public void LoadBan()
{
var provider = new Sqlite();
var table_group = provider.ExecuteQuery($@"SELECT DISTINCT khuvuc from view_ban a LEFT JOIN (SELECT maban from tbl_hoadon where dathanhtoan=0) b on b.maban=a.maban where b.maban>0 and a.maban NOT IN ('{Data._strMaBan}')");
var table_item = provider.ExecuteQuery($@"SELECT DISTINCT a.maban, tenban, khuvuc, hinh, CASE when b.maban>0 THEN 'True' ELSE 'False' END as sudung from view_ban a LEFT JOIN (SELECT maban from tbl_hoadon where dathanhtoan=0) b on b.maban=a.maban where b.maban>0 and a.maban NOT IN ('{Data._strMaBan}')");
count_group_gallery = table_group.Rows.Count;
galleryControl1.Gallery.ItemImageLayout = ImageLayoutMode.ZoomInside;
galleryControl1.Gallery.ImageSize = new Size(64, 64);
galleryControl1.Gallery.ShowItemText = true;
galleryControl1.Gallery.ShowGroupCaption = true;
foreach (DataRow group in table_group.Rows)
{
var galleryItem = new GalleryItemGroup();
galleryItem.Caption = group["khuvuc"] as string;
// galleryItem.CaptionAlignment = GalleryItemGroupCaptionAlignment.Center;
foreach (DataRow item in table_item.Rows)
{
if (group["khuvuc"].ToString().Equals(item["khuvuc"].ToString()))
{
var gc_item = new GalleryItem();
gc_item.AppearanceCaption.Normal.Font = new Font("Tahoma", 12, FontStyle.Regular);
gc_item.AppearanceCaption.Hovered.Font = new Font("Tahoma", 12, FontStyle.Regular);
gc_item.AppearanceCaption.Pressed.Font = new Font("Tahoma", 12, FontStyle.Regular);
string url = Data.BASE_URL_ICON + item["hinh"];
if (item["sudung"].ToString() == "True")
{
gc_item.ImageOptions.Image = Image.FromFile(url);
}
else
{
gc_item.ImageOptions.Image = Data.MakeGrayscale((Bitmap)Image.FromFile(url));
}
gc_item.Caption = item["tenban"].ToString();
gc_item.Value = item["maban"].ToString();
galleryItem.Items.Add(gc_item);
}
}
galleryControl1.Gallery.Groups.Add(galleryItem);
}
}
public void LoadBan()
{
var provider = new Sqlite();
DataTable table_group = new DataTable();
DataTable table_item = new DataTable();
table_group = provider.ExecuteQuery($@"SELECT DISTINCT c.khuvuc from tbl_ban a LEFT JOIN (SELECT DISTINCT maban from tbl_hoadon where ngayban>='{Convert.ToDateTime(dateTuNgay.EditValue).ToString("yyyy-MM-dd")}' and ngayban<='{Convert.ToDateTime(dateDenNgay.EditValue).ToString("yyyy-MM-dd")}' and huyhoadon=0) b on b.maban=a.maban INNER JOIN tbl_khuvuc c on c.makhuvuc=a.makhuvuc");
table_item = provider.ExecuteQuery($@"SELECT a.maban, a.tenban, c.khuvuc, c.hinh, CASE when b.maban is null then 'False' ELSE 'True' END as sudung from tbl_ban a LEFT JOIN (SELECT DISTINCT maban from tbl_hoadon where ngayban>='{Convert.ToDateTime(dateTuNgay.EditValue).ToString("yyyy-MM-dd")}' and ngayban<='{Convert.ToDateTime(dateDenNgay.EditValue).ToString("yyyy-MM-dd")}' and huyhoadon=0) b on b.maban=a.maban INNER JOIN tbl_khuvuc c on c.makhuvuc=a.makhuvuc");
count_group_gallery = table_group.Rows.Count;
galleryControl1.Gallery.ItemImageLayout = ImageLayoutMode.ZoomInside;
galleryControl1.Gallery.ImageSize = new Size(64, 64);
galleryControl1.Gallery.ShowItemText = true;
galleryControl1.Gallery.ShowGroupCaption = true;
foreach (DataRow group in table_group.Rows)
{
var galleryItem = new GalleryItemGroup();
galleryItem.Caption = group["khuvuc"] as string;
foreach (DataRow item in table_item.Rows)
{
if (group["khuvuc"].ToString().Equals(item["khuvuc"].ToString()))
{
var gc_item = new GalleryItem();
gc_item.AppearanceCaption.Normal.Font = new Font("Tahoma", 12, FontStyle.Regular);
gc_item.AppearanceCaption.Hovered.Font = new Font("Tahoma", 12, FontStyle.Regular);
gc_item.AppearanceCaption.Pressed.Font = new Font("Tahoma", 12, FontStyle.Regular);
string url = Data.BASE_URL_ICON + item["hinh"];
if (item["sudung"].ToString() == "True")
{
gc_item.ImageOptions.Image = Image.FromFile(url);
}
else
{
gc_item.ImageOptions.Image = Data.MakeGrayscale((Bitmap)Image.FromFile(url));
}
gc_item.Caption = item["tenban"].ToString();
gc_item.Value = item["maban"].ToString();
galleryItem.Items.Add(gc_item);
}
}
galleryControl1.Gallery.Groups.Add(galleryItem);
}
}
public void LoadBan()
{
var provider = new Sqlite();
var table_group = provider.ExecuteQuery("SELECT DISTINCT khuvuc FROM view_ban2");
var table_item = provider.ExecuteQuery("SELECT * from view_ban2");
count_group_gallery = table_group.Rows.Count;
galleryControl1.Gallery.ItemImageLayout = ImageLayoutMode.ZoomInside;
galleryControl1.Gallery.ImageSize = new Size(64, 64);
galleryControl1.Gallery.ShowItemText = true;
galleryControl1.Gallery.ShowGroupCaption = true;
foreach (DataRow group in table_group.Rows)
{
var galleryItem = new GalleryItemGroup();
galleryItem.Caption = group["khuvuc"] as string;
// galleryItem.CaptionAlignment = GalleryItemGroupCaptionAlignment.Center;
foreach (DataRow item in table_item.Rows)
{
if (group["khuvuc"].ToString().Equals(item["khuvuc"].ToString()))
{
var gc_item = new GalleryItem();
gc_item.AppearanceCaption.Normal.Font = new Font("Tahoma", 12, FontStyle.Regular);
gc_item.AppearanceCaption.Hovered.Font = new Font("Tahoma", 12, FontStyle.Regular);
gc_item.AppearanceCaption.Pressed.Font = new Font("Tahoma", 12, FontStyle.Regular);
string url = Data.BASE_URL_ICON + item["hinh"];
if (item["sudung"].ToString() == "True")
{
gc_item.ImageOptions.Image = Image.FromFile(url);
}
else
{
gc_item.ImageOptions.Image = Data.MakeGrayscale((Bitmap)Image.FromFile(url));
}
gc_item.Caption = item["tenban"].ToString();
gc_item.Value = item["maban"].ToString();
galleryItem.Items.Add(gc_item);
}
}
galleryControl1.Gallery.Groups.Add(galleryItem);
}
}