/// <summary>
/// Update Class Time
/// </summary>
/// <param name="requestValue"></param>
/// <param name="Data"></param>
/// <param name="StationReturn"></param>
public void UpdateClassTime(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
string strRet = "";
OleExec sfcdb = this.DBPools["SFCDB"].Borrow();
T_C_CLASS_TIME classTime = new T_C_CLASS_TIME(sfcdb, DB_TYPE_ENUM.Oracle);
Row_C_CLASS_TIME row = (Row_C_CLASS_TIME)classTime.NewRow();
row = (Row_C_CLASS_TIME)classTime.GetObjByID(Data["ID"].ToString().Trim(), sfcdb, DB_TYPE_ENUM.Oracle);
row.WORK_SECTION = Data["WORK_SECTION"].ToString().Trim();
row.START_TIME = Data["START_TIME"].ToString().Trim();
row.END_TIME = Data["END_TIME"].ToString().Trim();
if (Data["DAY_DISTINCT"].ToString().Trim() == ("Shift1"))
{
row.WORK_CLASS = ((int)WORK_CLASS.Shift1).ToString();
row.DAY_DISTINCT = WORK_CLASS.Shift1.ToString();
}
else
{
row.WORK_CLASS = ((int)WORK_CLASS.Shift2).ToString();
row.DAY_DISTINCT = WORK_CLASS.Shift2.ToString();
}
row.EDIT_EMP = this.LoginUser;
row.EDIT_TIME = DateTime.Now;
strRet = sfcdb.ExecSQL(row.GetUpdateString(DB_TYPE_ENUM.Oracle));
try
{
int rows = int.Parse(strRet);
sfcdb.CommitTrain();
StationReturn.Status = "PASS";
StationReturn.Message = "OK,Update Class Time OK!";
StationReturn.data = rows;
}
catch
{
sfcdb.RollbackTrain();
StationReturn.Status = "FAIL";
StationReturn.Message = strRet;
StationReturn.data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
/// <summary>
/// Deploy New Class Time Row
/// </summary>
/// <param name="requestValue"></param>
/// <param name="Data"></param>
/// <param name="StationReturn"></param>
public void DeployNewClassTime(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
MESException exception = new MESException("");
string[] msg = new string[1];
if (string.IsNullOrEmpty(Data["WORK_SECTION"].ToString()))
{
//msg[0] = "Please Input Work Section";
//throw exception.GetMESException("", "", msg);
throw new Exception("Please Input Work Section");
}
if (string.IsNullOrEmpty(Data["START_TIME"].ToString()))
{
throw new Exception("Please Input Start Time");
}
if (string.IsNullOrEmpty(Data["END_TIME"].ToString()))
{
throw new Exception("Please Input End Time");
}
if (string.IsNullOrEmpty(Data["DAY_DISTINCT"].ToString()))
{
throw new Exception("Please Input Day Distinct");
}
string strRet = "";
OleExec sfcdb = this.DBPools["SFCDB"].Borrow();
T_C_CLASS_TIME classTime = new T_C_CLASS_TIME(sfcdb, DB_TYPE_ENUM.Oracle);
Row_C_CLASS_TIME r = (Row_C_CLASS_TIME)classTime.NewRow();
//r.ID = classTime.GetNewID(this.BU,sfcdb,DB_TYPE_ENUM.Oracle);
r.ID = classTime.GetNewID("HWD", sfcdb, DB_TYPE_ENUM.Oracle);
r.SEQ_NO = classTime.GetTotalRows(sfcdb) + 1;
r.WORK_SECTION = Data["WORK_SECTION"].ToString().Trim();
r.START_TIME = Data["START_TIME"].ToString().Trim();
r.END_TIME = Data["END_TIME"].ToString().Trim();
if (Data["DAY_DISTINCT"].ToString().Trim() == "Shift1")
{
r.WORK_CLASS = ((int)WORK_CLASS.Shift1).ToString();
r.DAY_DISTINCT = WORK_CLASS.Shift1.ToString();
}
else
{
r.WORK_CLASS = ((int)WORK_CLASS.Shift2).ToString();
r.DAY_DISTINCT = WORK_CLASS.Shift2.ToString();
}
r.EDIT_EMP = this.LoginUser;
r.EDIT_TIME = DateTime.Now;
strRet = sfcdb.ExecSQL(r.GetInsertString(DB_TYPE_ENUM.Oracle));
try
{
int rows = int.Parse(strRet);
sfcdb.CommitTrain();
StationReturn.Status = "PASS";
StationReturn.Message = "OK,Deploy New Class Time OK!";
StationReturn.data = rows;
}
catch
{
sfcdb.RollbackTrain();
StationReturn.Status = "FAIL";
StationReturn.Message = strRet;
StationReturn.data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
