public static int UpdateCode(C_Code code)
{
string sql = "update C_Code set CodeClass='{0}',CodeName='{1}',Memo='{2}',Mender='{3}',MendDate='{4}' where OID={5}";
sql = string.Format(sql, code.CodeClass, code.CodeName, code.Memo, code.Mender, code.MendDate, code.OID);
try
{
int num = DbHelperSQL.ExecuteSql(sql);
return(num);
}
catch
{
return(0);
}
}
public static int AddParameter(C_Code code)
{
string sql = "insert into C_Code(CodeClass,CodeName,Memo,Mender,MendDate) values('{0}','{1}','{2}','{3}','{4}')";
sql = string.Format(sql, code.CodeClass, code.CodeName, code.Memo, code.Mender, code.MendDate);
try
{
int num = DbHelperSQL.ExecuteSql(sql);
return(num);
}
catch
{
return(0);
}
}
protected void Login_Click(object sender, EventArgs e)
{
S_UserInFo userInFo = new S_UserInFo();
userInFo.UserID = Request.Params["UserName"];
userInFo.UserPWD = Request.Params["Password"];
UserBLL staffBLL = new UserBLL();
ParameterBLL parameterBLL = new ParameterBLL();
SqlDataReader read = staffBLL.StaffLogin(userInFo);
if (read.Read())
{
int DeptID = int.Parse(read["DeptID"].ToString());
C_Code code = parameterBLL.findCode(DeptID);
string UserID = read["UserID"].ToString();
int Power = int.Parse(read["Power"].ToString());
string CodeName = code.CodeName;
S_UserInFo user = new S_UserInFo();
user.UserID = UserID; //用户名称
user.DeptID = DeptID; //用户部门ID
user.Power = Power; //用户权限
user.Memo = CodeName; //此次用户所属部门名称用备注先存着
if (userInFo.bOFF == 1)
{
Response.Write("<script language='javascript'>alert('当前用户已被禁用" + userInFo.Memo + "')</script>");
return;
}
else
{
Session.Remove("User");
Session["UserID"] = UserID;
Session["User"] = user; //用户名称，所属部门ID
Response.Redirect("Index.aspx");
}
}
else
{
Response.Write("<script language='javascript'>alert('用户名或密码错误!');window.location.href=document.URL;</script>");
return;
}
}
public static C_Code findCode(int oID)
{
string sql1 = "select * from C_Code where OID='{0}'";
sql1 = string.Format(sql1, oID);
DataSet ds = DbHelperSQL.Query(sql1);
C_Code code = new C_Code();
code.OID = oID;
if (ds.Tables[0].Rows.Count > 0)
{
code.CodeClass = ds.Tables[0].Rows[0]["CodeClass"].ToString();
code.CodeName = ds.Tables[0].Rows[0]["CodeName"].ToString();
code.Memo = ds.Tables[0].Rows[0]["Memo"].ToString();
return(code);
}
else
{
return(null);
}
}
public int UpdateCode(C_Code code)
{
return(ParameterDAL.UpdateCode(code));
}
public int AddParameter(C_Code code)
{
return(ParameterDAL.AddParameter(code));
}
