public void DeleteFactory(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec oleDB = null;
T_C_FACTORY Table = null;
string ID = string.Empty;
int result;
try
{
oleDB = this.DBPools["SFCDB"].Borrow();
Table = new T_C_FACTORY(oleDB, DBTYPE);
ID = Data["ID"].ToString().Trim();
result = Table.Delete(ID, oleDB);
if (result == 0)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "Delete success";
StationReturn.Data = new object();
}
else if (result == 1)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "Delete fail";
StationReturn.Data = new object();
}
else if (result == 2)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "Delete fail ID is empty";
StationReturn.Data = new object();
}
else if (result == 3)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000037";
StationReturn.Data = new object();
}
if (oleDB != null)
{
this.DBPools["SFCDB"].Return(oleDB);
}
}
catch (Exception e)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000037";
StationReturn.MessagePara.Add(e.Message);
StationReturn.Data = e.Message;
if (oleDB != null)
{
this.DBPools["SFCDB"].Return(oleDB);
}
}
}
public void GetAllFactory(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec oleDB = null;
T_C_FACTORY factory = null;
string FACTORY_CODE = string.Empty;
List <C_FACTORY> factoryList = new List <C_FACTORY>();
try
{
oleDB = this.DBPools["SFCDB"].Borrow();
factory = new T_C_FACTORY(oleDB, DBTYPE);
FACTORY_CODE = Data["FACTORY_CODE"].ToString().Trim().ToUpper();
factoryList = factory.GetAllFactory(FACTORY_CODE, oleDB);
if (factoryList.Count > 0)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000033";
StationReturn.MessagePara.Add(factoryList.Count);
StationReturn.Data = factoryList;
}
else
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000034";
StationReturn.Data = new object();
}
if (oleDB != null)
{
this.DBPools["SFCDB"].Return(oleDB);
}
}
catch (Exception exception)
{
this.DBPools["SFCDB"].Return(oleDB);
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Message = exception.Message;
StationReturn.Data = "";
if (oleDB != null)
{
this.DBPools["SFCDB"].Return(oleDB);
}
}
}
public void UpdateFactory(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
OleExec oleDB = null;
T_C_FACTORY Table = null;
string ID = string.Empty;
string FACTORY_CODE = string.Empty;
string FACTORY_NAME = string.Empty;
string FACTORY_ADDRESS = string.Empty;
string DESCRIPTION = string.Empty;
string EDIT_EMP = string.Empty;
int result;
try
{
oleDB = this.DBPools["SFCDB"].Borrow();
Table = new T_C_FACTORY(oleDB, DBTYPE);
ID = Data["ID"].ToString().Trim();
FACTORY_CODE = Data["FACTORY_CODE"].ToString().Trim().ToUpper();
FACTORY_NAME = Data["FACTORY_NAME"].ToString().Trim().ToUpper();
FACTORY_ADDRESS = Data["FACTORY_ADDRESS"].ToString().Trim().ToUpper();
DESCRIPTION = Data["DESCRIPTION"].ToString().Trim();
EDIT_EMP = LoginUser.EMP_NO.Trim();
result = Table.Update(ID, FACTORY_CODE, FACTORY_NAME, FACTORY_ADDRESS, DESCRIPTION, EDIT_EMP, oleDB);
if (result == 0)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "Update fail ID not exist";
StationReturn.Data = new object();
}
else if (result == 1)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "Update fail Factorycode, Factoryname, Factoryaddress existed ";
StationReturn.Data = new object();
}
else if (result == 2)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "Update success";
StationReturn.Data = new object();
}
else if (result == 3)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "Update fail";
StationReturn.Data = new object();
}
else if (result == 4)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000037";
StationReturn.Data = new object();
}
if (oleDB != null)
{
this.DBPools["SFCDB"].Return(oleDB);
}
}
catch (Exception e)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000037";
StationReturn.MessagePara.Add(e.Message);
StationReturn.Data = e.Message;
if (oleDB != null)
{
this.DBPools["SFCDB"].Return(oleDB);
}
}
}
