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

namespace DAL
{
    public class ClsKF_PonderationBillMain_Temp_Ctl : DBUtility.ClsGy_Base_Ctl 
    {
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); 
        //原代码 用于 替换子项目
        public string HOldNumber;
        public Model.ClsKF_PonderationBillMain_Temp oModel = new Model.ClsKF_PonderationBillMain_Temp();
        //新增
        public override bool AddNew()
        {
            try
            {
                oCn.BeginTran();
                oCn.RunProc("Insert into " + MvarItemKey + " " +
                    " (HInterID,HBillType,HMaterID,HProcID,HWhID,HSCWHID" +
                    ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " +
                    ",HBarCode,HAddr,HMaker,HMakeDate " +
                    ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" +
                    ",HRelationInterID,HRelationEntryID,HRelationBillNo) " +
                    " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() +
                    "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() +
                    ",'" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" +
                    "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" +oModel.HSourceBillNo+"'"+
                    "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "')", 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 bool AddNew_More()
        {
            try
            {
                oCn.BeginTran();
                //箱号条码,批量新增
                oCn.RunProc("exec h_p_KF_PonderationBillMain_Temp_Add " + oModel.HInterID.ToString() + "," + oModel.HWhID.ToString() + ",'" + oModel.HBillType + "','" + oModel.HBarCode + "'," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HMaker + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }

        public bool AddNew_Sell()
        {
            try
            {
                DataSet oDs = new DataSet();
                oCn.BeginTran();
                oDs = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HMaterID=" + oModel.HMaterID.ToString(), "KF_PonderationBillMain_Temp");
                if (oDs == null || oDs.Tables[0].Rows.Count == 0)
                {
                    return false;
                }
                else
                {
                    //if (oModel.HBillType == "21")
                    //{
                    //    oModel.HWhID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HWhID"]);
                    //}
                    //else if (oModel.HBillType == "41")
                    //{
                    //    oModel.HSCWHID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSCWhID"]);
                    //}
                    oModel.HQtyMust = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HQtyMust"]);
                    oModel.HSourceInterID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceInterID"]);
                    oModel.HSourceEntryID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceEntryID"]);
                    oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillType"]);
                    oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillNo"]);
                }
                oCn.RunProc("Insert into " + MvarItemKey + " " +
                    " (HInterID,HBillType,HMaterID,HProcID,HWhID,HSCWHID" +
                    ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " +
                    ",HBarCode,HAddr,HMaker,HMakeDate " +
                    ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" +
                    ",HRelationInterID,HRelationEntryID,HRelationBillNo) " +
                    " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() +
                    "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() +
                    ",'" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" +
                    "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" +
                    "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "')", 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 bool AddNew_More_Sell()
        {
            try
            {
                oCn.BeginTran();
                //箱号条码,批量新增
                oCn.RunProc("exec h_p_KF_PonderationBillMain_Temp_Add_Sell " + oModel.HInterID.ToString() + ",'" + oModel.HBillType + "','" + oModel.HBarCode + "'," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() + ",'" + oModel.HMaker + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }

        //新增(一张单据,存在相同物料)
        public bool AddNew_Select()
        {
            try
            {
                DataSet oDs = new DataSet();
                oCn.BeginTran();
                oDs = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + oModel.HInterID.ToString() + " and HMaterID=" + oModel.HMaterID.ToString() + " and HSourceInterID=" + oModel.HSourceInterID + " and HSourceEntryID=" + oModel.HSourceEntryID, "KF_PonderationBillMain_Temp");
                if (oDs == null || oDs.Tables[0].Rows.Count == 0)
                {
                    return false;
                }
                else
                {
                    //if (oModel.HBillType == "21")
                    //{
                    //    oModel.HWhID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HWhID"]);
                    //}
                    //else if (oModel.HBillType == "41")
                    //{
                    //    oModel.HSCWHID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSCWhID"]);
                    //}
                    oModel.HQtyMust = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HQtyMust"]);
                    oModel.HSourceInterID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceInterID"]);
                    oModel.HSourceEntryID = DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[0]["HSourceEntryID"]);
                    oModel.HSourceBillType = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillType"]);
                    oModel.HSourceBillNo = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0]["HSourceBillNo"]);
                }
                oCn.RunProc("Insert into " + MvarItemKey + " " +
                    " (HInterID,HBillType,HMaterID,HProcID,HWhID,HSCWHID" +
                    ",HStockPlaceID,HOutStockPlaceID,HGroupID,HQty,HQtyMust,HPieceQty " +
                    ",HBarCode,HAddr,HMaker,HMakeDate " +
                    ",HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" +
                    ",HRelationInterID,HRelationEntryID,HRelationBillNo) " +
                    " Values(" + oModel.HInterID.ToString() + ",'" + oModel.HBillType + "'," + oModel.HMaterID.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HWhID.ToString() + "," + oModel.HSCWHID.ToString() +
                    "," + oModel.HStockPlaceID.ToString() + "," + oModel.HOutStockPlaceID.ToString() + "," + oModel.HGroupID.ToString() + "," + oModel.HQty.ToString() + "," + oModel.HQtyMust.ToString() + "," + oModel.HPieceQty.ToString() +
                    ",'" + oModel.HBarCode + "','" + oModel.HAddr + "','" + oModel.HMaker + "',getdate()" +
                    "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() + ",'" + oModel.HSourceBillType + "','" + oModel.HSourceBillNo + "'" +
                    "," + oModel.HRelationInterID.ToString() + "," + oModel.HRelationEntryID.ToString() + ",'" + oModel.HRelationBillNo + "')", 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 bool AddNew_More_Select()
        {
            try
            {
                oCn.BeginTran();
                //箱号条码,批量新增
                oCn.RunProc("exec h_p_KF_PonderationBillMain_Temp_Add_Select " + oModel.HInterID.ToString() + ",'" + oModel.HBillType + "','" + oModel.HBarCode + "','" + oModel.HMaker + "'," + oModel.HSourceInterID + "," + oModel.HSourceEntryID, ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }

        //新增(常规物料条码记录)
        public bool AddNew_More_ChangGui(long HInterID, long HMaterID, string sBillType, int sQty)
        {
            try
            {
                oCn.BeginTran();
                //批量新增
                oCn.RunProc("exec h_p_KF_PonderationBillMain_Temp_Add_ChangGui " + HInterID + ",'" + sBillType + "'," + HMaterID + "," + sQty, ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }

        //修改
        public override bool ModifyByID(Int64 sItemID)
        {
            try
            {
                oCn.BeginTran();
                //oCn.RunProc("Update " + MvarItemKey + " set " +
                //    " HNumber='" + oModel.HNumber + "'" +
                //    ",HName='" + oModel.HName + "'" +
                //    ",HShortNumber='" + oModel.HShortNumber + "'" +
                //    ",HHelpCode='" + oModel.HHelpCode + "'" +
                //    ",HLevel=" + oModel.HLevel.ToString() +
                //    ",HParentID=" + oModel.HParentID.ToString() +
                //    ",HEndflag=" + Convert.ToString(oModel.HEndFlag ? 1 : 0) +
                //    ",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) +
                //    ",HEnglishName='" + oModel.HEnglishName + "'" +
                //    ",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, 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 bool IsBarCode(string sBarCode, long HInterID, string sBillType)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from KF_PonderationBillMain_Temp Where HInterID=" + HInterID.ToString() + " and HBarCode='" + sBarCode + "' and HBillType='" + sBillType + "'", "KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return true;       //不存在相同条码
                else
                {
                    return false;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        //判断箱号条码临时表中是否存在
        public bool IsBarCode_Pack(string sBarCode_Pack, long HInterID, string sBillType)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from KF_PonderationBillMain_Temp Where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + sBarCode_Pack + "' and HBillType='" + sBillType + "'", "KF_PonderationBillMain_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return true;       //不存在相同箱号条码
                else
                {
                    return false;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        //构造函数
        public ClsKF_PonderationBillMain_Temp_Ctl()
        {
            MvarItemKey = "KF_PonderationBillMain_Temp";
            MvarReportTitle = "出入库条码临时表";
            oModel = new Model.ClsKF_PonderationBillMain_Temp();
        } 
    }
}