private void ShowInfo(string UID) { Cao.WMS.BLL.caowms.Users bll = new Cao.WMS.BLL.caowms.Users(); Cao.WMS.Model.caowms.Users model = bll.GetModel(UID); this.lblUID.Text = model.UID; this.txtUPassword.Text = model.UPassword; this.txtUPower.Text = model.UPower; this.txtUSex.Text = model.USex; this.txtUName.Text = model.UName; this.txtUAddress.Text = model.UAddress; this.txtUTel.Text = model.UTel; this.txtUEmail.Text = model.UEmail; this.txtUDep.Text = model.UDep; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Cao.WMS.Model.caowms.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("UPassword=@UPassword,"); strSql.Append("UPower=@UPower,"); strSql.Append("USex=@USex,"); strSql.Append("UName=@UName,"); strSql.Append("UAddress=@UAddress,"); strSql.Append("UTel=@UTel,"); strSql.Append("UEmail=@UEmail,"); strSql.Append("UDep=@UDep"); strSql.Append(" where UID=@UID "); SqlParameter[] parameters = { new SqlParameter("@UPassword", SqlDbType.NVarChar, 50), new SqlParameter("@UPower", SqlDbType.NVarChar, 50), new SqlParameter("@USex", SqlDbType.Char, 2), new SqlParameter("@UName", SqlDbType.NVarChar, 50), new SqlParameter("@UAddress", SqlDbType.NVarChar, 50), new SqlParameter("@UTel", SqlDbType.NVarChar, 50), new SqlParameter("@UEmail", SqlDbType.NVarChar, 50), new SqlParameter("@UDep", SqlDbType.NVarChar, 50), new SqlParameter("@UID", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.UPassword; parameters[1].Value = model.UPower; parameters[2].Value = model.USex; parameters[3].Value = model.UName; parameters[4].Value = model.UAddress; parameters[5].Value = model.UTel; parameters[6].Value = model.UEmail; parameters[7].Value = model.UDep; parameters[8].Value = model.UID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cao.WMS.Model.caowms.Users DataRowToModel(DataRow row) { Cao.WMS.Model.caowms.Users model = new Cao.WMS.Model.caowms.Users(); if (row != null) { if (row["UID"] != null) { model.UID = row["UID"].ToString(); } if (row["UPassword"] != null) { model.UPassword = row["UPassword"].ToString(); } if (row["UPower"] != null) { model.UPower = row["UPower"].ToString(); } if (row["USex"] != null) { model.USex = row["USex"].ToString(); } if (row["UName"] != null) { model.UName = row["UName"].ToString(); } if (row["UAddress"] != null) { model.UAddress = row["UAddress"].ToString(); } if (row["UTel"] != null) { model.UTel = row["UTel"].ToString(); } if (row["UEmail"] != null) { model.UEmail = row["UEmail"].ToString(); } if (row["UDep"] != null) { model.UDep = row["UDep"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Cao.WMS.Model.caowms.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("UID,UPassword,UPower,USex,UName,UAddress,UTel,UEmail,UDep)"); strSql.Append(" values ("); strSql.Append("@UID,@UPassword,@UPower,@USex,@UName,@UAddress,@UTel,@UEmail,@UDep)"); SqlParameter[] parameters = { new SqlParameter("@UID", SqlDbType.NVarChar, 50), new SqlParameter("@UPassword", SqlDbType.NVarChar, 50), new SqlParameter("@UPower", SqlDbType.NVarChar, 50), new SqlParameter("@USex", SqlDbType.Char, 2), new SqlParameter("@UName", SqlDbType.NVarChar, 50), new SqlParameter("@UAddress", SqlDbType.NVarChar, 50), new SqlParameter("@UTel", SqlDbType.NVarChar, 50), new SqlParameter("@UEmail", SqlDbType.NVarChar, 50), new SqlParameter("@UDep", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.UID; parameters[1].Value = model.UPassword; parameters[2].Value = model.UPower; parameters[3].Value = model.USex; parameters[4].Value = model.UName; parameters[5].Value = model.UAddress; parameters[6].Value = model.UTel; parameters[7].Value = model.UEmail; parameters[8].Value = model.UDep; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cao.WMS.Model.caowms.Users GetModel(string UID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UID,UPassword,UPower,USex,UName,UAddress,UTel,UEmail,UDep from Users "); strSql.Append(" where UID=@UID "); SqlParameter[] parameters = { new SqlParameter("@UID", SqlDbType.NVarChar, 50) }; parameters[0].Value = UID; Cao.WMS.Model.caowms.Users model = new Cao.WMS.Model.caowms.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 void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtUPassword.Text.Trim().Length == 0) { strErr += "UPassword不能为空!\\n"; } if (this.txtUPower.Text.Trim().Length == 0) { strErr += "UPower不能为空!\\n"; } if (this.txtUSex.Text.Trim().Length == 0) { strErr += "USex不能为空!\\n"; } if (this.txtUName.Text.Trim().Length == 0) { strErr += "UName不能为空!\\n"; } if (this.txtUAddress.Text.Trim().Length == 0) { strErr += "UAddress不能为空!\\n"; } if (this.txtUTel.Text.Trim().Length == 0) { strErr += "UTel不能为空!\\n"; } if (this.txtUEmail.Text.Trim().Length == 0) { strErr += "UEmail不能为空!\\n"; } if (this.txtUDep.Text.Trim().Length == 0) { strErr += "UDep不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string UID = this.lblUID.Text; string UPassword = this.txtUPassword.Text; string UPower = this.txtUPower.Text; string USex = this.txtUSex.Text; string UName = this.txtUName.Text; string UAddress = this.txtUAddress.Text; string UTel = this.txtUTel.Text; string UEmail = this.txtUEmail.Text; string UDep = this.txtUDep.Text; Cao.WMS.Model.caowms.Users model = new Cao.WMS.Model.caowms.Users(); model.UID = UID; model.UPassword = UPassword; model.UPower = UPower; model.USex = USex; model.UName = UName; model.UAddress = UAddress; model.UTel = UTel; model.UEmail = UEmail; model.UDep = UDep; Cao.WMS.BLL.caowms.Users bll = new Cao.WMS.BLL.caowms.Users(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }