public static bool SaveInputModelChildDefine(MD_InputModel_Child InputModelChild)
{
string _sql = "update md_inputviewchild set param=@PARAM ,displayorder=@DISPLAYORDER,SHOWCONDITION=@SHOWCONDITION,SELECTMODE=@SELECTMODE where ID=@ID";
string _pstr = "";
foreach (MD_InputModel_ChildParam _p in InputModelChild.Parameters)
{
_pstr += string.Format("<PARAM>{0}:{1}:{2}</PARAM>", _p.Name, _p.DataType, _p.Value);
}
using (SqlConnection cn = SqlHelper.OpenConnection())
{
try
{
SqlCommand _cmd = new SqlCommand(_sql, cn);
_cmd.Parameters.Add("@PARAM", _pstr);
_cmd.Parameters.Add("@DISPLAYORDER", Convert.ToDecimal(InputModelChild.DisplayOrder));
_cmd.Parameters.Add("@SHOWCONDITION", InputModelChild.ShowCondition);
_cmd.Parameters.Add("@SELECTMODE", Convert.ToDecimal(InputModelChild.SelectMode));
_cmd.Parameters.Add("@ID", decimal.Parse(InputModelChild.ID));
_cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
private void ShowInputModelChild(MD_InputModel_Child _InputModelChild)
{
UC_InputModel_Child _uc = new UC_InputModel_Child(_InputModelChild);
_uc.Dock = DockStyle.Fill;
_uc.MenuChanged += new EventHandler <EventArgs>(_uc_MenuChanged);
this.splitContainerControl1.Panel2.Controls.Add(_uc);
CurrentControl = _uc as IMenuControl;
}
public bool SaveInputModelChildDefine(MD_InputModel_Child InputModelChild)
{
try
{
OraMetaDataFactroy _of = new OraMetaDataFactroy();
return(_of.SaveInputModelChildDefine(InputModelChild));
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
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));
}
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());
}
private void bt_DelChild_ItemClick(object sender, ItemClickEventArgs e)
{
object _selectedObj = FocusedItem;
if (_selectedObj is MD_InputModel_Child)
{
MD_InputModel_Child _child = _selectedObj as MD_InputModel_Child;
if (DAConfig.DataAccess.DelInputModelChild(_child.ID))
{
TreeListNode _node = this.treeList1.FocusedNode;
this.treeList1.MoveNext();
this.treeList1.DeleteNode(_node);
}
else
{
XtraMessageBox.Show("删除子模型失败！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void WriteGridChildData(MD_InputModel_Child _child, object ChildData, SqlConnection cn)
{
DataTable _srcData = ChildData as DataTable;
if (_srcData == null)
{
return;
}
DataTable _newData = _srcData.GetChanges(DataRowState.Added);
DataTable _modifyData = _srcData.GetChanges(DataRowState.Modified);
DataTable _delData = _srcData.GetChanges(DataRowState.Deleted);
if (_newData != null || _modifyData != null)
{
foreach (MD_InputModel_SaveTable _table in _child.ChildModel.WriteTableNames)
{
string _sql = string.Format("select * from {0} ", _table.TableName);
SqlDataAdapter adapter = new SqlDataAdapter(_sql, cn);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
if (_newData != null && _newData.Rows.Count > 0)
{
SqlHelper.UpdateData(cn, _sql, _newData.GetChanges());
}
if (_modifyData != null && _modifyData.Rows.Count > 0)
{
SqlHelper.UpdateData(cn, _sql, _modifyData.GetChanges());
}
}
}
if (_delData != null && _delData.Rows.Count > 0)
{
for (int i = _child.ChildModel.WriteTableNames.Count; i > 0; i--)
{
MD_InputModel_SaveTable _table = _child.ChildModel.WriteTableNames[i - 1];
string _sql = string.Format("select * from {0} ", _table.TableName);
SqlHelper.UpdateData(cn, _sql, _delData.GetChanges());
}
}
}
public static List <MD_InputModel_Child> GetChildInputModel(MD_InputModel _model)
{
List <MD_InputModel_Child> _ret = new List <MD_InputModel_Child>();
using (SqlConnection cn = SqlHelper.OpenConnection())
{
SqlCommand _cmd = new SqlCommand(SQL_GetChildInputModel, cn);
_cmd.Parameters.Add("@IVID", _model.ID);
SqlDataReader _dr = _cmd.ExecuteReader();
while (_dr.Read())
{
string _cns = _dr.IsDBNull(4) ? "" : _dr.GetString(4);
string _cname = _dr.IsDBNull(5) ? "" : _dr.GetString(5);
string _paramstring = _dr.IsDBNull(3) ? "" : _dr.GetString(3);
MD_InputModel_Child _child = new MD_InputModel_Child(
_dr.IsDBNull(0) ? "" : _dr.GetDecimal(0).ToString(),
string.Format("{0}.{1}", _model.NameSpace, _model.ModelName),
string.Format("{0}.{1}", _cns, _cname),
_dr.IsDBNull(6) ? 0 : Convert.ToInt32(_dr.GetDecimal(6))
);
_child.ShowCondition = _dr.IsDBNull(7) ? "" : _dr.GetString(7);
_child.SelectMode = _dr.IsDBNull(8) ? 0 : Convert.ToInt16(_dr.GetDecimal(8));
_child.ChildModel = GetInputModel(_cns, _cname);
if (_child.Parameters == null)
{
_child.Parameters = new List <MD_InputModel_ChildParam>();
}
foreach (string _pstr in StrUtils.GetMetasByName2("PARAM", _paramstring))
{
string[] _s = _pstr.Split(':');
MD_InputModel_ChildParam _p = new MD_InputModel_ChildParam(_s[0], _s[1], _s[2]);
_child.Parameters.Add(_p);
}
_ret.Add(_child);
}
_dr.Close();
}
return(_ret);
}
public bool SaveInputModelChildDefine(MD_InputModel_Child InputModelChild)
{
return(MetaDataFactroy.SaveInputModelChildDefine(InputModelChild));
}
public UC_InputModel_Child(MD_InputModel_Child _InputModelChild)
{
InitializeComponent();
inputModelChild = _InputModelChild;
InitForm();
}
private MD_InputEntity GetChildFormData(MD_InputModel_Child _child, MD_InputEntity entity)
{
return(new MD_InputEntity());
}
