/// <summary>
/// 获取列表
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="title"></param>
/// <param name="summary"></param>
/// <returns>JSON数据</returns>
public string GetList(int page, int limit, string title = "", string summary = "", string orderByField = "ID", string orderByType = "ASC")
{
string where = "1=1";
if (string.IsNullOrWhiteSpace(title) == false)
{
where += " AND TITLE LIKE '%" + title.Replace('\'', ' ') + "%'";
}
if (string.IsNullOrWhiteSpace(summary) == false)
{
where += " AND SUMMARY LIKE '%" + summary.Replace('\'', ' ') + "%'";
}
Library.BaseQuery.BBaseQuery.Order order = new Library.BaseQuery.BBaseQuery.Order(orderByField, orderByType);
List <Models.FW.BulletinModelsForList> umList = new List <Models.FW.BulletinModelsForList>();
IList <BLL.FW.BF_BULLETIN.Entity> ueList = BLL.FW.BF_BULLETIN.Instance.GetListPage(limit, page, order, where);
int count = BLL.FW.BF_BULLETIN.Instance.GetCount(where);
if (ueList != null && ueList.Count > 0)
{
foreach (BLL.FW.BF_BULLETIN.Entity ue in ueList)
{
Models.FW.BulletinModelsForList um = new Models.FW.BulletinModelsForList();
um.ID = ue.ID;
um.TITLE = ue.TITLE;
um.SUMMARY = ue.SUMMARY;
um.IS_ENABLE = ue.IS_ENABLE;
um.CONTENT = ue.CONTENT;
um.CREATE_UID_NAME = BLL.FW.BF_USER.Instance.GetStringValueByKey(ue.CREATE_UID, "NAME");
um.CREATE_TIME = ue.CREATE_TIME;
umList.Add(um);
}
}
return(ToJsonString(umList, count));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="id"></param>
/// <returns>JSON数据</returns>
public string GetList(int page, int limit, string content = "", string daterange = "", string userName = "", string orderByField = "ID", string orderByType = "DESC")
{
#region 查询条件
List <object> param = new List <object>();
string where = "1=1";
if (string.IsNullOrWhiteSpace(content) == false)
{
where += " and content LIKE '%" + content.Replace('\'', ' ') + "%'";
}
DateTime beginDate = DateTime.Today.AddDays(-1);
DateTime endDate = DateTime.Today;
if (string.IsNullOrWhiteSpace(daterange) == false)
{
Functions.GetIntervalDate(daterange, ref beginDate, ref endDate);
}
where += " and LOG_TIME >= to_date('" + beginDate + "','yyyy-mm-dd hh24:mi:ss') and LOG_TIME < to_date('" + endDate.AddDays(1) + "','yyyy-mm-dd hh24:mi:ss')";
if (string.IsNullOrWhiteSpace(userName) == false)
{
where += " and USER_NAME LIKE '%" + userName.Replace('\'', ' ') + "%'";
}
#endregion
Library.BaseQuery.BBaseQuery.Order order = new Library.BaseQuery.BBaseQuery.Order(orderByField, orderByType);
IList <BLL.FW.BF_OP_LOG.Entity> list = BLL.FW.BF_OP_LOG.Instance.GetListPage <BLL.FW.BF_OP_LOG.Entity>(limit, page, order, where, param);
int count = BLL.FW.BF_OP_LOG.Instance.GetCount(where, param);
if (list == null)
{
list = new List <BLL.FW.BF_OP_LOG.Entity>();
count = 0;
}
return(ToJsonString(list, count));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="pcode"></param>
/// <param name="name"></param>
/// <param name="code"></param>
/// <returns>JSON数据</returns>
public string GetList(int page, int limit, int pcode = 0, string name = "", string code = "", string orderByField = "ID", string orderByType = "ASC")
{
string where = "1=1";
List <object> param = new List <object>();
if (pcode > 0)
{
where += " AND P_CODE=?";
param.Add(pcode);
}
if (string.IsNullOrWhiteSpace(name) == false)
{
where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'";
}
if (string.IsNullOrWhiteSpace(code) == false)
{
where += " AND DEPT_CODE=? ";
param.Add(code);
}
Library.BaseQuery.BBaseQuery.Order order = new Library.BaseQuery.BBaseQuery.Order(orderByField, orderByType);
IList <BF_DEPARTMENT.Entity> list = BF_DEPARTMENT.Instance.GetListPage <BF_DEPARTMENT.Entity>(limit, page, order, where, param);
int count = BF_DEPARTMENT.Instance.GetCount(where, param);
if (list == null)
{
list = new List <BF_DEPARTMENT.Entity>();
count = 0;
}
return(ToJsonString(list, count));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="name"></param>
/// <param name="ip"></param>
/// <param name="type"></param>
/// <param name="orderByField"></param>
/// <param name="orderByType"></param>
/// <returns>JSON数据</returns>
public string GetList(int page, int limit, string name = "", string ip = "", int type = 0, string orderByField = "ID", string orderByType = "ASC")
{
string where = "1=1";
if (string.IsNullOrWhiteSpace(name) == false)
{
where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'";
}
if (string.IsNullOrWhiteSpace(ip) == false)
{
where += " AND IP LIKE '%" + ip.Replace('\'', ' ') + "%'";
}
if (type > 0)
{
where += " AND DB_TYPE=" + type;
}
Library.BaseQuery.BBaseQuery.Order order = new Library.BaseQuery.BBaseQuery.Order(orderByField, orderByType);
IList <BF_DATABASE.Entity> list = BF_DATABASE.Instance.GetListPage <BF_DATABASE.Entity>(limit, page, order, where);
int count = BF_DATABASE.Instance.GetCount(where);
if (list == null)
{
list = new List <BF_DATABASE.Entity>();
count = 0;
}
return(ToJsonString(list, count));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="id"></param>
/// <returns>JSON数据</returns>
public string GetList(int page, int limit, string message = "", int TaskId = 0, string orderByField = "ID", string orderByType = "ASC")
{
if (TaskId <= 0)
{
return("[]");
}
List <object> param = new List <object>();
string where = "TASK_ID=?";
param.Add(TaskId);
if (string.IsNullOrWhiteSpace(message) == false)
{
where += " and message LIKE '%" + message.Replace('\'', ' ') + "%'";
}
Library.BaseQuery.BBaseQuery.Order order = new Library.BaseQuery.BBaseQuery.Order(orderByField, orderByType);
IList <BLL.FW.BF_ST_TASK_LOG.Entity> list = BLL.FW.BF_ST_TASK_LOG.Instance.GetListPage <BLL.FW.BF_ST_TASK_LOG.Entity>(limit, page, order, where, param);
int count = BF_ST_TASK_LOG.Instance.GetCount(where, param);
if (list == null)
{
list = new List <BLL.FW.BF_ST_TASK_LOG.Entity>();
count = 0;
}
return(ToJsonString(list, count));
}
/// <summary>
/// 获取基础信息列表
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="name"></param>
/// <returns>JSON数据</returns>
public string GetList(int page, int limit, string name = "", string orderByField = "ID", string orderByType = "ASC")
{
string where = "1=1";
List <object> param = new List <object>();
if (string.IsNullOrWhiteSpace(name) == false)
{
where += " AND f.NAME LIKE '%" + name.Replace('\'', ' ') + "%'";
}
Library.BaseQuery.BBaseQuery.Order order = new Library.BaseQuery.BBaseQuery.Order(orderByField, orderByType);
DataTable data = BLL.FW.BF_FORM.Instance.GetDataTable(limit, page, where, param);
return(ToJsonString(data, data.Rows.Count));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="enName"></param>
/// <param name="cnName"></param>
/// <returns>JSON数据</returns>
public string GetList(int page, int limit, string enName = "", string cnName = "", string orderByField = "ID", string orderByType = "ASC")
{
string where = "1=1";
if (string.IsNullOrWhiteSpace(enName) == false)
{
where += " AND EN_NAME LIKE '%" + enName.Replace('\'', ' ') + "%'";
}
if (string.IsNullOrWhiteSpace(cnName) == false)
{
where += " AND CN_NAME LIKE '%" + cnName.Replace('\'', ' ') + "%'";
}
Library.BaseQuery.BBaseQuery.Order order = new Library.BaseQuery.BBaseQuery.Order(orderByField, orderByType);
IList <BF_FIELD.Entity> list = BF_FIELD.Instance.GetListPage <BF_FIELD.Entity>(limit, page, order, where);
int count = BF_FIELD.Instance.GetCount(where);
if (list == null)
{
list = new List <BF_FIELD.Entity>();
count = 0;
}
return(ToJsonString(list, count));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="name"></param>
/// <param name="cron"></param>
/// <returns>JSON数据</returns>
public string GetList(int page, int limit, string name = "", int runState = -1, int isEnable = -1, int lastTaskIs = -1, int self = 0, string orderByField = "ID", string orderByType = "ASC")
{
string where = "1=1";
if (!string.IsNullOrWhiteSpace(name))
{
where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'";
}
if (runState > -1)
{
where += " AND RUN_STATUS = " + runState;
}
if (isEnable > -1)
{
where += " AND IS_ENABLE = " + isEnable;
}
if (lastTaskIs > -1)
{
where += " AND LAST_TASK_IS =" + lastTaskIs;
}
if (self > 0)
{
where += " AND CREATE_UID = " + SystemSession.UserID;
}
Library.BaseQuery.BBaseQuery.Order order = new Library.BaseQuery.BBaseQuery.Order(orderByField, orderByType);
IList <BLL.FW.BF_ST_FLOW.Entity> list = BLL.FW.BF_ST_FLOW.Instance.GetListPage <BLL.FW.BF_ST_FLOW.Entity>(limit, page, order, where);
int count = BLL.FW.BF_ST_FLOW.Instance.GetCount(where);
if (list == null)
{
list = new List <BLL.FW.BF_ST_FLOW.Entity>();
count = 0;
}
return(ToJsonString(list, count));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="name"></param>
/// <param name="fullName"></param>
/// <returns>JSON数据</returns>
public string GetList(int page, int limit, string deptCode = "", string name = "", string fullName = "", string orderByField = "ID", string orderByType = "ASC")
{
string where = "1=1";
int dept = 0;
int.TryParse(deptCode, out dept);
if (dept > 0)
{
where += " AND DEPT_ID = " + dept;
}
if (string.IsNullOrWhiteSpace(name) == false)
{
where += " AND NAME LIKE '%" + name.Replace('\'', ' ') + "%'";
}
if (string.IsNullOrWhiteSpace(fullName) == false)
{
where += " AND FULL_NAME LIKE '%" + fullName.Replace('\'', ' ') + "%'";
}
Library.BaseQuery.BBaseQuery.Order order = new Library.BaseQuery.BBaseQuery.Order(orderByField, orderByType);
List <Models.FW.UserModelsForList> umList = new List <Models.FW.UserModelsForList>();
IList <BLL.FW.BF_USER.Entity> ueList = BLL.FW.BF_USER.Instance.GetListPage(limit, page, order, where);
int count = BLL.FW.BF_USER.Instance.GetCount(where);
if (ueList != null && ueList.Count > 0)
{
Dictionary <int, string> dicDeptName = BLL.FW.BF_DEPARTMENT.Instance.GetDictionary("ID", "NAME");
Dictionary <int, string> dicRoleName = BLL.FW.BF_ROLE.Instance.GetDictionary("ID", "NAME");
foreach (BLL.FW.BF_USER.Entity ue in ueList)
{
Models.FW.UserModelsForList um = new Models.FW.UserModelsForList();
um.ID = ue.ID;
if (dicDeptName.ContainsKey(ue.DEPT_ID) == true)
{
um.DEPT_NAME = dicDeptName[ue.DEPT_ID];
}
um.E_MAIL = ue.E_MAIL;
um.FULL_NAME = ue.FULL_NAME;
um.IS_ENABLE = ue.IS_ENABLE;
um.IS_LOCKED = ue.IS_LOCKED;
um.LAST_LOGIN_TIME = ue.LAST_LOGIN_TIME;
um.LOGIN_COUNT = ue.LOGIN_COUNT;
um.NAME = ue.NAME;
um.PHONE_NUMBER = ue.PHONE_NUMBER;
um.QQ = ue.QQ;
if (dicDeptName.Count > 0 && string.IsNullOrWhiteSpace(ue.ROLE_IDS) == false)
{
int roleID = 0;
foreach (string rid in ue.ROLE_IDS.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries))
{
if (int.TryParse(rid, out roleID) && dicRoleName.ContainsKey(roleID) == true)
{
um.ROLE_NAMES += dicRoleName[roleID] + ",";
}
}
}
umList.Add(um);
}
}
return(ToJsonString(umList, count));
}
