/// <summary>
/// 查询机组鞍座数据信息(true 为出口，false 为入口)
/// </summary>bool flag
/// <param name="flag">true 为出口;false 为入口</param>
public void getUnitSaddleData()
{
// string sql = null;
try
{
//if (flag == true)
//{
// sql = @"SELECT a.SADDLE_NO,a.SADDLE_NAME,a.X_CENTER,a.Y_CENTER,a.Z_CENTER,a.SADDLE_WIDTH,a.SADDLE_LENGTH,b.TAG_ISEMPTY,b.TAG_LOCK_REQUEST,b.TAG_ISLOCKED,c.COIL_NO FROM
// UACS_YARDMAP_SADDLE_DEFINE a
// inner join UACS_LINE_SADDLE_DEFINE b on a.SADDLE_NO = b.STOCK_NO
// inner join UACS_LINE_EXIT_L2INFO c ON b.UNIT_NO = c.UNIT_NO and b.SADDLE_L2NAME = c.SADDLE_L2NAME
// inner join UACS_YARDMAP_SADDLE_STOCK d ON a.SADDLE_NO = d.SADDLE_NO
// inner join UACS_YARDMAP_STOCK_DEFINE e ON e.STOCK_NO = d.STOCK_NO
// WHERE a.COL_ROW_NO LIKE '" + bayNo + "%' and e.BAY_NO = '" + myBayNo + "'";
// //数据存在问题 需要过滤
// //sql += " AND a.SADDLE_NO != 'D271VC1A02' AND a.SADDLE_NO != 'D271VC1A03' ";
//}
//else if (flag == false)
//{
// sql = @"SELECT a.SADDLE_NO,a.SADDLE_NAME,a.X_CENTER,a.Y_CENTER,a.Z_CENTER,a.SADDLE_WIDTH,a.SADDLE_LENGTH,b.TAG_ISEMPTY,b.TAG_LOCK_REQUEST,b.TAG_ISLOCKED,c.COIL_NO FROM UACS_YARDMAP_SADDLE_DEFINE a
// inner join UACS_LINE_SADDLE_DEFINE b on a.SADDLE_NO = b.STOCK_NO
// inner join UACS_LINE_ENTRY_L2INFO c ON b.UNIT_NO = c.UNIT_NO and b.SADDLE_L2NAME = c.SADDLE_L2NAME
// inner join UACS_YARDMAP_SADDLE_STOCK d ON a.SADDLE_NO = d.SADDLE_NO
// inner join UACS_YARDMAP_STOCK_DEFINE e ON e.STOCK_NO = d.STOCK_NO
// WHERE a.COL_ROW_NO LIKE '" + bayNo + "%' and e.BAY_NO = '" + myBayNo + "'";
// //数据存在问题 需要过滤
// // sql += " AND a.SADDLE_NO != 'D271VR1A03' ";
//}
string sql = "SELECT T.STOCK_NO, T.STOCK_TYPE, T.STOCK_SEQ, T.LOCATION, T.STOCK_STATUS, T.ENABLE, T.X, T.Y, T.Z,T.AREA_NO, T.STOCK_LENGTH,T1.MAT_NO_1, T1.MAT_NO_2,T2.WIDTH FROM UACS_YARDMAP_TRAIN_STOCK_DEFINE T LEFT JOIN UACS_LINE_EXIT_INFO T1 ON T.STOCK_NO = T1.STOCK_NO LEFT JOIN UACS_YARDMAP_SLAB T2 ON T1.MAT_NO_1 = T2.COIL_NO WHERE STOCK_TYPE = 'UNIT'";
using (IDataReader rdr = DB2Connect.DBHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
SaddleBase stockBaseInfo = new SaddleBase();
stockBaseInfo.STOCK_NO = rdr["STOCK_NO"].ToString();
stockBaseInfo.STOCK_STATUS = rdr["STOCK_STATUS"].ToString();
stockBaseInfo.AREA_NO = rdr["AREA_NO"].ToString();
stockBaseInfo.STOCK_SEQ = Convert.ToInt32(rdr["STOCK_SEQ"]);
stockBaseInfo.XCENTER = rdr["X"] == DBNull.Value?0: Convert.ToInt32(rdr["X"]);
stockBaseInfo.YCENTER = rdr["Y"] == DBNull.Value ? 0: Convert.ToInt32(rdr["Y"]);
stockBaseInfo.ZCENTER = rdr["Z"] == DBNull.Value ? 0: Convert.ToInt32(rdr["Z"]);
stockBaseInfo.STOCK_LENGTH = rdr["STOCK_LENGTH"] == DBNull.Value ? 0: Convert.ToInt32(rdr["STOCK_LENGTH"]);
stockBaseInfo.CoilNO = rdr["MAT_NO_1"].ToString();
stockBaseInfo.CoilNO1 = rdr["MAT_NO_2"].ToString();
stockBaseInfo.SaddleWidth = rdr["WIDTH"] == DBNull.Value ? 0 : Convert.ToInt32(rdr["WIDTH"]);
//SaddleBase theSaddle = new SaddleBase();
//if (rdr["SADDLE_NO"] != System.DBNull.Value)
//{
// theSaddle.SaddleNo = Convert.ToString(rdr["SADDLE_NO"]);
//}
//else
//{
// theSaddle.SaddleNo = string.Empty;
//}
//if (rdr["SADDLE_NAME"] != System.DBNull.Value)
//{
// theSaddle.SaddleName = Convert.ToString(rdr["SADDLE_NAME"]);
//}
//else
//{
// theSaddle.SaddleName = string.Empty;
//}
//if (rdr["X_CENTER"] != System.DBNull.Value)
//{
// theSaddle.X_Center = Convert.ToInt32(rdr["X_CENTER"]);
//}
//else
//{
// theSaddle.X_Center = 0;
//}
//if (rdr["Y_CENTER"] != System.DBNull.Value)
//{
// theSaddle.Y_Center = Convert.ToInt32(rdr["Y_CENTER"]);
//}
//else
//{
// theSaddle.Y_Center = 0;
//}
//if (rdr["Z_CENTER"] != System.DBNull.Value)
//{
// theSaddle.Z_Center = Convert.ToInt32(rdr["Z_CENTER"]);
//}
//else
//{
// theSaddle.Z_Center = 0;
//}
//if (rdr["SADDLE_WIDTH"] != System.DBNull.Value)
//{
// theSaddle.SaddleWidth = Convert.ToInt32(rdr["SADDLE_WIDTH"]);
//}
//else
//{
// theSaddle.SaddleWidth = 0;
//}
////if (rdr["SADDLE_NO"].ToString().Contains("C") || rdr["SADDLE_NO"].ToString().Contains("R") )
////{
//// theSaddle.SaddleLength = 800;
//// theSaddle.SaddleWidth = 1200;
////}
////else
////{
////}
//if (rdr["SADDLE_LENGTH"] != System.DBNull.Value)
//{
// theSaddle.SaddleLength = Convert.ToInt32(rdr["SADDLE_LENGTH"]);
//}
//else
//{
// theSaddle.SaddleLength = 0;
//}
//if (rdr["TAG_ISEMPTY"] != System.DBNull.Value)
//{
// theSaddle.TagAdd_IsOccupied = Convert.ToString(rdr["TAG_ISEMPTY"]);
//}
//else
//{
// theSaddle.TagAdd_IsOccupied = string.Empty;
//}
//if (rdr["TAG_LOCK_REQUEST"] != System.DBNull.Value)
//{
// theSaddle.Tag_Lock_Request = Convert.ToString(rdr["TAG_LOCK_REQUEST"]);
//}
//else
//{
// theSaddle.Tag_Lock_Request = string.Empty;
//}
//if (rdr["TAG_ISLOCKED"] != System.DBNull.Value)
//{
// theSaddle.Tag_IsLocked = Convert.ToString(rdr["TAG_ISLOCKED"]);
//}
//else
//{
// theSaddle.Tag_IsLocked = string.Empty;
//}
//if (rdr["COIL_NO"] != System.DBNull.Value)
//{
// theSaddle.CoilNO = Convert.ToString(rdr["COIL_NO"]);
//}
//else
//{
// theSaddle.CoilNO = string.Empty;
//}
dicSaddles[stockBaseInfo.STOCK_NO] = stockBaseInfo;
}
}
}
catch (Exception er)
{
throw;
}
}
public void getSaddleInfo()
{
try
{
string sql = null;
sql = @"SELECT b.STOCK_NO,b.STOCK_NAME,a.SADDLE_SEQ,a.ROW_NO,a.COL_NO,a.X_CENTER,a.Y_CENTER,a.Z_CENTER,a.SADDLE_WIDTH,a.SADDLE_LENGTH,a.LAYER_NUM,b.STOCK_STATUS,b.LOCK_FLAG,b.MAT_NO,d.PLASTIC_FLAG FROM";
sql += " UACS_YARDMAP_SADDLE_DEFINE a inner join UACS_YARDMAP_SADDLE_STOCK c on a.SADDLE_NO = c.SADDLE_NO ";
sql += " inner join UACS_YARDMAP_STOCK_DEFINE b on c.STOCK_NO = b.STOCK_NO left join UACS_YARDMAP_COIL_PLASTIC d on b.MAT_NO = d.COIL_NO";
sql += " where a.COL_ROW_NO LIKE '" + bayNo + "%' and a.X_CENTER > 0 order by b.STOCK_NO ";
using (IDataReader rdr = DB2Connect.DBHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
SaddleBase theSaddle = new SaddleBase();
if (rdr["STOCK_NO"] != System.DBNull.Value)
{
theSaddle.SaddleNo = Convert.ToString(rdr["STOCK_NO"]);
}
if (rdr["LAYER_NUM"] != System.DBNull.Value)
{
theSaddle.Layer_Num = Convert.ToInt32(rdr["LAYER_NUM"]);
}
if (rdr["STOCK_NAME"] != System.DBNull.Value)
{
theSaddle.SaddleName = Convert.ToString(rdr["STOCK_NAME"]);
}
if (rdr["SADDLE_SEQ"] != System.DBNull.Value)
{
theSaddle.Saddle_Seq = Convert.ToInt32(rdr["SADDLE_SEQ"]);
}
if (rdr["ROW_NO"] != System.DBNull.Value)
{
theSaddle.Row_No = Convert.ToInt32(rdr["ROW_NO"]);
}
if (rdr["COL_NO"] != System.DBNull.Value)
{
theSaddle.Col_No = Convert.ToInt32(rdr["COL_NO"]);
}
if (rdr["X_CENTER"] != System.DBNull.Value)
{
theSaddle.X_Center = Convert.ToInt32(rdr["X_CENTER"]);
}
if (rdr["Y_CENTER"] != System.DBNull.Value)
{
theSaddle.Y_Center = Convert.ToInt32(rdr["Y_CENTER"]);
}
if (rdr["Z_CENTER"] != System.DBNull.Value)
{
theSaddle.Z_Center = Convert.ToInt32(rdr["Z_CENTER"]);
}
if (rdr["STOCK_STATUS"] != System.DBNull.Value)
{
theSaddle.Stock_Status = Convert.ToInt32(rdr["STOCK_STATUS"]);
}
if (rdr["LOCK_FLAG"] != System.DBNull.Value)
{
theSaddle.Lock_Flag = Convert.ToInt32(rdr["LOCK_FLAG"]);
}
if (rdr["SADDLE_WIDTH"] != System.DBNull.Value)
{
//theSaddle.SaddleWidth = Convert.ToInt32(rdr["SADDLE_WIDTH"]);
}
theSaddle.SaddleWidth = 1000;
if (rdr["SADDLE_LENGTH"] != System.DBNull.Value)
{
//theSaddle.SaddleLength = Convert.ToInt32(rdr["SADDLE_LENGTH"]);
}
theSaddle.SaddleLength = 1000;
if (rdr["MAT_NO"] != System.DBNull.Value)
{
theSaddle.Mat_No = Convert.ToString(rdr["MAT_NO"]);
//theSaddle.Next_Unit_No = GetNextUnitNOByCoil(Convert.ToString(rdr["MAT_NO"]));
}
if (rdr["PLASTIC_FLAG"] != System.DBNull.Value)
{
theSaddle.Plastic_Flag = Convert.ToInt32(rdr["PLASTIC_FLAG"]);
}
dicSaddles[theSaddle.SaddleNo] = theSaddle;
}
}
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
}
/// <summary>
/// 查询机组鞍座数据信息(true 为出口，false 为入口)
/// </summary>
/// <param name="flag">true 为出口;false 为入口</param>
public void getUnitSaddleData(bool flag)
{
string sql = null;
try
{
if (flag == true)
{
sql = @"SELECT a.SADDLE_NO,a.SADDLE_NAME,a.X_CENTER,a.Y_CENTER,a.Z_CENTER,a.SADDLE_WIDTH,a.SADDLE_LENGTH,b.TAG_ISEMPTY,b.TAG_LOCK_REQUEST,b.TAG_ISLOCKED,c.COIL_NO FROM
UACS_YARDMAP_SADDLE_DEFINE a
inner join UACS_LINE_SADDLE_DEFINE b on a.SADDLE_NO = b.STOCK_NO
inner join UACS_LINE_EXIT_L2INFO c ON b.UNIT_NO = c.UNIT_NO and b.SADDLE_L2NAME = c.SADDLE_L2NAME
inner join UACS_YARDMAP_SADDLE_STOCK d ON a.SADDLE_NO = d.SADDLE_NO
inner join UACS_YARDMAP_STOCK_DEFINE e ON e.STOCK_NO = d.STOCK_NO
WHERE a.COL_ROW_NO LIKE '" + bayNo + "%' and e.BAY_NO = '" + myBayNo + "'";
//数据存在问题 需要过滤
//sql += " AND a.SADDLE_NO != 'D271VC1A02' AND a.SADDLE_NO != 'D271VC1A03' ";
}
else if (flag == false)
{
sql = @"SELECT a.SADDLE_NO,a.SADDLE_NAME,a.X_CENTER,a.Y_CENTER,a.Z_CENTER,a.SADDLE_WIDTH,a.SADDLE_LENGTH,b.TAG_ISEMPTY,b.TAG_LOCK_REQUEST,b.TAG_ISLOCKED,c.COIL_NO FROM UACS_YARDMAP_SADDLE_DEFINE a
inner join UACS_LINE_SADDLE_DEFINE b on a.SADDLE_NO = b.STOCK_NO
inner join UACS_LINE_ENTRY_L2INFO c ON b.UNIT_NO = c.UNIT_NO and b.SADDLE_L2NAME = c.SADDLE_L2NAME
inner join UACS_YARDMAP_SADDLE_STOCK d ON a.SADDLE_NO = d.SADDLE_NO
inner join UACS_YARDMAP_STOCK_DEFINE e ON e.STOCK_NO = d.STOCK_NO
WHERE a.COL_ROW_NO LIKE '" + bayNo + "%' and e.BAY_NO = '" + myBayNo + "'";
//数据存在问题 需要过滤
// sql += " AND a.SADDLE_NO != 'D271VR1A03' ";
}
using (IDataReader rdr = DB2Connect.DBHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
SaddleBase theSaddle = new SaddleBase();
if (rdr["SADDLE_NO"] != System.DBNull.Value)
{
theSaddle.SaddleNo = Convert.ToString(rdr["SADDLE_NO"]);
}
else
{
theSaddle.SaddleNo = string.Empty;
}
if (rdr["SADDLE_NAME"] != System.DBNull.Value)
{
theSaddle.SaddleName = Convert.ToString(rdr["SADDLE_NAME"]);
}
else
{
theSaddle.SaddleName = string.Empty;
}
if (rdr["X_CENTER"] != System.DBNull.Value)
{
theSaddle.X_Center = Convert.ToInt32(rdr["X_CENTER"]);
}
else
{
theSaddle.X_Center = 0;
}
if (rdr["Y_CENTER"] != System.DBNull.Value)
{
theSaddle.Y_Center = Convert.ToInt32(rdr["Y_CENTER"]);
}
else
{
theSaddle.Y_Center = 0;
}
if (rdr["Z_CENTER"] != System.DBNull.Value)
{
theSaddle.Z_Center = Convert.ToInt32(rdr["Z_CENTER"]);
}
else
{
theSaddle.Z_Center = 0;
}
if (rdr["SADDLE_WIDTH"] != System.DBNull.Value)
{
theSaddle.SaddleWidth = Convert.ToInt32(rdr["SADDLE_WIDTH"]);
}
else
{
theSaddle.SaddleWidth = 0;
}
//if (rdr["SADDLE_NO"].ToString().Contains("C") || rdr["SADDLE_NO"].ToString().Contains("R") )
//{
// theSaddle.SaddleLength = 800;
// theSaddle.SaddleWidth = 1200;
//}
//else
//{
//}
if (rdr["SADDLE_LENGTH"] != System.DBNull.Value)
{
theSaddle.SaddleLength = Convert.ToInt32(rdr["SADDLE_LENGTH"]);
}
else
{
theSaddle.SaddleLength = 0;
}
if (rdr["TAG_ISEMPTY"] != System.DBNull.Value)
{
theSaddle.TagAdd_IsOccupied = Convert.ToString(rdr["TAG_ISEMPTY"]);
}
else
{
theSaddle.TagAdd_IsOccupied = string.Empty;
}
if (rdr["TAG_LOCK_REQUEST"] != System.DBNull.Value)
{
theSaddle.Tag_Lock_Request = Convert.ToString(rdr["TAG_LOCK_REQUEST"]);
}
else
{
theSaddle.Tag_Lock_Request = string.Empty;
}
if (rdr["TAG_ISLOCKED"] != System.DBNull.Value)
{
theSaddle.Tag_IsLocked = Convert.ToString(rdr["TAG_ISLOCKED"]);
}
else
{
theSaddle.Tag_IsLocked = string.Empty;
}
if (rdr["COIL_NO"] != System.DBNull.Value)
{
theSaddle.CoilNO = Convert.ToString(rdr["COIL_NO"]);
}
else
{
theSaddle.CoilNO = string.Empty;
}
dicSaddles[theSaddle.SaddleNo] = theSaddle;
}
}
}
catch (Exception er)
{
throw;
}
}
