private void LoadGrid() { try { HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess(); DataSet ds = null; if (function == DatabaseConstant.Function.HDV_LAI_NHAP_GOC_THEO_SO || function == DatabaseConstant.Function.HDV_LAI_NHAP_GOC_THEO_DANH_SACH) { ds = huyDongVonProcess.GetDanhSachSoLNG(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai); } else if (function == DatabaseConstant.Function.HDV_RUT_BOT_GOC || function == DatabaseConstant.Function.HDV_RUT_GOC_THEO_DANH_SACH) { ds = huyDongVonProcess.GetDanhSachSoRutGocNhom(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai); } else if (function == DatabaseConstant.Function.HDV_DU_CHI) { ds = huyDongVonProcess.GetDanhSachSoDuChi(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai); } else if (function == DatabaseConstant.Function.HDV_TRA_LAI || function == DatabaseConstant.Function.HDV_TRA_LAI_THEO_DANH_SACH) { ds = huyDongVonProcess.GetDanhSachSoTraLaiNhom(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai); } else if (function == DatabaseConstant.Function.HDV_TAT_TOAN || function == DatabaseConstant.Function.HDV_TAT_TOAN_THEO_DANH_SACH) { ds = huyDongVonProcess.GetDanhSachSoTatToanNhom(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai); } else if (function == DatabaseConstant.Function.HDV_DIEU_CHINH_LS) { ds = huyDongVonProcess.GetDanhSachSoThayDoiLS(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai); } else { ds = huyDongVonProcess.GetDanhSachSoTGuiNhom(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom); } if (ds != null) { dtSoTGui = ds.Tables[0]; grSoTienGuiDS.ItemsSource = dtSoTGui; int soSoTgui = 0; decimal tongSoDu = 0; decimal soDuBinhQuan = 0; if (dtSoTGui.Rows.Count > 0) { soSoTgui = dtSoTGui.Rows.Count; for (int i = 0; i < dtSoTGui.Rows.Count; i++) { tongSoDu += Convert.ToDecimal(dtSoTGui.Rows[i]["SO_DU"]); } soDuBinhQuan = tongSoDu / soSoTgui; } lblSumSoSo.Content = String.Format("{0:#,#}", soSoTgui); lblSumSoDu.Content = String.Format("{0:#,#}", tongSoDu); lblSoDuBQ.Content = String.Format("{0:#,#}", soDuBinhQuan); } else { dtSoTGui.Rows.Clear(); grSoTienGuiDS.ItemsSource = dtSoTGui; } } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } }
private void LoadGrid(int itype) { try { sSanPham = ""; sIDCum = ""; if (itype == 1) { //string ListPThucVay = ""; //foreach (TreeNode item in tvwLoaiVay.CheckedNodes) //{ // ListPThucVay += ",''" + item.Value.ToString() + "''"; //} //if (ListPThucVay.Length > 0) // ListPThucVay = "(" + ListPThucVay.Substring(1) + ")"; foreach (TreeNode item in tvSearch.CheckedNodes) { ///Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM hoặc CUM001#3#DON_VI) string sTag = item.Value.ToString(); int i1 = sTag.IndexOf("#"); int i2 = sTag.LastIndexOf("#"); string sValue = sTag.Split('#')[0]; // sTag.Substring(0, i1); int iLevel = Convert.ToInt32(sTag.Split('#')[1]); string sLoaiTree = sTag.Split('#')[2]; // sTag.Substring(i2 + 1); if (sLoaiTree.Equals("SAN_PHAM")) { if (iLevel == 2) { sSanPham = sSanPham + "''" + sValue + "'',"; } } if (sLoaiTree.Equals("DON_VI")) { if (iLevel == 3) { sIDCum = sIDCum + "''" + sValue + "'',"; } } } if (sSanPham.Length > 0) { sSanPham = sSanPham.Substring(0, sSanPham.Length - 1); } if (sIDCum.Length > 0) { sIDCum = sIDCum.Substring(0, sIDCum.Length - 1); } //if (itemDonVi.CheckState == System.Windows.Automation.ToggleState.On) //{ // sIDCum = "%"; //} if (sSanPham.Equals("")) { sSanPham = "''''"; } if (sIDCum.Equals("")) { sIDCum = "''''"; } } else { sSanPham = "''%''"; sIDCum = "''%''"; } HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess(); DataSet ds = null; if (fn == "HDV_LAI_NHAP_GOC_THEO_SO" || fn == "HDV_LAI_NHAP_GOC_THEO_DANH_SACH") { ds = huyDongVonProcess.GetDanhSachSoLNG(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai); } else if (fn == "HDV_RUT_BOT_GOC" || fn == "HDV_RUT_GOC_THEO_DANH_SACH") { ds = huyDongVonProcess.GetDanhSachSoRutGoc(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai); } else if (fn == "HDV_DU_CHI") { ds = huyDongVonProcess.GetDanhSachSoDuChi(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai); } else if (fn == "HDV_TRA_LAI" || fn == "HDV_TRA_LAI_THEO_DANH_SACH") { ds = huyDongVonProcess.GetDanhSachSoTraLai(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai); } else if (fn == "HDV_TAT_TOAN" || fn == "HDV_TAT_TOAN_THEO_DANH_SACH") { ds = huyDongVonProcess.GetDanhSachSoTatToan(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai); } else if (fn == "HDV_DIEU_CHINH_LS") { ds = huyDongVonProcess.GetDanhSachSoThayDoiLS(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai); } else { ds = huyDongVonProcess.GetDanhSachSoTGui(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum); } if (ds != null) { dtSoTGui = ds.Tables[0]; if (itype == 0) { dtSoTGui = ds.Tables[0].Clone(); } grSoTienGuiDS.DataSource = dtSoTGui; grSoTienGuiDS.DataBind(); int soSoTgui = 0; decimal tongSoDu = 0; decimal soDuBinhQuan = 0; if (dtSoTGui.Rows.Count > 0) { soSoTgui = dtSoTGui.Rows.Count; for (int i = 0; i < dtSoTGui.Rows.Count; i++) { tongSoDu += Convert.ToDecimal(dtSoTGui.Rows[i]["SO_DU"]); } soDuBinhQuan = tongSoDu / soSoTgui; } lblSumSoSo.Text = String.Format("{0:#,#}", soSoTgui); lblSumSoDu.Text = String.Format("{0:#,#}", tongSoDu); lblSoDuBQ.Text = String.Format("{0:#,#}", soDuBinhQuan); } else { dtSoTGui.Rows.Clear(); grSoTienGuiDS.DataSource = dtSoTGui; grSoTienGuiDS.DataBind(); } } catch (Exception ex) { } }