/// <summary>
/// 通過Id刪除
/// </summary>
/// <param name="requestValue"></param>
/// <param name="Data"></param>
/// <param name="StationReturn"></param>
public void DeleteById(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
T_C_STORAGE_ITEM TC_STORAGE_ITEM = new T_C_STORAGE_ITEM(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle);
C_STORAGE_ITEM GetC_STORAGE_ITEM = new C_STORAGE_ITEM();
string strId = Data["Id"].ToString();
GetC_STORAGE_ITEM = TC_STORAGE_ITEM.GetById(strId, sfcdb);
if (GetC_STORAGE_ITEM != null)
{
int result = TC_STORAGE_ITEM.DeleteById(strId, sfcdb);
if (result > 0)
{
StationReturn.Data = strId;
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000001";
}
else
{
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000023";
StationReturn.MessagePara.Add("C_STORAGE_ITEM");
}
}
else
{
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000007";
StationReturn.MessagePara.Add("Id:" + strId);
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception ex)
{
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000037";
StationReturn.MessagePara.Add(ex.Message);
}
}
/// <summary>
/// 添加StorageItem
/// </summary>
/// <param name="requestValue"></param>
/// <param name="Data"></param>
/// <param name="StationReturn"></param>
public void AddNewStorageItem(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JToken Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
string ItemName = Data["ItemName"].ToString().Trim();
string ItemSon = Data["ItemSon"].ToString().Trim();
string StorageCode = Data["StorageCode"].ToString().Trim();
if (ItemName.Length <= 0)
{
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara.Add("ItemName");
this.DBPools["SFCDB"].Return(sfcdb);
return;
}
if (ItemSon.Length <= 0)
{
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara.Add("ItemSon");
this.DBPools["SFCDB"].Return(sfcdb);
return;
}
if (StorageCode.Length <= 0)
{
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara.Add("StorageCode");
this.DBPools["SFCDB"].Return(sfcdb);
return;
}
T_C_STORAGE_ITEM TC_STORAGE_ITEM = new T_C_STORAGE_ITEM(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle);
T_C_STORAGE_CODE TC_STORAGE_CODE = new T_C_STORAGE_CODE(sfcdb, MESDataObject.DB_TYPE_ENUM.Oracle);
List <C_STORAGE_CODE> GetSTORAGE_CODEList = new List <C_STORAGE_CODE>();
C_STORAGE_ITEM GetSTORAGE_ITEM = new C_STORAGE_ITEM();
GetSTORAGE_CODEList = TC_STORAGE_CODE.GetByStorageCode(StorageCode, sfcdb);
if (GetSTORAGE_CODEList == null || GetSTORAGE_CODEList.Count() <= 0)
{
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000007";
StationReturn.MessagePara.Add("StorageCode:" + StorageCode);
}
else
{
GetSTORAGE_ITEM = TC_STORAGE_ITEM.GetByItemNameAndItemSonAndStorageCode(ItemName, ItemSon, StorageCode, sfcdb);
if (GetSTORAGE_ITEM != null)
{
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000008";
StationReturn.MessagePara.Add("ItemName:" + ItemName + ",ItemSon:" + ItemSon + ",StorageCode:" + StorageCode);
}
else
{
C_STORAGE_ITEM NewStorageItem = new C_STORAGE_ITEM();
NewStorageItem.ID = TC_STORAGE_ITEM.GetNewID(BU, sfcdb);
NewStorageItem.ITEM_NAME = ItemName;
NewStorageItem.ITEM_SON = ItemSon;
NewStorageItem.STORAGE_CODE = StorageCode;
NewStorageItem.EDIT_EMP = LoginUser.EMP_NO;
NewStorageItem.EDIT_TIME = GetDBDateTime();
int result = TC_STORAGE_ITEM.Add(NewStorageItem, sfcdb);
if (result > 0)
{
StationReturn.Data = NewStorageItem;
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000001";
}
else
{
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000021";
StationReturn.MessagePara.Add("C_STORAGE_ITEM");
}
}
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception ex)
{
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
StationReturn.Data = "";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000037";
StationReturn.MessagePara.Add(ex.Message);
}
}
