private void ShowInfo(int hid) { myhouse.BLL.HouseService bll = new myhouse.BLL.HouseService(); myhouse.Model.House model = bll.GetModel(hid); this.lblhid.Text = model.hid.ToString(); this.lblcid.Text = model.cid.ToString(); this.lbluid.Text = model.uid.ToString(); this.lblsid.Text = model.sid.ToString(); this.txthname.Text = model.hname; this.txthdescription.Text = model.hdescription; this.txthmoney.Text = model.hmoney; this.txthtype.Text = model.htype.ToString(); this.txthphotoone.Text = model.hphotoone; this.txthphototwo.Text = model.hphototwo; this.txthphotothree.Text = model.hphotothree; this.txthphotofour.Text = model.hphotofour; this.txthfloor.Text = model.hfloor; this.txthsize.Text = model.hsize; this.txtharea.Text = model.harea.ToString(); this.txthcommunity.Text = model.hcommunity; this.txthadress.Text = model.hadress; this.txthtime.Text = model.htime.ToString(); this.txthmode.Text = model.hmode.ToString(); this.txthstatus.Text = model.hstatus.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public myhouse.Model.House GetModel(int hid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 hid,cid,uid,sid,hname,hdescription,hmoney,htype,hphotoone,hphototwo,hphotothree,hphotofour,hfloor,hsize,harea,hcommunity,hadress,htime,hmode,hstatus from t_house "); strSql.Append(" where hid=@hid"); SqlParameter[] parameters = { new SqlParameter("@hid", SqlDbType.Int, 4) }; parameters[0].Value = hid; myhouse.Model.House model = new myhouse.Model.House(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(myhouse.Model.House model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_house("); strSql.Append("cid,uid,sid,hname,hdescription,hmoney,htype,hphotoone,hphototwo,hphotothree,hphotofour,hfloor,hsize,harea,hcommunity,hadress,htime,hmode,hstatus)"); strSql.Append(" values ("); strSql.Append("@cid,@uid,@sid,@hname,@hdescription,@hmoney,@htype,@hphotoone,@hphototwo,@hphotothree,@hphotofour,@hfloor,@hsize,@harea,@hcommunity,@hadress,@htime,@hmode,@hstatus)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@cid", SqlDbType.Int, 4), new SqlParameter("@uid", SqlDbType.Int, 4), new SqlParameter("@sid", SqlDbType.Int, 4), new SqlParameter("@hname", SqlDbType.VarChar, 30), new SqlParameter("@hdescription", SqlDbType.VarChar, 200), new SqlParameter("@hmoney", SqlDbType.VarChar, 10), new SqlParameter("@htype", SqlDbType.Int, 4), new SqlParameter("@hphotoone", SqlDbType.VarChar, 200), new SqlParameter("@hphototwo", SqlDbType.VarChar, 200), new SqlParameter("@hphotothree", SqlDbType.VarChar, 200), new SqlParameter("@hphotofour", SqlDbType.VarChar, 200), new SqlParameter("@hfloor", SqlDbType.Char, 4), new SqlParameter("@hsize", SqlDbType.Char, 4), new SqlParameter("@harea", SqlDbType.Int, 4), new SqlParameter("@hcommunity", SqlDbType.VarChar, 100), new SqlParameter("@hadress", SqlDbType.VarChar, 200), new SqlParameter("@htime", SqlDbType.DateTime), new SqlParameter("@hmode", SqlDbType.Int, 4), new SqlParameter("@hstatus", SqlDbType.Int, 4) }; parameters[0].Value = model.cid; parameters[1].Value = model.uid; parameters[2].Value = model.sid; parameters[3].Value = model.hname; parameters[4].Value = model.hdescription; parameters[5].Value = model.hmoney; parameters[6].Value = model.htype; parameters[7].Value = model.hphotoone; parameters[8].Value = model.hphototwo; parameters[9].Value = model.hphotothree; parameters[10].Value = model.hphotofour; parameters[11].Value = model.hfloor; parameters[12].Value = model.hsize; parameters[13].Value = model.harea; parameters[14].Value = model.hcommunity; parameters[15].Value = model.hadress; parameters[16].Value = model.htime; parameters[17].Value = model.hmode; parameters[18].Value = model.hstatus; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public myhouse.Model.House DataRowToModel(DataRow row) { myhouse.Model.House model = new myhouse.Model.House(); if (row != null) { if (row["hid"] != null && row["hid"].ToString() != "") { model.hid = int.Parse(row["hid"].ToString()); } if (row["cid"] != null && row["cid"].ToString() != "") { model.cid = int.Parse(row["cid"].ToString()); } if (row["uid"] != null && row["uid"].ToString() != "") { model.uid = int.Parse(row["uid"].ToString()); } if (row["sid"] != null && row["sid"].ToString() != "") { model.sid = int.Parse(row["sid"].ToString()); } if (row["hname"] != null) { model.hname = row["hname"].ToString(); } if (row["hdescription"] != null) { model.hdescription = row["hdescription"].ToString(); } if (row["hmoney"] != null) { model.hmoney = row["hmoney"].ToString(); } if (row["htype"] != null && row["htype"].ToString() != "") { model.htype = int.Parse(row["htype"].ToString()); } if (row["hphotoone"] != null) { model.hphotoone = row["hphotoone"].ToString(); } if (row["hphototwo"] != null) { model.hphototwo = row["hphototwo"].ToString(); } if (row["hphotothree"] != null) { model.hphotothree = row["hphotothree"].ToString(); } if (row["hphotofour"] != null) { model.hphotofour = row["hphotofour"].ToString(); } if (row["hfloor"] != null) { model.hfloor = row["hfloor"].ToString(); } if (row["hsize"] != null) { model.hsize = row["hsize"].ToString(); } if (row["harea"] != null && row["harea"].ToString() != "") { model.harea = int.Parse(row["harea"].ToString()); } if (row["hcommunity"] != null) { model.hcommunity = row["hcommunity"].ToString(); } if (row["hadress"] != null) { model.hadress = row["hadress"].ToString(); } if (row["htime"] != null && row["htime"].ToString() != "") { model.htime = DateTime.Parse(row["htime"].ToString()); } if (row["hmode"] != null && row["hmode"].ToString() != "") { model.hmode = int.Parse(row["hmode"].ToString()); } if (row["hstatus"] != null && row["hstatus"].ToString() != "") { model.hstatus = int.Parse(row["hstatus"].ToString()); } } return(model); }
//UpdateAll 包含外键更新 public bool UpdateAll(myhouse.Model.House model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_house set "); strSql.Append("hname=@hname,"); strSql.Append("hdescription=@hdescription,"); strSql.Append("hmoney=@hmoney,"); strSql.Append("htype=@htype,"); strSql.Append("hphotoone=@hphotoone,"); strSql.Append("hphototwo=@hphototwo,"); strSql.Append("hphotothree=@hphotothree,"); strSql.Append("hphotofour=@hphotofour,"); strSql.Append("hfloor=@hfloor,"); strSql.Append("hsize=@hsize,"); strSql.Append("harea=@harea,"); strSql.Append("hcommunity=@hcommunity,"); strSql.Append("hadress=@hadress,"); strSql.Append("htime=@htime,"); strSql.Append("hmode=@hmode,"); strSql.Append("hstatus=@hstatus,"); strSql.Append("sid=@sid"); /*外键sid更新*/ strSql.Append(" where hid=@hid"); SqlParameter[] parameters = { new SqlParameter("@hname", SqlDbType.VarChar, 30), new SqlParameter("@hdescription", SqlDbType.VarChar, 200), new SqlParameter("@hmoney", SqlDbType.VarChar, 10), new SqlParameter("@htype", SqlDbType.Int, 4), new SqlParameter("@hphotoone", SqlDbType.VarChar, 200), new SqlParameter("@hphototwo", SqlDbType.VarChar, 200), new SqlParameter("@hphotothree", SqlDbType.VarChar, 200), new SqlParameter("@hphotofour", SqlDbType.VarChar, 200), new SqlParameter("@hfloor", SqlDbType.Char, 4), new SqlParameter("@hsize", SqlDbType.Char, 4), new SqlParameter("@harea", SqlDbType.Int, 4), new SqlParameter("@hcommunity", SqlDbType.VarChar, 100), new SqlParameter("@hadress", SqlDbType.VarChar, 200), new SqlParameter("@htime", SqlDbType.DateTime), new SqlParameter("@hmode", SqlDbType.Int, 4), new SqlParameter("@hstatus", SqlDbType.Int, 4), new SqlParameter("@hid", SqlDbType.Int, 4), new SqlParameter("@cid", SqlDbType.Int, 4), new SqlParameter("@uid", SqlDbType.Int, 4), new SqlParameter("@sid", SqlDbType.Int, 4) }; parameters[0].Value = model.hname; parameters[1].Value = model.hdescription; parameters[2].Value = model.hmoney; parameters[3].Value = model.htype; parameters[4].Value = model.hphotoone; parameters[5].Value = model.hphototwo; parameters[6].Value = model.hphotothree; parameters[7].Value = model.hphotofour; parameters[8].Value = model.hfloor; parameters[9].Value = model.hsize; parameters[10].Value = model.harea; parameters[11].Value = model.hcommunity; parameters[12].Value = model.hadress; parameters[13].Value = model.htime; parameters[14].Value = model.hmode; parameters[15].Value = model.hstatus; parameters[16].Value = model.hid; parameters[17].Value = model.cid; parameters[18].Value = model.uid; parameters[19].Value = model.sid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txthname.Text.Trim().Length == 0) { strErr += "hname不能为空!\\n"; } if (this.txthdescription.Text.Trim().Length == 0) { strErr += "hdescription不能为空!\\n"; } if (this.txthmoney.Text.Trim().Length == 0) { strErr += "hmoney不能为空!\\n"; } if (!PageValidate.IsNumber(txthtype.Text)) { strErr += "htype格式错误!\\n"; } if (this.txthphotoone.Text.Trim().Length == 0) { strErr += "hphotoone不能为空!\\n"; } if (this.txthphototwo.Text.Trim().Length == 0) { strErr += "hphototwo不能为空!\\n"; } if (this.txthphotothree.Text.Trim().Length == 0) { strErr += "hphotothree不能为空!\\n"; } if (this.txthphotofour.Text.Trim().Length == 0) { strErr += "hphotofour不能为空!\\n"; } if (this.txthfloor.Text.Trim().Length == 0) { strErr += "hfloor不能为空!\\n"; } if (this.txthsize.Text.Trim().Length == 0) { strErr += "hsize不能为空!\\n"; } if (!PageValidate.IsNumber(txtharea.Text)) { strErr += "harea格式错误!\\n"; } if (this.txthcommunity.Text.Trim().Length == 0) { strErr += "hcommunity不能为空!\\n"; } if (this.txthadress.Text.Trim().Length == 0) { strErr += "hadress不能为空!\\n"; } if (!PageValidate.IsDateTime(txthtime.Text)) { strErr += "htime格式错误!\\n"; } if (!PageValidate.IsNumber(txthmode.Text)) { strErr += "hmode格式错误!\\n"; } if (!PageValidate.IsNumber(txthstatus.Text)) { strErr += "hstatus格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int hid = int.Parse(this.lblhid.Text); int cid = int.Parse(this.lblcid.Text); int uid = int.Parse(this.lbluid.Text); int sid = int.Parse(this.lblsid.Text); string hname = this.txthname.Text; string hdescription = this.txthdescription.Text; string hmoney = this.txthmoney.Text; int htype = int.Parse(this.txthtype.Text); string hphotoone = this.txthphotoone.Text; string hphototwo = this.txthphototwo.Text; string hphotothree = this.txthphotothree.Text; string hphotofour = this.txthphotofour.Text; string hfloor = this.txthfloor.Text; string hsize = this.txthsize.Text; int harea = int.Parse(this.txtharea.Text); string hcommunity = this.txthcommunity.Text; string hadress = this.txthadress.Text; DateTime htime = DateTime.Parse(this.txthtime.Text); int hmode = int.Parse(this.txthmode.Text); int hstatus = int.Parse(this.txthstatus.Text); myhouse.Model.House model = new myhouse.Model.House(); model.hid = hid; model.cid = cid; model.uid = uid; model.sid = sid; model.hname = hname; model.hdescription = hdescription; model.hmoney = hmoney; model.htype = htype; model.hphotoone = hphotoone; model.hphototwo = hphototwo; model.hphotothree = hphotothree; model.hphotofour = hphotofour; model.hfloor = hfloor; model.hsize = hsize; model.harea = harea; model.hcommunity = hcommunity; model.hadress = hadress; model.htime = htime; model.hmode = hmode; model.hstatus = hstatus; myhouse.BLL.HouseService bll = new myhouse.BLL.HouseService(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }