public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtOperType.Text.Trim().Length == 0) { strErr += "业务类型不能为空!\\n"; } if (!PageValidate.IsDateTime(txtOperDate.Text)) { strErr += "业务日期格式错误!\\n"; } if (!PageValidate.IsNumber(txtMeterIDOld.Text)) { strErr += "老表ID格式错误!\\n"; } if (!PageValidate.IsNumber(txtMeterIDNew.Text)) { strErr += "新表ID格式错误!\\n"; } if (!PageValidate.IsDecimal(txtUseNumberOld.Text)) { strErr += "UseNumberOld格式错误!\\n"; } if (!PageValidate.IsNumber(txtStatFlag.Text)) { strErr += "StatFlag格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int OperID = int.Parse(this.lblOperID.Text); string OperType = this.txtOperType.Text; DateTime OperDate = DateTime.Parse(this.txtOperDate.Text); int MeterIDOld = int.Parse(this.txtMeterIDOld.Text); int MeterIDNew = int.Parse(this.txtMeterIDNew.Text); decimal UseNumberOld = decimal.Parse(this.txtUseNumberOld.Text); int StatFlag = int.Parse(this.txtStatFlag.Text); WebDemo.Model.WebDemo.MeterOperation model = new WebDemo.Model.WebDemo.MeterOperation(); model.OperID = OperID; model.OperType = OperType; model.OperDate = OperDate; model.MeterIDOld = MeterIDOld; model.MeterIDNew = MeterIDNew; model.UseNumberOld = UseNumberOld; model.StatFlag = StatFlag; WebDemo.BLL.WebDemo.MeterOperation bll = new WebDemo.BLL.WebDemo.MeterOperation(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
private void ShowInfo(int OperID) { WebDemo.BLL.WebDemo.MeterOperation bll = new WebDemo.BLL.WebDemo.MeterOperation(); WebDemo.Model.WebDemo.MeterOperation model = bll.GetModel(OperID); this.lblOperID.Text = model.OperID.ToString(); this.lblOperType.Text = model.OperType; this.lblOperDate.Text = model.OperDate.ToString(); this.lblMeterIDOld.Text = model.MeterIDOld.ToString(); this.lblMeterIDNew.Text = model.MeterIDNew.ToString(); this.lblUseNumberOld.Text = model.UseNumberOld.ToString(); this.lblStatFlag.Text = model.StatFlag.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.MeterOperation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MeterOperation set "); strSql.Append("OperType=@OperType,"); strSql.Append("OperDate=@OperDate,"); strSql.Append("MeterIDOld=@MeterIDOld,"); strSql.Append("MeterIDNew=@MeterIDNew,"); strSql.Append("UseNumberOld=@UseNumberOld,"); strSql.Append("StatFlag=@StatFlag"); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@OperType", SqlDbType.VarChar, 50), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@MeterIDOld", SqlDbType.Int, 4), new SqlParameter("@MeterIDNew", SqlDbType.Int, 4), new SqlParameter("@UseNumberOld", SqlDbType.Decimal, 9), new SqlParameter("@StatFlag", SqlDbType.Int, 4), new SqlParameter("@OperID", SqlDbType.Int, 4) }; parameters[0].Value = model.OperType; parameters[1].Value = model.OperDate; parameters[2].Value = model.MeterIDOld; parameters[3].Value = model.MeterIDNew; parameters[4].Value = model.UseNumberOld; parameters[5].Value = model.StatFlag; parameters[6].Value = model.OperID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.MeterOperation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MeterOperation("); strSql.Append("OperType,OperDate,MeterIDOld,MeterIDNew,UseNumberOld,StatFlag)"); strSql.Append(" values ("); strSql.Append("@OperType,@OperDate,@MeterIDOld,@MeterIDNew,@UseNumberOld,@StatFlag)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@OperType", SqlDbType.VarChar, 50), new SqlParameter("@OperDate", SqlDbType.DateTime), new SqlParameter("@MeterIDOld", SqlDbType.Int, 4), new SqlParameter("@MeterIDNew", SqlDbType.Int, 4), new SqlParameter("@UseNumberOld", SqlDbType.Decimal, 9), new SqlParameter("@StatFlag", SqlDbType.Int, 4) }; parameters[0].Value = model.OperType; parameters[1].Value = model.OperDate; parameters[2].Value = model.MeterIDOld; parameters[3].Value = model.MeterIDNew; parameters[4].Value = model.UseNumberOld; parameters[5].Value = model.StatFlag; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.MeterOperation DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.MeterOperation model = new WebDemo.Model.WebDemo.MeterOperation(); if (row != null) { if (row["OperID"] != null && row["OperID"].ToString() != "") { model.OperID = int.Parse(row["OperID"].ToString()); } if (row["OperType"] != null) { model.OperType = row["OperType"].ToString(); } if (row["OperDate"] != null && row["OperDate"].ToString() != "") { model.OperDate = DateTime.Parse(row["OperDate"].ToString()); } if (row["MeterIDOld"] != null && row["MeterIDOld"].ToString() != "") { model.MeterIDOld = int.Parse(row["MeterIDOld"].ToString()); } if (row["MeterIDNew"] != null && row["MeterIDNew"].ToString() != "") { model.MeterIDNew = int.Parse(row["MeterIDNew"].ToString()); } if (row["UseNumberOld"] != null && row["UseNumberOld"].ToString() != "") { model.UseNumberOld = decimal.Parse(row["UseNumberOld"].ToString()); } if (row["StatFlag"] != null && row["StatFlag"].ToString() != "") { model.StatFlag = int.Parse(row["StatFlag"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.MeterOperation GetModel(int OperID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OperID,OperType,OperDate,MeterIDOld,MeterIDNew,UseNumberOld,StatFlag from MeterOperation "); strSql.Append(" where OperID=@OperID"); SqlParameter[] parameters = { new SqlParameter("@OperID", SqlDbType.Int, 4) }; parameters[0].Value = OperID; WebDemo.Model.WebDemo.MeterOperation model = new WebDemo.Model.WebDemo.MeterOperation(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }