protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtCUSTOM_CODE.Text.Trim().Length == 0) { strErr += "CUSTOM_CODE不能为空!\\n"; } if (this.txtCUSTOM_NAME.Text.Trim().Length == 0) { strErr += "CUSTOM_NAME不能为空!\\n"; } if (this.txtZBBH.Text.Trim().Length == 0) { strErr += "ZBBH不能为空!\\n"; } if (this.txtPZMC.Text.Trim().Length == 0) { strErr += "PZMC不能为空!\\n"; } if (!PageValidate.IsDecimal(txtPRICE.Text)) { strErr += "PRICE格式错误!\\n"; } if (this.txtCREATE_NAME.Text.Trim().Length == 0) { strErr += "CREATE_NAME不能为空!\\n"; } if (!PageValidate.IsDateTime(txtCREATE_DATE.Text)) { strErr += "CREATE_DATE格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string CUSTOM_CODE = this.txtCUSTOM_CODE.Text; string CUSTOM_NAME = this.txtCUSTOM_NAME.Text; string ZBBH = this.txtZBBH.Text; string PZMC = this.txtPZMC.Text; decimal PRICE = decimal.Parse(this.txtPRICE.Text); string CREATE_NAME = this.txtCREATE_NAME.Text; DateTime CREATE_DATE = DateTime.Parse(this.txtCREATE_DATE.Text); MyERP.Model.ORDER_ZBPrice model = new MyERP.Model.ORDER_ZBPrice(); model.CUSTOM_CODE = CUSTOM_CODE; model.CUSTOM_NAME = CUSTOM_NAME; model.ZBBH = ZBBH; model.PZMC = PZMC; model.PRICE = PRICE; model.CREATE_NAME = CREATE_NAME; model.CREATE_DATE = CREATE_DATE; MyERP.BLL.ORDER_ZBPrice bll = new MyERP.BLL.ORDER_ZBPrice(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
private void ShowInfo() { MyERP.BLL.ORDER_ZBPrice bll = new MyERP.BLL.ORDER_ZBPrice(); MyERP.Model.ORDER_ZBPrice model = bll.GetModel(); this.lblCUSTOM_CODE.Text = model.CUSTOM_CODE; this.lblCUSTOM_NAME.Text = model.CUSTOM_NAME; this.lblZBGGID.Text = model.ZBGGID.ToString(); this.lblZBBH.Text = model.ZBBH; this.lblPZMC.Text = model.PZMC; this.lblPRICE.Text = model.PRICE.ToString(); this.lblCREATE_NAME.Text = model.CREATE_NAME; this.lblCREATE_DATE.Text = model.CREATE_DATE.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MyERP.Model.ORDER_ZBPrice model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ORDER_ZBPrice set "); strSql.Append("CUSTOM_CODE=@CUSTOM_CODE,"); strSql.Append("CUSTOM_NAME=@CUSTOM_NAME,"); strSql.Append("ZBGGID=@ZBGGID,"); strSql.Append("ZBBH=@ZBBH,"); strSql.Append("PZMC=@PZMC,"); strSql.Append("PRICE=@PRICE,"); strSql.Append("CREATE_NAME=@CREATE_NAME,"); strSql.Append("CREATE_DATE=@CREATE_DATE"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@CUSTOM_CODE", SqlDbType.NVarChar, 30), new SqlParameter("@CUSTOM_NAME", SqlDbType.NVarChar, 20), new SqlParameter("@ZBGGID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ZBBH", SqlDbType.VarChar, 50), new SqlParameter("@PZMC", SqlDbType.VarChar, 50), new SqlParameter("@PRICE", SqlDbType.Float, 8), new SqlParameter("@CREATE_NAME", SqlDbType.NVarChar, 10), new SqlParameter("@CREATE_DATE", SqlDbType.DateTime) }; parameters[0].Value = model.CUSTOM_CODE; parameters[1].Value = model.CUSTOM_NAME; parameters[2].Value = model.ZBGGID; parameters[3].Value = model.ZBBH; parameters[4].Value = model.PZMC; parameters[5].Value = model.PRICE; parameters[6].Value = model.CREATE_NAME; parameters[7].Value = model.CREATE_DATE; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.ORDER_ZBPrice DataRowToModel(DataRow row) { MyERP.Model.ORDER_ZBPrice model = new MyERP.Model.ORDER_ZBPrice(); if (row != null) { if (row["CUSTOM_CODE"] != null) { model.CUSTOM_CODE = row["CUSTOM_CODE"].ToString(); } if (row["CUSTOM_NAME"] != null) { model.CUSTOM_NAME = row["CUSTOM_NAME"].ToString(); } if (row["ZBGGID"] != null && row["ZBGGID"].ToString() != "") { model.ZBGGID = new Guid(row["ZBGGID"].ToString()); } if (row["ZBBH"] != null) { model.ZBBH = row["ZBBH"].ToString(); } if (row["PZMC"] != null) { model.PZMC = row["PZMC"].ToString(); } if (row["PRICE"] != null && row["PRICE"].ToString() != "") { model.PRICE = decimal.Parse(row["PRICE"].ToString()); } if (row["CREATE_NAME"] != null) { model.CREATE_NAME = row["CREATE_NAME"].ToString(); } if (row["CREATE_DATE"] != null && row["CREATE_DATE"].ToString() != "") { model.CREATE_DATE = DateTime.Parse(row["CREATE_DATE"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MyERP.Model.ORDER_ZBPrice model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ORDER_ZBPrice("); strSql.Append("CUSTOM_CODE,CUSTOM_NAME,ZBGGID,ZBBH,PZMC,PRICE,CREATE_NAME,CREATE_DATE)"); strSql.Append(" values ("); strSql.Append("@CUSTOM_CODE,@CUSTOM_NAME,@ZBGGID,@ZBBH,@PZMC,@PRICE,@CREATE_NAME,@CREATE_DATE)"); SqlParameter[] parameters = { new SqlParameter("@CUSTOM_CODE", SqlDbType.NVarChar, 30), new SqlParameter("@CUSTOM_NAME", SqlDbType.NVarChar, 20), new SqlParameter("@ZBGGID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ZBBH", SqlDbType.VarChar, 50), new SqlParameter("@PZMC", SqlDbType.VarChar, 50), new SqlParameter("@PRICE", SqlDbType.Float, 8), new SqlParameter("@CREATE_NAME", SqlDbType.NVarChar, 10), new SqlParameter("@CREATE_DATE", SqlDbType.DateTime) }; parameters[0].Value = model.CUSTOM_CODE; parameters[1].Value = model.CUSTOM_NAME; parameters[2].Value = Guid.NewGuid(); parameters[3].Value = model.ZBBH; parameters[4].Value = model.PZMC; parameters[5].Value = model.PRICE; parameters[6].Value = model.CREATE_NAME; parameters[7].Value = model.CREATE_DATE; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.ORDER_ZBPrice GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 CUSTOM_CODE,CUSTOM_NAME,ZBGGID,ZBBH,PZMC,PRICE,CREATE_NAME,CREATE_DATE from ORDER_ZBPrice "); strSql.Append(" where "); SqlParameter[] parameters = { }; MyERP.Model.ORDER_ZBPrice model = new MyERP.Model.ORDER_ZBPrice(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }