public DataTable DN_TK_ThucTeDonVi(int Ma_dviqly, int Thang, int Nam, int ThangN1, int NamN1, int ThangN2, int NamN2, int TuNgay, int DenNgay) { DbConnection connection = _DbHelper.CreateConnection(Common.ConnectionString); connection.Open(); try { ArrayList para = new ArrayList(); para.Add(_DbHelper.CreateParam("IDMA_DVIQLY", SqlDbType.Int, Ma_dviqly)); para.Add(_DbHelper.CreateParam("ThangHT", SqlDbType.Int, Thang)); para.Add(_DbHelper.CreateParam("NamHT", SqlDbType.Int, Nam)); para.Add(_DbHelper.CreateParam("ThangN1", SqlDbType.Int, ThangN1)); para.Add(_DbHelper.CreateParam("NamN1", SqlDbType.Int, NamN1)); para.Add(_DbHelper.CreateParam("ThangN2", SqlDbType.Int, ThangN2)); para.Add(_DbHelper.CreateParam("NamN2", SqlDbType.Int, NamN2)); para.Add(_DbHelper.CreateParam("TuNgay", SqlDbType.Int, TuNgay)); para.Add(_DbHelper.CreateParam("DenNgay", SqlDbType.Int, DenNgay)); DataTable dt = _DbHelper.RunProcedureGetTable(connection, Common.DatabaseSchema + "[DN_TK_ThucTeDonVi]", para); return(dt); } catch (Exception ex) { throw new Exception(String.Format("DN_TK_ThucTeDonVi: {0}", ex.Message)); } finally { connection.Close(); } }