예제 #1
0
        //新增模式使用
        public bool QueryPurchaseMaster(string ItemBarCode, string PeriodBarCode, out string PurchaseNo, out string Vendor)
        {
            PurchaseNo = string.Empty;
            Vendor = string.Empty;
            try
            {
                DBO.MaintainAcceptDBO dbo = new DBO.MaintainAcceptDBO(ref USEDB);
                ArrayList QueryParameter = new ArrayList();
                QueryParameter.Clear();
                QueryParameter.Add(ItemBarCode);
                QueryParameter.Add(PeriodBarCode);
                DataTable dtResult = dbo.QueryPurMaster(QueryParameter);

                if (dtResult.Rows.Count > 0)
                {
                    PurchaseNo = dtResult.Rows[0]["purchase_no"].ToString();
                    Vendor = dtResult.Rows[0]["vendor"].ToString();
                    return true;
                }
                else
                {
                    PurchaseNo = "";
                    Vendor = "";
                    return false;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }