//SELECT id, noms, adresse, contact, mail, sexe, datenaissance, lieunaissance, etatcivil, niveauetude, fonction, image, username FROM `tagent` WHERE 1 void Modifier(int index) { spl.ShowWaitForm(); rowHandle = gridView1.FocusedRowHandle; object[] data = new object[] { gridView1.GetRowCellValue(rowHandle, "id").ToString(), gridView1.GetRowCellValue(rowHandle, "noms").ToString(), gridView1.GetRowCellValue(rowHandle, "adresse").ToString(), gridView1.GetRowCellValue(rowHandle, "contact").ToString(), gridView1.GetRowCellValue(rowHandle, "mail").ToString(), gridView1.GetRowCellValue(rowHandle, "sexe").ToString(), gridView1.GetRowCellValue(rowHandle, "datenaissance").ToString(), gridView1.GetRowCellValue(rowHandle, "lieunaissance").ToString(), gridView1.GetRowCellValue(rowHandle, "etatcivil").ToString(), gridView1.GetRowCellValue(rowHandle, "niveauetude").ToString(), gridView1.GetRowCellValue(rowHandle, "fonction").ToString(), gridView1.GetRowCellValue(rowHandle, "image"), gridView1.GetRowCellValue(rowHandle, "qrCode"), gridView1.GetRowCellValue(rowHandle, "username").ToString(), gridView1.GetRowCellValue(rowHandle, "password").ToString(), gridView1.GetRowCellValue(rowHandle, "usersession").ToString() }; if (index == 1) { new frm_AddAgent(spl, this, data).ShowDialog(); } }
void Modifier(int index) { spl.ShowWaitForm(); rowHandle = gridView1.FocusedRowHandle; object[] data = new object[] { gridView1.GetRowCellValue(rowHandle, "id").ToString(), gridView1.GetRowCellValue(rowHandle, "noms").ToString(), gridView1.GetRowCellValue(rowHandle, "adresse").ToString(), gridView1.GetRowCellValue(rowHandle, "contact").ToString(), gridView1.GetRowCellValue(rowHandle, "mail").ToString(), gridView1.GetRowCellValue(rowHandle, "typepieceid").ToString(), gridView1.GetRowCellValue(rowHandle, "numeropieceid").ToString(), gridView1.GetRowCellValue(rowHandle, "image").ToString(), gridView1.GetRowCellValue(rowHandle, "username").ToString(), gridView1.GetRowCellValue(rowHandle, "password").ToString(), gridView1.GetRowCellValue(rowHandle, "usersession").ToString() }; if (index == 1) { new frm_AddChauffeur(spl, this, data).ShowDialog(); } //else if (index == 2) new frm_AddPasser(spl, data).ShowDialog(); }
public static void ShowWaitForm() { if (_splashScreenManager == null) { return; } _splashScreenManager.ShowWaitForm(); }
private void Item_ItemClick(object sender, TileItemEventArgs e) { if (e.Item.Tag != null || File.Exists(e.Item.Tag.ToString())) { splashManager.ShowWaitForm(); XSheetMain xshet = new XSheetMain(e.Item.Tag.ToString()); this.Hide(); xshet.Owner = this; splashManager.CloseWaitForm(); } }
private static void SplashBaslat(SplashScreenManager manager) { if (manager.IsSplashFormVisible) { manager.CloseWaitForm(); manager.ShowWaitForm(); } else { manager.ShowWaitForm(); } }
private void ExportAllData(string text) { string selectedPath = string.Empty; FolderBrowserDialog fileDialog = new FolderBrowserDialog(); if (fileDialog.ShowDialog() == DialogResult.OK) { selectedPath = fileDialog.SelectedPath; } if (string.IsNullOrEmpty(selectedPath) == true) { return; } string folderPath = string.Empty; using (var ssm = new SplashScreenManager(this, typeof(SysWaitForm), true, true)) { ssm.ShowWaitForm(); ssm.SetWaitFormDescription("正在" + text + "保存..."); folderPath = Path.Combine(selectedPath, "ExportpData"); this.ExportDataToPath(folderPath); ssm.CloseWaitForm(); MessageBox.Show(this, "全部数据" + text + "成功!文件夹名:ExportpData", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } Process.Start(folderPath); }
protected void BeforeOperation() { if (!_splash.IsSplashFormVisible && _ativo) { _splash.ShowWaitForm(); } }
public static void StartWait() { if (!splashManager.IsSplashFormVisible) { splashManager.ShowWaitForm(); } }
/// <summary>单击事件 /// 单击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BarButtonItem_ItemClick(object sender, ItemClickEventArgs e) { try { //获取左侧栏的name值 string strPageName = e.Link.Item.Name; string strCaption = e.Link.Caption; string strUrl = e.Link.Item.Tag.ToString(); if (StaticInfoHelper.IsOpen == 0) { SplashScreenManager.ShowWaitForm(); SplashScreenManager.SetWaitFormCaption("正在努力打开"); SplashScreenManager.SetWaitFormDescription("第一个页面加载稍微慢点,稍等一会"); OpenForm(this, strPageName, strCaption, strUrl); SplashScreenManager.CloseWaitForm(); StaticInfoHelper.IsOpen = 1; } else if (StaticInfoHelper.IsOpen == 1) { OpenForm(this, strPageName, strCaption, strUrl); } tabControl.Visible = MdiChildren.Length <= 0; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
internal void ShowLoading(string caption, string description) { this.Enabled = false; ssmLoader.ShowWaitForm(); ssmLoader.SetWaitFormCaption(caption); ssmLoader.SetWaitFormDescription(description); }
/// <summary> /// This method is called to show a form in the MainForm as a MDIChildform /// http://www.codeproject.com/Articles/9162/Invoking-methods-Runtime-on-method-name /// </summary> /// <remarks>Created: Henko Rabie 15/10/2013</remarks> public void ShowWaitForm() { if (!splash.IsSplashFormVisible) { splash.ShowWaitForm(); } }
public void ShowWaitForm() { if (splash.IsSplashFormVisible) { splash.CloseWaitForm(); } splash.ShowWaitForm(); }
private void switchUC(UserControl uc) { spl.ShowWaitForm(); panelConf.Controls.Clear(); uc.Dock = panelConf.Dock; panelConf.Controls.Add(uc); spl.CloseWaitForm(); }
private void btnImportar_Click(object sender, EventArgs e) { var resultado = XtraMessageBox.Show("¿Desea importar los empleados del cliente seleccionado a la empresa actual?", "Confirmación", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (resultado.Equals(DialogResult.Yes)) { try { string EmpresaNominaID = Properties.Settings.Default["EmpresaNominaID"].ToString(); if (splash.IsSplashFormVisible.Equals(false)) { splash.ShowWaitForm(); } for (int i = 0; i < gridViewEmpl.RowCount; i++) { empleado.Add(new E.Empleado { NumEmpl = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[1]).ToString(), Nombre = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[2]).ToString(), RFC = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[3]).ToString(), Correo = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[4]).ToString(), CURP = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[5]).ToString(), TipoRegimen = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[6]).ToString(), Departamento = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[8]).ToString(), cuenta = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[9]).ToString(), clabe_bancaria = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[10]).ToString(), cve_banco = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[11]).ToString(), banco = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[12]).ToString(), Puesto = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[14]).ToString(), TipoContrato = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[15]).ToString(), Periodicidad = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[17]).ToString(), Sindicalizado = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[10]).ToString(), idEmpresa = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[23]).ToString(), empresa = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[24]).ToString(), descuento = Convert.ToDecimal(gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[25]).ToString()), tipoPago = gridViewEmpl.GetRowCellValue(i, gridViewEmpl.Columns[26]).ToString(), nominaEmpresaID = EmpresaNominaID }); } controlador.ImportaEmpleado(lookUpEmpr.Text, empresaActiva, empleado, usuario, splash, EmpresaNominaID); empleado.Clear(); } catch (Exception imp) { if (splash.IsSplashFormVisible.Equals(true)) { splash.CloseWaitForm(); } empleado.Clear(); XtraMessageBox.Show("Error btnImportar: " + imp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public virtual void BatchSubmit(SplashScreenManager splash) { string clipboard = Clipboard.GetText(); DataTable dtInput = new DataTable(); DataRow nR; if (!clipboard.Contains((char)(10))) { XtraMessageBox.Show("复制的内容格式不正确", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (!clipboard.Contains((char)(9))) { XtraMessageBox.Show("复制的内容格式不正确", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } dtInput.Columns.Add("SFI单号"); dtInput.Columns.Add("代理单号"); string[] strs = clipboard.Split((char)(10)); string enter = ((char)13).ToString(); string tmpStr; foreach (string s in strs) { tmpStr = s.Replace(enter, ""); if (!string.IsNullOrEmpty(tmpStr)) { nR = dtInput.NewRow(); nR[0] = tmpStr.Split((char)(9))[0]; nR[1] = tmpStr.Split((char)(9))[1]; dtInput.Rows.Add(nR); } } InputDataFrm inputDataFrm = new InputDataFrm(dtInput, SelectedAgent.AGid); DialogResult DResult = inputDataFrm.ShowDialog(); if (DResult == DialogResult.OK) { splash.ShowWaitForm(); string sqlStr = $"select * from tb_SFI_TrackNum where int_AGid={SelectedAgent.AGid} AND CONVERT(varchar(10),tb_SFI_TrackNum.dttm_updateDttm,112) ='{ImportDate.ToString("yyyyMMdd")}';"; LoadNewAddedTrackNos(sqlStr); splash.CloseWaitForm(); } else if (DResult == DialogResult.Abort) { XtraMessageBox.Show("添加数据失败", "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (DResult == DialogResult.Cancel) { XtraMessageBox.Show("用户取消操作", "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Показать форму ожидания загрузки /// </summary> public void ShowWaitForm(string caption = null) { if (ssManager.IsSplashFormVisible) { return; } if (!string.IsNullOrEmpty(caption)) { ssManager.SetWaitFormCaption(caption); } ssManager.ShowWaitForm(); }
public static void CallWaitForm(XtraForm frmParent) { try { if (ssmWait == null || !ssmWait.IsSplashFormVisible) { ssmWait = new SplashScreenManager(frmParent, typeof(frmWaiting), true, true); ssmWait.ShowWaitForm(); SetCaptionWaitForm("Vui lòng chờ!", "Đang xử lý..."); } } catch { } }
public static void ShowWaitForm(this UserControl owner) { if (Managers.ContainsKey(owner)) { return; } SplashScreenManager manager = new SplashScreenManager(typeof(UserControlWaitForm), SplashFormStartPosition.Manual, owner.Parent.PointToScreen(owner.Location), new SplashFormProperties()); Managers.Add(owner, manager); manager.ShowWaitForm(); manager.SendCommand(UserControlWaitFormCommand.SetSize, owner.Size); }
private void btnGuardar_Click(object sender, EventArgs e) { var respuesta = XtraMessageBox.Show("¿Desea guardar los cambios?", "Confirmación", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (respuesta.Equals(DialogResult.Yes)) { splash.ShowWaitForm(); var listaBancos = new List <E.Banco>(); for (int i = 0; i < gridViewSucursales.RowCount; i++) { cve = gridViewSucursales.GetRowCellValue(i, gridViewSucursales.Columns[0]).ToString(); desc = gridViewSucursales.GetRowCellValue(i, gridViewSucursales.Columns[1]).ToString(); rsocial = gridViewSucursales.GetRowCellValue(i, gridViewSucursales.Columns[2]).ToString(); listaBancos.Add(new E.Banco { cveBanco = cve, nombre = desc, razonSocial = rsocial }); } if (controlador.modificaListaBancos(listaBancos, splash).Equals(true)) { splash.CloseWaitForm(); XtraMessageBox.Show("!Información actualizada¡", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); layoutControlBtnAgregar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlbtnEliminar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlBtnEditar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlbtnGuardar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; layoutControlbtnCancelar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; gridViewSucursales.OptionsBehavior.Editable = false; this.LlenaTabla(); } else { XtraMessageBox.Show("!Error al intentar actualizar información¡", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); layoutControlBtnAgregar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlbtnEliminar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlBtnEditar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlbtnGuardar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; layoutControlbtnCancelar.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; gridViewSucursales.OptionsBehavior.Editable = false; } } }
public void ShowWaitForm(string description, string caption = "") { if (!ssm.IsSplashFormVisible) { ssm.ShowWaitForm(); } if (caption == "") { ssm.SetWaitFormCaption("请稍等......"); } else { ssm.SetWaitFormCaption(caption); } ssm.SetWaitFormDescription(description); }
public virtual void Submit(SplashScreenManager splash) { splash.ShowWaitForm(); ImportDate = DateTime.Now; AgentNo = string.Empty; OrderNo = string.Empty; if (string.IsNullOrWhiteSpace(OrderNo2)) { splash.CloseWaitForm(); XtraMessageBox.Show("订单号不能为空", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (string.IsNullOrWhiteSpace(AgentNo2)) { splash.CloseWaitForm(); XtraMessageBox.Show("DPD单号不能为空", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } string str = "0123456789"; string aGawbSign = ""; for (int i = AgentNo2.Length - 1; i >= 0; i += -1) { if (str.LastIndexOf(AgentNo2.Substring(i, 1)) != 0) { aGawbSign = AgentNo2.Substring(i, 1); break; } } if (string.IsNullOrWhiteSpace(aGawbSign)) { //获取最后一位的值 aGawbSign = AgentNo2.Substring(AgentNo2.Length - 2, 1); } string sqlStr = $"INSERT INTO tb_SFI_TrackNum (vchar_SFInum, vchar_AGnum, int_AGid, vchar_updateUser, dttm_updateDttm,char_AG_Syn_sign) VALUES ('{OrderNo2}','{AgentNo2}','{SelectedAgent.AGid}','{MainFrm.CurrentUser}',GETDATE(),'{aGawbSign}');"; sqlStr = $"{sqlStr} select * from tb_SFI_TrackNum where int_AGid={SelectedAgent.AGid} AND CONVERT(varchar(10),tb_SFI_TrackNum.dttm_updateDttm,112) ='{ImportDate.ToString("yyyyMMdd")}';"; IList <SFITrackNum> tracks = SQLHelper.GetObject <SFITrackNum>(sqlStr).ToList(); LoadNewAddedTrackNos(sqlStr); splash.CloseWaitForm(); }
public static void Start(string statusText) { if (!SplashScreenManager.IsSplashFormVisible) { lock (ThisLock) { if (!SplashScreenManager.IsSplashFormVisible) { SplashScreenManager.ShowWaitForm(); SplashScreenManager.SetWaitFormDescription(statusText); } } } else { SplashScreenManager.SetWaitFormDescription(statusText); } }
public static void ExportGridToWord(GridView GridControl1, SplashScreenManager splashScreenManager1) { try { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Files(*.RTF)|*.RTF"; saveFileDialog.AddExtension = true; saveFileDialog.DefaultExt = ".RTF"; if (saveFileDialog.ShowDialog() == DialogResult.OK && saveFileDialog.CheckPathExists) { if (splashScreenManager1 != null) { splashScreenManager1.ShowWaitForm(); splashScreenManager1.SetWaitFormDescription("Exporting..Please Wait"); } GridControl1.ExportToRtf(saveFileDialog.FileName); if (splashScreenManager1 != null) { splashScreenManager1.CloseWaitForm(); } if (MessageBox.Show(@"Do you wish to open the RTF file now?", @"Export to RTF", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Process proc = new Process(); proc.StartInfo.FileName = saveFileDialog.FileName; proc.Start(); } } } catch (Exception ex) { if (splashScreenManager1 != null && splashScreenManager1.IsSplashFormVisible) { splashScreenManager1.CloseWaitForm(); } MessageBox.Show(ex.ToString()); } }
/// <summary> /// 生成要显示在Tab中的Form /// </summary> /// <param name="strTitle"></param> /// <param name="strTag"></param> /// <param name="frmBase"></param> /// <param name="image"></param> private void CreateMDIControl(string strTitle, string strTag, Form frmBase) { try { DevExpress.XtraTabbedMdi.XtraMdiTabPage currentPage = null; if (currentPage == null) { // 等待加载窗口 loading.ShowWaitForm(); // 设置Form属性 frmBase.Dock = DockStyle.Fill; frmBase.Text = strTitle; frmBase.Tag = strTag; frmBase.Location = new Point(100, 100); frmBase.MdiParent = this.parent; frmBase.Show(); // 记录当前Tab中的Page currentPage = xtraTabbedMdiMgr.SelectedPage; } else { xtraTabbedMdiMgr.SelectedPage = currentPage; } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } finally { // 关闭加载窗口 loading.CloseWaitForm(); } }
public void Show() { sm.ShowWaitForm(); }
/// <summary> /// [EN] ShowWaitForm /// Create By: ManhNV1 -Date:02/25/2016 /// Descripton: ShowWaitForm /// </summary> /// <param name="frmWaitForm">Form Used</param> /// <param name="strCaption"> /// Title WaitForm: /// if strCaption = null => Value = Please Wait /// else => Value = strCaption /// </param> /// <param name="strDescription">Description WaitForm</param> /// <returns>SplashScreenManager Type</returns> public static SplashScreenManager ShowWaitForm(Form frmWaitForm, string strCaption , string strDescription) { var splashScreenManager = new SplashScreenManager(frmWaitForm , typeof (WaitFormPlease), true, true); splashScreenManager.ShowWaitForm(); if (strCaption == null) splashScreenManager.SetWaitFormCaption(SEDConst.SET_PLEASE_WAIT); else splashScreenManager.SetWaitFormCaption(strCaption); // Nếu Null thì dùng strDescription không thì Set_Loading splashScreenManager.SetWaitFormDescription(strDescription ?? SEDConst.SET_LOADING); return splashScreenManager; }
//TODO Comment public static bool CheckConnectTimeOutWait(SplashScreenManager splashScreenManager) { if (IsConnectedToInternet() == false) { splashScreenManager.ShowWaitForm(); //TODO Set Constant splashScreenManager.SetWaitFormCaption("Checking the network connection!"); splashScreenManager.SetWaitFormDescription(SEDConst.SET_PLEASE_WAIT); Thread.Sleep(7000); splashScreenManager.CloseWaitForm(); if (IsConnectedToInternet() == false) { //TODO Set Constant XtraMessageBox.Show("Connect Timout. Checking the network connection...!", SEDConst.MESSAGE_WARNING_DISCONNECTED); return false; } return true; } return true; }
/// <summary> /// 显示进度条 /// </summary> /// <param name="manager">进度条</param> /// <param name="caption">标题</param> /// <param name="description">描述</param> /// Author : Napoleon /// Created : 2015-02-26 20:30:27 protected void ShowManager(SplashScreenManager manager, string caption, string description) { manager.ShowWaitForm(); manager.SetWaitFormCaption(caption); manager.SetWaitFormDescription(description); }
public virtual void RefreshLogs(SplashScreenManager splash) { splash.ShowWaitForm(); trackRecordLogs = GetTrackRecordLogs(); splash.CloseWaitForm(); }
/// <summary> /// 查询运单信息 /// </summary> /// <param name="para"></param> public virtual void Search(SplashScreenManager splash) { splash.ShowWaitForm(); #region 拼接sql语句的where条件 string sqlWhere = $" tb_SFI_TrackNum.int_AGid={SelectedAgent.AGid}"; if (!string.IsNullOrWhiteSpace(OrderNo)) { if (OrderNo.IndexOf(",") > 0) { sqlWhere = $"{sqlWhere} AND tb_SFI_TrackNum.vchar_SFInum in ("; string[] strs = OrderNo.Split(','); foreach (string str in strs) { sqlWhere = $"{sqlWhere}'{str}',"; } sqlWhere = $"{sqlWhere.TrimEnd(',')})"; } else { sqlWhere = $"{sqlWhere} AND tb_SFI_TrackNum.vchar_SFInum='{OrderNo}'"; } } if (!string.IsNullOrWhiteSpace(AgentNo)) { if (AgentNo.IndexOf(",") > 0) { sqlWhere = $"{sqlWhere} AND tb_SFI_TrackNum.vchar_AGnum in ("; string[] strs = AgentNo.Split(','); foreach (string str in strs) { sqlWhere = $"{sqlWhere}'{str}',"; } sqlWhere = $"{sqlWhere.TrimEnd(',')})"; } else { sqlWhere = $"{sqlWhere} AND tb_SFI_TrackNum.vchar_AGnum='{OrderNo}'"; } } sqlWhere = $"{sqlWhere} AND CONVERT(varchar(10),tb_SFI_TrackNum.dttm_updateDttm,112) ='{ImportDate.ToString("yyyyMMdd")}'"; //string sqlSelect = $"SELECT tb_SFI_TrackNum.int_Mappingid AS 数据编号, tb_SFI_TrackNum.vchar_SFInum AS SFI单号,tb_SFI_TrackNum.vchar_AGnum AS 代理单号, (CONVERT(varchar(10),tb_SFI_TrackNum.int_AGid) + N'-' + tb_Agent.vchar_AGname) AS 代理名称, tb_SFI_TrackNum.dttm_updateDttm AS 数据导入时间, tb_SFI_TrackNum.dttm_AG_LastSyn AS 最后同步时间, tb_SFI_TrackNum.char_IsStop AS 运输服务完毕 FROM tb_SFI_TrackNum INNER JOIN tb_Agent ON tb_SFI_TrackNum.int_AGid = tb_Agent.int_AGid WHERE {sqlWhere} ORDER BY tb_SFI_TrackNum.dttm_updateDttm DESC"; string sqlSelect = $"SELECT tb_SFI_TrackNum.int_Mappingid, tb_SFI_TrackNum.vchar_SFInum,tb_SFI_TrackNum.vchar_AGnum , (CONVERT(varchar(10),tb_SFI_TrackNum.int_AGid) + N'-' + tb_Agent.vchar_AGname), tb_SFI_TrackNum.dttm_updateDttm, tb_SFI_TrackNum.dttm_AG_LastSyn, tb_SFI_TrackNum.char_IsStop FROM tb_SFI_TrackNum INNER JOIN tb_Agent ON tb_SFI_TrackNum.int_AGid = tb_Agent.int_AGid WHERE {sqlWhere} ORDER BY tb_SFI_TrackNum.dttm_updateDttm DESC"; //DataSet ds = SQLHelper.GetDataSet(sqlSelect); //if (ds != null && ds.Tables.Count == 1) //{ // //para.Grid.BeginUpdate(); // //para.Grid.DataSource = ds.Tables[0].DefaultView; // //para.Grid.EndUpdate(); //} var tracks = (SQLHelper.GetObject <SFITrackNum>(sqlSelect)).ToList(); trackNumInfos.Clear(); if (tracks.Count > 0) { foreach (SFITrackNum track in tracks) { trackNumInfos.Add(track); } } else { trackNumInfos.Clear(); } splash.CloseWaitForm(); #endregion }
/// <summary> /// Backups the database. /// </summary> /// <returns></returns> public static bool BackupDatabase(SplashScreenManager splashScreenManager, string backupName, bool openBackupFolder) { try { var globalVariable = new GlobalVariable(); if (splashScreenManager != null) { splashScreenManager.ShowWaitForm(); splashScreenManager.SetWaitFormCaption("Đang sao lưu dữ liệu"); splashScreenManager.SetWaitFormDescription("Vui lòng đợi .."); } var databaseNameForBackup = RegistryHelper.GetValueByRegistryKey("DatabaseName"); var databaseForBackup = GlobalVariable.Server.Databases[databaseNameForBackup]; var backup = new Backup { //option for backup Action = BackupActionType.Database, BackupSetDescription = "Sao lưu CSDL, ngày " + DateTime.Now, BackupSetName = databaseNameForBackup + " Backup", Database = databaseForBackup.Name }; //create backupdevice var folderBackup = globalVariable.DailyBackupPath; var dateTimeString = "NG" + DateTime.Now.Day.ToString(CultureInfo.InvariantCulture) + "T" + DateTime.Now.Month.ToString(CultureInfo.InvariantCulture) + "N" + DateTime.Now.Year.ToString(CultureInfo.InvariantCulture) + "_" + DateTime.Now.Hour.ToString(CultureInfo.InvariantCulture) + "GI" + DateTime.Now.Minute.ToString(CultureInfo.InvariantCulture) + "P"; var databaseName = databaseNameForBackup + "_" + (string.IsNullOrEmpty(backupName) ? "" : backupName) + "_" + dateTimeString + ".bak"; //LINHMC kiem tra neu folder ko ton tai thi tao if (string.IsNullOrEmpty(folderBackup)) { DriveInfo[] allDrives = DriveInfo.GetDrives(); if (allDrives.Length > 1) { folderBackup = allDrives[1].Name + @"BACKUP_A_BIGTIME"; } else { folderBackup = allDrives[0].Name + @"BACKUP_A_BIGTIME"; } } if (!Directory.Exists(folderBackup)) { Directory.CreateDirectory(folderBackup); } var fileBackup = folderBackup + @"\" + databaseName; if (File.Exists(fileBackup)) { XtraMessageBox.Show(ResourceHelper.GetResourceValueByName("ResFileBackupExits"), ResourceHelper.GetResourceValueByName("ResExceptionCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } var backupDevice = new BackupDeviceItem(fileBackup, DeviceType.File); backup.Devices.Add(backupDevice); backup.Incremental = false; backup.SqlBackup(GlobalVariable.Server); //Cách nén file này chỉ dùng trong trường hợp hệ quản trị dữ liệu và chương trình cùng nằm trên 1 máy using (var zip = new ZipFile()) { zip.AddFile(fileBackup, ""); var zipFileName = fileBackup.Replace(".bak", ".zip"); zip.ParallelDeflateThreshold = -1; zip.Save(zipFileName); File.Delete(fileBackup); } if (splashScreenManager != null) { splashScreenManager.CloseWaitForm(); } if (openBackupFolder) { Process.Start(folderBackup); } return(true); } catch (Exception ex) { if (splashScreenManager != null) { splashScreenManager.CloseWaitForm(); } XtraMessageBox.Show(ex.ToString(), ResourceHelper.GetResourceValueByName("ResExceptionCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
private void BtnGenerarReporte_Click(object sender, EventArgs e) { try { if (LookUpMeses.Text.Equals("Seleccione")) { XtraMessageBox.Show("Por favor seleccione mes.", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { mes = LookUpMeses.EditValue.ToString(); } if (LookUpAño.Text.Equals("Seleccione")) { XtraMessageBox.Show("Por favor seleccione año.", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { año = LookUpAño.EditValue.ToString(); } splash.ShowWaitForm(); splash.SetWaitFormCaption("Generando Reporte.."); XtraReport reporte; reporte = new Reports.RepNomina(mes, año); ReportPrintTool printTool = new ReportPrintTool(reporte); PrintControl printControl = printTool.PreviewForm.PrintControl; //PrintControl printControl = printTool.PreviewRibbonForm.PrintControl; // Zoom the document, so that it fits the entire page into the Print Preview's dimensions. if (printControl.CanExecCommand(PrintingSystemCommand.ViewWholePage)) { printControl.ExecCommand(PrintingSystemCommand.ViewWholePage); } // Invoke the Hand tool to scroll the document using the mouse. if (printControl.CanExecCommand(PrintingSystemCommand.HandTool)) { printControl.ExecCommand(PrintingSystemCommand.HandTool, new object[] { true }); } // Hide the Hand tool. //if (printControlCanExecCommand(PrintingSystemCommand.HandTool)) { // printControl.ExecCommand(PrintingSystemCommand.HandTool, new object[] { false }); //} // Show the report's Print Preview in a dialog window. printControl.Zoom = 1.2F; printTool.ShowPreview(); splash.CloseWaitForm(); //printTool.ShowPreviewDialog(); //printTool.ShowRibbonPreviewDialog(); } catch (Exception genRep) { splash.CloseWaitForm(); XtraMessageBox.Show(genRep.Message + "mostrarReporte()", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }