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