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

namespace DAL
{
    /// <summary>
    /// 生产排程 保存 生产人员  1对多
    /// </summary>
    public  class ClsSc_ICMOSortBill_Group
    {

        public string MvarItemKey;
        public string MvarReportTitle;

        public Model.ClsSc_ICMOSortBill_GroupMain omodel = new Model.ClsSc_ICMOSortBill_GroupMain();
        public List<Model.ClsSc_ICMOSortBill_GroupSub> DetailColl = new List<Model.ClsSc_ICMOSortBill_GroupSub>();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        public bool FillTag = false;
        public ClsSc_ICMOSortBill_Group()
        {
            MvarItemKey = "3708";
            MvarReportTitle = "生产计划排程";
        }

        #region 固定代码
        
        ~ClsSc_ICMOSortBill_Group()
        {
            DetailColl = null;
        }
        //删除子表
        public void DeleteBillSub(Int64 lngBillKey)
        {
            //oCn.RunProc("Delete From Sc_ICMOSortBillSub where HInterID=" + lngBillKey.ToString());
        }
        //删除主表
        public void DeleteBillMain(Int64 lngBillKey)
        {
            //oCn.RunProc("Delete From Sc_ICMOSortBillMain where HInterID=" + lngBillKey.ToString());
        }
        //删除单据
        public bool DeleteBill(Int64 lngBillKey, ref string sReturn)
        {
            //try
            //{
            //    oCn.BeginTran();
            //    //删除关联 
            //    //删除明细表
            //    //DeleteBillSub(lngBillKey);
            //    //删除主表
            //    DeleteBillMain(lngBillKey);
            //    sReturn = "删除单据成功！";
            //    oCn.Commit();
            return true;
            //}
            //catch (Exception e)
            //{
            //    sReturn = e.Message;
            //    oCn.RollBack();
            //    return false;
            //}
        }
       
    
        #endregion
        
        //新增单据
        public bool AddBill(ref string sReturn)
        {
            try
            {
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                oCn.RunProc("delete from Sc_ICMOSortBill_Group where HICMOInterID=" + omodel.HICMOInterID.ToString() + " and HSplitNO='" + omodel.HSplitNO + "' and HSourceID=" + omodel.HSourceID.ToString() + " and HGroupID=" + omodel.HGroupID.ToString());
                //主表
                //
                //插入子表
                foreach (Model.ClsSc_ICMOSortBill_GroupSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Sc_ICMOSortBill_Group " +
                       " (HICMOInterID,HICMOBillNo,HSplitNO,HMaterID" +
                       ",HSourceID,HGroupID,HEmpID" +
                       ") " +
                       " values ("
                       + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo.ToString() + "','" + omodel.HSplitNO.ToString() + "'," + omodel.HMaterID.ToString() +
                       "," + omodel.HSourceID.ToString() + "," + omodel.HGroupID.ToString() + "," + oSub.HEmpID.ToString() +
                       ") ");
                }
                
                sReturn = "新增单据成功！";
                oCn.Commit();
                //
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                return false;
            }
        }
        //显示单据
        public bool ShowBill(Int64 HICMOInterID, string HSplitNO, Int64 HSourceID, Int64 HGroupID, ref string sReturn)
        {
            try
            {
                //查询主表
                DataSet Ds;
                DataSet DsSub;
                Ds = oCn.RunProcReturn("Select * from Sc_ICMOSortBill_Group where HICMOInterID=" + HICMOInterID.ToString() + " and HSplitNO='" + HSplitNO + "' and HSourceID=" + HSourceID.ToString() + " and HGroupID=" + HGroupID.ToString(), "Sc_ICMOSortBill_Group");
                if (Ds.Tables[0].Rows.Count == 0)
                {
                    sReturn = "单据未找到！";
                    return false;
                }
                //赋值
                omodel.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"]);
                omodel.HGroupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HGroupID"]);
                omodel.HSourceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceID"]);
                omodel.HSplitNO = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSplitNO"].ToString());
                //
                omodel.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOInterID"]);
                omodel.HICMOBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HICMOBillNo"].ToString());
                //
                DsSub = oCn.RunProcReturn("Select * from Sc_ICMOSortBill_Group where HICMOInterID=" + omodel.HICMOInterID.ToString() + " and HSplitNO='" + omodel.HSplitNO + "' and HSourceID=" + omodel.HSourceID.ToString() + " and HGroupID=" + omodel.HGroupID.ToString(), "Sc_ICMOSortBill_Group");
                DetailColl.Clear();//清空
                for (int j = 0; j < DsSub.Tables[0].Rows.Count; j++)
                {
                    Model.ClsSc_ICMOSortBill_GroupSub oSub = new Model.ClsSc_ICMOSortBill_GroupSub();
                    oSub.HEmpID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[j]["HEmpID"]);
                    DetailColl.Add(oSub);
                }
                //
                
                sReturn = "显示单据成功！";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                return false;
            }
        }






    }

}