public EasyUIgridCollectionInvokeResult <SmsSend> ListForEasyUIgridPage(EasyUIgridCollectionParam <SmsSend> param) { EasyUIgridCollectionInvokeResult <SmsSend> result = new EasyUIgridCollectionInvokeResult <SmsSend> { Success = true }; try { /***********************begin 复杂查询添加代码*********************/ StringObjectDictionary filters = new StringObjectDictionary(); if (param.instance != null) { filters = param.instance.ToStringObjectDictionary(false); } List <string> whereClause = new List <string>(); /**********************************************************/ if (param.filterFields != null) { foreach (var field in param.filterFields) { DateTime parseTime = new DateTime(); if (field.key.Equals("CheckInTime_Start") && DateTime.TryParse(field.value, out parseTime)) { whereClause.Add(string.Format("CheckInTime >= '{0}' ", field.value)); } else if (field.key.Equals("CheckInTime_End") && DateTime.TryParse(field.value, out parseTime)) { whereClause.Add(string.Format("CheckInTime <= '{0}' ", field.value)); } else { filters[field.key] = field.value; } } } /***********************begin 模糊查询*********************/ if (param.fuzzyFields != null) { List <string> fuzzys = new List <string>(); foreach (var field in param.fuzzyFields) { fuzzys.Add(string.Format("{0} like '%{1}%'", field.key, field.value)); } if (fuzzys.Count > 0) { whereClause.Add("(" + string.Join((string.IsNullOrEmpty(param.fuzzyFieldOP) ? " AND " : " " + param.fuzzyFieldOP + " "), fuzzys.ToArray()) + ")"); } } /***********************end 模糊查询***********************/ /***********************begin 自定义代码*******************/ /***********************此处添加自定义查询代码*************/ /***********************end 自定义代码*********************/ if (whereClause.Count > 0) { filters.Add("WhereClause", string.Join(" AND ", whereClause.ToArray())); } /**********************************************************/ /***********************begin 排序*************************/ gridCollectionPager.EasyUIgridDoPage4Model <SmsSend>(filters, param, ref result); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public EasyUIgridCollectionInvokeResult <StringObjectDictionary> OldManComplainInfo_Grid(EasyUIgridCollectionParam <StringObjectDictionary> param) { EasyUIgridCollectionInvokeResult <StringObjectDictionary> result = new EasyUIgridCollectionInvokeResult <StringObjectDictionary> { Success = true }; try { /***********************begin 复杂查询添加代码*********************/ StringObjectDictionary filters = new StringObjectDictionary(); List <string> whereClause = new List <string>(); if (param.filterFields != null) { foreach (var field in param.filterFields) { filters[field.key] = field.value; } } if (param.fuzzyFields != null) { List <string> fuzzys = new List <string>(); foreach (var field in param.fuzzyFields) { if (field.key.IndexOf("AreaId") > -1 && field.value != "") { whereClause.Add(string.Format("(AreaId3 in (select cast(AreaId as varchar (40)) from Pub_Area where {0} like '{1}%') or AreaId2 in (select cast(AreaId as varchar (40)) from Pub_Area where {0} like '{1}%'))", field.key, field.value)); } else if (field.key.IndexOf("AreaId") > -1 && field.value == "") { } else { fuzzys.Add(string.Format("{0} like '%{1}%'", field.key, field.value)); } } if (fuzzys.Count > 0) { whereClause.Add("(" + string.Join((string.IsNullOrEmpty(param.fuzzyFieldOP) ? " AND " : " " + param.fuzzyFieldOP + " "), fuzzys.ToArray()) + ")"); } } /***********************begin 自定义代码*******************/ string sql = PermissionsCategoryView(); if (sql == "user") { whereClause.Add("'0'='1'"); } else if (sql != "admin") { whereClause.Add(sql); } if (whereClause.Count > 0) { filters.Add("WhereClause", string.Join(" AND ", whereClause.ToArray())); } gridCollectionPager.EasyUIgridDoPage4StringObjectDictionary("OldManComplainInfos_ListByPage", filters, param, ref result); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public EasyUIgridCollectionInvokeResult <StringObjectDictionary> ListForEasyUIgrid(EasyUIgridCollectionParam <StringObjectDictionary> param) { EasyUIgridCollectionInvokeResult <StringObjectDictionary> result = new EasyUIgridCollectionInvokeResult <StringObjectDictionary> { Success = true }; try { /***********************begin 复杂查询添加代码*********************/ StringObjectDictionary filters = new StringObjectDictionary(); if (param.instance != null) { filters = param.instance.ToStringObjectDictionary(false); } List <string> whereClause = new List <string>(); /**********************************************************/ if (param.filterFields != null) { foreach (var field in param.filterFields) { filters[field.key] = field.value; } } /***********************begin 模糊查询*********************/ if (param.fuzzyFields != null) { foreach (var field in param.fuzzyFields) { whereClause.Add(string.Format("{0} like '%{1}%'", field.key, field.value)); } } /***********************end 模糊查询***********************/ /***********************begin 自定义代码*******************/ /***********************此处添加自定义查询代码*************/ /***********************end 自定义代码*********************/ if (whereClause.Count > 0) { filters.Add("WhereClause", string.Join(" AND ", whereClause.ToArray())); } /**********************************************************/ /***********************begin 排序*************************/ /**********************************************************/ if (!string.IsNullOrEmpty(param.sort)) { filters.Add("OrderByClause", param.sort + " " + param.order ?? "ASC"); } /***********************end 排序***************************/ gridCollectionPager.EasyUIgridDoPage <StringObjectDictionary>(BuilderFactory.DefaultBulder().ListStringObjectDictionary("SmsSend_List2", filters), param, ref result); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public EasyUIgridCollectionInvokeResult <StringObjectDictionary> ListForEasyUIgridPage(EasyUIgridCollectionParam <StringObjectDictionary> param) { EasyUIgridCollectionInvokeResult <StringObjectDictionary> result = new EasyUIgridCollectionInvokeResult <StringObjectDictionary> { Success = true }; try { /***********************begin 复杂查询添加代码*********************/ StringObjectDictionary filters = new StringObjectDictionary(); if (param.instance != null) { filters = param.instance.ToStringObjectDictionary(false); } List <string> whereClause = new List <string>(); /**********************************************************/ if (param.filterFields != null) { foreach (var field in param.filterFields) { if (field.key.Contains("AreaId2_Start") && field.value != "") { filters["AreaId2"] = field.value; } else if (field.key.Contains("AreaId3_Start") && field.value != "") { filters["AreaId3"] = field.value; } else { filters[field.key] = field.value; } } } /***********************begin 模糊查询*********************/ if (param.fuzzyFields != null) { List <string> fuzzys = new List <string>(); foreach (var field in param.fuzzyFields) { fuzzys.Add(string.Format("{0} like '%{1}%'", field.key, field.value)); } if (fuzzys.Count > 0) { whereClause.Add("(" + string.Join((string.IsNullOrEmpty(param.fuzzyFieldOP) ? " AND " : " " + param.fuzzyFieldOP + " "), fuzzys.ToArray()) + ")"); } } /***********************end 模糊查询***********************/ /***********************begin 自定义代码*******************/ /***********************此处添加自定义查询代码*************/ /***********************end 自定义代码*********************/ if (whereClause.Count > 0) { filters.Add("WhereClause", string.Join(" AND ", whereClause.ToArray())); } /**********************************************************/ gridCollectionPager.EasyUIgridDoPage4StringObjectDictionary("Reminder_ListByPage2", filters, param, ref result); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public EasyUIgridCollectionInvokeResult <Group> ListForEasyUIgridByUserId(EasyUIgridCollectionParam <Group> param) { EasyUIgridCollectionInvokeResult <Group> result = new EasyUIgridCollectionInvokeResult <Group> { Success = true }; try { /***********************begin 复杂查询添加代码*********************/ StringObjectDictionary filters = new StringObjectDictionary(); if (param.instance != null) { filters = param.instance.ToStringObjectDictionary(false); } List <string> whereClause = new List <string>(); /**********************************************************/ if (param.filterFields != null) { foreach (var field in param.filterFields) { filters[field.key] = field.value; } } /***********************begin 模糊查询*********************/ if (param.fuzzyFields != null) { foreach (var field in param.fuzzyFields) { if (field.key.Contains("GroupId")) { whereClause.Add(string.Format("SUBSTRING(CAST(a.GroupId as Nvarchar(40)),1,8)<>'00000000'")); } else { whereClause.Add(string.Format("{0} like '%{1}%'", field.key, field.value)); } } } /***********************end 模糊查询***********************/ /***********************begin 自定义代码*******************/ /***********************此处添加自定义查询代码*************/ /***********************end 自定义代码*********************/ if (whereClause.Count > 0) { filters.Add("WhereClause", string.Join(" AND ", whereClause.ToArray())); } /**********************************************************/ /***********************begin 排序*************************/ /**********************************************************/ if (!string.IsNullOrEmpty(param.order)) { filters.Add("OrderByClause", " case when b.UserId is null then 0 else 1 end " + param.order ?? "ASC"); } /***********************end 排序***************************/ gridCollectionPager.EasyUIgridDoPage <Group>(BuilderFactory.DefaultBulder().ExecuteSPForQuery <Group>("ListGroupByUserId", filters), param, ref result); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public EasyUIgridCollectionInvokeResult <User> ListForEasyUIgrid(EasyUIgridCollectionParam <User> param) { EasyUIgridCollectionInvokeResult <User> result = new EasyUIgridCollectionInvokeResult <User> { Success = true }; try { /***********************begin 复杂查询添加代码*********************/ StringObjectDictionary filters = new StringObjectDictionary(); List <string> whereClause = new List <string>(); if (param.instance != null) { List <string> groupIds = new List <string>(); if (param.instance.isNormalUser(groupIds)) { if (groupIds.Count > 0) { whereClause.Add(" UserId in (select UserId from Pub_GroupMember a where a.GroupId in ('" + string.Join("','", groupIds.ToArray()) + "'))"); } } filters = param.instance.ToStringObjectDictionary(false); } /**********************************************************/ /***********************begin 模糊查询*********************/ if (param.fuzzyFields != null) { foreach (var field in param.fuzzyFields) { whereClause.Add(string.Format("{0} like '%{1}%'", field.key, field.value)); } } /***********************end 模糊查询***********************/ /***********************begin 自定义代码*******************/ /***********************此处添加自定义查询代码*************/ /***********************end 自定义代码*********************/ if (whereClause.Count > 0) { filters.Add("WhereClause", string.Join(" AND ", whereClause.ToArray())); } /**********************************************************/ /***********************begin 排序*************************/ /**********************************************************/ if (!string.IsNullOrEmpty(param.sort)) { filters.Add("OrderByClause", param.sort + " " + param.order ?? "ASC"); } /***********************end 排序***************************/ gridCollectionPager.EasyUIgridDoPage <User>(BuilderFactory.DefaultBulder().List <User>(filters), param, ref result); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public EasyUIgridCollectionInvokeResult <StringObjectDictionary> GetServePeriodsForEasyUIgrid(EasyUIgridCollectionParam <StringObjectDictionary> param) { EasyUIgridCollectionInvokeResult <StringObjectDictionary> result = new EasyUIgridCollectionInvokeResult <StringObjectDictionary> { Success = true }; try { gridCollectionPager.EasyUIgridDoPage <StringObjectDictionary>(BuilderFactory.DefaultBulder().ListStringObjectDictionary("GetMerchantServePeriods"), param, ref result); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public EasyUIgridCollectionInvokeResult <StringObjectDictionary> QuerySurveyResultsForGrid(EasyUIgridCollectionParam param) { EasyUIgridCollectionInvokeResult <StringObjectDictionary> result = new EasyUIgridCollectionInvokeResult <StringObjectDictionary> { Success = true }; try { /***********************begin 复杂查询添加代码*********************/ StringObjectDictionary filters = new StringObjectDictionary(); List <string> whereClause = new List <string>(); if (param.filterFields != null) { foreach (var field in param.filterFields) { filters[field.key] = field.value; } } if (param.fuzzyFields != null) { foreach (var field in param.fuzzyFields) { whereClause.Add(string.Format("{0} like '%{1}%'", field.key, field.value)); } } /***********************end 模糊查询***********************/ /***********************begin 自定义代码*******************/ /***********************此处添加自定义查询代码*************/ /***********************end 自定义代码*********************/ if (whereClause.Count > 0) { filters.Add("WhereClause", string.Join(" AND ", whereClause.ToArray())); } /**********************************************************/ /***********************begin 排序*************************/ /**********************************************************/ //if (!string.IsNullOrEmpty(param.sort)) //{ // filters.Add("OrderByClause", param.sort + " " + param.order ?? "ASC"); //} /***********************end 排序***************************/ gridCollectionPager.EasyUIgridDoPage4StringObjectDictionary("SurveyResultMixed_ListByPage", filters, param, ref result); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }