public ActionResult Create(string ID) { //laoshi List <SelectListItem> select1 = new List <SelectListItem>(); select1.Add(new SelectListItem { Text = "请选择", Value = "" }); List <DBA.Model.Department> list = dbll.GetModelList(""); for (int i = 0; i < list.Count; i++) { select1.Add(new SelectListItem { Text = list[i].DepartmentName, Value = list[i].DepartmentName }); } ; ViewData["DepName"] = new SelectList(select1, "Value", "Text", ""); if (string.IsNullOrEmpty(ID)) { DBA.Model.Users model = new DBA.Model.Users(); return(View(model)); } else { return(View(bll.GetModel(Convert.ToInt32(ID)))); } }
public ActionResult Edit(DBA.Model.CKRecord model) { if (model.ID == 0) { DBA.Model.Users usermodel = ubll.GetModelList(" LoginName='" + model.Str1 + "'").FirstOrDefault(); if (usermodel == null) { usermodel = new DBA.Model.Users(); usermodel.Age = model.Age; usermodel.LoginName = model.Str1; usermodel.Sex = model.Sex; usermodel.UserName = model.Name; ubll.Add(usermodel); } model.Time = DateTime.Now; DBA.Model.Goods Goods = bbll.GetModel(model.BookID); model.CreateUserName = DBA.BLL.Users.GetNowUserName(); Goods.GoodsKC = Goods.GoodsKC - Convert.ToInt32(model.Num); model.Str3 = Goods.Price; model.Str2 = (Convert.ToDouble(model.Num) * (Convert.ToDouble(Goods.Price) - Convert.ToDouble(Goods.GoodsKey))).ToString(); bbll.Update(Goods); } bll.Edit(model); return(RedirectToAction("CKRecordManage")); }
public bool UsersUpdate(DBA.Model.Users PoorModel, DBA.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" update RRecord set "); strSql.Append(" CreateUserName='******' "); strSql.Append(" where CreateUserName='******'"); SqlParameter[] parameters = { new SqlParameter("@CreateUserName", SqlDbType.NChar, 10) }; parameters[0].Value = model.UserName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public ActionResult Edit(DBA.Model.Users model, string ID) { DBA.Model.Users PoorUser = bll.GetModel(Convert.ToInt32(ID)); DBA.BLL.RRecord Rbll = new DBA.BLL.RRecord(); Rbll.UsersUpdate(PoorUser, model); bll.Edit(model); return(RedirectToAction("UsersManage")); }
public JsonResult SX(string ID) { DBA.Model.Apply model = bll.GetModel(Convert.ToInt32(ID)); model.Major = "失约"; bll.Update(model); DBA.Model.Users user = ubll.GetModel(Convert.ToInt32(model.Str1)); user.Str2 = (Convert.ToInt32(user.Str2) + 1).ToString(); ubll.Update(user); return(Json(true)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DBA.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("UserName,UserPSD,UserType,DepName,Age,Major,BYSJ,Sex,UserJG,UserSFZ,Str1,Str2,Str3,Str4,Str5)"); strSql.Append(" values ("); strSql.Append("@UserName,@UserPSD,@UserType,@DepName,@Age,@Major,@BYSJ,@Sex,@UserJG,@UserSFZ,@Str1,@Str2,@Str3,@Str4,@Str5)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 200), new SqlParameter("@UserPSD", SqlDbType.NVarChar, 200), new SqlParameter("@UserType", SqlDbType.NVarChar, 200), new SqlParameter("@DepName", SqlDbType.NVarChar, 200), new SqlParameter("@Age", SqlDbType.NVarChar, 200), new SqlParameter("@Major", SqlDbType.NVarChar, 200), new SqlParameter("@BYSJ", SqlDbType.NVarChar, 200), new SqlParameter("@Sex", SqlDbType.NVarChar, 200), new SqlParameter("@UserJG", SqlDbType.NVarChar, 200), new SqlParameter("@UserSFZ", SqlDbType.NVarChar, 200), new SqlParameter("@Str1", SqlDbType.NVarChar, 200), new SqlParameter("@Str2", SqlDbType.NVarChar, 200), new SqlParameter("@Str3", SqlDbType.NVarChar, 200), new SqlParameter("@Str4", SqlDbType.NVarChar, 200), new SqlParameter("@Str5", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.UserName; parameters[1].Value = model.UserPSD; parameters[2].Value = model.UserType; parameters[3].Value = model.DepName; parameters[4].Value = model.Age; parameters[5].Value = model.Major; parameters[6].Value = model.BYSJ; parameters[7].Value = model.Sex; parameters[8].Value = model.UserJG; parameters[9].Value = model.UserSFZ; parameters[10].Value = model.Str1; parameters[11].Value = model.Str2; parameters[12].Value = model.Str3; parameters[13].Value = model.Str4; parameters[14].Value = model.Str5; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public ActionResult UCreate(string ID) { if (string.IsNullOrEmpty(ID)) { DBA.Model.Users model = new DBA.Model.Users(); return(View(model)); } else { return(View(bll.GetModel(Convert.ToInt32(ID)))); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DBA.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("LoginName=@LoginName,"); strSql.Append("LoginPSD=@LoginPSD,"); strSql.Append("UserName=@UserName,"); strSql.Append("Sex=@Sex,"); strSql.Append("Age=@Age,"); strSql.Append("Usertype=@Usertype,"); strSql.Append("UserNum=@UserNum,"); strSql.Append("Str1=@Str1,"); strSql.Append("Str2=@Str2"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@LoginName", SqlDbType.NChar, 50), new SqlParameter("@LoginPSD", SqlDbType.NChar, 20), new SqlParameter("@UserName", SqlDbType.NChar, 50), new SqlParameter("@Sex", SqlDbType.NChar, 10), new SqlParameter("@Age", SqlDbType.NChar, 10), new SqlParameter("@Usertype", SqlDbType.NChar, 10), new SqlParameter("@UserNum", SqlDbType.NChar, 50), new SqlParameter("@Str1", SqlDbType.NChar, 10), new SqlParameter("@Str2", SqlDbType.NChar, 10), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.LoginName; parameters[1].Value = model.LoginPSD; parameters[2].Value = model.UserName; parameters[3].Value = model.Sex; parameters[4].Value = model.Age; parameters[5].Value = model.Usertype; parameters[6].Value = model.UserNum; parameters[7].Value = model.Str1; parameters[8].Value = model.Str2; parameters[9].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DBA.Model.Users DataRowToModel(DataRow row) { DBA.Model.Users model = new DBA.Model.Users(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["LoginName"] != null) { model.LoginName = row["LoginName"].ToString(); } if (row["LoginPSD"] != null) { model.LoginPSD = row["LoginPSD"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["Sex"] != null) { model.Sex = row["Sex"].ToString(); } if (row["Age"] != null) { model.Age = row["Age"].ToString(); } if (row["Usertype"] != null) { model.Usertype = row["Usertype"].ToString(); } if (row["UserNum"] != null) { model.UserNum = row["UserNum"].ToString(); } if (row["Str1"] != null) { model.Str1 = row["Str1"].ToString(); } if (row["Str2"] != null) { model.Str2 = row["Str2"].ToString(); } } return(model); }
public JsonResult EditMM(string Old, string Newpsd) { string UserID = DBA.BLL.Users.GetNowUserID(); DBA.Model.Users model = bll.GetModel(Convert.ToInt32(UserID)); if (Old != model.LoginPSD.Trim()) { return(Json(false)); } else { model.LoginPSD = Newpsd; bll.Update(model); } return(Json(true)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DBA.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("LoginName,LoginPSD,UserName,Sex,Age,Usertype,UserNum,Str1,Str2)"); strSql.Append(" values ("); strSql.Append("@LoginName,@LoginPSD,@UserName,@Sex,@Age,@Usertype,@UserNum,@Str1,@Str2)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@LoginName", SqlDbType.NChar, 50), new SqlParameter("@LoginPSD", SqlDbType.NChar, 20), new SqlParameter("@UserName", SqlDbType.NChar, 50), new SqlParameter("@Sex", SqlDbType.NChar, 10), new SqlParameter("@Age", SqlDbType.NChar, 10), new SqlParameter("@Usertype", SqlDbType.NChar, 10), new SqlParameter("@UserNum", SqlDbType.NChar, 50), new SqlParameter("@Str1", SqlDbType.NChar, 10), new SqlParameter("@Str2", SqlDbType.NChar, 10) }; parameters[0].Value = model.LoginName; parameters[1].Value = model.LoginPSD; parameters[2].Value = model.UserName; parameters[3].Value = model.Sex; parameters[4].Value = model.Age; parameters[5].Value = model.Usertype; parameters[6].Value = model.UserNum; parameters[7].Value = model.Str1; parameters[8].Value = model.Str2; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DBA.Model.Users GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,UserName,UserPSD,UserType,DepName,Age,Major,BYSJ,Sex,UserJG,UserSFZ,Str1,Str2,Str3,Str4,Str5 from Users "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; DBA.Model.Users model = new DBA.Model.Users(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public ActionResult UEdit(DBA.Model.Users model) { bll.Edit(model); return(Redirect("/Users/UsersManage?UserType=客户")); }
public ActionResult Edit(DBA.Model.Users model) { bll.Edit(model); return(RedirectToAction("UsersManage")); }
/// <summary> /// 得到一个对象实体 /// </summary> public DBA.Model.Users DataRowToModel(DataRow row) { DBA.Model.Users model = new DBA.Model.Users(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["UserPSD"] != null) { model.UserPSD = row["UserPSD"].ToString(); } if (row["UserType"] != null) { model.UserType = row["UserType"].ToString(); } if (row["DepName"] != null) { model.DepName = row["DepName"].ToString(); } if (row["Age"] != null) { model.Age = row["Age"].ToString(); } if (row["Major"] != null) { model.Major = row["Major"].ToString(); } if (row["BYSJ"] != null) { model.BYSJ = row["BYSJ"].ToString(); } if (row["Sex"] != null) { model.Sex = row["Sex"].ToString(); } if (row["UserJG"] != null) { model.UserJG = row["UserJG"].ToString(); } if (row["UserSFZ"] != null) { model.UserSFZ = row["UserSFZ"].ToString(); } if (row["Str1"] != null) { model.Str1 = row["Str1"].ToString(); } if (row["Str2"] != null) { model.Str2 = row["Str2"].ToString(); } if (row["Str3"] != null) { model.Str3 = row["Str3"].ToString(); } if (row["Str4"] != null) { model.Str4 = row["Str4"].ToString(); } if (row["Str5"] != null) { model.Str5 = row["Str5"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DBA.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("UserName=@UserName,"); strSql.Append("UserPSD=@UserPSD,"); strSql.Append("UserType=@UserType,"); strSql.Append("DepName=@DepName,"); strSql.Append("Age=@Age,"); strSql.Append("Major=@Major,"); strSql.Append("BYSJ=@BYSJ,"); strSql.Append("Sex=@Sex,"); strSql.Append("UserJG=@UserJG,"); strSql.Append("UserSFZ=@UserSFZ,"); strSql.Append("Str1=@Str1,"); strSql.Append("Str2=@Str2,"); strSql.Append("Str3=@Str3,"); strSql.Append("Str4=@Str4,"); strSql.Append("Str5=@Str5"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 200), new SqlParameter("@UserPSD", SqlDbType.NVarChar, 200), new SqlParameter("@UserType", SqlDbType.NVarChar, 200), new SqlParameter("@DepName", SqlDbType.NVarChar, 200), new SqlParameter("@Age", SqlDbType.NVarChar, 200), new SqlParameter("@Major", SqlDbType.NVarChar, 200), new SqlParameter("@BYSJ", SqlDbType.NVarChar, 200), new SqlParameter("@Sex", SqlDbType.NVarChar, 200), new SqlParameter("@UserJG", SqlDbType.NVarChar, 200), new SqlParameter("@UserSFZ", SqlDbType.NVarChar, 200), new SqlParameter("@Str1", SqlDbType.NVarChar, 200), new SqlParameter("@Str2", SqlDbType.NVarChar, 200), new SqlParameter("@Str3", SqlDbType.NVarChar, 200), new SqlParameter("@Str4", SqlDbType.NVarChar, 200), new SqlParameter("@Str5", SqlDbType.NVarChar, 200), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.UserName; parameters[1].Value = model.UserPSD; parameters[2].Value = model.UserType; parameters[3].Value = model.DepName; parameters[4].Value = model.Age; parameters[5].Value = model.Major; parameters[6].Value = model.BYSJ; parameters[7].Value = model.Sex; parameters[8].Value = model.UserJG; parameters[9].Value = model.UserSFZ; parameters[10].Value = model.Str1; parameters[11].Value = model.Str2; parameters[12].Value = model.Str3; parameters[13].Value = model.Str4; parameters[14].Value = model.Str5; parameters[15].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }