public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
currentContext = context;
BitAuto.YanFa.SysRightManager.Common.UserInfo.Check();
//添加用户信息
if (context.Request.QueryString["add"] != null && context.Request.QueryString["add"] == "yes")
{
BitAuto.YanFa.Crm2009.Entities.ContactInfo model = new BitAuto.YanFa.Crm2009.Entities.ContactInfo();
model.PID = Convert.ToInt32(RequestPid);
model.CustID = RequestCustID;
model.CName = RequestCName;
model.EName = RequestEName;
model.Sex = RequestSex;
model.DepartMent = RequestDepartMent;
model.OfficeTypeCode = int.Parse(RequestOfficeTypeCode.Trim());
model.Title = RequestTitle;
model.OfficeTel = RequestOfficeTel;
model.Phone = RequestPhone;
model.Email = RequestEmail;
model.Fax = RequestFax;
model.Remark = RequestReamrk;
model.CreateTime = DateTime.Now;
model.Status = 0;
model.Address = RequestAddress;
model.ZipCode = RequestZipCode;
model.MSN = RequestMsn;
model.Birthday = RequestBirthday;
model.Hobby = Hobby;
model.Responsible = Responsible;
model.CreateUserID = BLL.Util.GetLoginUserID();
int contactID = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.InsertContactInfo(model);
if (contactID > 0)
{
int userid = model.CreateUserID;
//插入CC添加联系人记录日志
BLL.ProjectTask_ReturnVisit.Instance.InsertCCAddCRMContractLogForRV(contactID, userid);
//
message = "Add:'yes'";
AddContactUserMapping(contactID);
//负责会员处理(按顺序执行)
YesSelectMemberHandle(contactID);
NotSelectMemberHandle(contactID);
YesSelectMainHandle(contactID);
NotSelectMainHandle(contactID);
//添加日志记录 BY cheng ON 2011-08-12
string content = string.Format("为【{0}(ID:{1})】添加联系人【{2}】成功。", BitAuto.YanFa.Crm2009.BLL.AllCusts.Instance.GetCustName(model.CustID), model.CustID, model.CName);
BitAuto.YanFa.SysRightManager.Common.LogInfo.Instance.InsertLog(BitAuto.YanFa.Crm2009.BLL.LogModule.ContactInfo, (int)BitAuto.YanFa.SysRightManager.Common.LogInfo.ActionType.Add, content);
message = "Add:'yes',Edit:'no'";
}
else
{
message = "Add:'no'";
}
context.Response.Write("{" + message + "}");
context.Response.End();
}
//编辑用户信息
else if (context.Request.QueryString["edit"] != null && context.Request.QueryString["edit"] == "yes")
{
BitAuto.YanFa.Crm2009.Entities.ContactInfo model = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfoByUserID(RequestID);
if (model != null)
{
model.PID = Convert.ToInt32(RequestPid);
model.CName = RequestCName;
model.EName = RequestEName;
model.Sex = RequestSex;
model.DepartMent = RequestDepartMent;
int typecode = 0;
Int32.TryParse(RequestOfficeTypeCode, out typecode);
model.OfficeTypeCode = typecode;
model.Title = RequestTitle;
model.OfficeTel = RequestOfficeTel;
model.Phone = RequestPhone;
model.Email = RequestEmail;
model.Fax = RequestFax;
model.Remark = RequestReamrk;
model.Address = RequestAddress;
model.ZipCode = RequestZipCode;
model.MSN = RequestMsn;
model.Birthday = RequestBirthday;
model.Hobby = Hobby;
model.Responsible = Responsible;
model.ModifyTime = DateTime.Now;
model.ModifyUserID = BLL.Util.GetLoginUserID();
//添加日志记录 BY cheng ON 2011-08-12
string content = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetUpdateContent(model, "{0}由【{1}】修改为【{2}】", '，');
if (BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.UpdateContactInfo(model) > 0)
{
message = "Add:'yes'";
EditContactUserMapping(model.ID);
//负责会员处理(按顺序执行)
YesSelectMemberHandle(RequestID);
NotSelectMemberHandle(RequestID);
YesSelectMainHandle(RequestID);
NotSelectMainHandle(RequestID);
try
{
content = string.Format("为【{0}(ID:{1})】修改联系人【{2}】：{3}。",
BitAuto.YanFa.Crm2009.BLL.AllCusts.Instance.GetCustName(model.CustID), model.CustID, model.CName, content);
BitAuto.YanFa.SysRightManager.Common.LogInfo.Instance.InsertLog(BitAuto.YanFa.Crm2009.BLL.LogModule.ContactInfo, (int)BitAuto.YanFa.SysRightManager.Common.LogInfo.ActionType.Update, content);
message = "Add:'yes',Edit:'yes'";
}
catch (Exception ex)
{
message = ex.Message;
}
}
else
{
message = "Add:'no'";
}
}
else
{
message = "Add:'no'";
}
context.Response.Write("{" + message + "}");
context.Response.End();
}
//获取一条记录
else if (context.Request.QueryString["show"] != null && context.Request.QueryString["show"] == "yes")
{
BitAuto.YanFa.Crm2009.Entities.ContactInfo model = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfoByUserID(RequestID);
if (model != null)
{
model.CreateUserTrueName = GetUserInfoTrueName(model.CreateUserID);
model.CreateTimeFormat = string.Format("{0:yyyy-MM-dd}", model.CreateTime);
model.ModifyUserTrueName = GetUserInfoTrueName(model.ModifyUserID);
model.ModifyTimeFormat = string.Format("{0:yyyy-MM-dd}", model.ModifyTime);
string strwhere = " ContactID = '" + model.ID.ToString() + "' and Status=0 ";
DataSet dstSet = BitAuto.YanFa.Crm2009.BLL.ContactUserMapping.Instance.GetList(strwhere);
for (int i = 0; i < dstSet.Tables[0].Rows.Count; i++)
{
model.ContactUserS += GetTrueName(dstSet.Tables[0].Rows[i]["UserID"].ToString()) + ",";
model.hid_ContactUserS += dstSet.Tables[0].Rows[i]["UserID"] + ",";
}
result = JavaScriptConvert.SerializeObject(model);
message = "yes";
}
else
{
success = false;
message = "no";
}
AJAXHelper.WrapJsonResponse(success, result, message);
}
//删除一条记录
else if (context.Request["action"] != null && context.Request["action"] == "DeleteContact")
{
BitAuto.YanFa.Crm2009.Entities.ContactInfo contact = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfoByUserID(RequestID);
if (contact != null)
{
//删除CC添加联系人记录日志
BLL.ProjectTask_ReturnVisit.Instance.DeleteCCAddCRMContractLogForRV(RequestID);
//
BitAuto.YanFa.Crm2009.BLL.ContactUserMapping.Instance.DeleteByContactID(contact.ID);
//删除会员联系人关联关系
BitAuto.YanFa.Crm2009.BLL.MemberContactMapping.Instance.DeleteByContactID(contact.ID);
if (BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.Delete(RequestID) > 0)
{
message = "yes";//成功
//添加日志记录 BY cheng ON 2011-08-12
string content = string.Format("为【{0}(ID:{1})】删除联系人【{2}】。", BitAuto.YanFa.Crm2009.BLL.AllCusts.Instance.GetCustName(contact.CustID), contact.CustID, contact.CName);
BitAuto.YanFa.SysRightManager.Common.LogInfo.Instance.InsertLog(BitAuto.YanFa.Crm2009.BLL.LogModule.ContactInfo, (int)BitAuto.YanFa.SysRightManager.Common.LogInfo.ActionType.Delete, content);
}
else
{
success = false;
message = "no";//失败
}
}
AJAXHelper.WrapJsonResponse(success, result, message);
}
//通过CustID获取获取直接上级
else if ((context.Request["action"] + "").Trim() == "DropDownListPID")
{
StringBuilder sb = new StringBuilder();
DataTable dt = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfoPID(RequestCustID);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
sb.Append("{'ID':'" + dr["ID"] + "','Name':'" + dr["CName"] + "'},");
}
message = sb.ToString().TrimEnd(",".ToCharArray());
}
else
{
message = sb.ToString();
}
context.Response.Write("[" + message + "]");
context.Response.End();
}
//通过CustID获取获取直接上级
else if ((context.Request["action"] + "").Trim() == "BindContactDepartment")
{
string strWhere = "";
string filedOrder = "";
StringBuilder sb = new StringBuilder();
if ((context.Request["type"] + "").Trim() == "friend")
{
FriendInfo model = BitAuto.YanFa.Crm2009.BLL.FriendInfo.Instance.GetFriendInfo(context.Request["CustID"]);
if (context.Request["CustID"] != "0")
{
if (model != null)
{
strWhere = "TypeID='" + model.FriendCategoryID + "'";
filedOrder = " sort asc";
if (model.FriendCategoryID.Trim() == "")
{
sb.Append("{'ID':'1','Name':'error'},");
}
}
else
{
strWhere = "lb='0'";
}
}
else
{
strWhere = "lb='0'";
}
}
else if ((context.Request["type"] + "").Trim() == "customer")
{
BitAuto.YanFa.Crm2009.Entities.CustInfo model = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(context.Request["CustID"]);
if (context.Request["CustID"] != "0")
{
if (model != null)
{
strWhere = "TypeID='" + model.TypeID + "'";
filedOrder = " sort asc";
if (model.TypeID.Trim() == "")
{
sb.Append("{'ID':'0','Name':'error'},");
}
}
else
{
strWhere = "lb='1'";
}
}
else
{
strWhere = "lb='1'";
}
}
DataSet dt = BitAuto.YanFa.Crm2009.BLL.ContactUserDepartment.Instance.GetList(-1, strWhere, filedOrder);
if (dt != null)
{
foreach (DataRow dr in dt.Tables[0].Rows)
{
sb.Append("{'ID':'" + dr["DepartmentID"] + "','Name':'" + dr["DepartmentName"] + "'},");
}
message = sb.ToString().TrimEnd(",".ToCharArray());
}
else
{
message = sb.ToString();
}
context.Response.Write("[" + message + "]");
context.Response.End();
}
else if ((context.Request["showContactInfo"] + "").Trim() == "yes")
{
StringBuilder sb = new StringBuilder();
QueryContactInfo queryContactInfo = new QueryContactInfo();
queryContactInfo.CustID = RequestCustID;
int o;
DataTable dt = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfo(queryContactInfo, "", 1, 10000, out o);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
string tel = "";
if (dr["Phone"] != DBNull.Value)
{
tel += dr["Phone"].ToString().Trim() + ",";
}
if (dr["OfficeTel"] != DBNull.Value)
{
tel += dr["OfficeTel"].ToString().Trim() + ",";
}
sb.Append("{'ID':'" + dr["ID"] + "','Name':'" + dr["CName"] + "','Tel':'" + tel.Trim(',') + "'},");
}
message = sb.ToString().TrimEnd(",".ToCharArray());
}
else
{
message = sb.ToString();
}
context.Response.Write("[" + message + "]");
context.Response.End();
}
else if ((context.Request["showContactInfobycustid"] + "").Trim() == "yes")
{
StringBuilder sb = new StringBuilder();
DataTable dt = BitAuto.YanFa.Crm2009.BLL.ContactInfo.Instance.GetContactInfoByCustID(RequestCustID);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
string tel = "";
if (dr["Phone"] != DBNull.Value)
{
tel += dr["Phone"].ToString().Trim() + ",";
}
if (dr["OfficeTel"] != DBNull.Value)
{
tel += dr["OfficeTel"].ToString().Trim() + ",";
}
sb.Append("{'ID':'" + dr["ID"] + "','Name':'" + dr["CName"] + "','Tel':'" + tel.Trim(',') + "','DepartMent':'" + dr["DepartMent"] + "'},");
}
message = sb.ToString().TrimEnd(",".ToCharArray());
}
else
{
message = sb.ToString();
}
context.Response.Write("[" + message + "]");
context.Response.End();
}
else if (context.Request["action"].Trim() == "getmember")
{
message = GetMappingMember();
context.Response.Write(message);
context.Response.End();
}
else if (context.Request["action"].Trim() == "ishasmanager")
{
message = GetManageContactInfo();
context.Response.Write(message);
context.Response.End();
}
else
{
success = false;
message = "request error";
AJAXHelper.WrapJsonResponse(success, result, message);
}
}
private void BindCustomerInfo()
{
if (this.CustInfo != null)
{
this.CustID = this.CustInfo.CustID;
spanCustName.InnerText = this.CustInfo.CustName;
spanAbbrName.InnerText = this.CustInfo.AbbrName;
spanAddress.InnerText = this.CustInfo.Address;
if (!string.IsNullOrEmpty(CustInfo.CreateTime))
{
spanCreateTime.InnerText = CustInfo.CreateTime;
}
spanCreateUserName.InnerText = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(CustInfo.CreateUserID);
if (!string.IsNullOrEmpty(CustInfo.LastUpdateTime))
{
spanModifyTime.InnerText = CustInfo.LastUpdateTime;
}
spanModifyUserName.InnerText = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(CustInfo.LastUpdateUserID);
BitAuto.YanFa.Crm2009.Entities.QueryBrandInfo queryBrandInfo = new BitAuto.YanFa.Crm2009.Entities.QueryBrandInfo();
queryBrandInfo.CustID = this.CustInfo.CustID;
int o;
string s = "";
DataTable dt = BitAuto.YanFa.Crm2009.BLL.CarBrand.Instance.GetCustBrandInfo(queryBrandInfo, "", 1, 10000, out o);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
s += dt.Rows[i]["name"] + " ";
}
}
spanBrand.InnerText = s;
spanCarType.InnerText = BLL.Util.GetCustCatTypeName(this.CustInfo.CarType);
spanContractName.InnerText = this.CustInfo.contactName;
spanFax.InnerText = this.CustInfo.Fax;
if (!string.IsNullOrEmpty(this.CustInfo.IndustryID))
{
spanIndustry.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(Convert.ToInt32(this.CustInfo.IndustryID));
}
if (!string.IsNullOrEmpty(this.CustInfo.LevelID))
{
spanLevel.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(Convert.ToInt32(this.CustInfo.LevelID));
}
// 集团 厂商 没有 [所属集团 所属厂商]; 没有新增会员按钮
if (this.CustInfo.TypeID == ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.Company).ToString() || this.CustInfo.TypeID == ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.Bloc).ToString())
{
liPid.Visible = false;
liCustPid.Visible = false;
}
else
{
if (this.CustInfo.TypeID == ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.SynthesizedShop).ToString())
{
liCustPid.Visible = false;
//综合店 没有厂商
}
if (CustInfo.TypeID == ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.Licence).ToString())
{
liFourS.Visible = true;
if (!string.IsNullOrEmpty(CustInfo.FoursPid))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo pmodel = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(CustInfo.FoursPid);
if (pmodel != null)
{
spanFourPidName.InnerText = pmodel.CustName;
}
}
}
}
spanLicenseNumber.InnerText = this.CustInfo.LicenseNumber;
//spanAS.InnerText = this.CustInfo.BLAnnualSurvey == 0 ? "未知" : (this.CustInfo.BLAnnualSurvey == 1 ? "通过" : "未通过");
this.BLAnnualSurvey = this.CustInfo.BLAnnualSurvey.ToString();
//信用等级
this.StarLevel = this.CustInfo.StarLevel;
spanNotes.InnerText = this.CustInfo.Notes;
spanOfficeTel.InnerText = this.CustInfo.Officetel;
if (!string.IsNullOrEmpty(this.CustInfo.Pid))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo pmodel = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(this.CustInfo.Pid);
if (pmodel != null)
{
spanPid.InnerText = pmodel.CustName;
}
}
if (!string.IsNullOrEmpty(this.CustInfo.CustPid))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo pmodel = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(this.CustInfo.CustPid);
if (pmodel != null)
{
spanCustPid.InnerText = pmodel.CustName;
}
}
//if (!string.IsNullOrEmpty(model.ProducerID) && model.ProducerID != "-1")
//{
// Entities.ProducerInfo producerInfo = BLL.ProducerInfo.Instance.GetProducerInfo(model.ProducerID);
// if (model != null)
// {
// spanProducer.InnerText = producerInfo.ChinaName;
// }
//}
string provinceCity = "";
if (!string.IsNullOrEmpty(this.CustInfo.ProvinceID))
{
provinceCity += BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(this.CustInfo.ProvinceID);
}
if (!string.IsNullOrEmpty(this.CustInfo.CityID))
{
provinceCity += " " + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(this.CustInfo.CityID);
}
if (!string.IsNullOrEmpty(this.CustInfo.CountyID))
{
provinceCity += " " + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(this.CustInfo.CountyID);
}
spanProvinceCity.InnerText = provinceCity;
//if (!string.IsNullOrEmpty(model.SaleOrgID) && model.SaleOrgID != "-1")
//{
// Entities.SalesNetwork salesNetwork = BLL.SalesNetwork.Instance.GetSalesNetwork(model.SaleOrgID);
// if (model != null)
// {
// spanSaleNetwork.InnerText = salesNetwork.SnName;
// }
//}
if (!string.IsNullOrEmpty(this.CustInfo.ShopLevel))
{
spanShopLevel.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(Convert.ToInt32(this.CustInfo.ShopLevel));
}
if (!string.IsNullOrEmpty(this.CustInfo.TypeID))
{
spanType.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(Convert.ToInt32(this.CustInfo.TypeID));
}
spanZipCode.InnerText = this.CustInfo.zipcode;
if (this.CustInfo.Lock == 1)
{
//spanLock.InnerText = "是";
spanLock.Style["display"] = "block";
}
else
{
//spanLock.InnerText = "否";
spanLock.Style["display"] = "none";
}
if (this.CustInfo.Status == 0)
{
//spanStatus.InnerText = "在用";
spanStatus.Style["display"] = "none";
}
else
{
//spanStatus.InnerText = "停用";
spanStatus.Style["display"] = "block";
}
//二手车经营类型 置换型：1；零售型：2
if (custInfo.UsedCarBusinessType == "1")
{
spanUsedCarBusiness.InnerText = "置换型";
}
else if (custInfo.UsedCarBusinessType == "2")
{
spanUsedCarBusiness.InnerText = "零售型";
}
//所属交易市场
if (!string.IsNullOrEmpty(custInfo.TradeMarketID))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo custinfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(custInfo.TradeMarketID.ToString());
if (custinfo != null)
{
spanTradeMarketID.InnerText = custinfo.CustName;
}
}
#region Modify=masj，Date=2012-04-13 注释掉
////车商通会员ID
//Crm2009.Entities.QueryCstMember queryCstMember = new Crm2009.Entities.QueryCstMember();
//queryCstMember.CustID = custInfo.CustID;
//queryCstMember.Status = 0;
//DataTable dtCstMember = Crm2009.BLL.CstMember.Instance.GetTable(queryCstMember);
//string[] strCstMemberID = new string[dtCstMember.Rows.Count];
////ArrayList arr_cstMember = new ArrayList();
//for (int k = 0; k < dtCstMember.Rows.Count; k++)
//{
// strCstMemberID[k]=dtCstMember.Rows[k]["CstMemberID"].ToString();
//}
//if (strCstMemberID != null)
//{
// spanCstMemberID.InnerHtml = "";
// for (int k = 0; k < strCstMemberID.Length; k++)
// {
// spanCstMemberID.InnerHtml += "<a href='/CustCheck/CSTMember/CSTMemberInfo.aspx?CSTMemberID=" + strCstMemberID[k] + "' target='_blank'>" + strCstMemberID[k] + "</a>";
// if (k != strCstMemberID.Length - 1)
// {
// spanCstMemberID.InnerHtml += ",";
// }
// }
//}
#endregion
}
}
private bool CheckDataImported(string fileName, string filePath, out string msg)
{
bool checkData = true;//验证数据正确性
msg = "导入出错，请重新导入！";
//(1)连接EXCEL文件
string ext = Path.GetExtension(fileName);
string connStr = string.Empty;
if (ext.ToLower() == ".xls")
{
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @fileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
}
else
{
throw new Exception("上传文件应为xls格式的文件");
}
//(2)读取校验数据
Dictionary <string, ReturnVisitData> dictCust = new Dictionary <string, ReturnVisitData>(); //key 为客户ID， value为（客服ID，客户ID，工号）
bool isExistYYKF = false; //数据中存在运营客服 默认没有
bool isExistsCustMember = false; //客户存在新车负责客服 默认没有
DataSet ds = new DataSet();
try
{
using (OleDbConnection conn = new OleDbConnection(connStr))
{
conn.Open();
//返回Excel的架构，包括各个sheet表的名称,类型，创建时间和修改时间等
DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
//包含excel中表名的字符串数组
string firstSheetName = dtSheetName.Rows[0]["TABLE_NAME"].ToString();
//读取第一个sheet填充数据sheetConfig.Name.Replace(".", "#") + "$"
OleDbCommand command = new OleDbCommand("select * from [" + firstSheetName.Replace(".", "#") + "]", conn);
OleDbDataAdapter odda = new OleDbDataAdapter(command);
odda.Fill(ds);
}
if (ds.Tables[0].Rows.Count > 1000 || ds.Tables[0].Rows.Count == 0)
{
msg = "数据行数必须大于0小于1000！";
return(false);
}
int rowNum = 1;
int startReadRow = 0;
foreach (DataRow idr in ds.Tables[0].Rows)
{
if (idr[0].ToString().Trim().Contains("客户ID"))
{
startReadRow = rowNum;
}
if (rowNum > startReadRow)
{
++rowNum;
string agentNum = idr[1].ToString(); //工号
string custid = idr[0].ToString(); //客户id
custid = Regex.Replace(custid, @"\D*", "");
if (string.IsNullOrEmpty(custid) || string.IsNullOrEmpty(agentNum))
{
msg = "导入失败，第" + rowNum + "行客户ID或工号不可为空!";
checkData = false;
break;
}
BitAuto.YanFa.Crm2009.Entities.CustInfo custModel = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(custid);
if (custModel == null)
{
msg = "导入失败，第" + rowNum + "行数据的客户ID不存在！";
checkData = false;
break;
}
if (!dictCust.ContainsKey(custid))
{
DataTable dt = BLL.EmployeeAgent.Instance.GetEmployeeAgentsByAgentNum(agentNum);//根据工号获得userid
if (dt.Rows.Count == 0)
{
msg = "导入失败，第" + rowNum + "行数据的客服工号不存在！";
checkData = false;
break;
}
else
{
dictCust.Add(custid, new ReturnVisitData()
{
crmCustID = custid, AgentNum = agentNum, UserID = BitAuto.ISDC.CC2012.Entities.CommonFunction.ObjectToInteger(dt.Rows[0][0])
});
}
}
else
{
msg = "导入失败，第" + rowNum + "数据中存在相同客户ID!";
checkData = false;
break;
}
}
}
if (checkData)
{
int row = 0;
foreach (KeyValuePair <string, ReturnVisitData> item in dictCust)
{
row++;
bool isYYKF = BLL.ProjectTask_ReturnVisit.Instance.IsYYKF(item.Value.UserID);//是运行客服
if (isYYKF)
{
isExistYYKF = true;
// bool existFlag = BLL.EmployeeAgent.Instance.GetEmployeeAgentsByAgentNumBussniess(item.Key);
bool ExistsCustMember = BLL.ProjectTask_ReturnVisit.Instance.IsExistsCustMember(item.Value.UserID, "'" + item.Key + "'");
if (ExistsCustMember)//客户已存在新车负责客服
{
isExistsCustMember = true;
msg = "custidexists";
checkData = false;
break;
}
}
}
if (!isExistYYKF)//不存在运营客服 直接导入 FF浏览器CC使用直接导入有问题
{
msg = "onlyupload";
checkData = false;
// DealDataImported(fileName, false);
}
else if (isExistYYKF && !isExistsCustMember)//存在运营客服,切不存在新车负责客服 即修改
{
msg = "editupload";
checkData = false;
//DealDataImported(fileName, true);
}
}
else//文件校验失败 直接删除
{
Directory.Delete(filePath, true);
return(false);
}
}
catch (Exception ex)
{
msg = "分配失败！";
Directory.Delete(filePath, true);
checkData = false;
}
return(checkData);
}
