/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.CheckInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CheckInfo("); strSql.Append("MeterID,CheckDate,CheckWorker,CheckInfo,CheckMark)"); strSql.Append(" values ("); strSql.Append("@MeterID,@CheckDate,@CheckWorker,@CheckInfo,@CheckMark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@CheckDate", SqlDbType.DateTime), new SqlParameter("@CheckWorker", SqlDbType.VarChar, 50), new SqlParameter("@CheckInfo", SqlDbType.VarChar, 50), new SqlParameter("@CheckMark", SqlDbType.Int, 4) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.CheckDate; parameters[2].Value = model.CheckWorker; parameters[3].Value = model.CheckInfo; parameters[4].Value = model.CheckMark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.CheckInfo DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.CheckInfo model = new WebDemo.Model.WebDemo.CheckInfo(); if (row != null) { if (row["FID"] != null && row["FID"].ToString() != "") { model.FID = int.Parse(row["FID"].ToString()); } if (row["MeterID"] != null && row["MeterID"].ToString() != "") { model.MeterID = int.Parse(row["MeterID"].ToString()); } if (row["CheckDate"] != null && row["CheckDate"].ToString() != "") { model.CheckDate = DateTime.Parse(row["CheckDate"].ToString()); } if (row["CheckWorker"] != null) { model.CheckWorker = row["CheckWorker"].ToString(); } if (row["CheckInfo"] != null) { model.CheckInfo = row["CheckInfo"].ToString(); } if (row["CheckMark"] != null && row["CheckMark"].ToString() != "") { model.CheckMark = int.Parse(row["CheckMark"].ToString()); } } return(model); }
private void ShowInfo(int FID) { WebDemo.BLL.WebDemo.CheckInfo bll = new WebDemo.BLL.WebDemo.CheckInfo(); WebDemo.Model.WebDemo.CheckInfo model = bll.GetModel(FID); this.lblFID.Text = model.FID.ToString(); this.lblMeterID.Text = model.MeterID.ToString(); this.lblCheckDate.Text = model.CheckDate.ToString(); this.lblCheckWorker.Text = model.CheckWorker; this.lblCheckInfo.Text = model.CheckInfo; this.lblCheckMark.Text = model.CheckMark.ToString(); }
public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtMeterID.Text)) { strErr+="MeterID格式错误!\\n"; } if(!PageValidate.IsDateTime(txtCheckDate.Text)) { strErr+="CheckDate格式错误!\\n"; } if(this.txtCheckWorker.Text.Trim().Length==0) { strErr+="CheckWorker不能为空!\\n"; } if(this.txtCheckInfo.Text.Trim().Length==0) { strErr+="CheckInfo不能为空!\\n"; } if(!PageValidate.IsNumber(txtCheckMark.Text)) { strErr+="CheckMark格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int FID=int.Parse(this.lblFID.Text); int MeterID=int.Parse(this.txtMeterID.Text); DateTime CheckDate=DateTime.Parse(this.txtCheckDate.Text); string CheckWorker=this.txtCheckWorker.Text; string CheckInfo=this.txtCheckInfo.Text; int CheckMark=int.Parse(this.txtCheckMark.Text); WebDemo.Model.WebDemo.CheckInfo model=new WebDemo.Model.WebDemo.CheckInfo(); model.FID=FID; model.MeterID=MeterID; model.CheckDate=CheckDate; model.CheckWorker=CheckWorker; model.CheckInfo=CheckInfo; model.CheckMark=CheckMark; WebDemo.BLL.WebDemo.CheckInfo bll=new WebDemo.BLL.WebDemo.CheckInfo(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.CheckInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CheckInfo set "); strSql.Append("MeterID=@MeterID,"); strSql.Append("CheckDate=@CheckDate,"); strSql.Append("CheckWorker=@CheckWorker,"); strSql.Append("CheckInfo=@CheckInfo,"); strSql.Append("CheckMark=@CheckMark"); strSql.Append(" where FID=@FID"); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.Int, 4), new SqlParameter("@CheckDate", SqlDbType.DateTime), new SqlParameter("@CheckWorker", SqlDbType.VarChar, 50), new SqlParameter("@CheckInfo", SqlDbType.VarChar, 50), new SqlParameter("@CheckMark", SqlDbType.Int, 4), new SqlParameter("@FID", SqlDbType.Int, 4) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.CheckDate; parameters[2].Value = model.CheckWorker; parameters[3].Value = model.CheckInfo; parameters[4].Value = model.CheckMark; parameters[5].Value = model.FID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.CheckInfo GetModel(int FID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 FID,MeterID,CheckDate,CheckWorker,CheckInfo,CheckMark from CheckInfo "); strSql.Append(" where FID=@FID"); SqlParameter[] parameters = { new SqlParameter("@FID", SqlDbType.Int, 4) }; parameters[0].Value = FID; WebDemo.Model.WebDemo.CheckInfo model = new WebDemo.Model.WebDemo.CheckInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }