private void ShowInfo(int OperID) { WebDemo.BLL.WebDemo.PreOperation bll = new WebDemo.BLL.WebDemo.PreOperation(); WebDemo.Model.WebDemo.PreOperation model = bll.GetModel(OperID); this.lblOperID.Text = model.OperID.ToString(); this.txtCardID.Text = model.CardID.ToString(); this.txtCardSector.Text = model.CardSector.ToString(); this.txtPriceTypeID.Text = model.PriceTypeID.ToString(); this.txtPriceTypeName.Text = model.PriceTypeName; this.txtPrice.Text = model.Price.ToString(); this.txtOperMoney.Text = model.OperMoney.ToString(); this.txtOperInt.Text = model.OperInt.ToString(); this.txtOperZS.Text = model.OperZS.ToString(); this.txtFactMoney.Text = model.FactMoney.ToString(); this.txtLastBalance.Text = model.LastBalance.ToString(); this.txtCurrentBalance.Text = model.CurrentBalance.ToString(); this.txtTotalMoney.Text = model.TotalMoney.ToString(); this.txtTotalInt.Text = model.TotalInt.ToString(); this.txtTotalBase.Text = model.TotalBase.ToString(); this.txtOperType.Text = model.OperType.ToString(); this.txtPayType.Text = model.PayType.ToString(); this.txtInvoiceCode.Text = model.InvoiceCode; this.lblOperDate.Text = model.OperDate.ToString(); this.txtMeterID.Text = model.MeterID.ToString(); this.txtOperatorID.Text = model.OperatorID.ToString(); this.txtSiteID.Text = model.SiteID.ToString(); this.txtFactoryNum.Text = model.FactoryNum.ToString(); this.txtRemark.Text = model.Remark; this.txtRedOperId.Text = model.RedOperId.ToString(); this.txtOperNum.Text = model.OperNum.ToString(); this.txtPrice2.Text = model.Price2.ToString(); this.txtPrice3.Text = model.Price3.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.txtCurTotalBuyNumber.Text = model.CurTotalBuyNumber.ToString(); this.txtInvoiceID.Text = model.InvoiceID.ToString(); this.txtInvoiceType.Text = model.InvoiceType.ToString(); this.txtWriteCardFlag.Text = model.WriteCardFlag.ToString(); this.txtTransactionId.Text = model.TransactionId; this.txtPayWay.Text = model.PayWay.ToString(); this.txtOutTradeNo.Text = model.OutTradeNo; this.txtDepositDate.Text = model.DepositDate.ToString(); this.txtDiscountsNum.Text = model.DiscountsNum.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.PreOperation GetModel(int OperID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OperID,CardID,CardSector,PriceTypeID,PriceTypeName,Price,OperMoney,OperInt,OperZS,FactMoney,LastBalance,CurrentBalance,TotalMoney,TotalInt,TotalBase,OperType,PayType,InvoiceCode,OperDate,MeterID,OperatorID,SiteID,FactoryNum,Remark,RedOperId,OperNum,Price2,Price3,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,CurTotalBuyNumber,InvoiceID,InvoiceType,WriteCardFlag,TransactionId,PayWay,OutTradeNo,DepositDate,DiscountsNum from PreOperation "); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4) }; parameters[0].Value = OperID; WebDemo.Model.WebDemo.PreOperation model = new WebDemo.Model.WebDemo.PreOperation(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtCardID.Text)) { strErr += "一卡通卡号(卡号+卡区号不能重格式错误!\\n"; } if (!PageValidate.IsNumber(txtCardSector.Text)) { strErr += "卡区号(一卡通卡区号格式错误!\\n"; } if (!PageValidate.IsNumber(txtPriceTypeID.Text)) { strErr += "PriceTypeID格式错误!\\n"; } if (this.txtPriceTypeName.Text.Trim().Length == 0) { strErr += "价格名称不能为空!\\n"; } if (!PageValidate.IsDecimal(txtPrice.Text)) { strErr += "单价格式错误!\\n"; } if (!PageValidate.IsDecimal(txtOperMoney.Text)) { strErr += "业务金额格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperInt.Text)) { strErr += "业务量格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperZS.Text)) { strErr += "业务字数格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFactMoney.Text)) { strErr += "实收金额格式错误!\\n"; } if (!PageValidate.IsDecimal(txtLastBalance.Text)) { strErr += "上次余额格式错误!\\n"; } if (!PageValidate.IsDecimal(txtCurrentBalance.Text)) { strErr += "本次余额格式错误!\\n"; } if (!PageValidate.IsDecimal(txtTotalMoney.Text)) { strErr += "总购买金额格式错误!\\n"; } if (!PageValidate.IsNumber(txtTotalInt.Text)) { strErr += "总购买量格式错误!\\n"; } if (!PageValidate.IsNumber(txtTotalBase.Text)) { strErr += "总购买字数格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperType.Text)) { strErr += "业务类型(1-开户;2-充值;格式错误!\\n"; } if (!PageValidate.IsNumber(txtPayType.Text)) { strErr += "充值类型(1-远程充值;2-写格式错误!\\n"; } if (this.txtInvoiceCode.Text.Trim().Length == 0) { strErr += "发票号码不能为空!\\n"; } if (!PageValidate.IsDateTime(txtOperDate.Text)) { strErr += "业务日期格式错误!\\n"; } if (!PageValidate.IsNumber(txtMeterID.Text)) { strErr += "表编号格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperatorID.Text)) { strErr += "操作员格式错误!\\n"; } if (!PageValidate.IsNumber(txtSiteID.Text)) { strErr += "SiteID格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFactoryNum.Text)) { strErr += "FactoryNum格式错误!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "Remark不能为空!\\n"; } if (!PageValidate.IsNumber(txtRedOperId.Text)) { strErr += "RedOperId格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperNum.Text)) { strErr += "OperNum格式错误!\\n"; } if (!PageValidate.IsDecimal(txtPrice2.Text)) { strErr += "Price2格式错误!\\n"; } if (!PageValidate.IsDecimal(txtPrice3.Text)) { strErr += "Price3格式错误!\\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(txtCurTotalBuyNumber.Text)) { strErr += "CurTotalBuyNumber格式错误!\\n"; } if (!PageValidate.IsNumber(txtInvoiceID.Text)) { strErr += "InvoiceID格式错误!\\n"; } if (!PageValidate.IsNumber(txtInvoiceType.Text)) { strErr += "InvoiceType格式错误!\\n"; } if (!PageValidate.IsNumber(txtWriteCardFlag.Text)) { strErr += "WriteCardFlag格式错误!\\n"; } if (this.txtTransactionId.Text.Trim().Length == 0) { strErr += "TransactionId不能为空!\\n"; } if (!PageValidate.IsNumber(txtPayWay.Text)) { strErr += "PayWay格式错误!\\n"; } if (this.txtOutTradeNo.Text.Trim().Length == 0) { strErr += "OutTradeNo不能为空!\\n"; } if (!PageValidate.IsDateTime(txtDepositDate.Text)) { strErr += "DepositDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtDiscountsNum.Text)) { strErr += "DiscountsNum格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int OperID = int.Parse(this.lblOperID.Text); int CardID = int.Parse(this.txtCardID.Text); int CardSector = int.Parse(this.txtCardSector.Text); int PriceTypeID = int.Parse(this.txtPriceTypeID.Text); string PriceTypeName = this.txtPriceTypeName.Text; decimal Price = decimal.Parse(this.txtPrice.Text); decimal OperMoney = decimal.Parse(this.txtOperMoney.Text); int OperInt = int.Parse(this.txtOperInt.Text); int OperZS = int.Parse(this.txtOperZS.Text); decimal FactMoney = decimal.Parse(this.txtFactMoney.Text); decimal LastBalance = decimal.Parse(this.txtLastBalance.Text); decimal CurrentBalance = decimal.Parse(this.txtCurrentBalance.Text); decimal TotalMoney = decimal.Parse(this.txtTotalMoney.Text); int TotalInt = int.Parse(this.txtTotalInt.Text); int TotalBase = int.Parse(this.txtTotalBase.Text); int OperType = int.Parse(this.txtOperType.Text); int PayType = int.Parse(this.txtPayType.Text); string InvoiceCode = this.txtInvoiceCode.Text; DateTime OperDate = DateTime.Parse(this.txtOperDate.Text); int MeterID = int.Parse(this.txtMeterID.Text); int OperatorID = int.Parse(this.txtOperatorID.Text); int SiteID = int.Parse(this.txtSiteID.Text); decimal FactoryNum = decimal.Parse(this.txtFactoryNum.Text); string Remark = this.txtRemark.Text; int RedOperId = int.Parse(this.txtRedOperId.Text); int OperNum = int.Parse(this.txtOperNum.Text); decimal Price2 = decimal.Parse(this.txtPrice2.Text); decimal Price3 = decimal.Parse(this.txtPrice3.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 CurTotalBuyNumber = decimal.Parse(this.txtCurTotalBuyNumber.Text); int InvoiceID = int.Parse(this.txtInvoiceID.Text); int InvoiceType = int.Parse(this.txtInvoiceType.Text); int WriteCardFlag = int.Parse(this.txtWriteCardFlag.Text); string TransactionId = this.txtTransactionId.Text; int PayWay = int.Parse(this.txtPayWay.Text); string OutTradeNo = this.txtOutTradeNo.Text; DateTime DepositDate = DateTime.Parse(this.txtDepositDate.Text); int DiscountsNum = int.Parse(this.txtDiscountsNum.Text); WebDemo.Model.WebDemo.PreOperation model = new WebDemo.Model.WebDemo.PreOperation(); model.OperID = OperID; model.CardID = CardID; model.CardSector = CardSector; model.PriceTypeID = PriceTypeID; model.PriceTypeName = PriceTypeName; model.Price = Price; model.OperMoney = OperMoney; model.OperInt = OperInt; model.OperZS = OperZS; model.FactMoney = FactMoney; model.LastBalance = LastBalance; model.CurrentBalance = CurrentBalance; model.TotalMoney = TotalMoney; model.TotalInt = TotalInt; model.TotalBase = TotalBase; model.OperType = OperType; model.PayType = PayType; model.InvoiceCode = InvoiceCode; model.OperDate = OperDate; model.MeterID = MeterID; model.OperatorID = OperatorID; model.SiteID = SiteID; model.FactoryNum = FactoryNum; model.Remark = Remark; model.RedOperId = RedOperId; model.OperNum = OperNum; model.Price2 = Price2; model.Price3 = Price3; model.Divid1 = Divid1; model.Divid2 = Divid2; model.UseNumber1 = UseNumber1; model.UseNumber2 = UseNumber2; model.UseNumber3 = UseNumber3; model.CurTotalBuyNumber = CurTotalBuyNumber; model.InvoiceID = InvoiceID; model.InvoiceType = InvoiceType; model.WriteCardFlag = WriteCardFlag; model.TransactionId = TransactionId; model.PayWay = PayWay; model.OutTradeNo = OutTradeNo; model.DepositDate = DepositDate; model.DiscountsNum = DiscountsNum; WebDemo.BLL.WebDemo.PreOperation bll = new WebDemo.BLL.WebDemo.PreOperation(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.PreOperation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PreOperation("); strSql.Append("CardID,CardSector,PriceTypeID,PriceTypeName,Price,OperMoney,OperInt,OperZS,FactMoney,LastBalance,CurrentBalance,TotalMoney,TotalInt,TotalBase,OperType,PayType,InvoiceCode,OperDate,MeterID,OperatorID,SiteID,FactoryNum,Remark,RedOperId,OperNum,Price2,Price3,Divid1,Divid2,UseNumber1,UseNumber2,UseNumber3,CurTotalBuyNumber,InvoiceID,InvoiceType,WriteCardFlag,TransactionId,PayWay,OutTradeNo,DepositDate,DiscountsNum)"); strSql.Append(" values ("); strSql.Append("@CardID,@CardSector,@PriceTypeID,@PriceTypeName,@Price,@OperMoney,@OperInt,@OperZS,@FactMoney,@LastBalance,@CurrentBalance,@TotalMoney,@TotalInt,@TotalBase,@OperType,@PayType,@InvoiceCode,@OperDate,@MeterID,@OperatorID,@SiteID,@FactoryNum,@Remark,@RedOperId,@OperNum,@Price2,@Price3,@Divid1,@Divid2,@UseNumber1,@UseNumber2,@UseNumber3,@CurTotalBuyNumber,@InvoiceID,@InvoiceType,@WriteCardFlag,@TransactionId,@PayWay,@OutTradeNo,@DepositDate,@DiscountsNum)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CardID", SqlDbType.Int, 4), new SqlParameter("@CardSector", SqlDbType.Int, 4), new SqlParameter("@PriceTypeID", SqlDbType.Int, 4), new SqlParameter("@PriceTypeName", SqlDbType.VarChar, 50), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@OperMoney", SqlDbType.Decimal, 9), new SqlParameter("@OperInt", SqlDbType.Int, 4), new SqlParameter("@OperZS", SqlDbType.Int, 4), new SqlParameter("@FactMoney", SqlDbType.Decimal, 9), new SqlParameter("@LastBalance", SqlDbType.Decimal, 9), new SqlParameter("@CurrentBalance", SqlDbType.Decimal, 9), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@TotalInt", SqlDbType.Int, 4), new SqlParameter("@TotalBase", SqlDbType.Int, 4), new SqlParameter("@OperType", SqlDbType.Int, 4), new SqlParameter("@PayType", SqlDbType.Int, 4), new SqlParameter("@InvoiceCode", SqlDbType.VarChar, 50), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@FactoryNum", SqlDbType.Decimal, 9), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@RedOperId", SqlDbType.Int, 4), new SqlParameter("@OperNum", SqlDbType.Int, 4), new SqlParameter("@Price2", SqlDbType.Decimal, 9), new SqlParameter("@Price3", 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("@CurTotalBuyNumber", SqlDbType.Decimal, 9), new SqlParameter("@InvoiceID", SqlDbType.Int, 4), new SqlParameter("@InvoiceType", SqlDbType.Int, 4), new SqlParameter("@WriteCardFlag", SqlDbType.Int, 4), new SqlParameter("@TransactionId", SqlDbType.VarChar, 100), new SqlParameter("@PayWay", SqlDbType.Int, 4), new SqlParameter("@OutTradeNo", SqlDbType.VarChar, 100), new SqlParameter("@DepositDate", SqlDbType.DateTime), new SqlParameter("@DiscountsNum", SqlDbType.Int, 4) }; parameters[0].Value = model.CardID; parameters[1].Value = model.CardSector; parameters[2].Value = model.PriceTypeID; parameters[3].Value = model.PriceTypeName; parameters[4].Value = model.Price; parameters[5].Value = model.OperMoney; parameters[6].Value = model.OperInt; parameters[7].Value = model.OperZS; parameters[8].Value = model.FactMoney; parameters[9].Value = model.LastBalance; parameters[10].Value = model.CurrentBalance; parameters[11].Value = model.TotalMoney; parameters[12].Value = model.TotalInt; parameters[13].Value = model.TotalBase; parameters[14].Value = model.OperType; parameters[15].Value = model.PayType; parameters[16].Value = model.InvoiceCode; parameters[17].Value = model.OperDate; parameters[18].Value = model.MeterID; parameters[19].Value = model.OperatorID; parameters[20].Value = model.SiteID; parameters[21].Value = model.FactoryNum; parameters[22].Value = model.Remark; parameters[23].Value = model.RedOperId; parameters[24].Value = model.OperNum; parameters[25].Value = model.Price2; parameters[26].Value = model.Price3; parameters[27].Value = model.Divid1; parameters[28].Value = model.Divid2; parameters[29].Value = model.UseNumber1; parameters[30].Value = model.UseNumber2; parameters[31].Value = model.UseNumber3; parameters[32].Value = model.CurTotalBuyNumber; parameters[33].Value = model.InvoiceID; parameters[34].Value = model.InvoiceType; parameters[35].Value = model.WriteCardFlag; parameters[36].Value = model.TransactionId; parameters[37].Value = model.PayWay; parameters[38].Value = model.OutTradeNo; parameters[39].Value = model.DepositDate; parameters[40].Value = model.DiscountsNum; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.PreOperation DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.PreOperation model = new WebDemo.Model.WebDemo.PreOperation(); if (row != null) { if (row["OperID"] != null && row["OperID"].ToString() != "") { model.OperID = int.Parse(row["OperID"].ToString()); } if (row["CardID"] != null && row["CardID"].ToString() != "") { model.CardID = int.Parse(row["CardID"].ToString()); } if (row["CardSector"] != null && row["CardSector"].ToString() != "") { model.CardSector = int.Parse(row["CardSector"].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["OperMoney"] != null && row["OperMoney"].ToString() != "") { model.OperMoney = decimal.Parse(row["OperMoney"].ToString()); } if (row["OperInt"] != null && row["OperInt"].ToString() != "") { model.OperInt = int.Parse(row["OperInt"].ToString()); } if (row["OperZS"] != null && row["OperZS"].ToString() != "") { model.OperZS = int.Parse(row["OperZS"].ToString()); } if (row["FactMoney"] != null && row["FactMoney"].ToString() != "") { model.FactMoney = decimal.Parse(row["FactMoney"].ToString()); } if (row["LastBalance"] != null && row["LastBalance"].ToString() != "") { model.LastBalance = decimal.Parse(row["LastBalance"].ToString()); } if (row["CurrentBalance"] != null && row["CurrentBalance"].ToString() != "") { model.CurrentBalance = decimal.Parse(row["CurrentBalance"].ToString()); } if (row["TotalMoney"] != null && row["TotalMoney"].ToString() != "") { model.TotalMoney = decimal.Parse(row["TotalMoney"].ToString()); } if (row["TotalInt"] != null && row["TotalInt"].ToString() != "") { model.TotalInt = int.Parse(row["TotalInt"].ToString()); } if (row["TotalBase"] != null && row["TotalBase"].ToString() != "") { model.TotalBase = int.Parse(row["TotalBase"].ToString()); } if (row["OperType"] != null && row["OperType"].ToString() != "") { model.OperType = int.Parse(row["OperType"].ToString()); } if (row["PayType"] != null && row["PayType"].ToString() != "") { model.PayType = int.Parse(row["PayType"].ToString()); } if (row["InvoiceCode"] != null) { model.InvoiceCode = row["InvoiceCode"].ToString(); } if (row["OperDate"] != null && row["OperDate"].ToString() != "") { model.OperDate = DateTime.Parse(row["OperDate"].ToString()); } if (row["MeterID"] != null && row["MeterID"].ToString() != "") { model.MeterID = int.Parse(row["MeterID"].ToString()); } if (row["OperatorID"] != null && row["OperatorID"].ToString() != "") { model.OperatorID = int.Parse(row["OperatorID"].ToString()); } if (row["SiteID"] != null && row["SiteID"].ToString() != "") { model.SiteID = int.Parse(row["SiteID"].ToString()); } if (row["FactoryNum"] != null && row["FactoryNum"].ToString() != "") { model.FactoryNum = decimal.Parse(row["FactoryNum"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["RedOperId"] != null && row["RedOperId"].ToString() != "") { model.RedOperId = int.Parse(row["RedOperId"].ToString()); } if (row["OperNum"] != null && row["OperNum"].ToString() != "") { model.OperNum = int.Parse(row["OperNum"].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["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["CurTotalBuyNumber"] != null && row["CurTotalBuyNumber"].ToString() != "") { model.CurTotalBuyNumber = decimal.Parse(row["CurTotalBuyNumber"].ToString()); } if (row["InvoiceID"] != null && row["InvoiceID"].ToString() != "") { model.InvoiceID = int.Parse(row["InvoiceID"].ToString()); } if (row["InvoiceType"] != null && row["InvoiceType"].ToString() != "") { model.InvoiceType = int.Parse(row["InvoiceType"].ToString()); } if (row["WriteCardFlag"] != null && row["WriteCardFlag"].ToString() != "") { model.WriteCardFlag = int.Parse(row["WriteCardFlag"].ToString()); } if (row["TransactionId"] != null) { model.TransactionId = row["TransactionId"].ToString(); } if (row["PayWay"] != null && row["PayWay"].ToString() != "") { model.PayWay = int.Parse(row["PayWay"].ToString()); } if (row["OutTradeNo"] != null) { model.OutTradeNo = row["OutTradeNo"].ToString(); } if (row["DepositDate"] != null && row["DepositDate"].ToString() != "") { model.DepositDate = DateTime.Parse(row["DepositDate"].ToString()); } if (row["DiscountsNum"] != null && row["DiscountsNum"].ToString() != "") { model.DiscountsNum = int.Parse(row["DiscountsNum"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.PreOperation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PreOperation set "); strSql.Append("CardID=@CardID,"); strSql.Append("CardSector=@CardSector,"); strSql.Append("PriceTypeID=@PriceTypeID,"); strSql.Append("PriceTypeName=@PriceTypeName,"); strSql.Append("Price=@Price,"); strSql.Append("OperMoney=@OperMoney,"); strSql.Append("OperInt=@OperInt,"); strSql.Append("OperZS=@OperZS,"); strSql.Append("FactMoney=@FactMoney,"); strSql.Append("LastBalance=@LastBalance,"); strSql.Append("CurrentBalance=@CurrentBalance,"); strSql.Append("TotalMoney=@TotalMoney,"); strSql.Append("TotalInt=@TotalInt,"); strSql.Append("TotalBase=@TotalBase,"); strSql.Append("OperType=@OperType,"); strSql.Append("PayType=@PayType,"); strSql.Append("InvoiceCode=@InvoiceCode,"); strSql.Append("MeterID=@MeterID,"); strSql.Append("OperatorID=@OperatorID,"); strSql.Append("SiteID=@SiteID,"); strSql.Append("FactoryNum=@FactoryNum,"); strSql.Append("Remark=@Remark,"); strSql.Append("RedOperId=@RedOperId,"); strSql.Append("OperNum=@OperNum,"); strSql.Append("Price2=@Price2,"); strSql.Append("Price3=@Price3,"); strSql.Append("Divid1=@Divid1,"); strSql.Append("Divid2=@Divid2,"); strSql.Append("UseNumber1=@UseNumber1,"); strSql.Append("UseNumber2=@UseNumber2,"); strSql.Append("UseNumber3=@UseNumber3,"); strSql.Append("CurTotalBuyNumber=@CurTotalBuyNumber,"); strSql.Append("InvoiceID=@InvoiceID,"); strSql.Append("InvoiceType=@InvoiceType,"); strSql.Append("WriteCardFlag=@WriteCardFlag,"); strSql.Append("TransactionId=@TransactionId,"); strSql.Append("PayWay=@PayWay,"); strSql.Append("OutTradeNo=@OutTradeNo,"); strSql.Append("DepositDate=@DepositDate,"); strSql.Append("DiscountsNum=@DiscountsNum"); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@CardID", SqlDbType.Int, 4), new SqlParameter("@CardSector", SqlDbType.Int, 4), new SqlParameter("@PriceTypeID", SqlDbType.Int, 4), new SqlParameter("@PriceTypeName", SqlDbType.VarChar, 50), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@OperMoney", SqlDbType.Decimal, 9), new SqlParameter("@OperInt", SqlDbType.Int, 4), new SqlParameter("@OperZS", SqlDbType.Int, 4), new SqlParameter("@FactMoney", SqlDbType.Decimal, 9), new SqlParameter("@LastBalance", SqlDbType.Decimal, 9), new SqlParameter("@CurrentBalance", SqlDbType.Decimal, 9), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@TotalInt", SqlDbType.Int, 4), new SqlParameter("@TotalBase", SqlDbType.Int, 4), new SqlParameter("@OperType", SqlDbType.Int, 4), new SqlParameter("@PayType", SqlDbType.Int, 4), new SqlParameter("@InvoiceCode", SqlDbType.VarChar, 50), new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@FactoryNum", SqlDbType.Decimal, 9), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@RedOperId", SqlDbType.Int, 4), new SqlParameter("@OperNum", SqlDbType.Int, 4), new SqlParameter("@Price2", SqlDbType.Decimal, 9), new SqlParameter("@Price3", 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("@CurTotalBuyNumber", SqlDbType.Decimal, 9), new SqlParameter("@InvoiceID", SqlDbType.Int, 4), new SqlParameter("@InvoiceType", SqlDbType.Int, 4), new SqlParameter("@WriteCardFlag", SqlDbType.Int, 4), new SqlParameter("@TransactionId", SqlDbType.VarChar, 100), new SqlParameter("@PayWay", SqlDbType.Int, 4), new SqlParameter("@OutTradeNo", SqlDbType.VarChar, 100), new SqlParameter("@DepositDate", SqlDbType.DateTime), new SqlParameter("@DiscountsNum", SqlDbType.Int, 4), new SqlParameter("@OperID", SqlDbType.Int, 4), new SqlParameter("@OperDate", SqlDbType.DateTime) }; parameters[0].Value = model.CardID; parameters[1].Value = model.CardSector; parameters[2].Value = model.PriceTypeID; parameters[3].Value = model.PriceTypeName; parameters[4].Value = model.Price; parameters[5].Value = model.OperMoney; parameters[6].Value = model.OperInt; parameters[7].Value = model.OperZS; parameters[8].Value = model.FactMoney; parameters[9].Value = model.LastBalance; parameters[10].Value = model.CurrentBalance; parameters[11].Value = model.TotalMoney; parameters[12].Value = model.TotalInt; parameters[13].Value = model.TotalBase; parameters[14].Value = model.OperType; parameters[15].Value = model.PayType; parameters[16].Value = model.InvoiceCode; parameters[17].Value = model.MeterID; parameters[18].Value = model.OperatorID; parameters[19].Value = model.SiteID; parameters[20].Value = model.FactoryNum; parameters[21].Value = model.Remark; parameters[22].Value = model.RedOperId; parameters[23].Value = model.OperNum; parameters[24].Value = model.Price2; parameters[25].Value = model.Price3; parameters[26].Value = model.Divid1; parameters[27].Value = model.Divid2; parameters[28].Value = model.UseNumber1; parameters[29].Value = model.UseNumber2; parameters[30].Value = model.UseNumber3; parameters[31].Value = model.CurTotalBuyNumber; parameters[32].Value = model.InvoiceID; parameters[33].Value = model.InvoiceType; parameters[34].Value = model.WriteCardFlag; parameters[35].Value = model.TransactionId; parameters[36].Value = model.PayWay; parameters[37].Value = model.OutTradeNo; parameters[38].Value = model.DepositDate; parameters[39].Value = model.DiscountsNum; parameters[40].Value = model.OperID; parameters[41].Value = model.OperDate; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }