public FrmCollectionControl() { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); InitializeComponent(); publicStreetGroup = this; setImages(); ToolStripEvent(); iTransType = TransactionTypeCode.New; Load += OnFormLoad; openForm(); gridView1.DoubleClick += gridView1_DoubleClick; cboBank.KeyPress += cboBank_KeyPress; txtClosing.Leave += txtClosing_Leave; //txtOpening.LostFocus += txtOpening_LostFocus; txtOpening.Leave += txtOpening_Leave; //txtTransfer.LostFocus += txtTransfer_LostFocus; txtTransfer.Leave += txtTransfer_Leave; txtTrans.EditValueChanged += txtTrans_EditValueChanged; txtTrans.Leave += txtTrans_Leave; bttnUpdate.Click += bttnUpdate_Click; bttnReport.Click += bttnReport_Click; bttnPay.Click += bttnPay_Click; bttnIGR.Click += bttnIGR_Click; //dtpStart.ValueChanged += dtpStart_ValueChanged; //dtpEnd.ValueChanged += dtpEnd_ValueChanged; cboAccount.SelectedIndexChanged += cboAccount_SelectedIndexChanged; cboBank.SelectedIndexChanged += cboBank_SelectedIndexChanged; txtClose.Leave += txtClose_Leave; txtopen.Leave += txtopen_Leave; txtAdvance.Leave += txtAdvance_Leave; txtCharges.Leave += TxtCharges_Leave; OnFormLoad(null, null); SplashScreenManager.CloseForm(false); }
private void docBookRating_LinkPressed(object sender, NavBarLinkEventArgs e) { SplashScreenManager.ShowForm(this, typeof(Base.Waiting), true, true, false); DocumentLoading("AllRating.repx"); SplashScreenManager.CloseForm(false); }
private void btnImport_Click(object sender, EventArgs e) { SplashScreenManager.ShowForm(typeof(WaitForm2)); // data from file SITES_BUS busSite = new SITES_BUS(); FACILITY_BUS busFacility = new FACILITY_BUS(); MANUFACTURER_BUS busManufacture = new MANUFACTURER_BUS(); DESIGN_CODE_BUS busDesign = new DESIGN_CODE_BUS(); EQUIPMENT_MASTER_BUS busEqMaster = new EQUIPMENT_MASTER_BUS(); COMPONENT_MASTER_BUS busComMaster = new COMPONENT_MASTER_BUS(); RW_ASSESSMENT_BUS busAss = new RW_ASSESSMENT_BUS(); RW_EQUIPMENT_BUS busEq = new RW_EQUIPMENT_BUS(); RW_COMPONENT_BUS buscom = new RW_COMPONENT_BUS(); RW_EXTCOR_TEMPERATURE_BUS busExcort = new RW_EXTCOR_TEMPERATURE_BUS(); RW_STREAM_BUS busStream = new RW_STREAM_BUS(); RW_MATERIAL_BUS busMaterial = new RW_MATERIAL_BUS(); RW_COATING_BUS busCoat = new RW_COATING_BUS(); RW_INPUT_CA_LEVEL_1_BUS busInputCA = new RW_INPUT_CA_LEVEL_1_BUS(); FACILITY_RISK_TARGET_BUS busRiskTarget = new FACILITY_RISK_TARGET_BUS(); Bus_PLANT_PROCESS_Excel busExcelProcess = new Bus_PLANT_PROCESS_Excel(); busExcelProcess.path = txtPathFileExcel.Text; List <SITES> listSite = busExcelProcess.getAllSite(); foreach (SITES s in listSite) { if (!busSite.checkExist(s.SiteName)) { busSite.add(s); } else { busSite.edit(s); } } List <FACILITY> listFacility = busExcelProcess.getFacility(); foreach (FACILITY f in listFacility) { if (busFacility.checkExist(f.FacilityName)) { busFacility.edit(f); } else { busFacility.add(f); int FaciID = busFacility.getLastFacilityID(); FACILITY_RISK_TARGET riskTarget = new FACILITY_RISK_TARGET(); riskTarget.FacilityID = FaciID; busRiskTarget.add(riskTarget); } } List <string> manufacture = busExcelProcess.getAllManufacture(); for (int i = 0; i < manufacture.Count; i++) { MANUFACTURER manu = new MANUFACTURER(); manu.ManufacturerID = busManufacture.getIDbyName(manufacture[i]); manu.ManufacturerName = manufacture[i]; if (busManufacture.getIDbyName(manufacture[i]) == 0) { busManufacture.add(manu); } else { busManufacture.edit(manu); } } List <String> designcode = busExcelProcess.getAllDesigncode(); for (int i = 0; i < designcode.Count; i++) { DESIGN_CODE design = new DESIGN_CODE(); design.DesignCodeID = busDesign.getIDbyName(designcode[i]); design.DesignCode = designcode[i]; design.DesignCodeApp = ""; if (design.DesignCodeID == 0) { busDesign.add(design); } else { busDesign.edit(design); } } List <EQUIPMENT_MASTER> listEpMaster = busExcelProcess.getEquipmentMaster(); foreach (EQUIPMENT_MASTER eqM in listEpMaster) { if (busEqMaster.check(eqM.EquipmentNumber)) { busEqMaster.edit(eqM); } else { busEqMaster.add(eqM); } } List <COMPONENT_MASTER> listComMaster = busExcelProcess.getComponentMaster(); foreach (COMPONENT_MASTER comM in listComMaster) { if (busComMaster.checkExist(comM.ComponentNumber)) { busComMaster.edit(comM); } else { busComMaster.add(comM); } } List <RW_ASSESSMENT> listRW_Assessment = busExcelProcess.getAssessment(); List <int> editExcel = new List <int>(); List <int> addExcel = new List <int>(); foreach (RW_ASSESSMENT rwAss in listRW_Assessment) { //kiem tra xem Proposal add bang file Excel hay add bang tay List <int[]> ID_checkAddbyExcel = busAss.getCheckAddExcel_ID(rwAss.ComponentID, rwAss.EquipmentID); if (ID_checkAddbyExcel.Count != 0) { for (int i = 0; i < ID_checkAddbyExcel.Count; i++) { if (ID_checkAddbyExcel[i][0] != 0) //kiem tra xem co phai Assessment nay duoc them tu file Excel ko, !=0 la them tu file Excel { rwAss.ID = ID_checkAddbyExcel[i][1]; editExcel.Add(rwAss.ID); busAss.edit(rwAss); } } } else { rwAss.AddByExcel = 1; busAss.add(rwAss); int assID = busAss.getLastID(); addExcel.Add(assID); RW_INPUT_CA_LEVEL_1 inputCA = new RW_INPUT_CA_LEVEL_1(); inputCA.ID = assID; busInputCA.add(inputCA); } } List <RW_EQUIPMENT> listRw_eq = busExcelProcess.getRwEquipment(); for (int i = 0; i < listRw_eq.Count; i++) { if (editExcel.Count != 0) { for (int j = 0; j < editExcel.Count; j++) { if (listRw_eq[i].ID == editExcel[j]) { busEq.edit(listRw_eq[i]); } } } if (addExcel.Count != 0) { for (int j = 0; j < addExcel.Count; j++) { if (listRw_eq[i].ID == addExcel[j]) { busEq.add(listRw_eq[i]); } } } } List <RW_COMPONENT> listRw_com = busExcelProcess.getRwComponent(); for (int i = 0; i < listRw_com.Count; i++) { if (editExcel.Count != 0) { for (int j = 0; j < editExcel.Count; j++) { if (listRw_com[i].ID == editExcel[j]) { buscom.edit(listRw_com[i]); } } } if (addExcel.Count != 0) { for (int j = 0; j < addExcel.Count; j++) { if (listRw_com[i].ID == addExcel[j]) { buscom.add(listRw_com[i]); } } } } List <RW_EXTCOR_TEMPERATURE> listRw_extcor = busExcelProcess.getRwExtTemp(); //MessageBox.Show(listRw_extcor.Count.ToString()); for (int i = 0; i < listRw_extcor.Count; i++) { if (editExcel.Count != 0) { for (int j = 0; j < editExcel.Count; j++) { if (listRw_extcor[i].ID == editExcel[j]) { //MessageBox.Show("add file excel"); busExcort.edit(listRw_extcor[i]); } } } if (addExcel.Count != 0) { for (int j = 0; j < addExcel.Count; j++) { if (listRw_extcor[i].ID == addExcel[j]) { //MessageBox.Show("add file excel"); busExcort.add(listRw_extcor[i]); } } } } List <RW_STREAM> listRw_stream = busExcelProcess.getRwStream(); for (int i = 0; i < listRw_stream.Count; i++) { if (editExcel.Count != 0) { for (int j = 0; j < editExcel.Count; j++) { if (listRw_stream[i].ID == editExcel[j]) { busStream.edit(listRw_stream[i]); } } } if (addExcel.Count != 0) { for (int j = 0; j < addExcel.Count; j++) { if (listRw_stream[i].ID == addExcel[j]) { busStream.add(listRw_stream[i]); } } } } List <RW_MATERIAL> listRw_material = busExcelProcess.getRwMaterial(); for (int i = 0; i < listRw_material.Count; i++) { if (editExcel.Count != 0) { for (int j = 0; j < editExcel.Count; j++) { if (listRw_material[i].ID == editExcel[j]) { busMaterial.edit(listRw_material[i]); } } } if (addExcel.Count != 0) { for (int j = 0; j < addExcel.Count; j++) { if (listRw_material[i].ID == addExcel[j]) { busMaterial.add(listRw_material[i]); } } } } List <RW_COATING> listRw_coat = busExcelProcess.getRwCoating(); for (int i = 0; i < listRw_coat.Count; i++) { if (editExcel.Count != 0) { for (int j = 0; j < editExcel.Count; j++) { if (listRw_coat[i].ID == editExcel[j]) { busCoat.edit(listRw_coat[i]); } } } if (addExcel.Count != 0) { for (int j = 0; j < addExcel.Count; j++) { if (listRw_coat[i].ID == addExcel[j]) { busCoat.add(listRw_coat[i]); } } } } ButtonOKClicked = true; SplashScreenManager.CloseForm(); MessageBox.Show("All data have been saved! You need to add Risk Target in Facility!", "Cortek RBI", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); this.Close(); }
void bttnUpdate_Click(object sender, EventArgs e) { DataRowView oDataRowView = cboBatch.SelectedItem as DataRowView; if (radioGroup1.SelectedIndex == -1) { Common.setEmptyField("IGR Report Options...", Program.ApplicationName); return; } else { try { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); if (oDataRowView != null) { if (radioGroup1.EditValue == "Bank")//Call Report for bank Reconciliation { using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("doIGRReport", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Bank"; _command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"]; _command.CommandTimeout = 0; using (System.Data.DataSet ds = new System.Data.DataSet()) { ds.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(ds); connect.Close(); if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00") { XtraRepGen report = new XtraRepGen(); report.xrLabel18.Text = String.Format(" for the month of : [{0}]", oDataRowView.Row["BatchName"]); report.DataSource = ds.Tables[1]; report.DataMember = "table"; report.ShowPreviewDialog(); } else { return; } } } } else if (radioGroup1.EditValue == "Agency") { using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("doIGRReport", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Agency"; _command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"]; _command.CommandTimeout = 0; using (System.Data.DataSet ds = new System.Data.DataSet()) { ds.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(ds); connect.Close(); if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00") { XtraRepSummrayAgency repAgency = new XtraRepSummrayAgency() { DataSource = ds, DataMember = "table" }; repAgency.xrLabel32.Text = string.Format(" {0} STATE GOVERNMENT ", Program.StateName.ToUpper()); repAgency.xrLabel33.Text = string.Format("Summary of Collection by Agencies for the Month of {0}", oDataRowView.Row["BatchName"]); repAgency.DataSource = ds.Tables[1]; repAgency.DataMember = "ViewReconciliationAgencyDetails"; repAgency.ShowPreviewDialog(); } else { return; } } } } else if (radioGroup1.EditValue == "Revenue") { using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("doIGRReport", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Revenue"; _command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"]; _command.CommandTimeout = 0; using (System.Data.DataSet ds = new System.Data.DataSet()) { ds.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(ds); connect.Close(); if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00") { XtraRepSummRevenue report = new XtraRepSummRevenue() { DataSource = ds.Tables[1], DataMember = "table" }; //report.paramMonths.Value = dtpStart.Value.Month; //report.paramYear.Value = dtpStart.Value.Year; report.xrLabel32.Text = string.Format(" {0} STATE GOVERNMENT ", Program.StateName.ToUpper()); report.xrLabel33.Text = string.Format("Summary of Collection by Revenue Type for the Month of {0}", oDataRowView.Row["BatchName"]); report.ShowPreviewDialog(); } else { return; } } } } else if (radioGroup1.EditValue == "Details") { using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("doIGRReport", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Details"; _command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"]; _command.CommandTimeout = 0; using (System.Data.DataSet ds = new System.Data.DataSet()) { ds.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(ds); connect.Close(); if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00") { XtraRepAgencyDetails report = new XtraRepAgencyDetails(); report.xrLabel32.Text = string.Format(" {0} STATE GOVERNMENT ", Program.StateName.ToUpper()); report.xrLabel33.Text = string.Format("Summary of Collection by Agencies Details for the Month of {0}", oDataRowView.Row["BatchName"]); //report.paramMonths.Value = dtpStart.Value.Month; //report.paramYears.Value = dtpStart.Value.Year; report.DataSource = ds.Tables[1]; report.DataMember = "ViewReconciliationAgencyDetails"; //report.DataAdapter report.ShowPreviewDialog(); } else { return; } } } } else if (radioGroup1.EditValue == "Account") { using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("doIGRReport", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Account"; _command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"]; _command.CommandTimeout = 0; using (System.Data.DataSet ds = new System.Data.DataSet()) { ds.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(ds); connect.Close(); if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00") { //XtraRepIGRSummary repsumary = new XtraRepIGRSummary(); XtraRepIGRAccounts repacct = new XtraRepIGRAccounts(); //repsumary.xrLabel13.Text = string.Format("{0} State Government", Program.StateName); //repsumary.xrLabel14.Text = string.Format("Summary of {0} State Government IGR Accounts for {1}", Program.StateName, oDataRowView.Row["BatchName"]); repacct.xrLabel27.Text = string.Format(" {0} STATE GOVERNMENT ", Program.StateName.ToUpper()); repacct.xrLabel28.Text = string.Format(" DETAILS OF TRANSFER / CHARGES FOR {0}", oDataRowView.Row["BatchName"]); repacct.DataSource = ds.Tables[1]; repacct.DataMember = "table"; repacct.ShowPreviewDialog(); } else { return; } } } } else if (radioGroup1.EditValue == "Consolidate") { using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("doIGRReport", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Consolidate"; _command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"]; _command.CommandTimeout = 0; using (System.Data.DataSet ds = new System.Data.DataSet()) { ds.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(ds); connect.Close(); if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00") { XtraRepSummary repsummary = new XtraRepSummary(); repsummary.xrLabel32.Text = string.Format("{0} STATE GOVERNMENT ", Program.StateName.ToUpper()); repsummary.xrLabel33.Text = string.Format("CONSOLIDATED SUMMARY ACCOUNT OF IGR FOR THE MONTH OF {0}", oDataRowView.Row["BatchName"]); repsummary.DataSource = ds.Tables[1]; repsummary.DataMember = "ViewConsolidateDetailsTransactions"; //repsummary.paramPeriod.Value = dtpStart.Value.Month; //repsummary.paramYear.Value = dtpStart.Value.Year; repsummary.ShowPreviewDialog(); } else { return; } } } } else if (radioGroup1.EditValue == "Bank Details") { using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("doIGRReport", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Bank Details"; _command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"]; _command.CommandTimeout = 0; using (System.Data.DataSet ds = new System.Data.DataSet()) { ds.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(ds); connect.Close(); if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00") { XtraRepBankDetails bankdetails = new XtraRepBankDetails(); var list = (from DataRow row in ds.Tables[1].Rows select new Dataset.BankDetails { Amount = Convert.ToDecimal(row["Amount"]), PaymentDate = Convert.ToDateTime(row["PaymentDate"]), BankName = row["BankName"] as string, BankCode = row["BankCode"] as string, Description = row["Description"] as string, PayerName = row["PayerName"] as string, RevenueCode = row["RevenueCode"] as string, AccountNumber = row["AccountNumber"] as string, //Branchname = row["Branchname"] as string } ).ToList(); bankdetails.xrLabel17.Text = string.Format("{0} State Government", Program.StateName); bankdetails.xrLabel18.Text = string.Format("Bank Details of {0} State Government IGR Accounts for {1}", Program.StateName, oDataRowView.Row["BatchName"]); //bankdetails.DataSource = ds.Tables[1]; //bankdetails.DataMember = "table"; var binding = (BindingSource)bankdetails.DataSource; binding.Clear(); binding.DataSource = list; bankdetails.ShowPreviewDialog(); } else { return; } } } } else if (radioGroup1.EditValue == "Summary") { using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("doIGRReport", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar)).Value = "Summary"; _command.Parameters.Add(new SqlParameter("@BatchCode", SqlDbType.VarChar)).Value = oDataRowView.Row["BatchCode"]; _command.CommandTimeout = 0; using (System.Data.DataSet ds = new System.Data.DataSet()) { ds.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(ds); connect.Close(); if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00") { XtraRepIGRSummary repsumary = new XtraRepIGRSummary(); repsumary.xrLabel13.Text = string.Format("{0} State Government", Program.StateName); repsumary.xrLabel14.Text = string.Format("Summary of {0} State Government IGR Accounts for {1}", Program.StateName, oDataRowView.Row["BatchName"]); repsumary.DataSource = ds.Tables[1]; repsumary.DataMember = "table"; repsumary.ShowPreviewDialog(); } else { return; } } } } } else { } } catch (Exception ex) { Tripous.Sys.ErrorBox(ex); } finally { SplashScreenManager.CloseForm(false); } } }
private bool Validation() { if (txt_name.Text == "") { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Enter Your_Name"); txt_yourname.Focus(); return(false); } else if (txt_Email_address.Text == "") { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Enter Email_Address"); txt_Email_address.Focus(); return(false); } else if (txt_Incoming_server.Text == "") { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Enter Incoming Server details"); txt_Incoming_server.Focus(); return(false); } else if (txt_Outgoing_server.Text == "") { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Enter Outgoing server details"); txt_Outgoing_server.Focus(); return(false); } else if (txt_User_Name.Text == "") { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Enter User Name"); txt_User_Name.Focus(); return(false); } else if (txt_password.Text == "") { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Enter Password"); txt_password.Focus(); return(false); } //else if (txt_IS.Text == "") //{ // MessageBox.Show("please enter the Incoming Port"); // txt_IS.Focus(); // return false; //} else if (((txt_IS.Text != "" && (Convert.ToInt32(txt_IS.Text.Length) > 4)) || txt_IS.Text == "")) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("incoming port must be less than 4....And please enter Incoming port"); txt_IS.Focus(); return(false); } //else if (txt_OS.Text == "") //{ // MessageBox.Show("Please enter the Outgoing Server Port"); // txt_OS.Focus(); // return false; //} else if (((txt_OS.Text != "" && (Convert.ToInt32(txt_OS.Text.Length) > 4) || txt_OS.Text == ""))) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Outgoing port must be less than 4.....And please enter Outgoing port"); txt_OS.Focus(); return(false); } Regex myRegularExpression = new Regex("^([0-9a-zA-Z]([-\\.\\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\\w]*[0-9a-zA-Z]\\.)+[a-zA-Z]{2,9})$"); if (myRegularExpression.IsMatch(txt_Email_address.Text)) { } else { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Email Address Not Valid"); txt_Email_address.Focus(); return(false); } return(true); }
/// <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; }
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { // MetalMaskGlobal.waitForm.Close(); SplashScreenManager.CloseForm(); }
private void GirisForm_Load(object sender, System.EventArgs e) { SplashScreenManager.ShowForm(typeof(Baslatiliyor)); Yukle(); SplashScreenManager.CloseForm(); }
public uc_Configuration(SplashScreenManager spl) { InitializeComponent(); this.spl = spl; }
protected CommonChildForm() { InitializeComponent(); ssManager = new SplashScreenManager(this, typeof(XtraWaitForm), true, true); }
/// <summary> /// Abre el formulario de edicion de una orden de trabajo específica /// </summary> /// <param name="anOrdenDeTrabajoId"></param> /// <param name="obligaEditarFechas">si es true luego de abrir el formulario limpia los cambios de fecha /// util para cuando se duplica una orden de trabajo</param> public EditOtXtraForm(Guid anOrdenDeTrabajoId, bool obligaEditarFechas = false) { try { SplashScreenManager.ShowForm(MdiParent, typeof(WaitForm1), true, true); } catch (Exception) { SplashScreenManager.CloseForm(); SplashScreenManager.ShowForm(MdiParent, typeof(WaitForm1), true, true); } AIsAnUpdate = true; InitializeComponent(); AgrupacionControl.Properties.Buttons[1].Enabled = true; FechaConfecciontimeEdit.DateTime = DateTime.Today; AOrdenDeTrabajoId = anOrdenDeTrabajoId; GlobalActividad = AGLobalDataContext.OrdenDeTrabajo.FirstOrDefault(c => c.OrdenDeTrabajoID == AOrdenDeTrabajoId); Text += " " + GlobalActividad.ConsecutivoString; ATipoDeActividad = (Enumerados.TipoActividad)Enum.Parse(typeof(Enumerados.TipoActividad), GlobalActividad.TipoActividad.ToString()); if (GlobalActividad != null) { PopulaControles(); if (ATipoDeActividad == Enumerados.TipoActividad.Factura) { EsProyeco_checkEdit.Checked = GlobalActividad.ProyectosId != null; PopulaImporteGridControl(); } } AcomodaSegunTipoActividad(); NumOT_labelControl.Text = GlobalActividad.NumeroDeOrden; NumOT_labelControl.ForeColor = Color.DarkBlue; FechaConfecciontimeEdit.EditValue = GlobalActividad.FechaConfeccion; fechaIncialActividadDateEdit.EditValue = GlobalActividad.FechaIncialActividad; fechaFinalActividadDateEdit.EditValue = GlobalActividad.FechaFinalActividad; if (!GlobalActividad.Agrupacion.PerteneceACatalogo) { CargaTodasAgrupaciones(); } AgrupacionControl.EditValue = GlobalActividad.AgrupacionId; monedaLookUpEdit.EditValue = GlobalActividad.TipoMonedaId; clienteQueContrataIdComboBoxEdit.EditValue = GlobalActividad.ClienteQueContrataId; if (GlobalActividad.ProyectosId != null) { Proyectos_SearchlookUpEdit.EditValue = GlobalActividad.ProyectosId; } Observaciones_memoExEdit.EditValue = GlobalActividad.Observaciones; Cover_checkEdit.Checked = GlobalActividad.EsPorCover; lugarDePresentacionTextEdit.Text = GlobalActividad.LugarDePresentacion; importePorActividadTextEdit.EditValue = GlobalActividad.ImportePorActividad; NumeroContrato_textEdit.Text = GlobalActividad.NumeroContrato; cantidadActividadesSpinEdit.EditValue = GlobalActividad.CantidadActividades; Recordatorio_memoEdit.Text = GlobalActividad.Nota; if (obligaEditarFechas) { fechaIncialActividadDateEdit.Text = ""; fechaFinalActividadDateEdit.Text = ""; } }
/// <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); }
/// <summary> /// 隐藏进度条 /// </summary> /// <param name="manager">进度条</param> /// <param name="showForm">需要显示的窗体</param> /// <param name="hideForm">需要隐藏的窗体</param> /// Author : Napoleon /// Created : 2015-02-26 20:33:22 protected void HideManager(SplashScreenManager manager, Form showForm, Form hideForm) { hideForm.Hide(); manager.CloseWaitForm(); showForm.Show(); }
//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; }
public F配置() { SplashScreenManager.ShowForm(this.FindForm(), typeof(DevExpress.XtraWaitForm.DemoWaitForm), false, true, false); InitializeComponent(); }
private void btnSearch_Click(object sender, EventArgs e) { /* gvGdwu.DataSource = null; * adpter = new MySqlDataAdapter("SELECT a.KHID,a.CMND, a.TenKH, b.NgayGD, b.GioGD, b.TongTien FROM ql.khachhang a, ql.giaodich b where a.KHID = b.khachhang_KHID and b.NgayGD between '" + dtNgaybatdau.Text + "' and '" + dtNgayketthuc.Text + "'", cn.conn); * ds = new DataSet(); * adpter.Fill(ds); * gvGdwu.DataSource = ds.Tables[0]; * string text = ""; * text += "Giao dịch WU từ ngày: " + dtNgaybatdau.Text + " đến ngày: " + dtNgayketthuc.Text; * gridView1.ViewCaption = text;*/ try { nb = 1; gvGdwu.DataSource = null; SplashScreenManager.ShowForm(this, typeof(frmWait2), true, true); a = true; cn.openconnection(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = CommandType.Text; // cmd.CommandText = "SELECT a.KHID,a.CMND, a.TenKH, b.NgayGD, b.GioGD, b.TongTien,b.QuocGiaGui,b.DiemChiTra,IF(b.GiaoDichWU = 1, 'Có', N'Không') AS 'GiaoDichWU',b.MSNT FROM khachhang a, giaodich b where a.KHID = b.khachhang_KHID and b.NgayGD between '" + dtNgaybatdau.Text + "' and '" + dtNgayketthuc.Text + "'"; // cmd.CommandText = "SELECT a.KHID,a.CMND, a.TenKH, b.NgayGD, b.GioGD, b.TongTien,b.QuocGiaGui,b.DiemChiTra,IF(b.GiaoDichWU = 1, 'Có', N'Không') AS 'GiaoDichWU',b.MSNT FROM khachhang a, giaodich b where a.KHID = b.khachhang_KHID and b.NgayGD >= STR_TO_DATE('" + dtNgaybatdau.EditValue + "','%d/%m/%Y %H:%i:%s') and b.NgayGD <= STR_TO_DATE('" + dtNgayketthuc.EditValue + "','%d/%m/%Y %H:%i:%s') ORDER BY b.NgayGD DESC"; cmd.CommandText = "SELECT b.idGiaoDich,a.KHID,a.CMND, a.TenKH, b.NgayGD, b.GioGD,b.NgayGiaoDich, b.TongTien,b.QuocGiaGui,b.DiemChiTra,IF(b.GiaoDichWU = 1, 'Có', N'Không') AS 'GiaoDichWU',b.MSNT FROM khachhang a, giaodich b where b.IsXoa = 1 and a.KHID = b.khachhang_KHID and b.NgayGiaoDich >= STR_TO_DATE('" + dtNgaybatdau.EditValue + "','%d/%m/%Y %H:%i:%s') and b.NgayGiaoDich <= STR_TO_DATE('" + dtNgayketthuc.EditValue + "','%d/%m/%Y %H:%i:%s') ORDER BY b.NgayGiaoDich DESC"; cmd.Connection = cn.conn; DataTable dt = new DataTable(); dt.Columns.Add("idGiaoDich"); dt.Columns.Add("STT"); dt.Columns.Add("KHID"); dt.Columns.Add("CMND"); dt.Columns.Add("TenKH"); dt.Columns.Add("NgayGD"); dt.Columns.Add("GioGD"); dt.Columns.Add("NgayGiaoDich"); dt.Columns.Add("TongTien"); dt.Columns.Add("QuocGiaGui"); dt.Columns.Add("DiemChiTra"); dt.Columns.Add("GiaoDichWU"); dt.Columns.Add("MSNT"); MySqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { DataRow row = dt.NewRow(); row["idGiaoDich"] = rd["idGiaoDich"]; row["STT"] = nb; nb = nb + 1; row["KHID"] = rd["KHID"]; row["CMND"] = rd["CMND"]; row["TenKH"] = rd["TenKH"]; string s = rd["NgayGD"].ToString(); int r = s.Length; s = Left(s, 10); row["NgayGD"] = s; row["GioGD"] = rd["GioGD"]; row["NgayGiaoDich"] = rd["NgayGiaoDich"]; row["TongTien"] = rd["TongTien"]; row["QuocGiaGui"] = rd["QuocGiaGui"]; row["DiemChiTra"] = rd["DiemChiTra"]; row["GiaoDichWU"] = rd["GiaoDichWU"]; row["MSNT"] = rd["MSNT"]; dt.Rows.Add(row); } rd.Close(); gvGdwu.DataSource = dt; // gridView1.Columns[0].Visible = false; text = "Giao dịch từ ngày: " + dtNgaybatdau.EditValue + " đến ngày: " + dtNgayketthuc.EditValue; gridView1.ViewCaption = text; SplashScreenManager.CloseForm(); a = false; //gridColumn10.BestFit(); //gridColumn5.BestFit(); //gridColumn9.BestFit(); textEdit1.Text = ""; /* gridView1.GroupSummary.Clear(); * GridSummaryItem summaryItemMaxOrderSum = gridView1.GroupSummary.Add(DevExpress.Data.SummaryItemType.Sum, "TongTien", null, "(Tổng tiền giao dịch: {0:c0})"); * GridSummaryItem summaryItemMaxOrderSum1 = gridView1.GroupSummary.Add(DevExpress.Data.SummaryItemType.Count, null, null, "Số lần giao dịch: {0}");*/ // t.Abort(); // gridColumn3.BestFit(); } catch (Exception ex) { if (a == true) { SplashScreenManager.CloseForm(); a = false; } XtraMessageBox.Show(ex.Message); } finally { cn.closeconnection(); cn.conn.Dispose(); } }
private void Btn_Guardar_Click(object sender, EventArgs e) { //-- Boton Guardar Documento SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); SplashScreenManager.Default.SetWaitFormDescription("Grabando información..."); Model.Formulacion_Detalle_Personal MFDP = new Model.Formulacion_Detalle_Personal(); Service.Formulacion_Detalle_Personal SFDP = new Service.Formulacion_Detalle_Personal(); workbook = spreadsheetControl.Document; Worksheet worksheet_HojaTrabajo = workbook.Worksheets[0]; int _Rows = 9; int intIdFormulacion_Detalle_Personal = 0; while (true) { if (string.IsNullOrEmpty(Convert.ToString(worksheet_HojaTrabajo.Cells[_Rows, 3].Value.TextValue))) { break; } MFDP.IidFormulacion_Detalle_Personal = Convert.ToInt32(worksheet_HojaTrabajo.Cells[_Rows, 30].Value.NumericValue); MFDP.CañoProceso = strAñoProceso; MFDP.Cversion = strVersion; MFDP.CcodCeCo = Convert.ToString(worksheet_HojaTrabajo.Cells[_Rows, 6].Value.TextValue); MFDP.CcodCeCo_Gestor = strCodCentroCosto; MFDP.CcodPosPre = Convert.ToString(worksheet_HojaTrabajo.Cells[_Rows, 6].Value.TextValue); MFDP.CcodConcepto = FS.TraerDescripcion_DataTable(DS_Concepto.Tables[0], 1, 0, Convert.ToString(worksheet_HojaTrabajo.Cells[_Rows, 9].Value.TextValue) ); if (string.IsNullOrEmpty(Convert.ToString(worksheet_HojaTrabajo.Cells[_Rows, 10].Value.TextValue))) { MFDP.CTipoOrden = ""; MFDP.CNumeroOrden = ""; } else { MFDP.CTipoOrden = Convert.ToString(worksheet_HojaTrabajo.Cells[_Rows, 10].Value.TextValue).Substring(0, 2); MFDP.CNumeroOrden = Convert.ToString(worksheet_HojaTrabajo.Cells[_Rows, 10].Value.TextValue).Substring(3, 10); } MFDP.CcodFuenteFinanciamiento = "001"; MFDP.CcodTipoFormulacion = strCodTipoFormulacion; //MFDP.CcodProyecto = strCodProyecto; MFDP.CcodProyecto = "CORPORATIVOS "; MFDP.CcodClaseGasto = "02"; MFDP.TdescripcionGasto = Convert.ToString(worksheet_HojaTrabajo.Cells[_Rows, 11].Value.TextValue); MFDP.FvalorAnterior = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 12].Value.NumericValue); MFDP.FvalorRestoActual = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 13].Value.NumericValue); MFDP.FvalorFormulacion = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 26].Value.NumericValue); MFDP.FvalorFormulacionUno = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 27].Value.NumericValue); MFDP.FvalorFormulacionDos = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 28].Value.NumericValue); if (Convert.ToString(worksheet_HojaTrabajo.Cells[_Rows, 1].Value.TextValue) == "Año Anterior") { MFDP.IcodTipoInserccion = 2; // 2 Automatico } else { MFDP.IcodTipoInserccion = 1; //- 1 Manual } MFDP.Cusuario = MyStuff.CodigoEmpleado; MFDP.Fmes_01 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 14].Value.NumericValue); MFDP.Fmes_02 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 15].Value.NumericValue); MFDP.Fmes_03 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 16].Value.NumericValue); MFDP.Fmes_04 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 17].Value.NumericValue); MFDP.Fmes_05 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 18].Value.NumericValue); MFDP.Fmes_06 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 19].Value.NumericValue); MFDP.Fmes_07 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 20].Value.NumericValue); MFDP.Fmes_08 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 21].Value.NumericValue); MFDP.Fmes_09 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 22].Value.NumericValue); MFDP.Fmes_10 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 23].Value.NumericValue); MFDP.Fmes_11 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 24].Value.NumericValue); MFDP.Fmes_12 = Convert.ToDouble(worksheet_HojaTrabajo.Cells[_Rows, 25].Value.NumericValue); if (ValidaLineaGrabacion(MFDP, _Rows) == false) { if (MFDP.IidFormulacion_Detalle_Personal == 0) { if (MyStuff.UsaWCF == true) { intIdFormulacion_Detalle_Personal = objWCF.Graba_FormulacionDetalle_Personal(MFDP); } else { intIdFormulacion_Detalle_Personal = SFDP.Graba_FormulacionDetalle_Personal(MFDP); } string Rango = traeRangoCelda(1, _Rows + 1, 1, _Rows + 1); workbook = spreadsheetControl.Document; Range range = worksheet_HojaTrabajo.Range[Rango]; Formatting rangeFormatting = range.BeginUpdateFormatting(); rangeFormatting.Fill.BackgroundColor = Color.Green; range.EndUpdateFormatting(rangeFormatting); worksheet_HojaTrabajo.Cells[_Rows, 30].Value = intIdFormulacion_Detalle_Personal; } else { if (MyStuff.UsaWCF == true) { intIdFormulacion_Detalle_Personal = objWCF.Modifica_FormulacionDetalle_Personal(MFDP); } else { intIdFormulacion_Detalle_Personal = SFDP.Modifica_FormulacionDetalle_Personal(MFDP); } } } _Rows++; } SplashScreenManager.CloseForm(); }
public DataBaseErrorForm() { SplashScreenManager.CloseForm(false); InitializeComponent(); }
protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { if (keyData == Keys.Delete) { if (select == "qt") { if (XtraMessageBox.Show("Xoá quá trình đang chọn?", "Xoá", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { gridView1.DeleteSelectedRows(); unitQUATRINH.CommitChanges(); } return(true); } if (select == "qh") { if (XtraMessageBox.Show("Xoá quan hệ đang chọn?", "Xoá", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { gridView2.DeleteSelectedRows(); unitQUANHE.CommitChanges(); } return(true); } if (select == "ta") { if (XtraMessageBox.Show("Xoá tiền án đang chọn?", "Xoá", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { gridView21.DeleteSelectedRows(); unitTIENAN.CommitChanges(); } return(true); } if (select == "db") { if (XtraMessageBox.Show("Xoá diễn biến đang chọn?", "Xoá", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { gridView4.DeleteSelectedRows(); unitDIENBIEN.CommitChanges(); } return(true); } if (select == "tv") { if (XtraMessageBox.Show("Xoá tạm trú-tạm vắng đang chọn?", "Xoá", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { gridView6.DeleteSelectedRows(); unitTAMVANG.CommitChanges(); } return(true); } if (keyData == (Keys.Control | Keys.S)) { SplashScreenManager.ShowDefaultWaitForm("Đang tải", "Vui lòng chờ..."); try { unitNHANKHAU.CommitChanges(); unitQUATRINH.CommitChanges(); unitQUANHE.CommitChanges(); unitTIENAN.CommitChanges(); unitDIENBIEN.CommitChanges(); unitTAMVANG.CommitChanges(); alertControl1.Show(this, "Thông báo", "Đã lưu"); } catch (Exception) { } SplashScreenManager.CloseDefaultWaitForm(); } return(true); } return(base.ProcessCmdKey(ref msg, keyData)); }
private void btnSearchCEP_Click(object sender, EventArgs e) { if (!validatorSearchCEP.Validate()) { return; } tfCep.SelectAll(); try { if (Util.isConnectedWeb() && (tfCep.EditValue != null && !String.IsNullOrEmpty(tfCep.EditValue.ToString()))) { SplashScreenManager.ShowForm(desk, typeof(PleaseWaitForm), false, false, false); WebCEP wcep = new WebCEP(tfCep.EditValue.ToString(), WebCEP.TypeCase.Upper); ((address)bdgAddress.Current).state_id = 0; cbStateAddress.EditValue = 0; ((address)bdgAddress.Current).city_id = 0; cbCity.EditValue = 0; ((address)bdgAddress.Current).district = ""; tfDistrict.EditValue = ""; ((address)bdgAddress.Current).name = ""; tfAddress.EditValue = ""; if (wcep.RESULTADO == 0) { ((address)bdgAddress.Current).cep = ""; tfCep.EditValue = ""; SplashScreenManager.CloseForm(false); XtraMessageBox.Show("O CEP informado não foi encontrado!\nVerifique e tente novamente ou informe o endereço manualmente.", "CADORE TECNOLOGIA"); return; } else { state s = state.SingleOrDefault("WHERE symbol ILIKE @0", state.Concat(wcep.UF)); if (s != null) { ((address)bdgAddress.Current).state_id = s.id; cbStateAddress.EditValue = s.id; } Console.WriteLine(wcep.CIDADE); city c = city.SingleOrDefault("WHERE remove_character(name) ILIKE remove_character(@0)", city.Concat(wcep.CIDADE)); if (c != null) { ((address)bdgAddress.Current).city_id = c.id; cbCity.EditValue = c.id; } if (wcep.RESULTADO == 1) { ((address)bdgAddress.Current).district = wcep.BAIRRO; tfDistrict.EditValue = wcep.BAIRRO; string street = String.Format("{0} {1}", wcep.TIPOLAGRADOURO, wcep.LAGRADOURO); ((address)bdgAddress.Current).name = street; tfAddress.EditValue = street; } } } } catch (Exception ex) { XtraMessageBox.Show(String.Format("Ocorreu um erro\n\n{0}\n{1}", ex.Message, ex.InnerException)); } finally { SplashScreenManager.CloseForm(false); } }
private void btnLuu_ItemClick(object sender, ItemClickEventArgs e) { // Kiểm tra thông tin nhập vào if (string.IsNullOrEmpty(txtEmail.Text.ToString().Trim())) { MessageBox.Show("Email nhân viên không được để trống", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); txtEmail.Focus(); return; } else if (string.IsNullOrEmpty(txtMatKhau.Text.ToString().Trim())) { MessageBox.Show("Mật khẩu khách hàng không được để trống", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); txtMatKhau.Focus(); return; } else if (Commons.KiemTraEmailHopLe(txtEmail.Text.ToString().Trim()) != true) { MessageBox.Show("Email không được định dạng đúng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); txtEmail.Focus(); return; } else { SplashScreenManager.ShowForm(this, typeof(WaitLoadFrm)); string taikhoan = cboTaiKhoan.EditValue.ToString().Trim(); string matkhau = txtMatKhau.EditValue.ToString().Trim(); string email = txtEmail.EditValue.ToString().Trim(); TaiKhoanNV nv = new TaiKhoanNV(); nv.TaiKhoan = taikhoan; nv.MatKhau = matkhau; nv.Email = email; nv.TinhTrang = 0; if (nhanVien.ThemTKNhanVien(nv)) { try { NhanVien nvv = new NhanVien(); nvv = nhanVien.LayTTNhanVien(taikhoan); GMail gMail = new GMail(); gMail.GuiEmailTaiKhoan(email, nvv.HoTenNV, taikhoan, matkhau); SplashScreenManager.CloseDefaultSplashScreen(); MessageBox.Show("Tạo tài khoản cho mã khách hàng " + cboTaiKhoan.EditValue.ToString() + " thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); FrmTaiKhoanNV_Load(null, null); } catch (Exception ex) { MessageBox.Show("Tạo tài khoản cho mã khách hàng " + cboTaiKhoan.EditValue.ToString() + " thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); MessageBox.Show("Không gửi được gmail cho khách hàng " + cboTaiKhoan.EditValue.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); FrmTaiKhoanNV_Load(null, null); throw; } } else { MessageBox.Show("Lỗi tạo tài khoản cho khách hàng " + cboTaiKhoan.EditValue.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); SplashScreenManager.CloseDefaultSplashScreen(); FrmTaiKhoanNV_Load(null, null); } } }
public virtual void RefreshLogs(SplashScreenManager splash) { splash.ShowWaitForm(); trackRecordLogs = GetTrackRecordLogs(); splash.CloseWaitForm(); }
private async void btn_save_Click(object sender, EventArgs e) { try { if (Validation() != false) { if (emailId == 0 && btn_save.Text == "Save" && (await Usercheck()) != false) { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); txt_IS.Enabled = true; txt_OS.Enabled = true; var dictionary = new Dictionary <string, object>(); { dictionary.Add("@Trans", "INSERT"); dictionary.Add("@Your_Name", txt_name.Text); dictionary.Add("@Email_Address", txt_Email_address.Text); dictionary.Add("@Incoming_Mail_Server", txt_Incoming_server.Text); dictionary.Add("@Outgoing_Mail_Server", txt_Outgoing_server.Text); dictionary.Add("@Incoming_Server_Port", txt_IS.Text); dictionary.Add("@Outgoing_Server_Port", txt_OS.Text); dictionary.Add("@User_Name", txt_User_Name.Text); dictionary.Add("@Password", txt_password.Text); dictionary.Add("@Connection_SSL", check_connection_SSL.Checked); }; var data = new StringContent(JsonConvert.SerializeObject(dictionary), Encoding.UTF8, "application/json"); using (var httpClient = new HttpClient()) { var response = await httpClient.PostAsync(Base_Url.Url + "/EmailSettings/Insert", data); if (response.IsSuccessStatusCode) { if (response.StatusCode == HttpStatusCode.OK) { var result = await response.Content.ReadAsStringAsync(); SplashScreenManager.CloseForm(false); XtraMessageBox.Show(txt_User_Name.Text + " Created Successfully "); grid_Email_Address_list(); Clear(); } } } } if (btn_save.Text == "Edit") { var dictionary1 = new Dictionary <string, object>(); { dictionary1.Add("@Trans", "UPDATE"); dictionary1.Add("@ID", emailId); dictionary1.Add("@Your_Name", txt_name.Text); dictionary1.Add("@Email_Address", txt_Email_address.Text); dictionary1.Add("@Incoming_Mail_Server", txt_Incoming_server.Text); dictionary1.Add("@Outgoing_Mail_Server", txt_Outgoing_server.Text); dictionary1.Add("@Connection_SSL", check_connection_SSL.Checked); dictionary1.Add("@Incoming_Server_Port", txt_IS.Text); dictionary1.Add("@Outgoing_Server_Port", txt_OS.Text); dictionary1.Add("@User_Name", txt_User_Name.Text); dictionary1.Add("@Password", txt_password.Text); }; var data = new StringContent(JsonConvert.SerializeObject(dictionary1), Encoding.UTF8, "application/json"); using (var httpClient = new HttpClient()) { var response = await httpClient.PutAsync(Base_Url.Url + "/EmailSettings/Update", data); if (response.IsSuccessStatusCode) { if (response.StatusCode == HttpStatusCode.OK) { var result = await response.Content.ReadAsStringAsync(); SplashScreenManager.CloseForm(false); XtraMessageBox.Show(txt_User_Name.Text + " Updated Successfully "); grid_Email_Address_list(); Clear(); } } } } } } catch (Exception ex) { SplashScreenManager.CloseForm(false); MessageBox.Show(ex.Message.ToString()); } finally { SplashScreenManager.CloseForm(false); } }
private void btnAdd_Click(object sender, EventArgs e) { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); try { if (Convert.ToInt32(lookUpEditType.EditValue) == 0) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Select Type"); lookUpEditType.Focus(); return; } if (string.IsNullOrEmpty(textEditOption.Text.Trim())) { SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Enter option"); textEditOption.Focus(); return; } if (Convert.ToInt32(lookUpEditType.EditValue) == 1) { if (btnAdd.Text == "Add") { var htInsert = new Hashtable(); htInsert.Add("@Trans", "INSERT_BREAK_TYPE"); htInsert.Add("@Break_Mode", textEditOption.Text); htInsert.Add("@Status", true); htInsert.Add("@User_Id", User_ID); var id = da.ExecuteSPForScalar("Sp_Break_Mode", htInsert); SplashScreenManager.CloseForm(false); if (Convert.ToInt32(id) > 0) { MessageBox.Show("Break Mode Added Successfully"); BindBreakTypes(); } } if (btnAdd.Text == "Update") { var htInsert = new Hashtable(); htInsert.Add("@Trans", "UPDATE_BREAK_TYPE"); htInsert.Add("@Break_Mode", textEditOption.Text); htInsert.Add("@Status", true); htInsert.Add("@User_Id", User_ID); htInsert.Add("@Break_Mode_Id", ID); var id = da.ExecuteSPForScalar("Sp_Break_Mode", htInsert); SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Break Mode Updated Successfully"); BindBreakTypes(); } } if (Convert.ToInt32(lookUpEditType.EditValue) == 2) { if (btnAdd.Text == "Add") { var htInsert = new Hashtable(); htInsert.Add("@Trans", "INSERT_IDLE_TYPE"); htInsert.Add("@Idle_Type", textEditOption.Text); htInsert.Add("@User_Id", User_ID); htInsert.Add("@Status", true); var id = da.ExecuteSPForScalar("SP_User_Idle_Timings", htInsert); SplashScreenManager.CloseForm(false); if (Convert.ToInt32(id) > 0) { XtraMessageBox.Show("Idle Mode Added Successfully"); BindIdleTypes(); } } if (btnAdd.Text == "Update") { var htInsert = new Hashtable(); htInsert.Add("@Trans", "UPDATE_IDLE_TYPE"); htInsert.Add("@Idle_Type", textEditOption.Text); htInsert.Add("@User_Id", User_ID); htInsert.Add("@Idle_Mode_Id", ID); var id = da.ExecuteSPForScalar("SP_User_Idle_Timings", htInsert); SplashScreenManager.CloseForm(false); XtraMessageBox.Show("Idle Mode Updated Successfully"); BindIdleTypes(); } } textEditOption.Text = ""; btnAdd.Text = "Add"; } catch (Exception ex) { SplashScreenManager.CloseForm(false); MessageBox.Show("Error Occured Please Check With Administrator"); } finally { SplashScreenManager.CloseForm(false); } }
private void splashscreenBarButtonItem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { SplashScreenManager.ShowForm(typeof(SplashScreen1)); //SplashScreenManager.CloseForm( ); }
private void xbbiImport_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { SplashScreenManager.ShowDefaultWaitForm(); var listCPCOfficialFile = xgvOfficialFile.GetSelectedRows() .Select(h => xgvOfficialFile.GetRow(h) as CPCOfficialFile) .Where(f => f != null) .ToList(); listCPCOfficialFile.ForEach(f => { var dtNow = DateTime.Now; f.Note = string.Empty; Application.DoEvents(); try { if (f.SendDate == DateTime.MinValue) { f.Note += "官方发文日为空,该官文无法导入"; return; } if (string.IsNullOrWhiteSpace(f.CPCOfficialFileConfig.Dealer)) { f.Note += "请填写处理人"; return; } if (!string.IsNullOrWhiteSpace(f.AppNo) && !f.AppNo.Contains('.')) { f.AppNo = f.AppNo.Insert(f.AppNo.Length - 1, "."); } var dtCase = ExistCase(f.AppNo, f.CPCSerial); if (dtCase.Rows.Count < 1) { f.Note += "未找到案件"; return; } if (dtCase.Rows.Count > 1) { f.Note += "找到多个案件"; return; } f.CaseSerial = dtCase.Rows[0]["OURNO"].ToString(); f.ClientNo = dtCase.Rows[0]["CLIENT"].ToString(); f.ClientName = dtCase.Rows[0]["CLIENT_NAME"].ToString(); f.WithDrew = dtCase.Rows[0]["WITHDREW"].ToString(); if (!string.IsNullOrWhiteSpace(dtCase.Rows[0]["DIV_FILINGDATE"].ToString())) { f.DivFilingDate = Convert.ToDateTime(dtCase.Rows[0]["DIV_FILINGDATE"]); } f.Applicants = new Hashtable(); for (int i = 1; i <= 5; i++) { if (string.IsNullOrWhiteSpace(dtCase.Rows[0][$"APPL_CODE{i}"].ToString())) { continue; } f.Applicants.Add(dtCase.Rows[0][$"APPL_CODE{i}"].ToString(), !string.IsNullOrWhiteSpace(dtCase.Rows[0][$"APPLICANT{i}"].ToString()) ? dtCase.Rows[0][$"APPLICANT{i}"].ToString() : dtCase.Rows[0][$"APPLICANT_CH{i}"].ToString()); } if (ExistFile(f.CaseSerial, f.AppNo, f.FileName, f.SendDate)) { f.Note += "通知书已在系统中存在"; return; } var filePatent = _objectSpace.FindObject <FilePatent>(CriteriaOperator.Parse("s_OurNo = ?", f.CaseSerial)) ?? _objectSpace.CreateObject <FilePatent>(); filePatent.s_OurNo = f.CaseSerial; var fileInOfficial = _objectSpace.FindObject <FileInOfficial>(CriteriaOperator.Parse("s_OfficialNo = ?", f.SendSerial)) ?? _objectSpace.CreateObject <FileInOfficial>(); fileInOfficial.s_OfficialNo = f.SendSerial; if (fileInOfficial.FilePatent == null) { fileInOfficial.FilePatent = filePatent; } var strSql = new List <string>(); if (!string.IsNullOrWhiteSpace(f.AppNo)) { if (!string.IsNullOrWhiteSpace(dtCase.Rows[0]["APPLICATION_NO"].ToString()) && dtCase.Rows[0]["APPLICATION_NO"].ToString() != f.AppNo) { var dialogResult = XtraMessageBox.Show( $"通知书申请号与PatentCase系统中的申请号不一致,请确认是否进行更新,\r\n系统内申请号:{dtCase.Rows[0]["APPLICATION_NO"].ToString()}\r\n通知书申请号:{f.AppNo}", "冲突提醒", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (dialogResult == DialogResult.Cancel) { f.Note += "存在冲突,已跳过"; return; } if (dialogResult == DialogResult.Yes) { strSql.Add($"update PATENTCASE set APPLICATION_NO = '{f.AppNo}' where OURNO = '{f.CaseSerial}'"); } } else { strSql.Add($"update PATENTCASE set APPLICATION_NO = '{f.AppNo}' where OURNO = '{f.CaseSerial}'"); } } if (f.FileCode == "210307" || f.FileCode == "210308") { strSql.Add($"update PATENTCASE set SE_INITIATED = 'Y', SE_DATE = to_date('{f.SendDate:yyyy/MM/dd HH:mm:ss}','yyyy/MM/dd hh24:mi:ss') where OURNO = '{f.CaseSerial}'"); } strSql.Add($"insert into RECEIVINGLOG (PID,ISSUEDATE,RECEIVED,SENDERID,SENDER,OURNO,APPNO,CLIENTNO,CONTENT,COPIES,COMMENTS,STATUS,HANDLER) values ('{DateTime.Now:yyyyMMdd_HHmmss_ffffff_0}',to_date('{f.SendDate.Date:yyyy/MM/dd}','yyyy/MM/dd'),to_date('{DateTime.Now.Date:yyyy/MM/dd}','yyyy/MM/dd'),'SIPO','SIPO','{dtCase.Rows[0][0]}','{dtCase.Rows[0][1]}','{dtCase.Rows[0][2]}','other','1','{f.FileName}','P','{f.CPCOfficialFileConfig?.Dealer}')"); fileInOfficial.dt_OfficialSendDate = f.SendDate; fileInOfficial.dt_ReceiveDate = DateTime.Now; fileInOfficial.s_FileCode = f.FileCode; fileInOfficial.s_FileName = f.FileName; fileInOfficial.Handler = _objectSpace.FindObject <SysUser>(CriteriaOperator.Parse("Code = ?", f.CPCOfficialFileConfig?.Dealer)); if (f.CPCOfficialFileConfig?.DeadlineFiledType != null) { switch (f.CPCOfficialFileConfig.DeadlineFiledType.Value) { case DeadlineFiledType.Case: if (f.CPCOfficialFileConfig.DeadlineFiled == "GRANTNOTIC_DATE") { strSql.Add($"update PATENTCASE set GRANTNOTIC_DATE=to_date('{f.SendDate.Date:yyyy/MM/dd}','yyyy/MM/dd'),REGFEE_DL=to_date('{f.SendDate.Date.AddDays(15).AddMonths(2):yyyy/MM/dd}','yyyy/MM/dd') where OURNO = '{f.CaseSerial}'"); //更新办登信息 } else if (f.CPCOfficialFileConfig.DeadlineFiled == "PRE_EXAM_PASSED") { strSql.Add($"update PATENTCASE set PRE_EXAM_PASSED=to_date('{f.SendDate.Date:yyyy/MM/dd}','yyyy/MM/dd') where OURNO = '{f.CaseSerial}'"); //更新初审合格日 } break; case DeadlineFiledType.OA: strSql.Add( $"insert into GENERALALERT (CREATED,TYPEID,OURNO,TRIGERDATE1,DUEDATE,OATYPE,COMMENTS) values (to_date('{DateTime.Now:yyyy/MM/dd HH:mm:ss}','yyyy/MM/dd hh24:mi:ss'),'invoa','{f.CaseSerial}',to_date('{f.SendDate.Date:yyyy/MM/dd}','yyyy/MM/dd'),to_date('{f.SendDate.Date.AddDays(f.CPCOfficialFileConfig.AddDays).AddMonths(f.CPCOfficialFileConfig.AddMonths):yyyy/MM/dd}','yyyy/MM/dd'),'{f.CPCOfficialFileConfig.DeadlineFiled}','{f.CPCOfficialFileConfig.DeadlineFiledNote}')"); break; case DeadlineFiledType.Deadline: if (f.FileCode == "200702" && !IsValidCase(f.AppNo)) //如果是专利权终止通知书且案件已届满 { break; } strSql.Add( $"insert into GENERALALERT (CREATED,TYPEID,OURNO,DUEDATE,COMMENTS) values (to_date('{DateTime.Now:yyyy/MM/dd HH:mm:ss}','yyyy/MM/dd hh24:mi:ss'),'{f.CPCOfficialFileConfig.DeadlineFiled}','{f.CaseSerial}',to_date('{f.SendDate.Date.AddDays(f.CPCOfficialFileConfig.AddDays).AddMonths(f.CPCOfficialFileConfig.AddMonths):yyyy/MM/dd}','yyyy/MM/dd'),'{f.CPCOfficialFileConfig.DeadlineFiledNote}')"); break; case DeadlineFiledType.FCaseDeadline: break; } } SendEmail(f); var array = new ArrayList(); array.AddRange(strSql); DbHelperOra.ExecuteSqlTran(array); if (File.Exists(f.BizFilePath)) { fileInOfficial.InFileData = _objectSpace.CreateObject <FileData>(); fileInOfficial.InFileData.LoadFromStream(Path.GetFileName(f.BizFilePath), File.OpenRead(f.BizFilePath)); } fileInOfficial.Save(); filePatent.GetCaseInfo(); filePatent.Save(); _objectSpace.CommitChanges(); f.Note = "已导入"; } catch (Exception exception) { f.Note += exception.ToString(); _objectSpace.Rollback(); } while (dtNow.AddSeconds(1) > DateTime.Now) { } }); xgvOfficialFile.RefreshData(); SplashScreenManager.CloseDefaultWaitForm(); }
// 查询 private void SearchLocal(int pageNum) { try { SplashScreenManager.ShowForm(typeof(DevWaitForm)); //获取总数目 int dataCount = queryCount(); //是否显示全部 if (this.spanNumber.Enabled) { var dtQuery = queryByPage(pageNum); dtQuery.Columns.Add("check", System.Type.GetType("System.Boolean")); dtQuery.Columns["check"].ReadOnly = false; for (int i = 0; i < dtQuery.Rows.Count; i++) { dtQuery.Rows[i]["check"] = false; } this.gcDataInfo.DataSource = dtQuery; this.gvDataInfo.BestFitColumns(); int pageSize = Convert.ToInt32(this.spanNumber.Text); int pageCount = dataCount / pageSize; if (dataCount % pageSize > 0) { pageCount++; } int dataLast; if (pageNum == pageCount) { dataLast = dataCount; } else { dataLast = pageSize * pageNum; } this.lblSum.Text = String.Format("共{0}条", dataCount); this.labPage.Text = String.Format("当前显示{0}至{1}条", (pageSize * (pageNum - 1) + 1), dataLast); this.txtPage.Text = String.Format("{0}/{1}", pageNum, pageCount); } else { var dtQuery = queryAll(); dtQuery.Columns.Add("check", System.Type.GetType("System.Boolean")); dtQuery.Columns["check"].ReadOnly = false; for (int i = 0; i < dtQuery.Rows.Count; i++) { dtQuery.Rows[i]["check"] = false; } this.gcDataInfo.DataSource = dtQuery; this.gvDataInfo.BestFitColumns(); this.lblSum.Text = String.Format("共{0}条", dataCount); this.labPage.Text = String.Format("当前显示{0}至{1}条", 1, dataCount); this.txtPage.Text = String.Format("{0}/{1}", 1, 1); } if (dataCount == 0) { this.labPage.Text = "当前显示0至0条"; this.txtPage.Text = "0/0"; } } catch (Exception ex) { XtraMessageBox.Show("操作出现错误:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { SplashScreenManager.CloseForm(); } }
public void LoadCPCFiles() { SplashScreenManager.ShowDefaultWaitForm(); var listFiles = GetFiles().Rows.Cast <DataRow>().Select(r => new CPCOfficialFile(r)).ToList(); listFiles.ForEach(f => { try { if (f.SendDate == DateTime.MinValue) { f.Note += "官方发文日为空,该官文无法导入"; return; } if (!string.IsNullOrWhiteSpace(f.AppNo) && !f.AppNo.Contains('.')) { f.AppNo = f.AppNo.Insert(f.AppNo.Length - 1, "."); } var dtCase = ExistCase(f.AppNo, f.CPCSerial); if (dtCase.Rows.Count < 1) { f.Note += "未找到案件"; return; } if (dtCase.Rows.Count > 1) { f.Note += "找到多个案件"; return; } if (string.IsNullOrWhiteSpace(f.AppNo)) { f.AppNo = dtCase.Rows[0][1].ToString(); } if (dtCase.Rows[0][3]?.ToString().Trim().ToUpper() == "T") { f.CPCOfficialFileConfig.Dealer = "GS"; } f.CaseSerial = dtCase.Rows[0]["OURNO"].ToString(); f.ClientNo = dtCase.Rows[0]["CLIENT"].ToString(); f.ClientName = dtCase.Rows[0]["CLIENT_NAME"].ToString(); f.WithDrew = dtCase.Rows[0]["WITHDREW"].ToString(); if (!string.IsNullOrWhiteSpace(dtCase.Rows[0]["DIV_FILINGDATE"].ToString())) { f.DivFilingDate = Convert.ToDateTime(dtCase.Rows[0]["DIV_FILINGDATE"]); } if (f.FileCode == "210304" || f.FileCode == "250304") { var listCode = new List <string> { "3667", "3443" }; if (listCode.Contains(dtCase.Rows[0]["APPL_CODE1"].ToString()) || listCode.Contains(dtCase.Rows[0]["APPL_CODE2"].ToString()) || listCode.Contains(dtCase.Rows[0]["APPL_CODE3"].ToString()) || listCode.Contains(dtCase.Rows[0]["APPL_CODE4"].ToString()) || listCode.Contains(dtCase.Rows[0]["APPL_CODE5"].ToString()) || listCode.Contains(dtCase.Rows[0]["CLIENT"].ToString())) { f.CPCOfficialFileConfig.Dealer = "GK"; } } f.CPCOfficialFileConfig.Dealer = HandlerRedistribution(f.CaseSerial, f.CPCOfficialFileConfig.Dealer, f.CPCOfficialFileConfig?.DeadlineFiledType != null); GeneratePDFFile(f); } catch (Exception exception) { f.Note += exception.ToString(); } }); xgcOfficialFile.DataSource = listFiles; xgcOfficialFile.Refresh(); SplashScreenManager.CloseDefaultWaitForm(); }
public ucChauffeur(SplashScreenManager spl) { InitializeComponent(); this.spl = spl; }
public void Execute(object parameter) { HourGlass.Enable = true; TableView view = parameter as TableView; if (view == null) { return; } MainViewModel mainViewModel = view.DataContext as MainViewModel; PrintHelper.Instance.Header = mainViewModel != null ? string.Format("Код справочника НСИ: {0}\r\nНаименование справочника НСИ: {1}\r\nКод группы справочников НСИ: {2}\r\nГруппа: {3}", mainViewModel.SelectedNsi.ReferenceId ?? string.Empty, mainViewModel.SelectedNsi.ReferenceName ?? string.Empty, mainViewModel.SelectedNsi.ReferenceGroupId ?? string.Empty, mainViewModel.SelectedNsi.UserGroupId ?? string.Empty) : "Справочник"; SaveFileDialog saveFileDialog = new SaveFileDialog { DefaultExt = ".xlsx", InitialDirectory = @"C:\", Filter = "excel file (*.xlsx)|*.xlsx" }; if (saveFileDialog.ShowDialog() == true) { SplashScreenManager.ShowForm(typeof(frmWaitForm), true, true); SplashScreenManager.Default.SetWaitFormCaption("Экспортирую..."); var pathToSave = saveFileDialog.FileName; var excelApp = new Excel.Application(); Excel.Workbook excelBook = excelApp.Workbooks.Add(true); Excel.Worksheet worksheet = (Excel.Worksheet)excelBook.ActiveSheet; Excel.Range cells = excelBook.Worksheets[1].Cells; cells.NumberFormat = "@"; try { SplashScreenManager.Default.SetWaitFormDescription("Экспорт Бизнес записей"); worksheet.Cells[1, 1] = "Код справочника НСИ"; worksheet.Cells[1, 2] = mainViewModel.SelectedNsi.ReferenceId ?? string.Empty; worksheet.Cells[2, 1] = "Наименование справочника НСИ"; worksheet.Cells[2, 2] = mainViewModel.SelectedNsi.ReferenceName ?? string.Empty; worksheet.Cells[3, 1] = "Код группы справочников НСИ"; worksheet.Cells[3, 2] = mainViewModel.SelectedNsi.ReferenceGroupId ?? string.Empty; worksheet.Cells[4, 1] = "Группа"; worksheet.Cells[4, 2] = mainViewModel.SelectedNsi.UserGroupId ?? string.Empty; worksheet.Cells[6, 1] = "RecordId"; worksheet.Cells[6, 2] = "RecordName"; worksheet.Cells[7, 1] = "Бизнес-ИД записи"; worksheet.Cells[7, 2] = "Описание записи справочника"; worksheet.Cells[8, 1] = "String"; worksheet.Cells[8, 2] = "String"; int columnIndex = 1; int RowIndex = 9; foreach (var record in mainViewModel.Records) { if (!mainViewModel.isExcel) { worksheet.Cells[RowIndex, columnIndex] = record.ValueDictionary.Values.ElementAtOrDefault(1); worksheet.Cells[RowIndex, columnIndex + 1] = record.ValueDictionary.Values.ElementAtOrDefault(2); } else { worksheet.Cells[RowIndex, columnIndex] = record.ValueDictionary.Values.ElementAtOrDefault(0); worksheet.Cells[RowIndex, columnIndex + 1] = record.ValueDictionary.Values.ElementAtOrDefault(1); } RowIndex++; } SplashScreenManager.Default.SetWaitFormDescription("Экспорт таблицы"); columnIndex = 3; foreach (var MVM in mainViewModel.ReferenceAttributeCollection) { worksheet.Cells[6, columnIndex] = MVM.ReferenceAttributeId; worksheet.Cells[7, columnIndex] = MVM.ReferenceAttributeName; worksheet.Cells[8, columnIndex] = Convertation(MVM.ReferenceAttributeType, MVM.RefReferenceId); RowIndex = 9; foreach (var record in mainViewModel.Records) { foreach (var pair in record.ValueDictionary) { if (pair.Key == MVM.ReferenceAttributeName) { worksheet.Cells[RowIndex, columnIndex] = pair.Value; RowIndex++; break; } } } columnIndex++; } worksheet.Columns.AutoFit(); excelBook.SaveAs(pathToSave); } catch (Exception e) { MessageBox.Show("Что-то пошло не так :( " + e); } finally { HourGlass.Enable = false; SplashScreenManager.CloseForm(); excelBook.Close(0); excelApp.Quit(); } } }
private TWaitting() { ssm = new SplashScreenManager(null, typeof(frmWaitting), true, true); ssm.Properties.ClosingDelay = 500; }
private void btnupload_Click(object sender, EventArgs e) { _objMain.lblStatus.Caption = "Status: Uploading Route"; bool chk = checkSerialKeyForInstrument(PublicClass.currentInstrument); if (PublicClass.currentInstrument == "Impaq-Benstone") { chk = true; } if (chk) { //objupdown = new frmupdownload(); upload = new frmUpload(); string text1 = null; string CurrentInstName = PublicClass.currentInstrument; try { if (PublicClass.routename != null) { upload.SelectedRouteName = PublicClass.routename; upload.ShowDialog(); IsInstrument = upload.IsInstrumentSelected; if (CurrentInstName == "Kohtect-C911") { try { if (IsInstrument == false) { PathToUpLoad = upload.PCPath; PublicClass.Path = PathToUpLoad; } else { PathToUpLoad = upload.textBox1.Text; PublicClass.Path = PathToUpLoad; } if (upload.IsCancelClicked == false) { SplashScreenManager.ShowForm(typeof(WaitForm3)); bool testbool = false; string[] splitpath = PublicClass.Path.Split(new string[] { "\\" }, StringSplitOptions.RemoveEmptyEntries); DirectoryInfo obj = new DirectoryInfo(splitpath[0]); DirectoryInfo[] folders = obj.GetDirectories(); if (folders.Length > 0) { for (int a = 0; a < folders.Length; a++) { if (PublicClass.routename == folders[a].ToString()) { DialogResult Drslt = MessageBox.Show("Route Name Already Exist." + "\n" + "Do you want to Overrite?", "Route Transfer", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (Drslt == DialogResult.Yes) { testbool = true; DirectoryInfo dir = new DirectoryInfo(PublicClass.Path); foreach (FileInfo files in dir.GetFiles()) { files.Delete(); } foreach (DirectoryInfo dirs in dir.GetDirectories()) { dirs.Delete(true); } Directory.Delete(PublicClass.Path); } } else { testbool = true; } } } else { testbool = true; } if (testbool == true) { clsdb.Main = _objMain; clsdb.C911uploaddata(PublicClass.routename, PublicClass.Path); if (clsdb.check == "true") { _objMain.lblStatus.Caption = "Status: Uploading Route Successfully In Instrument"; MessageBox.Show("Route Create Sucessfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); _objMain.ribbonControl1.Enabled = true; this.Enabled = true; this.Close(); } else { MessageBox.Show("No point In Route", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); _objMain.ribbonControl1.Enabled = true; this.Enabled = true; this.Close(); } } SplashScreenManager.CloseForm(); } } catch { SplashScreenManager.CloseForm(); } } else if (CurrentInstName == "SKF/DI") { try { if (IsInstrument == false) { PathToUpLoad = upload.PCPath; PublicClass.Path = PathToUpLoad; } else { string path = Path.GetTempPath(); text1 = upload.textBox1.Text; PathToUpLoad = path + PublicClass.routename + ".dat"; } if (upload.IsCancelClicked == false) { clsdb.Main = _objMain; _objMain.ribbonControl1.Enabled = false; this.Enabled = false; if (text1 == null) { clsdb.UsbSelected = true; clsdb.DIuploaddata(PublicClass.routename); if (clsdb.check == "true") { _objMain.lblStatus.Caption = "Status: Uploading Route Successfully In Instrument"; MessageBox.Show("Route Create Sucessfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); SplashScreenManager.CloseForm(); _objMain.ribbonControl1.Enabled = true; this.Enabled = true; this.Close(); } else { MessageBox.Show("No point In Route", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); SplashScreenManager.CloseForm(); _objMain.ribbonControl1.Enabled = true; this.Enabled = true; this.Close(); } } else { clsdb.DIuploaddata(PublicClass.routename); if (clsdb.check == "true") { _objMain.lblStatus.Caption = "Status: Uploading Route Successfully In Instrument"; MessageBox.Show("Route Create Sucessfully In Instrument", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); //SplashScreenManager.CloseForm(); _objMain.ribbonControl1.Enabled = true; this.Enabled = true; this.Close(); } else { MessageBox.Show("No point In Route", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); //SplashScreenManager.CloseForm(); _objMain.ribbonControl1.Enabled = true; this.Enabled = true; this.Close(); } } } else { _objMain.lblStatus.Caption = "Status: Error"; MessageBox.Show("Route not Created", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Enabled = true; _objMain.ribbonControl1.Enabled = true; this.Close(); } SplashScreenManager.CloseForm(); } catch { SplashScreenManager.CloseForm(); } } else { if (IsInstrument == false) { PathToUpLoad = upload.PCPath; } else { if (m_objRAPI.DevicePresent) { m_objRAPI.Connect(); string path = Path.GetTempPath(); text1 = upload.textBox1.Text; PathToUpLoad = path + PublicClass.routename + ".sdf"; } else { SplashScreenManager.CloseForm(); MessageBox.Show(this, "Device Not Connected....", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } if (upload.IsCancelClicked == false) { _objMain.ribbonControl1.Enabled = false; this.Enabled = false; bool sStatus = CheckDemoSdf(); if (sStatus == true) { if (text1 != null) { getRouteInformation(PublicClass.routename); UploadData _objupload = new UploadData(); _objupload.Main = _objMain; _objupload.UploadValuesToBenstone(); _objMain.lblStatus.Caption = "Status: Uploading Route"; StartTheThread(); _objMain.lblStatus.Caption = "Status: Uploading Route Successfully In Instrument"; MessageBox.Show("Route Create Sucessfully In Instrument", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); _objMain.ribbonControl1.Enabled = true; this.Enabled = true; } else { getRouteInformation(PublicClass.routename); UploadData _objupload = new UploadData(); _objupload.Main = _objMain; _objupload.UploadValuesToBenstone(); _objMain.lblStatus.Caption = "Status: Uploading Route Successfully"; MessageBox.Show("Route Create Sucessfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); _objMain.ribbonControl1.Enabled = true; this.Enabled = true; } } else { _objMain.lblStatus.Caption = "Status: Error"; MessageBox.Show("Route not Created", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Enabled = true; _objMain.ribbonControl1.Enabled = true; this.Close(); } } if (PublicClass.routename != null) { this.Close(); } SplashScreenManager.CloseForm(); } } } catch { SplashScreenManager.CloseForm(); } } else { //MessageBox.Show("please connect correct instrumnet !","Error", MessageBoxIcon.Error,MessageBoxButtons.OK); } }
private void MostrarFiltro(Boolean blnSalir) { WINformulacion.Movimiento.Frm_ActualizaFormulacion_Personal_Filtro frm = new WINformulacion.Movimiento.Frm_ActualizaFormulacion_Personal_Filtro(); frm.ShowMe(); if (frm.blnProcesaExcel == true) { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); SplashScreenManager.Default.SetWaitFormDescription("Recopilando informaciòn..."); //Habilita Opciones this.Btn_BuscaClasificador.Enabled = true; this.Btn_DistribuyeLineaFormulada.Enabled = true; this.Btn_Guardar.Enabled = true; this.Btn_Imprimir.Enabled = true; //Traer Dato de la tabla Model.Formulacion_Cabecera MFC = new Model.Formulacion_Cabecera(); Service.Formulacion_Cabecera SFC = new Service.Formulacion_Cabecera(); if (MyStuff.UsaWCF == true) { MFC = objWCF.Recupera_FormulacionCabecera(MyStuff.AñoProceso); } else { MFC = SFC.Recupera_FormulacionCabecera(MyStuff.AñoProceso); } strAñoProceso = MFC.CañoProceso; strVersion = MFC.Cversion; strCodTipoFormulacion = "05"; strCodCentroCosto = frm.strCodCentroCosto; //-- Recuperar Datos Service.DataGeneral SDG = new Service.DataGeneral(); Service.CentroCosto SCC = new Service.CentroCosto(); if (MyStuff.UsaWCF == true) { DS_CentroCosto = objWCF.Ayuda_CentroCosto_Todos(); DS_Concepto = objWCF.Ayuda_Concepto(); } else { DS_CentroCosto = SCC.Ayuda_CentroCosto_Todos(); DS_Concepto = SDG.Ayuda_Concepto(); } Service.Formulacion_Detalle_Personal SFDP = new Service.Formulacion_Detalle_Personal(); if (MyStuff.UsaWCF == true) { DS_Formulacion = objWCF.Lista_FormulacionDetalle_Personal("000000", strCodCentroCosto, strCodTipoFormulacion); } else { DS_Formulacion = SFDP.Lista_FormulacionDetalle_Personal("000000", strCodCentroCosto, strCodTipoFormulacion); } workbook = spreadsheetControl.Document; string sRutaInterna = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"Excel\Formulacion_Personal.xlsx"); //workbook.LoadDocument(@"Excel\Formulacion_Proyecto_Inversion.xlsx", DocumentFormat.Xlsx); workbook.LoadDocument(sRutaInterna, DocumentFormat.Xlsx); Worksheet worksheet_HojaTrabajo = workbook.Worksheets[0]; worksheet_HojaTrabajo.Cells[3, 2].Value = frm.strNomProyecto; worksheet_HojaTrabajo.Cells[4, 2].Value = frm.strNomCentroCosto; worksheet_HojaTrabajo.Cells[2, 26].Value = MFC.CañoProceso; worksheet_HojaTrabajo.Cells[3, 26].Value = MFC.Cversion; worksheet_HojaTrabajo.Cells[4, 26].Value = "Gastos de Personal"; DV_Excel = DS_Formulacion.Tables[0].DefaultView; worksheet_HojaTrabajo.DataBindings.BindToDataSource(DV_Excel, 9, 1); //int intLinea = 9; //foreach (DataRow oRow1 in DS_Formulacion.Tables[0].Rows) //{ // string Rango = traeRangoCelda(1, intLinea + 1, 1, intLinea + 1); // workbook = spreadsheetControl.Document; // Range range = worksheet_HojaTrabajo.Range[Rango]; // Formatting rangeFormatting = range.BeginUpdateFormatting(); // rangeFormatting.Fill.BackgroundColor = Color.Green; // range.EndUpdateFormatting(rangeFormatting); // worksheet_HojaTrabajo.Cells[intLinea, 1].Value = Convert.ToString(oRow1["vNomTipoInserccion"]); // worksheet_HojaTrabajo.Cells[intLinea, 2].Value = Convert.ToString(oRow1["vNomCentroCosto"]); // worksheet_HojaTrabajo.Cells[intLinea, 3].Value = Convert.ToString(oRow1["vNomClaseGasto"]); // worksheet_HojaTrabajo.Cells[intLinea, 4].Value = Convert.ToString(oRow1["cCodClasificador"]); // worksheet_HojaTrabajo.Cells[intLinea, 5].Value = Convert.ToString(oRow1["vNomClasificador"]); // worksheet_HojaTrabajo.Cells[intLinea, 6].Value = Convert.ToString(oRow1["cCodPosPre"]); // worksheet_HojaTrabajo.Cells[intLinea, 7].Value = Convert.ToString(oRow1["vNomPosPre"]); // worksheet_HojaTrabajo.Cells[intLinea, 8].Value = Convert.ToString(oRow1["vNomFuenteFinanciamiento"]); // worksheet_HojaTrabajo.Cells[intLinea, 9].Value = Convert.ToString(oRow1["vNomConcepto"]); // worksheet_HojaTrabajo.Cells[intLinea, 10].Value = Convert.ToString(oRow1["Orden"]); // worksheet_HojaTrabajo.Cells[intLinea, 11].Value = Convert.ToString(oRow1["tDescripcionGasto"]); // worksheet_HojaTrabajo.Cells[intLinea, 12].Value = Convert.ToDouble(oRow1["fValorAnterior"]); // worksheet_HojaTrabajo.Cells[intLinea, 13].Value = Convert.ToDouble(oRow1["fValorRestoActual"]); // worksheet_HojaTrabajo.Cells[intLinea, 14].Value = Convert.ToDouble(oRow1["fMes_01"]); // worksheet_HojaTrabajo.Cells[intLinea, 15].Value = Convert.ToDouble(oRow1["fMes_02"]); // worksheet_HojaTrabajo.Cells[intLinea, 16].Value = Convert.ToDouble(oRow1["fMes_03"]); // worksheet_HojaTrabajo.Cells[intLinea, 17].Value = Convert.ToDouble(oRow1["fMes_04"]); // worksheet_HojaTrabajo.Cells[intLinea, 18].Value = Convert.ToDouble(oRow1["fMes_05"]); // worksheet_HojaTrabajo.Cells[intLinea, 19].Value = Convert.ToDouble(oRow1["fMes_06"]); // worksheet_HojaTrabajo.Cells[intLinea, 20].Value = Convert.ToDouble(oRow1["fMes_07"]); // worksheet_HojaTrabajo.Cells[intLinea, 21].Value = Convert.ToDouble(oRow1["fMes_08"]); // worksheet_HojaTrabajo.Cells[intLinea, 22].Value = Convert.ToDouble(oRow1["fMes_09"]); // worksheet_HojaTrabajo.Cells[intLinea, 23].Value = Convert.ToDouble(oRow1["fMes_10"]); // worksheet_HojaTrabajo.Cells[intLinea, 24].Value = Convert.ToDouble(oRow1["fMes_11"]); // worksheet_HojaTrabajo.Cells[intLinea, 25].Value = Convert.ToDouble(oRow1["fMes_12"]); // worksheet_HojaTrabajo.Cells[intLinea, 26].Value = Convert.ToDouble(oRow1["fValorFormulacion"]); // worksheet_HojaTrabajo.Cells[intLinea, 27].Value = Convert.ToDouble(oRow1["fValorFormulacionUno"]); // worksheet_HojaTrabajo.Cells[intLinea, 28].Value = Convert.ToDouble(oRow1["fValorFormulacionDos"]); // worksheet_HojaTrabajo.Cells[intLinea, 29].Value = Convert.ToDouble(oRow1["Distribucion"]); // worksheet_HojaTrabajo.Cells[intLinea, 30].Value = Convert.ToInt32(oRow1["iidFormulacion_Detalle_Personal"]); // //worksheet_HojaTrabajo.Cells[intLinea, 1000].Value = Convert.ToString(oRow1["vNomFuenteFinanciamiento"]); // this.FormatoCeldas(intLinea); // intLinea = intLinea + 1; // //} //} this.ValidarColumnas(); SplashScreenManager.CloseForm(); } else { //if (blnSalir == true) //this.Close(); } }
private void btnRefresh_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { SplashScreenManager.ShowForm(typeof(WaitForm1)); LoadCategory(); SplashScreenManager.CloseForm(); }
IOverlaySplashScreenHandle ShowProgressPanel(OverlayWindowOptions option, System.Windows.Forms.Control strlenh) { return(SplashScreenManager.ShowOverlayForm(strlenh, option)); }
//TODO Comment and Function private void barBtnFoxnews_ItemClick(object sender, ItemClickEventArgs e) { var splashScreenManagerCheckConnect = new SplashScreenManager(this , typeof(WaitFormPlease), true, true); if (SEDInternetConnection.CheckConnectTimeOutWait(splashScreenManagerCheckConnect) == false) return; var splashScreenManager = SEDFuncCall.ShowWaitForm(this, null, null); var frm = CheckFormExists(typeof(PE03FrmParseFoxnews)); if (frm != null) { frm.Activate(); } else { var f = new PE03FrmParseFoxnews { MdiParent = this }; f.Show(); } splashScreenManager.CloseWaitForm(); }