webservice关闭连接
winform连接webservice,第一次调试成功了,可第二次登陆就出现了错误,显示的是,服务器无法处理请求。 ---> 连接未关闭。 连接的当前状态为打开。
/// <summary>
/// 用户登录
/// </summary>
/// <param name="UserName">用户名</param>
/// <param name="PassWord">密码</param>
/// <returns></returns>
public string UserLogin(string UserName, string PassWord)
{
try
{
DataBase.con.Open();//打开数据库连接
//根据用户名和密码查询该用户是否存在
OracleCommand cmd = new OracleCommand("select count(*) from T_USER where USER_NAME='" + UserName + "'and USER_PASSWORD='" + PassWord + "'", DataBase.con);
int num = Convert.ToInt32(cmd.ExecuteScalar());
if (num > 0)//如果存在该用户
{
//根据用户名和密码查询用户相关信息
OracleCommand comd = new OracleCommand("select distinct EMP_ID,TEAM_ID,EMP_NAME FROM T_EMPLOYEE WHERE EMP_ID=(select USER_ID from T_USER where T_USER.USER_NAME='" + UserName + "'and T_USER.USER_PASSWORD='" + PassWord + "')", DataBase.con);
OracleDataReader dr = comd.ExecuteReader();
if (dr.Read())
{
EUname = UserName;
EPWD = PassWord;
EID = Convert.ToInt32(dr["EMP_ID"]);
TID = Convert.ToInt32(dr["TEAM_ID"]);
EName = dr["EMP_NAME"].ToString();
}
DataBase.con.Close();
DataBase.con.Dispose();
return EUname + "@@" + EPWD + "@@" + EID + "@@" + TID + "@@" + EName;
}
else
{
DataBase.con.Close();
return "该用户不存在!";
}
}
catch (Exception ex)
{
throw ex;
}
}