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;
}
}
