public C_SKU_DETAIL GetDataObject()
{
C_SKU_DETAIL DataObject = new C_SKU_DETAIL();
DataObject.SKUNO = this.SKUNO;
DataObject.CATEGORY = this.CATEGORY;
DataObject.CATEGORY_NAME = this.CATEGORY_NAME;
DataObject.VALUE = this.VALUE;
DataObject.EXTEND = this.EXTEND;
DataObject.VERSION = this.VERSION;
DataObject.BASETEMPLATE = this.BASETEMPLATE;
DataObject.EDIT_EMP = this.EDIT_EMP;
DataObject.EDIT_TIME = this.EDIT_TIME;
DataObject.ID = this.ID;
return(DataObject);
}
/// <summary>
/// 添加或者更新一個 C_SKU_DETAIL 記錄
/// 需要傳遞一個完完整整的 C_SKU_DETAIL 對象，包括 ID
/// </summary>
/// <param name="SkuDetail"></param>
/// <param name="Bu"></param>
/// <param name="DB"></param>
/// <returns></returns>
public int AddOrUpdateSkuDetail(string Operation, C_SKU_DETAIL SkuDetail, OleExec DB)
{
Row_C_SKU_DETAIL SkuDetailRow = (Row_C_SKU_DETAIL)NewRow();
string sql = string.Empty;
int result = 0;
if (this.DBType.Equals(DB_TYPE_ENUM.Oracle))
{
if (SkuDetail != null && SkuDetail.ID != null)
{
switch (Operation.Trim().ToUpper())
{
case "ADD":
SkuDetailRow = (Row_C_SKU_DETAIL)ConstructRow(SkuDetail);
sql = SkuDetailRow.GetInsertString(this.DBType);
break;
case "UPDATE":
SkuDetailRow = (Row_C_SKU_DETAIL)GetObjByID(SkuDetail.ID, DB);
SkuDetailRow.SKUNO = SkuDetailRow.SKUNO;
SkuDetailRow.CATEGORY = SkuDetail.CATEGORY;
SkuDetailRow.CATEGORY_NAME = SkuDetail.CATEGORY_NAME;
SkuDetailRow.VALUE = SkuDetail.VALUE;
SkuDetailRow.EXTEND = SkuDetail.EXTEND;
SkuDetailRow.VERSION = SkuDetail.VERSION;
SkuDetailRow.BASETEMPLATE = SkuDetail.BASETEMPLATE;
SkuDetailRow.EDIT_EMP = SkuDetail.EDIT_EMP;
SkuDetailRow.EDIT_TIME = SkuDetail.EDIT_TIME;
sql = SkuDetailRow.GetUpdateString(this.DBType);
break;
}
result = DB.ExecSqlNoReturn(sql, null);
}
}
else
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
return(result);
}
/// <summary>
/// 根據料號，類別，類別具體項目來獲得設置在 C_SKU_DETAIL 裡面的值
/// </summary>
/// <param name="Category"></param>
/// <param name="CategoryName"></param>
/// <param name="Skuno"></param>
/// <param name="DB"></param>
/// <returns></returns>
public C_SKU_DETAIL GetSkuDetail(string Category, string CategoryName, string Skuno, OleExec DB)
{
C_SKU_DETAIL SkuDetail = null;
string sql = string.Empty;
DataTable dt = new DataTable();
Row_C_SKU_DETAIL SkuDetailRow = (Row_C_SKU_DETAIL)NewRow();
if (this.DBType.Equals(DB_TYPE_ENUM.Oracle))
{
sql = $@"SELECT * FROM C_SKU_DETAIL WHERE SKUNO='{Skuno}' AND CATEGORY='{Category}' AND CATEGORY_NAME='{CategoryName}'";
dt = DB.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
SkuDetailRow.loadData(dt.Rows[0]);
SkuDetail = SkuDetailRow.GetDataObject();
}
}
else
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
return(SkuDetail);
}