/// <summary>
/// 获取系统字典(某个字典的全部字典项)
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public string GetFrameDictPager(string req)
{
try
{
reqdata = this.AnaRequestData(req);
QueryItemCollection[] objs = json.Deserialize <QueryItemCollection[]>(reqdata.reqdata);
SSY_PagingParam pager = null;
Xxx.Entities.SSY_FRAME_DICT model = null;
for (int i = 0; i < objs.Length; i++)
{
if (objs[i].queryItemKey.ToUpper() == "SSY_PagingParam".ToUpper())
{
pager = json.Deserialize <SSY_PagingParam>(objs[i].queryItemValue);
}
if (objs[i].queryItemKey.ToUpper() == "SSY_FRAME_DICT".ToUpper())
{
model = json.Deserialize <Xxx.Entities.SSY_FRAME_DICT>(objs[i].queryItemValue);
}
}
List <Xxx.Entities.SSY_FRAME_DICT> objResult = this._comSomebiz.GetFrameDictPager(model, base.envirObj.distManagerParam, pager);
if (UtilitysForT <Xxx.Entities.SSY_FRAME_DICT> .ListHasData(objResult))
{
resdata = this.MakeResponseData("1", string.Empty, json.Serialize(objResult), pager.TotalSize.ToString());
}
else
{
resdata = this.MakeResponseData("0", this.GetI18nLangItem("noFindData", this.i18nCommonCurrLang), string.Empty, string.Empty);
}
}
catch (Exception ex)
{
resdata = this.MakeResponseData("0", this.GetI18nLangItem("findDataErr", this.i18nCommonCurrLang) + ex.Message, string.Empty, string.Empty);
}
return(json.Serialize(resdata));
}
/// <summary> /// 获取系统字典(某个字典的全部字典项) /// </summary> /// <param name="model"></param> /// <param name="ddnmParams"></param> /// <param name="pager"></param> /// <returns></returns> public abstract DataTable GetBizDictPager(Xxx.Entities.SSY_BIZ_DICT model, DistributeDataNodeManagerParams ddnmParams, SSY_PagingParam pager);
/// <summary> /// 获取系统日志 /// </summary> /// <param name="model"></param> /// <param name="ddnmParams"></param> /// <param name="pager"></param> /// <returns></returns> public abstract DataTable GetLogDataPager(SSY_LOGENTITY model, DistributeDataNodeManagerParams ddnmParams, SSY_PagingParam pager);
/// <summary> /// 获取系统字典(某个字典的全部字典项) /// </summary> /// <param name="model"></param> /// <param name="ddnmParams"></param> /// <param name="pager"></param> /// <returns></returns> public abstract DataTable GetFrameDictPager(SSY_FRAME_DICT model, DistributeDataNodeManagerParams ddnmParams, SSY_PagingParam pager);
/// <summary> /// 获取用户组(带分页) /// </summary> /// <param name="bizobj"></param> /// <param name="distributeDataNodeManagerParams"></param> /// <param name="pager"></param> /// <returns></returns> public abstract DataTable GetPagePager(SSY_PAGE_DICT bizobj, DistributeDataNodeManagerParams distributeDataNodeManagerParams, SSY_PagingParam pager);
/// <summary> /// 获取用户组与用户 /// </summary> /// <param name="model"></param> /// <param name="distributeDataNodeManagerParams"></param> /// <param name="pager"></param> /// <returns></returns> public abstract DataTable GetGroupUserPager(SSY_USER_GROUP_DICT model, DistributeDataNodeManagerParams distributeDataNodeManagerParams, SSY_PagingParam pager);
/// <summary> /// 获取用户组(带分页) /// </summary> /// <param name="gd"></param> /// <param name="distributeDataNodeManagerParams"></param> /// <param name="pager"></param> /// <returns></returns> public abstract DataTable GetGroup(SSY_GROUP_DICT gd, DistributeDataNodeManagerParams distributeDataNodeManagerParams, SSY_PagingParam pager);
/// <summary> /// 获取用户 /// </summary> /// <param name="bizobj"></param> /// <param name="distributeDataNodeManagerParams"></param> /// <param name="pager"></param> /// <returns></returns> public abstract DataTable GetUserdict(SSY_USER_DICT bizobj, DistributeDataNodeManagerParams distributeDataNodeManagerParams, SSY_PagingParam pager);
/// <summary>
/// 获取系统字典(某个字典的全部字典项)
/// </summary>
/// <param name="model"></param>
/// <param name="ddnmParams"></param>
/// <param name="pager"></param>
/// <returns></returns>
public List <Xxx.Entities.SSY_FRAME_DICT> GetFrameDictPager(Xxx.Entities.SSY_FRAME_DICT model, DistributeDataNodeManagerParams ddnmParams, SSY_PagingParam pager)
{
List <Xxx.Entities.SSY_FRAME_DICT> listReturn = new List <Xxx.Entities.SSY_FRAME_DICT>();
DataTable dt = this.comSomebiz.GetFrameDictPager(model, ddnmParams, pager);
if (Common.Utility.DtHasData(dt))
{
listReturn = Common.UtilitysForT <Xxx.Entities.SSY_FRAME_DICT> .GetListsObj(dt);
}
return(listReturn);
}
/// <summary>
/// 获取系统字典(某个字典的全部字典项)
/// </summary>
/// <param name="model"></param>
/// <param name="ddnmParams"></param>
/// <param name="pager"></param>
/// <returns></returns>
public List <SSY_BIZ_DICT> GetBizDictPager(SSY_BIZ_DICT model, DistributeDataNodeManagerParams ddnmParams, SSY_PagingParam pager)
{
List <SSY_BIZ_DICT> listReturn = new List <SSY_BIZ_DICT>();
DataTable dt = this.comBize.GetBizDictPager(model, ddnmParams, pager);
if (Common.Utility.DtHasData(dt))
{
listReturn = Common.UtilitysForT <SSY_BIZ_DICT> .GetListsObj(dt);
}
return(listReturn);
}
/// <summary>
/// 获取用户
/// </summary>
/// <param name="bizobj"></param>
/// <param name="ddnmParams"></param>
/// <param name="pager"></param>
/// <returns></returns>
public List <SSY_USER_DICT> GetUserdict(SSY_USER_DICT bizobj, DistributeDataNodeManagerParams ddnmParams, SSY_PagingParam pager)
{
List <SSY_USER_DICT> listReturn = new List <SSY_USER_DICT>();
DataTable dt = this.comBize.GetUserdict(bizobj, ddnmParams, pager);
if (Common.Utility.DtHasData(dt))
{
listReturn = Common.UtilitysForT <SSY_USER_DICT> .GetListsObj(dt);
}
return(listReturn);
}
/// <summary>
/// 获取用户组(带分页)
/// </summary>
/// <param name="gd"></param>
/// <param name="distributeDataNodeManagerParams"></param>
/// <param name="pager"></param>
/// <returns></returns>
public List <SSY_GROUP_DICT> GetGroup(SSY_GROUP_DICT gd, DistributeDataNodeManagerParams distributeDataNodeManagerParams, SSY_PagingParam pager)
{
List <SSY_GROUP_DICT> listReturn = new List <SSY_GROUP_DICT>();
DataTable dt = this.comBize.GetGroup(gd, distributeDataNodeManagerParams, pager);
if (Common.Utility.DtHasData(dt))
{
listReturn = Common.UtilitysForT <SSY_GROUP_DICT> .GetListsObj(dt);
}
return(listReturn);
}
/// <summary>
/// 获取系统字典(某个字典的全部字典项)
/// </summary>
/// <param name="model"></param>
/// <param name="ddnmParams"></param>
/// <param name="pager"></param>
/// <returns></returns>
public override DataTable GetFrameDictPager(Xxx.Entities.SSY_FRAME_DICT model, DistributeDataNodeManagerParams ddnmParams, SSY_PagingParam pager)
{
//分页数据获取实现
//分页参数数据
SSY_PagingExecuteParam pageExecute = new SSY_PagingExecuteParam();
pageExecute.PagingParam = pager;
//参数值，若有，增加到该集合
List <IDataParameter> parameters = new List <IDataParameter>();
StringBuilder sbbSqlWhere = new StringBuilder();
if (model != null)
{
if (Utility.ObjHasData(model.DOMAINNAMEIDEN))
{
sbbSqlWhere.AppendLine(string.Format(@"and DOMAINNAMEIDEN = {0}DOMAINNAMEIDEN ",
DBFactorySingleton.GetInstance(ddnmParams.DistributeDataNode).Factory.ParamSign()));
parameters.Add(DBFactorySingleton.GetInstance(ddnmParams.DistributeDataNode).Factory.
GetDataParameter("DOMAINNAMEIDEN",
DbType.String, model.DOMAINNAMEIDEN.ToString()));
}
}
pageExecute.TableNameOrView = string.Format(@" {0}.SSY_FRAME_DICT ",
DBFactorySingleton.GetInstance(ddnmParams.DistributeDataNode).Factory.DbSchema);
pageExecute.Joins = string.Empty;
pageExecute.Fields = "*";
pageExecute.OrderField = "SSY_FRAME_DICTID";
pageExecute.SqlWhere = " 1=1 " + sbbSqlWhere.ToString();
StringBuilder sbbSql = new StringBuilder();
if (pager.TotalSize == 0)
{
//首次计算总记录
sbbSql.Clear();
if (string.IsNullOrEmpty(pageExecute.SqlWhere))
{
sbbSql.Append(string.Format(@"SELECT count(*) as cnt FROM {0} {1} ", pageExecute.TableNameOrView, pageExecute.Joins));
}
else
{
sbbSql.Append(string.Format(@"SELECT count(*) as cnt FROM {0} {1} where {2} ", pageExecute.TableNameOrView, pageExecute.Joins,
pageExecute.SqlWhere));
}
DataTable dt = DBFactorySingleton.GetInstance(ddnmParams.DistributeDataNode).Factory.GetDataTable(sbbSql.ToString(),
SqlExecType.SqlText, parameters.ToArray());
if (Utility.DtHasData(dt))
{
pager.TotalSize = int.Parse(dt.Rows[0]["cnt"].ToString());
}
}
return(DBFactorySingleton.GetInstance(ddnmParams.DistributeDataNode).Factory.GetDataPager(pageExecute, parameters.ToArray()));
}
