public string UpdateNGQty(string jobNo, int lineNo, int nQty, string userid)
    {
        string result = string.Empty;

        try
        {
            using (ProductCardNGBLL aNGBll = new ProductCardNGBLL())
            {
                result = aNGBll.Horizontal_UpdateNGQty(jobNo, lineNo, nQty, userid);
            }
        }
        catch (Exception ex)
        {
            result = ex.Message;
        }
        return(result);
    }
    public ProductCard GetJobLotInfo(string jobNo, int lineNo, string userid)
    {
        ProductCard pdCard = null;

        try
        {
            using (ProductCardNGBLL prodNGBll = new ProductCardNGBLL())
            {
                pdCard = prodNGBll.Horizontal_GetJobLotInfo(jobNo, lineNo, userid);
            }
        }
        catch (Exception ex)
        {
            pdCard = null;
            throw ex;
        }
        return(pdCard);
    }
    public List <JobLot> GetJobLotList(string jobNo, string userid)
    {
        List <JobLot> lstJobLot = null;

        try
        {
            using (ProductCardNGBLL prodNGBll = new ProductCardNGBLL())
            {
                lstJobLot = prodNGBll.Horizontal_GetJobLotList(jobNo, userid);
            }
        }
        catch (Exception ex)
        {
            lstJobLot = null;
            throw ex;
        }
        return(lstJobLot);
    }