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