/// <summary> /// 增加一条数据 /// </summary> public bool Add(WebDemo.Model.WebDemo.InvoiceList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into InvoiceList("); strSql.Append("InID,InCode,InNumber,SiteID,OperatorName,GetDate,PayID,PrintDate,InMoney,InMark,SendMark,SendDate,printMan,zfDate,zfInCode,zfInNumber,UName)"); strSql.Append(" values ("); strSql.Append("@InID,@InCode,@InNumber,@SiteID,@OperatorName,@GetDate,@PayID,@PrintDate,@InMoney,@InMark,@SendMark,@SendDate,@printMan,@zfDate,@zfInCode,@zfInNumber,@UName)"); SqlParameter[] parameters = { new SqlParameter("@InID", SqlDbType.Int, 4), new SqlParameter("@InCode", SqlDbType.VarChar, 20), new SqlParameter("@InNumber", SqlDbType.Int, 4), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@OperatorName", SqlDbType.VarChar, 50), new SqlParameter("@GetDate", SqlDbType.DateTime), new SqlParameter("@PayID", SqlDbType.Int, 4), new SqlParameter("@PrintDate", SqlDbType.DateTime), new SqlParameter("@InMoney", SqlDbType.Decimal, 9), new SqlParameter("@InMark", SqlDbType.Int, 4), new SqlParameter("@SendMark", SqlDbType.Int, 4), new SqlParameter("@SendDate", SqlDbType.DateTime), new SqlParameter("@printMan", SqlDbType.VarChar, 50), new SqlParameter("@zfDate", SqlDbType.DateTime), new SqlParameter("@zfInCode", SqlDbType.VarChar, 20), new SqlParameter("@zfInNumber", SqlDbType.VarChar, 20), new SqlParameter("@UName", SqlDbType.VarChar, 60) }; parameters[0].Value = model.InID; parameters[1].Value = model.InCode; parameters[2].Value = model.InNumber; parameters[3].Value = model.SiteID; parameters[4].Value = model.OperatorName; parameters[5].Value = model.GetDate; parameters[6].Value = model.PayID; parameters[7].Value = model.PrintDate; parameters[8].Value = model.InMoney; parameters[9].Value = model.InMark; parameters[10].Value = model.SendMark; parameters[11].Value = model.SendDate; parameters[12].Value = model.printMan; parameters[13].Value = model.zfDate; parameters[14].Value = model.zfInCode; parameters[15].Value = model.zfInNumber; parameters[16].Value = model.UName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int InID) { WebDemo.BLL.WebDemo.InvoiceList bll = new WebDemo.BLL.WebDemo.InvoiceList(); WebDemo.Model.WebDemo.InvoiceList model = bll.GetModel(InID); this.lblInID.Text = model.InID.ToString(); this.lblInCode.Text = model.InCode; this.lblInNumber.Text = model.InNumber.ToString(); this.lblSiteID.Text = model.SiteID.ToString(); this.lblOperatorName.Text = model.OperatorName; this.lblGetDate.Text = model.GetDate.ToString(); this.lblPayID.Text = model.PayID.ToString(); this.lblPrintDate.Text = model.PrintDate.ToString(); this.lblInMoney.Text = model.InMoney.ToString(); this.lblInMark.Text = model.InMark.ToString(); this.lblSendMark.Text = model.SendMark.ToString(); this.lblSendDate.Text = model.SendDate.ToString(); this.lblprintMan.Text = model.printMan; this.lblzfDate.Text = model.zfDate.ToString(); this.lblzfInCode.Text = model.zfInCode; this.lblzfInNumber.Text = model.zfInNumber; this.lblUName.Text = model.UName; }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.InvoiceList GetModel(int InID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 InID,InCode,InNumber,SiteID,OperatorName,GetDate,PayID,PrintDate,InMoney,InMark,SendMark,SendDate,printMan,zfDate,zfInCode,zfInNumber,UName from InvoiceList "); strSql.Append(" where InID=@InID "); SqlParameter[] parameters = { new SqlParameter("@InID", SqlDbType.Int, 4) }; parameters[0].Value = InID; WebDemo.Model.WebDemo.InvoiceList model = new WebDemo.Model.WebDemo.InvoiceList(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtInID.Text)) { strErr += "InID格式错误!\\n"; } if (this.txtInCode.Text.Trim().Length == 0) { strErr += "InCode不能为空!\\n"; } if (!PageValidate.IsNumber(txtInNumber.Text)) { strErr += "InNumber格式错误!\\n"; } if (!PageValidate.IsNumber(txtSiteID.Text)) { strErr += "SiteID格式错误!\\n"; } if (this.txtOperatorName.Text.Trim().Length == 0) { strErr += "OperatorName不能为空!\\n"; } if (!PageValidate.IsDateTime(txtGetDate.Text)) { strErr += "GetDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtPayID.Text)) { strErr += "PayID格式错误!\\n"; } if (!PageValidate.IsDateTime(txtPrintDate.Text)) { strErr += "PrintDate格式错误!\\n"; } if (!PageValidate.IsDecimal(txtInMoney.Text)) { strErr += "InMoney格式错误!\\n"; } if (!PageValidate.IsNumber(txtInMark.Text)) { strErr += "InMark格式错误!\\n"; } if (!PageValidate.IsNumber(txtSendMark.Text)) { strErr += "SendMark格式错误!\\n"; } if (!PageValidate.IsDateTime(txtSendDate.Text)) { strErr += "SendDate格式错误!\\n"; } if (this.txtprintMan.Text.Trim().Length == 0) { strErr += "printMan不能为空!\\n"; } if (!PageValidate.IsDateTime(txtzfDate.Text)) { strErr += "zfDate格式错误!\\n"; } if (this.txtzfInCode.Text.Trim().Length == 0) { strErr += "zfInCode不能为空!\\n"; } if (this.txtzfInNumber.Text.Trim().Length == 0) { strErr += "zfInNumber不能为空!\\n"; } if (this.txtUName.Text.Trim().Length == 0) { strErr += "UName不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int InID = int.Parse(this.txtInID.Text); string InCode = this.txtInCode.Text; int InNumber = int.Parse(this.txtInNumber.Text); int SiteID = int.Parse(this.txtSiteID.Text); string OperatorName = this.txtOperatorName.Text; DateTime GetDate = DateTime.Parse(this.txtGetDate.Text); int PayID = int.Parse(this.txtPayID.Text); DateTime PrintDate = DateTime.Parse(this.txtPrintDate.Text); decimal InMoney = decimal.Parse(this.txtInMoney.Text); int InMark = int.Parse(this.txtInMark.Text); int SendMark = int.Parse(this.txtSendMark.Text); DateTime SendDate = DateTime.Parse(this.txtSendDate.Text); string printMan = this.txtprintMan.Text; DateTime zfDate = DateTime.Parse(this.txtzfDate.Text); string zfInCode = this.txtzfInCode.Text; string zfInNumber = this.txtzfInNumber.Text; string UName = this.txtUName.Text; WebDemo.Model.WebDemo.InvoiceList model = new WebDemo.Model.WebDemo.InvoiceList(); model.InID = InID; model.InCode = InCode; model.InNumber = InNumber; model.SiteID = SiteID; model.OperatorName = OperatorName; model.GetDate = GetDate; model.PayID = PayID; model.PrintDate = PrintDate; model.InMoney = InMoney; model.InMark = InMark; model.SendMark = SendMark; model.SendDate = SendDate; model.printMan = printMan; model.zfDate = zfDate; model.zfInCode = zfInCode; model.zfInNumber = zfInNumber; model.UName = UName; WebDemo.BLL.WebDemo.InvoiceList bll = new WebDemo.BLL.WebDemo.InvoiceList(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.InvoiceList DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.InvoiceList model = new WebDemo.Model.WebDemo.InvoiceList(); if (row != null) { if (row["InID"] != null && row["InID"].ToString() != "") { model.InID = int.Parse(row["InID"].ToString()); } if (row["InCode"] != null) { model.InCode = row["InCode"].ToString(); } if (row["InNumber"] != null && row["InNumber"].ToString() != "") { model.InNumber = int.Parse(row["InNumber"].ToString()); } if (row["SiteID"] != null && row["SiteID"].ToString() != "") { model.SiteID = int.Parse(row["SiteID"].ToString()); } if (row["OperatorName"] != null) { model.OperatorName = row["OperatorName"].ToString(); } if (row["GetDate"] != null && row["GetDate"].ToString() != "") { model.GetDate = DateTime.Parse(row["GetDate"].ToString()); } if (row["PayID"] != null && row["PayID"].ToString() != "") { model.PayID = int.Parse(row["PayID"].ToString()); } if (row["PrintDate"] != null && row["PrintDate"].ToString() != "") { model.PrintDate = DateTime.Parse(row["PrintDate"].ToString()); } if (row["InMoney"] != null && row["InMoney"].ToString() != "") { model.InMoney = decimal.Parse(row["InMoney"].ToString()); } if (row["InMark"] != null && row["InMark"].ToString() != "") { model.InMark = int.Parse(row["InMark"].ToString()); } if (row["SendMark"] != null && row["SendMark"].ToString() != "") { model.SendMark = int.Parse(row["SendMark"].ToString()); } if (row["SendDate"] != null && row["SendDate"].ToString() != "") { model.SendDate = DateTime.Parse(row["SendDate"].ToString()); } if (row["printMan"] != null) { model.printMan = row["printMan"].ToString(); } if (row["zfDate"] != null && row["zfDate"].ToString() != "") { model.zfDate = DateTime.Parse(row["zfDate"].ToString()); } if (row["zfInCode"] != null) { model.zfInCode = row["zfInCode"].ToString(); } if (row["zfInNumber"] != null) { model.zfInNumber = row["zfInNumber"].ToString(); } if (row["UName"] != null) { model.UName = row["UName"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.InvoiceList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update InvoiceList set "); strSql.Append("InCode=@InCode,"); strSql.Append("InNumber=@InNumber,"); strSql.Append("SiteID=@SiteID,"); strSql.Append("OperatorName=@OperatorName,"); strSql.Append("GetDate=@GetDate,"); strSql.Append("PayID=@PayID,"); strSql.Append("PrintDate=@PrintDate,"); strSql.Append("InMoney=@InMoney,"); strSql.Append("InMark=@InMark,"); strSql.Append("SendMark=@SendMark,"); strSql.Append("SendDate=@SendDate,"); strSql.Append("printMan=@printMan,"); strSql.Append("zfDate=@zfDate,"); strSql.Append("zfInCode=@zfInCode,"); strSql.Append("zfInNumber=@zfInNumber,"); strSql.Append("UName=@UName"); strSql.Append(" where InID=@InID "); SqlParameter[] parameters = { new SqlParameter("@InCode", SqlDbType.VarChar, 20), new SqlParameter("@InNumber", SqlDbType.Int, 4), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@OperatorName", SqlDbType.VarChar, 50), new SqlParameter("@GetDate", SqlDbType.DateTime), new SqlParameter("@PayID", SqlDbType.Int, 4), new SqlParameter("@PrintDate", SqlDbType.DateTime), new SqlParameter("@InMoney", SqlDbType.Decimal, 9), new SqlParameter("@InMark", SqlDbType.Int, 4), new SqlParameter("@SendMark", SqlDbType.Int, 4), new SqlParameter("@SendDate", SqlDbType.DateTime), new SqlParameter("@printMan", SqlDbType.VarChar, 50), new SqlParameter("@zfDate", SqlDbType.DateTime), new SqlParameter("@zfInCode", SqlDbType.VarChar, 20), new SqlParameter("@zfInNumber", SqlDbType.VarChar, 20), new SqlParameter("@UName", SqlDbType.VarChar, 60), new SqlParameter("@InID", SqlDbType.Int, 4) }; parameters[0].Value = model.InCode; parameters[1].Value = model.InNumber; parameters[2].Value = model.SiteID; parameters[3].Value = model.OperatorName; parameters[4].Value = model.GetDate; parameters[5].Value = model.PayID; parameters[6].Value = model.PrintDate; parameters[7].Value = model.InMoney; parameters[8].Value = model.InMark; parameters[9].Value = model.SendMark; parameters[10].Value = model.SendDate; parameters[11].Value = model.printMan; parameters[12].Value = model.zfDate; parameters[13].Value = model.zfInCode; parameters[14].Value = model.zfInNumber; parameters[15].Value = model.UName; parameters[16].Value = model.InID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }