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); }