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();
}
}
