using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;

namespace DAL
{
    public class ClsXt_FastICScheme_Ctl : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsXt_FastICSchemeMain_Model omodel = new Model.ClsXt_FastICSchemeMain_Model();
        public List<Model.ClsXt_FastICSchemeSub_Model> DetailColl = new List<Model.ClsXt_FastICSchemeSub_Model>();

        public ClsXt_FastICScheme_Ctl()
        {
            base.MvarItemKeySub = "Xt_FastICSchemeSub";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey = "Xt_FastICSchemeMain";
            base.MvarReportTitle = "快速过滤方案";
            base.BillType = "3332";
            base.HBillSubType = "3332";
        }

        #region 固定代码

        #endregion   自定义方法
        //新增单据
        public bool AddBill(string HFilterIdLists, string HValue, string HElement_type,string user, ref string sReturn)
        {
            try
            {
                oCn.BeginTran();
                //如果当前保存的过滤方案设置为了 默认方案，则把 默认过滤方案标记都清除
                if (omodel.HUseingFlag == 1)
                {
                    oCn.RunProc("update Xt_FastICSchemeMain set HUseingFlag = 0 where HBillName ='" + omodel.HBillName + "' and HUserCode ='" + user + "'");
                }
                //主表
                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();
                
                //删除子表
                DeleteBillSub(lngBillKey);
                //获取子表数据
                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);
            }
        }       
    }
}