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