public static System.Data.DataTable mCashs_SumBrand(DateTime NgayBatDau, DateTime NgayKetThuc)
{
using (DbCommand DbCommand = clsConnect.DbConnection.CreateCommand())
{
DbCommand.CommandText = SpMobile_Cashs_SumBrand;
DbCommand.CommandType = System.Data.CommandType.StoredProcedure;
System.Data.Common.DbParameterCollection Parameters = DbCommand.Parameters;
System.Data.Common.DbParameter Parameter;
Parameter = DbCommand.CreateParameter();
Parameter.ParameterName = PNgayBatDau;
Parameter.Value = NgayBatDau;
Parameters.Add(Parameter);
Parameter = DbCommand.CreateParameter();
Parameter.ParameterName = PNgayKetThuc;
Parameter.Value = NgayKetThuc;
Parameters.Add(Parameter);
DbDataAdapter DbDataAdapter = clsConnect.DbProviderFactory.CreateDataAdapter();
DbDataAdapter.SelectCommand = DbCommand;
System.Data.DataTable DataTable = new System.Data.DataTable("TABLE");
try { DbDataAdapter.Fill(DataTable); }
catch { DataTable = null; }
return(DataTable);
}
}