public WCFAddUpdateResult DelSupInfo(CRM_CompanyParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.CompanyID <= 0)
{
throw new WarnException("请指定要删除的公司ID！");
}
#endregion
WhereClip whereClip = GetSupWhereClip(param);
CRM_CompanyResult info = new CRM_CompanyResult();
info.IsDeleted = true;
affect = this.Update <CRM_CompanyResult>(info, whereClip);
#region 设置返回值
ret.Key = affect;
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
public CRM_CompanyResult GetSupInfo(CRM_CompanyParam param)
{
this.CheckSession();
CRM_CompanyResult rst = new CRM_CompanyResult();
#region 判断
if (param.CompanyID <= 0 && param.CompanyGuID == null)
{
throw new WarnException("请指定公司ID或者GUID！");
}
#endregion
#region 获取实体
WhereClip whereClip = WhereClip.All;
if (param.CompanyID > 0)
{
whereClip = whereClip && CRM_Company._.CompanyID == param.CompanyID;
}
if (param.CompanyGuID != null)
{
whereClip = whereClip && CRM_Company._.CompanyGuID == param.CompanyGuID;
}
rst = this.Select <CRM_CompanyResult>(whereClip);
if (rst != null)
{
rst.ContactList = this.SelectList <CRM_CompanyContactResult>(CRM_CompanyContact._.CompanyID == rst.CompanyID);
}
#endregion
return(rst);
}
private void button3_Click(object sender, EventArgs e)
{
CRM_CompanyLogic logic = new CRM_CompanyLogic(this);
CRM_CompanyParam param = new CRM_CompanyParam();
PageList <CRM_CompanyResult> rst = logic.GetCustPageList(param);
this.ShowMessage(rst.TotalCount.ToString());
}
public WCFAddUpdateResult DelCustInfo(CRM_CompanyParam param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.CRM.CRM_CompanyBLL", "DelCustInfo", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
public CRM_CompanyResult GetCustInfo(CRM_CompanyParam param)
{
CRM_CompanyResult ret = new CRM_CompanyResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.CRM.CRM_CompanyBLL", "GetCustInfo", param);
ret = rst == null ? new CRM_CompanyResult() : rst.Result as CRM_CompanyResult;
return(ret);
}
public List <CRM_CompanyResult> GetSupList(CRM_CompanyParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.CRM.CRM_CompanyBLL", "GetSupList", param);
List <CRM_CompanyResult> list = new List <CRM_CompanyResult>();
list = (rst == null ? new List <CRM_CompanyResult>() : rst.Result as List <CRM_CompanyResult>);
return(list);
}
public List <CRM_CompanyResult> GetCustList(CRM_CompanyParam param)
{
this.CheckSession();
List <CRM_CompanyResult> ret = new List <CRM_CompanyResult>();
try
{
WhereClip whereClip = GetCustWhereClip(param);
ret = this.SelectList <CRM_CompanyResult>(whereClip, CRM_Company._.CompanyCode.Desc);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
void BindDgvCompany(int pageIndex)
{
CRM_CompanyParam param = new CRM_CompanyParam();
if (!string.IsNullOrEmpty(txtCompanyName.Text))
{
param.CompanyName = txtCompanyName.Text.Trim();
}
if (!string.IsNullOrEmpty(txtCompanyCode.Text))
{
param.CompanyCode = txtCompanyCode.Text.Trim();
}
param.PageIndex = pageIndex;
param.PageSize = 100;
PageList <CRM_CompanyResult> lstRst = companyLogic.GetSupPageList(param);
dgvCompany.DataSource = lstRst.ResultList;
pgCompany.RecordCount = lstRst.TotalCount;
this.SetDataSource <CRM_CompanyResult>(lstRst.ResultList);
SetGridCheck(this.dgvCompany, _idColName, _chkColName);
}
public PageList <CRM_CompanyResult> GetCustPageList(CRM_CompanyParam param)
{
this.CheckSession();
PageList <CRM_CompanyResult> ret = new PageList <CRM_CompanyResult>();
try
{
List <Field> field = new List <Field>()
{
Field.All
};
ret = this.SelectList <CRM_CompanyResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), field, GetCustWhereClip(param), CRM_Company._.CompanyCode.Asc);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
WhereClip GetCustWhereClip(CRM_CompanyParam param)
{
this.CheckSession();
WhereClip where = CRM_Company._.IsDeleted == 0 && CRM_Company._.CompanyType == 1;
if (param.CompanyID > 0)
{
where = where && CRM_Company._.CompanyID == param.CompanyID;
}
if (param.CompanyGuID != null)
{
where = where && CRM_Company._.CompanyGuID == param.CompanyGuID;
}
if (!string.IsNullOrEmpty(param.CompanyName))
{
where = where && CRM_Company._.CompanyName.Like("%" + param.CompanyName + "%");
}
if (param.CompanyContactType != null)
{
DateTime dt = DateTime.Now;
//当天起始
DateTime startTime = DateTime.Now.Date;
//当天结束
DateTime endTime = startTime.Add(new TimeSpan(23, 59, 59));
//昨天起始
DateTime yesStartTime = DateTime.Now.AddDays(-1).Date;
//昨天结束
DateTime yesEndTime = yesStartTime.Add(new TimeSpan(23, 59, 59));
//ucTextBox1.Text = DateTime.Now.Date.Add(new TimeSpan(23,59,59)).ToStringHasNull();
//本周一
DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))).Date;
//本周日
DateTime endWeek = startWeek.AddDays(6).Add(new TimeSpan(23, 59, 59));
//本月月初
DateTime startMonth = dt.AddDays(1 - dt.Day).Date;
//本月月末
DateTime endMonth = startMonth.AddMonths(1).AddDays(-1).Add(new TimeSpan(23, 59, 59));
//本季度初
DateTime startQuarter = dt.AddMonths(0 - (dt.Month - 1) % 3).AddDays(1 - dt.Day);
//本季度末
DateTime endQuarter = startQuarter.AddMonths(3).AddDays(-1);
switch (param.CompanyContactType)
{
case SysEnum.CompanyContactType.Today:
where = where && CRM_Company._.LastBusinessDate >= startTime && CRM_Company._.LastBusinessDate <= endTime;
break;
case SysEnum.CompanyContactType.Yesterday:
where = where && CRM_Company._.LastBusinessDate >= yesStartTime && CRM_Company._.LastBusinessDate <= yesEndTime;
break;
case SysEnum.CompanyContactType.ThisWeek:
where = where && CRM_Company._.LastBusinessDate >= startWeek && CRM_Company._.LastBusinessDate <= endWeek;
break;
case SysEnum.CompanyContactType.ThisMonth:
where = where && CRM_Company._.LastBusinessDate >= startMonth && CRM_Company._.LastBusinessDate <= endMonth;
break;
case SysEnum.CompanyContactType.ThreeMonth:
where = where && CRM_Company._.LastBusinessDate >= startTime.AddMonths(-3) && CRM_Company._.LastBusinessDate <= startTime.Add(new TimeSpan(23, 59, 59));
break;
case SysEnum.CompanyContactType.OneMonthNonContact:
where = where && CRM_Company._.LastBusinessDate < startTime.AddMonths(-1);
break;
case SysEnum.CompanyContactType.ThreeMonthNonContact:
where = where && CRM_Company._.LastBusinessDate < startTime.AddMonths(-3);
break;
case SysEnum.CompanyContactType.AboveOneYear:
where = where && CRM_Company._.LastBusinessDate < startTime.AddYears(-1);
break;
}
}
return(where);
}
public void BindDataGridView(int pageIndex)
{
CRM_CompanyParam param = new CRM_CompanyParam();
if (!string.IsNullOrEmpty(txtCompanyCode.Text.Trim()))
{
param.CompanyCode = txtCompanyCode.Text.Trim();
}
if (!string.IsNullOrEmpty(txtCompanyName.Text.Trim()))
{
param.CompanyName = txtCompanyName.Text.Trim();
}
param.CompanySearchType = rdoMySupplier.Checked ? SysEnum.CompanySearchType.Me : SysEnum.CompanySearchType.All;
if (adtCust.SelectedNode != null && adtCust.SelectedNode.Parent.Name == "trnContactedCust")
{
string contactType = adtCust.SelectedNode.Name.Substring(3);
switch (contactType)
{
case "Today": //今天联系过的供应商
param.CompanyContactType = SysEnum.CompanyContactType.Today;
break;
case "Yesterday": //昨天联系过的供应商
param.CompanyContactType = SysEnum.CompanyContactType.Yesterday;
break;
case "ThisWeek": //这周联系过的供应商
param.CompanyContactType = SysEnum.CompanyContactType.ThisWeek;
break;
case "ThisMonth": //这个月联系过的供应商
param.CompanyContactType = SysEnum.CompanyContactType.ThisMonth;
break;
case "ThreeMonth": //三个月内联系过的供应商
param.CompanyContactType = SysEnum.CompanyContactType.ThreeMonth;
break;
case "OneMonthNonContact": //近一个月未联系过的供应商
param.CompanyContactType = SysEnum.CompanyContactType.OneMonthNonContact;
break;
case "ThreeMonthNonContact": //近三个月未联系过的供应商
param.CompanyContactType = SysEnum.CompanyContactType.ThreeMonthNonContact;
break;
case "AboveThreeMonth": //三个月以上未联系过的供应商
param.CompanyContactType = SysEnum.CompanyContactType.AboveThreeMonth;
break;
case "AboveOneYear": //一年以上未联系过的供应商
param.CompanyContactType = SysEnum.CompanyContactType.AboveOneYear;
break;
case "SpecialAttention":
param.CompanyContactType = SysEnum.CompanyContactType.SpecialAttention;
break;
case "Focus":
param.CompanyContactType = SysEnum.CompanyContactType.Focus;
break;
case "ColdTreament":
param.CompanyContactType = SysEnum.CompanyContactType.ColdTreament;
break;
case "AreTracking":
param.CompanyContactType = SysEnum.CompanyContactType.AreTracking;
break;
case "IsTrackOver":
param.CompanyContactType = SysEnum.CompanyContactType.IsTrackOver;
break;
case "NoTrack":
param.CompanyContactType = SysEnum.CompanyContactType.NoTrack;
break;
}
}
param.PageIndex = pageIndex;
param.PageSize = 100;
PageList <CRM_CompanyResult> pageList = this.AsyncExecute <PageList <CRM_CompanyResult>, CRM_CompanyParam>(param, companyLogic.GetSupPageList, a =>
{
dgvCompany.DataSource = a.ResultList;
pgCompany.RecordCount = a.TotalCount;
});
}
