/// <summary>
/// Load dữ liệu lên form
/// </summary>
private void LoadDuLieu()
{
try
{
Presentation.Process.HuyDongVonProcess process = new Presentation.Process.HuyDongVonProcess();
//DataSet ds = process.getTreeView(Presentation.Process.Common.ClientInformation.IdDonVi);
// Nếu người dùng là NVDV, QTDV thì chỉ lấy thông tin đơn vị mình
// Nếu người dùng là NVTW,... thì lấy thông tin toàn hệ thống
// (Truongnx: popup chỉ lấy thông tin khách hàng thuộc đơn vị mình)
int idDonVi = 0;
idDonVi = ClientInformation.IdDonVi;
//if (ClientInformation.LoaiNguoiSuDung.Equals(BusinessConstant.LoaiNguoiSuDung.CAP_NVDV.layGiaTri()) ||
// ClientInformation.LoaiNguoiSuDung.Equals(BusinessConstant.LoaiNguoiSuDung.CAP_QTDV.layGiaTri()))
//{
// idDonVi = ClientInformation.IdDonVi;
//}
//else
//{
// idDonVi = DatabaseConstant.ID_TOCHUC;
//}
DataSet ds = process.getTreeView(idDonVi);
if (ds != null && ds.Tables.Count > 0)
{
dtSourceTree = ds.Tables[0];
if (dtSourceTree != null && dtSourceTree.Rows.Count > 0)
{
DataRow drFirst = dtSourceTree.Rows[0];
string cond = "convert(path,System.String) like '0#" + drFirst["idparent"].ToString() + @"/%'";
DataRow[] drRoot = dtSourceTree.Select(cond, "id");
foreach (DataRow dr in drRoot)
{
RadTreeViewItem item = new RadTreeViewItem();
item.Header = dr["ten"];
item.Tag = dr["path"];
tvwKhachHangDS.Items.Add(item);
tvwKhachHangDS.SelectedItem = item;
dtSourceTree.Rows.Remove(dr);
BuildTreeCungCap(item);
item.IsExpanded = true;
}
}
}
}
catch (System.Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
//private void radpage_PageIndexChanged(object sender, PageIndexChangedEventArgs e)
//{
// if (e.NewPageIndex < radpage.PageCount)
// {
// CurrentPagging = e.NewPageIndex + 1;
// StartRow = (CurrentPagging - 1) * PaggingSize + 1;
// EndRow = StartRow + PaggingSize;
// //radpage = new RadDataPager();
// TimKiemPhanTrang();
// }
//}
/// <summary>
/// Tìm kiếm phân trang
/// </summary>
private void TimKiemPhanTrang()
{
Mouse.OverrideCursor = Cursors.Wait;
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
// Lay du lieu treeview cho tim kiem
string ma_don_vi = "-1";
string ma_khu_vuc = "-1";
string ma_cum = "-1";
string ma_nhom = "-1";
if (tvwKhachHangDS.SelectedItem != null)
{
RadTreeViewItem item = tvwKhachHangDS.SelectedItem as RadTreeViewItem;
string level = item.Tag.ToString().Split('#')[0];
string[] path = item.Tag.ToString().Split('#')[1].Split('/');
string type = item.Tag.ToString().Split('#')[2];
if (type == "DVI")
{
ma_don_vi = path[path.Length - 1];
}
else
{
ma_don_vi = path[0];
//ma_khu_vuc = path[1];
//ma_cum = path[1];
if (type == "KVUC")
{
ma_khu_vuc = path[1];
}
if (type == "CUM")
{
if (path.Length > 2)
{
ma_cum = path[2];
}
else
{
ma_cum = path[1];
}
}
if (type == "NHOM")
{
if (path.Length > 3)
{
ma_nhom = path[3];
}
else
{
ma_nhom = path[2];
}
}
}
}
LDatatable.AddParameter(ref dt, "@TenDangNhap", "STRING", ClientInformation.TenDangNhap);
LDatatable.AddParameter(ref dt, "@DonViQLy", "STRING", ClientInformation.MaDonViQuanLy);
LDatatable.AddParameter(ref dt, "@DonVi", "INT", ma_don_vi);
LDatatable.AddParameter(ref dt, "@KhuVuc", "INT", ma_khu_vuc);
LDatatable.AddParameter(ref dt, "@Cum", "INT", ma_cum);
LDatatable.AddParameter(ref dt, "@Nhom", "INT", ma_nhom);
LDatatable.AddParameter(ref dt, "@StartRow", "INT", StartRow.ToString());
LDatatable.AddParameter(ref dt, "@EndRow", "INT", EndRow.ToString());
// Tim kiem
Presentation.Process.HuyDongVonProcess process = new Presentation.Process.HuyDongVonProcess();
DataSet ds = process.getKetQuaTimKiemNangCao(dt);
if (ds != null && ds.Tables.Count > 0)
{
DataTable serverDataTable = ds.Tables[0];
int totalRecord = Int32.Parse(ds.Tables[1].Rows[0][0].ToString());
DataTable clientDataTable = CommonFunction.BuildClientDataTable(serverDataTable, CurrentPagging, PaggingSize, totalRecord);
lblSumKhachHang.Content = totalRecord;
grKhachHangDS.ItemsSource = null;
grKhachHangDS.ItemsSource = clientDataTable.DefaultView;
if (!LObject.IsNullOrEmpty(grKhachHangDS.SelectedItem))
{
grKhachHangDS.SelectedItems.Clear();
}
}
Mouse.OverrideCursor = Cursors.Arrow;
}
