public void GetLockInfo(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn) { string type = Data["Type"].ToString().ToUpper(); string status = Data["Status"].ToString(); List <string> snList = new List <string>(); OleExec sfcdb = null; List <R_SN_LOCK> lockList = new List <R_SN_LOCK>(); try { sfcdb = this.DBPools["SFCDB"].Borrow(); sfcdb.ThrowSqlExeception = true; T_R_SN_LOCK t_r_sn_lock = new T_R_SN_LOCK(sfcdb, DBTYPE); if (status.ToUpper() == "ALL") { status = ""; } if (type == "BYWO") { lockList = t_r_sn_lock.GetLockList("", "", "", Data["Data"].ToString(), status, sfcdb); } else if (type == "BYLOT") { lockList = t_r_sn_lock.GetLockList("", Data["Data"].ToString(), "", "", status, sfcdb); } else if (type == "BYSN") { Newtonsoft.Json.Linq.JArray arraySN = (Newtonsoft.Json.Linq.JArray)Data["Data"]; for (int i = 0; i < arraySN.Count; i++) { lockList.AddRange(t_r_sn_lock.GetLockList("", "", arraySN[i].ToString(), "", status, sfcdb)); } } else if (type == "BYID") { Newtonsoft.Json.Linq.JArray arraySN = (Newtonsoft.Json.Linq.JArray)Data["Data"]; for (int i = 0; i < arraySN.Count; i++) { lockList.AddRange(t_r_sn_lock.GetLockList(arraySN[i].ToString(), "", "", "", status, sfcdb)); } } this.DBPools["SFCDB"].Return(sfcdb); StationReturn.Data = lockList; StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000001"; } catch (Exception exception) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.MessagePara.Add(exception.Message); StationReturn.Data = exception.Message; if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } } }
public void SelectRSnLock(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { T_R_SN_LOCK LOCK = null; OleExec sfcdb = null; try { sfcdb = this.DBPools["SFCDB"].Borrow(); LOCK = new T_R_SN_LOCK(sfcdb, DB_TYPE_ENUM.Oracle); List <R_SN_LOCK> list = LOCK.GetLockList((Data["LOCK_LOT"].ToString()).Trim(), (Data["SN"].ToString()).Trim(), (Data["WORKORDERNO"].ToString()).Trim(), sfcdb); if (list.Count > 0) { StationReturn.Message = "获取成功!!"; StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Data = list; } else { StationReturn.MessageCode = "MES00000036"; StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Data = ""; } this.DBPools["SFCDB"].Return(sfcdb); } catch (Exception e) { this.DBPools["SFCDB"].Return(sfcdb); throw e; } }