public bool InsertUpdateDeleteJobEntry(ENT.JobEntry objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteJobEntry";
sqlCMD.Parameters.AddWithValue("@JobID", objENT.JobID);
sqlCMD.Parameters.AddWithValue("@JobNo", objENT.JobNo);
sqlCMD.Parameters.AddWithValue("@JobFurnaceNo", objENT.JobFurnaceNo);
sqlCMD.Parameters.AddWithValue("@StartTime", objENT.StartTime);
sqlCMD.Parameters.AddWithValue("@EndTime", objENT.EndTime);
sqlCMD.Parameters.AddWithValue("@Pour1Time", objENT.Pour1Time);
sqlCMD.Parameters.AddWithValue("@Pour2Time", objENT.Pour2Time);
sqlCMD.Parameters.AddWithValue("@Pour3Time", objENT.Pour3Time);
sqlCMD.Parameters.AddWithValue("@Pour4Time", objENT.Pour4Time);
sqlCMD.Parameters.AddWithValue("@Pour5Time", objENT.Pour5Time);
sqlCMD.Parameters.AddWithValue("@Pour6Time", objENT.Pour6Time);
sqlCMD.Parameters.AddWithValue("@IsFinish", objENT.IsFinish);
sqlCMD.Parameters.AddWithValue("@HeatFurnaceID", objENT.HeatFurnaceID);
sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}
public bool InsertUpdateDeleteSpectroEntry(ENT.SpectroEntry objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteSpectroEntry";
sqlCMD.Parameters.AddWithValue("@SpectroID", objENT.SpectroID);
sqlCMD.Parameters.AddWithValue("@SpectroNo", objENT.SpectroNo);
sqlCMD.Parameters.AddWithValue("@KeyName", objENT.KeyName);
sqlCMD.Parameters.AddWithValue("@KeyValue", objENT.KeyValue);
sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}
public bool InsertUpdateDeleteMeterSlaveMaster(ENT.MeterSlaveMaster objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteMeterSlaveMaster";
sqlCMD.Parameters.AddWithValue("@ID", objENT.ID);
sqlCMD.Parameters.AddWithValue("@Address", objENT.Address);
sqlCMD.Parameters.AddWithValue("@DataDate", objENT.DataDate);
sqlCMD.Parameters.AddWithValue("@DataValue", objENT.DataValue);
sqlCMD.Parameters.AddWithValue("@MeterID", objENT.MeterID);
sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}
public bool InsertUpdateDeleteDeviceID(ENT.Device objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteDeviceID";
sqlCMD.Parameters.AddWithValue("@DeviceId", objENT.DeviceId);
sqlCMD.Parameters.AddWithValue("@DeviceCode", objENT.DeviceCode);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}
public bool InsertUpdateDeleteHeatStartStop(ENT.HeatStartStop objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteHeatStartStop";
sqlCMD.Parameters.AddWithValue("@HeatID", objENT.HeatID);
sqlCMD.Parameters.AddWithValue("@HeatStart", objENT.HeatStart);
sqlCMD.Parameters.AddWithValue("@HeatStop", objENT.HeatStop);
sqlCMD.Parameters.AddWithValue("@IsStop", objENT.IsStop);
sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}
public bool InsertFurnaceSwitchAPI(ENT.FurnaceSwitchParam objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteFurnaceSwitchAPI";
sqlCMD.Parameters.AddWithValue("@fur_id", objENT.fur_id);
sqlCMD.Parameters.AddWithValue("@fur_name", objENT.fur_name);
sqlCMD.Parameters.AddWithValue("@fur_no", objENT.fur_no);
sqlCMD.Parameters.AddWithValue("@fur_status", objENT.fur_status);
sqlCMD.Parameters.AddWithValue("@fur_open_time", objENT.fur_open_time);
sqlCMD.Parameters.AddWithValue("@fur_close_time", objENT.fur_close_time);
sqlCMD.Parameters.AddWithValue("@fur_entry_time", objENT.fur_entry_time);
sqlCMD.Parameters.AddWithValue("@fur_file_time", objENT.fur_file_time);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}