using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DAL
{
    public class ClsGy_SampleScheme_Ctl : DBUtility.ClsGy_Base_Ctl
    {
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        //原代码 用于 替换子项目
        public string HOldNumber;
        public Model.ClsGy_SampleScheme_Model oModel = new Model.ClsGy_SampleScheme_Model();
        //public Model.ClsGy_SampleSchemeSub_Model osub = new Model.ClsGy_SampleSchemeSub_Model();
        public List<Model.ClsGy_SampleSchemeSub_Model> DetailColl = new List<Model.ClsGy_SampleSchemeSub_Model>();

        //新增
        public override bool AddNew()
        {

            try
            {
                oCn.BeginTran();
                string sql = $@"INSERT INTO [Gy_SampleScheme] ([HName], [HShortNumber], [HParentID], [HLevel], [HEndFlag], [HStopflag], [HRemark], [HHelpCode], [HUseFlag], [HMakeTime], [HMakeEmp], [HCheckEmp], [HCheckTime], [HModifyEmp], [HModifyTime], [HStopEmp], [HStopTime], [HUSEORGID], [HCREATEORGID], [HInterID], [HSampleTimes], [HSampleType], [HSampleLevel], [HStrictLevel], [HAQL], [HEffectDate], [HExpireDate], [HIsSystemSet], [HERPItemID], [HNumber]) 
                VALUES (
                '{oModel.HName}', '{oModel.HShortNumber}',  '{oModel.HParentID}',  '{oModel.HLevel}',  '{oModel.HEndFlag}',  '{oModel.HStopflag}',  '{oModel.HRemark}',  '{oModel.HHelpCode}',  '{oModel.HUseFlag}',  '{oModel.HMakeTime}',  '{oModel.HMakeEmp}',  '{oModel.HCheckEmp}','{oModel.HCheckTime}','{oModel.HModifyEmp}',  '{oModel.HModifyTime}',  '{oModel.HStopEmp}','{oModel.HStopTime}','{oModel.HUSEORGID}','{oModel.HCREATEORGID}','{oModel.HInterID}','{oModel.HSampleTimes}','{oModel.HSampleType}','{oModel.HSampleLevel}','{oModel.HStrictLevel}','{oModel.HAQL}','{oModel.HEffectDate}','{oModel.HExpireDate}','{oModel.HIsSystemSet}','{0}','{oModel.HNumber}'
                ); ";
                oCn.RunProc(sql);


                // 插入子表
                if (DetailColl != null && DetailColl.Count > 0)
                {
                    foreach (Model.ClsGy_SampleSchemeSub_Model osub in DetailColl)
                    {
                        if (osub == null)
                            continue;
                        string sql1 = $@"INSERT INTO [Gy_SampleSchemeSub] ([HInterID], [HEntryID], [HBatch], [HSampleCode], [HSampleRate], [HExpression], [HRejectQty], [HAcceptQty], [HSampleQty], [HSampleLow], [HSampleUp]) VALUES(
                        '{oModel.HInterID}', '{osub.HEntryID}',  '{osub.HBatch}',  '{osub.HSampleCode}',  '{osub.HSampleRate}',  '{osub.HExpression}',  '{osub.HRejectQty}',  '{osub.HAcceptQty}',  '{osub.HSampleQty}',  '{osub.HSampleLow}',  '{osub.HSampleUp}''
                        ); ";
                        oCn.RunProc(sql1);
                    }
                }


                
                ////修改上级为非末级代码
                //oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }

        //修改
        public override bool ModifyByID(Int64 lngBillKey)
        {
            try
            {
                oCn.BeginTran();
                oCn.RunProc("Update " + MvarItemKey + " set " +
                " HName='" + oModel.HName + "'" +
                ",HShortNumber='" + oModel.HShortNumber + "'" +
                ",HParentID=" + oModel.HParentID +
                ",HLevel=" + oModel.HLevel +
                ",HEndFlag=" + Convert.ToString(oModel.HEndFlag ? 1 : 0) +
                ",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) +
                ",HRemark='" + oModel.HRemark + "'" +
                ",HHelpCode='" + oModel.HHelpCode + "'" +
                ",HUseFlag=" +oModel.HUseFlag  +
                ",HMakeTime='" + oModel.HMakeTime + "'" +
                ",HMakeEmp='" + oModel.HMakeEmp + "'" +
                ",HCheckEmp='" + oModel.HCheckEmp + "'" +
                ",HCheckTime='" + oModel.HCheckTime + "'" +
                ",HModifyEmp='" + oModel.HModifyEmp + "'" +
                ",HModifyTime='" + oModel.HModifyTime + "'" +
                ",HStopEmp='" + oModel.HStopEmp + "'" +
                ",HStopTime='" + oModel.HStopTime + "'" +
                ",HUSEORGID=" + oModel.HUSEORGID +
                ",HCREATEORGID=" + oModel.HCREATEORGID +
                ",HInterID=" + oModel.HInterID +
                ",HSampleTimes=" + oModel.HSampleTimes +
                ",HSampleType=" + oModel.HSampleType +
                ",HSampleLevel=" + oModel.HSampleLevel +
                ",HStrictLevel=" + oModel.HStrictLevel +
                ",HAQL=" + oModel.HAQL +
                ",HEffectDate='" + oModel.HEffectDate + "'" +
                ",HExpireDate='" + oModel.HExpireDate + "'" +
                ",HIsSystemSet=" + Convert.ToString(oModel.HIsSystemSet ? 1 : 0) +
                ",HERPItemID=" + 0 +
                ",HNumber='" + oModel.HNumber + "'" +
                " Where HItemID=" + lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo);

                oCn.RunProc("delete Gy_SampleSchemeSub where  HInterID='" + oModel.HInterID + "'");


                // 插入子表
                if (DetailColl != null && DetailColl.Count > 0)
                {
                    foreach (Model.ClsGy_SampleSchemeSub_Model osub in DetailColl)
                    {
                        if (osub == null)
                            continue;
                        string sql1 = $@"INSERT INTO [Gy_SampleSchemeSub] ([HInterID], [HEntryID], [HBatch], [HSampleCode], [HSampleRate], [HExpression], [HRejectQty], [HAcceptQty], [HSampleQty], [HSampleLow], [HSampleUp]) VALUES(
                        '{oModel.HInterID}', '{osub.HEntryID}',  '{osub.HBatch}',  '{osub.HSampleCode}',  '{osub.HSampleRate}',  '{osub.HExpression}',  '{osub.HRejectQty}',  '{osub.HAcceptQty}',  '{osub.HSampleQty}',  '{osub.HSampleLow}',  '{osub.HSampleUp}''
                        ); ";
                        oCn.RunProc(sql1);
                    }
                }


                //
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }
        //根据代码判断信息
        public override bool HavParentCode(string sCode, Int64 sItemID)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HStopflag=0 and HNumber='" + sCode + "' and HItemID<>" + sItemID, MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    oModel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]);
                    return true;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
        //构造函数
        public ClsGy_SampleScheme_Ctl()
        {
            MvarItemKey = "Gy_SampleScheme";
            MvarReportTitle = "抽样方案设置";
            oModel = new Model.ClsGy_SampleScheme_Model();
        }
    }
}