public static Mall_CheckRequestRuleDetail[] GetMall_CheckRequestRuleDetailListShiLi(Mall_CheckRequestRuleDetail[] list)
{
if (list.Length > 0)
{
var category_list = Mall_CheckCategory.GetMall_CheckCategories();
var checkinfo_list = Mall_CheckInfo.GetMall_CheckInfos();
foreach (var item in list)
{
item.CategoryType = item.EarnType;
var my_checkinfo = checkinfo_list.FirstOrDefault(p => p.ID == item.RuleID);
if (my_checkinfo != null)
{
item.CheckName = my_checkinfo.CheckName;
item.StartPoint = my_checkinfo.StartPoint;
item.EndPoint = my_checkinfo.EndPoint;
var my_category = category_list.FirstOrDefault(p => p.ID == my_checkinfo.CheckCategoryID);
if (my_category != null)
{
item.CategoryName = my_category.CategoryName;
}
}
else
{
item.CheckName = "固定积分";
item.CategoryName = item.Title;
item.StartPoint = 0;
item.EndPoint = 0;
}
}
}
return(list);
}
public static Mall_CheckRequestDetail[] GetMall_CheckRequestDetailShiLi(Mall_CheckRequestDetail[] list, List <string> conditions, List <SqlParameter> parameters)
{
if (list.Length > 0)
{
var check_rule_list = Mall_CheckRequestRule.GetMall_CheckRequestRules().ToArray();
var rule_list = GetList <Mall_CheckInfoDetail>("select * from [Mall_CheckInfo] where [ID] in (select [RuleID] from [Mall_CheckRequestRule] where [RequestID] in (select ID from [Mall_CheckRequest] where " + string.Join(" and ", conditions.ToArray()) + "))", parameters).ToArray();
var check_user_list = Mall_CheckRequestUser.GetMall_CheckRequestUsers().ToArray();
var user_list = GetList <User>("select * from [User] where [UserID] in (select [UserID] from [Mall_CheckRequestUser] where [RequestID] in (select ID from [Mall_CheckRequest] where " + string.Join(" and ", conditions.ToArray()) + "))", parameters).ToArray();
var category_list = Mall_CheckCategory.GetMall_CheckCategories();
foreach (var item in list)
{
var my_check_user_list = check_user_list.Where(p => p.RequestID == item.ID).ToArray();
if (my_check_user_list.Length > 0)
{
List <int> UserIDList = my_check_user_list.Select(p => p.UserID).ToList();
var my_user_list = user_list.Where(p => UserIDList.Contains(p.UserID)).ToArray();
item.CheckUserInfo = string.Join(",", my_user_list.Select(p => p.FinalRealName));
item.CheckUserPosition = string.Join(",", my_user_list.Where(p => !string.IsNullOrEmpty(p.PositionName)).Select(p => p.PositionName));
}
var my_check_rule_list = check_rule_list.Where(p => p.RequestID == item.ID).ToArray();
if (my_check_rule_list.Length > 0)
{
List <int> RuleIDList = my_check_rule_list.Select(p => p.RuleID).ToList();
var my_rule_list = rule_list.Where(p => RuleIDList.Contains(p.ID)).ToArray();
List <int> CategoryIDList = my_rule_list.Select(p => p.CheckCategoryID).ToList();
var my_category_list = category_list.Where(p => CategoryIDList.Contains(p.ID)).ToList();
if (item.RequestType <= 1)
{
if (my_category_list.Count > 0)
{
item.CheckCategoryName = string.Join(",", my_category_list.Select(p => p.CategoryName));
}
if (my_rule_list.Length > 0)
{
item.CheckRule = string.Join(",", my_rule_list.Select(p => p.CheckName));
}
}
else
{
item.CheckCategoryName = my_check_rule_list[0].Title;
item.CheckRule = item.RequestTypeDesc;
}
item.UserEarnPoint = my_check_rule_list.Where(p => p.EarnType == 1).Sum(p => p.PointValue);
item.UserReducePoint = my_check_rule_list.Where(p => p.EarnType == 2).Sum(p => p.PointValue);
}
}
}
return(list);
}
public static Ui.DataGrid GetMall_CheckInfoDetailGridByKeywords(string Keywords, List <int> CategoryIDList, string orderBy, long startRowIndex, int pageSize, int CategoryType)
{
long totalRows = 0;
List <SqlParameter> parameters = new List <SqlParameter>();
List <string> conditions = new List <string>();
conditions.Add("1=1");
if (CategoryType > 0)
{
conditions.Add("[CheckCategoryID] in (select [ID] from [Mall_CheckCategory] where [CategoryType]=@CategoryType)");
parameters.Add(new SqlParameter("@CategoryType", CategoryType));
}
if (!string.IsNullOrEmpty(Keywords))
{
conditions.Add("([CheckName] like @Keywords)");
parameters.Add(new SqlParameter("@Keywords", "%" + Keywords + "%"));
}
if (CategoryIDList.Count > 0)
{
conditions.Add("[CheckCategoryID] in (" + string.Join(",", CategoryIDList.ToArray()) + ")");
}
string fieldList = "[Mall_CheckInfo].* ";
string Statement = " from [Mall_CheckInfo] where " + string.Join(" and ", conditions.ToArray());
Mall_CheckInfoDetail[] list = GetList <Mall_CheckInfoDetail>(fieldList, Statement, parameters, orderBy, startRowIndex, pageSize, out totalRows).ToArray();
if (list.Length > 0)
{
var category_list = Mall_CheckCategory.GetMall_CheckCategories();
foreach (var item in list)
{
var my_category = category_list.FirstOrDefault(p => p.ID == item.CheckCategoryID);
if (my_category != null)
{
item.CategoryName = my_category.CategoryName;
item.CategoryTypeDesc = my_category.CategoryTypeDesc;
item.CategoryType = my_category.CategoryType;
}
}
}
DataAccess.Ui.DataGrid dg = new Ui.DataGrid();
dg.rows = list;
dg.total = totalRows;
dg.page = pageSize;
return(dg);
}
private void SetInfo(Foresight.DataAccess.Mall_CheckCategory data)
{
this.tdCategoryName.Value = data.CategoryName;
this.tdCategoryType.Value = data.CategoryType > 0 ? data.CategoryType.ToString() : "";
}
