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;
}
