/// <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"]); //
}
