public void DeleteCSkuDetail(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_SKU_DETAIL cSkuDetail = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
cSkuDetail = new T_C_SKU_DETAIL(sfcdb, DB_TYPE_ENUM.Oracle);
int strRet = cSkuDetail.DeleteSkuDetail((Data["ID"].ToString()).Trim(), sfcdb);
if (strRet > 0)
{
StationReturn.Message = "刪除成功！！";
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = "";
}
else
{
StationReturn.MessageCode = "MES00000036";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
public void SelectCSkuDetail(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_SKU_DETAIL cSkuDetail = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
cSkuDetail = new T_C_SKU_DETAIL(sfcdb, DB_TYPE_ENUM.Oracle);
List <C_SKU_DETAIL> list = cSkuDetail.GetSkuDetailBySkuno((Data["SKUNO"].ToString()).Trim(), sfcdb);
if (list.Count > 0)
{
StationReturn.Message = "获取成功！！";
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = list;
}
else
{
StationReturn.MessageCode = "MES00000036";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
public void AddCSkuDetail(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_SKU_DETAIL cSkuDetail = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
cSkuDetail = new T_C_SKU_DETAIL(sfcdb, DB_TYPE_ENUM.Oracle);
Row_C_SKU_DETAIL r = (Row_C_SKU_DETAIL)cSkuDetail.NewRow();
r.ID = cSkuDetail.GetNewID(this.BU, sfcdb);
r.SKUNO = (Data["SKUNO"].ToString()).Trim();
r.CATEGORY = (Data["CATEGORY"].ToString()).Trim();
r.CATEGORY_NAME = (Data["CATEGORY_NAME"].ToString()).Trim();
r.VALUE = (Data["VALUE"].ToString()).Trim();
r.EXTEND = (Data["EXTEND"].ToString()).Trim();
r.VERSION = (Data["VERSION"].ToString()).Trim();
r.BASETEMPLATE = (Data["BASETEMPLATE"].ToString()).Trim();
r.STATION_NAME = (Data["STATION_NAME"].ToString()).Trim();
r.EDIT_EMP = this.LoginUser.EMP_NO;
r.EDIT_TIME = GetDBDateTime();
string strRet = sfcdb.ExecSQL(r.GetInsertString(DB_TYPE_ENUM.Oracle));
if (Convert.ToInt32(strRet) > 0)
{
StationReturn.Message = "添加成功！！";
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = "";
}
else
{
StationReturn.MessageCode = "MES00000036";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
