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