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