/// <summary> /// 获取貨櫃號箱信息 /// </summary> /// <param name=></param> /// <returns></returns> public List <MODEL.doc_PackListShip> GetPacklistShpByCarNo(string carno) { string sql = @" select CarNo,CustomStyleCode,BOXNO,AimArea,CartonBarcode,ShipOut,ShipScanTime,BoxSize from doc_PackListShip where CarNo=@CarNo order by CustomStyleCode,BOXNO "; SqlParameter[] ps = { new SqlParameter("@CarNo", carno) }; DataTable dt = SqlHelper.ExcuteTable(sql, ps); List <MODEL.doc_PackListShip> lists = null; if (dt.Rows.Count > 0) { lists = new List <MODEL.doc_PackListShip>(); foreach (DataRow row in dt.Rows) { MODEL.doc_PackListShip c = new MODEL.doc_PackListShip(); LoadDataToList5(row, c); lists.Add(c); } } return(lists); }
/// <summary> /// 获取訂單年月裝箱編號信息 /// </summary> /// <param name=></param> /// <returns></returns> public List <MODEL.doc_PackListShip> GetPacklistCarNo1(string yyyymm, string buyer, string od) { string mbuyer = buyer + "%"; string morder = od + "%"; string sql = @" select CustomBuyName,CustomStyleCode,CarNo,AimArea from doc_PackListShip where OrderDate =@OrderDate and CustomBuyName like @CustomBuyName and CustomStyleCode like @CustomStyleCode Group by CustomStyleCode,CarNo ,AimArea,CustomBuyName order by CustomBuyName,CustomStyleCode "; SqlParameter[] ps = { new SqlParameter("@OrderDate", yyyymm), new SqlParameter("@CustomBuyName", mbuyer), new SqlParameter("@CustomStyleCode", morder) }; DataTable dt = SqlHelper.ExcuteTable(sql, ps); List <MODEL.doc_PackListShip> lists = null; if (dt.Rows.Count > 0) { lists = new List <MODEL.doc_PackListShip>(); foreach (DataRow row in dt.Rows) { MODEL.doc_PackListShip c = new MODEL.doc_PackListShip(); LoadDataToList(row, c); lists.Add(c); } } return(lists); }
/// <summary> /// 获取貨櫃號箱信息 /// </summary> /// <param name=></param> /// <returns></returns> /// public List <MODEL.doc_PackListShip> GetPacklistShipNoNotScanIn(string customstylecode, int mno) { string sql = @" select BOXNO,CartonBarcode,OrderDate,ScanOut,ScanIn,QAout from doc_PackListShip where CustomStyleCode=@CustomStyleCode and ScanOut=@ScanOut and ScanIn=@ScanIn order by QAout, BOXNO "; SqlParameter[] ps = { new SqlParameter("@CustomStyleCode", customstylecode), new SqlParameter("@ScanOut", mno), new SqlParameter("@ScanIn", mno) }; DataTable dt = SqlHelper.ExcuteTable(sql, ps); List <MODEL.doc_PackListShip> lists = null; if (dt.Rows.Count > 0) { lists = new List <MODEL.doc_PackListShip>(); foreach (DataRow row in dt.Rows) { MODEL.doc_PackListShip c = new MODEL.doc_PackListShip(); LoadDataToList3(row, c); lists.Add(c); } } return(lists); }
/// <summary> /// 获取裝箱信息 /// </summary> /// <param name=></param> /// <returns></returns> public List <MODEL.doc_PackListShip> GetPacklistShipByCartonBarcode(string cartonbarcode) { string sql = @" select CartonBarcode,Orderdate,CustomStyleCode,BOXNO,ScanIn,ScanOut,QAIn,QAOut,CustomBuyName from doc_PackListShip where CartonBarCode=@CartonBarCode "; SqlParameter[] ps = { new SqlParameter("@CartonBarCode", cartonbarcode) }; DataTable dt = SqlHelper.ExcuteTable(sql, ps); List <MODEL.doc_PackListShip> lists = null; if (dt.Rows.Count > 0) { lists = new List <MODEL.doc_PackListShip>(); foreach (DataRow row in dt.Rows) { MODEL.doc_PackListShip c = new MODEL.doc_PackListShip(); LoadDataToList2(row, c); lists.Add(c); } } return(lists); }
/// <summary> /// 加载行数据到对象--集合 /// </summary> /// <param name="dr"></param> /// <param name="classes"></param> public void LoadDataToList(DataRow dr, MODEL.doc_PackListShip docpacklist) { // docpacklist.Guid = (Guid)SqlHelper.FromDbValue(dr["Guid"]); // 不用抓, 前面產生 // docpacklist.Style = (string)SqlHelper.FromDbValue(dr["Style"]);// // docpacklist.Name = (string)SqlHelper.FromDbValue(dr["Name"]);// // docpacklist.Color = (string)SqlHelper.FromDbValue(dr["Color"]);// // docpacklist.Code = (string)SqlHelper.FromDbValue(dr["Code"]);// //docpacklist.CustomStyleName = (string)SqlHelper.FromDbValue(dr["CustomStyleName"]); // CustomStyleName docpacklist.CustomStyleCode = (string)SqlHelper.FromDbValue(dr["CustomStyleCode"]); // 訂單號 // docpacklist.CustomName = (string)SqlHelper.FromDbValue(dr["CustomName"]); // docpacklist.CustomBuyName = (string)SqlHelper.FromDbValue(dr["CustomBuyName"]); // docpacklist.AimArea = (string)SqlHelper.FromDbValue(dr["AimArea"]); // // docpacklist.OrderDate = (string)SqlHelper.FromDbValue(dr["OrderDate"]);// // docpacklist.ShipMentDate = (DateTime)SqlHelper.FromDbValue(dr["ShipMentDate"]);// // docpacklist.CustomPO = (string)SqlHelper.FromDbValue(dr["CustomPO"]);// // docpacklist.ManufactureOrder = (string)SqlHelper.FromDbValue(dr["ManufactureOrder"]);// // docpacklist.CutNo = (string)SqlHelper.FromDbValue(dr["CutNo"]);// // docpacklist.CartonBarcode = (string)SqlHelper.FromDbValue(dr["CartonBarcode"]); // // docpacklist.BoxSize = (string)SqlHelper.FromDbValue(dr["BoxSize"]); // 外箱的尺寸 docpacklist.CarNo = (string)SqlHelper.FromDbValue(dr["CarNo"]); // // docpacklist.InvoiceNo = (string)SqlHelper.FromDbValue(dr["InvoiceNo"]); // //docpacklist.BOXNO = (int)SqlHelper.FromDbValue(dr["BOXNO"]); // // docpacklist.ScanIn = (int)SqlHelper.FromDbValue(dr["ScanIn"]); // // docpacklist.ScanOut = (int)SqlHelper.FromDbValue(dr["ScanOut"]); // // docpacklist.QAIn = (int)SqlHelper.FromDbValue(dr["QAIn"]); // // docpacklist.QAOut = (int)SqlHelper.FromDbValue(dr["QAOut"]); // }
/// 获取已編號貨櫃號櫃裝箱編號信息 /// </summary> /// <param name=></param> /// <returns></returns> public List <MODEL.doc_PackListShip> GetPacklistCarNoOK(string carno) { string sql = @" select CustomBuyName,CustomStyleCode,CarNo,AimArea from doc_PackListShip where CarNo=@CarNo Group by CustomStyleCode,CarNo ,AimArea,CustomBuyName order by CustomBuyName,CustomStyleCode "; SqlParameter[] ps = { new SqlParameter("@CarNo", carno) }; DataTable dt = SqlHelper.ExcuteTable(sql, ps); List <MODEL.doc_PackListShip> lists = null; if (dt.Rows.Count > 0) { lists = new List <MODEL.doc_PackListShip>(); foreach (DataRow row in dt.Rows) { MODEL.doc_PackListShip c = new MODEL.doc_PackListShip(); LoadDataToList(row, c); lists.Add(c); } } return(lists); }
/// <summary> /// 加载行数据到对象--集合 /// </summary> /// <param name="dr"></param> /// <param name="classes"></param> public void LoadDataToList3(DataRow dr, MODEL.doc_PackListShip docpacklist) { docpacklist.BOXNO = (int)SqlHelper.FromDbValue(dr["BOXNO"]); // docpacklist.CartonBarcode = (string)SqlHelper.FromDbValue(dr["CartonBarcode"]); // docpacklist.OrderDate = (string)SqlHelper.FromDbValue(dr["OrderDate"]); // docpacklist.ScanIn = (int)SqlHelper.FromDbValue(dr["ScanIn"]); // docpacklist.ScanOut = (int)SqlHelper.FromDbValue(dr["ScanOut"]); // docpacklist.QAOut = (int)SqlHelper.FromDbValue(dr["QAOut"]); // }