/// <summary> /// 保存过滤方案 /// </summary> /// <param name="operType">操作类型</param> /// <param name="TabName">表名称</param> /// <param name="ParentID">父方案ID</param> /// <param name="SltType">过滤方案类型</param> /// <param name="KeyWords">查询关键字</param> private void AddFltSlt(OperType operType, string ParentID, string SltType, string KeyWords, List <DTSerializer <string, object> > List_DTObj) { try { //获取当前最大的方案ID string MaxSltID = ComClient.GetMaxSltID(FrmNam, SltType, ParentID); DTSerializer <string, object> DTObj1 = new DTSerializer <string, object>(); List <DTSerializer <string, object> > List_DTObj1 = new List <DTSerializer <string, object> >(); DTObj1.Add("FSltID", MaxSltID); DTObj1.Add("FSltName", Txt_SltName.Text.Trim()); DTObj1.Add("FParentID", ParentID); DTObj1.Add("FUsrID", CurUsrID); DTObj1.Add("FFrmName", FrmNam); DTObj1.Add("FSltType", SltType); List_DTObj1.Add(DTObj1); //开始SQL事务 ComClient.BeginTransaction(); ComClient.SaveFltSlt1(operType, Serializer.SerializeDTToXml <List <DTSerializer <string, object> > >(List_DTObj1), "t_ADMM_FltSltList", KeyWords); //向查询方案明细中追加方案ID和方案类型 foreach (DTSerializer <string, object> DTObj2 in List_DTObj) { DTObj2.Add("FSltID", MaxSltID); DTObj2.Add("FSltType", SltType); } //增加/修改/删除过滤方案明细 ComClient.SaveFltSlt1(operType, Serializer.SerializeDTToXml <List <DTSerializer <string, object> > >(List_DTObj), "t_ADMM_FltSltforDtl", KeyWords); //提交事务 ComClient.CommitTransaction(); } catch (Exception Ex) { Common.ShowMsg(Ex.Message); } }