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