/// <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);
}
