/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.SYS_USER GetModel(string USER_CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 USER_CODE,COMPANY_CODE,COMPANY_NAME,USER_NAME,STOCK_CODE,STOCK_NAME,DEPARTMENT_CODE,DEPARTMENT_NAME,department,PARENT_DEPARTMENT_CODE,PPRICE_SHOW,PASSWORD,Description,EmployeeCode,AllowUsed,isLicenceAudit,UserType,LastEdit,AuditDate from SYS_USER "); strSql.Append(" where USER_CODE=@USER_CODE "); SqlParameter[] parameters = { new SqlParameter("@USER_CODE", SqlDbType.NVarChar, 12) }; parameters[0].Value = USER_CODE; MyERP.Model.SYS_USER model = new MyERP.Model.SYS_USER(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void ShowInfo(string USER_CODE) { MyERP.BLL.SYS_USER bll = new MyERP.BLL.SYS_USER(); MyERP.Model.SYS_USER model = bll.GetModel(USER_CODE); this.lblUSER_CODE.Text = model.USER_CODE; this.lblCOMPANY_CODE.Text = model.COMPANY_CODE; this.lblCOMPANY_NAME.Text = model.COMPANY_NAME; this.lblUSER_NAME.Text = model.USER_NAME; this.lblSTOCK_CODE.Text = model.STOCK_CODE; this.lblSTOCK_NAME.Text = model.STOCK_NAME; this.lblDEPARTMENT_CODE.Text = model.DEPARTMENT_CODE; this.lblDEPARTMENT_NAME.Text = model.DEPARTMENT_NAME; this.lbldepartment.Text = model.department; this.lblPARENT_DEPARTMENT_CODE.Text = model.PARENT_DEPARTMENT_CODE; this.lblPPRICE_SHOW.Text = model.PPRICE_SHOW?"是":"否"; this.lblPASSWORD.Text = model.PASSWORD; this.lblDescription.Text = model.Description; this.lblEmployeeCode.Text = model.EmployeeCode; this.lblAllowUsed.Text = model.AllowUsed; this.lblisLicenceAudit.Text = model.isLicenceAudit; this.lblUserType.Text = model.UserType; this.lblLastEdit.Text = model.LastEdit.ToString(); this.lblAuditDate.Text = model.AuditDate.ToString(); }
private void ShowInfo(string USER_CODE) { MyERP.BLL.SYS_USER bll = new MyERP.BLL.SYS_USER(); MyERP.Model.SYS_USER model = bll.GetModel(USER_CODE); this.lblUSER_CODE.Text = model.USER_CODE; this.txtCOMPANY_CODE.Text = model.COMPANY_CODE; this.txtCOMPANY_NAME.Text = model.COMPANY_NAME; this.txtUSER_NAME.Text = model.USER_NAME; this.txtSTOCK_CODE.Text = model.STOCK_CODE; this.txtSTOCK_NAME.Text = model.STOCK_NAME; this.txtDEPARTMENT_CODE.Text = model.DEPARTMENT_CODE; this.txtDEPARTMENT_NAME.Text = model.DEPARTMENT_NAME; this.txtdepartment.Text = model.department; this.txtPARENT_DEPARTMENT_CODE.Text = model.PARENT_DEPARTMENT_CODE; this.chkPPRICE_SHOW.Checked = model.PPRICE_SHOW; this.txtPASSWORD.Text = model.PASSWORD; this.txtDescription.Text = model.Description; this.txtEmployeeCode.Text = model.EmployeeCode; this.txtAllowUsed.Text = model.AllowUsed; this.txtisLicenceAudit.Text = model.isLicenceAudit; this.txtUserType.Text = model.UserType; this.txtLastEdit.Text = model.LastEdit.ToString(); this.txtAuditDate.Text = model.AuditDate.ToString(); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MyERP.Model.SYS_USER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SYS_USER("); strSql.Append("USER_CODE,COMPANY_CODE,COMPANY_NAME,USER_NAME,STOCK_CODE,STOCK_NAME,DEPARTMENT_CODE,DEPARTMENT_NAME,department,PARENT_DEPARTMENT_CODE,PPRICE_SHOW,PASSWORD,Description,EmployeeCode,AllowUsed,isLicenceAudit,UserType,LastEdit,AuditDate)"); strSql.Append(" values ("); strSql.Append("@USER_CODE,@COMPANY_CODE,@COMPANY_NAME,@USER_NAME,@STOCK_CODE,@STOCK_NAME,@DEPARTMENT_CODE,@DEPARTMENT_NAME,@department,@PARENT_DEPARTMENT_CODE,@PPRICE_SHOW,@PASSWORD,@Description,@EmployeeCode,@AllowUsed,@isLicenceAudit,@UserType,@LastEdit,@AuditDate)"); SqlParameter[] parameters = { new SqlParameter("@USER_CODE", SqlDbType.NVarChar, 12), new SqlParameter("@COMPANY_CODE", SqlDbType.NVarChar, 50), new SqlParameter("@COMPANY_NAME", SqlDbType.NVarChar, 50), new SqlParameter("@USER_NAME", SqlDbType.NVarChar, 20), new SqlParameter("@STOCK_CODE", SqlDbType.NVarChar, 50), new SqlParameter("@STOCK_NAME", SqlDbType.NVarChar, 50), new SqlParameter("@DEPARTMENT_CODE", SqlDbType.NVarChar, 50), new SqlParameter("@DEPARTMENT_NAME", SqlDbType.NVarChar, 50), new SqlParameter("@department", SqlDbType.NVarChar, 50), new SqlParameter("@PARENT_DEPARTMENT_CODE", SqlDbType.NVarChar, 50), new SqlParameter("@PPRICE_SHOW", SqlDbType.Bit, 1), new SqlParameter("@PASSWORD", SqlDbType.NVarChar, 20), new SqlParameter("@Description", SqlDbType.NVarChar, 50), new SqlParameter("@EmployeeCode", SqlDbType.NVarChar, 12), new SqlParameter("@AllowUsed", SqlDbType.Text), new SqlParameter("@isLicenceAudit", SqlDbType.NVarChar, 1), new SqlParameter("@UserType", SqlDbType.NVarChar, 20), new SqlParameter("@LastEdit", SqlDbType.VarBinary, 8), new SqlParameter("@AuditDate", SqlDbType.DateTime) }; parameters[0].Value = model.USER_CODE; parameters[1].Value = model.COMPANY_CODE; parameters[2].Value = model.COMPANY_NAME; parameters[3].Value = model.USER_NAME; parameters[4].Value = model.STOCK_CODE; parameters[5].Value = model.STOCK_NAME; parameters[6].Value = model.DEPARTMENT_CODE; parameters[7].Value = model.DEPARTMENT_NAME; parameters[8].Value = model.department; parameters[9].Value = model.PARENT_DEPARTMENT_CODE; parameters[10].Value = model.PPRICE_SHOW; parameters[11].Value = model.PASSWORD; parameters[12].Value = model.Description; parameters[13].Value = model.EmployeeCode; parameters[14].Value = model.AllowUsed; parameters[15].Value = model.isLicenceAudit; parameters[16].Value = model.UserType; parameters[17].Value = model.LastEdit; parameters[18].Value = model.AuditDate; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.SYS_USER DataRowToModel(DataRow row) { MyERP.Model.SYS_USER model = new MyERP.Model.SYS_USER(); if (row != null) { if (row["USER_CODE"] != null) { model.USER_CODE = row["USER_CODE"].ToString(); } if (row["COMPANY_CODE"] != null) { model.COMPANY_CODE = row["COMPANY_CODE"].ToString(); } if (row["COMPANY_NAME"] != null) { model.COMPANY_NAME = row["COMPANY_NAME"].ToString(); } if (row["USER_NAME"] != null) { model.USER_NAME = row["USER_NAME"].ToString(); } if (row["STOCK_CODE"] != null) { model.STOCK_CODE = row["STOCK_CODE"].ToString(); } if (row["STOCK_NAME"] != null) { model.STOCK_NAME = row["STOCK_NAME"].ToString(); } if (row["DEPARTMENT_CODE"] != null) { model.DEPARTMENT_CODE = row["DEPARTMENT_CODE"].ToString(); } if (row["DEPARTMENT_NAME"] != null) { model.DEPARTMENT_NAME = row["DEPARTMENT_NAME"].ToString(); } if (row["department"] != null) { model.department = row["department"].ToString(); } if (row["PARENT_DEPARTMENT_CODE"] != null) { model.PARENT_DEPARTMENT_CODE = row["PARENT_DEPARTMENT_CODE"].ToString(); } if (row["PPRICE_SHOW"] != null && row["PPRICE_SHOW"].ToString() != "") { if ((row["PPRICE_SHOW"].ToString() == "1") || (row["PPRICE_SHOW"].ToString().ToLower() == "true")) { model.PPRICE_SHOW = true; } else { model.PPRICE_SHOW = false; } } if (row["PASSWORD"] != null) { model.PASSWORD = row["PASSWORD"].ToString(); } if (row["Description"] != null) { model.Description = row["Description"].ToString(); } if (row["EmployeeCode"] != null) { model.EmployeeCode = row["EmployeeCode"].ToString(); } if (row["AllowUsed"] != null) { model.AllowUsed = row["AllowUsed"].ToString(); } if (row["isLicenceAudit"] != null) { model.isLicenceAudit = row["isLicenceAudit"].ToString(); } if (row["UserType"] != null) { model.UserType = row["UserType"].ToString(); } if (row["LastEdit"] != null && row["LastEdit"].ToString() != "") { model.LastEdit = (byte[])row["LastEdit"]; } if (row["AuditDate"] != null && row["AuditDate"].ToString() != "") { model.AuditDate = DateTime.Parse(row["AuditDate"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MyERP.Model.SYS_USER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SYS_USER set "); strSql.Append("COMPANY_CODE=@COMPANY_CODE,"); strSql.Append("COMPANY_NAME=@COMPANY_NAME,"); strSql.Append("USER_NAME=@USER_NAME,"); strSql.Append("STOCK_CODE=@STOCK_CODE,"); strSql.Append("STOCK_NAME=@STOCK_NAME,"); strSql.Append("DEPARTMENT_CODE=@DEPARTMENT_CODE,"); strSql.Append("DEPARTMENT_NAME=@DEPARTMENT_NAME,"); strSql.Append("department=@department,"); strSql.Append("PARENT_DEPARTMENT_CODE=@PARENT_DEPARTMENT_CODE,"); strSql.Append("PPRICE_SHOW=@PPRICE_SHOW,"); strSql.Append("PASSWORD=@PASSWORD,"); strSql.Append("Description=@Description,"); strSql.Append("EmployeeCode=@EmployeeCode,"); strSql.Append("AllowUsed=@AllowUsed,"); strSql.Append("isLicenceAudit=@isLicenceAudit,"); strSql.Append("UserType=@UserType,"); strSql.Append("LastEdit=@LastEdit,"); strSql.Append("AuditDate=@AuditDate"); strSql.Append(" where USER_CODE=@USER_CODE "); SqlParameter[] parameters = { new SqlParameter("@COMPANY_CODE", SqlDbType.NVarChar, 50), new SqlParameter("@COMPANY_NAME", SqlDbType.NVarChar, 50), new SqlParameter("@USER_NAME", SqlDbType.NVarChar, 20), new SqlParameter("@STOCK_CODE", SqlDbType.NVarChar, 50), new SqlParameter("@STOCK_NAME", SqlDbType.NVarChar, 50), new SqlParameter("@DEPARTMENT_CODE", SqlDbType.NVarChar, 50), new SqlParameter("@DEPARTMENT_NAME", SqlDbType.NVarChar, 50), new SqlParameter("@department", SqlDbType.NVarChar, 50), new SqlParameter("@PARENT_DEPARTMENT_CODE", SqlDbType.NVarChar, 50), new SqlParameter("@PPRICE_SHOW", SqlDbType.Bit, 1), new SqlParameter("@PASSWORD", SqlDbType.NVarChar, 20), new SqlParameter("@Description", SqlDbType.NVarChar, 50), new SqlParameter("@EmployeeCode", SqlDbType.NVarChar, 12), new SqlParameter("@AllowUsed", SqlDbType.Text), new SqlParameter("@isLicenceAudit", SqlDbType.NVarChar, 1), new SqlParameter("@UserType", SqlDbType.NVarChar, 20), new SqlParameter("@LastEdit", SqlDbType.VarBinary, 8), new SqlParameter("@AuditDate", SqlDbType.DateTime), new SqlParameter("@USER_CODE", SqlDbType.NVarChar, 12) }; parameters[0].Value = model.COMPANY_CODE; parameters[1].Value = model.COMPANY_NAME; parameters[2].Value = model.USER_NAME; parameters[3].Value = model.STOCK_CODE; parameters[4].Value = model.STOCK_NAME; parameters[5].Value = model.DEPARTMENT_CODE; parameters[6].Value = model.DEPARTMENT_NAME; parameters[7].Value = model.department; parameters[8].Value = model.PARENT_DEPARTMENT_CODE; parameters[9].Value = model.PPRICE_SHOW; parameters[10].Value = model.PASSWORD; parameters[11].Value = model.Description; parameters[12].Value = model.EmployeeCode; parameters[13].Value = model.AllowUsed; parameters[14].Value = model.isLicenceAudit; parameters[15].Value = model.UserType; parameters[16].Value = model.LastEdit; parameters[17].Value = model.AuditDate; parameters[18].Value = model.USER_CODE; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtUSER_CODE.Text.Trim().Length == 0) { strErr += "USER_CODE不能为空!\\n"; } if (this.txtCOMPANY_CODE.Text.Trim().Length == 0) { strErr += "COMPANY_CODE不能为空!\\n"; } if (this.txtCOMPANY_NAME.Text.Trim().Length == 0) { strErr += "COMPANY_NAME不能为空!\\n"; } if (this.txtUSER_NAME.Text.Trim().Length == 0) { strErr += "USER_NAME不能为空!\\n"; } if (this.txtSTOCK_CODE.Text.Trim().Length == 0) { strErr += "STOCK_CODE不能为空!\\n"; } if (this.txtSTOCK_NAME.Text.Trim().Length == 0) { strErr += "STOCK_NAME不能为空!\\n"; } if (this.txtDEPARTMENT_CODE.Text.Trim().Length == 0) { strErr += "DEPARTMENT_CODE不能为空!\\n"; } if (this.txtDEPARTMENT_NAME.Text.Trim().Length == 0) { strErr += "DEPARTMENT_NAME不能为空!\\n"; } if (this.txtdepartment.Text.Trim().Length == 0) { strErr += "department不能为空!\\n"; } if (this.txtPARENT_DEPARTMENT_CODE.Text.Trim().Length == 0) { strErr += "PARENT_DEPARTMENT_CODE不能为空!\\n"; } if (this.txtPASSWORD.Text.Trim().Length == 0) { strErr += "PASSWORD不能为空!\\n"; } if (this.txtDescription.Text.Trim().Length == 0) { strErr += "Description不能为空!\\n"; } if (this.txtEmployeeCode.Text.Trim().Length == 0) { strErr += "EmployeeCode不能为空!\\n"; } if (this.txtAllowUsed.Text.Trim().Length == 0) { strErr += "AllowUsed不能为空!\\n"; } if (this.txtisLicenceAudit.Text.Trim().Length == 0) { strErr += "isLicenceAudit不能为空!\\n"; } if (this.txtUserType.Text.Trim().Length == 0) { strErr += "UserType不能为空!\\n"; } if (!PageValidate.IsDateTime(txtAuditDate.Text)) { strErr += "AuditDate格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string USER_CODE = this.txtUSER_CODE.Text; string COMPANY_CODE = this.txtCOMPANY_CODE.Text; string COMPANY_NAME = this.txtCOMPANY_NAME.Text; string USER_NAME = this.txtUSER_NAME.Text; string STOCK_CODE = this.txtSTOCK_CODE.Text; string STOCK_NAME = this.txtSTOCK_NAME.Text; string DEPARTMENT_CODE = this.txtDEPARTMENT_CODE.Text; string DEPARTMENT_NAME = this.txtDEPARTMENT_NAME.Text; string department = this.txtdepartment.Text; string PARENT_DEPARTMENT_CODE = this.txtPARENT_DEPARTMENT_CODE.Text; bool PPRICE_SHOW = this.chkPPRICE_SHOW.Checked; string PASSWORD = this.txtPASSWORD.Text; string Description = this.txtDescription.Text; string EmployeeCode = this.txtEmployeeCode.Text; string AllowUsed = this.txtAllowUsed.Text; string isLicenceAudit = this.txtisLicenceAudit.Text; string UserType = this.txtUserType.Text; byte[] LastEdit = new UnicodeEncoding().GetBytes(this.txtLastEdit.Text); DateTime AuditDate = DateTime.Parse(this.txtAuditDate.Text); MyERP.Model.SYS_USER model = new MyERP.Model.SYS_USER(); model.USER_CODE = USER_CODE; model.COMPANY_CODE = COMPANY_CODE; model.COMPANY_NAME = COMPANY_NAME; model.USER_NAME = USER_NAME; model.STOCK_CODE = STOCK_CODE; model.STOCK_NAME = STOCK_NAME; model.DEPARTMENT_CODE = DEPARTMENT_CODE; model.DEPARTMENT_NAME = DEPARTMENT_NAME; model.department = department; model.PARENT_DEPARTMENT_CODE = PARENT_DEPARTMENT_CODE; model.PPRICE_SHOW = PPRICE_SHOW; model.PASSWORD = PASSWORD; model.Description = Description; model.EmployeeCode = EmployeeCode; model.AllowUsed = AllowUsed; model.isLicenceAudit = isLicenceAudit; model.UserType = UserType; model.LastEdit = LastEdit; model.AuditDate = AuditDate; MyERP.BLL.SYS_USER bll = new MyERP.BLL.SYS_USER(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }