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