private void UpdateGridView()
        {
            if (sqlConnection.State == System.Data.ConnectionState.Closed)
            {
                sqlConnection.Open();
            }

            try
            {
                #region DML Command Setup for Get Discipline Venues

                String strSQL;
                strSQL = String.Format(@"SELECT F_NewsID AS [ID], F_NewsItem AS [Item], F_SubTitle AS [SubTitle], F_Heading AS [Heading], F_Issued_by AS [IssuedBy], F_Date AS [Date]
					                       FROM  TS_Offical_Communication 
					                        WHERE F_DisciplineID = {0}"                    , m_nDisciplineID);

                SqlCommand cmd = new SqlCommand(strSQL, sqlConnection);
                #endregion

                SqlDataReader dr = cmd.ExecuteReader();
                OVRDataBaseUtils.FillDataGridView(dgvCommunication, dr, null, null);
                dr.Close();

                dgvCommunication.Columns["ID"].Visible = false;
            }
            catch (System.Exception e)
            {
                UIMessageDialog.ShowMessageDialog(e.Message, "Information", false, this.Style);
            }
        }
Esempio n. 2
0
        private void IntiStatusCmb(String strLanguageCode)
        {
            try
            {
                SqlCommand oneSqlCommand = new SqlCommand();
                oneSqlCommand.Connection  = m_DatabaseConnection;
                oneSqlCommand.CommandText = "Proc_GetEventStatusList";
                oneSqlCommand.CommandType = CommandType.StoredProcedure;

                SqlParameter cmdParameter5 = new SqlParameter(
                    "@LanguageCode", SqlDbType.Char, 3,
                    ParameterDirection.Input, true, 0, 0, "",
                    DataRowVersion.Current, strLanguageCode);
                oneSqlCommand.Parameters.Add(cmdParameter5);

                if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed)
                {
                    m_DatabaseConnection.Open();
                }

                SqlDataReader sdr1 = oneSqlCommand.ExecuteReader();
                m_tbStatus.Clear();
                m_tbStatus.Load(sdr1);
                CmbStatus.DisplayMember = "F_StatusLongName";
                CmbStatus.ValueMember   = "F_StatusID";
                CmbStatus.DataSource    = m_tbStatus;
                sdr1.Close();
            }
            catch (Exception ex)
            {
                UIMessageDialog.ShowMessageDialog(ex.Message, "", false, this.Style);
            }
        }
Esempio n. 3
0
        private void InitCmbOCType()
        {
            m_tbOCType.Clear();
            if (DatabaseConnection.State == System.Data.ConnectionState.Closed)
            {
                sqlConnection.Open();
            }

            try
            {
                SqlCommand cmd = new SqlCommand("proc_Get_CommunicationType", sqlConnection);
                cmd.CommandType = CommandType.StoredProcedure;

                SqlDataReader dr = cmd.ExecuteReader();
                m_tbOCType.Load(dr);
                dr.Close();

                cmbOCType.DisplayMember = "F_TypeDes";
                cmbOCType.ValueMember   = "F_Type";
                cmbOCType.DataSource    = m_tbOCType;
            }
            catch (System.Exception e)
            {
                UIMessageDialog.ShowMessageDialog(e.Message, "Information", false, this.Style);
            }
        }
Esempio n. 4
0
        private void DatabaseBackup()
        {
            if (UIMessageDialog.ShowAskDialog(this, "Are you sure to backup DB?", this.Style) != true)
            {
                return;
            }
            if (SqlCon.State == System.Data.ConnectionState.Closed)
            {
                SqlCon.Open();
            }

            string strSectionName = "MainFrame";
            string strMsg, strCaption;

            strCaption = LocalizationRecourceManager.GetString(strSectionName, "BackupDBCaption");
            if (OVRDataBaseUtils.BackupDB(SqlCon))
            {
                strMsg = LocalizationRecourceManager.GetString(strSectionName, "BackupDBSuccessMsg");
            }
            else
            {
                strMsg = LocalizationRecourceManager.GetString(strSectionName, "BackupDBFailMsg");
            }

            UIMessageDialog.ShowMessageDialog(strMsg, strCaption, false, this.Style);
        }
Esempio n. 5
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            int iResult;

            if (m_bAdd)
            {
                iResult = AddOfficialCommunication();

                if (iResult > 0)
                {
                    m_iNewsID = iResult;
                }
            }
            else
            {
                iResult = EditOfficialCommunication();
            }

            string strPromotion;
            string strSectionName = "OfficialCommunication";

            if (iResult <= 0)
            {
                strPromotion = LocalizationRecourceManager.GetString(strSectionName, "PromotionFailed");
                UIMessageDialog.ShowMessageDialog(strPromotion, "Information", false, this.Style);

                this.DialogResult = DialogResult.Cancel;
            }
            else
            {
                this.DialogResult = DialogResult.OK;
            }
            this.Close();
        }
 private void btnCancel_Click(object sender, EventArgs e)
 {
     if (dgvRoomSell.SelectedRows.Count > 0)
     {
         if (UIMessageDialog.ShowMessageDialog("你确定要删除该消费记录吗?", UILocalize.WarningTitle, true, Style))
         {
             string    time  = dgvRoomSell.SelectedRows[0].Cells["clSpendTime"].Value.ToString();
             string    name  = dgvRoomSell.SelectedRows[0].Cells["clSpendName"].Value.ToString();
             string    price = dgvRoomSell.SelectedRows[0].Cells["clSpendPrice"].Value.ToString();
             SellThing s     = new SellService().SelectSellThingByNameAndPrice(name, price);
             decimal   num   = Convert.ToDecimal(dgvRoomSell.SelectedRows[0].Cells["clSpendAmount"].Value.ToString());
             string    Stock = (s.Stock + num).ToString();
             if (new SellService().DeleteSellThing(txtRoomNo.Text, time) == true)
             {
                 bool n = new SellService().UpdateSellThing(Stock, s.SellNo);
                 UIMessageTip.ShowOk("撤销成功!", 1000);
                 LoadSpendInfoByRoomNo(txtRoomNo.Text);
                 LoadSellThingInfo();
             }
         }
         else
         {
             UIMessageTip.ShowError("操作取消!", 1000);
         }
     }
     else
     {
         MessageBox.Show("请选择要删除的消费记录!", "提示信息");
     }
 }
        private void btnCheckIn_Click(object sender, EventArgs e)
        {
            string account = txtAccount.Text.Trim();  //获取超管账号
            string pass    = txtPassword.Text.Trim(); //获取超管密码

            if (!CheckInputString(account, pass))
            {
                UIMessageDialog.ShowErrorDialog(this, "错误提示", "账号或密码包含除字母数字外的字符,请检查!", UIStyle.Red);
                return;
            }
            Admin a = new AdminService().SelectMangerByPass(account, pass);

            if (a != null)//判断超管是否存在
            {
                AdminInfo.Type    = a.AdminType;
                AdminInfo.Name    = a.AdminName;
                AdminInfo.Account = a.AdminAccount;
                FrmBackgroundSystem fm = new FrmBackgroundSystem();
                fm.Show();   //打开主窗体
                this.Hide(); //隐藏登录窗体
            }
            else
            {
                UIMessageDialog.ShowErrorDialog(this, "错误提示", "账号或密码有误,请检查!", UIStyle.Red);
                return;
            }
        }
Esempio n. 8
0
        private bool TestConnection()
        {
            try
            {
                if (this.sqlConnection.ConnectionString == null ||
                    this.sqlConnection.ConnectionString.Trim() == "")
                {
                    this.ActiveControl = this.btnDbSetting;
                    return(false);
                }

                UpdateUserList();
                UpdateRoleList();
            }
            catch (System.Data.SqlClient.SqlException ex)
            {
                string strMsg = "";
                for (int i = 0; i < ex.Errors.Count; i++)
                {
                    string strTemp = String.Format("Index #{0}\nErrorNumber: {1}\nMessage: {2}\nLineNumber: {3}\n",
                                                   i, ex.Errors[i].Number, ex.Errors[i].Message, ex.Errors[i].LineNumber);
                    strTemp += "Source: " + ex.Errors[i].Source + "\n" + "Procedure: " + ex.Errors[i].Procedure + "\n";

                    strMsg += strTemp;
                }
                string strCaption = LocalizationRecourceManager.GetString(strSectionName, "DBConnectingError");
                UIMessageDialog.ShowMessageDialog(strMsg, strCaption, false, this.Style);
                this.ActiveControl = this.btnDbSetting;
                return(false);
            }
            this.ActiveControl = this.txPwd;
            return(true);
        }
Esempio n. 9
0
        private void UpdateDisciplineList(string strItemSel)
        {
            string strPath = System.IO.Path.GetDirectoryName(Application.ExecutablePath) + "\\Plugin";

            string[] files = Directory.GetFiles(strPath, "*.dll");
            foreach (string file in files)
            {
                try
                {
                    //System.Reflection.Assembly asmPlugin = System.Reflection.Assembly.LoadFile(file);
                    System.Reflection.Assembly asmPlugin = System.Reflection.Assembly.LoadFrom(file);
                    Type[] types = asmPlugin.GetTypes();
                    foreach (Type type in types)
                    {
                        if (type.IsSubclassOf(typeof(OVRPluginBase)))
                        {
                            string strDiscCode = Path.GetFileNameWithoutExtension(file);
                            int    iIndex      = cmbDiscList.Items.Add(strDiscCode);
                            if (strItemSel.ToUpper() == strDiscCode.ToUpper())
                            {
                                cmbDiscList.SelectedIndex = iIndex;
                            }

                            break;
                        }
                    }
                }
                catch (System.Exception ex)
                {
                    UIMessageDialog.ShowMessageDialog(ex.Message, "Information", false, this.Style);
                }
            }
        }
Esempio n. 10
0
        private void btnlogin_Click(object sender, EventArgs e)
        {
            try
            {
                btnlogin.Enabled = false;
                ProcessBarStart();

                LoginWord();
            }
            catch (SystemException ex)
            {
                UIMessageDialog.ShowMessageDialog(ex.Message, UILocalize.InfoTitle, false, Style);
            }
        }
        private string QueryDistrubutedVersion(string strTplType, string strRscCode)
        {
            string strDisVersion;

            strDisVersion = "";

            strDisVersion = strTplType + strRscCode;
            try
            {
                SqlCommand oneSqlCommand = new SqlCommand();
                oneSqlCommand.Connection  = sqlConnection;
                oneSqlCommand.CommandText = "Proc_GetDistrubutedVersion";
                oneSqlCommand.CommandType = CommandType.StoredProcedure;

                SqlParameter cmdParameter1 = new SqlParameter(
                    "@TplType", SqlDbType.NVarChar, 20,
                    ParameterDirection.Input, true, 0, 0, "",
                    DataRowVersion.Current, strTplType);
                oneSqlCommand.Parameters.Add(cmdParameter1);

                SqlParameter cmdParameter2 = new SqlParameter(
                    "@RscCode", SqlDbType.NVarChar, 50,
                    ParameterDirection.Input, true, 0, 0, "",
                    DataRowVersion.Current, strRscCode);

                oneSqlCommand.Parameters.Add(cmdParameter2);

                if (sqlConnection.State == System.Data.ConnectionState.Closed)
                {
                    sqlConnection.Open();
                }

                SqlDataReader sdr = oneSqlCommand.ExecuteReader();
                if (sdr.HasRows)
                {
                    if (sdr.Read())
                    {
                        strDisVersion = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_DistrubutedVersion");
                    }
                }
                sdr.Close();
            }
            catch (Exception ex)
            {
                UIMessageDialog.ShowMessageDialog(ex.Message, "Information", false, this.Style);
            }

            return(strDisVersion);
        }
        private void btnDel_Click(object sender, EventArgs e)
        {
            if (dgvCommunication.SelectedRows.Count <= 0)
            {
                return;
            }

            string strSectionName = "OfficialCommunication";
            string strPromotion   = LocalizationRecourceManager.GetString(strSectionName, "PromotionDelete");

            if (DevComponents.DotNetBar.MessageBoxEx.Show(strPromotion, "", MessageBoxButtons.YesNo) != DialogResult.Yes)
            {
                return;
            }

            int iSelRowsID = dgvCommunication.SelectedRows[0].Index;
            int iNewsID    = Convert.ToInt32(dgvCommunication.Rows[iSelRowsID].Cells["ID"].Value);

            if (sqlConnection.State == System.Data.ConnectionState.Closed)
            {
                sqlConnection.Open();
            }

            try
            {
                #region DML Command Setup for Get Discipline Venues

                String strSQL;
                strSQL = String.Format(@"Delete TS_Offical_Communication 
					                        WHERE F_NewsID = {0}"                    , iNewsID);

                SqlCommand cmd = new SqlCommand(strSQL, sqlConnection);
                #endregion

                SqlDataReader dr = cmd.ExecuteReader();
                OVRDataBaseUtils.FillDataGridView(dgvCommunication, dr, null, null);
                dr.Close();
            }
            catch (System.Exception ex)
            {
                UIMessageDialog.ShowMessageDialog(ex.Message, "Information", false, this.Style);
            }
            UpdateGridView();

            DataChangedNotify(OVRDataChangedType.emOfficialComDel, m_nDisciplineID, -1, -1, -1, iNewsID, null);
        }
Esempio n. 13
0
        public bool TestConnection()
        {
            string strPassword = tbPassword.Text;

            try
            {
                //strPassword = OVRSimpleEncryption.Encrypt(tbPassword.Text);
            }
            catch (System.Exception ex)
            {
                DevComponents.DotNetBar.MessageBoxEx.Show(LocalizationRecourceManager.GetString("OVRLogin", "PwdIncorrect"));

                return(false);
            }

            _ConnectionString = String.Format(@"Data Source={0};User ID={1};Password={2};Initial Catalog={3};Persist Security Info={4};MultipleActiveResultSets=true;"
                                              , tbServer.Text, tbUserID.Text, strPassword, cmbDatabase.Text, cbSavePwd.Checked.ToString());

            using (SqlConnection sqlCon = new SqlConnection(_ConnectionString))
            {
                try
                {
                    sqlCon.Open();
                    sqlCon.Close();
                }
                catch (SqlException ex)
                {
                    string strMsg = "";
                    for (int i = 0; i < ex.Errors.Count; i++)
                    {
                        string strTemp = String.Format("Index #{0}\nErrorNumber: {1}\nMessage: {2}\nLineNumber: {3}\n",
                                                       i, ex.Errors[i].Number, ex.Errors[i].Message, ex.Errors[i].LineNumber);
                        strTemp += "Source: " + ex.Errors[i].Source + "\n" + "Procedure: " + ex.Errors[i].Procedure + "\n";

                        strMsg += strTemp;
                    }
                    string strCaption = LocalizationRecourceManager.GetString("OVRLogin", "DBConnectingError");
                    UIMessageDialog.ShowMessageDialog(strMsg, "Information", false, this.Style);
                    return(false);
                }
            }

            return(true);
        }
Esempio n. 14
0
        private void GetCommunicationContext()
        {
            if (m_iNewsID <= 0)
            {
                return;
            }
            if (DatabaseConnection.State == System.Data.ConnectionState.Closed)
            {
                sqlConnection.Open();
            }
            try
            {
                SqlCommand cmd = new SqlCommand("Proc_GetOfficialCommunication", DatabaseConnection);
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter cmdParameter1 = new SqlParameter("@NewsID", SqlDbType.Int);
                cmdParameter1.Value = m_iNewsID;
                cmd.Parameters.Add(cmdParameter1);

                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        textItem.Text           = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_NewsItem");
                        textSubTitle.Text       = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_SubTitle");
                        textHeading.Text        = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Heading");
                        textText.Text           = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Text");
                        textIssuedBy.Text       = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Issued_by");
                        cmbOCType.SelectedValue = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Type");
                        dtOCDate.Text           = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Date");
                        textNote.Text           = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Note");
                        cmbReportTitle.Text     = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_ReportTitle");
                        txtSummary.Text         = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Summary");
                        txtDetails.Text         = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_Details");
                    }
                }
                dr.Close();
            }
            catch (System.Exception e)
            {
                UIMessageDialog.ShowMessageDialog(e.Message, "Information", false, this.Style);
            }
        }
        private void CheckUpdate()
        {
            var newversion = new ApplicationVersionUtil().CheckBaseVersion();

            string version = System.Windows.Forms.Application.ProductVersion.ToString();

            if (newversion.base_version != version)
            {
                UIMessageDialog.ShowErrorDialog(this, "系统提醒", "旧版已停止使用,请到github或gitee仓库更新最新发行版!");
                System.Windows.Forms.Application.Exit();
                this.Visible = false;
                //调用系统默认的浏览器
                System.Diagnostics.Process.Start("https://gitee.com/java-and-net/TopskyHotelManagerSystem/releases");
            }
            else
            {
                UIMessageDialog.ShowSuccessDialog(this, "系统提醒", "当前已为最新版本,无需更新!");
            }
        }
