/// <summary> /// 获取全部业务字典 /// </summary> /// <param name="req"></param> /// <returns></returns> public string GetBizDictAll(string req) { try { reqdata = this.AnaRequestData(req); Xxx.Entities.SSY_BIZ_DICT model = json.Deserialize <Xxx.Entities.SSY_BIZ_DICT>(reqdata.reqdata); List <Xxx.Entities.SSY_BIZ_DICT> objResult = this._comSomebiz.GetBizDictAll(model, base.envirObj.distManagerParam); if (UtilitysForT <Xxx.Entities.SSY_BIZ_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 GetBizDictAll(Xxx.Entities.SSY_BIZ_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_BIZ_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 GetBizDictPager(Xxx.Entities.SSY_BIZ_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_BIZ_DICT ", DBFactorySingleton.GetInstance(ddnmParams.DistributeDataNode).Factory.DbSchema); pageExecute.Joins = string.Empty; pageExecute.Fields = "*"; pageExecute.OrderField = "SSY_BIZ_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> /// <returns></returns> public List <Xxx.Entities.SSY_BIZ_DICT> GetBizDictAll(Xxx.Entities.SSY_BIZ_DICT model, DistributeDataNodeManagerParams ddnmParams) { List <Xxx.Entities.SSY_BIZ_DICT> listReturn = new List <Xxx.Entities.SSY_BIZ_DICT>(); DataTable dt = this.comSomebiz.GetBizDictAll(model, ddnmParams); if (Common.Utility.DtHasData(dt)) { listReturn = Common.UtilitysForT <Xxx.Entities.SSY_BIZ_DICT> .GetListsObj(dt); } return(listReturn); }
/// <summary> /// 获取系统字典(某个字典的全部字典项) /// </summary> /// <param name="req"></param> /// <returns></returns> public string GetBizDictPager(string req) { try { reqdata = this.AnaRequestData(req); QueryItemCollection[] objs = json.Deserialize <QueryItemCollection[]>(reqdata.reqdata); SSY_PagingParam pager = null; Xxx.Entities.SSY_BIZ_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_BIZ_DICT".ToUpper()) { model = json.Deserialize <Xxx.Entities.SSY_BIZ_DICT>(objs[i].queryItemValue); } } List <Xxx.Entities.SSY_BIZ_DICT> objResult = this._comSomebiz.GetBizDictPager(model, base.envirObj.distManagerParam, pager); if (UtilitysForT <Xxx.Entities.SSY_BIZ_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> /// <returns></returns> public abstract DataTable GetBizDictAll(Xxx.Entities.SSY_BIZ_DICT model, DistributeDataNodeManagerParams ddnmParams);