public void DeleteSkuRouteMapping(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_R_SKU_ROUTE table = null;
OleExec sfcdb = null;
string result = string.Empty;
string MappingID = string.Empty;
//MappingID = @"HWD000000000000000000000000000003";
try
{
if (Data["MappingID"] != null && !string.IsNullOrEmpty(Data["MappingID"].ToString()))
{
sfcdb = this.DBPools["SFCDB"].Borrow();
table = new T_R_SKU_ROUTE(sfcdb, DBTYPE);
MappingID = Data["MappingID"].ToString();
result = table.DeleteMapping(MappingID, sfcdb);
if (Int32.Parse(result) > 0)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000035";
StationReturn.MessagePara.Add(result);
StationReturn.Data = result;
}
else
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000036";
StationReturn.Data = result;
}
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
}
}
catch (Exception e)
{
if (!string.IsNullOrEmpty(result))
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000005";
StationReturn.Data = e.Message + ":" + result;
}
else
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000037";
StationReturn.MessagePara.Add(e.Message);
StationReturn.Data = e.Message;
}
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
throw e;
}
}
public void DeleteSkuRouteMapping(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_R_SKU_ROUTE table = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
JToken IDs = Data["MappingID"];
int counts = 0;
for (int i = 0; i < IDs.Count(); i++)
{
string result = string.Empty;
table = new T_R_SKU_ROUTE(sfcdb, DBTYPE);
result = table.DeleteMapping(IDs[i].ToString(), sfcdb);
if (Int32.Parse(result) > 0)
{
counts++;
}
}
if (counts > 0)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000035";
StationReturn.MessagePara.Add(counts);
StationReturn.Data = counts;
}
else
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000036";
StationReturn.Data = counts;
}
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);
}
}
}
public void DeleteSkuRouteMappingByObject(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_R_SKU_ROUTE table = null;
OleExec sfcdb = null;
string result = string.Empty;
R_SKU_ROUTE mapping = null;
try
{
if (Data["MappingObject"] != null && !string.IsNullOrEmpty(Data["MappingObject"].ToString()))
{
sfcdb = this.DBPools["SFCDB"].Borrow();
table = new T_R_SKU_ROUTE(sfcdb, DBTYPE);
mapping = (R_SKU_ROUTE)JsonConvert.Deserialize(Data["MappingObject"].ToString(), typeof(R_SKU_ROUTE));
result = table.DeleteMapping(mapping, sfcdb);
if (Int32.Parse(result) > 0)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000035";
StationReturn.MessagePara.Add(result);
StationReturn.Data = result;
}
else
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000036";
StationReturn.Data = result;
}
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);
}
//throw e;
}
}
