public void GetLineByLikeSearch(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; List <C_LINE> resultline; T_C_LINE line; string Linevalue = Data["LINE_NAME"].ToString().Trim(); try { sfcdb = this.DBPools["SFCDB"].Borrow(); line = new T_C_LINE(sfcdb, DBTYPE); resultline = line.GetLineBylike(Linevalue, sfcdb); if (resultline != null && resultline.Count > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000026"; StationReturn.Data = resultline; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000034"; } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } throw e; } }
public void GetLineByID(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; C_LINE resultline; T_C_LINE line; string LineId = Data["ID"].ToString().Trim(); try { sfcdb = this.DBPools["SFCDB"].Borrow(); line = new T_C_LINE(sfcdb, DBTYPE); resultline = line.GetLineById(LineId, sfcdb); if (resultline != null) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000026"; StationReturn.Data = resultline; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000007"; StationReturn.MessagePara.Add("Line Id:" + LineId); } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } throw e; } }
public void DeleteLine(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; T_C_LINE line; C_LINE checkLine; string deleteid = ""; Newtonsoft.Json.Linq.JArray ID = (Newtonsoft.Json.Linq.JArray)Data["ID"]; try { sfcdb = this.DBPools["SFCDB"].Borrow(); line = new T_C_LINE(sfcdb, DBTYPE); bool isallOK = true; sfcdb.BeginTrain(); for (int i = 0; i < ID.Count; i++) { deleteid = ID[i].ToString(); checkLine = line.GetLineById(deleteid, sfcdb); if (checkLine == null) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000007"; StationReturn.MessagePara.Add("Line Id:" + deleteid); isallOK = false; break; } else { int result = line.deleteById(deleteid, sfcdb); if (result <= 0) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000023"; StationReturn.MessagePara.Add("Line Id:" + deleteid); isallOK = false; break; } } } if (isallOK) { sfcdb.CommitTrain(); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000001"; } else { sfcdb.RollbackTrain(); } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } throw e; } }
public void InitLine(OleExec db) { List <string> line = new List <string>(); DataTable dt = new DataTable(); T_C_LINE S = new T_C_LINE(db, DB_TYPE_ENUM.Oracle); dt = S.GetAllLine(db); line.Add("ALL"); foreach (DataRow dr in dt.Rows) { line.Add(dr["line_name"].ToString()); } Line.ValueForUse = line; }
/// <summary> /// 獲取所有線體 /// </summary> /// <param name="requestValue"></param> /// <param name="Data"></param> /// <param name="StationReturn"></param> public void GetAllLine(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; List <C_LINE> linelist = new List <C_LINE>(); T_C_LINE line; try { sfcdb = this.DBPools["SFCDB"].Borrow(); line = new T_C_LINE(sfcdb, DBTYPE); linelist = line.GetLineData(sfcdb); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000016"; StationReturn.Data = linelist; this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }
/// <summary> /// 更新標簽顯示語言數據 /// </summary> /// <param name="requestValue"></param> /// <param name="Data"></param> /// <param name="StationReturn"></param> public void UpdateLine(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { OleExec sfcdb = null; T_C_LINE line; C_LINE newline; string ID = Data["ID"].ToString().Trim(); string LineName = Data["LINE_NAME"].ToString().Trim(); string SectionID = Data["SECTION_ID"].ToString().Trim(); string LineCode = Data["LINE_CODE"].ToString().Trim(); string LinePcas = Data["LINE_PCAS"].ToString().Trim(); string Description = Data["DESCRIPTION"].ToString().Trim(); try { if (ID.Length <= 0) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("ID"); return; } if (LineName.Length <= 0) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("LineName"); return; } if (SectionID.Length <= 0) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("SectionID"); return; } if (LineCode.Length <= 0) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("LineCode"); return; } if (LinePcas.Length <= 0) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara.Add("LinePcas"); return; } sfcdb = this.DBPools["SFCDB"].Borrow(); line = new T_C_LINE(sfcdb, DBTYPE); newline = line.GetByLineName(LineName, sfcdb); if (newline != null && newline.ID != ID) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000008"; StationReturn.MessagePara.Add(LineName); } else { newline = new C_LINE(); newline.ID = ID; newline.LINE_NAME = LineName; newline.SECTION_ID = SectionID; newline.LINE_CODE = LineCode; newline.LINE_PCAS = LinePcas; newline.DESCRIPTION = Description; newline.EDIT_EMP = LoginUser.EMP_NO; newline.EDIT_TIME = GetDBDateTime(); int result = line.Update(newline, sfcdb); if (result > 0) { StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "MES00000003"; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000025"; StationReturn.MessagePara.Add(LineName); } } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }