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 override void OnSaving(object sender, EntityFormEventArgs e) { if (Request.Form["frmImgPic"] != "") { if (Request.Form["Hid"] != null) { decimal cid = Convert.ToDecimal(Request.Form["C.CustomerID"]); int hid = Convert.ToInt32(Request.Form["Hid"]); H_houseinfor h = H_houseinfor.FindByHouseID(hid); if (h != null) { //带看凭证 Entity.ImgPic = Request.Form["frmImgPic"]; //操作人 Entity.EmployeeID = Employee.Current.EmployeeID; //状态、 Entity.HouseState = int.Parse(ffrmHouseState.SelectedValue); //房源ID Entity.HouseID = hid; //责任人 Entity.ZRempID = Request.Form["f.frmEscortEmployeeID1"].ToDecimal(); //时间 Entity.Exe_date = DateTime.Now; Entity.Update(); //房源状态改为选择的状态 h.EntrustTypeID = Entity.HouseState; h.Update(); } else { Response.Write("<script>alertMsg.error('参数错误,请重新操作')</script>"); //取消执行 e.Cancel = true; return; } } else { Response.Write("<script>alertMsg.error('参数错误,请重新操作')</script>"); //取消执行 e.Cancel = true; return; } } else { Response.Write("<script>alertMsg.error('操作失败!请上传带看凭证')</script>"); //取消执行 e.Cancel = true; return; } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; if (context.Request["HouseID"] != null && context.Request["HouseID"] != "0") { try { H_houseinfor hh = H_houseinfor.FindByHouseID(Convert.ToDecimal(context.Request["HouseID"])); bool igr = false; if (context.Request["num"].ToString() == "1") { igr = true; } hh.IsGetRent = igr; hh.Update_date = DateTime.Now; hh.Update(); context.Response.Write("1"); } catch { context.Response.Write("2"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { myffrmwc.Items.Clear(); myffrmwc.Items.Add(new ListItem("全部", "2")); myffrmwc.Items.Add(new ListItem("未完成", "0")); myffrmwc.Items.Add(new ListItem("已完成", "1")); string temp = GetMySearchControlValue("wc"); if (!temp.IsNullOrWhiteSpace()) { myffrmwc.SelectedValue = temp; } else { myffrmwc.SelectedIndex = 1; } myffrmlq.Items.Clear(); myffrmlq.Items.Add(new ListItem("全部", "")); myffrmlq.Items.Add(new ListItem("未领取", "0")); myffrmlq.Items.Add(new ListItem("已领取", "1")); myffrmsh.Items.Clear(); myffrmsh.Items.Add(new ListItem("全部", "")); myffrmsh.Items.Add(new ListItem("未审核", "0")); myffrmsh.Items.Add(new ListItem("已审核", "1")); FullDropListData(typeof(h_EntrustType), this.myffrmEntrustTypeID, "Name", "EntrustTypeID", ""); } if (CheckRolePermission("修改")) { z_bottom = "<li><a class=\"iconL\" href=\"House/HousePicListYY.aspx?Type=0&doType=lq&NavTabId=" + NavTabId + "&selectPage=" + (gv.PageIndex + 1).ToString() + "&doAjax=true\" rel=\"ids\" target=\"selectedTodo\" title=\"确定要操作吗?\"><span>领取</span></a></li>"; z_bottom += "<li><a class=\"iconL\" href=\"House/HousePicListYY.aspx?Type=0&doType=qxlq&NavTabId=" + NavTabId + "&selectPage=" + (gv.PageIndex + 1).ToString() + "&doAjax=true\" rel=\"ids\" target=\"selectedTodo\" title=\"确定要操作吗?\"><span>取消领取</span></a></li>"; z_bottom += "<li><a class=\"iconL\" href=\"House/HousePicListYY.aspx?Type=0&doType=wc&NavTabId=" + NavTabId + "&selectPage=" + (gv.PageIndex + 1).ToString() + "&doAjax=true\" rel=\"ids\" target=\"selectedTodo\" title=\"确定要操作吗?\"><span>完成</span></a></li>"; z_bottom += "<li><a class=\"delete\" href=\"House/HousePicListYY.aspx?doType=del&NavTabId=" + NavTabId + "&selectPage=" + (gv.PageIndex + 1).ToString() + "&doAjax=true\" rel=\"ids\" target=\"selectedTodo\" title=\"确定要删除吗?\"><span>删除照片</span></a></li>"; z_bottom += "<li><a class=\"edit\" href=\"House/HouseRemarkAdd.aspx?NavTabId=" + NavTabId + "&doAjax=true&ID={ID}\" rel='Bargain1' width=\"360\" height=\"230\" target=\"dialog\" mask=\"true\"><span>增加备注</span></a></li>"; } if (CheckRolePermission("删除")) { z_bottom += "<li><a class=\"iconL\" href=\"House/HousePicListYY.aspx?doType=sh&NavTabId=" + NavTabId + "&selectPage=" + (gv.PageIndex + 1).ToString() + "&doAjax=true\" rel=\"ids\" target=\"selectedTodo\"><span>审核</span></a></li>"; } if (CheckRolePermission("驳回")) { z_bottom += "<li><a class=\"iconL\" href=\"House/HousePicListYY.aspx?doType=bh&NavTabId=" + NavTabId + "&selectPage=" + (gv.PageIndex + 1).ToString() + "&doAjax=true\" rel=\"ids\" target=\"selectedTodo\" title=\"确定要驳回吗?\"><span>驳回</span></a></li>"; } #region 执行操作 if (Request.QueryString["doType"] != null) { //领取 if (Request.QueryString["doType"].ToString() == "lq") { if (!string.IsNullOrEmpty(Request["ids"])) { string sql = string.Format("select * from h_PicList_YY where ID in({0})", Request["ids"]); List <h_PicList_YY> list_h_PicList_YY = h_PicList_YY.FindAll(sql); foreach (h_PicList_YY hfa in list_h_PicList_YY) { //摄影师以提示已经领取任务 if (hfa.Photographer != null) { Response.Write("<script>alertMsg.error(\"任务已被领取,不可在领!\")</script>"); Response.End(); } else { hfa.Photographer = int.Parse(Current.EmployeeID.ToString()); hfa.PotoOrg = int.Parse(Current.OrgID.ToString()); hfa.Update(); } } } } //取消领取 else if (Request.QueryString["doType"].ToString() == "qxlq") { if (!string.IsNullOrEmpty(Request["ids"])) { string sql = string.Format("select * from h_PicList_YY where ID in({0})", Request["ids"]); List <h_PicList_YY> list_h_PicList_YY = h_PicList_YY.FindAll(sql); foreach (h_PicList_YY hfa in list_h_PicList_YY) { hfa.Photographer = null; hfa.PotoOrg = null; hfa.Update(); } } } //完成 else if (Request.QueryString["doType"].ToString() == "wc") { if (!string.IsNullOrEmpty(Request["ids"])) { string sql = string.Format("select * from h_PicList_YY where ID in({0})", Request["ids"]); List <h_PicList_YY> list_h_PicList_YY = h_PicList_YY.FindAll(sql); foreach (h_PicList_YY hfa in list_h_PicList_YY) { //完成时间更新 hfa.Finishtime = DateTime.Now; hfa.Update(); } } } else if (Request.QueryString["doType"].ToString() == "del") { if (!string.IsNullOrEmpty(Request["ids"])) { string sql = string.Format("select * from h_PicList_YY where ID in({0})", Request["ids"]); List <h_PicList_YY> list_h_PicList_YY = h_PicList_YY.FindAll(sql); h_PicList hp; string HouseID; foreach (h_PicList_YY hfa in list_h_PicList_YY) { HouseID = hfa.HouseID.ToString(); //删除全部照片 List <h_PicList> list_h_PicList = h_PicList.FindAllByHouseID(HouseID.ToDecimal().Value); foreach (h_PicList item in list_h_PicList) { h_PicListDel list_h_PicListDel = new h_PicListDel(); list_h_PicListDel.ComID = item.ComID; list_h_PicListDel.EmployeeID = item.EmployeeID; list_h_PicListDel.Exe_date = item.exe_date; list_h_PicListDel.HouseID = item.HouseID; list_h_PicListDel.PicTypeID = item.PicTypeID; list_h_PicListDel.PicURL = item.PicURL; list_h_PicListDel.OrgID = item.OrgID; list_h_PicListDel.DelEmployeeID = Current.EmployeeID.ToInt32(); list_h_PicListDel.DelOrgID = Current.OrgID.ToInt32(); list_h_PicListDel.DelDate = DateTime.Now; list_h_PicListDel.Insert(); } DbHelperSQL.ExecuteSql("delete from h_PicList where PicTypeID!=9 and HouseID= " + HouseID); H_houseinfor.Update("HasImage=0", "HouseID=" + HouseID); Log log1 = new Log(); log1.Action = "删除"; log1.Category = "删除房源照片"; log1.IP = HttpContext.Current.Request.UserHostAddress; log1.OccurTime = DateTime.Now; log1.UserID = Convert.ToInt32(Employee.Current.EmployeeID); log1.UserName = Employee.Current.Em_name; log1.Remark = "房源ID=" + HouseID; log1.Insert(); } StringBuilder sb1 = new StringBuilder(); sb1.Append("<script>alertMsg.correct(\"操作成功!\")</script>"); Response.Write(sb1.ToString()); Response.End(); } } //驳回 else if (Request.QueryString["doType"].ToString() == "bh") { if (!string.IsNullOrEmpty(Request["ids"])) { string sql = string.Format("select * from h_PicList_YY where ID in({0})", Request["ids"]); List <h_PicList_YY> list_h_PicList_YY = h_PicList_YY.FindAll(sql); foreach (h_PicList_YY hfa in list_h_PicList_YY) { hfa.Delete(); } } } //审核 else if (Request.QueryString["doType"].ToString() == "sh") { if (!string.IsNullOrEmpty(Request["ids"])) { string sql = string.Format("select * from h_PicList_YY where ID in({0})", Request["ids"]); List <h_PicList_YY> list_h_PicList_YY = h_PicList_YY.FindAll(sql); foreach (h_PicList_YY hfa in list_h_PicList_YY) { if (hfa.IsCheck == 1) { hfa.IsCheck = 0; } else { hfa.IsCheck = 1; } hfa.Update(); } } } #region 刷新当前页[抓取当页导航数字onclick事件] string JavaScript = " dwzPageBreak({ targetType: \"navTab\", rel: \"\", data: { pageNum: " + Request["selectPage"] + "} });"; JSDo_UserCallBack_Success(JavaScript, "操作成功"); #endregion 刷新当前页[抓取当页导航数字onclick事件] } #endregion }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { myffrmddlAudit.Items.Clear(); myffrmddlAudit.Items.Add(""); myffrmddlAudit.Items.Add(new ListItem("未审核", "0")); myffrmddlAudit.Items.Add(new ListItem("已审核", "1")); myffrmddlAudit.SelectedIndex = 1; } z_bottom = "<li><a class=\"iconL\" href=\"House/FollowAuditList.aspx?doType=upDateHouse&NavTabId=" + NavTabId + "&selectPage=" + (gv.PageIndex + 1).ToString() + "&doAjax=true&FollowAuditID={FollowAuditID}\" rel=\"ids\" target=\"selectedTodo\" title=\"确定要操作吗?\"><span>审核</span></a></li>"; if (CheckRolePermission("删除")) { z_del = "<li><a class=\"delete\" href=\"House/FollowAuditList.aspx?doType=del&NavTabId=" + NavTabId + "&selectPage=" + (gv.PageIndex + 1).ToString() + "&doAjax=true&FollowAuditID={FollowAuditID}\" rel=\"ids\" target=\"selectedTodo\" title=\"确定要删除吗?\"><span>删除</span></a></li>"; } if (Request.QueryString["doType"] != null) { //审核状态 if (Request.QueryString["doType"].ToString() == "upDateHouse") { if (!string.IsNullOrEmpty(Request["ids"])) { string sql = string.Format("select * from h_FollowAudit where FollowAuditID in({0})", Request["ids"]); List <h_FollowAudit> list_h_FollowAudit = h_FollowAudit.FindAll(sql); foreach (h_FollowAudit hfa in list_h_FollowAudit) { //房源跟进中增加修改状态 if (DbHelperSQL.ExecuteSql("exec dbo.h_update_HouseState " + hfa.StateID + ", " + hfa.HouseID + ", " + hfa.EmployeeID) > 0) { H_houseinfor hh = H_houseinfor.FindByHouseID(Convert.ToDecimal(hfa.HouseID)); //判断房源原先的状态(非委托中)改为委托中,并且当前日期已经大于房源的更新时间超过15天(不包括15天) if (hh.StateID != 2 && hfa.StateID == 2 && (DateTime.Now - hh.Update_date).TotalDays > 15) { //需要重新获取实体,因为在存储过程中,已经更新过 hh = H_houseinfor.FindByHouseID(Convert.ToDecimal(hfa.HouseID)); Employee emp = Employee.FindByEmployeeID(hfa.EmployeeID); //增加跟进记录 h_FollowUp hsf = new h_FollowUp(); hsf.EmployeeID = hfa.EmployeeID; hsf.HouseID = hfa.HouseID; hsf.FollowUpText = hfa.FollowText; hsf.exe_Date = hfa.CreateTime; hsf.Insert(); //更新该房源的首录人,用于统计员工新增房源工作量 hh.OwnerEmployeeID = Convert.ToInt32(emp.EmployeeID); hh.OperatorID = Convert.ToInt32(emp.EmployeeID); hh.OrgID = Convert.ToInt32(emp.OrgID); hh.Exe_date = hfa.CreateTime; } hh.Update_date = hfa.CreateTime; hh.Update(); hfa.AuditEmpID = Current.EmployeeID.ToString().ToInt32(); hfa.AuditTime = DateTime.Now; hfa.Update(); } } } } else if (Request.QueryString["doType"].ToString() == "del") { if (!string.IsNullOrEmpty(Request["ids"])) { DbHelperSQL.ExecuteSql("delete from h_FollowAudit where FollowAuditID in(" + Request["ids"] + ")"); } } #region 刷新当前页[抓取当页导航数字onclick事件] string JavaScript = " dwzPageBreak({ targetType: \"navTab\", rel: \"\", data: { pageNum: " + Request["selectPage"] + "} });"; JSDo_UserCallBack_Success(JavaScript, "操作成功"); #endregion 刷新当前页[抓取当页导航数字onclick事件] } }
/// <summary> /// 表单提交前执行 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected override void OnSaving(object sender, EntityFormEventArgs e) { //base.OnSaving(sender, e); if (Request.Form["Key"] != null) { HouseID = Request["Key"]; Entity.HouseID = Convert.ToDecimal(HouseID); Entity.EmployeeID = Employee.Current.EmployeeID; Entity.FollowUpText = "此房源照片及描述被信息部驳回,原因为:" + frmRemark.Text; Entity.exe_Date = DateTime.Now; //删除全部照片 List <h_PicList> list_h_PicList = h_PicList.FindAllByHouseID(HouseID.ToDecimal().Value); foreach (h_PicList item in list_h_PicList) { h_PicListDel list_h_PicListDel = new h_PicListDel(); list_h_PicListDel.ComID = item.ComID; list_h_PicListDel.EmployeeID = item.EmployeeID; list_h_PicListDel.Exe_date = item.exe_date; list_h_PicListDel.HouseID = item.HouseID; list_h_PicListDel.PicTypeID = item.PicTypeID; list_h_PicListDel.PicURL = item.PicURL; list_h_PicListDel.OrgID = item.OrgID; list_h_PicListDel.DelEmployeeID = Current.EmployeeID.ToInt32(); list_h_PicListDel.DelOrgID = Current.OrgID.ToInt32(); list_h_PicListDel.DelDate = DateTime.Now; list_h_PicListDel.Insert(); } DbHelperSQL.ExecuteSql("delete from h_PicList where HouseID= " + HouseID); H_houseinfor hh = H_houseinfor.FindByHouseID(Convert.ToDecimal(HouseID)); hh.HasImage = false; hh.IsSh = null; hh.LinkTel1 = null; hh.SeeHouseID = null; hh.NowStateID = null; hh.TaxesID = null; hh.AssortID = null; hh.SaleMotiveID = null; hh.ApplianceID = null; hh.PayServantID = null; hh.Update(); Log log1 = new Log(); log1.Action = "删除"; log1.Category = "删除房源照片"; log1.IP = HttpContext.Current.Request.UserHostAddress; log1.OccurTime = DateTime.Now; log1.UserID = Convert.ToInt32(Employee.Current.EmployeeID); log1.UserName = Employee.Current.Em_name; log1.Remark = "房源ID=" + HouseID; log1.Insert(); try { h_FollowUp.Meta.BeginTrans(); Entity.Insert(); H_houseinfor.Meta.Execute("update h_houseinfor set IsBh=1 where HouseID=" + Entity.HouseID.ToString()); h_FollowUp.Meta.Commit(); } catch { h_FollowUp.Meta.Rollback(); Response.Write(error()); e.Cancel = true; return; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["Name"] != null) { //照片分类ID string PicTypeID = Request["PicTypeID"].ToString(); //上传的文件夹 string Path = Request["Path"].ToString(); //上传文件名 string Name = Request["Name"].ToString(); //房源ID string HouseID = Request["HouseID"].ToString(); //人员ID string EmployeeID = Request["EmployeeID"]; if (PicTypeID != "0") { string suburl = ImageHelper.GetDbPath(Path, Name); string allurl = ImageHelper.GetUrl(suburl); h_PicList h_PicList = new h_PicList(); h_PicList.PicURL = suburl; h_PicList.PicTypeID = PicTypeID.ToDecimal().Value; if (string.IsNullOrEmpty(EmployeeID) || EmployeeID == "0") { h_PicList.OrgID = Current.OrgID.ToInt32().Value; h_PicList.EmployeeID = Current.EmployeeID.ToInt32().Value; } else { h_PicList.OrgID = int.Parse(Employee.FindByEmployeeID(Convert.ToDecimal(EmployeeID)).OrgID.ToString()); h_PicList.EmployeeID = int.Parse(EmployeeID); } h_PicList.HouseID = HouseID.ToDecimal().Value; h_PicList.Insert(); Log log1 = new Log(); log1.Action = "上传房源照片"; log1.Category = "上传房源照片"; log1.IP = HttpContext.Current.Request.UserHostAddress; log1.OccurTime = DateTime.Now; log1.UserID = Convert.ToInt32(Employee.Current.EmployeeID); log1.UserName = Employee.Current.Em_name; log1.Remark = string.Format("房源ID={0},房源编号={1}", HouseID, H_houseinfor.FindByHouseID(HouseID.ToInt32()).Shi_id); log1.Insert(); H_houseinfor hh = H_houseinfor.FindByHouseID(HouseID.ToDecimal().Value); if (hh != null) { hh.Update_date = DateTime.Now; hh.HasImage = true; hh.Update(); #region 出租积分 上传满5张照片即有积分 //租房并且不是毛坯有积分 if (hh.aType == 1 && hh.Renovation != "毛坯") { string sql = string.Format(@"SELECT count(1) FROM h_PicList Where PicTypeID>1 And EmployeeID={0} And HouseID={1}", Employee.Current.EmployeeID, HouseID); if (EntityUtils.DBUtility.DbHelperSQL.GetSingle(sql).ToInt32() >= 5) { UpdateIntegral("上传5张房源照片(租)", DateTime.Now, "H_houseinfor", "HouseID", HouseID); } } #endregion } Response.Write(allurl + "|" + Employee.Current.OrgCode + Employee.Current.OrgName + "-" + Employee.Current.Em_id + Employee.Current.Em_name + " 日期:" + DateTime.Now.ToString()); } else { //if (CheckRolePermission("上传全景照片")) //{ //h_PicList.Meta.Query("insert into h_AllViewPic(Url,EmployeeID,HouseID) values('/UploadFiles/housePIC/" + Request["Name"] + "'," + Employee.Current.EmployeeID + "," + Request["HouseID"] + ")"); //H_houseinfor.Meta.Query("update H_houseinfor set HasImage=1 where HouseID=" + Request["HouseID"]); //h_FollowUp En = new h_FollowUp(); //En.HouseID = Convert.ToDecimal(Request["HouseID"]); //En.EmployeeID = Employee.Current.EmployeeID; //En.FollowUpText = "添加全景照片"; //En.exe_Date = DateTime.Now; //En.Insert(); //UpdateIntegral("添加全景照片", DateTime.Now, "h_AllViewPic", "HouseID", Request["HouseID"]); //Response.Write(Employee.Current.OrgCode + Employee.Current.OrgName + "-" + Employee.Current.Em_id + Employee.Current.Em_name + " 日期:" + DateTime.Now.ToString()); //} //else //{ Response.Write("2"); //} } } } }
protected override void OnSaveSuccess(object sender, EntityFormEventArgs e) { if (Request.Form["txtRemark"] != null) { H_houseinfor hh = H_houseinfor.FindByHouseID(Entity.houseID); //总部认证状态 hh.state_ZBCheck = Request.QueryString["StateID"].ToInt32(); //更新日期 hh.Update_date = DateTime.Now; //认证通过 if (Request.QueryString["StateID"].ToInt32() == (int)CheckState.合格) { //当房源首录人和申请认证的人不一致时,修改首录人和门店 if (Entity.employeeID.HasValue && hh.OwnerEmployeeID != Entity.employeeID.Value) { Employee ee = Employee.FindByEmployeeID(Entity.employeeID.Value); hh.OwnerEmployeeID = (int)ee.EmployeeID; hh.OrgID = (int)ee.OrgID; } //hh.Exe_date = Entity.exe_Date.Value; //找出此房源所有未审核,未上传开盘录音的记录,将其清空 List <h_houseinfor_ZBCheck> listZB = h_houseinfor_ZBCheck.FindAll(string.Format(@"select * from h_houseinfor_ZBCheck where houseid={0} and phoneID is null and employee_auditID is null and isDel=0" , Entity.houseID)); if (listZB.Count > 0) { DbHelperSQL.ExecuteSql("update h_houseinfor_ZBCheck set isdel=1 where id in(" + string.Join(",", listZB.Select(x => x.ID).ToArray()) + ")"); } if (Entity.phoneID.HasValue) { h_RecordClose hrc = h_RecordClose.Find(h_RecordClose._.phoneID, Entity.phoneID.Value); if (hrc != null) { hrc.IsCheck = true; hrc.Update(); } else { hrc = new h_RecordClose(); i_InternetPhone iip = i_InternetPhone.FindByKey(Entity.phoneID.Value); hrc.EmployeeID = iip.employeeID; hrc.phoneID = Entity.phoneID.Value; hrc.aType = 0; hrc.CheckEmployeeID = iip.employeeID; hrc.IsCheck = true; hrc.CheckDate = DateTime.Now; hrc.exe_date = DateTime.Now; hrc.ComID = Current.ComID; hrc.Insert(); } } //增加排序积分 s_SysParam ss = s_SysParam.FindByParamCode("houseKP"); //获取分隔符的值,第一个为分值,第二是否有 有效期,第三为有效期值 string[] ssValue = ss.Value.Split('|'); e_Integral ei = new e_Integral(); ei.employeeID = Entity.employeeID.Value; ei.Type = (int)integral_Type.房源与经纪人; ei.tableName = "h_houseinfor"; ei.coloumnName = "HouseID"; ei.keyID = Entity.houseID; ei.integralParam = "houseKP"; ei.integralValue = ssValue[0].ToInt32(); ei.integralDay = ssValue[1] == "1" ? ssValue[2].ToInt32() : 0; ei.exe_Date = DateTime.Now; ei.Insert(); } //认证驳回 else if (Request.QueryString["StateID"].ToInt32() == (int)CheckState.驳回) { h_houseinfor_ZBCheck hhz = new h_houseinfor_ZBCheck(); hhz.houseID = Entity.houseID; hhz.employeeID = Entity.employeeID; hhz.exe_Date = DateTime.Now; hhz.state_ZBCheck = (int)CheckState.待认证; hhz.rejectNum = Entity.rejectNum.Value + 1; hhz.comID = Current.ComID; hhz.Insert(); } //认证 虚位以待 else if (Request.QueryString["StateID"].ToInt32() == (int)CheckState.虚位以待) { hh.OwnerEmployeeID = 0; hh.OrgID = 0; //修改为无效状态 hh.StateID = 10; hh.CurrentEmployee = Current.EmployeeID; //找出此房源所有未审核,未上传开盘录音的记录,将其清空 List <h_houseinfor_ZBCheck> listZB = h_houseinfor_ZBCheck.FindAll(string.Format(@"select * from h_houseinfor_ZBCheck where houseid={0} and phoneID is null and employee_auditID is null and isDel=0" , Entity.houseID)); if (listZB.Count > 0) { DbHelperSQL.ExecuteSql("update h_houseinfor_ZBCheck set isdel=1 where id in(" + string.Join(",", listZB.Select(x => x.ID).ToArray()) + ")"); } } hh.Update(); } ShowMsg(AlertType.correct, "保存成功"); //base.OnSaveSuccess(sender, e); }