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);
}
}