Esempio n. 16
0
        private void OnDatabaseBackupClick(object sender, EventArgs e)
        {
            if (SqlCon.State == System.Data.ConnectionState.Closed)
            {
                SqlCon.Open();
            }

            string strSectionName = "MainFrame";
            string strMsg, strCaption;

            strCaption = LocalizationRecourceManager.GetString(strSectionName, "BackupDBCaption");
            if (OVRDataBaseUtils.BackupDB(SqlCon))
            {
                strMsg = LocalizationRecourceManager.GetString(strSectionName, "BackupDBSuccessMsg");
            }
            else
            {
                strMsg = LocalizationRecourceManager.GetString(strSectionName, "BackupDBFailMsg");
            }

            UIMessageDialog.ShowMessageDialog(strMsg, strCaption, false, this.Style);
        }
Esempio n. 17
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            if (!btnLogin.Enabled)
            {
                return;
            }

            if (cmbDiscList.SelectedIndex == -1)
            {
                UIMessageDialog.ShowMessageDialog(LocalizationRecourceManager.GetString(strSectionName, "DiscCodeNullException"), "Information", false, this.Style);
                return;
            }

            if (UserValidate() && LicenseValidate())
            {
                this.DialogResult = DialogResult.OK;
                Close();
            }
            else
            {
                UIMessageDialog.ShowMessageDialog(LocalizationRecourceManager.GetString(strSectionName, "PwdIncorrect"), "Information", false, this.Style);
            }
        }
