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

namespace DAL
{
    public class ClsGy_BarCodeEdit_Ctl
    {
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        public Model.ClsGy_BarCodeEdit_Model omodel = new Model.ClsGy_BarCodeEdit_Model();
        public List<Model.ClsGy_BarCodeEdit_Model> DetailColl = new List<Model.ClsGy_BarCodeEdit_Model>();

        //新增
        public bool AddNew()
        {

            try
            {
                oCn.BeginTran();
                foreach (Model.ClsGy_BarCodeEdit_Model omodel in DetailColl)
                {
                    oCn.RunProc("INSERT INTO [Kf_ICStockBillSub_WMS] " +
                        "([HInterID],[HEntryID],[HBillType],[HMaterID],[HProcID] " +
                        ",[HWhID],[HSCWhID],[HStockPlaceID],[HOutStockPlaceID],[HGroupID] " +
                        ",[HQty],[HBarCode],[HAddr],[HBatchNo],[HMaker],[HMakeDate] " +
                        ",[HSourceInterID],[HSourceEntryID],[HSourceBillType],[HSourceItemID],[HBarCodeType]) " +
                        " Values ('" + omodel.HInterID + "'," + omodel.HEntryID.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.HBarCode + "','" + omodel.HAddr + "','" + omodel.HBatchNo + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" +
                        "," + omodel.HSourceInterID.ToString() + "," + omodel.HSourceEntryID.ToString() + ",'" + omodel.HSourceBillType + "'," + omodel.HSourceItemID.ToString() + ",'" + omodel.HBarCodeType + "'" + ")", ref DBUtility.ClsPub.sExeReturnInfo);
                }
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCn.RollBack();
                throw (e);
            }
        }

        //删除
        public bool DeleteByID(Int64 sItemID)
        {
            try
            {
                oCn.RunProc("Delete from Kf_ICStockBillSub_WMS where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        //设置单据网络信息
        public DataSet SetGridViewByBillNo(string sBillNo)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from h_v_Kf_StockBarCodeList Where HBillType='" + sBillNo + "'", "h_v_Kf_StockBarCodeList", ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return null;
                else
                {
                    return DS;
                }
            }
            catch (Exception e)
            {
                return null;
            }
        }

        //根据条码判断信息
        public bool HavParentCarCode(string sCode)
        {
            DataSet DS;
           
            try
            {
                DS = oCn.RunProcReturn("Select * from Gy_BarCodeBill Where hbarcode='" + sCode + "'", "Gy_BarCodeBill", ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                return false;
            //if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBarCodeType"]) == "箱号条码")
            //{
            //    DataSet oDS;
            //    try
            //    {
            //        oDS = oCn.RunProcReturn("select * from h_v_Sc_PackUnionBillList where 箱号条形码=" + sCode, "Sc_PackUnionBillMain", ref Pub_Class.ClsPub.sExeReturnInfo);
            //        if (oDS.Tables[0].Rows.Count == 0)
            //            return false;
                    
            //        else
            //        {
            //            DetailColl.Clear();
            //            for (int i = 0; i < oDS.Tables[0].Rows.Count; i++)
            //            {
            //                omodel.HMaterID = DBUtility.ClsPub.isLong(oDS.Tables[0].Rows[i]["HMaterID"]);
            //                omodel.HQty = DBUtility.ClsPub.isDoule(oDS.Tables[0].Rows[i]["数量"]);
            //                omodel.HBarCode = DBUtility.ClsPub.isStrNull(oDS.Tables[0].Rows[i]["箱号条形码"]);
            //                DetailColl.Add(omodel);
            //            }
            //            return true;
            //        } 
            //    }
            //    catch (Exception e)
            //    {
            //        throw (e);
            //    }
            //}
                 else
            {
                 //       omodel.HMaterID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HMaterID"]);
                 //       omodel.HQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]);
                 //       omodel.HBarCode = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBarCode"]);
                 //       omodel.HBatchNo = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBatchNo"]);
                 //       omodel.HSourceInterID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HSourceInterID"]);
                 //       omodel.HSourceEntryID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HSourceEntryID"]);
                 //       omodel.HSourceBillType = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HSourceBillType"]);
                        return true;
                    }
                   
               
            }

            catch (Exception e)
            {
                throw (e);
            }
        }


        public bool Show(long sMater)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from Kf_ICStockBillSub_WMS Where HMaterID='" + sMater + "'", "Kf_ICStockBillSub_WMS", ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    omodel.HMaterID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HMaterID"]);
                    omodel.HQty = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[0]["HQty"]);
                    omodel.HBarCode = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBarCode"]);
                    omodel.HBatchNo = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBatchNo"]);
                    omodel.HSourceInterID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HSourceInterID"]);
                    omodel.HSourceEntryID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HSourceEntryID"]);
                    omodel.HSourceBillType = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HSourceBillType"]);
                    return true;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

    }
}