private void ShowInfo(int OperID) { WebDemo.BLL.WebDemo.OperationDay bll = new WebDemo.BLL.WebDemo.OperationDay(); WebDemo.Model.WebDemo.OperationDay model = bll.GetModel(OperID); this.lblOperID.Text = model.OperID.ToString(); this.txtMeterID.Text = model.MeterID.ToString(); this.txtBeginMonth.Text = model.BeginMonth; this.txtBeginNumber.Text = model.BeginNumber.ToString(); this.txtEndMonth.Text = model.EndMonth; this.txtEndNumber.Text = model.EndNumber.ToString(); this.txtUseNumber.Text = model.UseNumber.ToString(); this.txtPriceTypeID.Text = model.PriceTypeID.ToString(); this.txtPriceTypeName.Text = model.PriceTypeName; this.txtPrice.Text = model.Price.ToString(); this.txtPrice2.Text = model.Price2.ToString(); this.txtPrice3.Text = model.Price3.ToString(); this.txtFareMoney.Text = model.FareMoney.ToString(); this.txtPayMark.Text = model.PayMark.ToString(); this.txtOperType.Text = model.OperType.ToString(); this.lblOperDate.Text = model.OperDate.ToString(); this.txtOperatorID.Text = model.OperatorID.ToString(); this.txtopermonth.Text = model.opermonth; this.txtMeterNumber.Text = model.MeterNumber.ToString(); this.txtDivid1.Text = model.Divid1.ToString(); this.txtDivid2.Text = model.Divid2.ToString(); this.txtUseNumber1.Text = model.UseNumber1.ToString(); this.txtUseNumber2.Text = model.UseNumber2.ToString(); this.txtUseNumber3.Text = model.UseNumber3.ToString(); this.txtExtData1.Text = model.ExtData1; this.txtExtData2.Text = model.ExtData2; }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.OperationDay GetModel(int OperID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OperID,MeterID,BeginMonth,BeginNumber,EndMonth,EndNumber,UseNumber,PriceTypeID,PriceTypeName,Price,Price2,Price3,FareMoney,PayMark,OperType,OperDate,OperatorID,opermonth,MeterNumber,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,ExtData1,ExtData2 from OperationDay "); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4) }; parameters[0].Value = OperID; WebDemo.Model.WebDemo.OperationDay model = new WebDemo.Model.WebDemo.OperationDay(); 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 int Add(WebDemo.Model.WebDemo.OperationDay model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OperationDay("); strSql.Append("MeterID,BeginMonth,BeginNumber,EndMonth,EndNumber,UseNumber,PriceTypeID,PriceTypeName,Price,Price2,Price3,FareMoney,PayMark,OperType,OperDate,OperatorID,opermonth,MeterNumber,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,ExtData1,ExtData2)"); strSql.Append(" values ("); strSql.Append("@MeterID,@BeginMonth,@BeginNumber,@EndMonth,@EndNumber,@UseNumber,@PriceTypeID,@PriceTypeName,@Price,@Price2,@Price3,@FareMoney,@PayMark,@OperType,@OperDate,@OperatorID,@opermonth,@MeterNumber,@Divid1,@Divid2,@UseNumber1,@UseNumber2,@UseNumber3,@ExtData1,@ExtData2)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@BeginMonth", SqlDbType.VarChar, 10), new SqlParameter("@BeginNumber", SqlDbType.Decimal, 9), new SqlParameter("@EndMonth", SqlDbType.VarChar, 10), new SqlParameter("@EndNumber", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber", SqlDbType.Decimal, 9), new SqlParameter("@PriceTypeID", SqlDbType.Int, 4), new SqlParameter("@PriceTypeName", SqlDbType.VarChar, 50), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@Price2", SqlDbType.Decimal, 9), new SqlParameter("@Price3", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney", SqlDbType.Decimal, 9), new SqlParameter("@PayMark", SqlDbType.Int, 4), new SqlParameter("@OperType", SqlDbType.Int, 4), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@opermonth", SqlDbType.VarChar, 10), new SqlParameter("@MeterNumber", SqlDbType.Decimal, 9), new SqlParameter("@Divid1", SqlDbType.Int, 4), new SqlParameter("@Divid2", SqlDbType.Int, 4), new SqlParameter("@UseNumber1", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber2", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber3", SqlDbType.Decimal, 9), new SqlParameter("@ExtData1", SqlDbType.VarChar, 50), new SqlParameter("@ExtData2", SqlDbType.VarChar, 50) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.BeginMonth; parameters[2].Value = model.BeginNumber; parameters[3].Value = model.EndMonth; parameters[4].Value = model.EndNumber; parameters[5].Value = model.UseNumber; parameters[6].Value = model.PriceTypeID; parameters[7].Value = model.PriceTypeName; parameters[8].Value = model.Price; parameters[9].Value = model.Price2; parameters[10].Value = model.Price3; parameters[11].Value = model.FareMoney; parameters[12].Value = model.PayMark; parameters[13].Value = model.OperType; parameters[14].Value = model.OperDate; parameters[15].Value = model.OperatorID; parameters[16].Value = model.opermonth; parameters[17].Value = model.MeterNumber; parameters[18].Value = model.Divid1; parameters[19].Value = model.Divid2; parameters[20].Value = model.UseNumber1; parameters[21].Value = model.UseNumber2; parameters[22].Value = model.UseNumber3; parameters[23].Value = model.ExtData1; parameters[24].Value = model.ExtData2; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.OperationDay DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.OperationDay model = new WebDemo.Model.WebDemo.OperationDay(); if (row != null) { if (row["OperID"] != null && row["OperID"].ToString() != "") { model.OperID = int.Parse(row["OperID"].ToString()); } if (row["MeterID"] != null && row["MeterID"].ToString() != "") { model.MeterID = int.Parse(row["MeterID"].ToString()); } if (row["BeginMonth"] != null) { model.BeginMonth = row["BeginMonth"].ToString(); } if (row["BeginNumber"] != null && row["BeginNumber"].ToString() != "") { model.BeginNumber = decimal.Parse(row["BeginNumber"].ToString()); } if (row["EndMonth"] != null) { model.EndMonth = row["EndMonth"].ToString(); } if (row["EndNumber"] != null && row["EndNumber"].ToString() != "") { model.EndNumber = decimal.Parse(row["EndNumber"].ToString()); } if (row["UseNumber"] != null && row["UseNumber"].ToString() != "") { model.UseNumber = decimal.Parse(row["UseNumber"].ToString()); } if (row["PriceTypeID"] != null && row["PriceTypeID"].ToString() != "") { model.PriceTypeID = int.Parse(row["PriceTypeID"].ToString()); } if (row["PriceTypeName"] != null) { model.PriceTypeName = row["PriceTypeName"].ToString(); } if (row["Price"] != null && row["Price"].ToString() != "") { model.Price = decimal.Parse(row["Price"].ToString()); } if (row["Price2"] != null && row["Price2"].ToString() != "") { model.Price2 = decimal.Parse(row["Price2"].ToString()); } if (row["Price3"] != null && row["Price3"].ToString() != "") { model.Price3 = decimal.Parse(row["Price3"].ToString()); } if (row["FareMoney"] != null && row["FareMoney"].ToString() != "") { model.FareMoney = decimal.Parse(row["FareMoney"].ToString()); } if (row["PayMark"] != null && row["PayMark"].ToString() != "") { model.PayMark = int.Parse(row["PayMark"].ToString()); } if (row["OperType"] != null && row["OperType"].ToString() != "") { model.OperType = int.Parse(row["OperType"].ToString()); } if (row["OperDate"] != null && row["OperDate"].ToString() != "") { model.OperDate = DateTime.Parse(row["OperDate"].ToString()); } if (row["OperatorID"] != null && row["OperatorID"].ToString() != "") { model.OperatorID = int.Parse(row["OperatorID"].ToString()); } if (row["opermonth"] != null) { model.opermonth = row["opermonth"].ToString(); } if (row["MeterNumber"] != null && row["MeterNumber"].ToString() != "") { model.MeterNumber = decimal.Parse(row["MeterNumber"].ToString()); } if (row["Divid1"] != null && row["Divid1"].ToString() != "") { model.Divid1 = int.Parse(row["Divid1"].ToString()); } if (row["Divid2"] != null && row["Divid2"].ToString() != "") { model.Divid2 = int.Parse(row["Divid2"].ToString()); } if (row["UseNumber1"] != null && row["UseNumber1"].ToString() != "") { model.UseNumber1 = decimal.Parse(row["UseNumber1"].ToString()); } if (row["UseNumber2"] != null && row["UseNumber2"].ToString() != "") { model.UseNumber2 = decimal.Parse(row["UseNumber2"].ToString()); } if (row["UseNumber3"] != null && row["UseNumber3"].ToString() != "") { model.UseNumber3 = decimal.Parse(row["UseNumber3"].ToString()); } if (row["ExtData1"] != null) { model.ExtData1 = row["ExtData1"].ToString(); } if (row["ExtData2"] != null) { model.ExtData2 = row["ExtData2"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.OperationDay model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OperationDay set "); strSql.Append("MeterID=@MeterID,"); strSql.Append("BeginMonth=@BeginMonth,"); strSql.Append("BeginNumber=@BeginNumber,"); strSql.Append("EndMonth=@EndMonth,"); strSql.Append("EndNumber=@EndNumber,"); strSql.Append("UseNumber=@UseNumber,"); strSql.Append("PriceTypeID=@PriceTypeID,"); strSql.Append("PriceTypeName=@PriceTypeName,"); strSql.Append("Price=@Price,"); strSql.Append("Price2=@Price2,"); strSql.Append("Price3=@Price3,"); strSql.Append("FareMoney=@FareMoney,"); strSql.Append("PayMark=@PayMark,"); strSql.Append("OperType=@OperType,"); strSql.Append("OperatorID=@OperatorID,"); strSql.Append("opermonth=@opermonth,"); strSql.Append("MeterNumber=@MeterNumber,"); strSql.Append("Divid1=@Divid1,"); strSql.Append("Divid2=@Divid2,"); strSql.Append("UseNumber1=@UseNumber1,"); strSql.Append("UseNumber2=@UseNumber2,"); strSql.Append("UseNumber3=@UseNumber3,"); strSql.Append("ExtData1=@ExtData1,"); strSql.Append("ExtData2=@ExtData2"); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@BeginMonth", SqlDbType.VarChar, 10), new SqlParameter("@BeginNumber", SqlDbType.Decimal, 9), new SqlParameter("@EndMonth", SqlDbType.VarChar, 10), new SqlParameter("@EndNumber", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber", SqlDbType.Decimal, 9), new SqlParameter("@PriceTypeID", SqlDbType.Int, 4), new SqlParameter("@PriceTypeName", SqlDbType.VarChar, 50), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@Price2", SqlDbType.Decimal, 9), new SqlParameter("@Price3", SqlDbType.Decimal, 9), new SqlParameter("@FareMoney", SqlDbType.Decimal, 9), new SqlParameter("@PayMark", SqlDbType.Int, 4), new SqlParameter("@OperType", SqlDbType.Int, 4), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@opermonth", SqlDbType.VarChar, 10), new SqlParameter("@MeterNumber", SqlDbType.Decimal, 9), new SqlParameter("@Divid1", SqlDbType.Int, 4), new SqlParameter("@Divid2", SqlDbType.Int, 4), new SqlParameter("@UseNumber1", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber2", SqlDbType.Decimal, 9), new SqlParameter("@UseNumber3", SqlDbType.Decimal, 9), new SqlParameter("@ExtData1", SqlDbType.VarChar, 50), new SqlParameter("@ExtData2", SqlDbType.VarChar, 50), new SqlParameter("@OperID", SqlDbType.Int, 4), new SqlParameter("@OperDate", SqlDbType.DateTime) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.BeginMonth; parameters[2].Value = model.BeginNumber; parameters[3].Value = model.EndMonth; parameters[4].Value = model.EndNumber; parameters[5].Value = model.UseNumber; parameters[6].Value = model.PriceTypeID; parameters[7].Value = model.PriceTypeName; parameters[8].Value = model.Price; parameters[9].Value = model.Price2; parameters[10].Value = model.Price3; parameters[11].Value = model.FareMoney; parameters[12].Value = model.PayMark; parameters[13].Value = model.OperType; parameters[14].Value = model.OperatorID; parameters[15].Value = model.opermonth; parameters[16].Value = model.MeterNumber; parameters[17].Value = model.Divid1; parameters[18].Value = model.Divid2; parameters[19].Value = model.UseNumber1; parameters[20].Value = model.UseNumber2; parameters[21].Value = model.UseNumber3; parameters[22].Value = model.ExtData1; parameters[23].Value = model.ExtData2; parameters[24].Value = model.OperID; parameters[25].Value = model.OperDate; 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 (!PageValidate.IsNumber(txtMeterID.Text)) { strErr += "MeterID格式错误!\\n"; } if (this.txtBeginMonth.Text.Trim().Length == 0) { strErr += "BeginMonth不能为空!\\n"; } if (!PageValidate.IsDecimal(txtBeginNumber.Text)) { strErr += "BeginNumber格式错误!\\n"; } if (this.txtEndMonth.Text.Trim().Length == 0) { strErr += "EndMonth不能为空!\\n"; } if (!PageValidate.IsDecimal(txtEndNumber.Text)) { strErr += "EndNumber格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseNumber.Text)) { strErr += "UseNumber格式错误!\\n"; } if (!PageValidate.IsNumber(txtPriceTypeID.Text)) { strErr += "PriceTypeID格式错误!\\n"; } if (this.txtPriceTypeName.Text.Trim().Length == 0) { strErr += "PriceTypeName不能为空!\\n"; } if (!PageValidate.IsDecimal(txtPrice.Text)) { strErr += "Price格式错误!\\n"; } if (!PageValidate.IsDecimal(txtPrice2.Text)) { strErr += "Price2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtPrice3.Text)) { strErr += "Price3格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFareMoney.Text)) { strErr += "FareMoney格式错误!\\n"; } if (!PageValidate.IsNumber(txtPayMark.Text)) { strErr += "PayMark格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperType.Text)) { strErr += "OperType格式错误!\\n"; } if (!PageValidate.IsDateTime(txtOperDate.Text)) { strErr += "业务时间格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperatorID.Text)) { strErr += "OperatorID格式错误!\\n"; } if (this.txtopermonth.Text.Trim().Length == 0) { strErr += "opermonth不能为空!\\n"; } if (!PageValidate.IsDecimal(txtMeterNumber.Text)) { strErr += "MeterNumber格式错误!\\n"; } if (!PageValidate.IsNumber(txtDivid1.Text)) { strErr += "Divid1格式错误!\\n"; } if (!PageValidate.IsNumber(txtDivid2.Text)) { strErr += "Divid2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseNumber1.Text)) { strErr += "UseNumber1格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseNumber2.Text)) { strErr += "UseNumber2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseNumber3.Text)) { strErr += "UseNumber3格式错误!\\n"; } if (this.txtExtData1.Text.Trim().Length == 0) { strErr += "ExtData1不能为空!\\n"; } if (this.txtExtData2.Text.Trim().Length == 0) { strErr += "ExtData2不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int MeterID = int.Parse(this.txtMeterID.Text); string BeginMonth = this.txtBeginMonth.Text; decimal BeginNumber = decimal.Parse(this.txtBeginNumber.Text); string EndMonth = this.txtEndMonth.Text; decimal EndNumber = decimal.Parse(this.txtEndNumber.Text); decimal UseNumber = decimal.Parse(this.txtUseNumber.Text); int PriceTypeID = int.Parse(this.txtPriceTypeID.Text); string PriceTypeName = this.txtPriceTypeName.Text; decimal Price = decimal.Parse(this.txtPrice.Text); decimal Price2 = decimal.Parse(this.txtPrice2.Text); decimal Price3 = decimal.Parse(this.txtPrice3.Text); decimal FareMoney = decimal.Parse(this.txtFareMoney.Text); int PayMark = int.Parse(this.txtPayMark.Text); int OperType = int.Parse(this.txtOperType.Text); DateTime OperDate = DateTime.Parse(this.txtOperDate.Text); int OperatorID = int.Parse(this.txtOperatorID.Text); string opermonth = this.txtopermonth.Text; decimal MeterNumber = decimal.Parse(this.txtMeterNumber.Text); int Divid1 = int.Parse(this.txtDivid1.Text); int Divid2 = int.Parse(this.txtDivid2.Text); decimal UseNumber1 = decimal.Parse(this.txtUseNumber1.Text); decimal UseNumber2 = decimal.Parse(this.txtUseNumber2.Text); decimal UseNumber3 = decimal.Parse(this.txtUseNumber3.Text); string ExtData1 = this.txtExtData1.Text; string ExtData2 = this.txtExtData2.Text; WebDemo.Model.WebDemo.OperationDay model = new WebDemo.Model.WebDemo.OperationDay(); model.MeterID = MeterID; model.BeginMonth = BeginMonth; model.BeginNumber = BeginNumber; model.EndMonth = EndMonth; model.EndNumber = EndNumber; model.UseNumber = UseNumber; model.PriceTypeID = PriceTypeID; model.PriceTypeName = PriceTypeName; model.Price = Price; model.Price2 = Price2; model.Price3 = Price3; model.FareMoney = FareMoney; model.PayMark = PayMark; model.OperType = OperType; model.OperDate = OperDate; model.OperatorID = OperatorID; model.opermonth = opermonth; model.MeterNumber = MeterNumber; model.Divid1 = Divid1; model.Divid2 = Divid2; model.UseNumber1 = UseNumber1; model.UseNumber2 = UseNumber2; model.UseNumber3 = UseNumber3; model.ExtData1 = ExtData1; model.ExtData2 = ExtData2; WebDemo.BLL.WebDemo.OperationDay bll = new WebDemo.BLL.WebDemo.OperationDay(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }