/// <summary> /// Загружает cвойства настройки /// </summary> /// <param name="objSetting">настройка</param> public void LoadSettingProperties(CSetting objSetting) { m_bDisableEvents = true; if (objSetting == null) { return; } try { m_objSetting = objSetting; lblSettingName.Text = m_objSetting.Name; tableLayoutPanel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.treeListParams)).BeginInit(); treeListParams.Nodes.Clear(); if (m_objSetting.xmldocAdvancedParamList != null) { foreach (System.Xml.XmlNode objNode in m_objSetting.xmldocAdvancedParamList.ChildNodes) { AddNode(treeListParams, null, objNode); } } //if (m_objSetting.ParamList != null) //{ // System.String strGroupName = ""; // DevExpress.XtraTreeList.Nodes.TreeListNode objGroupNode = null; // foreach (CAdvancedParam objParam in m_objSetting.ParamList) // { // if ((objParam.GroupName != "") && (objParam.GroupName != strGroupName)) // { // strGroupName = objParam.GroupName; // objGroupNode = treeListParams.AppendNode(new object[] { strGroupName, null }, null); // } // treeListParams.AppendNode(new object[] { objParam.Name, objParam.Value }, objGroupNode).Tag = objParam; // } //} treeListParams.ExpandAll(); this.tableLayoutPanel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.treeListParams)).EndInit(); SetPropertiesModified(false); SetModeReadOnly(true); btnCancel.Enabled = true; btnCancel.Focus(); } catch (System.Exception f) { SendMessageToLog("Ошибка редактирования описания настройки. Текст ошибки: " + f.Message); } finally { m_bDisableEvents = false; } return; }
public ctrlSetting(UniXP.Common.CProfile objProfile, UniXP.Common.MENUITEM objMenuItem) { m_objProfile = objProfile; m_objMenuItem = objMenuItem; m_objSetting = null; m_bIsChanged = false; m_bDisableEvents = false; InitializeComponent(); }
/// <summary> /// Сохраняет в БД настройки для импорта данных в заказ /// </summary> /// <param name="objProfile">профайл</param> /// <param name="cmdSQL">SQL-команда</param> /// <param name="strErr">строка с сообщением об ошибке</param> /// <returns>true - успешное завершение операции; false - ошибка</returns> public System.Boolean SaveExportSetting(UniXP.Common.CProfile objProfile, System.Data.SqlClient.SqlCommand cmdSQL, ref System.String strErr) { System.Boolean bRet = false; try { bRet = CSetting.SaveSettingInDB(this.ID, this.XMLSettings.InnerXml, objProfile, cmdSQL, ref strErr); } catch (System.Exception f) { strErr += (f.Message); } finally { } return(bRet); }
/// <summary> /// Сохраняет изменения в базе данных /// </summary> /// <returns>true - удачное завершение операции;false - ошибка</returns> private System.Boolean bSaveChanges() { System.Boolean bRet = false; try { //CAdvancedParam objAdvancedParam = null; CSetting objSettingForSave = new CSetting(); objSettingForSave.Name = m_objSetting.Name; objSettingForSave.ID = m_objSetting.ID; objSettingForSave.xmldocAdvancedParamList = m_objSetting.xmldocAdvancedParamList; objSettingForSave.ParamList = new List <CAdvancedParam>(); if (objSettingForSave.xmldocAdvancedParamList != null) { for (System.Int32 i = 0; i < objSettingForSave.xmldocAdvancedParamList.ChildNodes.Count; i++) { SetNode(objSettingForSave.xmldocAdvancedParamList.ChildNodes[i], treeListParams.Nodes[i]); } } System.String strErr = ""; if (objSettingForSave.SaveSettingInDB(m_objProfile, null, ref strErr) == true) { m_objSetting.xmldocAdvancedParamList = objSettingForSave.xmldocAdvancedParamList; bRet = true; } else { SendMessageToLog("Ошибка сохранения изменений в описании настройки. Текст ошибки: " + strErr); } } catch (System.Exception f) { SendMessageToLog("Ошибка сохранения изменений в описании настройки. Текст ошибки: " + f.Message); } finally { } return(bRet); }
/// <summary> /// Возвращает список настроек /// </summary> /// <param name="objProfile">профайл</param> /// <param name="cmdSQL">SQL-команда</param> /// <returns>список настроек</returns> public static List <CSetting> GetSettingsList(UniXP.Common.CProfile objProfile, System.Data.SqlClient.SqlCommand cmdSQL) { List <CSetting> objList = new List <CSetting>(); System.Data.SqlClient.SqlConnection DBConnection = null; System.Data.SqlClient.SqlCommand cmd = null; try { if (cmdSQL == null) { DBConnection = objProfile.GetDBSource(); if (DBConnection == null) { DevExpress.XtraEditors.XtraMessageBox.Show( "Не удалось получить соединение с базой данных.", "Внимание", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); return(objList); } cmd = new System.Data.SqlClient.SqlCommand(); cmd.Connection = DBConnection; cmd.CommandType = System.Data.CommandType.StoredProcedure; } else { cmd = cmdSQL; cmd.Parameters.Clear(); } cmd.CommandText = System.String.Format("[{0}].[dbo].[sp_GetSettings]", objProfile.GetOptionsDllDBName()); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ERROR_NUM", System.Data.SqlDbType.Int, 8, System.Data.ParameterDirection.Output, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ERROR_MES", System.Data.SqlDbType.NVarChar, 4000)); cmd.Parameters["@ERROR_MES"].Direction = System.Data.ParameterDirection.Output; System.Data.SqlClient.SqlDataReader rs = cmd.ExecuteReader(); if (rs.HasRows) { CSetting objSetting = null; System.Xml.XmlDocument docInfoAboutParam = null; CAdvancedParam objParam = null; System.Xml.XmlNode objRootNode = null; while (rs.Read()) { objSetting = new CSetting(); objSetting.ID = (System.Guid)rs["Settings_Guid"]; objSetting.Name = System.Convert.ToString(rs["Settings_Name"]); objSetting.ParamList = new List <CAdvancedParam>(); if (rs["Settings_XML"] != System.DBNull.Value) { docInfoAboutParam = new System.Xml.XmlDocument(); docInfoAboutParam.LoadXml(System.Convert.ToString(rs["Settings_XML"])); if ((docInfoAboutParam != null) && (docInfoAboutParam.ChildNodes.Count > 0)) { objSetting.xmldocAdvancedParamList = docInfoAboutParam; objRootNode = docInfoAboutParam.ChildNodes[0]; //objSetting.Name = objRootNode.Name; foreach (System.Xml.XmlNode objNode in objRootNode.ChildNodes) { //if (objNode.Name == "CommonParams") //{ foreach (System.Xml.XmlNode objChildNode in objNode.ChildNodes) { //if (objChildNode.Name == "Params") //{ foreach (System.Xml.XmlAttribute objAttribute in objChildNode.Attributes) { objParam = new CAdvancedParam(System.Guid.Empty, objAttribute.Name, "", new CParamDataType(0, "")); objParam.GroupName = objNode.Name; objParam.Value = objAttribute.Value; objSetting.ParamList.Add(objParam); } //} //} } } } } objList.Add(objSetting); } } rs.Dispose(); if (cmdSQL == null) { cmd.Dispose(); DBConnection.Close(); } } catch (System.Exception f) { DevExpress.XtraEditors.XtraMessageBox.Show( "Не удалось получить список настроек.\n\nТекст ошибки: " + f.Message, "Внимание", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); } return(objList); }