/// <summary> /// 更新一条数据 /// </summary> public bool Update(SDM.Model.jiating model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update JiatingInfo set "); strSql.Append("户口所在地=@户口所在地,"); strSql.Append("描述=@描述"); strSql.Append(" where 家庭编号=@家庭编号"); SqlParameter[] parameters = { new SqlParameter("@户口所在地", SqlDbType.NVarChar, 250), new SqlParameter("@描述", SqlDbType.NVarChar, 250), new SqlParameter("@家庭编号", SqlDbType.Int, 4) }; parameters[0].Value = model.Hkszd; parameters[1].Value = model.Miaoshu; parameters[2].Value = model.Jiating; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SDM.Model.jiating model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into JiatingInfo("); strSql.Append("户口所在地,描述)"); strSql.Append(" values ("); strSql.Append("@户口所在地,@描述)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@户口所在地", SqlDbType.NVarChar, 250), new SqlParameter("@描述", SqlDbType.NVarChar, 250) }; parameters[0].Value = model.Hkszd; parameters[1].Value = model.Miaoshu; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void Button2_Click(object sender, EventArgs e) { model2 = CreateModel2(); model2.Jiating = int.Parse(Request.QueryString["id"].ToString()); bll2.Update(model2); SDM.DAL.ShowInfo.Alert("操作成功!", this.Page); bind2();//重新刷新数据 }
/// <summary> /// 得到一个对象实体 /// </summary> public SDM.Model.jiating DataRowToModel(DataRow row) { SDM.Model.jiating model = new SDM.Model.jiating(); if (row != null) { if (row["家庭编号"] != null && row["家庭编号"].ToString() != "") { model.Jiating = int.Parse(row["家庭编号"].ToString()); } if (row["户口所在地"] != null) { model.Hkszd = row["户口所在地"].ToString(); } if (row["描述"] != null) { model.Miaoshu = row["描述"].ToString(); } } return(model); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { switch (Request.QueryString["action"].ToString().Trim()) { case "add": Button2.Visible = false; Button1.Visible = true; break; case "Edit": Button2.Visible = true; Button1.Visible = false; int id = int.Parse(Request.QueryString["id"]); model2 = bll2.GetModel(id); TextBox1.Text = model2.Hkszd.ToString(); TextBox2.Text = model2.Miaoshu.ToString(); break; } bind2(); } }
/// <summary> /// 得到一个对象实体 /// </summary> public SDM.Model.jiating GetModel(int AdminID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 家庭编号,户口所在地,描述 from JiatingInfo "); strSql.Append(" where 家庭编号=@家庭编号"); SqlParameter[] parameters = { new SqlParameter("@家庭编号", SqlDbType.Int, 4) }; parameters[0].Value = AdminID; SDM.Model.jiating model = new SDM.Model.jiating(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }