public DataTable getPODataFromScanService(string startDate, string StopDate) { string sql = @" SELECT id,Barcode,CartonNo,PackQty,Style,Size,Color,( CASE WHEN LEN(MasterPO) > 0 THEN MasterPO else POCut END ) MasterPO ,StyleDescription,Country FROM U_NGC WHERE AddDate BETWEEN ' " + startDate + "' AND ' " + StopDate + "'"; DataTable result = TNF_SqlHelper.ExcuteTable(sql); return(result); }
public DataTable getPODataFromScanService(int Id) { string sql = @" SELECT id,Barcode,CartonNo,PackQty,Style,Size,Color,MasterPO,StyleDescription,Country FROM U_NGC WHERE ID > " + Id; DataTable result = TNF_SqlHelper.ExcuteTable(sql); return(result); }
public DataTable getPODataFromScanService(string PONumber) { string sql = @"SELECT Id, Barcode, CartonNo, PackQty, Style, Size, Color, (CASE WHEN LEN(MasterPO) > 0 THEN MasterPO ELSE POCut END ) MasterPO, StyleDescription, Country FROM U_NGC WHERE MasterPO LIKE '" + PONumber + @"%' OR POCut LIKE '" + PONumber + @"%' GROUP BY Id, Barcode, CartonNo, PackQty, Style, Size, Color, (CASE WHEN LEN(MasterPO) > 0 THEN MasterPO ELSE POCut END ), StyleDescription, Country;"; DataTable result = TNF_SqlHelper.ExcuteTable(sql); return(result); }