using?Common.Utility;
using?System;
using?System.Collections;
using?System.Collections.Generic;
using?System.Data;
using?System.Linq;
using?System.Web;

///?

///?供應商DAL
///?

public?class?VendorDAL
{
????public?VendorDAL（）
????{

????}



????///?

????///?根據編碼或者條碼或名稱查找
????///?

????///?編碼或者條碼
????///?名稱
????///?輸出sql
????///?
????public?ArrayList?GetByCodeAndName（string?code?string?name?out?string?sql）
????{

????????sql?=?@“select?*?from?
????????????????????????[Vendor]
????????????????????where?[cVCCode]?like?‘%{0}%‘?and?cVenName?like?‘%{1}%‘“;

????????sql?=?string.Format（sql?code?name）;

????????ArrayList?dt?=?DBUtil.Select（sql）;

????????return?dt;
????}

????public?ArrayList?GetByCodeAndName（string?invCode?string?invName）
????{
????????string?sql?=?““;
????????return?GetByCodeAndName（invCode?invName?out?sql）;
????}
????///?

????///?根據類別編碼查詢
????///?

????///?
????///?
????public?ArrayList?GetByClass（string?cVCCode）
????{

????????string?sql?=?@“select?a.*??from??????????????????????????????
????????????????????????????[Vendor]?a
????????????????????????where?cVCCode=‘{0}‘“;
????????sql?=?string.Format（sql?cVCCode）;

????????ArrayList?dt?=?DBUtil.Select（sql）;

????????return?dt;
????}
????///?

????///?返回所有存貨
????///?

????///?
????public?ArrayList?GetAll（）
????{

????????string?sql?=?@“select?*?from?[Vendor]?“;


????????ArrayList?dt?=?DBUtil.Select（sql）;

????????return?dt;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-12-25?08:52??ASHX-DEMO\
?????文件????????2169??2014-05-10?20:52??ASHX-DEMO\GetVendor.ashx
?????文件????????1819??2014-05-10?20:24??ASHX-DEMO\VendorDAL.cs