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

namespace DAL
{
    public class ClsGy_CostItemAverageType_Ctl_2 : DBUtility.ClsGy_Base_Ctl
    {
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        //原代码 用于 替换子项目
        public string HOldNumber;
        public Model.ClsGy_Gy_CostItemAverageType_Model_2 oModel = new Model.ClsGy_Gy_CostItemAverageType_Model_2();
        //新增
        public override bool AddNew(ref string sReturn)
        {


            try
            {
                oCn.BeginTran();
                oCn.RunProc($@"
                    INSERT INTO {MvarItemKey} (HNumber, HName, HShortNumber, HParentID, HLevel, HEndFlag, 
                    HStopflag, HRemark, HHelpCode, HUseFlag, HMakeTime, HMakeEmp, HUSEORGID, 
                    HCREATEORGID,HCostItemID,HAverageTypeID,HWIPFlag,HProcName,HFixRate) 
                    VALUES ('{oModel.HNumber}', '{oModel.HName}', '{oModel.HShortNumber}',
                    '{oModel.HParentID}', '{oModel.HLevel}', '{oModel.HEndFlag}', 
                    '{oModel.HStopflag}', '{oModel.HRemark}', '{oModel.HHelpCode}', 
                    '{oModel.HUseFlag}', getdate(), '{oModel.HMakeEmp}', 
                    '{oModel.HUSEORGID}', '{oModel.HCREATEORGID}', '{oModel.HCostItemID}', '{oModel.HAverageTypeID}',
                    '{oModel.HWIPFlag}', '{oModel.HProcName}', '{oModel.HFixRate}')
                ", ref DBUtility.ClsPub.sExeReturnInfo);
                //修改上级为非末级代码
                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 sItemID, ref string sReturn)
        {
            try
            {
                oCn.BeginTran();
                oCn.RunProc($@"
                UPDATE {MvarItemKey} SET 
                HNumber='{oModel.HNumber}',
                HName='{oModel.HName}', 
                HShortNumber='{oModel.HShortNumber}',
                HParentID='{oModel.HParentID}',
                HLevel='{oModel.HLevel}',
                HEndFlag='{oModel.HEndFlag}',
                HStopflag='{oModel.HStopflag}',
                HRemark='{oModel.HRemark}',
                HHelpCode='{oModel.HHelpCode}',
                HUseFlag='{oModel.HUseFlag}',
                HModifyEmp='{oModel.HModifyEmp}',
                HModifyTime=getdate(),
                HUSEORGID='{oModel.HUSEORGID}',
                HCostItemID = '{oModel.HCostItemID}',
                HAverageTypeID= '{oModel.HAverageTypeID}',
                HWIPFlag ='{oModel.HWIPFlag}', 
                HProcName = '{oModel.HProcName}',
                HFixRate = '{oModel.HFixRate}',
                HCREATEORGID= '{oModel.HCREATEORGID}'
                WHERE HItemID='{oModel.HItemID}'
                ", ref DBUtility.ClsPub.sExeReturnInfo);
                //修改子项目代码
                // oCn.RunProc("exec h_p_Gy_UpdateNumber '" + MvarItemKey + "','" + oModel.HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
                //将上级 为非末级
                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 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_CostItemAverageType_Ctl_2()
        {
            MvarItemKey = "Gy_CostItemAverageType";
            MvarReportTitle = "成本项目分配标准";
            oModel = new Model.ClsGy_Gy_CostItemAverageType_Model_2();
        }
    }
}