/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.EInvoices model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into EInvoices("); strSql.Append("OperID,OperType,InvoiceNumber,OrderNo,MeterID,OperMoney,FactMoney,InvoiceState,OperDate,URL,CreateDate,OperatorID,InvoiceCode,RtnInvoiceNumber,ManualRegist,RedSaleURL,RSInvoiceNumber,RegistDate)"); strSql.Append(" values ("); strSql.Append("@OperID,@OperType,@InvoiceNumber,@OrderNo,@MeterID,@OperMoney,@FactMoney,@InvoiceState,@OperDate,@URL,@CreateDate,@OperatorID,@InvoiceCode,@RtnInvoiceNumber,@ManualRegist,@RedSaleURL,@RSInvoiceNumber,@RegistDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4), new SqlParameter("@OperType", SqlDbType.Int, 4), new SqlParameter("@InvoiceNumber", SqlDbType.NVarChar, 50), new SqlParameter("@OrderNo", SqlDbType.NVarChar, 20), new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@OperMoney", SqlDbType.Decimal, 9), new SqlParameter("@FactMoney", SqlDbType.Decimal, 9), new SqlParameter("@InvoiceState", SqlDbType.Int, 4), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@URL", SqlDbType.NVarChar, 100), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@InvoiceCode", SqlDbType.VarChar, 12), new SqlParameter("@RtnInvoiceNumber", SqlDbType.VarChar, 12), new SqlParameter("@ManualRegist", SqlDbType.Int, 4), new SqlParameter("@RedSaleURL", SqlDbType.NVarChar, 100), new SqlParameter("@RSInvoiceNumber", SqlDbType.NVarChar, 50), new SqlParameter("@RegistDate", SqlDbType.DateTime) }; parameters[0].Value = model.OperID; parameters[1].Value = model.OperType; parameters[2].Value = model.InvoiceNumber; parameters[3].Value = model.OrderNo; parameters[4].Value = model.MeterID; parameters[5].Value = model.OperMoney; parameters[6].Value = model.FactMoney; parameters[7].Value = model.InvoiceState; parameters[8].Value = model.OperDate; parameters[9].Value = model.URL; parameters[10].Value = model.CreateDate; parameters[11].Value = model.OperatorID; parameters[12].Value = model.InvoiceCode; parameters[13].Value = model.RtnInvoiceNumber; parameters[14].Value = model.ManualRegist; parameters[15].Value = model.RedSaleURL; parameters[16].Value = model.RSInvoiceNumber; parameters[17].Value = model.RegistDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void ShowInfo(int ID) { WebDemo.BLL.WebDemo.EInvoices bll = new WebDemo.BLL.WebDemo.EInvoices(); WebDemo.Model.WebDemo.EInvoices model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.lblOperID.Text = model.OperID.ToString(); this.lblOperType.Text = model.OperType.ToString(); this.lblInvoiceNumber.Text = model.InvoiceNumber; this.lblOrderNo.Text = model.OrderNo; this.lblMeterID.Text = model.MeterID.ToString(); this.lblOperMoney.Text = model.OperMoney.ToString(); this.lblFactMoney.Text = model.FactMoney.ToString(); this.lblInvoiceState.Text = model.InvoiceState.ToString(); this.lblOperDate.Text = model.OperDate.ToString(); this.lblURL.Text = model.URL; this.lblCreateDate.Text = model.CreateDate.ToString(); this.lblOperatorID.Text = model.OperatorID.ToString(); this.lblInvoiceCode.Text = model.InvoiceCode; this.lblRtnInvoiceNumber.Text = model.RtnInvoiceNumber; this.lblManualRegist.Text = model.ManualRegist.ToString(); this.lblRedSaleURL.Text = model.RedSaleURL; this.lblRSInvoiceNumber.Text = model.RSInvoiceNumber; this.lblRegistDate.Text = model.RegistDate.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.EInvoices GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,OperID,OperType,InvoiceNumber,OrderNo,MeterID,OperMoney,FactMoney,InvoiceState,OperDate,URL,CreateDate,OperatorID,InvoiceCode,RtnInvoiceNumber,ManualRegist,RedSaleURL,RSInvoiceNumber,RegistDate from EInvoices "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; WebDemo.Model.WebDemo.EInvoices model = new WebDemo.Model.WebDemo.EInvoices(); 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(txtOperID.Text)) { strErr += "OperID格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperType.Text)) { strErr += "OperType格式错误!\\n"; } if (this.txtInvoiceNumber.Text.Trim().Length == 0) { strErr += "InvoiceNumber不能为空!\\n"; } if (this.txtOrderNo.Text.Trim().Length == 0) { strErr += "OrderNo不能为空!\\n"; } if (!PageValidate.IsNumber(txtMeterID.Text)) { strErr += "MeterID格式错误!\\n"; } if (!PageValidate.IsDecimal(txtOperMoney.Text)) { strErr += "OperMoney格式错误!\\n"; } if (!PageValidate.IsDecimal(txtFactMoney.Text)) { strErr += "FactMoney格式错误!\\n"; } if (!PageValidate.IsNumber(txtInvoiceState.Text)) { strErr += "InvoiceState格式错误!\\n"; } if (!PageValidate.IsDateTime(txtOperDate.Text)) { strErr += "OperDate格式错误!\\n"; } if (this.txtURL.Text.Trim().Length == 0) { strErr += "URL不能为空!\\n"; } if (!PageValidate.IsDateTime(txtCreateDate.Text)) { strErr += "CreateDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtOperatorID.Text)) { strErr += "OperatorID格式错误!\\n"; } if (this.txtInvoiceCode.Text.Trim().Length == 0) { strErr += "InvoiceCode不能为空!\\n"; } if (this.txtRtnInvoiceNumber.Text.Trim().Length == 0) { strErr += "RtnInvoiceNumber不能为空!\\n"; } if (!PageValidate.IsNumber(txtManualRegist.Text)) { strErr += "ManualRegist格式错误!\\n"; } if (this.txtRedSaleURL.Text.Trim().Length == 0) { strErr += "RedSaleURL不能为空!\\n"; } if (this.txtRSInvoiceNumber.Text.Trim().Length == 0) { strErr += "RSInvoiceNumber不能为空!\\n"; } if (!PageValidate.IsDateTime(txtRegistDate.Text)) { strErr += "RegistDate格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int ID = int.Parse(this.lblID.Text); int OperID = int.Parse(this.txtOperID.Text); int OperType = int.Parse(this.txtOperType.Text); string InvoiceNumber = this.txtInvoiceNumber.Text; string OrderNo = this.txtOrderNo.Text; int MeterID = int.Parse(this.txtMeterID.Text); decimal OperMoney = decimal.Parse(this.txtOperMoney.Text); decimal FactMoney = decimal.Parse(this.txtFactMoney.Text); int InvoiceState = int.Parse(this.txtInvoiceState.Text); DateTime OperDate = DateTime.Parse(this.txtOperDate.Text); string URL = this.txtURL.Text; DateTime CreateDate = DateTime.Parse(this.txtCreateDate.Text); int OperatorID = int.Parse(this.txtOperatorID.Text); string InvoiceCode = this.txtInvoiceCode.Text; string RtnInvoiceNumber = this.txtRtnInvoiceNumber.Text; int ManualRegist = int.Parse(this.txtManualRegist.Text); string RedSaleURL = this.txtRedSaleURL.Text; string RSInvoiceNumber = this.txtRSInvoiceNumber.Text; DateTime RegistDate = DateTime.Parse(this.txtRegistDate.Text); WebDemo.Model.WebDemo.EInvoices model = new WebDemo.Model.WebDemo.EInvoices(); model.ID = ID; model.OperID = OperID; model.OperType = OperType; model.InvoiceNumber = InvoiceNumber; model.OrderNo = OrderNo; model.MeterID = MeterID; model.OperMoney = OperMoney; model.FactMoney = FactMoney; model.InvoiceState = InvoiceState; model.OperDate = OperDate; model.URL = URL; model.CreateDate = CreateDate; model.OperatorID = OperatorID; model.InvoiceCode = InvoiceCode; model.RtnInvoiceNumber = RtnInvoiceNumber; model.ManualRegist = ManualRegist; model.RedSaleURL = RedSaleURL; model.RSInvoiceNumber = RSInvoiceNumber; model.RegistDate = RegistDate; WebDemo.BLL.WebDemo.EInvoices bll = new WebDemo.BLL.WebDemo.EInvoices(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.EInvoices DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.EInvoices model = new WebDemo.Model.WebDemo.EInvoices(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["OperID"] != null && row["OperID"].ToString() != "") { model.OperID = int.Parse(row["OperID"].ToString()); } if (row["OperType"] != null && row["OperType"].ToString() != "") { model.OperType = int.Parse(row["OperType"].ToString()); } if (row["InvoiceNumber"] != null) { model.InvoiceNumber = row["InvoiceNumber"].ToString(); } if (row["OrderNo"] != null) { model.OrderNo = row["OrderNo"].ToString(); } if (row["MeterID"] != null && row["MeterID"].ToString() != "") { model.MeterID = int.Parse(row["MeterID"].ToString()); } if (row["OperMoney"] != null && row["OperMoney"].ToString() != "") { model.OperMoney = decimal.Parse(row["OperMoney"].ToString()); } if (row["FactMoney"] != null && row["FactMoney"].ToString() != "") { model.FactMoney = decimal.Parse(row["FactMoney"].ToString()); } if (row["InvoiceState"] != null && row["InvoiceState"].ToString() != "") { model.InvoiceState = int.Parse(row["InvoiceState"].ToString()); } if (row["OperDate"] != null && row["OperDate"].ToString() != "") { model.OperDate = DateTime.Parse(row["OperDate"].ToString()); } if (row["URL"] != null) { model.URL = row["URL"].ToString(); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["OperatorID"] != null && row["OperatorID"].ToString() != "") { model.OperatorID = int.Parse(row["OperatorID"].ToString()); } if (row["InvoiceCode"] != null) { model.InvoiceCode = row["InvoiceCode"].ToString(); } if (row["RtnInvoiceNumber"] != null) { model.RtnInvoiceNumber = row["RtnInvoiceNumber"].ToString(); } if (row["ManualRegist"] != null && row["ManualRegist"].ToString() != "") { model.ManualRegist = int.Parse(row["ManualRegist"].ToString()); } if (row["RedSaleURL"] != null) { model.RedSaleURL = row["RedSaleURL"].ToString(); } if (row["RSInvoiceNumber"] != null) { model.RSInvoiceNumber = row["RSInvoiceNumber"].ToString(); } if (row["RegistDate"] != null && row["RegistDate"].ToString() != "") { model.RegistDate = DateTime.Parse(row["RegistDate"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.EInvoices model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update EInvoices set "); strSql.Append("OperID=@OperID,"); strSql.Append("OperType=@OperType,"); strSql.Append("InvoiceNumber=@InvoiceNumber,"); strSql.Append("OrderNo=@OrderNo,"); strSql.Append("MeterID=@MeterID,"); strSql.Append("OperMoney=@OperMoney,"); strSql.Append("FactMoney=@FactMoney,"); strSql.Append("InvoiceState=@InvoiceState,"); strSql.Append("OperDate=@OperDate,"); strSql.Append("URL=@URL,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("OperatorID=@OperatorID,"); strSql.Append("InvoiceCode=@InvoiceCode,"); strSql.Append("RtnInvoiceNumber=@RtnInvoiceNumber,"); strSql.Append("ManualRegist=@ManualRegist,"); strSql.Append("RedSaleURL=@RedSaleURL,"); strSql.Append("RSInvoiceNumber=@RSInvoiceNumber,"); strSql.Append("RegistDate=@RegistDate"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4), new SqlParameter("@OperType", SqlDbType.Int, 4), new SqlParameter("@InvoiceNumber", SqlDbType.NVarChar, 50), new SqlParameter("@OrderNo", SqlDbType.NVarChar, 20), new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@OperMoney", SqlDbType.Decimal, 9), new SqlParameter("@FactMoney", SqlDbType.Decimal, 9), new SqlParameter("@InvoiceState", SqlDbType.Int, 4), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@URL", SqlDbType.NVarChar, 100), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@InvoiceCode", SqlDbType.VarChar, 12), new SqlParameter("@RtnInvoiceNumber", SqlDbType.VarChar, 12), new SqlParameter("@ManualRegist", SqlDbType.Int, 4), new SqlParameter("@RedSaleURL", SqlDbType.NVarChar, 100), new SqlParameter("@RSInvoiceNumber", SqlDbType.NVarChar, 50), new SqlParameter("@RegistDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.OperID; parameters[1].Value = model.OperType; parameters[2].Value = model.InvoiceNumber; parameters[3].Value = model.OrderNo; parameters[4].Value = model.MeterID; parameters[5].Value = model.OperMoney; parameters[6].Value = model.FactMoney; parameters[7].Value = model.InvoiceState; parameters[8].Value = model.OperDate; parameters[9].Value = model.URL; parameters[10].Value = model.CreateDate; parameters[11].Value = model.OperatorID; parameters[12].Value = model.InvoiceCode; parameters[13].Value = model.RtnInvoiceNumber; parameters[14].Value = model.ManualRegist; parameters[15].Value = model.RedSaleURL; parameters[16].Value = model.RSInvoiceNumber; parameters[17].Value = model.RegistDate; parameters[18].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }