private void ShowInfo(string ITEM_INTERNAL_CODE) { MyERP.BLL.PUB_FIXEDASSET bll = new MyERP.BLL.PUB_FIXEDASSET(); MyERP.Model.PUB_FIXEDASSET model = bll.GetModel(ITEM_INTERNAL_CODE); this.lblITEM_INTERNAL_CODE.Text = model.ITEM_INTERNAL_CODE; this.lblFIXEDASSET_CODE.Text = model.FIXEDASSET_CODE; this.lblFIXEDASSET_NAME.Text = model.FIXEDASSET_NAME; this.lblSPECIFICATIONS.Text = model.SPECIFICATIONS; this.lblSUPPLY_CODE.Text = model.SUPPLY_CODE; this.lblSUPPLY_NAME.Text = model.SUPPLY_NAME; this.lblOUT_DATE.Text = model.OUT_DATE.ToString(); this.lblPOWER_RATE.Text = model.POWER_RATE; this.lblBEGIN_DATE.Text = model.BEGIN_DATE; this.lblEND_DATE.Text = model.END_DATE; this.lblMEASURE_UNIT.Text = model.MEASURE_UNIT; this.lblQUANTITY.Text = model.QUANTITY.ToString(); this.lblFIXEDASSET_STATUS.Text = model.FIXEDASSET_STATUS; this.lblDEPARTMENT_CODE.Text = model.DEPARTMENT_CODE; this.lblDEPARTMENT_NAME.Text = model.DEPARTMENT_NAME; this.lblPOSITION.Text = model.POSITION; this.lblCREATE_NAME.Text = model.CREATE_NAME; this.lblCREATE_DATE.Text = model.CREATE_DATE.ToString(); this.lblUPDATE_NAME.Text = model.UPDATE_NAME; this.lblUPDATE_DATE.Text = model.UPDATE_DATE.ToString(); this.lblREMARK.Text = model.REMARK; }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.PUB_FIXEDASSET GetModel(string ITEM_INTERNAL_CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ITEM_INTERNAL_CODE,FIXEDASSET_CODE,FIXEDASSET_NAME,SPECIFICATIONS,SUPPLY_CODE,SUPPLY_NAME,OUT_DATE,POWER_RATE,BEGIN_DATE,END_DATE,MEASURE_UNIT,QUANTITY,FIXEDASSET_STATUS,DEPARTMENT_CODE,DEPARTMENT_NAME,POSITION,CREATE_NAME,CREATE_DATE,UPDATE_NAME,UPDATE_DATE,REMARK from PUB_FIXEDASSET "); strSql.Append(" where ITEM_INTERNAL_CODE=@ITEM_INTERNAL_CODE "); SqlParameter[] parameters = { new SqlParameter("@ITEM_INTERNAL_CODE", SqlDbType.VarChar, 50) }; parameters[0].Value = ITEM_INTERNAL_CODE; MyERP.Model.PUB_FIXEDASSET model = new MyERP.Model.PUB_FIXEDASSET(); 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.txtITEM_INTERNAL_CODE.Text.Trim().Length == 0) { strErr += "ITEM_INTERNAL_CODE不能为空!\\n"; } if (this.txtFIXEDASSET_CODE.Text.Trim().Length == 0) { strErr += "FIXEDASSET_CODE不能为空!\\n"; } if (this.txtFIXEDASSET_NAME.Text.Trim().Length == 0) { strErr += "FIXEDASSET_NAME不能为空!\\n"; } if (this.txtSPECIFICATIONS.Text.Trim().Length == 0) { strErr += "SPECIFICATIONS不能为空!\\n"; } if (this.txtSUPPLY_CODE.Text.Trim().Length == 0) { strErr += "SUPPLY_CODE不能为空!\\n"; } if (this.txtSUPPLY_NAME.Text.Trim().Length == 0) { strErr += "SUPPLY_NAME不能为空!\\n"; } if (!PageValidate.IsDateTime(txtOUT_DATE.Text)) { strErr += "OUT_DATE格式错误!\\n"; } if (this.txtPOWER_RATE.Text.Trim().Length == 0) { strErr += "POWER_RATE不能为空!\\n"; } if (this.txtBEGIN_DATE.Text.Trim().Length == 0) { strErr += "BEGIN_DATE不能为空!\\n"; } if (this.txtEND_DATE.Text.Trim().Length == 0) { strErr += "END_DATE不能为空!\\n"; } if (this.txtMEASURE_UNIT.Text.Trim().Length == 0) { strErr += "MEASURE_UNIT不能为空!\\n"; } if (!PageValidate.IsDecimal(txtQUANTITY.Text)) { strErr += "QUANTITY格式错误!\\n"; } if (this.txtFIXEDASSET_STATUS.Text.Trim().Length == 0) { strErr += "FIXEDASSET_STATUS不能为空!\\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.txtPOSITION.Text.Trim().Length == 0) { strErr += "POSITION不能为空!\\n"; } if (this.txtCREATE_NAME.Text.Trim().Length == 0) { strErr += "CREATE_NAME不能为空!\\n"; } if (!PageValidate.IsDateTime(txtCREATE_DATE.Text)) { strErr += "CREATE_DATE格式错误!\\n"; } if (this.txtUPDATE_NAME.Text.Trim().Length == 0) { strErr += "UPDATE_NAME不能为空!\\n"; } if (!PageValidate.IsDateTime(txtUPDATE_DATE.Text)) { strErr += "UPDATE_DATE格式错误!\\n"; } if (this.txtREMARK.Text.Trim().Length == 0) { strErr += "REMARK不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string ITEM_INTERNAL_CODE = this.txtITEM_INTERNAL_CODE.Text; string FIXEDASSET_CODE = this.txtFIXEDASSET_CODE.Text; string FIXEDASSET_NAME = this.txtFIXEDASSET_NAME.Text; string SPECIFICATIONS = this.txtSPECIFICATIONS.Text; string SUPPLY_CODE = this.txtSUPPLY_CODE.Text; string SUPPLY_NAME = this.txtSUPPLY_NAME.Text; DateTime OUT_DATE = DateTime.Parse(this.txtOUT_DATE.Text); string POWER_RATE = this.txtPOWER_RATE.Text; string BEGIN_DATE = this.txtBEGIN_DATE.Text; string END_DATE = this.txtEND_DATE.Text; string MEASURE_UNIT = this.txtMEASURE_UNIT.Text; decimal QUANTITY = decimal.Parse(this.txtQUANTITY.Text); string FIXEDASSET_STATUS = this.txtFIXEDASSET_STATUS.Text; string DEPARTMENT_CODE = this.txtDEPARTMENT_CODE.Text; string DEPARTMENT_NAME = this.txtDEPARTMENT_NAME.Text; string POSITION = this.txtPOSITION.Text; string CREATE_NAME = this.txtCREATE_NAME.Text; DateTime CREATE_DATE = DateTime.Parse(this.txtCREATE_DATE.Text); string UPDATE_NAME = this.txtUPDATE_NAME.Text; DateTime UPDATE_DATE = DateTime.Parse(this.txtUPDATE_DATE.Text); string REMARK = this.txtREMARK.Text; MyERP.Model.PUB_FIXEDASSET model = new MyERP.Model.PUB_FIXEDASSET(); model.ITEM_INTERNAL_CODE = ITEM_INTERNAL_CODE; model.FIXEDASSET_CODE = FIXEDASSET_CODE; model.FIXEDASSET_NAME = FIXEDASSET_NAME; model.SPECIFICATIONS = SPECIFICATIONS; model.SUPPLY_CODE = SUPPLY_CODE; model.SUPPLY_NAME = SUPPLY_NAME; model.OUT_DATE = OUT_DATE; model.POWER_RATE = POWER_RATE; model.BEGIN_DATE = BEGIN_DATE; model.END_DATE = END_DATE; model.MEASURE_UNIT = MEASURE_UNIT; model.QUANTITY = QUANTITY; model.FIXEDASSET_STATUS = FIXEDASSET_STATUS; model.DEPARTMENT_CODE = DEPARTMENT_CODE; model.DEPARTMENT_NAME = DEPARTMENT_NAME; model.POSITION = POSITION; model.CREATE_NAME = CREATE_NAME; model.CREATE_DATE = CREATE_DATE; model.UPDATE_NAME = UPDATE_NAME; model.UPDATE_DATE = UPDATE_DATE; model.REMARK = REMARK; MyERP.BLL.PUB_FIXEDASSET bll = new MyERP.BLL.PUB_FIXEDASSET(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MyERP.Model.PUB_FIXEDASSET model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PUB_FIXEDASSET("); strSql.Append("ITEM_INTERNAL_CODE,FIXEDASSET_CODE,FIXEDASSET_NAME,SPECIFICATIONS,SUPPLY_CODE,SUPPLY_NAME,OUT_DATE,POWER_RATE,BEGIN_DATE,END_DATE,MEASURE_UNIT,QUANTITY,FIXEDASSET_STATUS,DEPARTMENT_CODE,DEPARTMENT_NAME,POSITION,CREATE_NAME,CREATE_DATE,UPDATE_NAME,UPDATE_DATE,REMARK)"); strSql.Append(" values ("); strSql.Append("@ITEM_INTERNAL_CODE,@FIXEDASSET_CODE,@FIXEDASSET_NAME,@SPECIFICATIONS,@SUPPLY_CODE,@SUPPLY_NAME,@OUT_DATE,@POWER_RATE,@BEGIN_DATE,@END_DATE,@MEASURE_UNIT,@QUANTITY,@FIXEDASSET_STATUS,@DEPARTMENT_CODE,@DEPARTMENT_NAME,@POSITION,@CREATE_NAME,@CREATE_DATE,@UPDATE_NAME,@UPDATE_DATE,@REMARK)"); SqlParameter[] parameters = { new SqlParameter("@ITEM_INTERNAL_CODE", SqlDbType.VarChar, 50), new SqlParameter("@FIXEDASSET_CODE", SqlDbType.VarChar, 50), new SqlParameter("@FIXEDASSET_NAME", SqlDbType.VarChar, 50), new SqlParameter("@SPECIFICATIONS", SqlDbType.VarChar, 50), new SqlParameter("@SUPPLY_CODE", SqlDbType.VarChar, 50), new SqlParameter("@SUPPLY_NAME", SqlDbType.NChar, 10), new SqlParameter("@OUT_DATE", SqlDbType.DateTime), new SqlParameter("@POWER_RATE", SqlDbType.VarChar, 50), new SqlParameter("@BEGIN_DATE", SqlDbType.VarChar, 50), new SqlParameter("@END_DATE", SqlDbType.VarChar, 50), new SqlParameter("@MEASURE_UNIT", SqlDbType.VarChar, 50), new SqlParameter("@QUANTITY", SqlDbType.Float, 8), new SqlParameter("@FIXEDASSET_STATUS", SqlDbType.NChar, 10), new SqlParameter("@DEPARTMENT_CODE", SqlDbType.VarChar, 50), new SqlParameter("@DEPARTMENT_NAME", SqlDbType.VarChar, 50), new SqlParameter("@POSITION", SqlDbType.VarChar, 50), new SqlParameter("@CREATE_NAME", SqlDbType.VarChar, 50), new SqlParameter("@CREATE_DATE", SqlDbType.DateTime), new SqlParameter("@UPDATE_NAME", SqlDbType.VarChar, 50), new SqlParameter("@UPDATE_DATE", SqlDbType.DateTime), new SqlParameter("@REMARK", SqlDbType.VarChar, 50) }; parameters[0].Value = model.ITEM_INTERNAL_CODE; parameters[1].Value = model.FIXEDASSET_CODE; parameters[2].Value = model.FIXEDASSET_NAME; parameters[3].Value = model.SPECIFICATIONS; parameters[4].Value = model.SUPPLY_CODE; parameters[5].Value = model.SUPPLY_NAME; parameters[6].Value = model.OUT_DATE; parameters[7].Value = model.POWER_RATE; parameters[8].Value = model.BEGIN_DATE; parameters[9].Value = model.END_DATE; parameters[10].Value = model.MEASURE_UNIT; parameters[11].Value = model.QUANTITY; parameters[12].Value = model.FIXEDASSET_STATUS; parameters[13].Value = model.DEPARTMENT_CODE; parameters[14].Value = model.DEPARTMENT_NAME; parameters[15].Value = model.POSITION; parameters[16].Value = model.CREATE_NAME; parameters[17].Value = model.CREATE_DATE; parameters[18].Value = model.UPDATE_NAME; parameters[19].Value = model.UPDATE_DATE; parameters[20].Value = model.REMARK; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MyERP.Model.PUB_FIXEDASSET DataRowToModel(DataRow row) { MyERP.Model.PUB_FIXEDASSET model = new MyERP.Model.PUB_FIXEDASSET(); if (row != null) { if (row["ITEM_INTERNAL_CODE"] != null) { model.ITEM_INTERNAL_CODE = row["ITEM_INTERNAL_CODE"].ToString(); } if (row["FIXEDASSET_CODE"] != null) { model.FIXEDASSET_CODE = row["FIXEDASSET_CODE"].ToString(); } if (row["FIXEDASSET_NAME"] != null) { model.FIXEDASSET_NAME = row["FIXEDASSET_NAME"].ToString(); } if (row["SPECIFICATIONS"] != null) { model.SPECIFICATIONS = row["SPECIFICATIONS"].ToString(); } if (row["SUPPLY_CODE"] != null) { model.SUPPLY_CODE = row["SUPPLY_CODE"].ToString(); } if (row["SUPPLY_NAME"] != null) { model.SUPPLY_NAME = row["SUPPLY_NAME"].ToString(); } if (row["OUT_DATE"] != null && row["OUT_DATE"].ToString() != "") { model.OUT_DATE = DateTime.Parse(row["OUT_DATE"].ToString()); } if (row["POWER_RATE"] != null) { model.POWER_RATE = row["POWER_RATE"].ToString(); } if (row["BEGIN_DATE"] != null) { model.BEGIN_DATE = row["BEGIN_DATE"].ToString(); } if (row["END_DATE"] != null) { model.END_DATE = row["END_DATE"].ToString(); } if (row["MEASURE_UNIT"] != null) { model.MEASURE_UNIT = row["MEASURE_UNIT"].ToString(); } if (row["QUANTITY"] != null && row["QUANTITY"].ToString() != "") { model.QUANTITY = decimal.Parse(row["QUANTITY"].ToString()); } if (row["FIXEDASSET_STATUS"] != null) { model.FIXEDASSET_STATUS = row["FIXEDASSET_STATUS"].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["POSITION"] != null) { model.POSITION = row["POSITION"].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()); } if (row["UPDATE_NAME"] != null) { model.UPDATE_NAME = row["UPDATE_NAME"].ToString(); } if (row["UPDATE_DATE"] != null && row["UPDATE_DATE"].ToString() != "") { model.UPDATE_DATE = DateTime.Parse(row["UPDATE_DATE"].ToString()); } if (row["REMARK"] != null) { model.REMARK = row["REMARK"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MyERP.Model.PUB_FIXEDASSET model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PUB_FIXEDASSET set "); strSql.Append("FIXEDASSET_CODE=@FIXEDASSET_CODE,"); strSql.Append("FIXEDASSET_NAME=@FIXEDASSET_NAME,"); strSql.Append("SPECIFICATIONS=@SPECIFICATIONS,"); strSql.Append("SUPPLY_CODE=@SUPPLY_CODE,"); strSql.Append("SUPPLY_NAME=@SUPPLY_NAME,"); strSql.Append("OUT_DATE=@OUT_DATE,"); strSql.Append("POWER_RATE=@POWER_RATE,"); strSql.Append("BEGIN_DATE=@BEGIN_DATE,"); strSql.Append("END_DATE=@END_DATE,"); strSql.Append("MEASURE_UNIT=@MEASURE_UNIT,"); strSql.Append("QUANTITY=@QUANTITY,"); strSql.Append("FIXEDASSET_STATUS=@FIXEDASSET_STATUS,"); strSql.Append("DEPARTMENT_CODE=@DEPARTMENT_CODE,"); strSql.Append("DEPARTMENT_NAME=@DEPARTMENT_NAME,"); strSql.Append("POSITION=@POSITION,"); strSql.Append("CREATE_NAME=@CREATE_NAME,"); strSql.Append("CREATE_DATE=@CREATE_DATE,"); strSql.Append("UPDATE_NAME=@UPDATE_NAME,"); strSql.Append("UPDATE_DATE=@UPDATE_DATE,"); strSql.Append("REMARK=@REMARK"); strSql.Append(" where ITEM_INTERNAL_CODE=@ITEM_INTERNAL_CODE "); SqlParameter[] parameters = { new SqlParameter("@FIXEDASSET_CODE", SqlDbType.VarChar, 50), new SqlParameter("@FIXEDASSET_NAME", SqlDbType.VarChar, 50), new SqlParameter("@SPECIFICATIONS", SqlDbType.VarChar, 50), new SqlParameter("@SUPPLY_CODE", SqlDbType.VarChar, 50), new SqlParameter("@SUPPLY_NAME", SqlDbType.NChar, 10), new SqlParameter("@OUT_DATE", SqlDbType.DateTime), new SqlParameter("@POWER_RATE", SqlDbType.VarChar, 50), new SqlParameter("@BEGIN_DATE", SqlDbType.VarChar, 50), new SqlParameter("@END_DATE", SqlDbType.VarChar, 50), new SqlParameter("@MEASURE_UNIT", SqlDbType.VarChar, 50), new SqlParameter("@QUANTITY", SqlDbType.Float, 8), new SqlParameter("@FIXEDASSET_STATUS", SqlDbType.NChar, 10), new SqlParameter("@DEPARTMENT_CODE", SqlDbType.VarChar, 50), new SqlParameter("@DEPARTMENT_NAME", SqlDbType.VarChar, 50), new SqlParameter("@POSITION", SqlDbType.VarChar, 50), new SqlParameter("@CREATE_NAME", SqlDbType.VarChar, 50), new SqlParameter("@CREATE_DATE", SqlDbType.DateTime), new SqlParameter("@UPDATE_NAME", SqlDbType.VarChar, 50), new SqlParameter("@UPDATE_DATE", SqlDbType.DateTime), new SqlParameter("@REMARK", SqlDbType.VarChar, 50), new SqlParameter("@ITEM_INTERNAL_CODE", SqlDbType.VarChar, 50) }; parameters[0].Value = model.FIXEDASSET_CODE; parameters[1].Value = model.FIXEDASSET_NAME; parameters[2].Value = model.SPECIFICATIONS; parameters[3].Value = model.SUPPLY_CODE; parameters[4].Value = model.SUPPLY_NAME; parameters[5].Value = model.OUT_DATE; parameters[6].Value = model.POWER_RATE; parameters[7].Value = model.BEGIN_DATE; parameters[8].Value = model.END_DATE; parameters[9].Value = model.MEASURE_UNIT; parameters[10].Value = model.QUANTITY; parameters[11].Value = model.FIXEDASSET_STATUS; parameters[12].Value = model.DEPARTMENT_CODE; parameters[13].Value = model.DEPARTMENT_NAME; parameters[14].Value = model.POSITION; parameters[15].Value = model.CREATE_NAME; parameters[16].Value = model.CREATE_DATE; parameters[17].Value = model.UPDATE_NAME; parameters[18].Value = model.UPDATE_DATE; parameters[19].Value = model.REMARK; parameters[20].Value = model.ITEM_INTERNAL_CODE; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }