public List <C_SKU_DETAIL> GetSkuDetailBySkuno(string skuno, OleExec DB) { List <C_SKU_DETAIL> SkuDetails = new List <C_SKU_DETAIL>(); string sql = string.Empty; DataTable dt = new DataTable("AllSkuDetail"); 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 "; if (skuno == "") { sql += $@" rownum<21 order by EDIT_TIME DESC "; } else { sql += $@" SKUNO='{skuno}' ORDER BY EDIT_TIME DESC "; } dt = DB.ExecSelect(sql, null).Tables[0]; foreach (DataRow dr in dt.Rows) { SkuDetailRow.loadData(dr); SkuDetails.Add(SkuDetailRow.GetDataObject()); } } else { string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() }); throw new MESReturnMessage(errMsg); } return(SkuDetails); }
public Row_C_SKU_DETAIL getC_SKU_DETAILbyID(string id, OleExec DB) { string strSql = $@" SELECT * FROM C_SKU_DETAIL where ID='{id}' "; DataSet res = DB.ExecSelect(strSql); if (res.Tables[0].Rows.Count > 0) { Row_C_SKU_DETAIL ret = (Row_C_SKU_DETAIL)NewRow(); ret.loadData(res.Tables[0].Rows[0]); return(ret); } else { return(null); } }
/// <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); }