//取得[合約編號] 與[履歷版本] public DataTable GetCNT_EDIT_NO(ArrayList ParameterList) { try { VAM20_DBO DBO = new VAM20_DBO(ref USEDB); DataTable dt = DBO.GetCNT_EDIT_NO(ParameterList); return dt; } catch (Exception ex) { throw ex; } }
//檢查是否已正常結帳 public DataTable CheckData(ArrayList ParameterList) { try { VAM20_DBO DBO = new VAM20_DBO(ref USEDB); DataTable dt = DBO.CheckData(ParameterList); return dt; } catch (Exception ex) { throw ex; } }
public bool DeleteData(ArrayList ParameterList) { bool bResult = false; try { VAM20_DBO DBO = new VAM20_DBO(ref USEDB); Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); DBO.DeleteData(ParameterList, DBT); DBT.Commit(); bResult = true; } catch (Exception ex) { if (DBT != null) DBT.Rollback(); throw ex; } finally { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) Conn.Close(); } return bResult; }