//进行一次查询
private void QueryShelfInformation()
{
try
{
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
int cnt = 0;
dt1 = DBPCaller.AtStationPod(MyData.GetStationId());
if (dt1 != null && dt1.Rows.Count > 0)
{
//打印货架信息
Trace.WriteLine("Debug: PodId=" + dt1.Rows[0]["PodId"].ToString() +
", PodName=" + dt1.Rows[0]["PodName"].ToString() +
", Row=" + dt1.Rows[0]["Row"].ToString() +
", Column=" + dt1.Rows[0]["Column"].ToString()
);
dt2 = DBPCaller.PickAtStationLoc(MyData.GetStationId());
_dtShelf = dt2;
if (dt2 != null && dt2.Rows.Count > 0)
{
//打印出货储位等信息
Trace.WriteLine("Debug: StockNo=" + dt2.Rows[0]["StockNo"].ToString() +
",ShowText=" + dt2.Rows[0]["ShowText"].ToString() +
",PodId=" + dt2.Rows[0]["PodId"].ToString() +
",PodSide=" + dt2.Rows[0]["PodSide"].ToString() +
",ShelfId=" + dt2.Rows[0]["ShelfId"].ToString() +
",BoxBarcode=" + dt2.Rows[0]["BoxBarcode"].ToString() +
",BoxId=" + dt2.Rows[0]["BoxId"].ToString() +
",MaterialId=" + dt2.Rows[0]["MaterialId"].ToString() +
",MaterialName=" + dt2.Rows[0]["MaterialName"].ToString() +
",Qty=" + dt2.Rows[0]["Qty"].ToString() +
",AllOut=" + dt2.Rows[0]["AllOut"].ToString()
);
//cnt = GeTrSnCnt(dt2.Rows[0]["BoxBarcode"].ToString());
}
if (runFlag)
{
RefreshPickUI(cnt, int.Parse(dt1.Rows[0]["Column"].ToString()), _dtShelf);
}
}
else
{
if (runFlag)
{
RefreshPickUI(0, 0, null);
}
}
}
catch (Exception ex)
{
Log.Error("RefreshUI:" + ex.Message);
Trace.WriteLine("Debug: QueryShelfInformation : " + ex.Message);
}
}
//进行一次查询
private void QueryShelfInformation()
{
try
{
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
Trace.WriteLine("Debug: ------AtStationPod Start------");
dt1 = DBPCaller.AtStationPod(MyData.GetStationId());
Trace.WriteLine("Debug: ------AtStationPod Stop------");
if (dt1 != null && dt1.Rows.Count > 0)
{
//打印货架信息
Trace.WriteLine("Debug: PodId=" + dt1.Rows[0]["PodId"].ToString() +
", PodName=" + dt1.Rows[0]["PodName"].ToString() +
", Row=" + dt1.Rows[0]["Row"].ToString() +
", Column=" + dt1.Rows[0]["Column"].ToString()
);
Trace.WriteLine("Debug: ------PickAtStationLoc Start------");
dt2 = DBPCaller.ReplenishAtStationLoc(MyData.GetStationId());
Trace.WriteLine("Debug: ------PickAtStationLoc Stop------");
_dtShelf = dt2;
if (_dtShelf != null && _dtShelf.Rows.Count > 0)
{
Trace.WriteLine("Debug: StockNo=" + _dtShelf.Rows[0]["StockNo"].ToString() +
", PodId=" + _dtShelf.Rows[0]["PodId"].ToString() +
", ShelfId=" + _dtShelf.Rows[0]["ShelfId"].ToString() +
", BoxId=" + _dtShelf.Rows[0]["BoxId"].ToString() +
", MaterialId=" + _dtShelf.Rows[0]["MaterialId"].ToString() +
", MaterialName=" + _dtShelf.Rows[0]["MaterialName"].ToString() +
", BoxBarcode=" + _dtShelf.Rows[0]["BoxBarcode"].ToString() +
", HoderId=" + _dtShelf.Rows[0]["HoderId"].ToString() +
", PodSide=" + _dtShelf.Rows[0]["PodSide"].ToString()
);
}
if (runFlag)
{
Trace.WriteLine("Debug: ------RefreshUI Ready Start------");
RefreshUI(int.Parse(dt1.Rows[0]["Row"].ToString()), int.Parse(dt1.Rows[0]["Column"].ToString()), _dtShelf);
Trace.WriteLine("Debug: ------RefreshUI Ready Stop------");
}
}
else
{
if (runFlag)
{
Trace.WriteLine("Debug: ------RefreshUI Ready Start------");
RefreshUI(0, 0, null);
Trace.WriteLine("Debug: ------RefreshUI Ready Stop------");
}
}
}
catch (Exception ex)
{
Log.Error("RefreshUI:" + ex.Message);
//ShowHint("RefreshUI:" + ex.Message, Color.Red);
}
}
