public CMData GetBlockedCMDetails(Int64 queueId)
{
CMData objCMData = null;
try
{
using (OracleConnection con = new DBConnection().getDBConnection()) // DA.Connection().getDBConnection())
{
// if (con.State == System.Data.ConnectionState.Closed) con.Open();
using (OracleCommand command = con.CreateCommand())
{
string sql = "SELECT LU_ID, LU_NAME,FLOOR,ACTUAL_AISLE_MIN,ACTUAL_AISLE_MAX,VIRTUAL_AISLE_MIN,VIRTUAL_AISLE_MAX,HOME_AISLE"
+ " ,MACHINE,MACHINE_CODE,IS_BLOCKED,CHANGED_HOME_AISLE,HOME_ROW,CHANGED_HOME_ROW,STATUS,FLOOR_CM_INDEX,CM_CHANNEL,REM_CODE"
+ " FROM L2_LCM_UCM_MASTER "
+ " where BLOCK_Q_ID=" + queueId + " and rownum=1";
command.CommandText = sql;
using (OracleDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
if (reader.Read())
{
objCMData = new Model.CMData();
objCMData.cmPkId = Int32.Parse(reader["LU_ID"].ToString());
objCMData.cmName = reader["LU_NAME"].ToString();
objCMData.floor = Int32.Parse(reader["FLOOR"].ToString());
objCMData.actualAisleMin = Int32.Parse(reader["ACTUAL_AISLE_MIN"].ToString());
objCMData.actualAisleMax = Int32.Parse(reader["ACTUAL_AISLE_MAX"].ToString());
objCMData.virtualAisleMin = Int32.Parse(reader["VIRTUAL_AISLE_MIN"].ToString());
objCMData.virtualAisleMax = Int32.Parse(reader["VIRTUAL_AISLE_MAX"].ToString());
objCMData.homeAisle = Int32.Parse(reader["HOME_AISLE"].ToString());
objCMData.machine = reader["MACHINE"].ToString();
objCMData.cmChannel = reader["CM_CHANNEL"].ToString();
objCMData.machineCode = reader["MACHINE_CODE"].ToString();
objCMData.isBlocked = Int32.Parse(reader["IS_BLOCKED"].ToString()) == 1 ? true : false;
objCMData.positionAisle = Convert.ToInt32(reader["CHANGED_HOME_AISLE"]);
objCMData.homeRow = Convert.ToInt32(reader["HOME_ROW"]);
objCMData.positionRow = Convert.ToInt32(reader["CHANGED_HOME_ROW"]);
objCMData.status = Convert.ToInt32(reader["STATUS"]);
objCMData.floorCmIndex = Convert.ToInt32(reader["FLOOR_CM_INDEX"]);
objCMData.remCode = Convert.ToString(reader["REM_CODE"]);
}
}
}
}
}
}
catch (Exception errMsg)
{
}
return(objCMData);
}
public List <CMData> GetCMList()
{
List <CMData> lstCMData = null;
try
{
using (OracleConnection con = new OracleConnection(Connection.connectionString)) // DA.Connection().getDBConnection())
{
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
using (OracleCommand command = con.CreateCommand())
{
string sql = "SELECT LU_ID, MACHINE,FLOOR,MACHINE_CODE,STATUS,CM_CHANNEL,REM_CODE"
+ " FROM L2_LCM_UCM_MASTER";
command.CommandText = sql;
using (OracleDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
lstCMData = new List <CMData>();
while (reader.Read())
{
Model.CMData objCMData = new Model.CMData();
objCMData.cmPkId = Int32.Parse(reader["LU_ID"].ToString());
objCMData.cmName = reader["MACHINE"].ToString();
objCMData.floor = Int32.Parse(reader["FLOOR"].ToString());
objCMData.cmChannel = reader["CM_CHANNEL"].ToString();
objCMData.machineCode = reader["MACHINE_CODE"].ToString();
objCMData.status = Convert.ToInt32(reader["STATUS"]);
objCMData.remCode = Convert.ToString(reader["REM_CODE"]);
lstCMData.Add(objCMData);
}
}
}
}
}
}
catch (Exception errMsg)
{
MessageBox.Show(errMsg.Message);
}
return(lstCMData);
}
public List <CMData> GetCMList()
{
List <CMData> lstCMData = null;
try
{
using (OracleConnection con = new DBConnection().getDBConnection()) // DA.Connection().getDBConnection())
{
// if (con.State == System.Data.ConnectionState.Closed) con.Open();
using (OracleCommand command = con.CreateCommand())
{
string sql = "SELECT LU_ID, LU_NAME,FLOOR,ACTUAL_AISLE_MIN,ACTUAL_AISLE_MAX,VIRTUAL_AISLE_MIN,VIRTUAL_AISLE_MAX,HOME_AISLE"
+ " ,MACHINE,MACHINE_CODE,IS_BLOCKED,CHANGED_HOME_AISLE,HOME_ROW,CHANGED_HOME_ROW,STATUS,FLOOR_CM_INDEX,CM_CHANNEL,REM_CODE"
+ " FROM L2_LCM_UCM_MASTER";
command.CommandText = sql;
using (OracleDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
lstCMData = new List <CMData>();
while (reader.Read())
{
Model.CMData objCMData = new Model.CMData();
objCMData.cmPkId = Int32.Parse(reader["LU_ID"].ToString());
objCMData.cmName = reader["LU_NAME"].ToString();
objCMData.floor = Int32.Parse(reader["FLOOR"].ToString());
objCMData.actualAisleMin = Int32.Parse(reader["ACTUAL_AISLE_MIN"].ToString());
objCMData.actualAisleMax = Int32.Parse(reader["ACTUAL_AISLE_MAX"].ToString());
objCMData.virtualAisleMin = Int32.Parse(reader["VIRTUAL_AISLE_MIN"].ToString());
objCMData.virtualAisleMax = Int32.Parse(reader["VIRTUAL_AISLE_MAX"].ToString());
objCMData.homeAisle = Int32.Parse(reader["HOME_AISLE"].ToString());
objCMData.machine = reader["MACHINE"].ToString();
objCMData.cmChannel = reader["CM_CHANNEL"].ToString();
objCMData.machineCode = reader["MACHINE_CODE"].ToString();
objCMData.isBlocked = Int32.Parse(reader["IS_BLOCKED"].ToString()) == 1?true:false;
objCMData.positionAisle = Convert.ToInt32(reader["CHANGED_HOME_AISLE"]);
objCMData.homeRow = Convert.ToInt32(reader["HOME_ROW"]);
objCMData.positionRow = Convert.ToInt32(reader["CHANGED_HOME_ROW"]);
objCMData.status = Convert.ToInt32(reader["STATUS"]);
objCMData.floorCmIndex = Convert.ToInt32(reader["FLOOR_CM_INDEX"]);
objCMData.remCode = Convert.ToString(reader["REM_CODE"]);
//objCMData.collapseMachine =
//objCMData.triggerAisle =
// objCMData.triggerRow =
//objCMData.inDemoMode =
// objCMData.defaultHomeAisle =
//objCMData.isPalletPresent =
lstCMData.Add(objCMData);
}
}
}
}
}
}
catch (Exception errMsg)
{
}
return(lstCMData);
}
