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

namespace DAL
{
    public class ClsSc_ICMOBill_K3 : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsSc_ICMOBillMain_K3 omodel = new Model.ClsSc_ICMOBillMain_K3();
        //public List<Model.ClsSc_ICMOBill_K3Sub> DetailColl = new List<Model.ClsSc_ICMOBill_K3Sub>();
        
        public ClsSc_ICMOBill_K3()
        {
            base.MvarItemKeySub = "";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey = "ICMO";
            base.MvarReportTitle = "生产任务单";
            base.BillType = "85";
        }

        #region 固定代码

        ~ClsSc_ICMOBill_K3()
        {
            //DetailColl = null;
        }

        #endregion   自定义方法

        //单据号是否重复
        public bool IsExistBillNo(ref string sReturn, string sBillNo, DBUtility.ClsPub.Enum_BillStatus oBillStatus, Int64 lngBillKey)
        {
            try
            {
                string sSql = "";
                if (oBillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew)
                {
                    sSql = "Select FInterID from ICMO where FTranType='" + BillType + "' and FBillNo ='" + sBillNo + "'";
                }
                else
                {
                    sSql = "Select FInterID from ICMO where FTranType='" + BillType + "' and FBillNo ='" + sBillNo + "' and FInterID<>" + lngBillKey.ToString();
                }
                DataSet Ds;
                Ds = oCnK3.RunProcReturn(sSql, "ICMO");
                if (Ds.Tables[0].Rows.Count != 0)
                {
                    sReturn = "单号重复";
                    return true;
                }
                sReturn = "单号未重复";
                return false;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                return false;
            }
        }

        //删除主表
        public void DeleteBillMain(Int64 lngBillKey)
        {
            oCnK3.RunProc("Delete From ICMO where FInterID=" + lngBillKey.ToString());
        }
        //删除单据
        public bool DeleteBill(Int64 lngBillKey, ref string sReturn)
        {
            DataSet Ds = new DataSet();
            try
            {
                oCnK3.BeginTran();
                //删除关联
                //DeleteRelation(ref sReturn, lngBillKey);
                //删除明细表 
                //删除主表
                DeleteBillMain(lngBillKey);
                //删除关联

                sReturn = "删除单据成功！";
                oCnK3.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCnK3.RollBack();
                return false;
            }
        }

        //修改单据
        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //得到用户ID
                DataSet DsBiller;
                DsBiller = oCnK3.RunProcReturn("select top 1 fuserid from t_User where fname='" + DBUtility.ClsPub.CurUserName + "'", "t_User");
                if (DsBiller.Tables[0].Rows.Count != 0)
                {
                    omodel.HBillerID = DBUtility.ClsPub.isLong(DsBiller.Tables[0].Rows[0][0]);
                }
                else
                {
                    omodel.HBillerID = 16394;
                }
                omodel.HBillType = this.BillType;
                //
                //得到mainid 
                omodel.HInterID = lngBillKey;

