过滤方案

yusijie

2024-01-16 8df5325c7dce674563d10e3e73b90b7cabb63184

 DAL/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/ClsXt_FastICScheme_Ctl.cs

@@ -26,37 +26,59 @@
        #region å›ºå®šä»£ç 

        #endregion   è‡ªå®šä¹‰æ–¹æ³•
        //新增单据
        public bool AddBill(string HFilterIdLists, string HValue, string HElement_type, ref string sReturn)
        {
            try
            {
                oCn.BeginTran();
                //如果当前保存的过滤方案设置为了 é»˜è®¤æ–¹æ¡ˆï¼Œåˆ™æŠŠ é»˜è®¤è¿‡æ»¤æ–¹æ¡ˆæ ‡è®°éƒ½æ¸…除
                if (omodel.HUseingFlag == 1)
                {
                    oCn.RunProc("update Xt_FastICSchemeMain set HUseingFlag = 0");
                }
                //主表
                oCn.RunProc("Insert Into Xt_FastICSchemeMain   " +
                "(HInterID,HName,HUserCode,HBillType,HBillName" +
                ",HStopflag,HCreateDate,HUseingFlag,HRemark" +
                ") " +
                " values('" + omodel.HInterID.ToString() + "','" + omodel.HName + "','" + omodel.HUserCode + "'" +
                "," + 3332 + ",'" + omodel.HBillName + "'," + omodel.HStopflag + "," + "getdate()" + "," + omodel.HUseingFlag + ",'" + omodel.HRemark +
                "') ");
                //获取子表数据
                string[] HFilterIdLists_arr = Regex.Split(HFilterIdLists, ",", RegexOptions.IgnoreCase);
                string[] HValue_arr = Regex.Split(HValue, ",", RegexOptions.IgnoreCase);
                string[] HElement_type_arr = Regex.Split(HElement_type, ",", RegexOptions.IgnoreCase);
                //插入子表
                for (var i = 0; i < HFilterIdLists_arr.Length; i++)
                {
                    oCn.RunProc("Insert Into xt_FastICSchemeSub " +
                   "(HInterID,HKey,HValue,HDataType) " +
                   " values('" + omodel.HInterID.ToString() + "','" + HFilterIdLists_arr[i] + "','" + HValue_arr[i] + "'" +
                   ",'" + HElement_type_arr[i] +
                   "') ");
                }

                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }

        //修改单据
        public bool ModifyBill(Int64 lngBillKey, string HFilterIdLists, string HValue, string HElement_type, ref string sReturn)
        {
            try
            {
                //
                //更新当前过滤方案的过滤字段信息
                oCn.BeginTran();
                //更新主表
                //oCn.RunProc("UpDate Cg_POOrderBillMain set  " +
                //" HBillNo='" + omodel.HBillNo + "'" +  //固定赋值===============
                //",HDate='" + omodel.HDate + "'" +
                //",HYear='" + omodel.HYear.ToString() + "'" +
                //",HPeriod='" + omodel.HPeriod.ToString() + "'" +
                //",HRemark='" + omodel.HRemark + "'" +
                //",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" +
                //",HUpDateDate=getdate()" +
                ////========================================
                //",HSSDate='" + omodel.HSSDate + "'" +
                //",HAddress='" + omodel.HAddress + "'" +
                //",HSSID=" + omodel.HSSID.ToString() +
                //",HPSStyleID=" + omodel.HPSStyleID.ToString() +
                //",HSupID=" + omodel.HSupID.ToString() +
                //",HCurID=" + omodel.HCurID.ToString() +
                //",HExRate=" + omodel.HExRate.ToString() +
                //",HEmpID=" + omodel.HEmpID.ToString() +
                //",HManagerID=" + omodel.HManagerID.ToString() +
                //",HDeptID=" + omodel.HDeptID.ToString() +
                //",HExplanation='" + omodel.HExplanation + "'" +
                //",HInnerBillNo='" + omodel.HInnerBillNo + "'" +
                //" where HInterID=" + lngBillKey.ToString());

                
                //删除子表
                DeleteBillSub(lngBillKey);
                //获取子表数据
@@ -83,52 +105,6 @@
                oCn.RollBack();
                throw (e);
            }
        }
        //新增单据
        public bool AddBill(string HFilterIdLists, string HValue, string HElement_type, ref string sReturn)
        {
            try
            {                              
                oCn.BeginTran();
                if (omodel.HUseingFlag == 1)
                {
                    oCn.RunProc("update Xt_FastICSchemeMain set HUseingFlag = 0");
                }
                //主表
                oCn.RunProc("Insert Into Xt_FastICSchemeMain   " +
                "(HInterID,HName,HUserCode,HBillType,HBillName" +
                ",HStopflag,HCreateDate,HUseingFlag,HRemark" +              
                ") " +
                " values('" + omodel.HInterID.ToString() + "','" + omodel.HName + "','" + omodel.HUserCode + "'" +
                "," + 3332 + ",'" + omodel.HBillName + "'," + omodel.HStopflag + "," + "getdate()" + "," + omodel.HUseingFlag + ",'" + omodel.HRemark +
                "') ");
                //获取子表数据
                string[] HFilterIdLists_arr = Regex.Split(HFilterIdLists, ",", RegexOptions.IgnoreCase);
                string[] HValue_arr = Regex.Split(HValue, ",", RegexOptions.IgnoreCase);
                string[] HElement_type_arr = Regex.Split(HElement_type, ",", RegexOptions.IgnoreCase);
                //插入子表
                for (var i = 0; i < HFilterIdLists_arr.Length;i++)
                {
                    oCn.RunProc("Insert Into xt_FastICSchemeSub " +
                   "(HInterID,HKey,HValue,HDataType) " +
                   " values('" + omodel.HInterID.ToString() + "','" + HFilterIdLists_arr[i] + "','" + HValue_arr[i] + "'" +
                   ",'" + HElement_type_arr[i] + 
                   "') ");
                }
               
              
                //
                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }

        }       
    }
}