/// <summary>
/// 获取全部系统字典
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public string GetFrameDictAll(string req)
{
try
{
reqdata = this.AnaRequestData(req);
Xxx.Entities.SSY_FRAME_DICT model = json.Deserialize <Xxx.Entities.SSY_FRAME_DICT>(reqdata.reqdata);
List <Xxx.Entities.SSY_FRAME_DICT> objResult = this._comSomebiz.GetFrameDictAll(model, base.envirObj.distManagerParam);
if (UtilitysForT <Xxx.Entities.SSY_FRAME_DICT> .ListHasData(objResult))
{
resdata = this.MakeResponseData("1", string.Empty, json.Serialize(objResult), string.Empty);
}
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>
/// <returns></returns>
public override DataTable GetFrameDictAll(Xxx.Entities.SSY_FRAME_DICT model, DistributeDataNodeManagerParams ddnmParams)
{
DataSet ds = null;
StringBuilder sbb = new StringBuilder();
try
{
sbb.AppendLine(string.Format(@" select DOMAINNAMEIDEN, DOMAINNAMES, sum(1) dicts FROM {0}.SSY_FRAME_DICT group by DOMAINNAMEIDEN, DOMAINNAMES",
DBFactorySingleton.GetInstance(ddnmParams.DistributeDataNode).Factory.DbSchema));
ds = DBFactorySingleton.GetInstance(ddnmParams.DistributeDataNode).Factory.GetDataSet(sbb.ToString(), SqlExecType.SqlText, null);
}
catch (Exception ex)
{
return(null);
}
if (Common.Utility.DsHasData(ds))
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}
/// <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()));
}
/// <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="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> /// <returns></returns> public abstract DataTable GetFrameDictAll(Xxx.Entities.SSY_FRAME_DICT model, DistributeDataNodeManagerParams ddnmParams);
/// <summary> /// 获取系统字典(某个字典的全部字典项) /// </summary> /// <param name="model"></param> /// <param name="ddnmParams"></param> /// <param name="pager"></param> /// <returns></returns> public abstract DataTable GetFrameDictPager(Xxx.Entities.SSY_FRAME_DICT model, DistributeDataNodeManagerParams ddnmParams, SSY_PagingParam pager);
