public void BindDgv()
{
SqlSugarClient db = null;
try
{
db = SqlLiteHelper.GetInstance();
if (!File.Exists(Device.DB_FilePath))
{
MessageBox.Show("文件下载中，请稍后再试！");
return;
}
var sourceList = db.Queryable <SYS_USERROOM, SYS_MODELS>((u, m) => new object[] {
JoinType.Left, u.GUID == m.GUID
})
.Select((u, m) => new
{
u.GUID,
u.NAME,
u.CREATETIME,
m.MODELID,
m.FEATURE,
u.STARTTIME,
u.ENDTIME,
u.AREACODE,
u.AREANAME,
u.USERTYPE,
});
if (!string.IsNullOrWhiteSpace(txtName.Text))
{
sourceList = sourceList.Where(u => u.NAME.Contains(txtName.Text));
}
TotalCount = sourceList.Count();
if (PageIndex <= 1)
{
PageIndex = 1;
}
var maxPageIndex = Math.Ceiling((decimal)TotalCount / (decimal)PageSize);
if (PageIndex >= maxPageIndex)
{
PageIndex = maxPageIndex.ToInt32();
}
var skip = (PageIndex - 1) * PageSize;
sourceList = sourceList.Take(PageSize).Skip(skip)
.OrderBy(u => u.CREATETIME, OrderByType.Desc);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = sourceList.ToList();
lblTotalCount.Text = $"第{PageIndex}页，每页{PageSize}条，总数：" + TotalCount;
}
catch (Exception ex)
{
MessageBox.Show("文件下载中，请稍后再试！");
}
db.Close();
db.Dispose();
System.Data.SQLite.SQLiteConnection.ClearAllPools();
}
