public static List <MD_GuideLineParameter> GetParametersFromMeta(string _metaStr) { List <MD_GuideLineParameter> _ret = new List <MD_GuideLineParameter>(); RegexOptions options = RegexOptions.None; Regex regeMeta = new Regex(@"<CS>[^<]{1,}</CS>", options); MatchCollection _mc = regeMeta.Matches(_metaStr); foreach (Match _m in _mc) { string _s2 = _m.Value.Substring(4, _m.Length - 9); string[] _s3 = _s2.Split(':'); if (_s3.Length > 2) { string _pname = _s3[0]; string _title = _s3[1]; string _retTable = ""; string _selectAllCode = ""; bool _incldeChildren = false; string _type = ParseParamType(_s3[2], ref _retTable, ref _incldeChildren, ref _selectAllCode); int _order = (_s3.Length > 3) ? int.Parse((_s3[3] == "") ? "0" : _s3[3]) : 0; int _inputWidth = (_s3.Length > 4) ? int.Parse((_s3[4] == "") ? "200" : _s3[4]) : 200; MD_GuideLineParameter _mgp = new MD_GuideLineParameter(_pname, _title, _type, _order, _inputWidth, _retTable, _incldeChildren, _selectAllCode); _ret.Add(_mgp); } } _ret.Sort((p1, p2) => { return(p1.DisplayOrder.CompareTo(p2.DisplayOrder)); }); return(_ret); }
public SinoSZUC_GLQ_InputItem(MD_GuideLineParameter _mdParameter) { InitializeComponent(); paramDefine = _mdParameter; InitControls(); InitFinished = true; }
public SinoSZUC_GLQ_InputOrg(MD_GuideLineParameter _mdParameter, string _type) { InitializeComponent(); paramDefine = _mdParameter; InputType = _type; InitControls(); InitFinished = true; }
/// <summary> /// 分页取指标结果集 /// </summary> /// <param name="guideLineId"></param> /// <param name="param"></param> /// <param name="filterWord"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="sortBy"></param> /// <param name="sortDirection"></param> /// <returns></returns> public async static Task <IPagedList <DataTable> > QueryGuideline(string guideLineId, Dictionary <string, object> param, string filterWord, int pageIndex, int pageSize, string sortBy, string sortDirection) { int getQueryStartTime = Environment.TickCount; int recordCount = 0; DataTable tb = new DataTable("ResultTable"); MD_GuideLine define = await GetGuidelineDefine(guideLineId); if (define != null) { string queryStr = await GetGuidelineMethod(guideLineId); List <MDQuery_GuideLineParameter> glPara = new List <MDQuery_GuideLineParameter>(); if (param != null && define.Parameters != null) { foreach (var p in param) { MD_GuideLineParameter md_pa = define.Parameters.Find(pa => pa.ParameterName == p.Key); if (md_pa != null) { glPara.Add(new MDQuery_GuideLineParameter(md_pa, p.Value)); } } } foreach (MDQuery_GuideLineParameter gp in glPara) { queryStr = MySqlQueryBuilder.RebuildGuideLineQueryString(queryStr, gp); } if (!string.IsNullOrEmpty(filterWord)) { queryStr = string.Format("select * from (\n {0} \n) where {1}", queryStr, filterWord); } try { var cot = await MysqlDBHelper.ExecuteScalar(MysqlDBHelper.queryString, CommandType.Text, string.Format("select count(*) from (\n {0} \n) as t ", queryStr)); recordCount = Convert.ToInt32(cot); } catch (Exception e) { MysqlLogWriter.WriteSystemLog("Exception :QueryGuideline310行异常,异常信息为" + e.Message, "ERROR"); } queryStr = StrUtils.BuildPagingSQL22(queryStr, pageIndex, pageSize, sortBy, sortDirection); tb = await FillResultData(queryStr, "ResultTable"); MysqlLogWriter.WriteQueryLog(queryStr, Environment.TickCount - getQueryStartTime, "2"); } var list = new List <DataTable>(); list.Add(tb); var ret = new StaticPagedList <DataTable>(list, pageIndex, pageSize, recordCount); return(ret); }
private static string CreateReTableType(MD_GuideLineParameter _param) { if (_param.ParameterType == "代码表") { return(string.Format("代码表[{0},{1},{2}]", _param.RefTableName, (_param.IncludeChildren) ? 1 : 0, _param.SelectAllCode)); } else { return(_param.ParameterType); } }
public MDQuery_GuideLineParameter(MD_GuideLineParameter _pDefine, object data) { Paramter = _pDefine; Data = data; this.ParameterName = _pDefine.ParameterName; this.DisplayTitle = _pDefine.DisplayTitle; this.ParameterType = _pDefine.ParameterType; this.ParameterValue = data; this.RefTableName = _pDefine.RefTableName; this.IncludeChildren = _pDefine.IncludeChildren; this.SelectAllCode = _pDefine.SelectAllCode; }
private void AddParameter() { this.gridParameter.BeginUpdate(); MD_GuideLineParameter _gp = new MD_GuideLineParameter(); _gp.ParameterName = "param"; IList <MD_GuideLineParameter> _pList = this.gridParameter.DataSource as IList <MD_GuideLineParameter>; _pList.Add(_gp); this.gridParameter.EndUpdate(); this._haveChange = true; RaiseDataChanged(); }
private void repositoryItemButtonEdit2_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { this.gridView2.PostEditor(); int _index = this.gridView2.FocusedRowHandle; if (_index >= 0) { MD_GuideLineParameter _gd = this.gridView2.GetRow(_index) as MD_GuideLineParameter; Dialog_EditGuideLineRefTable _f = new Dialog_EditGuideLineRefTable(_gd); if (_f.ShowDialog() == DialogResult.OK) { this.gridView2.BeginUpdate(); _gd.RefTableName = _f.RefTableName; _gd.IncludeChildren = _f.IncludeChildren; _gd.SelectAllCode = _f.SelectAllCode; this.gridView2.EndUpdate(); this._haveChange = true; RaiseDataChanged(); } } }
public async static Task <DataTable> QueryGuideline(string guideLineId, Dictionary <string, object> param, string filterWord) { int getQueryStartTime = Environment.TickCount; DataTable tb = new DataTable("ResultTable"); MD_GuideLine define = await GetGuidelineDefine(guideLineId); if (define != null) { string queryStr = await GetGuidelineMethod(guideLineId); List <MDQuery_GuideLineParameter> glPara = new List <MDQuery_GuideLineParameter>(); if (param != null && define.Parameters != null) { foreach (var p in param) { MD_GuideLineParameter md_pa = define.Parameters.Find(pa => pa.ParameterName == p.Key); if (md_pa != null) { glPara.Add(new MDQuery_GuideLineParameter(md_pa, p.Value)); } } } foreach (MDQuery_GuideLineParameter gp in glPara) { queryStr = MySqlQueryBuilder.RebuildGuideLineQueryString(queryStr, gp); } if (!string.IsNullOrEmpty(filterWord)) { queryStr = string.Format("select * from (\n {0} \n) where {1}", queryStr, filterWord); } tb = await FillResultData(queryStr, "ResultTable"); MysqlLogWriter.WriteQueryLog(queryStr, Environment.TickCount - getQueryStartTime, "2"); } return(tb); }
public SinoSZUC_GLQ_InputRefTable(MD_GuideLineParameter _mdParameter) : base(_mdParameter) { }
public Dialog_EditGuideLineRefTable(MD_GuideLineParameter _p) { InitializeComponent(); _parameterDefine = _p; InitForm(); }
public SinoSZUC_GLQ_InputOrg(MD_GuideLineParameter _mdParameter) : base(_mdParameter) { }
public SinoSZUC_GLQD_InputDate(MD_GuideLineParameter _mdParameter) : base(_mdParameter) { }
public MDQuery_GuideLineParameter(MD_GuideLineParameter _pDefine, object data) { _paramDefine = _pDefine; _data = data; }