public void GetAllSapStationMapBySku(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
List <C_SAP_STATION_MAP> MapList = new List <C_SAP_STATION_MAP>();
T_C_SAP_STATION_MAP Table = null;
string SkuNo = string.Empty;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
Table = new T_C_SAP_STATION_MAP(sfcdb, DBTYPE);
SkuNo = Data["SkuNo"].ToString().Trim();
if (string.IsNullOrEmpty(SkuNo))
{
GetAllSapStationMaps(requestValue, Data, StationReturn);
}
else
{
MapList = Table.GetSAPStationMapBySku(SkuNo, sfcdb);
if (MapList.Count() == 0)
{
//沒有獲取到數據
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000034";
StationReturn.Data = new object();
}
else
{
//獲取成功
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000033";
StationReturn.MessagePara.Add(MapList.Count().ToString());
StationReturn.Data = MapList;
}
}
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
}
catch (Exception e)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000037";
StationReturn.MessagePara.Add(e.Message);
StationReturn.Data = e.Message;
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
}
}
/// <summary>
/// 加載對應的拋賬信息
/// </summary>
/// <param name="DB"></param>
public SKU LoadSapStationMap(OleExec DB)
{
if (!this.SkuBase.ID.Equals(""))
{
T_C_SAP_STATION_MAP table = new T_C_SAP_STATION_MAP(DB, this._DBType);
this.SapStationMaps = table.GetSAPStationMapBySku(this.SkuBase.SKUNO, DB);
return(this);
}
else
{
throw new MESReturnMessage("Please ensure the C_SKU property is not null before using other methods.");
}
}