public string DeleteSAPStationMap(string ID, OleExec sfcdb) { string result = string.Empty; string DeleteString = string.Empty; Row_C_SAP_STATION_MAP row = (Row_C_SAP_STATION_MAP)NewRow(); string sql = string.Empty; DataTable dt = new DataTable(); if (DBType.Equals(DB_TYPE_ENUM.Oracle)) { sql = $@"SELECT * FROM C_SAP_STATION_MAP WHERE ID='{ID}'"; dt = sfcdb.ExecSelect(sql).Tables[0]; if (dt.Rows.Count > 0) { row.loadData(dt.Rows[0]); DeleteString = row.GetDeleteString(DBType); result = sfcdb.ExecSQL(DeleteString); } else { result = "0"; } } else { string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() }); throw new MESReturnMessage(errMsg); } return(result); }
/// <summary> /// 增、刪、改 SAP 與 站位的映射 /// </summary> /// <param name="Map"></param> /// <param name="Operation"></param> /// <param name="Bu"></param> /// <param name="DB"></param> /// <returns></returns> public string UpdateSAPStationMap(C_SAP_STATION_MAP Map, string Operation, string Bu, OleExec DB) { string sql = string.Empty; string result = string.Empty; Row_C_SAP_STATION_MAP row = (Row_C_SAP_STATION_MAP)NewRow(); T_C_SAP_STATION_MAP table = new T_C_SAP_STATION_MAP(DB, DBType); if (DBType.Equals(DB_TYPE_ENUM.Oracle)) { if (Map.ID != null && !Map.ID.Equals("")) { row = (Row_C_SAP_STATION_MAP)GetObjByID(Map.ID, DB); } row.SKUNO = Map.SKUNO; row.STATION_NAME = Map.STATION_NAME; row.WORKORDER_TYPE = Map.WORKORDER_TYPE; row.SAP_STATION_CODE = Map.SAP_STATION_CODE; row.EDIT_EMP = Map.EDIT_EMP; row.EDIT_TIME = Map.EDIT_TIME; switch (Operation.ToUpper()) { case "ADD": row.ID = GetNewID(Bu, DB); sql = row.GetInsertString(DBType); break; case "UPDATE": sql = row.GetUpdateString(DBType); break; case "DELETE": sql = row.GetDeleteString(DBType); break; default: sql = $@"SELECT * FROM C_SAP_STATION_MAP"; break; } result = DB.ExecSQL(sql); } else { string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() }); throw new MESReturnMessage(errMsg); } return(result); }