private void BindData()
{
if (string.IsNullOrEmpty(ch.TID))
{
return;
}
else
{
task = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(ch.TID);
if (task == null)
{
return;
}
this.TID = task.PTID.ToString();
}
int totalCount = 0;
Entities.QueryProjectTask_Cust_Contact query = new Entities.QueryProjectTask_Cust_Contact();
query.PTID = task.PTID;
DataTable table = BLL.ProjectTask_Cust_Contact.Instance.GetContactInfo(query, "", ch.CurrentPage, ch.PageSize, out totalCount);
//设置数据源
if (table != null && table.Rows.Count > 0)
{
repeater_Contact.DataSource = table;
}
//绑定列表数据
repeater_Contact.DataBind();
//分页控件
this.AjaxPager_Contact.InitPager(totalCount);
}
protected bool CustVerify(string tid)
{
bool result = true;
Entities.ProjectTaskInfo taskInfo = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(tid);
if (taskInfo != null)
{
if (taskInfo.Source == 1)
{
Response.Write("<script type='text/javascript'>$.jAlert('此客户属于新增客户，请进入新增客户核实页进行核实操作！');window.location.href='/CustCheck/CrmCustCheck/Main.aspx';</script>");
result = false;
}
else if (taskInfo.Source == 2)
{
BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(taskInfo.CrmCustID);
if (custInfo != null)
{
if (custInfo.CarType == 2)
{
Response.Write("<script type='text/javascript'>$.jAlert('此客户是二手车客户，请进入相应的核实页进行操作！');window.location.href='/CustCheck/CrmCustCheck/Main.aspx';</script>");
result = false;
}
}
}
}
else
{
Response.Write("<script type='text/javascript'>$.jAlert('不存在此任务ID');window.location.href='/CustCheck/CrmCustCheck/Main.aspx';</script>");
result = false;
}
return(result);
}
/// <summary>
/// 若任务状态为已处理（提交处理成功、提交处理失败、删除成功、删除失败），则不能操作了
/// </summary>
public void ValidateOperation()
{
if (string.IsNullOrEmpty(CustInfo.TID))
{
throw new Exception("TID不可为空");
}
Entities.ProjectTaskInfo model = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(CustInfo.TID);
if (model != null)
{
if (model.TaskStatus == (int)Entities.EnumProjectTaskStatus.SubmitFinsih ||
model.TaskStatus == (int)Entities.EnumProjectTaskStatus.DelFinsh ||
//model.TaskStatus == (int)Entities.EnumProjectTaskStatus.SubmitManageSuccess ||
//model.TaskStatus == (int)Entities.EnumProjectTaskStatus.SubmitManageFail ||
//model.TaskStatus == (int)Entities.EnumProjectTaskStatus.DelFail ||
//model.TaskStatus == (int)Entities.EnumProjectTaskStatus.DelSuccess||
model.TaskStatus == (int)Entities.EnumProjectTaskStatus.Finshed ||
//model.TaskStatus == (int)Entities.EnumProjectTaskStatus.StayAudit||
model.TaskStatus == (int)Entities.EnumProjectTaskStatus.StayReview)
{
throw new Exception("任务状态已处理，不能再操作了");
}
}
else
{
throw new Exception("无此任务");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
CustCheckHelper h = new CustCheckHelper();
//int taskId = -1;
if (!string.IsNullOrEmpty(h.TID))
{
TID = h.TID;
Entities.ProjectTaskInfo task = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(h.TID);
this.UCCust1.Task = task;
}
else
{
throw new Exception("无法找到此任务");
}
}
}
catch (Exception ex)
{
//日志
}
}
/// <summary>
/// 将CRM中信息同步到ProjectTask_Cust
/// </summary>
public void SyncInfoFromCrm(Entities.ProjectTaskInfo task)
{
if (task.Source == 2 && BLL.ProjectTask_Cust.Instance.Exists(task.PTID) == false)
{
Dal.ProjectTask_Cust.Instance.SyncInfoFromCrm(task, Util.GetLoginUserID(), DateTime.Now);
}
}
internal void AddContact()
{
Entities.ProjectTaskInfo task = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(this.TID);
if (task == null)
{
throw new Exception("无法得到相应任务");
}
//int i = -1;
Entities.ProjectTask_Cust_Contact c = new Entities.ProjectTask_Cust_Contact();
c.PTID = task.PTID;
//c.OriginalContactID =
int _PID = -2;
if (int.TryParse(this.ContactPID, out _PID))
{
}
c.PID = _PID;
c.CName = this.CName;
c.EName = this.EName;
c.Sex = this.Sex;
if (this.CustType != "20010")
{
c.DepartMent = this.DepartMent;
}
c.OfficeTypeCode = int.Parse(this.OfficeTypeCode.Trim());
c.Title = this.Title;
c.OfficeTel = this.OfficeTel;
c.Phone = this.Phone;
c.Email = this.Email;
c.Fax = this.Fax;
c.Remarks = this.Reamrk;
c.Address = this.Address;
c.ZipCode = this.ZipCode;
c.MSN = this.MSN;
c.Birthday = this.Birthday;
c.CreateTime = DateTime.Now;
c.ModifyTime = DateTime.Now;
c.CreateUserID = BLL.Util.GetLoginUserID();
c.Status = 0;
c.Hobby = this.Hobby;
c.Responsible = this.Responsible;
try
{
int contactID = BLL.ProjectTask_Cust_Contact.Instance.InsertContact(c);
if (contactID > 0)
{
//负责会员处理(按顺序执行)
YesSelectMemberHandle(contactID);
NotSelectMemberHandle(contactID);
YesSelectMainHandle(contactID);
NotSelectMainHandle(contactID);
}
}
catch (Exception ex)
{
}
}
/// <summary>
/// 删除核实的客户信息
/// </summary>
internal void DeleteCheckInfo()
{
Entities.ProjectTaskInfo task = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(this.TID);
if (task == null)
{
throw new Exception("无此任务");
}
ValidateOperation(this.TID);
BLL.ProjectTaskInfo.Instance.UpdateTaskStatus(task.PTID, Entities.EnumProjectTaskStatus.DelFinsh, Entities.EnumProjectTaskOperationStatus.TaskDel, this.DescriptionWhenDelete, DateTime.Now);
}
/// <summary>
/// 客户是否停用
/// </summary>
/// <returns></returns>
internal void CustIsLock()
{
Entities.ProjectTaskInfo task = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(TID);
BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(task.CrmCustID);
if (custInfo != null)
{
if (custInfo.Lock == 1)
{
throw new Exception("此会员已锁定，无法进行停用操作！");
}
}
}
private void BindData()
{
DataTable dtMember = new DataTable();
Entities.ProjectTaskInfo model = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(RequestTID);
if (model != null)
{
DataSource = model.Source.ToString();
if (model.Source == 1)//Excel导入客户
{
Entities.ProjectTaskInfo cccustModel = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(RequestTID);
if (cccustModel != null)
{
txtCustName.Value = cccustModel.CustName;
List <Entities.ProjectTask_DMSMember> ccmemberList = new List <Entities.ProjectTask_DMSMember>();
ccmemberList = BitAuto.ISDC.CC2012.BLL.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMemberByTID(RequestTID);
//*add by qizhiqiang 取新建车商通会员信息 2012-4-20
List <Entities.ProjectTask_CSTMember> cc_cstmemberList = new List <Entities.ProjectTask_CSTMember>();
cc_cstmemberList = BitAuto.ISDC.CC2012.BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberByTID(RequestTID);
//*
//*updateby qizhiqiang 2012-4-20
BindMemberDDL(ccmemberList, cc_cstmemberList);
//*
hidCustID.Value = model.RelationID;
}
}
else if (model.Source == 2)//CRM库客户
{
BitAuto.YanFa.Crm2009.Entities.CustInfo custModel = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(model.RelationID);
if (custModel != null)
{
txtCustName.Value = custModel.CustName;
spanCustID.InnerHtml = custModel.CustID;
hidCustID.Value = custModel.CustID;
List <Entities.ProjectTask_DMSMember> ccmemberList = new List <Entities.ProjectTask_DMSMember>();
ccmemberList = BitAuto.ISDC.CC2012.BLL.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMemberByTID(RequestTID);
//*add byqizhiqiang 2012-4-20
List <Entities.ProjectTask_CSTMember> cc_cstmemberList = new List <Entities.ProjectTask_CSTMember>();
cc_cstmemberList = BitAuto.ISDC.CC2012.BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberByTID(RequestTID);
//*
//*updateby qizhiqiang 2012-4-20
BindMemberDDL(ccmemberList, cc_cstmemberList);
//*
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
CustCheckHelper h = new CustCheckHelper();
//int taskId = -1;
if (!string.IsNullOrEmpty(h.TID))
{
TID = h.TID;
Entities.ProjectTaskInfo task = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(h.TID);
this.UCCust1.Task = task;
if (task != null)
{
switch (task.TaskStatus)
{
//case (int)Entities.EnumProjectTaskStatus.SubmitManageSuccess:
//case (int)Entities.EnumProjectTaskStatus.SubmitManageFail:
//case (int)Entities.EnumProjectTaskStatus.DelSuccess:
//case (int)Entities.EnumProjectTaskStatus.DelFail:
case (int)Entities.EnumProjectTaskStatus.StayReview:
case (int)Entities.EnumProjectTaskStatus.Finshed:
this.btnConfirm.Visible = this.btnRefuse.Visible = this.btnCallBack.Visible = false;
break;
case (int)Entities.EnumProjectTaskStatus.SubmitFinsih:
case (int)Entities.EnumProjectTaskStatus.DelFinsh:
this.btnConfirm.Visible = this.btnRefuse.Visible = this.btnCallBack.Visible = true;
break;
default:
break;
}
//if (task.TaskStatus == (int)Entities.EnumProjectTaskStatus.SubmitManageFail)
//{
// this.btnReject.Visible = true;
//}
}
}
else
{
throw new Exception("无法找到此任务");
}
}
}
catch (Exception ex)
{
//日志
}
}
public void SyncInfoFromCrm(Entities.ProjectTaskInfo task, int createUserID, DateTime createTime)
{
SqlParameter[] parameters =
{
new SqlParameter("@PTID", SqlDbType.VarChar),
new SqlParameter("@CrmCustID", SqlDbType.VarChar, 50),
new SqlParameter("@CreateUserID", SqlDbType.Int),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = task.PTID;
parameters[1].Value = task.RelationID;
parameters[2].Value = createUserID;
parameters[3].Value = createTime;
SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_CUST_SYNCINFOFROMCRM, parameters);
}
private void BindData()
{
//int taskId = -1;
//if (int.TryParse(ch.TID, out taskId) == false) { return; }
//else
//{
// task = BLL.CC_Tasks.Instance.GetCC_Tasks(taskId);
// if (task == null) { return; }
// this.TID = task.TID.ToString();
//}
if (!string.IsNullOrEmpty(ch.TID))
{
task = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(ch.TID);
if (task == null)
{
return;
}
this.TID = task.PTID.ToString();
}
else
{
return;
}
int totalCount = 0;
Entities.QueryProjectTask_Cust_Contact query = new Entities.QueryProjectTask_Cust_Contact();
query.PTID = task.PTID;
DataTable table = BLL.ProjectTask_Cust_Contact.Instance.GetContactInfo(query, "contact.ModifyTime DESC", ch.CurrentPage, PageSize, out totalCount);
//设置数据源
if (table != null && table.Rows.Count > 0)
{
repeater_Contact.DataSource = table;
}
//绑定列表数据
repeater_Contact.DataBind();
//分页控件
this.AjaxPager_Contact.InitPager(totalCount);
}
private void BindData()
{
task = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(ch.TID);
if (task == null)
{
return;
}
this.TID = task.PTID.ToString();
DataTable table = BLL.ProjectTaskLog.Instance.GetProjectTaskLog(task.PTID);
//设置数据源
if (table != null && table.Rows.Count > 0)
{
repeater_Contact.DataSource = table;
}
//绑定列表数据
repeater_Contact.DataBind();
////分页控件
//this.AjaxPager_Contact.InitPager(totalCount);
}
private void BindCustInfo()
{
Entities.ProjectTask_Cust query = new Entities.ProjectTask_Cust();
if (TID != string.Empty)
{
Task = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(TID);
Entities.ProjectTask_Cust ccCust = BLL.ProjectTask_Cust.Instance.GetCustInfoModelByPTID(TID);
if (ccCust != null)
{
CarType = ccCust.CarType;
spanCustName.InnerText = ccCust.CustName;
spanCustAbbr.InnerText = ccCust.AbbrName;
spanAddress.InnerText = ccCust.Address;
hdnCustType.Value = ccCust.TypeID;
spanBrandName.InnerText = BitAuto.ISDC.CC2012.Web.WebUtil.Converter.List2String(ccCust.BrandNames, ",", "", "");
spanContactName.InnerText = ccCust.ContactName;
spanFax.InnerText = ccCust.Fax;
if (!string.IsNullOrEmpty(ccCust.IndustryID))
{
spanCustIndustry.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(Convert.ToInt32(ccCust.IndustryID));
}
if (!string.IsNullOrEmpty(ccCust.LevelID))
{
spanCustLevel.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(Convert.ToInt32(ccCust.LevelID));
}
// 集团 厂商 没有 [所属集团 所属厂商]; 没有新增会员按钮
if (ccCust.TypeID == ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.Company).ToString() || ccCust.TypeID == ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.Bloc).ToString())
{
liPid.Visible = false;
liCustPid.Visible = false;
}
else
{
if (ccCust.TypeID == ((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.SynthesizedShop).ToString())
{
liCustPid.Visible = false;
//综合店 没有厂商
}
}
spanNotes.InnerText = ccCust.Notes;
spanOfficeTel.InnerText = ccCust.OfficeTel;
if (!string.IsNullOrEmpty(ccCust.Pid))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo pmodel = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.Pid);
if (pmodel != null)
{
spanPidName.InnerText = pmodel.CustName;
}
}
if (!string.IsNullOrEmpty(ccCust.CustPid))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo pmodel = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.CustPid);
if (pmodel != null)
{
spanCustPidName.InnerText = pmodel.CustName;
}
}
string provinceCity = "";
if (!string.IsNullOrEmpty(ccCust.ProvinceID))
{
provinceCity += BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(ccCust.ProvinceID);
}
if (!string.IsNullOrEmpty(ccCust.CityID))
{
provinceCity += " " + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(ccCust.CityID);
}
if (!string.IsNullOrEmpty(ccCust.CountyID))
{
provinceCity += " " + BitAuto.YanFa.Crm2009.BLL.MainBrand.Instance.GetAreaName(ccCust.CountyID);
}
spanArea.InnerText = provinceCity;
if (!string.IsNullOrEmpty(ccCust.ShopLevel))
{
spanShopLevel.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(Convert.ToInt32(ccCust.ShopLevel));
}
if (!string.IsNullOrEmpty(ccCust.TypeID))
{
spanCustType.InnerText = BitAuto.YanFa.Crm2009.BLL.Util.GetEnumOptText(Convert.ToInt32(ccCust.TypeID));
custid.InnerText = ccCust.TypeID;
}
spanZipcode.InnerText = ccCust.Zipcode;
if (!string.IsNullOrEmpty(ccCust.OriginalCustID))
{
if (ccCust.Status != null)
{
switch (ccCust.Status.Value)
{
case 0:
imgCustStatus.Src = "/Images/xt.gif";
imgCustStatus.Attributes.Add("title", "在用");
imgStatusLock = 1;
break;
case 1:
imgCustStatus.Src = "/Images/xt_1.gif";
imgCustStatus.Attributes.Add("title", "停用");
imgStatusLock = 1;
break;
default:
break;
}
}
if (ccCust.Lock != null && ccCust.Lock.Value == 1)
{
imgCustStatusLock.Src = "/Images/lock.gif";
imgCustStatusLock.Attributes.Add("title", "锁定");
imgLock = 1;
}
else if (ccCust.Lock != null && ccCust.Lock.Value == 0)
{
imgCustStatusLock.Src = "/Images/unlock.gif";
imgCustStatusLock.Attributes.Add("title", "未锁定");
imgLock = 1;
}
liCustStatus.Style.Remove("display");
liCustLock.Style.Remove("display");
}
}
}
else
{
throw new Exception("无法找到此任务");
}
}
/// <summary>
/// 从CC_Custs中读取客户信息与会员信息。
/// </summary>
private void LoadInfoFromCC_Cust(Entities.ProjectTaskInfo task)
{
#region 加载客户信息
Entities.ProjectTask_Cust ccCust = BLL.ProjectTask_Cust.Instance.GetProjectTask_Cust(task.PTID);
CarType = ccCust.CarType.ToString();
this.OriginalCustID = ccCust.OriginalCustID;
this.tfCustName.Value = ccCust.CustName;
this.tfCustAbbr.Value = ccCust.AbbrName;
ListItem li = this.selCustType.Items.FindByValue(ccCust.TypeID);
this.selCustType.SelectedIndex = this.selCustType.Items.IndexOf(li);
//如果客户类型为特许经销商，显示所属4S
if (ccCust.TypeID == Convert.ToString((int)BitAuto.YanFa.Crm2009.Entities.EnumCustomType.Licence))
{
//lbl4S.Style["display"] = "blank";
}
if (task.Source == 2) //CRM库来源
{
selCustType.Attributes.Add("disabled", "disabled"); //不能编辑客户类别
}
li = this.selCustIndustry.Items.FindByValue(ccCust.IndustryID);
this.selCustIndustry.SelectedIndex = this.selCustIndustry.Items.IndexOf(li);
this.InitialProvinceID = ccCust.ProvinceID;
this.InitialCityID = ccCust.CityID;
this.InitialCountyID = ccCust.CountyID;
this.tfAddress.Value = ccCust.Address;
this.tfZipcode.Value = ccCust.Zipcode;
if (!string.IsNullOrEmpty(ccCust.TradeMarketID))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.TradeMarketID.ToString());
if (custInfo != null)
{
tfCustPidName1.Value = custInfo.CustName;
tfCustPid1.Value = ccCust.TradeMarketID.ToString();
}
}
#region Modify=masj，Date=2012-04-13 注释掉
//if (ccCust.CstMemberID != "" && ccCust.CstMemberID != null)
//{
// this.txtCtsMemberID.Value = ccCust.CstMemberID;
//}
#endregion
if (ccCust.CarType == 3)
{
this.chkOldCarType.Checked = true;
if (!string.IsNullOrEmpty(ccCust.UsedCarBusinessType))
{
this.sltUsedCarBusinessType.Value = ccCust.UsedCarBusinessType.ToString();
}
if (!string.IsNullOrEmpty(ccCust.TradeMarketID))
{
BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.TradeMarketID.ToString());
if (custInfo != null)
{
tfCustPidName1.Value = custInfo.CustName;
tfCustPid1.Value = ccCust.TradeMarketID.ToString();
}
}
}
if (!string.IsNullOrEmpty(ccCust.OriginalCustID))
{
if (ccCust.Status != null)
{
switch (ccCust.Status.Value)
{
case 0:
imgCustStatus.Src = "/Images/xt.gif";
imgCustStatus.Attributes.Add("title", "在用");
break;
case 1:
imgCustStatus.Src = "/Images/xt_1.gif";
imgCustStatus.Attributes.Add("title", "停用");
break;
default:
break;
}
}
if (ccCust.Lock != null && ccCust.Lock.Value == 1)
{
imgCustStatusLock.Src = "/Images/lock.gif";
imgCustStatusLock.Attributes.Add("title", "锁定");
}
else if (ccCust.Lock != null && ccCust.Lock.Value == 0)
{
imgCustStatusLock.Src = "/Images/unlock.gif";
imgCustStatusLock.Attributes.Add("title", "未锁定");
}
liCustStatus.Style.Remove("display");
liCustLock.Style.Remove("display");
}
li = this.selCustLevel.Items.FindByValue(ccCust.LevelID);
this.selCustLevel.SelectedIndex = this.selCustLevel.Items.IndexOf(li);
BitAuto.YanFa.Crm2009.Entities.CustInfo crmCust = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.CustPid);
if (crmCust != null)
{
this.tfCustPid.Value = crmCust.CustID; this.tfCustPidName.Value = crmCust.CustName;
}
crmCust = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.Pid);
if (crmCust != null)
{
this.tfPid.Value = crmCust.CustID; this.tfPidName.Value = crmCust.CustName;
}
crmCust = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.FoursPid);
if (crmCust != null)
{
this.tf4sPid.Value = crmCust.CustID; this.tf4sName.Value = crmCust.CustName;
}
li = this.selShopLevel.Items.FindByValue(ccCust.ShopLevel);
this.selShopLevel.SelectedIndex = this.selShopLevel.Items.IndexOf(li);
this.tfBrand.Value = BLL.Util.List2String(ccCust.BrandIDs, ",", "", "");
this.tfBrandName.Value = BLL.Util.List2String(ccCust.BrandNames, ",", "", "");
this.tfOfficeTel.Value = ccCust.OfficeTel;
this.tfFax.Value = ccCust.Fax;
this.tfContactName.Value = ccCust.ContactName;
this.tfNotes.Value = ccCust.Notes;
#endregion
#region 加载会员信息(如果没有会员，并且从excel中加载，加载一个空会员控件)
List <Entities.ProjectTask_DMSMember> ccMembers = BLL.ProjectTask_DMSMember.Instance.GetProjectTask_DMSMemberByTID(task.PTID);
if (ccMembers.Count > 0)
{
Control ctl;
foreach (Entities.ProjectTask_DMSMember m in ccMembers)
{
//在CRM中有会员
if (string.IsNullOrEmpty(m.OriginalDMSMemberID) == false)
{
HasMembersInCrm = true;
}
ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditMember.ascx", m);
this.PlaceHolder.Controls.Add(ctl);
}
}
else
{
if (task.Source == 1)
{
Control ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditMember.ascx", task.PTID);
this.PlaceHolder.Controls.Add(ctl);
}
}
#endregion
#region 加载车商通会员信息
//如果是新车二手车或二手车
if (ccCust.CarType == 2 || ccCust.CarType == 3)
{
Entities.ProjectTask_CSTMember queryCstMember = new Entities.ProjectTask_CSTMember();
List <Entities.ProjectTask_CSTMember> ccCstMembers = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberByTID(task.PTID);
if (ccCstMembers.Count > 0)
{
Control ctl;
foreach (Entities.ProjectTask_CSTMember m in ccCstMembers)
{
////在CRM中有会员
//if (string.IsNullOrEmpty(m.OriginalDMSMemberID) == false) { HasMembersInCrm = true; }
ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditCstMember.ascx", m);
this.PlaceHolderCstMember.Controls.Add(ctl);
}
}
}
//如果是新车客户，显示车商通的会员
if (ccCust.CarType == 1)
{
List <Entities.ProjectTask_CSTMember> ccMemberList = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberByTID(this.Task.PTID);
Control ctl;
foreach (Entities.ProjectTask_CSTMember m in ccMemberList)
{
ctl = this.LoadControl("~/CustInfo/DetailV/UCCstMemberFromCC.ascx", m);
this.PlaceHolderShowCstMember.Controls.Add(ctl);
}
}
#endregion
}
private void GenByDataTable(Entities.ProjectInfo ProjectModel, int userId, DataTable dt, out string msg)
{
msg = "";
#region 根据数据关联生成任务
List <Entities.ProjectTaskInfo> list = new List <Entities.ProjectTaskInfo>();
Entities.ProjectTaskInfo ptaskModel = null;
List <Entities.CustLastOperTask> list_OperTask = new List <Entities.CustLastOperTask>();
List <Entities.CustLastOperTask> list_OldOperTask = new List <Entities.CustLastOperTask>();
int maxcount = BLL.ProjectTaskInfo.Instance.GetMax();//从ProjectTaskInfo表中查找最大值
string PixStr = "";
if (ProjectModel.Source == 1)
{
PixStr = "IMP";
}
else if (ProjectModel.Source == 2)
{
PixStr = "CRM";
}
DateTime dtime = DateTime.Now;
foreach (DataRow dr in dt.Rows)
{
ptaskModel = new Entities.ProjectTaskInfo();
ptaskModel.PTID = PixStr + (++maxcount).ToString().PadLeft(7, '0');
ptaskModel.PDSID = long.Parse(dr["PDSID"].ToString());
ptaskModel.ProjectID = int.Parse(ProjectID);
ptaskModel.CustName = dr["CustName"].ToString(); //客户名称
ptaskModel.Source = int.Parse(dr["Source"].ToString());
ptaskModel.RelationID = dr["RelationID"].ToString();
ptaskModel.CrmCustID = dr["CustID"].ToString();//CRM客户ID
ptaskModel.CreateTime = dtime;
ptaskModel.CreateUserID = userId;
ptaskModel.LastOptTime = dtime;
ptaskModel.LastOptUserID = userId;
ptaskModel.TaskStatus = (int)(EnumProjectTaskStatus.NoSelEmployee);
ptaskModel.Status = 0;
ptaskModel.CustType = dr["CustType"].ToString();
list.Add(ptaskModel);
if (PixStr == "CRM")
{
Entities.CustLastOperTask operTaskModel = new BitAuto.ISDC.CC2012.Entities.CustLastOperTask();
if (ptaskModel.CrmCustID != "")
{
Entities.CustLastOperTask oldModel = BLL.CustLastOperTask.Instance.GetCustLastOperTask(ptaskModel.CrmCustID);
if (oldModel == null)
{
operTaskModel.CustID = ptaskModel.CrmCustID;
operTaskModel.TaskID = ptaskModel.PTID;
operTaskModel.TaskType = 1;
operTaskModel.LastOperUserID = operTaskModel.CreateUserID = BLL.Util.GetLoginUserID();
operTaskModel.LastOperTime = operTaskModel.CreateTime = dtime;
list_OperTask.Add(operTaskModel);
list_OldOperTask.Add(null);
}
else
{
operTaskModel.CustID = ptaskModel.CrmCustID;
operTaskModel.TaskID = ptaskModel.PTID;
operTaskModel.LastOperUserID = BLL.Util.GetLoginUserID();
operTaskModel.LastOperTime = dtime;
list_OperTask.Add(operTaskModel);
list_OldOperTask.Add(oldModel);
}
}
}
}
string connectionstrings = ConfigurationUtil.GetAppSettingValue("ConnectionStrings_CC");
SqlConnection connection = new SqlConnection(connectionstrings);
connection.Open();
SqlTransaction tran = connection.BeginTransaction("SampleTransaction");
try
{
//add by qizq 2013-3-11 4S和非4S电话营销
if (ProjectModel.Source != 3) //Modify By Chybin At 2014-3-31
{
#region 生成任务
foreach (Entities.ProjectTaskInfo item in list)
{
BLL.ProjectTaskInfo.Instance.Add(tran, item);
}
BLL.ProjectLog.Instance.InsertProjectLog(ProjectModel.ProjectID, ProjectLogOper.L6_生成任务, "生成任务" + list.Count + "条", tran);
#endregion
}
#region 修改项目状态
ProjectModel.Status = 1;
BLL.ProjectInfo.Instance.Update(tran, ProjectModel);
#endregion
#region 修改关联数据状态
BLL.ProjectDataSoure.Instance.UpdateStatusByProjectId(tran, "1", (int)ProjectModel.ProjectID);
#endregion
tran.Commit();
}
catch (Exception ex)
{
if (tran.Connection != null)
{
tran.Rollback();
}
msg = ex.Message.ToString();
}
finally
{
connection.Close();
}
#endregion
}
/// <summary>
/// 从CC_Custs中读取客户信息与会员信息。
/// </summary>
private void LoadInfoFromCC_Cust(Entities.ProjectTaskInfo task)
{
#region 加载客户信息
Entities.ProjectTask_Cust ccCust = BLL.ProjectTask_Cust.Instance.GetProjectTask_Cust(task.PTID);
this.OriginalCustID = ccCust.OriginalCustID;
this.tfCustName.Value = ccCust.CustName;
this.tfCustAbbr.Value = ccCust.AbbrName;
ListItem li = this.selCustType.Items.FindByValue(ccCust.TypeID);
this.selCustType.SelectedIndex = this.selCustType.Items.IndexOf(li);
if (task.Source == 2) //CRM库来源
{
selCustType.Attributes.Add("disabled", "disabled"); //不能编辑客户类别
}
li = this.selCustIndustry.Items.FindByValue(ccCust.IndustryID);
this.selCustIndustry.SelectedIndex = this.selCustIndustry.Items.IndexOf(li);
this.InitialProvinceID = ccCust.ProvinceID;
this.InitialCityID = ccCust.CityID;
this.InitialCountyID = ccCust.CountyID;
this.tfAddress.Value = ccCust.Address;
this.tfZipcode.Value = ccCust.Zipcode;
if (!string.IsNullOrEmpty(ccCust.TradeMarketID))
{
//this.sltTradeMarket.Value = ccCust.TradeMarketID.ToString();
BitAuto.YanFa.Crm2009.Entities.CustInfo custInfo = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(ccCust.TradeMarketID.ToString());
if (custInfo != null)
{
tfCustPidName.Value = custInfo.CustName;
tfCustPid.Value = ccCust.TradeMarketID.ToString();
}
}
if (ccCust.CarType == 2)
{
this.chkOldCarType.Checked = true;
#region Modify=masj，Date=2012-04-13 注释掉
//if (ccCust.CstMemberID != "" && ccCust.CstMemberID != null)
//{
// this.txtCtsMemberID.Value = ccCust.CstMemberID;
//}
#endregion
//if (!string.IsNullOrEmpty(ccCust.UsedCarBusinessType))
//{
// this.sltUsedCarBusinessType.Value = ccCust.UsedCarBusinessType.ToString();
//}
}
if (!string.IsNullOrEmpty(ccCust.OriginalCustID))
{
if (ccCust.Status != null)
{
switch (ccCust.Status.Value)
{
case 0:
imgCustStatus.Src = "/Images/xt.gif";
imgCustStatus.Attributes.Add("title", "在用");
break;
case 1:
imgCustStatus.Src = "/Images/xt_1.gif";
imgCustStatus.Attributes.Add("title", "停用");
break;
default:
break;
}
}
if (ccCust.Lock != null && ccCust.Lock.Value == 1)
{
imgCustStatusLock.Src = "/Images/lock.gif";
imgCustStatusLock.Attributes.Add("title", "锁定");
}
else if (ccCust.Lock != null && ccCust.Lock.Value == 0)
{
imgCustStatusLock.Src = "/Images/unlock.gif";
imgCustStatusLock.Attributes.Add("title", "未锁定");
}
liCustStatus.Style.Remove("display");
liCustLock.Style.Remove("display");
}
li = this.selCustLevel.Items.FindByValue(ccCust.LevelID);
this.selCustLevel.SelectedIndex = this.selCustLevel.Items.IndexOf(li);
this.tfOfficeTel.Value = ccCust.OfficeTel;
this.tfFax.Value = ccCust.Fax;
this.tfContactName.Value = ccCust.ContactName;
this.tfNotes.Value = ccCust.Notes;
#endregion
BindCCMemberList();
#region 加载车商通会员信息
//如果是新车二手车或二手车
if (ccCust.CarType == 2 || ccCust.CarType == 3)
{
Entities.QueryProjectTask_CSTMember queryCstMember = new Entities.QueryProjectTask_CSTMember();
List <Entities.ProjectTask_CSTMember> ccCstMembers = BLL.ProjectTask_CSTMember.Instance.GetProjectTask_CSTMemberByTID(task.PTID);
if (ccCstMembers.Count > 0)
{
Control ctl;
foreach (Entities.ProjectTask_CSTMember m in ccCstMembers)
{
////在CRM中有会员
//if (string.IsNullOrEmpty(m.OriginalDMSMemberID) == false) { HasMembersInCrm = true; }
ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditCstMember.ascx", m);
this.PlaceHolderCstMember.Controls.Add(ctl);
}
}
//else
//{
// if (task.Source == 1)
// {
// Control ctl = this.LoadControl("~/CustInfo/EditVWithCalling/UCEditCstMember.ascx", task.TID);
// this.PlaceHolderCstMember.Controls.Add(ctl);
// }
//}
}
#endregion
}
/// <summary>
/// 将excel中信息同步到ProjectTask_Cust
/// </summary>
public void SyncInfoFromExcel(Entities.ProjectTaskInfo task)
{
if (task.Source == 1 && BLL.ProjectTask_Cust.Instance.Exists(task.PTID) == false)
{
int i = -1;
if (int.TryParse(task.RelationID, out i) == false)
{
return;
}
Entities.ExcelCustInfo excelInfo = BLL.ExcelCustInfo.Instance.GetExcelCustInfo(i);
if (excelInfo == null)
{
return;
}
//插入基本信息
Entities.ProjectTask_Cust c = new Entities.ProjectTask_Cust();
c.PTID = task.PTID;
c.CustName = excelInfo.CustName;
BitAuto.YanFa.Crm2009.Entities.EnumCustomType?ct = this.GetCustTypeByName(excelInfo.TypeName);
c.TypeID = ct.HasValue ? ((int)ct.Value).ToString() : "";
//Crm2009.Entities.EnumCustomIndustry? ci = this.GetCustIndustryByName(excelInfo.IndustryName);
//c.IndustryID = ci.HasValue ? ((int)ci.Value).ToString() : "";
c.ProvinceID = BLL.AreaHelper.Instance.GetAreaIDByName(excelInfo.ProvinceName);
c.CityID = BLL.AreaHelper.Instance.GetAreaIDByName(excelInfo.CityName);
c.CountyID = BLL.AreaHelper.Instance.GetAreaIDByName(excelInfo.CountyName);
c.BrandIDs = BLL.CarBrandHelper.Instance.GetCarBrandIDsByNames(excelInfo.BrandName);
c.Address = excelInfo.Address;
c.OfficeTel = excelInfo.OfficeTel;
c.Fax = excelInfo.Fax;
c.Zipcode = excelInfo.Zipcode;
c.CreateTime = c.LastUpdateTime = DateTime.Now;
c.CreateUserID = c.LastUpdateUserID = BLL.Util.GetLoginUserID();
c.CarType = excelInfo.CarType;
c.ContactName = excelInfo.ContactName;
if (!string.IsNullOrEmpty(excelInfo.ContactName))
{
c.ContactName = excelInfo.ContactName;
}
if (excelInfo.TradeMarketID > 0)
{
c.TradeMarketID = excelInfo.TradeMarketID.ToString();
}
if (excelInfo.CarType > 0)
{
c.CarType = excelInfo.CarType;
}
if (!string.IsNullOrEmpty(excelInfo.TypeName))
{
foreach (BitAuto.YanFa.Crm2009.Entities.EnumCustomType type in (BitAuto.YanFa.Crm2009.Entities.EnumCustomType[])Enum.GetValues(typeof(BitAuto.YanFa.Crm2009.Entities.EnumCustomType)))
{
if (Utils.EnumHelper.GetEnumTextValue(type) == excelInfo.TypeName)
{
c.TypeID = ((int)type).ToString();
break;
}
}
}
if (excelInfo.MonthSales > 0 || excelInfo.MonthStock > 0 || excelInfo.MonthTrade > 0)
{
Entities.ProjectTask_BusinessScale scaleInfo = new Entities.ProjectTask_BusinessScale();
scaleInfo.CreateTime = DateTime.Now;
scaleInfo.CreateUserID = Util.GetLoginUserID();
scaleInfo.MonthSales = excelInfo.MonthSales;
scaleInfo.MonthStock = excelInfo.MonthStock;
scaleInfo.MonthTrade = excelInfo.MonthTrade;
scaleInfo.Status = 0;
scaleInfo.PTID = task.PTID;
BLL.ProjectTask_BusinessScale.Instance.Insert(scaleInfo);
}
BLL.ProjectTask_Cust.Instance.Insert(c);
}
}
/// <summary>
/// 批量为员工分配任务（单选）
/// </summary>
/// <param name="model"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool InsertProjectTaskInfo_Employee(Entities.ProjectTaskInfo model, int userId)
{
return(Dal.ProjectTaskInfo.Instance.InsertProjectTaskInfo_Employee(model, userId));
}
public void Add(SqlTransaction sqltran, Entities.ProjectTaskInfo model)
{
Dal.ProjectTaskInfo.Instance.Add(sqltran, model);
}
//str += "<a href='SurveyInfo.aspx?SIID='" + dt.Rows[i]["SIID"].ToString() + "'+'&ProJectID='" + dt.Rows[i]["ProjectID"].ToString() + "'+'&TaskID='" + dt.Rows[i]["PTID"].ToString() + "' target='_blank'>" + dt.Rows[i]["Name"].ToString() + "</a> ";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int _projectid;
if (int.TryParse(RequestProjectID, out _projectid))
{
//后续需要判断任务状态，不是所有状态都可以答问卷,任务在处理中，未处理加载可编辑问卷，其他状态加载只能查看
if (string.IsNullOrEmpty(RequestTaskID))
{
Response.Write(@"<script language='javascript'>javascript:alert('核实任务不存在');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
//else if (string.IsNullOrEmpty(RequestSIID))
//{
// Response.Write("<script language='javascript'>alert('核实问卷不存在！');closePage();</script>");
//}
else
{
if (!string.IsNullOrEmpty(RequestSIID))
{
Entities.ProjectTaskInfo Taskinfo = BLL.ProjectTaskInfo.Instance.GetProjectTaskInfo(RequestTaskID);
if (Request["Action"] != null && Request["Action"] == "view")
{
UCSurveyInfoEdit1.Visible = false;
UCSurveyInfoView1.Visible = true;
UCSurveyInfoView1.RequestSIID = RequestSIID;
UCSurveyInfoView1.RequestPTID = RequestTaskID;
btnsave.Visible = false;
}
else
{
//核实任务在处理中，或未处理
if (Taskinfo.TaskStatus == (int)Entities.EnumProjectTaskStatus.NoAssign || Taskinfo.TaskStatus == (int)Entities.EnumProjectTaskStatus.Assigning)
{
UCSurveyInfoEdit1.Visible = true;
UCSurveyInfoView1.Visible = false;
UCSurveyInfoEdit1.RequestSIID = RequestSIID;
UCSurveyInfoEdit1.RequestPTID = RequestTaskID;
btnsave.Visible = true;
}
else
{
UCSurveyInfoEdit1.Visible = false;
UCSurveyInfoView1.Visible = true;
UCSurveyInfoView1.RequestSIID = RequestSIID;
UCSurveyInfoView1.RequestPTID = RequestTaskID;
btnsave.Visible = false;
}
}
}
}
}
else
{
Response.Write(@"<script language='javascript'>javascript:alert('核实项目id数据格式不正确！');try {
window.external.MethodScript('/browsercontrol/closepage');
} catch (e) {
window.opener = null; window.open('', '_self'); window.close();
};</script>");
}
}
}
