private void ShowInfo(int TID) { WebDemo.BLL.WebDemo.OperationTotal bll = new WebDemo.BLL.WebDemo.OperationTotal(); WebDemo.Model.WebDemo.OperationTotal model = bll.GetModel(TID); this.lblTID.Text = model.TID.ToString(); this.txtMeterID.Text = model.MeterID.ToString(); this.txtPayID.Text = model.PayID.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.txtOperDate.Text = model.OperDate.ToString(); this.txtOperatorID.Text = model.OperatorID.ToString(); this.txtopermonth.Text = model.opermonth; this.txtPriceUnit.Text = model.PriceUnit; this.txtOperationName.Text = model.OperationName; 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.txtAdditionNum.Text = model.AdditionNum.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.OperationTotal GetModel(int TID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 TID,MeterID,PayID,BeginMonth,BeginNumber,EndMonth,EndNumber,UseNumber,PriceTypeID,PriceTypeName,Price,Price2,Price3,FareMoney,PayMark,OperType,OperDate,OperatorID,opermonth,PriceUnit,OperationName,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,AdditionNum from OperationTotal "); strSql.Append(" where TID=@TID "); SqlParameter[] parameters = { new SqlParameter("@TID", SqlDbType.Int, 4) }; parameters[0].Value = TID; WebDemo.Model.WebDemo.OperationTotal model = new WebDemo.Model.WebDemo.OperationTotal(); 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 Add(WebDemo.Model.WebDemo.OperationTotal model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OperationTotal("); strSql.Append("TID,MeterID,PayID,BeginMonth,BeginNumber,EndMonth,EndNumber,UseNumber,PriceTypeID,PriceTypeName,Price,Price2,Price3,FareMoney,PayMark,OperType,OperDate,OperatorID,opermonth,PriceUnit,OperationName,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,AdditionNum)"); strSql.Append(" values ("); strSql.Append("@TID,@MeterID,@PayID,@BeginMonth,@BeginNumber,@EndMonth,@EndNumber,@UseNumber,@PriceTypeID,@PriceTypeName,@Price,@Price2,@Price3,@FareMoney,@PayMark,@OperType,@OperDate,@OperatorID,@opermonth,@PriceUnit,@OperationName,@Divid1,@Divid2,@UseNumber1,@UseNumber2,@UseNumber3,@AdditionNum)"); SqlParameter[] parameters = { new SqlParameter("@TID", SqlDbType.Int, 4), new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@PayID", SqlDbType.Int, 4), new SqlParameter("@BeginMonth", SqlDbType.VarChar, 7), new SqlParameter("@BeginNumber", SqlDbType.Int, 4), new SqlParameter("@EndMonth", SqlDbType.VarChar, 7), new SqlParameter("@EndNumber", SqlDbType.Int, 4), new SqlParameter("@UseNumber", SqlDbType.Int, 4), 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, 7), new SqlParameter("@PriceUnit", SqlDbType.VarChar, 50), new SqlParameter("@OperationName", SqlDbType.VarChar, 50), 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("@AdditionNum", SqlDbType.Decimal, 9) }; parameters[0].Value = model.TID; parameters[1].Value = model.MeterID; parameters[2].Value = model.PayID; parameters[3].Value = model.BeginMonth; parameters[4].Value = model.BeginNumber; parameters[5].Value = model.EndMonth; parameters[6].Value = model.EndNumber; parameters[7].Value = model.UseNumber; parameters[8].Value = model.PriceTypeID; parameters[9].Value = model.PriceTypeName; parameters[10].Value = model.Price; parameters[11].Value = model.Price2; parameters[12].Value = model.Price3; parameters[13].Value = model.FareMoney; parameters[14].Value = model.PayMark; parameters[15].Value = model.OperType; parameters[16].Value = model.OperDate; parameters[17].Value = model.OperatorID; parameters[18].Value = model.opermonth; parameters[19].Value = model.PriceUnit; parameters[20].Value = model.OperationName; parameters[21].Value = model.Divid1; parameters[22].Value = model.Divid2; parameters[23].Value = model.UseNumber1; parameters[24].Value = model.UseNumber2; parameters[25].Value = model.UseNumber3; parameters[26].Value = model.AdditionNum; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.OperationTotal DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.OperationTotal model = new WebDemo.Model.WebDemo.OperationTotal(); if (row != null) { if (row["TID"] != null && row["TID"].ToString() != "") { model.TID = int.Parse(row["TID"].ToString()); } if (row["MeterID"] != null && row["MeterID"].ToString() != "") { model.MeterID = int.Parse(row["MeterID"].ToString()); } if (row["PayID"] != null && row["PayID"].ToString() != "") { model.PayID = int.Parse(row["PayID"].ToString()); } if (row["BeginMonth"] != null) { model.BeginMonth = row["BeginMonth"].ToString(); } if (row["BeginNumber"] != null && row["BeginNumber"].ToString() != "") { model.BeginNumber = int.Parse(row["BeginNumber"].ToString()); } if (row["EndMonth"] != null) { model.EndMonth = row["EndMonth"].ToString(); } if (row["EndNumber"] != null && row["EndNumber"].ToString() != "") { model.EndNumber = int.Parse(row["EndNumber"].ToString()); } if (row["UseNumber"] != null && row["UseNumber"].ToString() != "") { model.UseNumber = int.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["PriceUnit"] != null) { model.PriceUnit = row["PriceUnit"].ToString(); } if (row["OperationName"] != null) { model.OperationName = row["OperationName"].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["AdditionNum"] != null && row["AdditionNum"].ToString() != "") { model.AdditionNum = decimal.Parse(row["AdditionNum"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.OperationTotal model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OperationTotal set "); strSql.Append("MeterID=@MeterID,"); strSql.Append("PayID=@PayID,"); 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("OperDate=@OperDate,"); strSql.Append("OperatorID=@OperatorID,"); strSql.Append("opermonth=@opermonth,"); strSql.Append("PriceUnit=@PriceUnit,"); strSql.Append("OperationName=@OperationName,"); strSql.Append("Divid1=@Divid1,"); strSql.Append("Divid2=@Divid2,"); strSql.Append("UseNumber1=@UseNumber1,"); strSql.Append("UseNumber2=@UseNumber2,"); strSql.Append("UseNumber3=@UseNumber3,"); strSql.Append("AdditionNum=@AdditionNum"); strSql.Append(" where TID=@TID "); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@PayID", SqlDbType.Int, 4), new SqlParameter("@BeginMonth", SqlDbType.VarChar, 7), new SqlParameter("@BeginNumber", SqlDbType.Int, 4), new SqlParameter("@EndMonth", SqlDbType.VarChar, 7), new SqlParameter("@EndNumber", SqlDbType.Int, 4), new SqlParameter("@UseNumber", SqlDbType.Int, 4), 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, 7), new SqlParameter("@PriceUnit", SqlDbType.VarChar, 50), new SqlParameter("@OperationName", SqlDbType.VarChar, 50), 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("@AdditionNum", SqlDbType.Decimal, 9), new SqlParameter("@TID", SqlDbType.Int, 4) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.PayID; parameters[2].Value = model.BeginMonth; parameters[3].Value = model.BeginNumber; parameters[4].Value = model.EndMonth; parameters[5].Value = model.EndNumber; parameters[6].Value = model.UseNumber; parameters[7].Value = model.PriceTypeID; parameters[8].Value = model.PriceTypeName; parameters[9].Value = model.Price; parameters[10].Value = model.Price2; parameters[11].Value = model.Price3; parameters[12].Value = model.FareMoney; parameters[13].Value = model.PayMark; parameters[14].Value = model.OperType; parameters[15].Value = model.OperDate; parameters[16].Value = model.OperatorID; parameters[17].Value = model.opermonth; parameters[18].Value = model.PriceUnit; parameters[19].Value = model.OperationName; parameters[20].Value = model.Divid1; parameters[21].Value = model.Divid2; parameters[22].Value = model.UseNumber1; parameters[23].Value = model.UseNumber2; parameters[24].Value = model.UseNumber3; parameters[25].Value = model.AdditionNum; parameters[26].Value = model.TID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtMeterID.Text)) { strErr += "MeterID格式错误!\\n"; } if (!PageValidate.IsNumber(txtPayID.Text)) { strErr += "PayID格式错误!\\n"; } if (this.txtBeginMonth.Text.Trim().Length == 0) { strErr += "BeginMonth不能为空!\\n"; } if (!PageValidate.IsNumber(txtBeginNumber.Text)) { strErr += "BeginNumber格式错误!\\n"; } if (this.txtEndMonth.Text.Trim().Length == 0) { strErr += "EndMonth不能为空!\\n"; } if (!PageValidate.IsNumber(txtEndNumber.Text)) { strErr += "EndNumber格式错误!\\n"; } if (!PageValidate.IsNumber(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 += "总金额格式错误!\\n"; } if (!PageValidate.IsNumber(txtPayMark.Text)) { strErr += "PayMark格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperType.Text)) { strErr += "1-抄表结算;2-换表结算;格式错误!\\n"; } if (!PageValidate.IsDateTime(txtOperDate.Text)) { strErr += "OperDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperatorID.Text)) { strErr += "OperatorID格式错误!\\n"; } if (this.txtopermonth.Text.Trim().Length == 0) { strErr += "opermonth不能为空!\\n"; } if (this.txtPriceUnit.Text.Trim().Length == 0) { strErr += "PriceUnit不能为空!\\n"; } if (this.txtOperationName.Text.Trim().Length == 0) { strErr += "OperationName不能为空!\\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 (!PageValidate.IsDecimal(txtAdditionNum.Text)) { strErr += "AdditionNum格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int TID = int.Parse(this.lblTID.Text); int MeterID = int.Parse(this.txtMeterID.Text); int PayID = int.Parse(this.txtPayID.Text); string BeginMonth = this.txtBeginMonth.Text; int BeginNumber = int.Parse(this.txtBeginNumber.Text); string EndMonth = this.txtEndMonth.Text; int EndNumber = int.Parse(this.txtEndNumber.Text); int UseNumber = int.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; string PriceUnit = this.txtPriceUnit.Text; string OperationName = this.txtOperationName.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); decimal AdditionNum = decimal.Parse(this.txtAdditionNum.Text); WebDemo.Model.WebDemo.OperationTotal model = new WebDemo.Model.WebDemo.OperationTotal(); model.TID = TID; model.MeterID = MeterID; model.PayID = PayID; 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.PriceUnit = PriceUnit; model.OperationName = OperationName; model.Divid1 = Divid1; model.Divid2 = Divid2; model.UseNumber1 = UseNumber1; model.UseNumber2 = UseNumber2; model.UseNumber3 = UseNumber3; model.AdditionNum = AdditionNum; WebDemo.BLL.WebDemo.OperationTotal bll = new WebDemo.BLL.WebDemo.OperationTotal(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }