public DataTable QueryProductLineList(ProductLineFilter filter, out int totalCount) { if (filter.IsSearchEmptyCategory.HasValue && filter.IsSearchEmptyCategory.Value) { return(QueryEmptyCategory2List(filter, out totalCount)); } else { return(Query(filter, out totalCount)); } }
public QueryResult QueryProductLine(ProductLineFilter request) { if (request == null) { throw new ArgumentNullException("request"); } int totalCount; var data = ObjectFactory <IProductLineQueryDA> .Instance.QueryProductLineList(request, out totalCount); return(new QueryResult { Data = data, TotalCount = totalCount }); }
private DataTable Query(ProductLineFilter filter, out int totalCount) { string pmrangetype = string.Empty; if (filter.PMRangeType.HasValue) { pmrangetype = filter.PMRangeType.ToString(); } DataCommand cmd = DataCommandManager.GetDataCommand("ProductLine_GetList"); cmd.SetParameterValue("@SortField", filter.PagingInfo.SortBy); cmd.SetParameterValue("@PageSize", filter.PagingInfo.PageSize); cmd.SetParameterValue("@PageCurrent", filter.PagingInfo.PageIndex); cmd.SetParameterValue("@CompanyCode", filter.CompanyCode); cmd.SetParameterValue("@BrandSysNo", filter.BrandSysNo); cmd.SetParameterValue("@C1SysNo", filter.C1SysNo); cmd.SetParameterValue("@C2SysNo", filter.C2SysNo); cmd.SetParameterValue("@PMSysNo", filter.PMUserSysNo); cmd.SetParameterValue("@PMRangeType", pmrangetype); DataTable table = cmd.ExecuteDataTable(); table.Columns.Add("BackupPMNameList", typeof(string)); table.Columns.Add("MerchandiserName", typeof(string)); foreach (DataRow row in table.Rows) { row["MerchandiserName"] = GetUserNameList(row["MerchandiserSysNo"].ToString())[0].UserInfo.UserDisplayName; string bakpmstring = string.Format("{0}", row["BackupPMSysNoList"]); if (string.IsNullOrEmpty(bakpmstring)) { continue; } string sysnolist = string.Format("{0}", row["BackupPMSysNoList"]).Replace(';', ','); List <string> bakpm = bakpmstring.Split(';').ToList <string>(); int result = 0; bakpm = bakpm.Where(p => (!string.IsNullOrEmpty(p) && int.TryParse(p, out result))).ToList <string>(); List <string> pms = new List <string>(); GetUserNameList(bakpm.Join(",")).ForEach(pm => { pms.Add(pm.UserInfo.UserDisplayName); }); row["BackupPMNameList"] = pms.Join(";"); //row["MerchandiserSysNo"] = bakpm.Join(";"); } totalCount = (int)cmd.GetParameterValue("@TotalCount"); return(table); }
private DataTable QueryEmptyCategory2List(ProductLineFilter filter, out int totalCount) { DataCommand cmd = DataCommandManager.GetDataCommand("ProductLine_GetEmptyCategory2List"); cmd.SetParameterValue("@SortField", filter.PagingInfo.SortBy); cmd.SetParameterValue("@PageSize", filter.PagingInfo.PageSize); cmd.SetParameterValue("@PageCurrent", filter.PagingInfo.PageIndex); cmd.SetParameterValue("@CompanyCode", filter.CompanyCode); cmd.SetParameterValue("@BrandSysNo", filter.BrandSysNo); cmd.SetParameterValue("@C1SysNo", filter.C1SysNo); cmd.SetParameterValue("@C2SysNo", filter.C2SysNo); cmd.SetParameterValue("@PMSysNo", filter.PMUserSysNo); DataTable table = cmd.ExecuteDataTable(); totalCount = (int)cmd.GetParameterValue("@TotalCount"); return(table); }