public void LoadPDDataToList(DataRow dr, pdinventory pdlist)
{
pdlist.Code = (string)SqlHelper.FromDbValue(dr["Code"]); //
pdlist.Name = (string)SqlHelper.FromDbValue(dr["Name"]); // 訂單號
pdlist.CustomStyleCode = (string)SqlHelper.FromDbValue(dr["CustomStyleCode"]); //
pdlist.OrderDate = (string)SqlHelper.FromDbValue(dr["OrderDate"]); //
pdlist.BOXNO = (int)SqlHelper.FromDbValue(dr["BOXNO"]); //
pdlist.CartonBarcode = (string)SqlHelper.FromDbValue(dr["CartonBarcode"]);
pdlist.WH = (string)SqlHelper.FromDbValue(dr["WH"]); //
pdlist.PDScan1 = (int)SqlHelper.FromDbValue(dr["PDScan1"]); //
pdlist.PDScan1Time = (string)SqlHelper.FromDbValue(dr["PDScan1Time"]); //
pdlist.PDScan2 = (int)SqlHelper.FromDbValue(dr["PDScan2"]); //
pdlist.PDScan2Time = (string)SqlHelper.FromDbValue(dr["PDScan2Time"]); //
pdlist.PDScan3 = (int)SqlHelper.FromDbValue(dr["PDScan3"]); //
pdlist.PDScan3Time = (string)SqlHelper.FromDbValue(dr["PDScan3Time"]); //
}
public List <pdinventory> getpdfiletotxt(string whs)
{
string sql = @"
SELECT Code ,
Name ,
CustomStyleCode ,
OrderDate ,
BOXNO ,
CartonBarcode ,
WH ,
ISNULL(PDScan1, '0') PDScan1 ,
PDScan1Time ,
ISNULL(PDScan2, '0') PDScan2 ,
PDScan2Time ,
ISNULL(PDScan3, '0') PDScan3 ,
PDScan3Time
FROM dbo.doc_PackListShip
WHERE WH='" + whs + @"'
AND (ShipOut=0 OR ShipOut IS NULL)
AND ScanIn != ScanOut
ORDER BY CustomStyleCode ,
BOXNO";
DataTable dt = SqlHelper.ExcuteTable(sql);
List <pdinventory> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <pdinventory>();
foreach (DataRow row in dt.Rows)
{
pdinventory c = new pdinventory();
LoadPDDataToList(row, c);
lists.Add(c);
}
}
return(lists);
}
