/// <summary> /// 得到一个对象实体 /// </summary> public zs.Model.Tbl_Xueyuan GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,name,nameen,logo,image1,image2,image3,yuanzhang,conts from Tbl_Xueyuan "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; zs.Model.Tbl_Xueyuan model = new zs.Model.Tbl_Xueyuan(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["name"] != null && ds.Tables[0].Rows[0]["name"].ToString() != "") { model.name = ds.Tables[0].Rows[0]["name"].ToString(); } if (ds.Tables[0].Rows[0]["nameen"] != null && ds.Tables[0].Rows[0]["nameen"].ToString() != "") { model.nameen = ds.Tables[0].Rows[0]["nameen"].ToString(); } if (ds.Tables[0].Rows[0]["logo"] != null && ds.Tables[0].Rows[0]["logo"].ToString() != "") { model.logo = ds.Tables[0].Rows[0]["logo"].ToString(); } if (ds.Tables[0].Rows[0]["image1"] != null && ds.Tables[0].Rows[0]["image1"].ToString() != "") { model.image1 = ds.Tables[0].Rows[0]["image1"].ToString(); } if (ds.Tables[0].Rows[0]["image2"] != null && ds.Tables[0].Rows[0]["image2"].ToString() != "") { model.image2 = ds.Tables[0].Rows[0]["image2"].ToString(); } if (ds.Tables[0].Rows[0]["image3"] != null && ds.Tables[0].Rows[0]["image3"].ToString() != "") { model.image3 = ds.Tables[0].Rows[0]["image3"].ToString(); } if (ds.Tables[0].Rows[0]["yuanzhang"] != null && ds.Tables[0].Rows[0]["yuanzhang"].ToString() != "") { model.yuanzhang = ds.Tables[0].Rows[0]["yuanzhang"].ToString(); } if (ds.Tables[0].Rows[0]["conts"] != null && ds.Tables[0].Rows[0]["conts"].ToString() != "") { model.conts = ds.Tables[0].Rows[0]["conts"].ToString(); } return(model); } else { return(null); } }
private void ShowInfo(int id) { zs.BLL.Tbl_Xueyuan bll = new zs.BLL.Tbl_Xueyuan(); zs.Model.Tbl_Xueyuan model = bll.GetModel(id); this.lblid.Text = model.id.ToString(); this.txtname.Text = model.name; this.txtnameen.Text = model.nameen; this.txtlogo.Text = model.logo; this.txtimage1.Text = model.image1; this.txtimage2.Text = model.image2; this.txtimage3.Text = model.image3; this.txtyuanzhang.Text = model.yuanzhang; this.txtconts.Text = model.conts; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zs.Model.Tbl_Xueyuan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Tbl_Xueyuan set "); strSql.Append("name=@name,"); strSql.Append("nameen=@nameen,"); strSql.Append("logo=@logo,"); strSql.Append("image1=@image1,"); strSql.Append("image2=@image2,"); strSql.Append("image3=@image3,"); strSql.Append("yuanzhang=@yuanzhang,"); strSql.Append("conts=@conts"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@nameen", SqlDbType.VarChar, 80), new SqlParameter("@logo", SqlDbType.VarChar, 50), new SqlParameter("@image1", SqlDbType.VarChar, 50), new SqlParameter("@image2", SqlDbType.VarChar, 50), new SqlParameter("@image3", SqlDbType.VarChar, 50), new SqlParameter("@yuanzhang", SqlDbType.VarChar), new SqlParameter("@conts", SqlDbType.VarChar), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.nameen; parameters[2].Value = model.logo; parameters[3].Value = model.image1; parameters[4].Value = model.image2; parameters[5].Value = model.image3; parameters[6].Value = model.yuanzhang; parameters[7].Value = model.conts; parameters[8].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zs.Model.Tbl_Xueyuan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tbl_Xueyuan("); strSql.Append("name,nameen,logo,image1,image2,image3,yuanzhang,conts)"); strSql.Append(" values ("); strSql.Append("@name,@nameen,@logo,@image1,@image2,@image3,@yuanzhang,@conts)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@nameen", SqlDbType.VarChar, 80), new SqlParameter("@logo", SqlDbType.VarChar, 50), new SqlParameter("@image1", SqlDbType.VarChar, 50), new SqlParameter("@image2", SqlDbType.VarChar, 50), new SqlParameter("@image3", SqlDbType.VarChar, 50), new SqlParameter("@yuanzhang", SqlDbType.VarChar), new SqlParameter("@conts", SqlDbType.VarChar) }; parameters[0].Value = model.name; parameters[1].Value = model.nameen; parameters[2].Value = model.logo; parameters[3].Value = model.image1; parameters[4].Value = model.image2; parameters[5].Value = model.image3; parameters[6].Value = model.yuanzhang; parameters[7].Value = model.conts; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtname.Text.Trim().Length == 0) { strErr += "name不能为空!\\n"; } if (this.txtnameen.Text.Trim().Length == 0) { strErr += "nameen不能为空!\\n"; } if (this.txtlogo.Text.Trim().Length == 0) { strErr += "logo不能为空!\\n"; } if (this.txtimage1.Text.Trim().Length == 0) { strErr += "image1不能为空!\\n"; } if (this.txtimage2.Text.Trim().Length == 0) { strErr += "image2不能为空!\\n"; } if (this.txtimage3.Text.Trim().Length == 0) { strErr += "image3不能为空!\\n"; } if (this.txtyuanzhang.Text.Trim().Length == 0) { strErr += "yuanzhang不能为空!\\n"; } if (this.txtconts.Text.Trim().Length == 0) { strErr += "conts不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int id = int.Parse(this.lblid.Text); string name = this.txtname.Text; string nameen = this.txtnameen.Text; string logo = this.txtlogo.Text; string image1 = this.txtimage1.Text; string image2 = this.txtimage2.Text; string image3 = this.txtimage3.Text; string yuanzhang = this.txtyuanzhang.Text; string conts = this.txtconts.Text; zs.Model.Tbl_Xueyuan model = new zs.Model.Tbl_Xueyuan(); model.id = id; model.name = name; model.nameen = nameen; model.logo = logo; model.image1 = image1; model.image2 = image2; model.image3 = image3; model.yuanzhang = yuanzhang; model.conts = conts; zs.BLL.Tbl_Xueyuan bll = new zs.BLL.Tbl_Xueyuan(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }