/// <summary> /// Xem dữ liệu /// </summary> private void onView(int id) { UserControl userControl = null; string tittle = DatabaseConstant.layNgonNguTieuDeForm(this.Function); Window frm = new Window(); frm.Title = tittle; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; ApplicationConstant.DonViSuDung company = ApplicationConstant.layDonViSuDung(ClientInformation.Company); switch (company) { case ApplicationConstant.DonViSuDung.BANTAYVANG: userControl = new ucNhomCT_01(); break; default: userControl = new ucNhomCT_01(); break; } PropertyInfo fieldAction = userControl.GetType().GetProperty("Action"); fieldAction.SetValue(userControl, DatabaseConstant.Action.XEM, null); fieldAction = userControl.GetType().GetProperty("Id"); fieldAction.SetValue(userControl, id, null); MethodInfo mi = userControl.GetType().GetMethod("beforeViewFromList"); mi.Invoke(userControl, null); //LoadTreeCT dlgLoadTreeCT = new LoadTreeCT(userControl.beforeViewFromList); //dlgLoadTreeCT(); frm.Content = userControl; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; frm.ShowDialog(); }
/// <summary> /// Xử lý sự kiện thêm /// </summary> private void Them() { UserControl userControl = null; string tittle = DatabaseConstant.layNgonNguTieuDeForm(this.function); Window frm = new Window(); frm.Title = tittle; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; ApplicationConstant.DonViSuDung company = ApplicationConstant.layDonViSuDung(ClientInformation.Company); switch (company) { case ApplicationConstant.DonViSuDung.BANTAYVANG: userControl = new ucKhuVucCT_01(); break; default: userControl = new ucKhuVucCT_01(); break; } FieldInfo fieldAction = userControl.GetType().GetField("action"); fieldAction.SetValue(userControl, DatabaseConstant.Action.THEM); //MethodInfo mi = userControl.GetType().GetMethod("SetDataForm"); //object[] para = new object[1] { id }; //mi.Invoke(userControl, para); //LoadDuLieuCT dlgLoadDuLieuCT = new LoadDuLieuCT(userControl.beforeViewFromList); //dlgLoadDuLieuCT(); frm.Content = userControl; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; frm.ShowDialog(); }
public LoginWithConfigWindow() { InitializeComponent(); process = new ZAMainAppProcess(); //Icon & title setting CommonFunction.setIcon(this); this.Title += " - " + ClientInformation.ShortName; ApplicationConstant.DonViSuDung company = ApplicationConstant.layDonViSuDung(ClientInformation.Company); if (company == ApplicationConstant.DonViSuDung.BINHKHANH) { lblLanguage.Visibility = Visibility.Hidden; cboLanguage.Visibility = Visibility.Hidden; lblTitle.Visibility = Visibility.Visible; } string ServerPattern = ClientInformation.ServerList; Server server = new Server(); List <Server> ServerList = server.getServerList(ServerPattern); foreach (Server item in ServerList) { MenuItem mnuItem = new MenuItem(); mnuItem.Name = "" + item.ServerName; mnuItem.Header = "" + item.ServerName; mnuItem.Uid = "" + item.ServerIP + "#" + item.ServerPort; if (item.ServerName.Equals(ClientInformation.ServerName)) { mnuItem.Icon = new Image { Source = new BitmapImage(new Uri(@"pack://application:,,,/Utilities.Common;component/Images/Action/approve.png", UriKind.RelativeOrAbsolute)), Width = 12, Height = 12 }; } mnuItem.Click += mnu_Click; mnuConfig.Items.Add(mnuItem); } }
public int CapNhatKheUocDaTatToan(ApplicationConstant.DonViSuDung CompanyCode) { int SoLuongKheUoc = 0; try { if (CompanyCode.Equals(ApplicationConstant.DonViSuDung.BINHKHANH)) { string nativeQuery = ""; DS_TruyVan dsTruyVan = new DS_TruyVan(); DataSet ds = new DataSet(); // Lay so luong trong TD_KUOCVM nativeQuery = "SELECT COUNT(*) FROM TD_KUOCVM WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); string SoLuongKUOCVM = ""; if (ds != null && ds.Tables[0].Rows.Count > 0) { SoLuongKUOCVM = ds.Tables[0].Rows[0][0].ToString(); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "KUOCVM: " + SoLuongKUOCVM); // Lay so luong trong TD_KUOCVM_LSU nativeQuery = "SELECT COUNT(*) FROM TD_KUOCVM_LSU WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); string SoLuongKUOCVM_LSU = ""; if (ds != null && ds.Tables[0].Rows.Count > 0) { SoLuongKUOCVM_LSU = ds.Tables[0].Rows[0][0].ToString(); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "KUOCVM_LSU: " + SoLuongKUOCVM_LSU); if (SoLuongKUOCVM.Equals(SoLuongKUOCVM_LSU) && !SoLuongKUOCVM.Equals("0")) { SoLuongKheUoc = Int32.Parse(SoLuongKUOCVM); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "KUOCVM PROCESSING"); nativeQuery = "SELECT MA_KUOCVM, SO_DU, SO_TIEN_GIAI_NGAN, GOC_DA_THU, LAI_PHAI_THU, LAI_DA_THU FROM TD_KUOCVM WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string MA_KUOCVM = ds.Tables[0].Rows[i][0].ToString(); string SO_DU = ds.Tables[0].Rows[i][1].ToString(); string SO_TIEN_GIAI_NGAN = ds.Tables[0].Rows[i][2].ToString(); string GOC_DA_THU = ds.Tables[0].Rows[i][3].ToString(); string LAI_PHAI_THU = ds.Tables[0].Rows[i][4].ToString(); string LAI_DA_THU = ds.Tables[0].Rows[i][5].ToString(); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "MA_KUOCVM, SO_DU, SO_TIEN_GIAI_NGAN, GOC_DA_THU, LAI_PHAI_THU, LAI_DA_THU"); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, MA_KUOCVM + ", " + SO_DU + ", " + SO_TIEN_GIAI_NGAN + ", " + GOC_DA_THU + ", " + LAI_PHAI_THU + ", " + LAI_DA_THU); } nativeQuery = "UPDATE TD_KUOCVM SET SO_DU = 0 WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, ds.ToString()); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "KUOCVM_LSU PROCESSING"); nativeQuery = "SELECT MA_KUOCVM, SO_DU, SO_TIEN_GIAI_NGAN, GOC_DA_THU, LAI_PHAI_THU, LAI_DA_THU FROM TD_KUOCVM_LSU WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string MA_KUOCVM = ds.Tables[0].Rows[i][0].ToString(); string SO_DU = ds.Tables[0].Rows[i][1].ToString(); string SO_TIEN_GIAI_NGAN = ds.Tables[0].Rows[i][2].ToString(); string GOC_DA_THU = ds.Tables[0].Rows[i][3].ToString(); string LAI_PHAI_THU = ds.Tables[0].Rows[i][4].ToString(); string LAI_DA_THU = ds.Tables[0].Rows[i][5].ToString(); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "MA_KUOCVM, SO_DU, SO_TIEN_GIAI_NGAN, GOC_DA_THU, LAI_PHAI_THU, LAI_DA_THU"); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, MA_KUOCVM + ", " + SO_DU + ", " + SO_TIEN_GIAI_NGAN + ", " + GOC_DA_THU + ", " + LAI_PHAI_THU + ", " + LAI_DA_THU); } nativeQuery = "UPDATE TD_KUOCVM_LSU SET SO_DU = 0 WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, ds.ToString()); } } } return(SoLuongKheUoc); } catch (System.Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } }
public int CapNhatSoTietKiem(ApplicationConstant.DonViSuDung CompanyCode) { int SoLuongSoTietKiem = 0; try { if (CompanyCode.Equals(ApplicationConstant.DonViSuDung.BINHKHANH)) { string nativeQuery = ""; DS_TruyVan dsTruyVan = new DS_TruyVan(); DataSet ds = new DataSet(); // Lay so luong trong TD_KUOCVM nativeQuery = "SELECT COUNT(*) FROM BL_TIEN_GUI where DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); string SoLuongSo = ""; if (ds != null && ds.Tables[0].Rows.Count > 0) { SoLuongSo = ds.Tables[0].Rows[0][0].ToString(); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "SoLuongSo: " + SoLuongSo); // Lay so luong trong TD_KUOCVM_LSU nativeQuery = "SELECT COUNT(*) FROM BL_TIEN_GUI_LSU where DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); string SoLuongSo_LSU = ""; if (ds != null && ds.Tables[0].Rows.Count > 0) { SoLuongSo_LSU = ds.Tables[0].Rows[0][0].ToString(); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "SoLuongSo_LSU: " + SoLuongSo_LSU); if (SoLuongSo.Equals(SoLuongSo_LSU) && !SoLuongSo.Equals("0")) { SoLuongSoTietKiem = Int32.Parse(SoLuongSo); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "BL_TIEN_GUI PROCESSING"); nativeQuery = "SELECT MA_KHANG, SO_SO_TG FROM BL_TIEN_GUI where DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string MA_KHANG = ds.Tables[0].Rows[i][0].ToString(); string SO_SO_TG = ds.Tables[0].Rows[i][1].ToString(); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "MA_KHANG, SO_SO_TG"); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, MA_KHANG + ", " + SO_SO_TG); } nativeQuery = "UPDATE BL_TIEN_GUI SET DU_CHI_LAI = 0 WHERE DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, ds.ToString()); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "BL_TIEN_GUI_LSU PROCESSING"); nativeQuery = "SELECT MA_KHANG, SO_SO_TG FROM BL_TIEN_GUI_LSU where DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string MA_KHANG = ds.Tables[0].Rows[i][0].ToString(); string SO_SO_TG = ds.Tables[0].Rows[i][1].ToString(); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "MA_KHANG, SO_SO_TG"); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, MA_KHANG + ", " + SO_SO_TG); } nativeQuery = "UPDATE BL_TIEN_GUI_LSU SET DU_CHI_LAI = 0 WHERE DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, ds.ToString()); } } } return(SoLuongSoTietKiem); } catch (System.Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } }
public LoginWindow() { InitializeComponent(); // IP, MAC Address new ClientInitProcess().docThongTinCauHinhClient(1); // No IP, MAC Address //docThongTinCauHinhClient(1); if (!ClientInformation.Theme.Equals("default")) { SetThemes(); } /* LANGUAGE */ if (!ClientInformation.LanguageList.Equals("")) { string LanguagePattern = ClientInformation.LanguageList; List <Language> LanguageList = (new Language()).getLanguageList(LanguagePattern); int i = 0; int index = 0; string value = ""; foreach (Language e in LanguageList) { RadComboBoxItem item = new RadComboBoxItem(); item.Content = e.LanguageName; item.Tag = e.LanguageCode; cboLanguage.Items.Add(item); if (e.LanguageStatus.Equals("1")) { index = i; value = e.LanguageStatus; } ++i; } cboLanguage.SelectedIndex = index; //cboLanguage.SelectedValue = value; } else { } /* LANGUAGE */ process = new ZAMainAppProcess(); //Icon & title setting CommonFunction.setIcon(this); //Set licence Aspose Words and Cells MemoryStream aspLic = new MemoryStream(); StreamWriter sw = new StreamWriter(aspLic, Encoding.UTF8); Aspose.Words.License licenseWord = new Aspose.Words.License(); //Set the license of Aspose.Cells to avoid the evaluation //limitations sw.WriteLine(BusinessConstant.asposeWordLic); sw.Flush(); aspLic.Position = 0; licenseWord.SetLicense(aspLic); Aspose.Cells.License licenseExcel = new Aspose.Cells.License(); //Set the license of Aspose.Cells to avoid the evaluation //limitations sw.WriteLine(BusinessConstant.asposeWordLic); sw.Flush(); aspLic.Position = 0; licenseExcel.SetLicense(aspLic); ApplicationConstant.DonViSuDung company = ApplicationConstant.layDonViSuDung(ClientInformation.Company); if (company == ApplicationConstant.DonViSuDung.BINHKHANH) { lblLanguage.Visibility = Visibility.Hidden; cboLanguage.Visibility = Visibility.Hidden; lblTitle.Visibility = Visibility.Visible; //imgConfig.Visibility = Visibility.Collapsed; string ServerPattern = ClientInformation.ServerList; if (!string.IsNullOrEmpty(ServerPattern)) { Server server = new Server(); List <Server> ServerList = server.getServerList(ServerPattern); if (ServerList.Count <= 1) { imgConfig.Visibility = Visibility.Collapsed; } else { foreach (Server item in ServerList) { MenuItem mnuItem = new MenuItem(); mnuItem.Name = "" + item.ServerName; mnuItem.Header = "" + item.ServerName; mnuItem.Uid = "" + item.ServerIP + "#" + item.ServerPort + "#" + item.ServerCode; if (item.ServerName.Equals(ClientInformation.ServerName)) { mnuItem.Icon = new Image { Source = new BitmapImage(new Uri(@"pack://*****:*****@"pack://application:,,,/Utilities.Common;component/Images/Action/approve.png", UriKind.RelativeOrAbsolute)), Width = 12, Height = 12 }; } mnuItem.Click += mnu_Click; mnuConfig.Items.Add(mnuItem); } } } else { imgConfig.Visibility = Visibility.Collapsed; } } else { if (company == ApplicationConstant.DonViSuDung.BIDV || company == ApplicationConstant.DonViSuDung.BIDV_BLF) { //cboLanguage.SelectedIndex = 1; } //imgConfig.Visibility = Visibility.Collapsed; string ServerPattern = ClientInformation.ServerList; if (!string.IsNullOrEmpty(ServerPattern)) { Server server = new Server(); List <Server> ServerList = server.getServerList(ServerPattern); if (ServerList.Count <= 1) { imgConfig.Visibility = Visibility.Collapsed; } else { foreach (Server item in ServerList) { MenuItem mnuItem = new MenuItem(); mnuItem.Name = "" + item.ServerName; mnuItem.Header = "" + item.ServerName; mnuItem.Uid = "" + item.ServerIP + "#" + item.ServerPort + "#" + item.ServerCode; if (item.ServerName.Equals(ClientInformation.ServerName)) { mnuItem.Icon = new Image { Source = new BitmapImage(new Uri(@"pack://application:,,,/Utilities.Common;component/Images/Action/approve.png", UriKind.RelativeOrAbsolute)), Width = 12, Height = 12 }; } mnuItem.Click += mnu_Click; mnuConfig.Items.Add(mnuItem); } } } else { imgConfig.Visibility = Visibility.Collapsed; } } cboLanguage.SelectionChanged += cboLanguage_SelectionChanged; }
public int CapNhatSoTietKiem(ApplicationConstant.DonViSuDung CompanyCode) { return(new DS_ZAMainApp().CapNhatSoTietKiem(CompanyCode)); }
public int CapNhatKheUocDaTatToan(ApplicationConstant.DonViSuDung CompanyCode) { return(new DS_ZAMainApp().CapNhatKheUocDaTatToan(CompanyCode)); }