/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.event1 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update event1 set "); strSql.Append("sta_time=@sta_time,"); strSql.Append("end_time=@end_time,"); strSql.Append("event_name=@event_name,"); strSql.Append("beizhu=@beizhu"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@sta_time", SqlDbType.DateTime), new SqlParameter("@end_time", SqlDbType.DateTime), new SqlParameter("@event_name", SqlDbType.NVarChar, 50), new SqlParameter("@beizhu", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.sta_time; parameters[1].Value = model.end_time; parameters[2].Value = model.event_name; parameters[3].Value = model.beizhu; parameters[4].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.event1 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into event1("); strSql.Append("sta_time,end_time,event_name,beizhu)"); strSql.Append(" values ("); strSql.Append("@sta_time,@end_time,@event_name,@beizhu)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@sta_time", SqlDbType.DateTime), new SqlParameter("@end_time", SqlDbType.DateTime), new SqlParameter("@event_name", SqlDbType.NVarChar, 50), new SqlParameter("@beizhu", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.sta_time; parameters[1].Value = model.end_time; parameters[2].Value = model.event_name; parameters[3].Value = model.beizhu; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.event1 DataRowToModel(DataRow row) { Maticsoft.Model.event1 model = new Maticsoft.Model.event1(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["sta_time"] != null && row["sta_time"].ToString() != "") { model.sta_time = DateTime.Parse(row["sta_time"].ToString()); } if (row["end_time"] != null && row["end_time"].ToString() != "") { model.end_time = DateTime.Parse(row["end_time"].ToString()); } if (row["event_name"] != null) { model.event_name = row["event_name"].ToString(); } if (row["beizhu"] != null) { model.beizhu = row["beizhu"].ToString(); } } return(model); }
private void ShowInfo(int id) { Maticsoft.BLL.event1 bll = new Maticsoft.BLL.event1(); Maticsoft.Model.event1 model = bll.GetModel(id); this.lblid.Text = model.id.ToString(); this.lblsta_time.Text = model.sta_time.ToString(); this.lblend_time.Text = model.end_time.ToString(); this.lblevent_name.Text = model.event_name; this.lblbeizhu.Text = model.beizhu; }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDateTime(txtsta_time.Text)) { strErr += "sta_time格式错误!\\n"; } if (!PageValidate.IsDateTime(txtend_time.Text)) { strErr += "end_time格式错误!\\n"; } if (this.txtevent_name.Text.Trim().Length == 0) { strErr += "event_name不能为空!\\n"; } if (this.txtbeizhu.Text.Trim().Length == 0) { strErr += "beizhu不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int id = int.Parse(this.lblid.Text); DateTime sta_time = DateTime.Parse(this.txtsta_time.Text); DateTime end_time = DateTime.Parse(this.txtend_time.Text); string event_name = this.txtevent_name.Text; string beizhu = this.txtbeizhu.Text; Maticsoft.Model.event1 model = new Maticsoft.Model.event1(); model.id = id; model.sta_time = sta_time; model.end_time = end_time; model.event_name = event_name; model.beizhu = beizhu; Maticsoft.BLL.event1 bll = new Maticsoft.BLL.event1(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.event1 GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,sta_time,end_time,event_name,beizhu from event1 "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Maticsoft.Model.event1 model = new Maticsoft.Model.event1(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }