public static bool SaveView2App(string V2AID, MD_View2App View2AppData)
{
using (SqlConnection cn = SqlHelper.OpenConnection())
{
SqlTransaction _txn = cn.BeginTransaction();
try
{
SqlCommand _cmd = new SqlCommand(SQL_CMD_DelView2App, cn);
_cmd.Parameters.Add("@ID", decimal.Parse(V2AID));
_cmd.ExecuteNonQuery();
SqlCommand _ins = new SqlCommand(SQL_SaveView2App_Insert, cn);
_ins.Parameters.Add("@ID", decimal.Parse(V2AID));
_ins.Parameters.Add("@VIEWID", decimal.Parse(View2AppData.ViewID));
_ins.Parameters.Add("@TITLE", View2AppData.Title);
_ins.Parameters.Add("@INTEGRATEDAPP", View2AppData.AppName);
_ins.Parameters.Add("@DISPLAYHEIGHT", Convert.ToDecimal(View2AppData.DisplayHeight));
_ins.Parameters.Add("@URL", View2AppData.RegURL);
_ins.Parameters.Add("@DISPLAYORDER", Convert.ToDecimal(View2AppData.DisplayOrder));
_ins.Parameters.Add("@META", View2AppData.Meta);
_ins.ExecuteNonQuery();
_txn.Commit();
return(true);
}
catch (Exception e)
{
string _err = string.Format("在保存查询模型的集成应用展示定义时发生错误，错误信息：{0}", e.Message);
LogWriter.WriteSystemLog(_err, "ERROR");
return(false);
}
}
}
public void InitData(MD_View2App _data)
{
CurrentData = _data;
this.TE_DISPLAY.EditValue = _data.Title;
this.te_AppName.EditValue = _data.AppName;
this.te_DisplayHeight.EditValue = _data.DisplayHeight;
this.te_DisplayOrder.EditValue = _data.DisplayOrder;
this.te_Meta.EditValue = _data.Meta;
this.te_URL.EditValue = _data.RegURL;
_initFinished = true;
}
public bool SaveView2App(string V2AID, MD_View2App View2AppData)
{
try
{
OraMetaDataFactroy _of = new OraMetaDataFactroy();
return(_of.SaveView2App(V2AID, View2AppData));
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
private void SaveData()
{
using (MetaDataServiceClient _mdc = new MetaDataServiceClient())
{
MD_View2App _newData = this.GetData();
if (_mdc.SaveView2App(_newData.ID, _newData))
{
XtraMessageBox.Show("保存成功！", "系统提示", MessageBoxButtons.OK);
this._haveChange = false;
RaiseDataChanged();
}
else
{
XtraMessageBox.Show("保存失败！", "系统提示", MessageBoxButtons.OK);
}
}
}
private void ChangeView2AppID(MD_View2App _v2a, MD_QueryModel _qv, MetaDataServiceClient _mdc)
{
if (_v2a == null)
{
return;
}
_v2a.ViewID = _qv.QueryModelID;
string _newid = GetNewID(_v2a.ID, "MD_VIEW2APPLICATION", "ID", _mdc);
try
{
IDTable.Add(_v2a.ID, _newid);
}
catch (Exception e)
{
throw e;
}
_v2a.ID = _newid;
}
public static List <MD_View2App> GetView2ApplicationList(string QueryModelID)
{
List <MD_View2App> _ret = new List <MD_View2App>();
using (SqlConnection cn = SqlHelper.OpenConnection())
{
try
{
SqlCommand _cmd = new SqlCommand(SQL_GetView2ApplicationList, cn);
_cmd.Parameters.Add("@VIEWID", decimal.Parse(QueryModelID));
using (SqlDataReader _dr = _cmd.ExecuteReader())
{
while (_dr.Read())
{
MD_View2App _app = new MD_View2App();
_app.ID = _dr.IsDBNull(0) ? "" : _dr.GetString(0);
_app.ViewID = _dr.IsDBNull(1) ? "" : _dr.GetString(1);
_app.Title = _dr.IsDBNull(2) ? "" : _dr.GetString(2);
_app.AppName = _dr.IsDBNull(3) ? "" : _dr.GetString(3);
_app.DisplayHeight = _dr.IsDBNull(4) ? 40 : Convert.ToInt32(_dr.GetDouble(4));
_app.RegURL = _dr.IsDBNull(5) ? "" : _dr.GetString(5);
_app.DisplayOrder = _dr.IsDBNull(6) ? 40 : Convert.ToInt32(_dr.GetDouble(6));
_app.Meta = _dr.IsDBNull(7) ? "" : _dr.GetString(7);
_ret.Add(_app);
}
}
}
catch (Exception e)
{
string _err = string.Format("在获取查询模型的集成应用展示定义时发生错误，错误信息：{0}", e.Message);
LogWriter.WriteSystemLog(_err, "ERROR");
}
}
return(_ret);
}
public async Task <bool> SaveView2App(string v2AID, MD_View2App view2AppData)
{
var ret = await this.mdService.SaveView2App(v2AID, view2AppData);
return(ret);
}
public SinoUC_QME_View2APP(MD_View2App _data)
{
InitializeComponent();
InitData(_data);
}
public Dialog_AddView2App(MD_View2App _data)
{
InitializeComponent();
this.sinoUC_QME_View2APP1.InitData(_data);
}
