public StoreBinData GetStoreBinData(int x)
{
var result = new StoreBinData();
result.MaxBin = new BinData();
var where = new Hashtable();
var param = new Hashtable();
param["BinStart"] = x.ToString("D2");
where["where"] = param;
if (x == 99)
{
result.MaxBin.BinNo = getMaxBinNo(null);
}
else
{
result.MaxBin.BinNo = getMaxBinNo(where);
}
var dTable = this.GetDataTableByStatement("GetBinDataByBinNoStart", where);
var bins = new List <BinData>();
foreach (DataRow dRow in dTable.Rows)
{
var bin = new BinData();
bins.Add(bin);
bin.BinNo = dRow.StringValue("BIN_PLC_NO");
bin.UsedFlag = dRow.IntValue("USED_FLAG", 0);
bin.BinSize = dRow.StringValue("BIN_SIZE");
bin.BinStatus = dRow.StringValue("BIN_STATUS");
bin.BinBizStatus = dRow.StringValue("BIN_BIZ_STATUS");
bin.BinWeight = dRow.IntValue("BIN_WEIGHT", 0);
bin.BinArea = dRow.StringValue("BIN_AREA");
bin.CrnNo = dRow.StringValue("CRN_NO");
bin.GroupNo = dRow.StringValue("GROUP_NO");
bin.OrderLineGuid = dRow.StringValue("ORDER_LINE_GUID");
bin.BinAgvNo = dRow.StringValue("BIN_AGV_NO");
//bin.BinPlcNo = dRow.StringValue("BIN_PLC_NO");
bin.PalletNo1 = dRow.StringValue("PALLET_NO1");
bin.PalletNo2 = dRow.StringValue("PALLET_NO2");
bin.MaterNo = dRow.StringValue("MATERIAL_NO");
bin.MaterName = dRow.StringValue("MATER_NAME");
bin.BatchNo = dRow.StringValue("BATCH_NO");
bin.Grade = dRow.StringValue("GRADE");
bin.ProductDate = dRow.StringValue("PRODUCT_DATE");
bin.MaterMkind = dRow.StringValue("MATER_MKIND");
bin.MaterType = dRow.StringValue("MATER_TYPE");
bin.MaterSpec = dRow.StringValue("MATER_SPEC");
bin.MaterDesc = dRow.StringValue("MATER_DESC");
bin.Qty = dRow.StringValue("QTY");
bin.CrnNo = dRow.StringValue("CRN_NO");
}
result.AllBin = bins.ToArray();
return(result);
}
private BinData getBinStatusData(StoreBinData store, int y, int z)
{
foreach (var data in store.AllBin)
{
if (data.Y == y &&
data.Z == z)
{
return(data);
}
}
return(null);
}
