private void LoadGrid() { Cursor = Cursors.Wait; try { #region Điều kiện tìm kiếm RadTreeViewItem item = tvwTree.SelectedItem as RadTreeViewItem; string loai = item.Uid.ToString(); string ma = item.Tag.ToString(); #endregion HuyDongVonProcess HuyDongVonProcess = new HuyDongVonProcess(); DataTable dt = null; LDatatable.MakeParameterTable(ref dt); LDatatable.AddParameter(ref dt, "@USER_NAME", "String", ClientInformation.TenDangNhap); LDatatable.AddParameter(ref dt, "@MA_DVI_QLY", "String", ClientInformation.MaDonViQuanLy); LDatatable.AddParameter(ref dt, "@MA", "String", ma); LDatatable.AddParameter(ref dt, "@LOAI", "String", loai); DataSet ds = HuyDongVonProcess.GetDanhSachDangKyRutGocQB(dt); if (ds != null && ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ds.Tables[0].Rows[i]["TTHAI_NVU"] = BusinessConstant.layNgonNguNghiepVu(ds.Tables[0].Rows[i]["TTHAI_NVU"].ToString()); } grDanhSach.DataContext = ds.Tables[0].DefaultView; if (ds.Tables[0].Rows.Count > 0) { lblTongSo.Content = ds.Tables[0].Rows.Count; } else { lblTongSo.Content = "0"; } } else { grDanhSach.Items.Clear(); lblTongSo.Content = 0; } } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); } finally { Mouse.OverrideCursor = Cursors.Arrow; } }
private void SetFormData() { string SO_GIAO_DICH = MA_GIAO_DICH.Value; try { HuyDongVonProcess processHDV = new HuyDongVonProcess(); DataSet ds = processHDV.GetThongTinGuiThemTheoDS(AppConfig.LoginedUser.MaDonViGiaoDich, SO_GIAO_DICH); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; lblTrangThai.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, BusinessConstant.layMaNgonNguNghiepVu(dr["TTHAI_NVU"].ToString())); raddtNgay.Text = LDateTime.StringToDate(dr["NGAY_DL"].ToString(), "yyyyMMdd").ToString("dd/MM/yyyy"); txtMaGiaoDich.Text = SO_GIAO_DICH; txtNguoiGiaoDich.Text = dr["TEN_KHANG"].ToString(); txtDiaChi.Text = dr["DIA_CHI"].ToString(); txtDienGiai.Text = dr["DIEN_GIAI"].ToString(); TRANG_THAI_BAN_GHI.Value = dr["TTHAI_BGHI"].ToString(); TRANG_THAI_NGHIEP_VU.Value = dr["TTHAI_NVU"].ToString(); #region Tab thông tin kiểm soát txtTrangThai.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, BusinessConstant.layMaNgonNguSuDung(dr["TTHAI_BGHI"].ToString())); teldtNgayNhap.Text = LDateTime.StringToDate(dr["NGAY_NHAP"].ToString(), "yyyyMMdd").ToString("dd/MM/yyyy"); txtNguoiLap.Text = dr["NGUOI_NHAP"].ToString(); if (LDateTime.IsDate(dr["NGAY_CNHAT"].ToString(), "yyyyMMdd") == true) { teldtNgayCNhat.Text = LDateTime.StringToDate(dr["NGAY_CNHAT"].ToString(), "yyyyMMdd").ToString("dd/MM/yyyy"); } else { teldtNgayCNhat.Text = ""; } txtNguoiCapNhat.Text = dr["NGUOI_CNHAT"].ToString(); #endregion } dsGuiThem = processHDV.GetThongTinGuiThemTheoDSCTiet(AppConfig.LoginedUser.MaDonViGiaoDich, SO_GIAO_DICH); if (dsGuiThem != null) { //DataViewManager dataViewManager = new DataViewManager(dsGuiThem); // DataView dataView = dataViewManager.CreateDataView(dsGuiThem.Tables[0]); grGuiThemDS.DataSource = dsGuiThem; grGuiThemDS.DataBind(); } TinhTong(); } catch (Exception ex) { } }
private void LoadGrid() { try { HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess(); DataSet ds = null; if (DatabaseConstant.Function.TDVM_TAM_UNG == function) { ds = huyDongVonProcess.GetDanhSachSoRutGoc(ClientInformation.MaDonViGiaoDich, sSanPham, sIDCum, ClientInformation.NgayLamViecHienTai); } 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; } }
/// <summary> /// Xóa /// </summary> /// <param name="listId"></param> private void OnDelete(List <int> listId) { HuyDongVonProcess processHuyDongVon = new HuyDongVonProcess(); Mouse.OverrideCursor = Cursors.Wait; try { List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>(); List <HDV_THONG_TIN_DKY_RUT_GOC> lstNhom = new List <HDV_THONG_TIN_DKY_RUT_GOC>(); HDV_THONG_TIN_DKY_RUT_GOC obj = null; foreach (int id in listId) { obj = new HDV_THONG_TIN_DKY_RUT_GOC(); obj.ID = id; lstNhom.Add(obj); } bool ret = processHuyDongVon.DanhSachDangKyRutGocQB(DatabaseConstant.Action.XOA, ref lstNhom, ref listClientResponseDetail); AfterDelete(ret, listId, listClientResponseDetail); } catch (System.Exception ex) { // Yêu cầu unlock dữ liệu UtilitiesProcess process = new UtilitiesProcess(); bool retUnlockData = process.UnlockData(DatabaseConstant.Module.DMDC, DatabaseConstant.Function.DC_DM_NHOM_DS, DatabaseConstant.Table.DM_NHOM, DatabaseConstant.Action.XOA, listId); this.Cursor = Cursors.Arrow; CommonFunction.ThongBaoLoi(ex); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); } Mouse.OverrideCursor = Cursors.Arrow; }
/// <summary> /// Load dữ liệu lên Treeview /// </summary> private void LoadTreeview() { try { HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess(); string sIdDonVi = ""; string sMaDonVi = ""; string sIdDonViQLy = ""; string sMaDonViQLy = ""; if (lstSourceDonVi != null) { sIdDonVi = lstSourceDonVi.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.ElementAt(1); sMaDonVi = lstSourceDonVi.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.ElementAt(0); DM_DON_VI objDonVi = new DanhMucProcess().getDonViById(Convert.ToInt32(sIdDonVi)); if (objDonVi.LOAI_DVI.Equals(DatabaseConstant.ToChucDonVi.HSO.getValue()) || objDonVi.LOAI_DVI.Equals(DatabaseConstant.ToChucDonVi.CNH.getValue())) { sIdDonViQLy = objDonVi.ID.ToString(); sMaDonViQLy = objDonVi.MA_DVI; } else { sIdDonViQLy = objDonVi.ID_DVI_CHA.ToString(); sMaDonViQLy = objDonVi.MA_DVI_CHA; } } dtTreeSanPham = huyDongVonProcess.GetTreeSanPham(sMaDonViQLy).Tables[0]; dtTreeDonVi = huyDongVonProcess.GetTreeDonViNhom(AppConfig.LoginedUser.MaDonViQuanLy, AppConfig.LoginedUser.UserName, sMaDonViQLy).Tables[0]; dtTreeCBQL = huyDongVonProcess.GetTreeCBQL(sMaDonViQLy).Tables[0]; // BuildTree(dtTreeSanPham, tvwLoaiVay, false); DataTable mtree = new DataTable(); mtree.Columns.Add("LEVEL", Type.GetType("System.String")); mtree.Columns.Add("NODE_PARENT", Type.GetType("System.String")); mtree.Columns.Add("NODE", Type.GetType("System.String")); mtree.Columns.Add("NODE_NAME", Type.GetType("System.String")); mtree.Columns.Add("STYPE", Type.GetType("System.String")); DataRow row = mtree.NewRow(); for (int j = 0; j < dtTreeSanPham.Rows.Count; j++) { row = mtree.NewRow(); row["LEVEL"] = dtTreeSanPham.Rows[j][0].ToString(); row["NODE_PARENT"] = dtTreeSanPham.Rows[j][1].ToString(); row["NODE"] = dtTreeSanPham.Rows[j][2].ToString(); row["NODE_NAME"] = dtTreeSanPham.Rows[j][3].ToString(); row["STYPE"] = "SAN_PHAM"; mtree.Rows.Add(row); } tvwLoaiVay.Nodes.Clear(); TreeNode rootItem = new TreeNode(); rootItem.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, "U.HuyDongVon.MoSo.ucMoSoDS.NhomSanPham"); rootItem.Value = "0#SAN_PHAM"; tvwLoaiVay.Nodes.Add(rootItem); BuildTree(rootItem, mtree, "SAN_PHAM"); mtree.Clear(); for (int j = 0; j < dtTreeDonVi.Rows.Count; j++) { row = mtree.NewRow(); row["LEVEL"] = dtTreeDonVi.Rows[j][0].ToString(); row["NODE_PARENT"] = dtTreeDonVi.Rows[j][1].ToString(); row["NODE"] = dtTreeDonVi.Rows[j][2].ToString(); row["NODE_NAME"] = dtTreeDonVi.Rows[j][3].ToString(); row["STYPE"] = "DON_VI"; mtree.Rows.Add(row); } TreeNode rootItem_dv = new TreeNode(); rootItem_dv.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, "U.HuyDongVon.MoSo.ucMoSoDS.KhachHang"); rootItem_dv.Value = "0#DON_VI"; tvwLoaiVay.Nodes.Add(rootItem_dv); BuildTree(rootItem, mtree, "DON_VI"); tvwLoaiVay.ShowCheckBoxes = TreeNodeTypes.All; } catch (Exception ex) { //LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); } }
/// <summary> /// Load dữ liệu lên Grid /// </summary> private void LoadGrid(int stype) { try { HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess(); AutoComboBox auto = new AutoComboBox(); List <string> lstDieuKien = new List <string>(); lstDieuKien.Add(AppConfig.LoginedUser.UserName); lstDieuKien.Add(AppConfig.LoginedUser.MaDonVi); lstDieuKien.Add(DatabaseConstant.ToChucDonVi.PGD.getValue()); auto.GenAutoSoure(ref lstSourceDonVi, DatabaseConstant.DanhSachTruyVan.COMBOBOX_DONVI_THEOPVI.getValue(), lstDieuKien, AppConfig.LoginedUser.MaDonViGiaoDich); lstDieuKien.Clear(); #region Điều kiện tìm kiếm string sMaDonVi = ""; sMaDonVi = "("; string maChon = cmbDonVi.SelectedItem.Value;// lstSourceDonVi.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.ElementAt(0); string donVi = ""; foreach (AutoCompleteEntry item in lstSourceDonVi) { donVi = item.KeywordStrings.ElementAt(0); if (donVi.Contains(maChon)) { sMaDonVi += "''" + donVi + "'',"; } } sMaDonVi = sMaDonVi.Substring(0, sMaDonVi.Length - 1); sMaDonVi += ")"; string sTrangThaiNVu = ""; string sSoTGui = "%"; string sTenSoTGui = "%"; string sTuNgayMoSo = "%"; string sDenNgayMoSo = "%"; string sTuNgayDHan = "%"; string sDenNgayDHan = "%"; string soDuTu = "%"; string soDuDen = "%"; string iKyHanTu = "%"; string iKyHanDen = "%"; string sKyHanDonVi = "%"; string sMaKH = "%"; string sTenKH = "%"; string sSoCMND = "%"; string sSDT = "%"; string sEmail = "%"; string sNgayDC = "%"; string sSanPham = "%", sIDNhom = "%", sCBQL = "%"; if (cbChoduyet.Checked) { sTrangThaiNVu = sTrangThaiNVu + "''" + cbChoduyet.Value + "'',"; } if (cbDaduyet.Checked) { sTrangThaiNVu = sTrangThaiNVu + "''" + cbDaduyet.Value + "'',"; } if (cbThoaiduyet.Checked) { sTrangThaiNVu = sTrangThaiNVu + "''" + cbThoaiduyet.Value + "'',"; } if (cbTuchoi.Checked) { sTrangThaiNVu = sTrangThaiNVu + "''" + cbTuchoi.Value + "'',"; } if (sTrangThaiNVu != "") { sTrangThaiNVu = "(" + sTrangThaiNVu.Substring(0, sTrangThaiNVu.Length - 1) + ")"; } if (!txtSoSoTG.Text.IsNullOrEmpty()) { sSoTGui = txtSoSoTG.Text; } if (!raddtNgayMoSoTu.Text.IsNullOrEmpty()) { sTuNgayMoSo = LDateTime.StringToDate(raddtNgayMoSoTu.Text, "dd/MM/yyyy").ToString("yyyyMMdd"); } if (!raddtNgayMoSoDen.Text.IsNullOrEmpty()) { sDenNgayMoSo = LDateTime.StringToDate(raddtNgayMoSoDen.Text, "dd/MM/yyyy").ToString("yyyyMMdd"); } if (!raddtNgayDaoHanTu.Text.IsNullOrEmpty()) { sTuNgayDHan = LDateTime.StringToDate(raddtNgayDaoHanTu.Text, "dd/MM/yyyy").ToString("yyyyMMdd"); } if (!raddtNgayDaoHanDen.Text.IsNullOrEmpty()) { sDenNgayDHan = LDateTime.StringToDate(raddtNgayDaoHanDen.Text, "dd/MM/yyyy").ToString("yyyyMMdd"); } if (numSoDuTu.Text != "") { soDuTu = numSoDuTu.Text.Replace(",", "").ToString(); } if (numSoDuDen.Text != "") { soDuDen = numSoDuDen.Text.Replace(",", "").ToString(); } if (numKyHanTu.Text != "") { iKyHanTu = numKyHanTu.Text.Replace(",", "").ToString(); } if (numKyHanDen.Text != "") { iKyHanDen = numKyHanDen.Text.Replace(",", "").ToString(); } if (cmbKyHanTu.SelectedIndex >= 0) { sKyHanDonVi = cmbKyHanTu.SelectedItem.Value; } if (!txtKhachHang.Text.IsNullOrEmptyOrSpace()) { sMaKH = txtKhachHang.Text; } if (!txtTenKhachHang.Text.IsNullOrEmptyOrSpace()) { sTenKH = txtTenKhachHang.Text; } //} #endregion // Phân trang int StartRow = 1; int EndRow = 999999999 * stype; // ClientInformation.SoLuongBanGhi; int CurrentPagging = 1; int PaggingSize = 999999999; // ClientInformation.SoLuongBanGhi; DataSet ds = huyDongVonProcess.GetDanhSachSoTGuiNhom(sMaDonVi, sSanPham, sIDNhom, sCBQL, sTrangThaiNVu, sSoTGui, sTenSoTGui, sTuNgayMoSo, sDenNgayMoSo, sTuNgayDHan, sDenNgayDHan, soDuTu, soDuDen, iKyHanTu, iKyHanDen, sKyHanDonVi, sMaKH, sTenKH, sSoCMND, sSDT, sEmail, sNgayDC, StartRow.ToString(), EndRow.ToString()); if (ds != null && ds.Tables.Count > 0) { //foreach (DataRow dr in ds.Tables[0].Rows) //{ // dr["TTHAI_NVU"] = BusinessConstant.layNgonNguNghiepVu(dr["TTHAI_NVU"].ToString()); // if (!dr["KY_HAN_DVI_TINH"].IsNullOrEmpty() && !dr["KY_HAN_TGIAN"].IsNullOrEmpty() && !dr["KY_HAN"].IsNullOrEmpty()) // { // if (!dr["KY_HAN_TGIAN"].ToString().Equals("0") && !dr["KY_HAN_DVI_TINH"].ToString().Equals("")) // dr["KY_HAN"] = dr["KY_HAN_TGIAN"] + " " + BusinessConstant.layNgonNguTuGiaTri(dr["KY_HAN_DVI_TINH"].ToString(), "TAN_SUAT"); // } //} DataTable serverDataTable = ds.Tables[0]; int totalRecord = Int32.Parse(ds.Tables[1].Rows[0][0].ToString()); //DataTable clientDataTable = ds.Tables[0].Copy() ;// CommonFunction.BuildClientDataTable(serverDataTable, CurrentPagging, PaggingSize, totalRecord); //dtSoTGui = ds.Tables[0]; //grSoTienGuiDS.DataContext = dtSoTGui.DefaultView; dtSoTGui = serverDataTable; grSoTienGuiDS.DataSource = serverDataTable; grSoTienGuiDS.DataBind(); int soSoTgui = 0; decimal tongSoDu = 0; decimal soDuBinhQuan = 0; decimal tongSoDuGoc = Decimal.Parse(ds.Tables[2].Rows[0][0].ToString()); decimal tongSoDuLai = Decimal.Parse(ds.Tables[2].Rows[0][1].ToString()); if (totalRecord > 0) { soSoTgui = totalRecord; 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); lblSumSoDuGoc.Text = String.Format("{0:#,#}", tongSoDuGoc); lblSumSoDuLai.Text = String.Format("{0:#,#}", tongSoDuLai); } else { dtSoTGui.Rows.Clear(); grSoTienGuiDS.DataSource = dtSoTGui.DefaultView; grSoTienGuiDS.DataBind(); } } catch (Exception ex) { // LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); } }
/// <summary> /// Load dữ liệu lên Treeview /// </summary> private void LoadTreeview() { try { HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess(); string sIdDonVi = ClientInformation.IdDonVi.ToString(); string sMaDonVi = ClientInformation.MaDonVi; DataSet dsTreeSanPham; dtTreeDonVi = huyDongVonProcess.GetTreeDonVi(sIdDonVi).Tables[0]; #region Tree Sản phẩm if (function == DatabaseConstant.Function.HDV_RUT_BOT_GOC || function == DatabaseConstant.Function.HDV_RUT_GOC_THEO_DANH_SACH) { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamRutGoc(sMaDonVi); } else if (function == DatabaseConstant.Function.HDV_GUI_THEM_TIEN_THEO_SO || function == DatabaseConstant.Function.HDV_GUI_THEM_TIEN_THEO_DANH_SACH) { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamGuiThem(sMaDonVi); } else if (function == DatabaseConstant.Function.HDV_TRA_LAI || function == DatabaseConstant.Function.HDV_TRA_LAI_THEO_DANH_SACH) { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamTraLai(sMaDonVi); } else if (function == DatabaseConstant.Function.HDV_DU_CHI) { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamDuChi(sMaDonVi); } else if (function == DatabaseConstant.Function.HDV_PHAN_BO) { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamPhanBo(sMaDonVi); } else if (function == DatabaseConstant.Function.HDV_DIEU_CHINH_LS) { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamThayDoiLS(sMaDonVi); } else { dsTreeSanPham = huyDongVonProcess.GetTreeSanPham(sMaDonVi); } if (dsTreeSanPham != null && dsTreeSanPham.Tables[0].Rows.Count > 0) { dtTreeSanPham = dsTreeSanPham.Tables[0]; } #endregion itemSanPham.Items.Clear(); //Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM) itemSanPham.Tag = "0#0#SAN_PHAM"; itemSanPham.IsExpanded = false; BuildTree(itemSanPham, dtTreeSanPham, "SAN_PHAM"); itemDonVi.Items.Clear(); //Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM) itemDonVi.Tag = "0#0#DON_VI"; itemDonVi.IsExpanded = false; BuildTree(itemDonVi, dtTreeDonVi, "DON_VI"); } catch (Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); } }
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; } }
/// <summary> /// Load dữ liệu lên Treeview /// </summary> private void LoadTreeview() { try { HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess(); string sIdDonVi = AppConfig.LoginedUser.IdDonVi.ToString(); if (sIdDonVi == "0") { sIdDonVi = "4"; // FIX TAM DE CO DU LIEU } string sMaDonVi = AppConfig.LoginedUser.MaDonVi; DataSet dsTreeSanPham; dtTreeDonVi = huyDongVonProcess.GetTreeDonVi(sIdDonVi).Tables[0]; #region Tree Sản phẩm if (fn == "HDV_RUT_BOT_GOC" || fn == "HDV_RUT_GOC_THEO_DANH_SACH") { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamRutGoc(sMaDonVi); } else if (fn == "HDV_GUI_THEM_TIEN_THEO_SO" || fn == "HDV_GUI_THEM_TIEN_THEO_DANH_SACH") { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamGuiThem(sMaDonVi); } else if (fn == "HDV_TRA_LAI" || fn == "HDV_TRA_LAI_THEO_DANH_SACH") { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamTraLai(sMaDonVi); } else if (fn == "HDV_DU_CHI") { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamDuChi(sMaDonVi); } else if (fn == "HDV_PHAN_BO") { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamPhanBo(sMaDonVi); } else if (fn == "HDV_DIEU_CHINH_LS") { dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamThayDoiLS(sMaDonVi); } else { dsTreeSanPham = huyDongVonProcess.GetTreeSanPham(sMaDonVi); } if (dsTreeSanPham != null && dsTreeSanPham.Tables[0].Rows.Count > 0) { dtTreeSanPham = dsTreeSanPham.Tables[0]; } #endregion tvSearch.Nodes.Clear(); //Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM) TreeNode itemSanPham = new TreeNode(); itemSanPham.Value = "0#0#SAN_PHAM"; itemSanPham.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, "U.HuyDongVon.Popup.ucPopupSoTGui.SanPham"); itemSanPham.Expanded = true; tvSearch.Nodes.Add(itemSanPham); BuildTree(itemSanPham, dtTreeSanPham, "SAN_PHAM"); TreeNode itemDonVi = new TreeNode(); //Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM) itemDonVi.Value = "0#0#DON_VI"; itemDonVi.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, "U.HuyDongVon.MoSo.ucMoSoDS.KhachHang"); itemDonVi.Expanded = true; //BuildTree(itemDonVi, dtTreeDonVi, "DON_VI"); tvSearch.Nodes.Add(itemDonVi); BuildSubTreeKhuVuc(itemDonVi, null, 0); tvSearch.ShowCheckBoxes = TreeNodeTypes.All; } catch (Exception 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) { } }