public static List <MD_View2View> GetView2ViewList(string GroupID, string ViewID)
{
List <MD_View2View> _ret = new List <MD_View2View>();
using (SqlConnection cn = SqlHelper.OpenConnection())
{
try
{
SqlCommand _cmd = new SqlCommand(SQL_GetView2ViewList, cn);
_cmd.Parameters.Add("@VIEWID", decimal.Parse(ViewID));
_cmd.Parameters.Add("@GROUPID", GroupID);
using (SqlDataReader _dr = _cmd.ExecuteReader())
{
while (_dr.Read())
{
MD_View2View _g = new MD_View2View();
_g.ID = _dr.IsDBNull(0) ? "" : _dr.GetString(0);
_g.TargetViewName = _dr.IsDBNull(2) ? "" : _dr.GetString(2);
_g.RelationString = _dr.IsDBNull(3) ? "" : _dr.GetString(3);
_g.DisplayOrder = _dr.IsDBNull(4) ? 0 : Convert.ToInt32(_dr.GetDouble(4));
_g.DisplayTitle = _dr.IsDBNull(5) ? "" : _dr.GetString(5);
_ret.Add(_g);
}
}
}
catch (Exception e)
{
LogWriter.WriteSystemLog(string.Format("在取查询模型{0}相关联模型分组信息时发生错误，错误信息：{1} ", ViewID, e.Message), "ERROR");
return(null);
}
}
return(_ret);
}
public async Task <bool> SaveView2View(MD_View2View view2View)
{
var ret = await this.mdService.SaveView2View(view2View);
MyDA_MetaDataQuery.QueryModelCache.Clear();
return(ret);
}
public bool SaveView2View(MD_View2View View2View)
{
try
{
return(MetaDataFactroy.SaveView2View(View2View));
}
catch (Exception e)
{
return(false);
}
}
public bool SaveView2View(MD_View2View View2View)
{
try
{
OraMetaDataFactroy _of = new OraMetaDataFactroy();
return(_of.SaveView2View(View2View));
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
private void ChangeView2ViewID(MD_View2View _v2v, MD_View2ViewGroup _group, MetaDataServiceClient _mdc)
{
if (_v2v == null)
{
return;
}
_v2v.QueryModelID = _group.QueryModelID;
string _newid = GetNewID(_v2v.ID, "MD_VIEW2VIEW", "ID", _mdc);
try
{
IDTable.Add(_v2v.ID, _newid);
}
catch (Exception e)
{
throw e;
}
_v2v.ID = _newid;
}
public static bool SaveView2View(MD_View2View View2View)
{
using (SqlConnection cn = SqlHelper.OpenConnection())
{
try
{
SqlCommand _cmd = new SqlCommand(SQL_SaveView2View, cn);
_cmd.Parameters.Add("@VIEWNAME", View2View.TargetViewName);
_cmd.Parameters.Add("@STR", View2View.RelationString);
_cmd.Parameters.Add("@DISPORDER", Convert.ToDecimal(View2View.DisplayOrder));
_cmd.Parameters.Add("@TITLE", View2View.DisplayTitle);
_cmd.Parameters.Add("@ID", View2View.ID);
_cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
string _msg = string.Format("在保存关联的模型信息{0}时发生错误，错误信息：{1} ", View2View.ID, e.Message);
LogWriter.WriteSystemLog(_msg, "ERROR");
return(false);
}
}
}
public View2ViewInfo(MD_View2View _data)
{
InitializeComponent();
this.Data = _data;
RefreshData();
}
