private dynamic getCLDV_khl_oracle(string startime, string endtime)
{
var checkDate = m_cldv_khl.toDataConvert(startime, endtime);
List <TK_KhongHaiLong_CLDV> data = new List <TK_KhongHaiLong_CLDV>();
if (checkDate == true)
{
string connStr = m_configuration.GetConnectionString("DefaultConnection");
var dt = new DataTable();
using (var conn = new SqlConnection(connStr))
{
conn.Open();
using (var cmd = new SqlCommand(@"select tuan, ngay, donvi_cha_id, sl from [dbo].TK_KhongHaiLong_CLDV where ngay between CONVERT(DATETIME,'" + startime + "',103) and CONVERT(DATETIME,'" + endtime + "',103)", conn))
{
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
TK_KhongHaiLong_CLDV row = new TK_KhongHaiLong_CLDV();
row.donvi_cha_id = Convert.ToInt32(rdr["donvi_cha_id"]);
row.ngay = (DateTime)rdr["ngay"];
row.tuan = rdr["tuan"].ToString();
row.sl = Convert.ToInt32(rdr["sl"]);
data.Add(row);
}
}
conn.Close();
}
return(data);
}
else
{
return(data);
}
}
public dynamic test()
{
try
{
return(m_tK_KhongHaiLong_CLDV.toDataConvert("05/03/2021", "07/03/2021"));
}
catch (Exception e)
{
}
return(true);
}
