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