                //若MAINDI重复则重新获取 
                oCnK3.BeginTran();
                //主表
                oCnK3.RunProc(K3_BaseFun.Fun_GetAddBillMainSQL_ICMO(omodel, DBUtility.ClsPub.VersionNum));
                //
                sReturn = "修改单据成功！";
                oCnK3.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCnK3.RollBack();
                throw (e);
            }
        }
        //新增单据
        public override bool AddBill(ref string sReturn)
        {
            try
            {
                //得到用户ID
                DataSet DsBiller;
                DsBiller = oCnK3.RunProcReturn("select top 1 fuserid from t_User where fname='" + DBUtility.ClsPub.CurUserName + "'", "t_User");
                if (DsBiller.Tables[0].Rows.Count != 0)
                {
                    omodel.HBillerID = DBUtility.ClsPub.isLong(DsBiller.Tables[0].Rows[0][0]);
                }
                else
                {
                    omodel.HBillerID = 16394;
                }
                omodel.HBillType = this.BillType;
                //
                DataSet Ds;
                //得到mainid 
                Ds = oCnK3.RunProcReturn("declare @InterID int set @InterID=0 exec GetICMaxNum 'ICMO', @InterID output, 1, 16394 select ltrim(@InterID)", "GetICMaxNum");
                omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]);

                //若MAINDI重复则重新获取 
                oCnK3.BeginTran();
                //主表
                oCnK3.RunProc(K3_BaseFun.Fun_GetAddBillMainSQL_ICMO(omodel, DBUtility.ClsPub.VersionNum));
                //
                sReturn = "新增单据成功！";
                oCnK3.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCnK3.RollBack();
                throw (e);
            }
        }
        //显示单据
        public override bool ShowBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //查询主表
                DataSet Ds;
                Ds = oCnK3.RunProcReturn("Select * from ICMO Where FInterID=" + lngBillKey.ToString(), "ICMO");
                if (Ds.Tables[0].Rows.Count == 0)
                {
                    sReturn = "单据未找到！";
                    return false;
                }
                //赋值
                omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FInterID"]);
                omodel.HBillNo = Ds.Tables[0].Rows[0]["FBillNo"].ToString().Trim();
                omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["FCheckDate"]); 
                //=================
                omodel.HRemark = Ds.Tables[0].Rows[0]["Fnote"].ToString().Trim();

                omodel.HBatchNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FGMPBatchNo"]);
                //omodel.HBatchNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FHeadSelfJ0187"]);
                omodel.HSeOrderBillNo = "";
                omodel.HSeOrderInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FOrderInterID"]);
                omodel.HSeOrderEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FSourceEntryID"]);
                //omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"]);
                omodel.HCusID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FCustID"]);
                omodel.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FWorkShop"]);
                //omodel.HCenterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCenterID"]);
                omodel.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FItemID"]);
                omodel.HUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FUnitID"]);
                omodel.HBomID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FBomInterID"]);
                //omodel.HMainBomID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FHeadSelfj0194"]);
                //omodel.HMainBomNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FHeadSelfj0194"]);
                omodel.HRoutingInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["FRoutingID"]);
                //
                //omodel.HLevNum = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HLevNum"]);
                //omodel.HReadyQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HReadyQty"]);
                omodel.HPlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["Fauxqty"]);
                //omodel.HStockType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FHeadSelfJ0187"]);
                //
                omodel.HPlanBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["FPlanCommitDate"]);
                omodel.HPlanEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["FPlanFinishDate"]);
                //omodel.HBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HBeginDate"]);
                //omodel.HEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HEndDate"]);
                //
                omodel.HMaker = Ds.Tables[0].Rows[0]["FBillerID"].ToString().Trim();
                omodel.HMakeDate = Ds.Tables[0].Rows[0]["FCheckDate"].ToString().Trim(); 
               
                sReturn = "显示单据成功！";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }
        /// <summary>
        /// 生成工序计划单
        /// </summary>
        /// <param name="HICMOID"></param>
        /// <param name="sReturn"></param>
        /// <returns></returns>
        public bool ProcessPlanBill_Add(long HICMOID, ref string sReturn)
        {
            try
            {
                DataSet Ds;
                //单据ID
                long HInterID = DBUtility.ClsPub.CreateBillID("3715", ref DBUtility.ClsPub.sExeReturnInfo);
                string sHBillNo = DBUtility.ClsPub.CreateBillCode("3715", ref DBUtility.ClsPub.sExeReturnInfo, true);
                //
                oCn.BeginTran();
                //增加主表
                Ds = oCn.RunProcReturn("exec h_p_Sc_ProcessPlanBill_Add " + HICMOID.ToString() + "," + HInterID.ToString() + ",'" + sHBillNo + "','" + DBUtility.ClsPub.CurUserName + "'", "h_p_Sc_ProcessPlanBill_Add");
                if (Ds == null || Ds.Tables[0].Rows.Count == 0)
                {
                    oCn.RollBack();
                    return false;
                }
                if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) != 9)
                {
                    sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][1]);
                    oCn.RollBack();
                    return false;
                }
                //
                oCn.Commit();
                //回填关联数量
                //oCnK3.RunProc("update ICMO set FCardClosed=1 where finterid=" + HICMOID.ToString());
                //
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                return false;
            }
        }

        /// <summary>
        /// 生成工序计划单
        /// </summary>
        /// <param name="HICMOID"></param>
        /// <param name="sReturn"></param>
        /// <returns></returns>
        public bool ProcessPlanBill_Add(long HICMOID, long HRoutingID, ref string sReturn)
        {
            try
            {
                DataSet Ds;
                //单据ID
                long HInterID = DBUtility.ClsPub.CreateBillID("3715", ref DBUtility.ClsPub.sExeReturnInfo);
                string sHBillNo = DBUtility.ClsPub.CreateBillCode("3715", ref DBUtility.ClsPub.sExeReturnInfo, true);
                //
                oCn.BeginTran();
                //增加主表
                Ds = oCn.RunProcReturn("exec h_p_Sc_ProcessPlanBill_Add2 " + HICMOID.ToString() + "," + HRoutingID.ToString() + "," + HInterID.ToString() + ",'" + sHBillNo + "','" + DBUtility.ClsPub.CurUserName + "'", "h_p_Sc_ProcessPlanBill_Add");
                if (Ds == null || Ds.Tables[0].Rows.Count == 0)
                {
                    oCn.RollBack();
                    return false;
                }
                if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) != 9)
                {
                    sReturn = "工序计划单，单据号：" + sHBillNo + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][1]);
                    oCn.RollBack();
                    return false;
                }
                //
                oCn.Commit();
                //回填关联数量
                //oCnK3.RunProc("update ICMO set FCardClosed=1 where finterid=" + HICMOID.ToString());
                //
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                return false;
            }
        }

        /// <summary>
        /// 得到成本对象
        /// </summary>
        /// <param name="HICMOID"></param>
        /// <param name="sReturn"></param>
        /// <returns></returns>
        public long GetCostObjByHMaterID(long HMaterID)
        {
            DataSet Ds;
            //
            //增加主表
            Ds = oCnK3.RunProcReturn("select cb.FCostObjID HCostObjID from t_icitem m inner join cb_CostObj_Product cb on m.FItemID=cb.FProductID "+
                                                    "where FItemID=" + HMaterID.ToString(), "cb_CostObj_Product");
            if (Ds == null || Ds.Tables[0].Rows.Count == 0)
            {
                return 0;
            }
            long HCostObjID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
            return HCostObjID;
        }

        /// <summary>
        /// 下达
        /// </summary>
        /// <param name="HMaterID"></param>
        /// <returns></returns>
        public bool CheckICMOBill(Int64 HInterID, ref string sReturn)
        {
            try
            {
                oCn.RunProc("exec h_p_Sc_ICMOCheck_K3  " + HInterID.ToString());
                sReturn = "";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }

        /// <summary>
        /// 修改任务单 测试状态
        /// </summary>
        /// <param name="HICMOID"></param>
        /// <param name="sReturn"></param>
        /// <returns></returns>
        public bool UpdateTestStatus(long HICMOID, string sStatus, ref string sReturn)
        {
            try
            {
                oCn.BeginTran();
                //增加主表
                oCn.RunProc("update h_v_K3_ICMOBill set HTestStatus='" + sStatus + "' where HInterID=" + HICMOID.ToString());
                //
                sReturn = "修改状态成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                return false;
            }
        }

    }

}