public void UpdateWorkClass(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { string strID = Data["CLASS_ID"].ToString().Trim(); string newClassName = Data["NEW_CLASS_NAME"].ToString().Trim(); string startTime = Data["START_TIME"].ToString().Trim(); string endTime = Data["END_TIME"].ToString().Trim(); OleExec oleDB = null; T_C_WORK_CLASS workClass = null; Row_C_WORK_CLASS workClassRow = null; if (string.IsNullOrEmpty(strID)) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("CLASS ID"); StationReturn.Data = ""; return; } if (string.IsNullOrEmpty(startTime)) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("START TIME"); StationReturn.Data = ""; return; } if (string.IsNullOrEmpty(endTime)) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("END TIME"); StationReturn.Data = ""; return; } try { oleDB = this.DBPools["SFCDB"].Borrow(); workClass = new T_C_WORK_CLASS(oleDB, DBTYPE); workClassRow = (Row_C_WORK_CLASS)workClass.NewRow(); if (!workClass.WorkClassIsExistByID(strID, oleDB)) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000007"; StationReturn.Data = ""; } else if (!string.IsNullOrEmpty(newClassName) && workClass.WorkClassIsExistByName(newClassName, oleDB)) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000008"; StationReturn.MessagePara.Add(newClassName); StationReturn.Data = ""; } else { workClassRow = (Row_C_WORK_CLASS)workClass.GetObjByID(strID, oleDB, DBTYPE); if (!string.IsNullOrEmpty(newClassName)) { workClassRow.NAME = newClassName; } if (!string.IsNullOrEmpty(startTime)) { workClassRow.START_TIME = startTime; } if (!string.IsNullOrEmpty(endTime)) { workClassRow.END_TIME = endTime; } oleDB.ThrowSqlExeception = true; oleDB.ExecSQL(workClassRow.GetUpdateString(DBTYPE)); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000003"; StationReturn.Data = ""; } this.DBPools["SFCDB"].Return(oleDB); } catch (Exception exception) { this.DBPools["SFCDB"].Return(oleDB); throw exception; } }
public void AddWorkClass(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { string className = Data["CLASS_NAME"].ToString().Trim(); string startTime = Data["START_TIME"].ToString().Trim(); string endTime = Data["END_TIME"].ToString().Trim(); bool isExist = false; OleExec oleDB = null; T_C_WORK_CLASS workClass = null; if (string.IsNullOrEmpty(className)) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("CLASS NAME"); StationReturn.Data = ""; return; } if (string.IsNullOrEmpty(startTime)) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("START TIME"); StationReturn.Data = ""; return; } if (string.IsNullOrEmpty(endTime)) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("END TIME"); StationReturn.Data = ""; return; } try { oleDB = this.DBPools["SFCDB"].Borrow(); workClass = new T_C_WORK_CLASS(oleDB, DBTYPE); if (workClass.WorkClassIsExistByName(className, oleDB)) { StationReturn.MessagePara.Add(className); isExist = true; } if (workClass.TimeIsExist(startTime, oleDB)) { StationReturn.MessagePara.Add(startTime); isExist = true; } if (workClass.TimeIsExist(endTime, oleDB)) { StationReturn.MessagePara.Add(endTime); isExist = true; } if (isExist) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000008"; StationReturn.Data = ""; } else { Row_C_WORK_CLASS workClassRow = (Row_C_WORK_CLASS)workClass.NewRow(); workClassRow.ID = workClass.GetNewID(this.BU, oleDB, DBTYPE); workClassRow.NAME = className; workClassRow.START_TIME = startTime; workClassRow.END_TIME = endTime; oleDB.ThrowSqlExeception = true; oleDB.ExecSQL(workClassRow.GetInsertString(DBTYPE)); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000002"; StationReturn.Data = ""; } this.DBPools["SFCDB"].Return(oleDB); } catch (Exception exctption) { this.DBPools["SFCDB"].Return(oleDB); throw exctption; } }