public ActionResult Index()
{
LogSMSBusiness = Get <LogSMSBusiness>();
var searchmodel = new LOGSMS_SEARCHBO();
SessionManager.SetValue("TimKiemSMS", null);
var data = LogSMSBusiness.GetDaTaByPage(null);
return(View(data));
}
public JsonResult getData(int indexPage, string sortQuery, int pageSize)
{
LogSMSBusiness = Get <LogSMSBusiness>();
var searchModel = SessionManager.GetValue("TimKiemSMS") as LOGSMS_SEARCHBO;
if (!string.IsNullOrEmpty(sortQuery))
{
if (searchModel == null)
{
searchModel = new LOGSMS_SEARCHBO();
}
searchModel.sortQuery = sortQuery;
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue("TimKiemSMS", searchModel);
}
var data = LogSMSBusiness.GetDaTaByPage(searchModel, pageSize, indexPage);
return(Json(data));
}
public JsonResult searchData(FormCollection form)
{
LogSMSBusiness = Get <LogSMSBusiness>();
var searchModel = SessionManager.GetValue("TimKiemSMS") as LOGSMS_SEARCHBO;
if (searchModel == null)
{
searchModel = new LOGSMS_SEARCHBO();
searchModel.pageSize = 20;
}
searchModel.NguoiNhan = form["sea_NguoiNhan"];
searchModel.NguoiGui = form["sea_NguoiGui"];
searchModel.DonViGui = form["sea_DonViGui"];
searchModel.DonViNhan = form["sea_DonViNhan"];
searchModel.SoDienThoai = form["sea_SoDienThoai"];
searchModel.TuNgay = form["sea_TuNgay"].ToDataTime();
searchModel.DenNgay = form["sea_DenNgay"].ToDataTime();
SessionManager.SetValue("TimKiemSMS", searchModel);
var data = LogSMSBusiness.GetDaTaByPage(searchModel, searchModel.pageSize, 1);
return(Json(data));
}
public PageListResultBO <LOGSMS_BO> GetDaTaByPage(LOGSMS_SEARCHBO searchModel, int pageSize = 20, int pageIndex = 1)
{
var query = from tbllog in this.context.LOGSMS
join deptSend in this.context.CCTC_THANHPHAN
on tbllog.DONVI_GUI equals deptSend.ID
into gLogSend
from logSend in gLogSend.DefaultIfEmpty()
join deptReceive in this.context.CCTC_THANHPHAN
on tbllog.DONVI_GUI equals deptReceive.ID
into gLogReceive
from logReceive in gLogReceive.DefaultIfEmpty()
select new LOGSMS_BO
{
CREATED_AT = tbllog.CREATED_AT,
CREATED_BY = tbllog.CREATED_BY,
HOTENNGUOIGUI = tbllog.HOTENNGUOIGUI,
HOTENNGUOINHAN = tbllog.HOTENNGUOINHAN,
ID = tbllog.ID,
ITEMID = tbllog.ITEMID,
ITEMTYPE = tbllog.ITEMTYPE,
KETQUA = tbllog.KETQUA,
NOIDUNG = tbllog.NOIDUNG,
SODIENTHOAINHAN = tbllog.SODIENTHOAINHAN,
SOKYTU = tbllog.SOKYTU,
TEN_DONVI_GUI = logSend.NAME,
TEN_DONVI_NHAN = logReceive.NAME
};
if (searchModel != null)
{
if (!string.IsNullOrEmpty(searchModel.NguoiGui))
{
query = query.Where(a => a.HOTENNGUOIGUI.Contains(searchModel.NguoiGui));
}
if (!string.IsNullOrEmpty(searchModel.NguoiNhan))
{
query = query.Where(a => a.HOTENNGUOINHAN.Contains(searchModel.NguoiNhan));
}
if (!string.IsNullOrEmpty(searchModel.SoDienThoai))
{
query = query.Where(a => a.SODIENTHOAINHAN.Contains(searchModel.SoDienThoai));
}
if (searchModel.TuNgay.HasValue)
{
query = query.Where(x => searchModel.TuNgay <= x.CREATED_AT);
}
if (searchModel.DenNgay.HasValue)
{
query = query.Where(x => searchModel.DenNgay >= x.CREATED_AT);
}
if (!string.IsNullOrEmpty(searchModel.DonViGui))
{
query = query.Where(a => a.TEN_DONVI_GUI.Contains(searchModel.DonViGui));
}
if (!string.IsNullOrEmpty(searchModel.DonViNhan))
{
query = query.Where(a => a.TEN_DONVI_NHAN.Contains(searchModel.DonViNhan));
}
//Lọc tìm kiếm
if (!string.IsNullOrEmpty(searchModel.sortQuery))
{
query = query.OrderBy(searchModel.sortQuery);
}
else
{
query = query.OrderByDescending(a => a.ID);
}
}
else
{
query = query.OrderByDescending(a => a.ID);
}
//Gán nội dung trả về
var resultmodel = new PageListResultBO <LOGSMS_BO>();
if (pageSize == -1)
{
var dataPageList = query.ToList();
resultmodel.Count = dataPageList.Count;
resultmodel.TotalPage = 1;
resultmodel.ListItem = dataPageList;
}
else
{
var dataPageList = query.ToPagedList(pageIndex, pageSize);
resultmodel.Count = dataPageList.TotalItemCount;
resultmodel.TotalPage = dataPageList.PageCount;
resultmodel.ListItem = dataPageList.ToList();
}
return(resultmodel);
}
