private void ShowInfo(int BatchId) { WebDemo.BLL.WebDemo.InvoiceRangeInfo bll = new WebDemo.BLL.WebDemo.InvoiceRangeInfo(); WebDemo.Model.WebDemo.InvoiceRangeInfo model = bll.GetModel(BatchId); this.lblBatchId.Text = model.BatchId.ToString(); this.lblInCode.Text = model.InCode; this.lblStartNum.Text = model.StartNum; this.lblEndNum.Text = model.EndNum; this.lblOperatorName.Text = model.OperatorName; this.lblGetDateTime.Text = model.GetDateTime.ToString(); this.lblInDate.Text = model.InDate.ToString(); this.lblSiteID.Text = model.SiteID.ToString(); this.lblRemark.Text = model.Remark; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.InvoiceRangeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update InvoiceRangeInfo set "); strSql.Append("InCode=@InCode,"); strSql.Append("StartNum=@StartNum,"); strSql.Append("EndNum=@EndNum,"); strSql.Append("OperatorName=@OperatorName,"); strSql.Append("GetDateTime=@GetDateTime,"); strSql.Append("InDate=@InDate,"); strSql.Append("SiteID=@SiteID,"); strSql.Append("Remark=@Remark"); strSql.Append(" where BatchId=@BatchId"); SqlParameter[] parameters = { new SqlParameter("@InCode", SqlDbType.VarChar, 50), new SqlParameter("@StartNum", SqlDbType.VarChar, 50), new SqlParameter("@EndNum", SqlDbType.VarChar, 50), new SqlParameter("@OperatorName", SqlDbType.VarChar, 50), new SqlParameter("@GetDateTime", SqlDbType.DateTime), new SqlParameter("@InDate", SqlDbType.DateTime), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 200), new SqlParameter("@BatchId", SqlDbType.Int, 4) }; parameters[0].Value = model.InCode; parameters[1].Value = model.StartNum; parameters[2].Value = model.EndNum; parameters[3].Value = model.OperatorName; parameters[4].Value = model.GetDateTime; parameters[5].Value = model.InDate; parameters[6].Value = model.SiteID; parameters[7].Value = model.Remark; parameters[8].Value = model.BatchId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.InvoiceRangeInfo DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.InvoiceRangeInfo model = new WebDemo.Model.WebDemo.InvoiceRangeInfo(); if (row != null) { if (row["BatchId"] != null && row["BatchId"].ToString() != "") { model.BatchId = int.Parse(row["BatchId"].ToString()); } if (row["InCode"] != null) { model.InCode = row["InCode"].ToString(); } if (row["StartNum"] != null) { model.StartNum = row["StartNum"].ToString(); } if (row["EndNum"] != null) { model.EndNum = row["EndNum"].ToString(); } if (row["OperatorName"] != null) { model.OperatorName = row["OperatorName"].ToString(); } if (row["GetDateTime"] != null && row["GetDateTime"].ToString() != "") { model.GetDateTime = DateTime.Parse(row["GetDateTime"].ToString()); } if (row["InDate"] != null && row["InDate"].ToString() != "") { model.InDate = DateTime.Parse(row["InDate"].ToString()); } if (row["SiteID"] != null && row["SiteID"].ToString() != "") { model.SiteID = int.Parse(row["SiteID"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.InvoiceRangeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into InvoiceRangeInfo("); strSql.Append("InCode,StartNum,EndNum,OperatorName,GetDateTime,InDate,SiteID,Remark)"); strSql.Append(" values ("); strSql.Append("@InCode,@StartNum,@EndNum,@OperatorName,@GetDateTime,@InDate,@SiteID,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@InCode", SqlDbType.VarChar, 50), new SqlParameter("@StartNum", SqlDbType.VarChar, 50), new SqlParameter("@EndNum", SqlDbType.VarChar, 50), new SqlParameter("@OperatorName", SqlDbType.VarChar, 50), new SqlParameter("@GetDateTime", SqlDbType.DateTime), new SqlParameter("@InDate", SqlDbType.DateTime), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 200) }; parameters[0].Value = model.InCode; parameters[1].Value = model.StartNum; parameters[2].Value = model.EndNum; parameters[3].Value = model.OperatorName; parameters[4].Value = model.GetDateTime; parameters[5].Value = model.InDate; parameters[6].Value = model.SiteID; parameters[7].Value = model.Remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.InvoiceRangeInfo GetModel(int BatchId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 BatchId,InCode,StartNum,EndNum,OperatorName,GetDateTime,InDate,SiteID,Remark from InvoiceRangeInfo "); strSql.Append(" where BatchId=@BatchId"); SqlParameter[] parameters = { new SqlParameter("@BatchId", SqlDbType.Int, 4) }; parameters[0].Value = BatchId; WebDemo.Model.WebDemo.InvoiceRangeInfo model = new WebDemo.Model.WebDemo.InvoiceRangeInfo(); 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 (this.txtInCode.Text.Trim().Length == 0) { strErr += "InCode不能为空!\\n"; } if (this.txtStartNum.Text.Trim().Length == 0) { strErr += "StartNum不能为空!\\n"; } if (this.txtEndNum.Text.Trim().Length == 0) { strErr += "EndNum不能为空!\\n"; } if (this.txtOperatorName.Text.Trim().Length == 0) { strErr += "OperatorName不能为空!\\n"; } if (!PageValidate.IsDateTime(txtGetDateTime.Text)) { strErr += "GetDateTime格式错误!\\n"; } if (!PageValidate.IsDateTime(txtInDate.Text)) { strErr += "InDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtSiteID.Text)) { strErr += "SiteID格式错误!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "Remark不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string InCode = this.txtInCode.Text; string StartNum = this.txtStartNum.Text; string EndNum = this.txtEndNum.Text; string OperatorName = this.txtOperatorName.Text; DateTime GetDateTime = DateTime.Parse(this.txtGetDateTime.Text); DateTime InDate = DateTime.Parse(this.txtInDate.Text); int SiteID = int.Parse(this.txtSiteID.Text); string Remark = this.txtRemark.Text; WebDemo.Model.WebDemo.InvoiceRangeInfo model = new WebDemo.Model.WebDemo.InvoiceRangeInfo(); model.InCode = InCode; model.StartNum = StartNum; model.EndNum = EndNum; model.OperatorName = OperatorName; model.GetDateTime = GetDateTime; model.InDate = InDate; model.SiteID = SiteID; model.Remark = Remark; WebDemo.BLL.WebDemo.InvoiceRangeInfo bll = new WebDemo.BLL.WebDemo.InvoiceRangeInfo(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }