public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtUName.Text.Trim().Length == 0) { strErr += "UName不能为空!\\n"; } if (this.txtUPwd.Text.Trim().Length == 0) { strErr += "UPwd不能为空!\\n"; } if (this.txtUGender.Text.Trim().Length == 0) { strErr += "UGender不能为空!\\n"; } if (this.txtULevel.Text.Trim().Length == 0) { strErr += "ULevel不能为空!\\n"; } if (this.txtUPhone.Text.Trim().Length == 0) { strErr += "UPhone不能为空!\\n"; } if (this.txtUEmail.Text.Trim().Length == 0) { strErr += "UEmail不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int UID = int.Parse(this.lblUID.Text); string UName = this.txtUName.Text; string UPwd = this.txtUPwd.Text; string UGender = this.txtUGender.Text; string ULevel = this.txtULevel.Text; string UPhone = this.txtUPhone.Text; string UEmail = this.txtUEmail.Text; ERP.Model.Users model = new ERP.Model.Users(); model.UID = UID; model.UName = UName; model.UPwd = UPwd; model.UGender = UGender; model.ULevel = ULevel; model.UPhone = UPhone; model.UEmail = UEmail; ERP.BLL.Users bll = new ERP.BLL.Users(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
private void ShowInfo(int UID) { ERP.BLL.Users bll = new ERP.BLL.Users(); ERP.Model.Users model = bll.GetModel(UID); this.lblUID.Text = model.UID.ToString(); this.lblUName.Text = model.UName; this.lblUPwd.Text = model.UPwd; this.lblUGender.Text = model.UGender; this.lblULevel.Text = model.ULevel; this.lblUPhone.Text = model.UPhone; this.lblUEmail.Text = model.UEmail; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ERP.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("UName=@UName,"); strSql.Append("UPwd=@UPwd,"); strSql.Append("UGender=@UGender,"); strSql.Append("ULevel=@ULevel,"); strSql.Append("UPhone=@UPhone,"); strSql.Append("UEmail=@UEmail"); strSql.Append(" where UID=@UID"); SqlParameter[] parameters = { new SqlParameter("@UName", SqlDbType.NVarChar, 50), new SqlParameter("@UPwd", SqlDbType.NVarChar, 50), new SqlParameter("@UGender", SqlDbType.Char, 2), new SqlParameter("@ULevel", SqlDbType.NVarChar, 50), new SqlParameter("@UPhone", SqlDbType.NVarChar, 50), new SqlParameter("@UEmail", SqlDbType.NVarChar, 50), new SqlParameter("@UID", SqlDbType.Int, 4) }; parameters[0].Value = model.UName; parameters[1].Value = model.UPwd; parameters[2].Value = model.UGender; parameters[3].Value = model.ULevel; parameters[4].Value = model.UPhone; parameters[5].Value = model.UEmail; parameters[6].Value = model.UID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ERP.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("UName,UPwd,UGender,ULevel,UPhone,UEmail)"); strSql.Append(" values ("); strSql.Append("@UName,@UPwd,@UGender,@ULevel,@UPhone,@UEmail)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UName", SqlDbType.NVarChar, 50), new SqlParameter("@UPwd", SqlDbType.NVarChar, 50), new SqlParameter("@UGender", SqlDbType.Char, 2), new SqlParameter("@ULevel", SqlDbType.NVarChar, 50), new SqlParameter("@UPhone", SqlDbType.NVarChar, 50), new SqlParameter("@UEmail", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.UName; parameters[1].Value = model.UPwd; parameters[2].Value = model.UGender; parameters[3].Value = model.ULevel; parameters[4].Value = model.UPhone; parameters[5].Value = model.UEmail; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ERP.Model.Users DataRowToModel(DataRow row) { ERP.Model.Users model = new ERP.Model.Users(); if (row != null) { if (row["UID"] != null && row["UID"].ToString() != "") { model.UID = int.Parse(row["UID"].ToString()); } if (row["UName"] != null) { model.UName = row["UName"].ToString(); } if (row["UPwd"] != null) { model.UPwd = row["UPwd"].ToString(); } if (row["UGender"] != null) { model.UGender = row["UGender"].ToString(); } if (row["ULevel"] != null) { model.ULevel = row["ULevel"].ToString(); } if (row["UPhone"] != null) { model.UPhone = row["UPhone"].ToString(); } if (row["UEmail"] != null) { model.UEmail = row["UEmail"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ERP.Model.Users GetModel(int UID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UID,UName,UPwd,UGender,ULevel,UPhone,UEmail from Users "); strSql.Append(" where UID=@UID"); SqlParameter[] parameters = { new SqlParameter("@UID", SqlDbType.Int, 4) }; parameters[0].Value = UID; ERP.Model.Users model = new ERP.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); } }