public Dictionary <string, string> GetNewChildRecord(MD_InputModel_Child _child, MD_InputEntity entity)
{
List <MDQuery_GuideLineParameter> _callParam = new List <MDQuery_GuideLineParameter>();
foreach (MD_InputModel_ChildParam _p in _child.Parameters)
{
string _pValue = ConvetDataByMainEntityData(_p.Value, entity);
MDQuery_GuideLineParameter _cp = new MDQuery_GuideLineParameter(new MD_GuideLineParameter(_p.Name, "", _p.DataType, 0, 0, "", false, ""), _pValue);
_callParam.Add(_cp);
}
DataTable _dt = QueryFactory.QueryGuideLine(_child.ChildModel.GetNewRecordGuideLine, _callParam);
return(GetInputDataByDataTable(_dt));
}
/// <summary>
/// 以指标方式显示详细信息
/// </summary>
/// <param name="_df"></param>
/// <param name="_dr"></param>
private void ShowDetailByGuideLine(MD_GuideLineDetailDefine _df, DataRow _dr)
{
MDQuery_GuideLineParameter _param;
List <MD_GuideLine> _gls;
string _guideLineID = _df.DetailMethodID;
using (MetaDataQueryServiceClient _msc = new MetaDataQueryServiceClient())
{
_gls = _msc.GetRootGuideLineList(_guideLineID).ToList <MD_GuideLine>();
}
//取链接明细参数定义
List <MD_GuideLineDetailParameter> _detailParamList = MC_GuideLine.GetGuideLineDetailParam(_df.DetailParameterMeta);
Dictionary <string, string> _detailParamDict = new Dictionary <string, string>();
foreach (MD_GuideLineDetailParameter _dparam in _detailParamList)
{
_detailParamDict.Add(_dparam.Name, _dparam.DataValue);
}
if (_gls.Count > 0)
{
//取指标
MD_GuideLine _guideLine = _gls[0];
//建立查询参数
List <MDQuery_GuideLineParameter> _queryParams = new List <MDQuery_GuideLineParameter>();
//建立指标参数字典
List <MD_GuideLineParameter> _gParam = MC_GuideLine.GetParametersFromMeta(_guideLine.GuideLineMeta);
foreach (MD_GuideLineParameter _p in _gParam)
{
if (_detailParamDict.ContainsKey(_p.ParameterName))
{
string _dataDefine = _detailParamDict[_p.ParameterName];
string _data = ReplaceVerByRowData(_dr, _dataDefine);
_param = new MDQuery_GuideLineParameter(_p, _data);
_queryParams.Add(_param);
}
else
{
XtraMessageBox.Show("缺少参数定义！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
RaiseShowDetailDatal(new ShowDetailDataArgs(_guideLine, _queryParams));
}
}
private string GetChildGridData(MD_InputModel_Child _child, MD_InputEntity entity)
{
List <MD_InputEntity> _ret = new List <MD_InputEntity>();
List <MDQuery_GuideLineParameter> _callParam = new List <MDQuery_GuideLineParameter>();
foreach (MD_InputModel_ChildParam _p in _child.Parameters)
{
string _pValue = ConvetDataByMainEntityData(_p.Value, entity);
MDQuery_GuideLineParameter _cp = new MDQuery_GuideLineParameter(new MD_GuideLineParameter(_p.Name, "", _p.DataType, 0, 0, "", false, ""), _pValue);
_callParam.Add(_cp);
}
DataTable _dt = QueryFactory.QueryGuideLine(_child.ChildModel.GetDataGuideLine, _callParam);
return(_dt.DataTableToXml());
}
public override MDQuery_GuideLineParameter GetParameter()
{
MDQuery_GuideLineParameter _ret = new MDQuery_GuideLineParameter(paramDefine, this._uc.Code);
return(_ret);
}
virtual public MDQuery_GuideLineParameter GetParameter()
{
MDQuery_GuideLineParameter _ret = new MDQuery_GuideLineParameter(paramDefine, this.te_Value.EditValue);
return(_ret);
}
public static string RebuildGuideLineQueryString(string _queryStr, MDQuery_GuideLineParameter _gp)
{
string _ret = _queryStr;
switch (_gp.ParameterType)
{
case "数值型":
string _s3 = string.Format(" {0}", _gp.ParameterValue == null ? "" : _gp.ParameterValue);
return(_queryStr.Replace(_gp.ParameterName, _s3));
case "代码表":
string _refStr = "";
string[] _rtNames = _gp.RefTableName.Split('.');
if (_gp.ParameterName == "strYN")
{
_refStr = string.Format("1 = {0}", _gp.ParameterValue);
}
else
{
string _tName = (_rtNames.Length > 1) ? _rtNames[1] : _rtNames[0];
if (_gp.IncludeChildren)
{
//对于树型代码表
if (_gp.ParameterValue.ToString() == _gp.SelectAllCode)
{
_refStr = string.Format(" ('{0}') ", _gp.ParameterValue);
}
else
{
_refStr = string.Format(" (select TO_CHAR(dm) from jsods.{1} start with dm='{0}' connect by prior DM=FATHERCODE) ",
_gp.ParameterValue, _tName);
}
}
else
{
//对于非树型代码表
_refStr = string.Format(" '{0}' ", _gp.ParameterValue);
}
}
return(_queryStr.Replace(_gp.ParameterName, _refStr));
case "日期型":
string _s1 = DateTime.MaxValue.ToString("yyyy-MM-dd");
if (_gp.ParameterValue.GetType() == typeof(DateTime))
{
_s1 = ((DateTime)_gp.ParameterValue).ToString("yyyy-MM-dd HH:mm:ss");
}
else if (_gp.ParameterValue.GetType() == typeof(string))
{
_s1 = StrUtils.String2Date(_gp.ParameterValue.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
if (_s1.Length == 10)
{
_s1 = string.Format(" to_date('{0}','YYYY-MM-DD') ", _s1);
}
if (_s1.Length == 19)
{
_s1 = string.Format("to_date('{0}','YYYY-MM-DD HH24:MI:SS') ", _s1);
}
return(_queryStr.Replace(_gp.ParameterName, _s1));
case "逻辑型":
return(_queryStr = _queryStr + " and " + _gp.ParameterName + " like " + "'%" + _gp.ParameterValue + "%'");
default:
string _s2 = string.Format(" '{0}'", _gp.ParameterValue.ToString());
return(_queryStr.Replace(_gp.ParameterName, _s2));
}
}
public static string RebuildGuideLineQueryString(string _queryStr, MDQuery_GuideLineParameter _gp)
{
string _ret = _queryStr;
switch (_gp.Paramter.ParameterType)
{
case "数值型":
string _s3 = string.Format(" {0}", _gp.Data.ToString());
return(_queryStr.Replace(_gp.Paramter.ParameterName, _s3));
case "代码表":
string _refStr = "";
string[] _rtNames = _gp.Paramter.RefTableName.Split('.');
if (_gp.Paramter.ParameterName == "strYN")
{
_refStr = string.Format("1 = {0}", _gp.Data);
}
else
{
string _tName = (_rtNames.Length > 1) ? _rtNames[1] : _rtNames[0];
if (_gp.Paramter.IncludeChildren)
{
//对于树型代码表
if (_gp.Data.ToString() == _gp.Paramter.SelectAllCode)
{
_refStr = string.Format(" ('{0}') ", _gp.Data);
}
else
{
return(string.Format("(select dm from dm_reftabledata where `type`='{0}' and FIND_IN_SET('{1}',allfathercode) )",
_tName, _gp.Data));
}
}
else
{
//对于非树型代码表
_refStr = string.Format(" '{0}' ", _gp.Data);
}
}
return(_queryStr.Replace(_gp.Paramter.ParameterName, _refStr));
case "日期型":
string _s1 = _gp.Data.ToString();
if (_s1.Length == 10)
{
_s1 = string.Format(" STR_TO_DATE('{0}','%Y-%m-%d') ", _s1);
}
if (_s1.Length == 19)
{
_s1 = string.Format("STR_TO_DATE('{0}','%Y-%m-%d %H:%i:%s') ", _s1);
}
return(_queryStr.Replace(_gp.Paramter.ParameterName, _s1));
default:
string _s2 = string.Format(" '{0}'", _gp.Data.ToString());
return(_queryStr.Replace(_gp.Paramter.ParameterName, _s2));
}
return(_ret);
}
public static string RebuildGuideLineQueryString(string _queryStr, MDQuery_GuideLineParameter _gp)
{
string _ret = _queryStr;
switch (_gp.Paramter.ParameterType)
{
case "数值型":
string _s3 = string.Format(" {0}", _gp.Data.ToString());
return(_queryStr.Replace(_gp.Paramter.ParameterName, _s3));
case "代码表":
string _refStr = "";
string[] _rtNames = _gp.Paramter.RefTableName.Split('.');
if (_gp.Paramter.ParameterName == "strYN")
{
_refStr = string.Format("1 = {0}", _gp.Data);
}
else
{
string _tName = (_rtNames.Length > 1) ? _rtNames[1] : _rtNames[0];
if (_gp.Paramter.IncludeChildren)
{
//对于树型代码表
if (_gp.Data.ToString() == _gp.Paramter.SelectAllCode)
{
_refStr = string.Format(" ('{0}') ", _gp.Data);
}
else
{
_refStr = string.Format("(select TO_CHAR(dm) from jsods.{1} start with dm='{0}' connect by prior DM=FATHERCODE)",
_gp.Data, _tName);
}
}
else
{
//对于非树型代码表
_refStr = string.Format(" '{0}' ", _gp.Data);
}
}
return(_queryStr.Replace(_gp.Paramter.ParameterName, _refStr));
case "日期型":
string _s1 = _gp.Data.ToString();
if (_s1.Length == 10)
{
_s1 = string.Format(" to_date('{0}','YYYY-MM-DD') ", _s1);
}
if (_s1.Length == 19)
{
_s1 = string.Format("to_date('{0}','YYYY-MM-DD HH24:MI:SS') ", _s1);
}
return(_queryStr.Replace(_gp.Paramter.ParameterName, _s1));
default:
string _s2 = string.Format(" '{0}'", _gp.Data.ToString());
return(_queryStr.Replace(_gp.Paramter.ParameterName, _s2));
}
return(_ret);
}
