public void ShowArticleInfo(string strID) { DC_HouseDAL dal = new DC_HouseDAL(); DataSet ds = dal.GetDCHouseDetail(strID); DC_House model = DataConvert.DataRowToModel <DC_House>(ds.Tables[0].Rows[0]); Summary.Text = model.Summary; img0.Src = "../../" + model.Photo; ddlCategory.SelectedIndex = ddlCategory.Items.IndexOf(ddlCategory.Items.FindByValue(model.SaleRental.ToString())); Price.Text = model.Price.ToString(); HouseType.Text = model.HouseType; Faces.Text = model.Faces; Area.Text = model.Area.ToString(); Renovation.Text = model.Renovation; Floor.Text = model.Floor; UseType.Text = model.UseType; Buildings.Text = model.Buildings; CreateYear.Text = model.CreateYear; Regions.Text = model.Regions; Address.Text = model.Address; hd_content.Value = model.Content; if (strAction == "show") { this.btnReset.Visible = false; this.btnSave.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strHouseID = string.Empty; string strSiteCode = string.Empty; string siteid = string.Empty; if (null == Request.QueryString["id"]) { return; } if (Request["siteid"] != null && Request["siteid"] != "") { siteid = Request["siteid"]; } #region 房屋详细 strHouseID = Common.Common.NoHtml(Request.QueryString["id"].ToString()); DC_HouseDAL dal = new DC_HouseDAL(); DataSet ds = dal.GetDCHouseDetail(strHouseID); DC_House model = new DC_House(); if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { model = DataConvert.DataRowToModel <DC_House>(ds.Tables[0].Rows[0]); strSiteCode = model.SiteCode; } #endregion #region 相关房屋列表 List <DC_House> HouseList = new List <DC_House>(); DataSet RelevantHouseDs = dal.GetRelevantHouseList(3, strHouseID); if (null != RelevantHouseDs && RelevantHouseDs.Tables.Count > 0 && RelevantHouseDs.Tables[0].Rows.Count > 0) { foreach (DataRow row in RelevantHouseDs.Tables[0].Rows) { DC_House RelevantModel = DataConvert.DataRowToModel <DC_House>(row); HouseList.Add(RelevantModel); } } #endregion //读取模板内容 string text = System.IO.File.ReadAllText(Server.MapPath("Themes/Realty/NewHomeDetail.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["sitecode"] = strSiteCode; context.TempData["title"] = "房产详细信息"; context.TempData["HouseDetail"] = model; context.TempData["siteid"] = siteid; context.TempData["RelevantHouse"] = HouseList; context.TempData["footer"] = "奥琦微商易"; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); } }
protected void Page_Load(object sender, EventArgs e) { if (null != Common.Common.NoHtml(Request.QueryString["action"])) { strAction = Common.Common.NoHtml(Request.QueryString["action"]); } if (null != Common.Common.NoHtml(Request.QueryString["id"])) { strID = Common.Common.NoHtml(Request.QueryString["id"]); } DC_HouseDAL dal = new DC_HouseDAL(); int statein = 0; try { statein = Convert.ToInt32(dal.GetDCHouseByValue("IsDel", strID)); } catch (Exception) { statein = 0; } switch (statein) { case 0: statein = 1; break; default: statein = 0; break; } switch (strAction) { case "del": if (dal.UpdateIsDel(strID, statein.ToString())) { strMessage = "操作成功!"; } else { strMessage = "操作失败!"; } break; default: break; } Response.Write(strMessage); Response.End(); }
protected override void AddTempData(JinianNet.JNTemplate.TemplateContext context) { List <DC_House> HouseList = new List <DC_House>(); DC_HouseDAL dal = new DC_HouseDAL(); DataSet Houseds = dal.GetDCHouseList(SiteCode, "0"); string housecount = Houseds.Tables[0].Rows.Count.ToString(); foreach (DataRow row in Houseds.Tables[0].Rows) { DC_House model = DataConvert.DataRowToModel <DC_House>(row); HouseList.Add(model); } context.TempData["HouseCount"] = housecount; context.TempData["HouseList"] = HouseList; }
/// <summary> /// 加载数据 /// </summary> /// <param name="strWhere">条件</param> void LoadData(string strWhere) { txtTitle.Text = ""; DC_HouseDAL dal = new DC_HouseDAL(); DataSet ds = dal.GetDCHouseList(strWhere); DataView dv = ds.Tables[0].DefaultView; AspNetPager1.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = AspNetPager1.PageSize; Repeater1.DataSource = pds; Repeater1.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { if (null == Session["strSiteName"] || null == Session["strSiteCode"] || null == Session["strLoginName"]) { Response.Write("<script language=JavaScript>;parent.location.href='../Index.aspx';</script>"); Response.End(); } //上传图像 string strIconFileName = string.Empty; //图像路径 string strIconSaveFileName = string.Empty; //网址路径 try { if (this.file0.PostedFile.FileName == "") { strIconSaveFileName = ""; } else { if (!System.IO.Directory.Exists(Server.MapPath("~") + @"/Images")) { System.IO.Directory.CreateDirectory(Server.MapPath("~") + @"/Images"); } if (!System.IO.Directory.Exists(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString()))) { System.IO.Directory.CreateDirectory(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString())); } string orignalName = this.file0.PostedFile.FileName; //获取客户机上传文件的文件名 string extendName = orignalName.Substring(orignalName.LastIndexOf(".")); //获取扩展名 if (extendName != ".gif" && extendName != ".jpg" && extendName != ".jpeg" && extendName != ".png") { MessageBox.Show(this, "文件格式有误!"); return; }//检查文件格式 string newName = String.Format("{0}_{1}{2}", DateTime.Now.Millisecond, file0.PostedFile.ContentLength, extendName);//对文件进行重命名 strIconFileName = String.Format(@"{0}Images/{1}/{2}", Server.MapPath("~"), Session["strSiteCode"].ToString(), newName); strIconSaveFileName = String.Format(@"Images/{0}/{1}", Session["strSiteCode"].ToString(), newName); file0.PostedFile.SaveAs(strIconFileName); } } catch (Exception ex) { MessageBox.Show(this, "上传发生错误!原因是:" + ex.ToString()); } DC_HouseDAL dal = new DC_HouseDAL(); DC_House model = new DC_House(); model.ID = strID; model.SiteCode = Session["strSiteCode"].ToString(); if (Summary.Text.Trim() != null && Summary.Text.Trim() != "") { model.Summary = Summary.Text; } if (strIconSaveFileName != null && strIconSaveFileName != "") { model.Photo = strIconSaveFileName; } if (ddlCategory.SelectedValue != null && ddlCategory.SelectedValue != "") { model.SaleRental = Convert.ToInt32(ddlCategory.SelectedValue); } if (Price.Text.Trim() != null && Price.Text.Trim() != "") { model.Price = Convert.ToDecimal(Price.Text); } if (HouseType.Text.Trim() != null && HouseType.Text.Trim() != "") { model.HouseType = HouseType.Text; } if (Faces.Text.Trim() != null && Faces.Text.Trim() != "") { model.Faces = Faces.Text; } if (Area.Text.Trim() != null && Area.Text.Trim() != "") { model.Area = Convert.ToDecimal(Area.Text); } if (Renovation.Text.Trim() != null && Renovation.Text.Trim() != "") { model.Renovation = Renovation.Text; } if (Floor.Text.Trim() != null && Floor.Text.Trim() != "") { model.Floor = Floor.Text; } if (UseType.Text.Trim() != null && UseType.Text.Trim() != "") { model.UseType = UseType.Text; } if (Buildings.Text.Trim() != null && Buildings.Text.Trim() != "") { model.Buildings = Buildings.Text; } if (CreateYear.Text.Trim() != null && CreateYear.Text.Trim() != "") { model.CreateYear = CreateYear.Text; } if (Regions.Text.Trim() != null && Regions.Text.Trim() != "") { model.Regions = Regions.Text; } if (Address.Text.Trim() != null && Address.Text.Trim() != "") { model.Address = Address.Text; } if (hd_content.Value.Trim() != null && hd_content.Value.Trim() != "") { model.Content = hd_content.Value; } if (dal.UpdateDCHouse(model)) { MessageBox.Show(this, "操作成功!"); } else { MessageBox.Show(this, "操作失败!"); } }