/// <summary> /// 增加一条数据 /// </summary> public bool Add(MyERP.Model.SYS_USER_GROUP model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SYS_USER_GROUP("); strSql.Append("CompanyCode,UserGroupNo,UserGroupName,Description,AllowUsed)"); strSql.Append(" values ("); strSql.Append("@CompanyCode,@UserGroupNo,@UserGroupName,@Description,@AllowUsed)"); SqlParameter[] parameters = { new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 10), new SqlParameter("@UserGroupNo", SqlDbType.NVarChar, 12), new SqlParameter("@UserGroupName", SqlDbType.NVarChar, 20), new SqlParameter("@Description", SqlDbType.NVarChar, 50), new SqlParameter("@AllowUsed", SqlDbType.NVarChar, 1) }; parameters[0].Value = model.CompanyCode; parameters[1].Value = model.UserGroupNo; parameters[2].Value = model.UserGroupName; parameters[3].Value = model.Description; parameters[4].Value = model.AllowUsed; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.SYS_USER_GROUP DataRowToModel(DataRow row) { MyERP.Model.SYS_USER_GROUP model = new MyERP.Model.SYS_USER_GROUP(); if (row != null) { if (row["CompanyCode"] != null) { model.CompanyCode = row["CompanyCode"].ToString(); } if (row["UserGroupNo"] != null) { model.UserGroupNo = row["UserGroupNo"].ToString(); } if (row["UserGroupName"] != null) { model.UserGroupName = row["UserGroupName"].ToString(); } if (row["Description"] != null) { model.Description = row["Description"].ToString(); } if (row["AllowUsed"] != null) { model.AllowUsed = row["AllowUsed"].ToString(); } } return(model); }
private void ShowInfo() { MyERP.BLL.SYS_USER_GROUP bll = new MyERP.BLL.SYS_USER_GROUP(); MyERP.Model.SYS_USER_GROUP model = bll.GetModel(); this.txtCompanyCode.Text = model.CompanyCode; this.txtUserGroupNo.Text = model.UserGroupNo; this.txtUserGroupName.Text = model.UserGroupName; this.txtDescription.Text = model.Description; this.txtAllowUsed.Text = model.AllowUsed; }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtCompanyCode.Text.Trim().Length == 0) { strErr += "CompanyCode不能为空!\\n"; } if (this.txtUserGroupNo.Text.Trim().Length == 0) { strErr += "UserGroupNo不能为空!\\n"; } if (this.txtUserGroupName.Text.Trim().Length == 0) { strErr += "UserGroupName不能为空!\\n"; } if (this.txtDescription.Text.Trim().Length == 0) { strErr += "Description不能为空!\\n"; } if (this.txtAllowUsed.Text.Trim().Length == 0) { strErr += "AllowUsed不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string CompanyCode = this.txtCompanyCode.Text; string UserGroupNo = this.txtUserGroupNo.Text; string UserGroupName = this.txtUserGroupName.Text; string Description = this.txtDescription.Text; string AllowUsed = this.txtAllowUsed.Text; MyERP.Model.SYS_USER_GROUP model = new MyERP.Model.SYS_USER_GROUP(); model.CompanyCode = CompanyCode; model.UserGroupNo = UserGroupNo; model.UserGroupName = UserGroupName; model.Description = Description; model.AllowUsed = AllowUsed; MyERP.BLL.SYS_USER_GROUP bll = new MyERP.BLL.SYS_USER_GROUP(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.SYS_USER_GROUP GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 CompanyCode,UserGroupNo,UserGroupName,Description,AllowUsed from SYS_USER_GROUP "); strSql.Append(" where "); SqlParameter[] parameters = { }; MyERP.Model.SYS_USER_GROUP model = new MyERP.Model.SYS_USER_GROUP(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MyERP.Model.SYS_USER_GROUP model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SYS_USER_GROUP set "); strSql.Append("CompanyCode=@CompanyCode,"); strSql.Append("UserGroupNo=@UserGroupNo,"); strSql.Append("UserGroupName=@UserGroupName,"); strSql.Append("Description=@Description,"); strSql.Append("AllowUsed=@AllowUsed"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 10), new SqlParameter("@UserGroupNo", SqlDbType.NVarChar, 12), new SqlParameter("@UserGroupName", SqlDbType.NVarChar, 20), new SqlParameter("@Description", SqlDbType.NVarChar, 50), new SqlParameter("@AllowUsed", SqlDbType.NVarChar, 1) }; parameters[0].Value = model.CompanyCode; parameters[1].Value = model.UserGroupNo; parameters[2].Value = model.UserGroupName; parameters[3].Value = model.Description; parameters[4].Value = model.AllowUsed; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }