过滤方案

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

        }       
    }
}

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Xt_FastICSchemeController.cs

@@ -62,7 +62,7 @@
        }

        /// <summary>
        /// è¿”回过滤方案列表
        /// åŒå‡»è¿”回选择的过滤方案列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
@@ -140,11 +140,11 @@
                var _value = oMain["oMain"].ToString();
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string msg2 = sArray[0].ToString();//表头
                string msg3 = sArray[1].ToString();//过滤条件id
                string msg4 = sArray[2].ToString();//过滤值
                string msg5 = sArray[3].ToString();//标签类型
                string msg6 = sArray[4].ToString();//用户
                string msg2 = sArray[0].ToString();//表头字段信息 æˆ– å•æ®å†…码
                string HFilterIdLists = sArray[1].ToString();//过滤条件id
                string HValue = sArray[2].ToString();//过滤值
                string HElement_type = sArray[3].ToString();//标签类型
                string user = sArray[4].ToString();//用户
                string OperationType = sArray[5].ToString();//操作类型

                DAL.ClsXt_FastICScheme_Ctl oBill = new DAL.ClsXt_FastICScheme_Ctl();
@@ -154,10 +154,13 @@
                List<Model.ClsXt_FastICSchemeMain_Model> lsmain = new List<Model.ClsXt_FastICSchemeMain_Model>();
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");  //\n

                //当前操作类型不为编辑，则进行json数据的解析
                if (Convert.ToInt32(OperationType) != 3)
                {
                    lsmain = oListModels.getObjectByJson_Xt_FastICSchemeMain(msg2);
                }
                //当前操作类型为编辑，msg2 ä¸ºå•æ®å†…码
                else
                {
                    oBill.omodel.HInterID = Convert.ToInt32(msg2);
@@ -169,29 +172,16 @@
                    oBill.omodel = oItem;
                }

                ////表体数据
                ////按 },{来拆分数组 //去掉【和】
                //msg3 = msg3.Substring(1, msg3.Length - 2);
                //msg3 = msg3.Replace("\\", "");
                //msg3 = msg3.Replace("\n", "");  //\n
                ////msg2 = msg2.Replace("'", "’");
                //List<Model.ClsXt_FastICSchemeSub_Model> ls = new List<Model.ClsXt_FastICSchemeSub_Model>();
                //ls = oListModels.getObjectByJson_Gy_ICMOReportBillSub(msg3);
                //int i = 0;
               


                //保存
                //保存完毕后处理
                bool bResult;
                if (Convert.ToInt32(OperationType) == 1)
                {
                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                    bResult = oBill.AddBill(msg3, msg4, msg5, ref DBUtility.ClsPub.sExeReturnInfo);
                    bResult = oBill.AddBill(HFilterIdLists, HValue, HElement_type, ref DBUtility.ClsPub.sExeReturnInfo);
                }
                else
                {
                    bResult = oBill.ModifyBill(Convert.ToInt32(msg2), msg3, msg4, msg5, ref DBUtility.ClsPub.sExeReturnInfo);
                    bResult = oBill.ModifyBill(Convert.ToInt32(msg2), HFilterIdLists, HValue, HElement_type, ref DBUtility.ClsPub.sExeReturnInfo);
                }
                if (bResult)
                {