Esempio n. 18
0
 private void btnAuto_Click(object sender, EventArgs e)
 {
     UIMessageDialog.ShowMessageDialog("跟随界面主题风格信息提示框", UILocalize.InfoTitle, false, Style);
 }
Esempio n. 19
0
        private int EditOfficialCommunication()
        {
            if (DatabaseConnection.State == System.Data.ConnectionState.Closed)
            {
                sqlConnection.Open();
            }

            try
            {
                #region DML Command Setup for Edit OfficialCommunication

                SqlCommand cmd = new SqlCommand("proc_Add_OfficialCommunication", sqlConnection);
                cmd.CommandType      = CommandType.StoredProcedure;
                cmd.UpdatedRowSource = UpdateRowSource.None;

                SqlParameter cmdParameter1 = new SqlParameter(
                    "@DisciplineiD", SqlDbType.Int, 0,
                    ParameterDirection.Input, false, 0, 0, "@DisciplineiD",
                    DataRowVersion.Current, m_iDisciplineID);

                SqlParameter cmdParameter2 = new SqlParameter(
                    "@bAddNew", SqlDbType.Bit, 1,
                    ParameterDirection.Input, false, 0, 0, "@bAddNew",
                    DataRowVersion.Current, 0);

                SqlParameter cmdParameter3 = new SqlParameter(
                    "@NewsID", SqlDbType.Int, 0,
                    ParameterDirection.Input, false, 0, 0, "@NewsID",
                    DataRowVersion.Current, m_iNewsID);

                SqlParameter cmdParameter4 = new SqlParameter(
                    "@NewsItem", SqlDbType.NVarChar, 20,
                    ParameterDirection.Input, false, 0, 0, "@NewsItem",
                    DataRowVersion.Current, textItem.Text);

                SqlParameter cmdParameter5 = new SqlParameter(
                    "@SubTitle", SqlDbType.NVarChar, 100,
                    ParameterDirection.Input, false, 0, 0, "@SubTitle",
                    DataRowVersion.Current, textSubTitle.Text);

                SqlParameter cmdParameter6 = new SqlParameter(
                    "@Heading", SqlDbType.NVarChar, 100,
                    ParameterDirection.Input, false, 0, 0, "@Heading",
                    DataRowVersion.Current, textHeading.Text);

                SqlParameter cmdParameter7 = new SqlParameter(
                    "@Text", SqlDbType.NVarChar, 1000,
                    ParameterDirection.Input, false, 0, 0, "@Text",
                    DataRowVersion.Current, textText.Text);

                SqlParameter cmdParameter8 = new SqlParameter(
                    "@Issuedby", SqlDbType.NVarChar, 100,
                    ParameterDirection.Input, false, 0, 0, "@Issuedby",
                    DataRowVersion.Current, textIssuedBy.Text);

                SqlParameter cmdParameter9 = new SqlParameter(
                    "@Type", SqlDbType.Int, 0,
                    ParameterDirection.Input, false, 0, 0, "@Type",
                    DataRowVersion.Current, cmbOCType.SelectedValue);

                SqlParameter cmdParameter10 = new SqlParameter("@Date", SqlDbType.DateTime);
                cmdParameter10.Direction = ParameterDirection.Input;
                if (dtOCDate.Text == "")
                {
                    cmdParameter10.Value = DBNull.Value;
                }
                else
                {
                    cmdParameter10.Value = dtOCDate.Text;
                }

                SqlParameter cmdParameter11 = new SqlParameter(
                    "@Note", SqlDbType.NVarChar, 200,
                    ParameterDirection.Input, false, 0, 0, "@Note",
                    DataRowVersion.Current, textNote.Text);

                SqlParameter cmdParameter12 = new SqlParameter(
                    "@ReportTitle", SqlDbType.NVarChar, 100,
                    ParameterDirection.Input, false, 0, 0, "@ReportTitle",
                    DataRowVersion.Current, cmbReportTitle.Text);

                SqlParameter cmdParameter13 = new SqlParameter(
                    "@Summary", SqlDbType.NVarChar, 1000,
                    ParameterDirection.Input, false, 0, 0, "@Summary",
                    DataRowVersion.Current, txtSummary.Text);

                SqlParameter cmdParameter14 = new SqlParameter(
                    "@Details", SqlDbType.NVarChar, 1000,
                    ParameterDirection.Input, false, 0, 0, "@Details",
                    DataRowVersion.Current, txtDetails.Text);

                SqlParameter cmdParameterResult = new SqlParameter(
                    "@Result", SqlDbType.Int, 0,
                    ParameterDirection.Output, false, 0, 0, "@Result",
                    DataRowVersion.Default, null);

                cmd.Parameters.Add(cmdParameter1);
                cmd.Parameters.Add(cmdParameter2);
                cmd.Parameters.Add(cmdParameter3);
                cmd.Parameters.Add(cmdParameter4);
                cmd.Parameters.Add(cmdParameter5);
                cmd.Parameters.Add(cmdParameter6);
                cmd.Parameters.Add(cmdParameter7);
                cmd.Parameters.Add(cmdParameter8);
                cmd.Parameters.Add(cmdParameter9);
                cmd.Parameters.Add(cmdParameter10);
                cmd.Parameters.Add(cmdParameter11);
                cmd.Parameters.Add(cmdParameter12);
                cmd.Parameters.Add(cmdParameter13);
                cmd.Parameters.Add(cmdParameter14);
                cmd.Parameters.Add(cmdParameterResult);
                cmd.UpdatedRowSource = UpdateRowSource.OutputParameters;
                #endregion

                cmd.ExecuteNonQuery();
                int nRetValue = (int)cmd.Parameters["@Result"].Value;

                return(nRetValue);
            }
            catch (System.Exception e)
            {
                UIMessageDialog.ShowMessageDialog(e.Message, "Information", false, this.Style);
                return(-1);
            }
        }
