protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["type"] != null) { H_houseinfor hh = H_houseinfor.Find("shi_id='" + Request.Form["Shi_id"] + "' and " + GetRolePermissionOrgIds("查看", "OrgID")); if (hh != null) { hh.Shi_id = Request.Form["NewShi_id"]; if (H_houseinfor.FindCount("Shi_id", hh.Shi_id) == 0) { hh.Update(); //插入日志 Log log = new Log(); log.Action = "修改"; log.Category = "房源编号修改"; log.IP = HttpContext.Current.Request.UserHostAddress; log.OccurTime = DateTime.Now; log.UserID = Convert.ToInt32(HouseMIS.EntityUtils.Employee.Current.EmployeeID); log.UserName = HouseMIS.EntityUtils.Employee.Current.Em_name; log.Remark = "原房源编号=" + Request.Form["Shi_id"] + ",新房源编号=" + Request.Form["NewShi_id"]; log.Insert(); JSDo_UserCallBack_Success("", "操作成功!"); } else { JSDo_UserCallBack_Error("", "操作失败!"); } } else { JSDo_UserCallBack_Error("", "您没有操作该房源的权限!"); } } }
protected void Page_Load(object sender, EventArgs e) { form1.Action += "?HouseID=" + HouseID; if (!IsPostBack) { string seeRecord = GetRolePermissionEmployeeIds("查看录音", "EmployeeID"); string seeRecord_Mask = GetRolePermissionEmployeeIds("查看屏蔽录音", "EmployeeID"); string sql = string.Format(@"select b.recordUrl as a, d.Name+'('+c.em_id+'-'+c.em_name+')'+' '+CONVERT(varchar,createTime,120) as c, b.phoneID,b.employeeID,source from i_InternetPhone b inner join e_Employee c on b.employeeID=c.EmployeeID inner join s_Organise d on d.OrgID=c.OrgID where b.HouseId={0} and b.recordUrlDel=1 and b.RecrodType=1 and b.talktime>0 and b.EmployeeID in(select EmployeeID from e_Employee where {1}) and b.phoneID not in (select a.phoneID from i_InternetPhone a inner join h_RecordClose b on a.phoneID = b.phoneID where a.houseID ={0} and b.IsCheck = 1 and a.EmployeeID not in (select EmployeeID from e_Employee where {2})) order by b.phoneID desc", Request.QueryString["HouseID"], seeRecord, seeRecord_Mask); //string sql = string.Format(@"select A.recordUrl as a,C.Name+'('+B.em_id+'-'+B.em_name+')'+' '+CONVERT(varchar,createTime,120) as c,A.phoneID,A.employeeID,source // from i_InternetPhone A // left join e_Employee B on A.employeeID=B.EmployeeID // left join s_Organise C on B.OrgID=C.OrgID // where houseID={0} // and A.recordUrlDel=1 // order by a.createTime desc", // Request.QueryString["HouseID"]); DataSet dts = DbHelperSQL.Query(sql); if (dts.Tables[0].Rows.Count > 0) { sql = string.Format(@"select phoneID,EmployeeID from h_RecordClose where IsCheck=1 and phoneID in({0})", string.Join(",", dts.Tables[0].AsEnumerable().Select(x => x.Field <decimal>("phoneID")))); list_h_RecordClose = h_RecordClose.FindAll(sql); } hf_ly2.DataSource = dts.Tables[0]; hf_ly2.DataBind(); frmOldPrice.Text = H_houseinfor.Find("HouseID", HouseID).Min_price.ToString(); } }