/// <summary>
/// 获取站点配置列表
/// </summary>
/// <param name="id">站点编码</param>
/// <param name="page">页数</param>
/// <param name="rows">所有数据行数</param>
/// <param name="search"></param>
/// <param name="sidx"></param>
/// <param name="sord">排序</param>
/// <returns></returns>
public ActionResult GetStationConfigList(string id, int page, int rows, string search, string sidx, string sord)
{
string filters = Request["filters"] == null ? "" : Request["filters"].ToString();
string filtersSql = "";
if (!string.IsNullOrEmpty(filters))
{
filtersSql = BulidJqGridSearch.BuildSearch(filters);
}
//string
List <Bse_CheckValue> list = new List <Bse_CheckValue>();
if (string.IsNullOrEmpty(id))
{
}
if (string.IsNullOrEmpty(filtersSql))
{
list = aInstance.GetConfigByStaion(id, "1=1");
}
else
{
list = aInstance.GetConfigByStaion(id, filtersSql);
}
var model = list.AsQueryable <Bse_CheckValue>();
var result = JsonConvert.SerializeObject(model.ToJqGridData(page, rows, null, search, null), new JsonDateConverter("yyyy-MM-dd"));
return(JavaScript(result));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult GetLogList(int page, int rows, string search, string sidx, string sord)
{
string filters = Request["filters"] == null ? "" : Request["filters"].ToString();
string filtersSql = "";
if (!string.IsNullOrEmpty(filters))
{
filtersSql = BulidJqGridSearch.BuildSearch(filters);
}
//string
List <Sys_OpLog> list = new List <Sys_OpLog>();
if (!string.IsNullOrEmpty(filtersSql))
{
list = upInstance.GetLogList(" And " + filtersSql);
}
else
{
list = upInstance.GetLogList(" And 1=1");
}
var model = list.AsQueryable <Sys_OpLog>();
var result = JsonConvert.SerializeObject(model.ToJqGridData(page, rows, null, search, null), new JsonDateConverter("yyyy-MM-dd"));
return(JavaScript(result));
}
/// <summary>
/// 获取客户列表
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="search"></param>
/// <param name="sidx"></param>
/// <param name="sord"></param>
/// <returns></returns>
public ActionResult GetCustomerList(int page, int rows, string search, string sidx, string sord)
{
string filter = Request["filters"] != null ? Request["filters"] : "";
string filterSql = "";
if (!string.IsNullOrEmpty(filter))
{
filterSql = BulidJqGridSearch.BuildSearch(filter);
//filterSql = BulidJqGridSearch.BuildSearch(filter);
}
List <SD_Customer> list = new List <SD_Customer>();
if (string.IsNullOrEmpty(filterSql))
{
list = cInstance.GetCustomerList("1=1");
}
else
{
list = cInstance.GetCustomerList(filterSql);
}
var model = list.AsQueryable <SD_Customer>();
//var result = model.ToJqGridData(page, rows, null, search, null);
//return Json(result, JsonRequestBehavior.AllowGet);
var jsonResult = JsonConvert.SerializeObject(model.ToJqGridData(page, rows, null, search, null), new JsonDateConverter("yyyy-MM-dd"));
return(JavaScript(jsonResult));
}
public ActionResult GetEmpList(string id, int page, int rows, string search, string sidx, string sord)
{
//string id = string.Empty;
string filters = Request["filters"] == null ? "" : Request["filters"].ToString();
string filtersSql = "";
if (!string.IsNullOrEmpty(filters))
{
filtersSql = BulidJqGridSearch.BuildSearch(filters);
}
//string
List <HR_Stuff> list = new List <HR_Stuff>();
if (string.IsNullOrEmpty(id))
{
if (!string.IsNullOrEmpty(filtersSql))
{
list = hrInstance.GetListByCode(" AND " + filtersSql);
}
else
{
list = hrInstance.GetListByCode("");
}
}
else
{
if (!string.IsNullOrEmpty(filtersSql))
{
list = hrInstance.GetStuffByDept(id, " AND " + filtersSql);
}
else
{
list = hrInstance.GetStuffByDept(id, "AND 1=1");
}
}
var model = list.AsQueryable <HR_Stuff>();
var result = JsonConvert.SerializeObject(model.ToJqGridData(page, rows, null, search, null), new JsonDateConverter("yyyy-MM-dd"));
return(JavaScript(result));
}
/// <summary>
/// Bug日记
/// </summary>
/// <param name="id"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="search"></param>
/// <param name="sidx"></param>
/// <param name="sord"></param>
/// <returns></returns>
public ActionResult LogGetList(int page, int rows, string search, string sidx, string sord)
{
List <Sys_BugLog> list = new List <Sys_BugLog>();
string filters = Request["filters"];
string filtersSql = string.Empty;
if (!string.IsNullOrEmpty(Request["Code"]))
{
filtersSql = "and SL_Code='" + Request["Code"] + "'";
}
if (!string.IsNullOrEmpty(filters))
{
filtersSql = " AND " + BulidJqGridSearch.BuildSearch(filters);
}
if (!string.IsNullOrEmpty(filtersSql))
{
list = buglogInstance.GetListByCode(filtersSql);
}
else
{
list = buglogInstance.GetAll();
}
if (list.Count() > 0)
{
foreach (var item in list)
{
var dictModel = dictInstance.GetModel(" AND Dict_Code='" + item.SL_Status + "'");
if (dictModel != null)
{
item.SL_Status = dictModel.Dict_Name;
}
}
}
var model = list.OrderByDescending(o => o.SL_ID).AsQueryable <Sys_BugLog>();
var result = JsonConvert.SerializeObject(model.ToJqGridData(page, rows, null, search, null), new JsonDateConverter("yyyy-MM-dd HH:mm"));
return(JavaScript(result));
}
public ActionResult GetEmpList(string id, int page, int rows, string search, string sidx, string sord)
{
string filters = Request["filters"] == null ? "" : Request["filters"].ToString();
string filtersSql = "";
if (!string.IsNullOrEmpty(filters))
{
filtersSql = BulidJqGridSearch.BuildSearch(filters);
}
//string
List <Bse_Employee> list = new List <Bse_Employee>();
if (string.IsNullOrEmpty(id))
{
if (!string.IsNullOrEmpty(filtersSql))
{
list = hrInstance.GetListByCode(" AND " + filtersSql);
}
else
{
list = hrInstance.GetAll();
}
}
else
{
if (!string.IsNullOrEmpty(filtersSql))
{
list = hrInstance.GetStuffByDept(id, " AND " + filtersSql);
}
else
{
list = hrInstance.GetStuffByDept(id);
}
}
//字典替换
foreach (var listmodel in list)
{
switch (listmodel.Emp_Gendar)
{
case "G001": { listmodel.Emp_Gendar = "男"; break; }
case "G002": { listmodel.Emp_Gendar = "女"; break; }
}
if (!string.IsNullOrEmpty(listmodel.Emp_Title))
{
var _model = dictInstance.GetModel(" and dict_key='STUFFTITLE' and dict_code='" + listmodel.Emp_Title + "'");
listmodel.Emp_Title = _model != null ? _model.Dict_Name : "";
}
if (!string.IsNullOrEmpty(listmodel.Emp_Duty))
{
var _model = dictInstance.GetModel(" and dict_key='STUFFDUTYTYPE' and dict_code='" + listmodel.Emp_Duty + "'");
listmodel.Emp_Duty = _model != null ? _model.Dict_Name : "";
}
}
var model = list.AsQueryable <Bse_Employee>();
var result = JsonConvert.SerializeObject(model.ToJqGridData(page, rows, null, search, null), new JsonDateConverter("yyyy-MM-dd"));
return(JavaScript(result));
}
public ActionResult GetData(int page, int rows, string search, string sidx, string sord)
{
string Name = Request["name"] == null ? "" : Request["name"].ToString();
string filters = Request["filters"] == null ? "" : Request["filters"].ToString();
string filter = Request["filter"] == null ? "" : Request["filter"].ToString();
string ModuleName = Request["m"] == null ? "" : Request["m"].ToString();
string NameSpace = Request["n"] == null ? "" : Request["n"].ToString();
string filtersSql = string.Empty;
string mapSqlFilter = string.Empty;
if (!string.IsNullOrEmpty(filters))
{
filtersSql = BulidJqGridSearch.BuildSearch(filters);
}
Bll_Sys_Config_Refer configRefer = new Bll_Sys_Config_Refer();
Bll_Sys_Config_Field_Refer configReferList = new Bll_Sys_Config_Field_Refer();
Sys_Config_Refer model = configRefer.GetListByCode(" AND R_ModuleName='"
+ ModuleName + "'")[0];
var referList = configReferList.GetListByCode(" AND D_ModuleName='" + ModuleName + "'").Where(o => !string.IsNullOrEmpty(o.D_DictKey));
Bll_Bse_Dict DictInstance = new Bll_Bse_Dict();
DataTable dt = new DataTable();
if (!string.IsNullOrEmpty(model.R_SQL))
{
if (!string.IsNullOrEmpty(filter))
{
model.R_SQL = model.R_SQL + filter;
}
if (!string.IsNullOrEmpty(filtersSql))
{
model.R_SQL = model.R_SQL + " AND " + filtersSql;
}
dt = configRefer.ListBySql(model.R_SQL);
}
else
{
string _filtersql = !String.IsNullOrEmpty(model.R_FilterSql) ? model.R_FilterSql : "";
_filtersql = _filtersql + filter;
//#region 特殊映射处理
//if (ModuleName=="HR_StuffModule")
//{
// //读取映射配置表中公司配置
// Bll_Comm comm = new Bll_Comm();
// string mapFilter = "";
// var mapModel = comm.CommMap(ModuleName, "Company");
// if (mapModel!=null)
// {
// var deptList = comm.GetChildListDeptNon(comm.CommMap(ModuleName, "Company").Map_Object);
// if (deptList.Count()>0)
// {
// foreach (var item in deptList)
// {
// }
// for (int i = 0; i < deptList.Count;i++ )
// {
// if (i==(deptList.Count-1))
// {
// mapFilter += "'" + deptList[i].Dept_Code+"'";
// }
// else
// {
// mapFilter += "'" + deptList[i].Dept_Code+ "',";
// }
// }
// mapFilter.TrimEnd(',');
// }
// mapSqlFilter = " Stuff_DepCode in(" + mapFilter + ")";
// }
//}
//#endregion
//为空时不初始化
//if (!string.IsNullOrEmpty(filter))
//{
// dt = configRefer.ListDataByCode(Name, _filtersql, filtersSql + mapSqlFilter);
//}
dt = configRefer.ListDataByCode(Name, _filtersql, filtersSql + mapSqlFilter);
}
DataTable newdt = DataTablePage.GetPagedTable(dt, page, rows);
#region 字典进行转换
//对字典进行转换
for (int i = 0; i < newdt.Rows.Count; i++)
{
foreach (var item in referList.ToList())
{
var value = newdt.Rows[i][item.D_Index] != null ? newdt.Rows[i][item.D_Index].ToString() : "";
var DictResult = DictInstance.GetListByCode(" AND Dict_Code='" + value
+ "' AND Dict_Key='" + item.D_DictKey + "' ");
if (DictResult.Count > 0)
{
newdt.Rows[i][item.D_Index] = DictResult.FirstOrDefault().Dict_Name;
}
}
}
#endregion
var json = DataTablePage.JsonForJqgrid(newdt, page, rows, dt.Rows.Count);
return(JavaScript(json));
}
