public bool InsertHeatStartStopReport(ENT.HeatStartStopReport objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteHeatStartStopReport";
sqlCMD.Parameters.AddWithValue("@ID", objENT.ID);
sqlCMD.Parameters.AddWithValue("@LineCountStart", objENT.LineCountStart);
sqlCMD.Parameters.AddWithValue("@LineCountEnd", objENT.LineCountEnd);
sqlCMD.Parameters.AddWithValue("@StartDataTime", objENT.StartDataTime);
sqlCMD.Parameters.AddWithValue("@EndDataTime", objENT.EndDataTime);
sqlCMD.Parameters.AddWithValue("@DataValue", objENT.DataValue);
sqlCMD.Parameters.AddWithValue("@DataValue2", objENT.DataValue2);
sqlCMD.Parameters.AddWithValue("@FileName", objENT.FileName);
sqlCMD.Parameters.AddWithValue("@EntryDate", objENT.EntryDate);
sqlCMD.Parameters.AddWithValue("@isupdated", objENT.isupdated);
sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}
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("@Mode", objENT.Mode);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}
public bool InsertUpdateDeleteDeviceID(ENTITY.GI obj)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteDeviceID";
sqlCMD.Parameters.AddWithValue("@DeviceId", obj.response);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}
public bool InsertUpdateDeleteFurnaceSwitch(ENT.FurnaceSwitch objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteFurnaceSwitch";
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_file_time", objENT.fur_file_time);
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);
}