Example #1
0
    public bool IsExistsArrangeBillFactPallet(string strArriveBillNo, string strPalletNo)
    {
        BArrangeBillFactBB arrangeBillFactBB = new BArrangeBillFactBB();

        try
        {
            DataTable dt = new DataTable();

            dt = arrangeBillFactBB.GetList("arriveBillNo='" + strArriveBillNo + "' and palletNo='" + strPalletNo + "'").Tables[0];
            return dt.Rows.Count > 0 ? true : false;
        }
        finally
        {
            arrangeBillFactBB.Dispose();
        }
    }
Example #2
0
    public DataTable GetArrangeBillFactDetail(string strArriveBillNo, string strPalletIndex, string strRegion)
    {
        BArrangeBillFactBB arrangeBillFactBB = new BArrangeBillFactBB();
        BArrangeBillFactDetailBB arrangeBillFactDetailBB = new BArrangeBillFactDetailBB();

        try
        {
            DataTable dt = new DataTable();
            DataSet ds = new DataSet();
            string mainId = "0";

            ds = arrangeBillFactBB.GetList("arriveBillNo='" + strArriveBillNo + "' and palletIndex='" + strPalletIndex + "'");
            if (ds.Tables[0].Rows.Count > 0)
            {
                mainId = ds.Tables[0].Rows[0]["id"].ToString();
            }

            dt = arrangeBillFactDetailBB.GetVList("mainId='" + mainId + "' and region='" + strRegion + "'").Tables[0];
            return dt;
        }
        finally
        {
            arrangeBillFactBB.Dispose();
            arrangeBillFactDetailBB.Dispose();
        }
    }
Example #3
0
    public string GetPalletNo(string strArriveBillNo, string strPalletIndex)
    {
        BArrangeBillFactBB arrangeBillFactBB = new BArrangeBillFactBB();

        try
        {
            DataSet ds = new DataSet();
            string strPalletNo = "";

            ds = arrangeBillFactBB.GetList("arriveBillNo='" + strArriveBillNo + "' and palletIndex='" + strPalletIndex + "'");
            if (ds.Tables[0].Rows.Count > 0)
            {
                strPalletNo = ds.Tables[0].Rows[0]["palletNo"].ToString();
            }

            return strPalletNo;
        }
        finally
        {
            arrangeBillFactBB.Dispose();
        }
    }