/// <summary> /// 重写查找条件 /// </summary> /// <param name="typeName"></param> /// <returns></returns> protected override string GetWhereClauseFromSearchBar(string typeName) { sb.Append(base.GetWhereClauseFromSearchBar(typeName)); if (Request.QueryString["CustomerID"] != null) { c_Customer myCC = c_Customer.FindByCustomerID(Convert.ToDecimal(Request.QueryString["CustomerID"])); //小区地址暂时没加 if (myCC.NeedBuildAreaID > 0) { c_NeedBuildArea Cn = c_NeedBuildArea.FindByNeedBuildAreaID(myCC.NeedBuildAreaID); if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" build_area>={0} ", Cn.bValue); sb.Append(" AND "); sb.AppendFormat(" build_area<={0} ", Cn.eValue); } if (myCC.NeedHouseTypeID > 0) { c_NeedHouseType Cn = c_NeedHouseType.FindByNeedHouseTypeID(myCC.NeedHouseTypeID); if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" form_bedroom>={0} ", Cn.bValue); sb.Append(" AND "); sb.AppendFormat(" form_bedroom<={0} ", Cn.eValue); } if (myCC.NeedFloorID > 0) { c_NeedFloor Cn = c_NeedFloor.FindByNeedFloorID(myCC.NeedFloorID); if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" build_floor>={0} ", Cn.bValue); sb.Append(" AND "); sb.AppendFormat(" build_floor<={0} ", Cn.eValue); } if (myCC.NeedPriceID > 0) { c_NeedPrice Cn = c_NeedPrice.FindByNeedPriceID(myCC.NeedPriceID); if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" sum_price>={0} ", Cn.bValue); sb.Append(" AND "); sb.AppendFormat(" sum_price<={0} ", Cn.eValue); } if (myCC.NeedFitmentID > 0) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" FitmentID={0} ", myCC.NeedFitmentID); } if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" StateID=2 "); } string parms = Request.QueryString["OperType"]; switch (parms) { case "0": if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" aType = " + parms); break; case "1": if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" aType = " + parms); break; case "2": if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" aType=1 and OrgID in " + GetEmployeeOrgTableIds(Convert.ToInt32(HouseMIS.EntityUtils.Employee.Current.EmployeeID), RangeType.本店)); break; case "3": if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" aType=1 and OwnerEmployeeID= " + HouseMIS.EntityUtils.Employee.Current.EmployeeID.ToString()); break; case "4": if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" aType=0 and OwnerEmployeeID= " + HouseMIS.EntityUtils.Employee.Current.EmployeeID.ToString()); break; case "5": if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" HouseID in(select HouseID from h_HouseCollect where EmployeeID=" + HouseMIS.EntityUtils.Employee.Current.EmployeeID.ToString() + ")"); break; case "6": if (Request.QueryString["HouseID"] != null) { string HouseID = Request.QueryString["HouseID"]; if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat("HouseID in (select A.HouseID from h_houseinfor A left join h_houseinfor B on A.HouseDicName=B.HouseDicName and A.build_id=B.build_id and A.build_unit=B.build_unit and A.build_room=B.build_room where B.HouseID={0})", HouseID); } break; case "7": if (Request.QueryString["HouseID"] != null) { string HouseID = Request.QueryString["HouseID"]; if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat("HouseID in (select A.HouseID from h_houseinfor A left join h_houseinfor B on A.HouseDicAddress=B.HouseDicAddress and A.form_bedroom=B.form_bedroom and A.Build_area<B.Build_area+5 and A.Build_area>B.Build_area-5 where B.HouseID={0})", HouseID); } break; case "8": //今日房源 且有效的房源 if (sb.Length > 0) { sb.Append(" AND "); } sb.Append("exe_date>'" + DateTime.Now.ToString("yyyy-MM-dd") + "' AND CONVERT(varchar(12),exe_date,103)=CONVERT(varchar(12),getdate(),103) AND StateID=2"); break; case "9": if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" aType=0 and OrgID in " + GetEmployeeOrgTableIds(Convert.ToInt32(HouseMIS.EntityUtils.Employee.Current.EmployeeID), RangeType.本店)); break; default: break; } //string op = Request.QueryString["op"]; //if (op != null) //{ // switch (op) // { // case "1": // if (sb.Length > 0) { sb.Append("AND "); } // sb.AppendFormat(" OrgID = " + HouseMIS.EntityUtils.Employee.Current.OrgID.ToString()); // break; // } //} if (!GetMySearchControlValue("HouseDicName").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" HouseDicName like '%{0}%'", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("HouseDicName"))); } if (!GetMySearchControlValue("build_id").IsNullOrWhiteSpace()) { string build_id = HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("build_id")); if (build_id.ToInt32() > 9) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" build_id like '%{0}%'", build_id); } else { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" build_id='{0}'", build_id); } } if (!GetMySearchControlValue("note").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" note like '%{0}%'", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("note"))); } if (!GetMySearchControlValue("HouseDicID").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } string[] s = HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("HosueDicID")).Split('|'); sb.AppendFormat(" HouseDicID={0} ", s[0]); if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" SanjakID={0} ", s[1]); } if (!GetMySearchControlValue("area1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" Build_area>={0}", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("area1"))); } if (!GetMySearchControlValue("area2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" Build_area<={0}", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("area2"))); } if (!GetMySearchControlValue("Price1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" sum_price>={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("Price1"))); } if (!GetMySearchControlValue("Price2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" sum_price<={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("Price2"))); } //if (!GetMySearchControlValue("shi_addr1").IsNullOrWhiteSpace() && !GetMySearchControlValue("shi_addr2").IsNullOrWhiteSpace()) //{ // if (sb.Length > 0) // sb.Append(" AND "); // sb.AppendFormat(" HouseID in (select HouseID from h_houseinfor h left join s_HouseDicFloorPrice s on h.build_floor=s.Floor and h.HouseDicID=s.HouseDicID where Price>={0} and Price<={1}) ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("shi_addr1")), HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("shi_addr2"))); //} //else if (!GetMySearchControlValue("shi_addr1").IsNullOrWhiteSpace()) //{ // if (sb.Length > 0) // sb.Append(" AND "); // sb.AppendFormat(" HouseID in (select HouseID from h_houseinfor h left join s_HouseDicFloorPrice s on h.build_floor=s.Floor and h.HouseDicID=s.HouseDicID where Price>={0}) ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("shi_addr1"))); //} //else if (!GetMySearchControlValue("shi_addr2").IsNullOrWhiteSpace()) //{ // if (sb.Length > 0) // sb.Append(" AND "); // sb.AppendFormat(" HouseID in (select HouseID from h_houseinfor h left join s_HouseDicFloorPrice s on h.build_floor=s.Floor and h.HouseDicID=s.HouseDicID where Price<={0}) ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("shi_addr2"))); //} if (!GetMySearchControlValue("Ohter2ID1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" Ohter2ID>={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("Ohter2ID1"))); } if (!GetMySearchControlValue("Ohter2ID2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" Ohter2ID<={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("Ohter2ID2"))); } if (!GetMySearchControlValue("exe_date1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" exe_date>='{0}' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("exe_date1"))); } if (!GetMySearchControlValue("exe_date2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" exe_date<='{0} 23:59:59' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("exe_date2"))); } if (!GetMySearchControlValue("FollowUp_Date1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" FollowUp_Date>='{0}' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("FollowUp_Date1"))); } if (!GetMySearchControlValue("FollowUp_Date2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" FollowUp_Date<='{0} 23:59:59' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("FollowUp_Date2"))); } if (!GetMySearchControlValue("update_date1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" update_date>='{0}' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("update_date1"))); } if (!GetMySearchControlValue("update_date2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" update_date<='{0} 23:59:59' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("update_date2"))); } if (!GetMySearchControlValue("build_floor1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" build_floor>='{0}' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("build_floor1").ToInt32().ToString())); } if (!GetMySearchControlValue("build_floor2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" build_floor<='{0}' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("build_floor2").ToInt32().ToString())); } if (!GetMySearchControlValue("Build_area1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" Build_area>={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("Build_area1"))); } if (!GetMySearchControlValue("Build_area2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" Build_area<={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("Build_area2"))); } if (!GetMySearchControlValue("dprice1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" (sum_price * 10000)/build_area>={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("dprice1"))); } if (!GetMySearchControlValue("dprice2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" (sum_price * 10000)/build_area<={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("dprice2"))); } if (!GetMySearchControlValue("sum_price1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" sum_price>={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("sum_price1"))); } if (!GetMySearchControlValue("sum_price2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" sum_price<={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("sum_price2"))); } if (!GetMySearchControlValue("Rent_Price1").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" Rent_Price>={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("Rent_Price1"))); } if (!GetMySearchControlValue("Rent_Price2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" Rent_Price<={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("Rent_Price2"))); } if (!GetMySearchControlValue("FitmentID").IsNullOrWhiteSpace()) { if (h_Fitment.Find("FitmentID", GetMySearchControlValue("FitmentID")).Name == "装修") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" FitmentID is not null and FitmentID<>{0} ", h_Fitment.Find("Name", "毛坯").FitmentID); } else { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" FitmentID={0} ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("FitmentID"))); } } if (!GetMySearchControlValue("BackUpCode").IsNullOrWhiteSpace()) { string aa = GetMySearchControlValue("BackUpCode"); if (aa == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" BackUpCode is not null"); } } if (!GetMySearchControlValue("OperatorID").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" OperatorID in (select EmployeeID from e_Employee where em_name like '%{0}%') ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("OperatorID"))); } if (!GetMySearchControlValue("OwenEmployeeID").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" OwnerEmployeeID in (select EmployeeID from e_Employee where em_name like '%{0}%') ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("OwenEmployeeID"))); } //if (GetMySearchControlValue("shi_addr") == "on") //{ // if (sb.Length > 0) // sb.Append(" AND "); // sb.AppendFormat(" HouseID in (select HouseID from h_houseinfor h left join s_HouseDicFloorPrice s on h.build_floor=s.Floor and h.HouseDicID=s.HouseDicID and h.Build_id=s.Build_id where Price>0) "); //} if (GetMySearchControlValue("HXImg") == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" HouseID in (select HouseID from h_PicList where PicTypeID=1) "); } if (GetMySearchControlValue("IsLock") == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" IsLock=1 "); } if (GetMySearchControlValue("HasRecord") == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" (HasRecord=1 or HouseID in(select houseID from i_InternetPhone where recordUrlDel=1))"); } //if (GetMySearchControlValue("AllView") == "on") //{ // if (sb.Length > 0) // sb.Append(" AND "); // sb.AppendFormat(" HouseID in (select HouseID from h_AllViewPic) "); //} if (GetMySearchControlValue("HasKey") == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" HasKey=1 "); } if (GetMySearchControlValue("HasImage") == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" HasImage=1 "); } if (GetMySearchControlValue("IsVideo") == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" IsVideo=1 "); } if (GetMySearchControlValue("IsBring") == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" shi_id in (select HouseList from c_BringCustomer)"); } if (GetMySearchControlValue("IsPrivate") == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" IsPrivate=1 "); } if (GetMySearchControlValue("EntrustType") == "on") { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" EntrustTypeID={0} ", h_EntrustType.Find("Name", "独家委托").EntrustTypeID.ToString()); } if (!GetMySearchControlValue("Shi_id").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" Shi_id like '%{0}%' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("Shi_id"))); } if (!GetMySearchControlValue("HouseDicAddress").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" HouseDicAddress like '%{0}%' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("HouseDicAddress"))); } if (!GetMySearchControlValue("AreaID").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" SanjakID in (select SanjakID from s_Sanjak where AreaID={0}) ", GetMySearchControlValue("AreaID")); } if (!GetMySearchControlValue("LinkTel2").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" LinkTel2 like '%{0}%' ", GetMySearchControlValue("LinkTel2").TelEncrypt2(false)); } //if (!GetMySearchControlValue("landlord_tel2").IsNullOrWhiteSpace()) //{ // if (sb.Length > 0) // sb.Append(" AND "); // sb.AppendFormat(" landlord_tel2 like '%{0}%' ", GetMySearchControlValue("landlord_tel2").TelEncrypt2(false)); //} //楼盘/地址 if (!GetMySearchControlValue("EstateOrAddress").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" (HouseDicName like '%{0}%' OR HouseDicAddress like '%{0}%') ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("EstateOrAddress"))); } else if (Request["HouseDicID"].ToInt32() > 0) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat("(HouseDicID={0}) ", Request["HouseDicID"].ToInt32()); if (this.pagerForm.Action.IndexOf("HouseDicID") == -1) { this.pagerForm.Action += "&HouseDicID=" + Request["HouseDicID"]; } } //if (!GetMySearchControlValue("landlord_tel2").IsNullOrWhiteSpace()) //{ // if (sb.Length > 0) // sb.Append(" AND "); // sb.AppendFormat(" (landlord_tel2 like '%{0}%' OR LinkTel2 like '%{0}%') ", GetMySearchControlValue("landlord_tel2").TelEncrypt2(false)); //} if (!GetMySearchControlValue("landlord_tel2").IsNullOrWhiteSpace()) { String tel = GetMySearchControlValue("landlord_tel2").Trim(); if (sb.Length > 0) { sb.Append(" AND "); } String ids = H_houseinfor.FindHouseIDsByTel(tel); if (ids.IsNullOrWhiteSpace()) { tel += "00"; sb.AppendFormat(" HouseID in (select HouseID from h_HouseTelList where Tel2 like '{0}%' and DelType=0)", tel.TelEncrypt().Substring(0, tel.Length - 2)); } else { sb.AppendFormat(" HouseID in ({0})", ids); } } if (!GetMySearchControlValue("landlord_name").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" landlord_name like '%{0}%' ", HouseMIS.EntityUtils.StringHelper.Filter(GetMySearchControlValue("landlord_name"))); } if (!GetMySearchControlValue("BackTel").IsNullOrWhiteSpace()) { if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat(" BackTel like '%{0}%' ", GetMySearchControlValue("BackTel").TelEncrypt2(false)); } //if (sb.Length > 0) // sb.Append(" AND "); //sb.Append(GetRolePermissionEmployeeIds("查看", "OwnerEmployeeID")); if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(" (IsLock=0 or " + GetRolePermissionOrgIds("查看锁盘", "OrgID") + ") and IsNull(bID,0)<>1 and DelType=1"); return(sb.Length == 0 ? null : sb.ToString()); }
public int showopts(object opts, object op) { int i = 0; if (opts.ToInt32() == 1) { try { HouseMIS.EntityUtils.c_BringCustomer.Meta.Query("UPDATE c_BringCustomer SET Isshenhe = 1 , shenOperatorDate = GETDATE() , shenOperatorID ='" + HouseMIS.EntityUtils.Employee.Current.EmployeeID + "' WHERE BringCustomerID = " + op); //HouseMIS.EntityUtils.c_BringCustomer.Meta.Query("UPDATE c_BringCustomer SET Isshenhe = 1 WHERE BringCustomerID = " + op); //HouseMIS.EntityUtils.c_BringCustomer.Meta.Query("UPDATE c_BringCustomer SET shenOperatorDate = GETDATE() AND shenOperatorID = '" + HouseMIS.EntityUtils.Employee.Current.EmployeeID + "' WHERE BringCustomerID = " + op); } catch { i = 0; } finally { i = 1; string BID = op.ToString2(); c_BringCustomer cb = c_BringCustomer.FindByBringCustomerID(Convert.ToInt32(BID)); if (cb != null) { c_Customer c = c_Customer.FindByCus_id(cb.CustomerID); if (c != null) { DataTable dt = I_IntegralLog.Meta.Query("SELECT * FROM I_IntegralLog WHERE Remak='添加客户积分' AND KeyValue ='" + c.CustomerID + "'").Tables[0]; if (dt.Rows.Count == 0) { var AddIntegral = System.Math.Abs(Math.Round((Convert.ToDecimal(c.NPrice) * 40), 0)); c_Customer.UpdateIntegral(AddIntegral.ToInt32().Value, "添加客户积分", c.OperatorID.ToInt32().Value, DateTime.Now, "c_Customer", "CustomerID", c.CustomerID.ToString()); } } } } } else if (opts.ToInt32() == 0) { try { HouseMIS.EntityUtils.c_BringCustomer.Meta.Query("UPDATE c_BringCustomer SET Isshenhe = 0 , shenOperatorDate = GETDATE() , shenOperatorID ='" + HouseMIS.EntityUtils.Employee.Current.EmployeeID + "' WHERE BringCustomerID = " + op); //HouseMIS.EntityUtils.c_BringCustomer.Meta.Query("UPDATE c_BringCustomer SET Isshenhe = 0 WHERE BringCustomerID = " + op); //HouseMIS.EntityUtils.c_BringCustomer.Meta.Query("UPDATE c_BringCustomer SET shenOperatorDate = GETDATE() AND shenOperatorID = '" + HouseMIS.EntityUtils.Employee.Current.EmployeeID + "' WHERE BringCustomerID = " + op); } catch { i = 0; } finally { i = 1; string BID = op.ToString2(); c_BringCustomer cb = c_BringCustomer.FindByBringCustomerID(Convert.ToInt32(BID)); if (cb != null) { c_Customer c = c_Customer.FindByCus_id(cb.CustomerID); if (c != null) { DataTable dt = I_IntegralLog.Meta.Query("SELECT * FROM I_IntegralLog WHERE Remak='添加客户积分' AND KeyValue ='" + c.CustomerID + "'").Tables[0]; if (dt.Rows.Count > 0) { I_IntegralLog.Meta.Query("DELETE FROM I_IntegralLog WHERE Remak='添加客户积分 AND KeyValue = " + c.CustomerID); } } } } } return(i); }