private void GetTagStatisticData(out string msg)
{
msg = "";
int totcount;
int userID = BLL.Util.GetLoginUserID();
Entities.QueryCC_CustUserMapping query = new Entities.QueryCC_CustUserMapping();
if (!string.IsNullOrEmpty(RequestCustName))
{
query.CustName = RequestCustName.Trim();
}
if (!string.IsNullOrEmpty(RequestBrand))
{
query.Brandids = RequestBrand.Trim();
}
if (!string.IsNullOrEmpty(RequestSearchTrueNameID))
{
query.UserName = RequestSearchTrueNameID.Trim();
}
//坐席查询条件：是否有坐席
query.NoResponser = RequestNoResponser;
if (!string.IsNullOrEmpty(RequestProvinceID) && int.Parse(RequestProvinceID) > 0)
{
query.ProvinceID = RequestProvinceID.Trim();
}
if (!string.IsNullOrEmpty(RequestCityID) && int.Parse(RequestCityID) > 0)
{
query.CityID = RequestCityID.Trim();
}
if (!string.IsNullOrEmpty(RequestCountyID) && int.Parse(RequestCountyID) > 0)
{
query.CountyID = RequestCountyID.Trim();
}
//add by qizq 2012-5-30 客户类型经和营范围
if (!string.IsNullOrEmpty(ClientType))
{
query.TypeID = ClientType;
}
if (!string.IsNullOrEmpty(CarType))
{
query.CarType = CarType;
}
//add lxw 12.6.8 最近访问时间
if (!string.IsNullOrEmpty(StartTime))
{
query.StartTime = DateTime.Parse(StartTime);
}
if (!string.IsNullOrEmpty(EndTime))
{
query.EndTime = DateTime.Parse(EndTime);
}
if (Contact != -2)
{
query.Contact = Contact;
}
if (!string.IsNullOrEmpty(RequestProjectName))
{
query.ProjectName = RequestProjectName.Trim();
}
if (!string.IsNullOrEmpty(radioTaoche))
{
query.radioTaoche = radioTaoche;
}
//取当前人所对应的数据权限组
Entities.QueryUserGroupDataRigth QueryUserGroupDataRigth = new Entities.QueryUserGroupDataRigth();
QueryUserGroupDataRigth.UserID = userID;
DataTable dtUserGroupDataRigth = BLL.UserGroupDataRigth.Instance.GetUserGroupDataRigth(QueryUserGroupDataRigth, "", 1, 100000, out totcount);
string Rolename = string.Empty;
query.UserID = userID;//进列表肯定有查看本人负责的客户信息
if (dtUserGroupDataRigth != null && dtUserGroupDataRigth.Rows.Count > 0)
{
for (int i = 0; i < dtUserGroupDataRigth.Rows.Count; i++)
{
//4s电话营销，非4s电话营销
if (dtUserGroupDataRigth.Rows[i]["bgid"].ToString() == "6" || dtUserGroupDataRigth.Rows[i]["bgid"].ToString() == "7" || dtUserGroupDataRigth.Rows[i]["bgid"].ToString() == "19" || dtUserGroupDataRigth.Rows[i]["bgid"].ToString() == "27")
{
//本组
query.BGIDStr += dtUserGroupDataRigth.Rows[i]["bgid"].ToString() + ",";
}
}
}
if (!string.IsNullOrEmpty(ReqeustCCProjectName))
{
query.ReqeustCCProjectName = ReqeustCCProjectName;
}
DataTable dtUserTags = BitAuto.YanFa.Crm2009.BLL.CustTag.Instance.GetCustTagByUserID(userID);
string TagIDs = "";
foreach (DataRow row in dtUserTags.Rows)
{
TagIDs += "," + row["TagID"];
}
if (TagIDs.Length > 0)
{
TagIDs = TagIDs.Substring(1);
}
else
{
TagIDs = "0";
}
query.TagID = TagIDs;
DataTable dt = BLL.CC_UserCustDataRigth.Instance.GetCustUserMappingTagStatisticsByUserID(query, userID);
DataColumn newcol = new DataColumn("ThisTagNum", typeof(string));
dtUserTags.Columns.Add(newcol);
//拼接起来
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
foreach (DataRow row2 in dtUserTags.Rows)
{
if (row["TagName"].ToString() == row2["TagName"].ToString())
{
row2["ThisTagNum"] = row["TheTagNum"];
}
}
}
}
if (dtUserTags == null || dtUserTags.Rows.Count < 1)
{
msg = "{ }";
}
else
{
int i = 0;
foreach (DataRow row in dtUserTags.Rows)
{
if (row["ThisTagNum"] == null || string.IsNullOrEmpty(row["ThisTagNum"].ToString()))
{
msg += "'" + i + "':['" + row["TagID"].ToString() + "','0','" + row["TagName"].ToString() + "'],";
i++;
}
else
{
msg += "'" + i + "':['" + row["TagID"].ToString() + "','" + row["ThisTagNum"] + "','" + row["TagName"].ToString() + "'],";
i++;
// msg += "'" + row["TagName"].ToString() + "':['" + row["TagID"].ToString() + "','" + row["ThisTagNum"] + "'],";
}
}
if (msg.Length < 1)
{
msg = "{ }";
}
else
{
msg = "{ " + msg.Substring(0, msg.Length - 1) + "}";
}
}
}
private string GetList()
{
QueryCrmCustInfo queryCustInfo = new QueryCrmCustInfo();
#region 条件
if (CustID != string.Empty)
{
queryCustInfo.CustID = CustID;
}
if (CustName != string.Empty)
{
queryCustInfo.CustName = CustName;
}
if (CustAbbr != string.Empty)
{
queryCustInfo.AbbrName = CustAbbr;
}
if (BrandIDs != string.Empty)
{
queryCustInfo.BrandID = BrandIDs;
}
if (CarType != string.Empty)
{
queryCustInfo.CarType = CarType;
}
if (ProvinceID > 0)
{
queryCustInfo.ProvinceID = ProvinceID.ToString();
}
if (CityID > 0)
{
queryCustInfo.CityID = CityID.ToString();
}
if (CountyID > 0)
{
queryCustInfo.CountyID = CountyID.ToString();
}
//if (IsHavMember)
//{
// queryCustInfo.IsHaveMember = true;
//}
//if (IsNoHavMember)
//{
// queryCustInfo.IsHaveNoMember = true;
//}
if (!string.IsNullOrEmpty(CustType))
{
queryCustInfo.TypeID = CustType;
}
if (!string.IsNullOrEmpty(Address))
{
queryCustInfo.Address = Address;
}
if (!string.IsNullOrEmpty(TradeMarketID))
{
queryCustInfo.TradeMarketID = TradeMarketID;
}
if (CustStatus != string.Empty && CustStatus != "0,1")
{
queryCustInfo.StatusIDs = CustStatus;
}
if (CooperateStatusIDs != string.Empty)
{
queryCustInfo.CooperateStatusIDs = CooperateStatusIDs;
}
if (CooperatedStatusIDs != string.Empty)
{
queryCustInfo.CooperatedStatusIDs = CooperatedStatusIDs;
}
if (CustLockStatus != string.Empty && CustLockStatus != "0,1")
{
queryCustInfo.Lock = int.Parse(CustLockStatus);
}
if (DataSource != string.Empty && DataSource != "1,0")
{
queryCustInfo.TaskType = int.Parse(DataSource);
}
if (!string.IsNullOrEmpty(RequestBeginMemberCooperatedTime))
{
queryCustInfo.BeginMemberCooperatedTime = RequestBeginMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestEndMemberCooperatedTime))
{
queryCustInfo.EndMemberCooperatedTime = RequestEndMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestBeginNoMemberCooperatedTime))
{
queryCustInfo.BeginNoMemberCooperatedTime = RequestBeginNoMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestEndNoMemberCooperatedTime))
{
queryCustInfo.EndNoMemberCooperatedTime = RequestEndNoMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestMemberCooperateStatus))
{
queryCustInfo.MemberCooperateStatus = RequestMemberCooperateStatus;
}
if (!string.IsNullOrEmpty(RequestCreateCustStartDate))
{
queryCustInfo.CreateTimeStart = RequestCreateCustStartDate;
}
if (!string.IsNullOrEmpty(RequestCreateCustEndDate))
{
queryCustInfo.CreateTimeEnd = RequestCreateCustEndDate;
}
if (!string.IsNullOrEmpty(RequestAreaTypeIDs))
{
queryCustInfo.AreaTypeIDs = RequestAreaTypeIDs;
}
if (!string.IsNullOrEmpty(RequestProjectName))
{
queryCustInfo.ProjectName = RequestProjectName.Trim();
}
if (!string.IsNullOrEmpty(RequestStartMemberCooperatedBeginTime) ||
!string.IsNullOrEmpty(RequestEndMemberCooperatedBeginTime))
{
queryCustInfo.CooperatedStatusIDs = "1";
if (!string.IsNullOrEmpty(RequestStartMemberCooperatedBeginTime))
{
queryCustInfo.StartMemberCooperatedBeginTime = RequestStartMemberCooperatedBeginTime.Trim();
}
if (!string.IsNullOrEmpty(RequestEndMemberCooperatedBeginTime))
{
queryCustInfo.EndMemberCooperatedBeginTime = RequestEndMemberCooperatedBeginTime.Trim();
}
}
#endregion
DataTable dt = BLL.CrmCustInfo.Instance.GetCC_CrmCustIDsByAlone(queryCustInfo);
List <string> colList = new List <string>();
colList.Add("CustID");
string jsonStr = Converter.DataTable2Json(dt, colList);
return(jsonStr);
}
private void BindData()
{
Stopwatch sw = new Stopwatch();
sw.Start();
int totcount = 0;
if (!int.TryParse(RequestPageSize, out PageSize))
{
PageSize = 20;
}
Entities.QueryCC_CustUserMapping query = new Entities.QueryCC_CustUserMapping();
if (!string.IsNullOrEmpty(RequestCustName))
{
query.CustName = RequestCustName.Trim();
}
if (!string.IsNullOrEmpty(RequestBrand))
{
query.Brandids = RequestBrand.Trim();
}
if (!string.IsNullOrEmpty(RequestSearchTrueNameID))
{
query.UserName = RequestSearchTrueNameID.Trim();
}
//坐席查询条件：是否有坐席
query.NoResponser = RequestNoResponser;
if (!string.IsNullOrEmpty(RequestProvinceID) && int.Parse(RequestProvinceID) > 0)
{
query.ProvinceID = RequestProvinceID.Trim();
}
if (!string.IsNullOrEmpty(RequestCityID) && int.Parse(RequestCityID) > 0)
{
query.CityID = RequestCityID.Trim();
}
if (!string.IsNullOrEmpty(RequestCountyID) && int.Parse(RequestCountyID) > 0)
{
query.CountyID = RequestCountyID.Trim();
}
//add by qizq 2012-5-30 客户类型经和营范围
if (!string.IsNullOrEmpty(ClientType))
{
query.TypeID = ClientType;
}
if (!string.IsNullOrEmpty(CarType))
{
query.CarType = CarType;
}
//add lxw 12.6.8 最近访问时间
if (!string.IsNullOrEmpty(StartTime))
{
query.StartTime = DateTime.Parse(StartTime);
}
if (!string.IsNullOrEmpty(EndTime))
{
query.EndTime = DateTime.Parse(EndTime);
}
if (Contact != -2)
{
query.Contact = Contact;
}
if (!string.IsNullOrEmpty(RequestProjectName))
{
query.ProjectName = RequestProjectName.Trim();
}
if (!string.IsNullOrEmpty(radioTaoche))
{
query.radioTaoche = radioTaoche;
}
//取当前人所对应的数据权限组
Entities.QueryUserGroupDataRigth QueryUserGroupDataRigth = new Entities.QueryUserGroupDataRigth();
QueryUserGroupDataRigth.UserID = userID;
DataTable dtUserGroupDataRigth = BLL.UserGroupDataRigth.Instance.GetUserGroupDataRigth(QueryUserGroupDataRigth, "", 1, 100000, out totcount);
string Rolename = string.Empty;
query.UserID = userID;//进列表肯定有查看本人负责的客户信息
if (dtUserGroupDataRigth != null && dtUserGroupDataRigth.Rows.Count > 0)
{
for (int i = 0; i < dtUserGroupDataRigth.Rows.Count; i++)
{
//4s电话营销，非4s电话营销
if (dtUserGroupDataRigth.Rows[i]["bgid"].ToString() == "6" || dtUserGroupDataRigth.Rows[i]["bgid"].ToString() == "7" || dtUserGroupDataRigth.Rows[i]["bgid"].ToString() == "19" || dtUserGroupDataRigth.Rows[i]["bgid"].ToString() == "27")
{
//本组
query.BGIDStr += dtUserGroupDataRigth.Rows[i]["bgid"].ToString() + ",";
}
}
}
if (!string.IsNullOrEmpty(ReqeustCCProjectName))
{
query.ReqeustCCProjectName = ReqeustCCProjectName;
}
query.TagID = TagID;
int count;
DataTable dt;
string order = "ISNULL(ISNULL(b1.NextVisitDate,b2.NextVisitDate),'9999-12-30'),ISNULL(a.LastUpdateTime,'9999-12-30')";
dt = BLL.CC_UserCustDataRigth.Instance.GetCustUserMappingByUserID(query, order, PageCommon.Instance.PageIndex, PageSize, out count);
string s1 = sw.Elapsed.ToString();
RecordCount = count;
repeaterList.DataSource = dt;
repeaterList.DataBind();
litPagerDown.Text = PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), GroupLength, count, PageSize, PageCommon.Instance.PageIndex, 1);
sw.Stop();
string s2 = sw.Elapsed.ToString();
}