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)); }