public void GetWoInfo(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
sfcdb.ThrowSqlExeception = true;
T_R_WO_BASE t_r_wo_base = new T_R_WO_BASE(sfcdb, DBTYPE);
R_WO_BASE r_wo_base = t_r_wo_base.GetWoByWoNo(Data["WO"].ToString().ToUpper().Trim(), sfcdb);
if (r_wo_base == null)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000164", new string[] { Data["WO"].ToString().ToUpper().Trim() }));
}
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Data = r_wo_base;
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 WOBase(string wo, OleExec sfcdb)
{
T_R_WO_BASE TR_WO_BASE = new T_R_WO_BASE(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle);
WO = TR_WO_BASE.GetWoByWoNo(wo, sfcdb);
if (WO == null)
{
throw new Exception("工單 " + wo + " 不存在！");
}
else
{
if (WO.SKUNO == null || WO.SKUNO.Trim().Length <= 0)
{
throw new Exception("工單 " + wo + " 未配置機種！");
}
_SAPMapping = new SAPMappingBase(WO.SKUNO, sfcdb);
if (WO.ROUTE_ID == null || WO.ROUTE_ID.Trim().Length <= 0)
{
throw new Exception("工單 " + wo + " 未配置路由ID！");
}
_Route = new RouteBase(WO.ROUTE_ID.Trim(), sfcdb);
}
}
public void GetSNDetailByWo(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
sfcdb.ThrowSqlExeception = true;
T_R_WO_BASE t_r_wo_base = new T_R_WO_BASE(sfcdb, DBTYPE);
R_WO_BASE r_wo_base = t_r_wo_base.GetWoByWoNo(Data["WO"].ToString().ToUpper().Trim(), sfcdb);
if (r_wo_base == null)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000164", new string[] { Data["WO"].ToString().ToUpper().Trim() }));
}
T_R_SN t_r_sn = new T_R_SN(sfcdb, DBTYPE);
List <R_SN> snList = t_r_sn.GetRSNbyWo(Data["WO"].ToString().ToUpper().Trim(), sfcdb).FindAll(sn => sn.CURRENT_STATION.IndexOf("LOADING") >= 0);
if (snList.Count == 0)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MSGCODE20180731133844", new string[] { Data["WO"].ToString().ToUpper().Trim() }));
}
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Data = snList;
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 CutWoBySNId(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
try
{
string wo = Data["WO"].ToString().ToUpper().Trim();
string closeFlag = Data["CLOSEFLAG"].ToString().ToUpper().Trim();
Newtonsoft.Json.Linq.JArray arrayId = (Newtonsoft.Json.Linq.JArray)Data["ID"];
sfcdb = this.DBPools["SFCDB"].Borrow();
sfcdb.ThrowSqlExeception = true;
T_R_WO_BASE t_r_wo_base = new T_R_WO_BASE(sfcdb, DBTYPE);
R_WO_BASE r_wo_base = t_r_wo_base.GetWoByWoNo(wo, sfcdb);
if (r_wo_base == null)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000164", new string[] { wo }));
}
T_R_SN t_r_sn = new T_R_SN(sfcdb, DBTYPE);
Row_R_SN rowSN;
for (int i = 0; i < arrayId.Count; i++)
{
rowSN = (Row_R_SN)t_r_sn.GetObjByID(arrayId[i].ToString(), sfcdb);
rowSN.SN = "CUT_" + rowSN.SN;
rowSN.WORKORDERNO = "CUT_" + rowSN.WORKORDERNO;
rowSN.SKUNO = "CUT_" + rowSN.SKUNO;
rowSN.EDIT_EMP = LoginUser.EMP_NO;
rowSN.EDIT_TIME = GetDBDateTime();
sfcdb.ExecSQL(rowSN.GetUpdateString(DBTYPE));
}
Row_R_WO_BASE rowWoBase = (Row_R_WO_BASE)t_r_wo_base.GetObjByID(r_wo_base.ID, sfcdb);
rowWoBase.WORKORDER_QTY = r_wo_base.WORKORDER_QTY - Convert.ToDouble(arrayId.Count);
rowWoBase.INPUT_QTY = r_wo_base.INPUT_QTY - Convert.ToDouble(arrayId.Count);
rowWoBase.EDIT_EMP = LoginUser.EMP_NO;
rowWoBase.EDIT_TIME = GetDBDateTime();
if (closeFlag == "1")
{
rowWoBase.CLOSED_FLAG = closeFlag;
rowWoBase.CLOSE_DATE = GetDBDateTime();
}
sfcdb.ExecSQL(rowWoBase.GetUpdateString(DBTYPE));
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Data = r_wo_base;
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000210";
StationReturn.MessagePara.Add(wo);
StationReturn.MessagePara.Add(arrayId.Count);
}
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 CutWoByNum(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn)
{
string wo = Data["WO"].ToString().ToUpper().Trim();
string closeFlag = Data["CLOSEFLAG"].ToString().ToUpper().Trim();
double num = 0;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
sfcdb.ThrowSqlExeception = true;
T_R_WO_BASE t_r_wo_base = new T_R_WO_BASE(sfcdb, DBTYPE);
R_WO_BASE r_wo_base = t_r_wo_base.GetWoByWoNo(wo, sfcdb);
if (r_wo_base == null)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000164", new string[] { wo }));
}
try
{
num = Convert.ToDouble(Data["NUM"].ToString().ToUpper().Trim());
}
catch
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MSGCODE20180731151259", new string[] { Data["NUM"].ToString().ToUpper().Trim() }));
}
if (num <= 0)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MSGCODE20180731151259", new string[] { Data["NUM"].ToString().ToUpper().Trim() }));
}
if (r_wo_base.WORKORDER_QTY - r_wo_base.INPUT_QTY < num)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000208", new string[] { wo, num.ToString(), (r_wo_base.WORKORDER_QTY - r_wo_base.INPUT_QTY).ToString() }));
}
Row_R_WO_BASE rowWoBase = (Row_R_WO_BASE)t_r_wo_base.GetObjByID(r_wo_base.ID, sfcdb);
rowWoBase.WORKORDER_QTY = r_wo_base.WORKORDER_QTY - Convert.ToDouble(num);
if (closeFlag == "1")
{
rowWoBase.CLOSED_FLAG = closeFlag;
rowWoBase.CLOSE_DATE = GetDBDateTime();
}
rowWoBase.EDIT_EMP = LoginUser.EMP_NO;
rowWoBase.EDIT_TIME = GetDBDateTime();
sfcdb.ExecSQL(rowWoBase.GetUpdateString(DBTYPE));
this.DBPools["SFCDB"].Return(sfcdb);
StationReturn.Data = r_wo_base;
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000210";
StationReturn.MessagePara.Add(wo);
StationReturn.MessagePara.Add(num);
}
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);
}
}
}