/// <summary> /// 增加一条数据 /// </summary> public bool Add(MyERP.Model.PUB_COMPANY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PUB_COMPANY("); strSql.Append("COMPANY_CODE,COMPANY_NAME,COMPANY_FULLNAME,PARENT_COMPANY_CODE,MANAGER,ADDRESS,TELPHONE,ZIP,EMAIL,HTTP,LICENSE,REGISTER_BANK,BANK_ACCOUNT,ALLOW_USED,REMARK)"); strSql.Append(" values ("); strSql.Append("@COMPANY_CODE,@COMPANY_NAME,@COMPANY_FULLNAME,@PARENT_COMPANY_CODE,@MANAGER,@ADDRESS,@TELPHONE,@ZIP,@EMAIL,@HTTP,@LICENSE,@REGISTER_BANK,@BANK_ACCOUNT,@ALLOW_USED,@REMARK)"); SqlParameter[] parameters = { new SqlParameter("@COMPANY_CODE", SqlDbType.NVarChar, 10), new SqlParameter("@COMPANY_NAME", SqlDbType.NVarChar, 60), new SqlParameter("@COMPANY_FULLNAME", SqlDbType.NChar, 200), new SqlParameter("@PARENT_COMPANY_CODE", SqlDbType.NVarChar, 10), new SqlParameter("@MANAGER", SqlDbType.NVarChar, 20), new SqlParameter("@ADDRESS", SqlDbType.NVarChar, 200), new SqlParameter("@TELPHONE", SqlDbType.NVarChar, 20), new SqlParameter("@ZIP", SqlDbType.NVarChar, 6), new SqlParameter("@EMAIL", SqlDbType.NVarChar, 20), new SqlParameter("@HTTP", SqlDbType.NVarChar, 20), new SqlParameter("@LICENSE", SqlDbType.NVarChar, 50), new SqlParameter("@REGISTER_BANK", SqlDbType.NVarChar, 60), new SqlParameter("@BANK_ACCOUNT", SqlDbType.NVarChar, 30), new SqlParameter("@ALLOW_USED", SqlDbType.NVarChar, 1), new SqlParameter("@REMARK", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.COMPANY_CODE; parameters[1].Value = model.COMPANY_NAME; parameters[2].Value = model.COMPANY_FULLNAME; parameters[3].Value = model.PARENT_COMPANY_CODE; parameters[4].Value = model.MANAGER; parameters[5].Value = model.ADDRESS; parameters[6].Value = model.TELPHONE; parameters[7].Value = model.ZIP; parameters[8].Value = model.EMAIL; parameters[9].Value = model.HTTP; parameters[10].Value = model.LICENSE; parameters[11].Value = model.REGISTER_BANK; parameters[12].Value = model.BANK_ACCOUNT; parameters[13].Value = model.ALLOW_USED; parameters[14].Value = model.REMARK; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo() { MyERP.BLL.PUB_COMPANY bll = new MyERP.BLL.PUB_COMPANY(); MyERP.Model.PUB_COMPANY model = bll.GetModel(); this.lblCOMPANY_CODE.Text = model.COMPANY_CODE; this.lblCOMPANY_NAME.Text = model.COMPANY_NAME; this.lblCOMPANY_FULLNAME.Text = model.COMPANY_FULLNAME; this.lblPARENT_COMPANY_CODE.Text = model.PARENT_COMPANY_CODE; this.lblMANAGER.Text = model.MANAGER; this.lblADDRESS.Text = model.ADDRESS; this.lblTELPHONE.Text = model.TELPHONE; this.lblZIP.Text = model.ZIP; this.lblEMAIL.Text = model.EMAIL; this.lblHTTP.Text = model.HTTP; this.lblLICENSE.Text = model.LICENSE; this.lblREGISTER_BANK.Text = model.REGISTER_BANK; this.lblBANK_ACCOUNT.Text = model.BANK_ACCOUNT; this.lblALLOW_USED.Text = model.ALLOW_USED; this.lblREMARK.Text = model.REMARK; }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.PUB_COMPANY GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 COMPANY_CODE,COMPANY_NAME,COMPANY_FULLNAME,PARENT_COMPANY_CODE,MANAGER,ADDRESS,TELPHONE,ZIP,EMAIL,HTTP,LICENSE,REGISTER_BANK,BANK_ACCOUNT,ALLOW_USED,REMARK from PUB_COMPANY "); strSql.Append(" where "); SqlParameter[] parameters = { }; MyERP.Model.PUB_COMPANY model = new MyERP.Model.PUB_COMPANY(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; 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.txtCOMPANY_FULLNAME.Text.Trim().Length == 0) { strErr += "COMPANY_FULLNAME不能为空!\\n"; } if (this.txtPARENT_COMPANY_CODE.Text.Trim().Length == 0) { strErr += "PARENT_COMPANY_CODE不能为空!\\n"; } if (this.txtMANAGER.Text.Trim().Length == 0) { strErr += "MANAGER不能为空!\\n"; } if (this.txtADDRESS.Text.Trim().Length == 0) { strErr += "ADDRESS不能为空!\\n"; } if (this.txtTELPHONE.Text.Trim().Length == 0) { strErr += "TELPHONE不能为空!\\n"; } if (this.txtZIP.Text.Trim().Length == 0) { strErr += "ZIP不能为空!\\n"; } if (this.txtEMAIL.Text.Trim().Length == 0) { strErr += "EMAIL不能为空!\\n"; } if (this.txtHTTP.Text.Trim().Length == 0) { strErr += "HTTP不能为空!\\n"; } if (this.txtLICENSE.Text.Trim().Length == 0) { strErr += "LICENSE不能为空!\\n"; } if (this.txtREGISTER_BANK.Text.Trim().Length == 0) { strErr += "REGISTER_BANK不能为空!\\n"; } if (this.txtBANK_ACCOUNT.Text.Trim().Length == 0) { strErr += "BANK_ACCOUNT不能为空!\\n"; } if (this.txtALLOW_USED.Text.Trim().Length == 0) { strErr += "ALLOW_USED不能为空!\\n"; } if (this.txtREMARK.Text.Trim().Length == 0) { strErr += "REMARK不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string COMPANY_CODE = this.txtCOMPANY_CODE.Text; string COMPANY_NAME = this.txtCOMPANY_NAME.Text; string COMPANY_FULLNAME = this.txtCOMPANY_FULLNAME.Text; string PARENT_COMPANY_CODE = this.txtPARENT_COMPANY_CODE.Text; string MANAGER = this.txtMANAGER.Text; string ADDRESS = this.txtADDRESS.Text; string TELPHONE = this.txtTELPHONE.Text; string ZIP = this.txtZIP.Text; string EMAIL = this.txtEMAIL.Text; string HTTP = this.txtHTTP.Text; string LICENSE = this.txtLICENSE.Text; string REGISTER_BANK = this.txtREGISTER_BANK.Text; string BANK_ACCOUNT = this.txtBANK_ACCOUNT.Text; string ALLOW_USED = this.txtALLOW_USED.Text; string REMARK = this.txtREMARK.Text; MyERP.Model.PUB_COMPANY model = new MyERP.Model.PUB_COMPANY(); model.COMPANY_CODE = COMPANY_CODE; model.COMPANY_NAME = COMPANY_NAME; model.COMPANY_FULLNAME = COMPANY_FULLNAME; model.PARENT_COMPANY_CODE = PARENT_COMPANY_CODE; model.MANAGER = MANAGER; model.ADDRESS = ADDRESS; model.TELPHONE = TELPHONE; model.ZIP = ZIP; model.EMAIL = EMAIL; model.HTTP = HTTP; model.LICENSE = LICENSE; model.REGISTER_BANK = REGISTER_BANK; model.BANK_ACCOUNT = BANK_ACCOUNT; model.ALLOW_USED = ALLOW_USED; model.REMARK = REMARK; MyERP.BLL.PUB_COMPANY bll = new MyERP.BLL.PUB_COMPANY(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MyERP.Model.PUB_COMPANY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PUB_COMPANY set "); strSql.Append("COMPANY_CODE=@COMPANY_CODE,"); strSql.Append("COMPANY_NAME=@COMPANY_NAME,"); strSql.Append("COMPANY_FULLNAME=@COMPANY_FULLNAME,"); strSql.Append("PARENT_COMPANY_CODE=@PARENT_COMPANY_CODE,"); strSql.Append("MANAGER=@MANAGER,"); strSql.Append("ADDRESS=@ADDRESS,"); strSql.Append("TELPHONE=@TELPHONE,"); strSql.Append("ZIP=@ZIP,"); strSql.Append("EMAIL=@EMAIL,"); strSql.Append("HTTP=@HTTP,"); strSql.Append("LICENSE=@LICENSE,"); strSql.Append("REGISTER_BANK=@REGISTER_BANK,"); strSql.Append("BANK_ACCOUNT=@BANK_ACCOUNT,"); strSql.Append("ALLOW_USED=@ALLOW_USED,"); strSql.Append("REMARK=@REMARK"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@COMPANY_CODE", SqlDbType.NVarChar, 10), new SqlParameter("@COMPANY_NAME", SqlDbType.NVarChar, 60), new SqlParameter("@COMPANY_FULLNAME", SqlDbType.NChar, 200), new SqlParameter("@PARENT_COMPANY_CODE", SqlDbType.NVarChar, 10), new SqlParameter("@MANAGER", SqlDbType.NVarChar, 20), new SqlParameter("@ADDRESS", SqlDbType.NVarChar, 200), new SqlParameter("@TELPHONE", SqlDbType.NVarChar, 20), new SqlParameter("@ZIP", SqlDbType.NVarChar, 6), new SqlParameter("@EMAIL", SqlDbType.NVarChar, 20), new SqlParameter("@HTTP", SqlDbType.NVarChar, 20), new SqlParameter("@LICENSE", SqlDbType.NVarChar, 50), new SqlParameter("@REGISTER_BANK", SqlDbType.NVarChar, 60), new SqlParameter("@BANK_ACCOUNT", SqlDbType.NVarChar, 30), new SqlParameter("@ALLOW_USED", SqlDbType.NVarChar, 1), new SqlParameter("@REMARK", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.COMPANY_CODE; parameters[1].Value = model.COMPANY_NAME; parameters[2].Value = model.COMPANY_FULLNAME; parameters[3].Value = model.PARENT_COMPANY_CODE; parameters[4].Value = model.MANAGER; parameters[5].Value = model.ADDRESS; parameters[6].Value = model.TELPHONE; parameters[7].Value = model.ZIP; parameters[8].Value = model.EMAIL; parameters[9].Value = model.HTTP; parameters[10].Value = model.LICENSE; parameters[11].Value = model.REGISTER_BANK; parameters[12].Value = model.BANK_ACCOUNT; parameters[13].Value = model.ALLOW_USED; parameters[14].Value = model.REMARK; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.PUB_COMPANY DataRowToModel(DataRow row) { MyERP.Model.PUB_COMPANY model = new MyERP.Model.PUB_COMPANY(); if (row != null) { 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["COMPANY_FULLNAME"] != null) { model.COMPANY_FULLNAME = row["COMPANY_FULLNAME"].ToString(); } if (row["PARENT_COMPANY_CODE"] != null) { model.PARENT_COMPANY_CODE = row["PARENT_COMPANY_CODE"].ToString(); } if (row["MANAGER"] != null) { model.MANAGER = row["MANAGER"].ToString(); } if (row["ADDRESS"] != null) { model.ADDRESS = row["ADDRESS"].ToString(); } if (row["TELPHONE"] != null) { model.TELPHONE = row["TELPHONE"].ToString(); } if (row["ZIP"] != null) { model.ZIP = row["ZIP"].ToString(); } if (row["EMAIL"] != null) { model.EMAIL = row["EMAIL"].ToString(); } if (row["HTTP"] != null) { model.HTTP = row["HTTP"].ToString(); } if (row["LICENSE"] != null) { model.LICENSE = row["LICENSE"].ToString(); } if (row["REGISTER_BANK"] != null) { model.REGISTER_BANK = row["REGISTER_BANK"].ToString(); } if (row["BANK_ACCOUNT"] != null) { model.BANK_ACCOUNT = row["BANK_ACCOUNT"].ToString(); } if (row["ALLOW_USED"] != null) { model.ALLOW_USED = row["ALLOW_USED"].ToString(); } if (row["REMARK"] != null) { model.REMARK = row["REMARK"].ToString(); } } return(model); }