public void AddNewSeries(JObject requestValue, JToken Data, MESStationReturn StationReturn)
{
//CUSTOMER_ID,SERIES_NAME,DESCRIPTION
if (Data == null || string.IsNullOrEmpty(Data["SERIES_NAME"].ToString()))
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara = new List <Object>()
{
"Series"
};
StationReturn.Data = null;
return;
}
OleExec sfcdb = null;
Row_C_SERIES c_series = null;
OleDbParameter[] paras = null;
string sql = null;
string customerName = Data["CUSTOMER_NAME"].ToString();
string seriesName = Data["SERIES_NAME"].ToString();
try
{
sfcdb = DBPools["SFCDB"].Borrow();
c_series = (Row_C_SERIES) new T_C_SERIES(sfcdb, DB_TYPE_ENUM.Oracle).NewRow();
//c_series.ID = GetNextId(sfcdb);//GetNewId
c_series.ID = new T_C_SERIES(sfcdb, DB_TYPE_ENUM.Oracle).GetNewID(this.BU, sfcdb);
string CustomerID = new T_C_CUSTOMER(sfcdb, DB_TYPE_ENUM.Oracle).GetCustomerID(sfcdb, BU, customerName);
if (string.IsNullOrEmpty(CustomerID))
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara = new List <Object>()
{
"Customer"
};
StationReturn.Data = Data["CUSTOMER_Name"].ToString();
return;
}
if (new T_C_SERIES(sfcdb, DB_TYPE_ENUM.Oracle).isExist(sfcdb, seriesName, CustomerID))
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000008";
StationReturn.MessagePara = new List <Object>()
{
"SERIES_NAME"
};
StationReturn.Data = seriesName;
return;
}
c_series.CUSTOMER_ID = CustomerID;
c_series.SERIES_NAME = seriesName;
c_series.DESCRIPTION = Data["DESCRIPTION"].ToString();
c_series.EDIT_EMP = this.LoginUser.EMP_NO;
c_series.EDIT_TIME = this.GetDBDateTime();
sql = c_series.GetInsertString(DB_TYPE_ENUM.Oracle);
sfcdb.ExecuteNonQuery(sql, CommandType.Text, paras);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000002";
StationReturn.Data = null;
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
}
catch (Exception ex)
{
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
throw ex;
}
}
public void UpdateSeries(JObject requestValue, JToken Data, MESStationReturn StationReturn)
{
if (Data == null)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara = new List <Object>()
{
"Series"
};
StationReturn.Data = null;
return;
}
string serieid = Data["ID"].ToString();
if (string.IsNullOrEmpty(serieid))
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara = new List <Object>()
{
"SeriesID"
};
StationReturn.Data = null;
return;
}
OleExec sfcdb = null;
Row_C_SERIES c_series = null;
string sql = null;
string seriesName = Data["SERIES_NAME"].ToString();
try
{
sfcdb = DBPools["SFCDB"].Borrow();
c_series = (Row_C_SERIES) new T_C_SERIES(sfcdb, DB_TYPE_ENUM.Oracle).GetObjByID(serieid, sfcdb);
if (c_series == null)
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000007";
StationReturn.MessagePara = new List <Object>()
{
"Series"
};
StationReturn.Data = null;
return;
}
string CustomerID = new T_C_CUSTOMER(sfcdb, DB_TYPE_ENUM.Oracle).GetCustomerID(sfcdb, BU, Data["CUSTOMER_NAME"].ToString());
if (string.IsNullOrEmpty(CustomerID))
{
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.MessageCode = "MES00000006";
StationReturn.MessagePara = new List <Object>()
{
"Customer"
};
StationReturn.Data = Data["CUSTOMER_Name"].ToString();
return;
}
c_series.ID = serieid;
c_series.CUSTOMER_ID = CustomerID;
c_series.SERIES_NAME = seriesName;
c_series.DESCRIPTION = Data["DESCRIPTION"].ToString();
c_series.EDIT_EMP = this.LoginUser.EMP_NO;
c_series.EDIT_TIME = this.GetDBDateTime();
sql = c_series.GetUpdateString(DB_TYPE_ENUM.Oracle);
sfcdb.ExecuteNonQuery(sql, CommandType.Text);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000003";
StationReturn.Data = c_series.GetDataObject();
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
}
catch (Exception ex)
{
if (sfcdb != null)
{
this.DBPools["SFCDB"].Return(sfcdb);
}
throw ex;
}
}
public void DeleteSeriesById(JObject requestValue, JToken Data, MESStationReturn StationReturn)
{
OleExec sfcdb = null;
string DeleteSql = "";
string strid = "";
T_C_SERIES DeleteInformation;
Newtonsoft.Json.Linq.JArray seriesId = (Newtonsoft.Json.Linq.JArray)Data["ID"];
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
sfcdb.BeginTrain();
DeleteInformation = new T_C_SERIES(sfcdb, DBTYPE);
for (int i = 0; i < seriesId.Count; i++)
{
strid = seriesId[i].ToString();
Row_C_SERIES row = (Row_C_SERIES)DeleteInformation.GetObjByID(strid, sfcdb);
DeleteSql += row.GetDeleteString(DBTYPE) + ";\n";
}
DeleteSql = "begin\n" + DeleteSql + "end;";
sfcdb.ExecSQL(DeleteSql);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.MessageCode = "MES00000004";
sfcdb.CommitTrain();
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
sfcdb.RollbackTrain();
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
//string seriesId = Data["SeriesId"].ToString();
//if (string.IsNullOrEmpty(seriesId))
//{
// StationReturn.Status = StationReturnStatusValue.Fail;
// StationReturn.MessageCode = "MES00000006";
// StationReturn.MessagePara = new List<Object>() { "Series" };
// StationReturn.Data = null;
// return;
//}
//OleExec sfcdb = DBPools["SFCDB"].Borrow();
//Row_C_SERIES c_series = (Row_C_SERIES) new T_C_SERIES(sfcdb, DB_TYPE_ENUM.Oracle).NewRow();
//string[] ids = seriesId.Split(',');
//try
//{
// sfcdb.BeginTrain();
// string deleteString = null;
// foreach (string id in ids)
// {
// deleteString = c_series.GetDeleteString(DB_TYPE_ENUM.Oracle, id);
// sfcdb.ExecuteNonQuery(deleteString, CommandType.Text, null);
// }
// sfcdb.CommitTrain();
//}
//catch (Exception ex)
//{
// sfcdb.RollbackTrain();
// if (sfcdb != null) this.DBPools["SFCDB"].Return(sfcdb);
// throw ex;
//}
//StationReturn.Status = StationReturnStatusValue.Pass;
//StationReturn.MessageCode = "MES00000004";
//StationReturn.Data = "";
//if (sfcdb != null) this.DBPools["SFCDB"].Return(sfcdb);
}
