Exemplo n.º 1
0
 //取得[合約編號] 與[履歷版本]
 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;
     }
 }
Exemplo n.º 2
0
 //檢查是否已正常結帳
 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;
     }
 }
Exemplo n.º 3
0
        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;
        }