Esempio n. 20
0
 /// <summary>
 ///     确认信息提示框
 /// </summary>
 /// <param name="msg">信息</param>
 /// <param name="showMask">显示遮罩层</param>
 /// <returns>结果</returns>
 public static bool ShowAskDialog(string msg, bool showMask = true)
 {
     return(UIMessageDialog.ShowMessageDialog(msg, UILocalize.AskTitle, true, UIStyle.Blue, showMask));
 }
Esempio n. 21
0
        private void LoadSystemSettings()
        {
            string strAppDir = Path.GetDirectoryName(Application.ExecutablePath);

            string strDiscCode         = ConfigurationManager.GetUserSettingString("DiscCode").Trim();
            string strPrtPath          = ConfigurationManager.GetUserSettingString("PrtPath").Trim();
            string strCurCul           = ConfigurationManager.GetUserSettingString("CultureName").Trim();
            string strConnectionString = ConfigurationManager.GetUserSettingString("ConnectionString").Trim();

            // Decrypt Password
            strConnectionString = PasswordProcessing(strConnectionString, true);

            if ("1" == ConfigurationManager.GetUserSettingString("DCEnable").Trim() ||
                (strDiscCode != null && strDiscCode.Length > 0))
            {
                this.cmbDiscList.Enabled = true;
            }
            else
            {
                this.cmbDiscList.Enabled = false;
            }

            // Get the Language File
            string strLangFilePath = strAppDir + "\\Localization\\";
            string strDefCul       = System.Globalization.CultureInfo.CurrentCulture.Name;
            string strDefLangFile  = null;
            string strCurLangFile  = null;

            DataRow drDef = dtLanguageTable.NewRow();

            drDef["F_Description"] = "Default";
            drDef["F_CulName"]     = "Default";
            dtLanguageTable.Rows.Add(drDef);

            string[] files = Directory.GetFiles(strLangFilePath, "*.xml");
            foreach (string file in files)
            {
                System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(file);
                xmlReader.ReadToDescendant("Localization");

                DataRow dr = dtLanguageTable.NewRow();
                dr["F_Description"] = xmlReader["description"];
                dr["F_CulName"]     = xmlReader["cultureName"];
                dr["F_FileName"]    = Path.GetFileName(file);
                dtLanguageTable.Rows.Add(dr);

                if (xmlReader["cultureName"] == strDefCul)
                {
                    strDefLangFile = dr["F_FileName"].ToString();
                }

                if (xmlReader["cultureName"] == strCurCul)
                {
                    strCurLangFile = dr["F_FileName"].ToString();
                }
            }

            if (strDefLangFile == null)
            {
                if (dtLanguageTable.Rows.Count > 1)
                {
                    drDef["F_FileName"] = dtLanguageTable.Rows[1]["F_FileName"];
                }
                else
                {
                    drDef["F_FileName"] = "";
                }
            }

            if (strCurLangFile == null)
            {
                strCurCul      = "Default";
                strCurLangFile = drDef["F_FileName"].ToString();
            }

            cmbLanguage.DataSource    = dtLanguageTable;
            cmbLanguage.DisplayMember = "F_Description";
            cmbLanguage.ValueMember   = "F_CulName";
            cmbLanguage.SelectedValue = strCurCul;

            string strLangFile = strLangFilePath + strCurLangFile;

            if (!LocalizationRecourceManager.LoadLocalResource(strLangFile))
            {
                UIMessageDialog.ShowMessageDialog("Failed to Load Language Resource!", "OVR System Error", false, this.Style);
            }

            this.sqlConnection.ConnectionString = strConnectionString;
            this.lbServerName.Text = this.sqlConnection.DataSource;
            this.lbDbName.Text     = this.sqlConnection.Database;
            this.txRptPrtPath.Text = strPrtPath;

            UpdateDisciplineList(strDiscCode);

            Localization();
        }
Esempio n. 22
0
 public bool ShowMessageDialog(string msg)
 {
     return(UIMessageDialog.ShowMessageDialog(msg, UILocalize.InfoTitle, false, Style));
 }