public DataTable GetPortionStockCheckOps(string checkNo)
{
BenQGuru.eMES.Material.WarehouseFacade facade = null;
if (facade == null)
{
facade = new BenQGuru.eMES.Material.WarehouseFacade(DataProvider);
}
object[] objs = facade.GetPortionStockCheckOps(checkNo);
DataTable dt = new DataTable("ExampleDataTable");
dt.Columns.Add("SLocationCode", typeof(string));
dt.Columns.Add("SCartonno", typeof(string));
dt.Columns.Add("LocationCode", typeof(string));
dt.Columns.Add("Cartonno", typeof(string));
dt.Columns.Add("StorageQTY", typeof(string));
dt.Columns.Add("CheckQTY", typeof(string));
dt.Columns.Add("StorageCode", typeof(string));
dt.Columns.Add("DQMCode", typeof(string));
if (objs != null)
{
for (int i = 0; i < objs.Length; i++)
{
StockCheckDetailOp s = objs[i] as StockCheckDetailOp;
dt.Rows.Add(s.SLocationCode, s.SCARTONNO, s.LocationCode, s.CARTONNO, s.STORAGEQTY, s.Qty, s.StorageCode, s.DQMCODE);
}
}
return(dt);
}
protected override string[] FormatExportRecord(object obj)
{
StockCheckDetailOp s = ((StockCheckDetailOp)obj);
return(new string[] {
s.CheckNo,
s.StorageCode,
s.DQMCODE,
s.SLocationCode,
s.SCARTONNO,
s.LocationCode,
s.CARTONNO,
s.STORAGEQTY.ToString(),
s.Qty.ToString(),
FormatHelper.ToTimeString(s.CTIME),
s.DiffDesc
});
}
