public static DataTable GetProvinceReportForClientGroup(DateTime startDate, DateTime endDate, int clientGroupID, int channleClientID) { DataTable dt = new DataTable("DS"); dt.Columns.Add("ClientGroupName"); dt.Columns.Add("ChannelID"); dt.Columns.Add("CodeName"); dt.Columns.Add("ChannelClentID"); dt.Columns.Add("Province"); dt.Columns.Add("RecordCount", typeof(int)); dt.AcceptChanges(); DataTable dtReportQuery = businessProxy.GetProvinceReportForClientGroup(startDate, endDate, clientGroupID, channleClientID, false); List <ReportDataProvinceItem> reportDataProvinceItems = new List <ReportDataProvinceItem>(); foreach (DataRow dr in dtReportQuery.Rows) { SPClientGroupWrapper clientGroup = SPClientGroupWrapper.FindById((int)dr["ClientGroupID"]); SPClientChannelSettingWrapper channelSettingWrapper = SPClientChannelSettingWrapper.FindById((int)dr["ChannleClientID"]); string channelName = clientGroup.Name; string moCode = channelSettingWrapper.ParentClientChannelSetting.MoCode; string province = dr["Province"].ToString(); int recordCount = (int)dr["RecordCount"]; ReportDataProvinceItem reportDataProvinceItem = new ReportDataProvinceItem(); reportDataProvinceItem.ChannelName = channelName.ToLower(); reportDataProvinceItem.ChannelID = clientGroup.Id; reportDataProvinceItem.CodeID = channelSettingWrapper.Id; reportDataProvinceItem.CodeName = moCode.ToLower(); if (string.IsNullOrEmpty(province)) { reportDataProvinceItem.Province = "未知省份"; } else { if (string.IsNullOrEmpty(province.Trim())) { reportDataProvinceItem.Province = "未知省份"; } else { reportDataProvinceItem.Province = province.ToLower(); } } reportDataProvinceItem.RecordCount = recordCount; reportDataProvinceItem.Mo = channelSettingWrapper.CommandCode.ToLower(); if (channelSettingWrapper.ChannelCode == null) { reportDataProvinceItem.SPCode = ""; } else { reportDataProvinceItem.SPCode = channelSettingWrapper.ChannelCode.ToLower(); } if (channelSettingWrapper.CommandType == "1") { reportDataProvinceItem.MoType = "1"; } else if (channelSettingWrapper.CommandType == "2" || channelSettingWrapper.CommandType == "3" || channelSettingWrapper.CommandType == "4") { reportDataProvinceItem.MoType = "2"; } else { reportDataProvinceItem.MoType = "0"; } reportDataProvinceItem.MoLength = reportDataProvinceItem.Mo.Length; reportDataProvinceItems.Add(reportDataProvinceItem); } foreach (ReportDataProvinceItem groupItem in reportDataProvinceItems) { AddNewProvinceReportRow1(dt, groupItem.ChannelName, groupItem.CodeName, groupItem.Province, groupItem.RecordCount, groupItem.ChannelID, groupItem.CodeID); } return(dt); }
public static List <SPClientWrapper> FindAllBySPClientGroupID(SPClientGroupWrapper sPClientGroupID) { return(ConvertToWrapperList(businessProxy.FindAllBySPClientGroupID(sPClientGroupID.entity))); }
public static List <SPClientWrapper> FindAllByOrderByAndFilterAndSPClientGroupID(string orderByColumnName, bool isDesc, int pageIndex, int pageSize, SPClientGroupWrapper sPClientGroupID, out int recordCount) { return(ConvertToWrapperList(businessProxy.FindAllByOrderByAndFilterAndSPClientGroupID(orderByColumnName, isDesc, pageIndex, pageSize, sPClientGroupID.entity, out recordCount))); }
public static void Refresh(SPClientGroupWrapper instance) { businessProxy.Refresh(instance.entity); }
public static void Delete(SPClientGroupWrapper instance) { businessProxy.Delete(instance.entity); }
public static void SaveOrUpdate(SPClientGroupWrapper obj) { businessProxy.SaveOrUpdate(obj.entity); }