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

namespace BLL
{
    public class ClsSc_AssemblyBill
    {
        /// <summary>
        /// 扫描成品条码 并返回相关信息，判断是否有效条码
        /// </summary>
        /// <param name="sCPCode">成品编码</param>
        /// <param name="HBillType">单据类型</param>
        /// <param name="sICMOBillNo">任务单号</param>
        /// <param name="sCPBarCode">成品条码</param>
        /// <param name="sCPMaterID">成品内码</param>
        /// <param name="sCPMaterName">成品名称</param>
        /// <param name="sBillNo">单据号</param>
        /// <param name="sInterID">单据内码</param>
        /// <param name="sErrMsg">错误信息</param>
        /// <returns></returns>
        public bool Get_Assembly_CPBarCode(string sCPCode, string HBillType, ref string sICMOBillNo, ref string sCPBarCode, ref Int64 sCPMaterID, ref string sCPMaterName, ref string sBillNo, ref Int64 sInterID, ref string sErrMsg)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DAL.ClsGy_BarCodeBill_View dal = new DAL.ClsGy_BarCodeBill_View();
            //
            try
            {
                //判断所扫描条码是否有效
                if (dal.GetInfoByNumber_View(sCPCode))
                {
                    //判断成品条码是否存在组装单记录
                    DataSet ds = oCn.RunProcReturn("exec h_p_Sc_AssemblyBill_CPBarCode '" + sCPCode + "'", "h_p_Sc_AssemblyBill_CPBarCode");
                    if (ds == null || ds.Tables[0].Rows.Count == 0)
                    {
                        sErrMsg = "扫描成品条码信息，未知错误！";
                        return false;
                    }
                    else
                    {
                        //已存在组装单记录，编辑状态，获取原组装单单据内码、单据号
                        if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "Modify")
                        {
                            sICMOBillNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HICMOBillNo"]);
                            sCPBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HCPBarCode"]);
                            sCPMaterID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HCPMaterID"]);
                            sCPMaterName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HCPMaterName"]);
                            sInterID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"]);
                            sBillNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBillNo"]);
                            return true;
                        }
                        else if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "AddNew")
                        //不存在组装单记录，新增状态，获取最大组装单单据内码、单据号
                        {
                            sICMOBillNo = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HICMOBillNo"]);
                            sCPBarCode = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HCPBarCode"]);
                            sCPMaterID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HCPMaterID"]);
                            sCPMaterName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HCPMaterName"]);
                            sInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref sErrMsg);
                            sBillNo = DBUtility.ClsPub.CreateBillCode_Prod(HBillType, ref sErrMsg, true);
                            return true;
                        }
                        else
                        {
                            sErrMsg = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]);
                            return false;
                        }
                    }
                }
                else
                {
                    sErrMsg = "无效条码";
                    return false;
                }
            }
            catch (Exception e)
            {
                sErrMsg = "扫描成品条码失败！" + e.Message;
                return false;
            }
        }

        /// <summary>
        /// 扫描配件条码  并返回相关信息，判断是否有效条码
        /// </summary>
        /// <param name="sPJCode">配件代码</param>
        /// <param name="sCPCode">成品代码</param>
        /// <param name="sInterID">内码</param>
        /// <param name="sBillNo">单据号</param>
        /// <param name="sMaker">制单人</param>
        /// <param name="HWorkerID">操作员</param>
        /// <param name="HSNNumber">SN号</param>
        /// <param name="sErrMsg">错误信息</param>
        /// <returns></returns>
        public bool Get_Assembly_PJBarCode(string sPJCode, string sCPCode, long sInterID, string sBillNo, string sMaker, long HWorkerID, string HSNNumber, ref string sErrMsg)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DAL.ClsGy_BarCodeBill_View dal = new DAL.ClsGy_BarCodeBill_View();
            //
            try
            {
                if (dal.GetInfoByNumber_View(sPJCode))
                {
                    if (sPJCode == sCPCode)
                    {
                        sErrMsg = "所扫描配件条码与成品条码不允许相同！";
                        return false;
                    }

                    DataSet ds = oCn.RunProcReturn("exec h_p_Sc_AssemblyBill_PJBarCode '" + sPJCode + "','" + sCPCode + "'," + sInterID.ToString() + ",'" + sBillNo + "','" + sMaker + "'," + HWorkerID.ToString() + ",'" + HSNNumber + "'", "h_p_Sc_AssemblyBill_PJBarCode");
                    if (ds == null || ds.Tables[0].Rows.Count == 0)
                    {
                        sErrMsg = "扫描配件条码信息，未知错误！";
                        return false;
                    }
                    else
                    {
                        if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]) == 0)
                        {
                            return true;
                        }
                        else
                        {
                            sErrMsg = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
                            return false;
                        }
                    }
                }
                else
                {
                    sErrMsg = "无效条码";
                    return false;
                }
            }
            catch (Exception e)
            {
                sErrMsg = "扫描配件条码失败！" + e.Message;
                return false;
            }
        }

        /// <summary>
        /// 根据内码 返回组装单信息
        /// </summary>
        /// <param name="HInterID">内码</param>
        /// <param name="sBillType">单据类型</param>
        /// <param name="sWhere">过滤条件</param>
        /// <returns></returns>
        public DataSet GetSc_AssemblyBill(long HInterID, string sBillType, string sWhere,ref string sErr)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            //
            try
            {
                DataSet DS = oCn.RunProcReturn("exec h_p_Sc_AssemblyBillList " + HInterID, "h_p_Sc_AssemblyBillList");
                //DataSet DS = oCn.RunProcReturn("Select * from h_v_Sc_AssemblyBill Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_Sc_AssemblyBill", ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS == null || DS.Tables[0].Rows.Count == 0)
                {
                    return null;
                }
                else
                {
                    return DS;
                }
            }
            catch (Exception e)
            {
                sErr = sErr + "," + e.Message;
                throw (e);
            }
        }

        /// <summary>
        /// 根据内码及条形码，删除对应数据
        /// </summary>
        /// <param name="HInterID"></param>
        /// <param name="HBarCode"></param>
        /// <param name="sErrMsg"></param>
        /// <returns></returns>
        public bool set_DelSc_AssemblyBill(long HInterID, string HBarCode, ref string sErrMsg)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            try
            {
                oCn.RunProc("Delete from Sc_AssemblyBillSub where HInterID=" + HInterID.ToString() + " and HBarCode='" + HBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                sErrMsg = "删除失败！" + e.Message;
                return false;
            }
        }


    }
}