public bool DeleteTriggerMaintenance_ByMaintenanceValue(DBSetting dbSetting, CategoryEnum category, ActionTypeEnum actionType, string maintenanceValue) { var TriggerMaintenanceList = TriggerMaintenanceRepo.Instance.GetTriggerMaintenance_ByMaintenanceValue(dbSetting, category, actionType, maintenanceValue.Replace("'", "''")); var responseModel = new DBResponseModel(); if (TriggerMaintenanceList.Rows.Count != 0) { //Delete the record responseModel = TriggerMaintenanceRepo.Instance.DeleteTriggerMaintenance_ByMaintenanceValue(dbSetting, category, maintenanceValue); if (responseModel.Status == DBStatusCodeEnum.Success) { return(true); } else { // fail, insert into log return(false); } } else { return(true); } }
// if the user single clicks on an item, show the value of that item private void advancedSettingsTreeView_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e) { TreeNode selectedNode = advancedSettingsTreeView.SelectedNode; // if the user selected a settings node if (selectedNode != null && selectedNode.Tag != null && selectedNode.Tag.GetType() == typeof(DBSetting)) { setValueTextBox.Enabled = true; selectedSetting = (DBSetting)selectedNode.Tag; setValueTextBox.Text = selectedSetting.StringValue; setDescriptionLabel.Text = selectedSetting.Description; moreInfoLinkLabel.Visible = (selectedSetting.MoreInfoLink != null); } else { setValueTextBox.Enabled = false; setDescriptionLabel.Text = string.Empty; setValueTextBox.Text = String.Empty; moreInfoLinkLabel.Visible = false; } updateSettingButton.Enabled = false; }
public bool CheckAPITokenFile(DBSetting dbSetting) { string sFilePath = GetAPITokenFilePath(); if (File.Exists(sFilePath)) { FileInfo fInfo = new FileInfo(sFilePath); var size = fInfo.Length; if (System.Convert.ToInt32(size) > 0) { return(true); } else { return(false); } } else { var response = MasterRepo.Instance.GetServiceSyncDataValue(dbSetting, SyncDataTypeEnum.API_TOKEN_VAL); if (response.Rows.Count != 0) { return(true); } else { return(false); } } }
public static void AddTransient( IServiceCollection services, DBMS dbms, string connectionString) { services.AddTransient <IUserService, AdvancedUserService>(); services.AddTransient <IUserRepository>( userRepository => new UserRepository( DBSetting.GetUserContext(dbms, connectionString)) ); services.AddTransient <IUserRoleRepository>( userRoleRepository => new UserRoleRepository( DBSetting.GetUserContext(dbms, connectionString)) ); services.AddTransient <IAccountRepository>( userRepository => new AccountRepository( DBSetting.GetUserContext(dbms, connectionString)) ); services.AddTransient <IAccountRoleRepository>( userRepository => new AccountRoleRepository( DBSetting.GetUserContext(dbms, connectionString)) ); services.AddTransient <IAccountAddressRepository>( userRepository => new AccountAddressRepository( DBSetting.GetUserContext(dbms, connectionString)) ); }
/// <summary> /// 注册链接|Register database links /// </summary> /// <param name="strConn">connection string</param> /// <param name="dBType">type of database</param> /// <param name="dbAliase">Multiple databases can be injected depending on the key</param> public static void ConfigRegist(string strConn, DBType dBType = DBType.SqlServer, string dbAliase = DefaultAliase) { var dbSetting = new DBSetting() { ConnectionString = strConn, DBType = dBType }; ConfigRegist(dbSetting, dbAliase); }
public DataTable GetServiceSyncDataValue(DBSetting dbSetting, SyncDataTypeEnum dataType) { string sQuery = string.Format(DBScripts.MASTER_GETSERVICESYNCDATA_BYDATATYPE, dataType.ToString()); sQuery = DBHelper.Instance.QueryScript(DBTables.TABLE_FLEX_SERVICESYNCDATA, sQuery); DataTable dt = dbSetting.GetDataTable(sQuery, false); return(dt); }
/// <summary> /// 单击单元格(编辑、删除、缓存) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvSource_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex == -1) { return; } string id = this.dgvSource.Rows[e.RowIndex].Cells["ID"].Value.ToString(); if (e.ColumnIndex == 0)//修改 { OpenDetailWin(id); } else if (e.ColumnIndex == 1)//删除 { DialogResult dr = MessageBox.Show("是否确定删除?", "提示", MessageBoxButtons.OKCancel); if (dr == DialogResult.OK) { string msg; bll.DeleteDBSet(id, out msg); MessageBox.Show(msg, "提示", MessageBoxButtons.OK); BindDBList(); } } else if (e.ColumnIndex == 2)//缓存 { DialogResult dr = MessageBox.Show("是否确定缓存数据源?", "提示", MessageBoxButtons.OKCancel); if (dr == DialogResult.OK) { this.Enabled = false; PgsBar pgs = new PgsBar(pgsDBList, lblShow); TableBLL auxbll = new TableBLL(); string filename = bll.GetFilePath(id, this.dgvSource.Rows[e.RowIndex].Cells["NAME"].Value.ToString()); DBSetting setmodel = new DBSetting(); setmodel.Flag = CommonConfig.DataType.DB; setmodel.DBAccount.DB = this.dgvSource.Rows[e.RowIndex].Cells["DB"].Value.ToString(); setmodel.DBAccount.User = this.dgvSource.Rows[e.RowIndex].Cells["USER"].Value.ToString(); setmodel.DBAccount.Pwd = this.dgvSource.Rows[e.RowIndex].Cells["PWD"].Value.ToString(); auxbll.IninDefinitionDAL(setmodel); string retmsg; if (auxbll.CacheTable(pgs, filename, out retmsg)) { DataBaseModel model = new DataBaseModel(); model.ID = id; model.PATH = filename; if (!bll.SetCache(model, out retmsg)) { MessageBox.Show(retmsg, "提示", MessageBoxButtons.OK); } } this.Enabled = true; BindDBList(); } } }
public DataTable GetTriggerMaintenance_ByMaintenanceValue(DBSetting dbSetting, CategoryEnum category, ActionTypeEnum actionType, string maintenanceValue) { string sQuery = string.Format(DBScripts.TRIGGERMAINTENANCE_GETLIST_BYMAINTENANCEVALUE, category.ToString().ToUpper(), maintenanceValue.ToString(), actionType.ToString().ToUpperInvariant()); sQuery = DBHelper.Instance.QueryScript(DBTables.TABLE_TRIGGERMAINTENANCE, sQuery); DataTable dt = dbSetting.GetDataTable(sQuery, false); return(dt); }
/// <summary> /// 实例化目标 /// </summary> /// <param name="setting"></param> public void IninTargetDAL(DBSetting setting) { if (setting.Flag == CommonConfig.DataType.DB) { itargetdal = DalFactory.CreateTableDAL(CommonConfig.DataType.DB, setting.DBAccount.GetConnStr()); } else { itargetdal = DalFactory.CreateTableDAL(CommonConfig.DataType.XML, setting.XMLPath); } }
private DBSetting GetSettingFromUI() { DBSetting objDBSetting = new DBSetting() { DB_IP = Functions.FormatString(txtDBIP.Text), DB_Name = Functions.FormatString(txtDBName.Text), DB_User = Functions.FormatString(txtUserName.Text), DB_Password = Functions.FormatString(txtUserPassword.Text) }; return(objDBSetting); }
public string GetServiceConfigureDetail(DBSetting dbSetting, SyncDataTypeEnum type) { var response = MasterRepo.Instance.GetServiceSyncDataValue(dbSetting, type); var result = string.Empty; if (response.Rows.Count != 0) { result = CryptoHelper.Decrypt(response.Rows[0][DBVariables.VAR_SERVICEVALUE].ToString()); } return(result); }
private static Setting DBMapping(DBSetting dbItem) { if (dbItem == null) return null; Setting item = new Setting(); item.SettingID = dbItem.SettingID; item.Name = dbItem.Name; item.Value = dbItem.Value; item.Description = dbItem.Description; return item; }
/// <summary> /// Gets a setting /// </summary> /// <param name="SettingID">Setting identifer</param> /// <returns>Setting</returns> public static Setting GetSettingByID(int SettingID) { if (SettingID == 0) { return(null); } DBSetting dbItem = DBProviderManager <DBSettingProvider> .Provider.GetSettingByID(SettingID); Setting setting = DBMapping(dbItem); return(setting); }
public bool GetRealTimeSyncStatus(DBSetting dbSetting, SyncDataTypeEnum type) { var response = MasterRepo.Instance.GetServiceSyncDataValue(dbSetting, type); if (response.Rows.Count != 0) { if (System.Convert.ToInt32(response.Rows[0][DBVariables.VAR_SERVICEVALUE2].ToString()).Equals(MasterConstant.MASTER_REALTIMESTATUSVALUE)) { return(true); } } return(false); }
/// <summary> /// Updates a setting /// </summary> /// <param name="SettingID">Setting identifier</param> /// <param name="Name">The name</param> /// <param name="Value">The value</param> /// <param name="Description">The description</param> /// <returns>Setting</returns> public static Setting UpdateSetting(int SettingID, string Name, string Value, string Description) { DBSetting dbItem = DBProviderManager <DBSettingProvider> .Provider.UpdateSetting(SettingID, Name, Value, Description); Setting setting = DBMapping(dbItem); if (SettingManager.CacheEnabled) { NopCache.RemoveByPattern(SETTINGS_ALL_KEY); } return(setting); }
public bool GetLoginAcessCheck(DBSetting dbSetting) { var response = MasterRepo.Instance.GetServiceSyncDataValue(dbSetting, SyncDataTypeEnum.ACCESSCHECK); if (response.Rows.Count != 0) { if (response.Rows[0][DBVariables.VAR_SERVICEVALUE].ToString().ToUpperInvariant().Equals(MasterConstant.MASTER_LOGINACCESSCHECK_SUCCESS)) { return(true); } } return(false); }
public DBResponseModel DeleteTriggerMaintenance_ByMaintenanceValue(DBSetting dbSetting, CategoryEnum category, string maintenanceValue) { string sQuery = string.Format(DBScripts.TRIGGERMAINTENANCE_DELETE_BYMAINTENANCEVALUE, DBParams.PARAM_DOCTYPE, DBParams.PARAM_VALUE); sQuery = DBHelper.Instance.QueryScript(DBTables.TABLE_TRIGGERMAINTENANCE, sQuery); Dictionary <string, object> param = new Dictionary <string, object>(); param.Add(DBParams.PARAM_DOCTYPE, category.ToString().ToUpper()); param.Add(DBParams.PARAM_VALUE, maintenanceValue); var response = DBHelper.Instance.Execute(dbSetting, sQuery, param); return(response); }
/// <summary> /// 注册链接|Register database links /// </summary> /// <param name="db">connection model</param> /// <param name="dbAliase">Multiple databases can be injected depending on the key</param> public static void ConfigRegist(DBSetting db, string dbAliase = DefaultAliase) { if (DBSettingDic == null) { DBSettingDic = new ConcurrentDictionary <string, DBSetting>(); } if (string.IsNullOrEmpty(dbAliase)) { dbAliase = DefaultAliase; } if (DBSettingDic.ContainsKey(dbAliase)) { throw new Exception("The same key already exists:" + dbAliase); } DBSettingDic[dbAliase] = db; }
private static Setting DBMapping(DBSetting dbItem) { if (dbItem == null) { return(null); } var item = new Setting(); item.SettingId = dbItem.SettingId; item.Name = dbItem.Name; item.Value = dbItem.Value; item.Description = dbItem.Description; return(item); }
public DBResponseModel UpdateTriggerMaintenance(DBSetting dbSetting, CategoryEnum category, ActionTypeEnum actionType, string maintenanceValue) { string sQuery = string.Format(DBScripts.TRIGGERMAINTENANCE_UPDATE, DBParams.PARAM_MODIFIEDDATE, DBParams.PARAM_DOCTYPE, DBParams.PARAM_VALUE, DBParams.PARAM_STATUS); sQuery = DBHelper.Instance.QueryScript(DBTables.TABLE_TRIGGERMAINTENANCE, sQuery); Dictionary <string, object> param = new Dictionary <string, object>(); param.Add(DBParams.PARAM_MODIFIEDDATE, DateTime.Now); param.Add(DBParams.PARAM_DOCTYPE, category.ToString().ToUpper()); param.Add(DBParams.PARAM_VALUE, maintenanceValue); param.Add(DBParams.PARAM_STATUS, actionType.ToString().ToUpper()); var response = DBHelper.Instance.Execute(dbSetting, sQuery, param); return(response); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { var dbConfigSettingConfig = Configuration.GetSection("DBSettings"); DBSetting dbSetting = new DBSetting(); dbConfigSettingConfig.Bind(dbSetting); services.AddSingleton(s => dbSetting); services.AddTransient <IUserService, UserService>(); services.AddTransient <IDocumentDBService, DocumentDBService>(); services.AddMvc(); services.AddSwaggerGen(swagger => { swagger.DescribeAllEnumsAsStrings(); swagger.DescribeAllParametersInCamelCase(); swagger.SwaggerDoc("v1", new Info { Title = "Cosmos DB Document client", Version = "v1" }); }); }
public DBResponseModel Execute(DBSetting dbSetting, string query, Dictionary <string, object> _params = null) { DBResponseModel response = new DBResponseModel(); using (SqlConnection conn = new SqlConnection(dbSetting.ConnectionString)) { SqlCommand cmd = new SqlCommand(); try { cmd.Connection = conn; cmd.CommandText = query; cmd.Connection.Open(); if (_params.Count != 0) { foreach (var param in _params) { cmd.Parameters.AddWithValue(param.Key, param.Value); } } cmd.ExecuteNonQuery(); response = new DBResponseModel { Status = DBStatusCodeEnum.Success }; } catch (Exception ex) { response = new DBResponseModel { Status = DBStatusCodeEnum.Fail, Message = ex.Message.ToString(), }; } finally { cmd.Connection.Close(); } } return(response); }
protected override void BtnOK_Click(object sender, EventArgs e) { string strDBIP = Functions.FormatString(txtDBIP.Text); string strUserName = Functions.FormatString(txtUserName.Text); string strUserPassword = Functions.FormatString(txtUserPassword.Text); //地址 if (string.IsNullOrEmpty(strDBIP) || strDBIP.Equals("")) { txtDBIP.Focus(); CMessageBox.ShowError(string.Format("请输入数据库地址!"), Config.DialogTitle); return; } //名称 if (string.IsNullOrEmpty(strUserName) || strUserName.Equals("")) { txtUserName.Focus(); CMessageBox.ShowError(string.Format("请输入数据库用户名!"), Config.DialogTitle); return; } DBLinkTestForm objModal = new DBLinkTestForm(string.Format("SERVER={0};Port={1};User ID={2};Password={3};Charset={4};Database=mysql;allow user variables=true", strDBIP, "3308", strUserName, strUserPassword, System.Text.Encoding.Default.HeaderName.ToString())); if (objModal.ShowDialog() == DialogResult.OK) { _DBSetting = new DBSetting() { DB_IP = strDBIP, DB_User = strUserName, DB_Password = strUserPassword }; this.DialogResult = DialogResult.OK; } else if (objModal.ShowDialog() == DialogResult.No) { CMessageBox.ShowError(string.Format("目的服务器配置错误,原因可能是数据库未安装或则用户名密码错误,请重新设置和排查!"), Config.DialogTitle); } else { Application.Exit(); } }
public bool GetModulePermission(DBSetting dbSetting, CategoryEnum category) { var response = MasterRepo.Instance.GetServiceSyncDataValue(dbSetting, SyncDataTypeEnum.PERMISSION); if (response.Rows.Count != 0) { string sReadPermission = category.ToString() + PermissionEnum.Read.ToString(); string sWritePermission = category.ToString() + PermissionEnum.Write.ToString(); List <string> sPermissions = new List <string>(); sPermissions = response.Rows[0][DBVariables.VAR_SERVICEVALUE].ToString().Split(',').ToList(); if (sPermissions.Contains(sReadPermission) && sPermissions.Contains(sWritePermission)) { return(true); } } return(false); }
public static List <SPParameterEntity> GetParameter(string SPName) { List <SPParameterEntity> list = new List <SPParameterEntity>(); DBSettingEntity dbSetting = new DBSettingEntity(DataProvider.SqlServer, DBSetting.GetDBConnection(DBSource.MainDBConstr), CommandType.StoredProcedure, DBSetting.GetSPValue("GetSPParameters"), false); dbSetting.AddParameters("@SPName", DBSetting.GetSPValue(SPName), ParameterDirection.Input); Func <IDataReader, bool> func = delegate(IDataReader dr) { List <string> drlist = new List <string>(); while (dr.Read()) { list.Add((SPParameterEntity)DBHelper.DataReaderMapping(dr, new SPParameterEntity())); } return(true); }; DBManager2.Instance.ExecuteReader(dbSetting, func); return(list); }
private void BtnCheckDBSetting_Click(object sender, EventArgs e) { DBSetting objDBSetting = GetSettingFromUI(); if (!CheckDBSettings(objDBSetting, out string strErrInfo)) { CMessageBox.ShowError(string.Format("数据库配置错误,错误如下:\r\n{0}", strErrInfo), Config.DialogTitle); return; } DBLinkTestForm objModal = new DBLinkTestForm(string.Format("SERVER={0};Port={1};User ID={2};Password={3};Charset={4};Database={5};allow user variables=true", objDBSetting.DB_IP, "3308", objDBSetting.DB_User, objDBSetting.DB_Password, System.Text.Encoding.Default.HeaderName.ToString(), objDBSetting.DB_Name)); if (objModal.ShowDialog() == DialogResult.OK) { CMessageBox.ShowSucc(string.Format("恭喜您,数据库连接成功!"), Config.DialogTitle); } else if (objModal.ShowDialog() == DialogResult.No) { CMessageBox.ShowError(string.Format("对不起,数据库连接失败!请重新配置软件参数!"), Config.DialogTitle); File.Delete(RunVariable.IniPathAndFileName); } }
public ImporterSettingsPane() { InitializeComponent(); // if we are in designer, break to prevent errors with rendering, it cant access the DB... if (LicenseManager.UsageMode == LicenseUsageMode.Designtime) { return; } autoApproval = MovingPicturesCore.Settings["importer_autoapprove"]; settingAutoApproveAlternateTitle.Setting = MovingPicturesCore.Settings["importer_autoapprove_alternate_titles"]; settingAutoApproveAlternateTitle.IgnoreSettingName = true; preferFolderCheckBox.Setting = MovingPicturesCore.Settings["importer_prefer_foldername"]; folderGroupingCheckBox.Setting = MovingPicturesCore.Settings["importer_groupfolder"]; nfoExtTextBox.Setting = MovingPicturesCore.Settings["importer_nfoext"]; nfoScannerCheckBox.Setting = MovingPicturesCore.Settings["importer_nfoscan"]; nfoScannerCheckBox.IgnoreSettingName = true; nfoAutoApproveCheckBox.Setting = MovingPicturesCore.Settings["importer_autoimdb"]; nfoAutoApproveCheckBox.IgnoreSettingName = true; coverFromMovieFolderCheckBox.Setting = MovingPicturesCore.Settings["local_cover_from_movie_folder"]; coverFromMovieFolderCheckBox.IgnoreSettingName = true; coverPatternTextBox.Setting = MovingPicturesCore.Settings["local_moviefolder_coverart_pattern"]; backdropFromMovieFolderCheckBox.Setting = MovingPicturesCore.Settings["local_backdrop_from_movie_folder"]; backdropFromMovieFolderCheckBox.IgnoreSettingName = true; backdropPatternTextBox.Setting = MovingPicturesCore.Settings["local_moviefolder_backdrop_pattern"]; coverCountTextBox.Setting = MovingPicturesCore.Settings["max_covers_per_movie"]; autoRescanCheckBox.Setting = MovingPicturesCore.Settings["importer_rescan_enabled"]; rescanIntervalTextBox.Setting = MovingPicturesCore.Settings["importer_rescan_interval"]; MovingPicturesCore.Settings.SettingChanged += new Cornerstone.Database.SettingChangedDelegate(Settings_SettingChanged); }
public GUISettingsPane() { InitializeComponent(); // if we are in designer, break to prevent errors with rendering, it cant access the DB... if (LicenseManager.UsageMode == LicenseUsageMode.Designtime) { return; } homeScreenTextBox.Setting = MovingPicturesCore.Settings["home_name"]; watchedPercentTextBox.Setting = MovingPicturesCore.Settings["gui_watch_percentage"]; remoteControlCheckBox.Setting = MovingPicturesCore.Settings["enable_rc_filter"]; enableDeleteCheckBox.Setting = MovingPicturesCore.Settings["enable_delete_movie"]; allowRescanInGuiCheckBox.Setting = MovingPicturesCore.Settings["allow_rescan_movie"]; parentalControlsCheckBox.Setting = MovingPicturesCore.Settings["enable_parental_controls"]; passwordTextBox.Setting = MovingPicturesCore.Settings["parental_controls_password"]; categoriesCheckBox.Setting = MovingPicturesCore.Settings["enable_categories"]; defaultFilterCheckBox.Setting = MovingPicturesCore.Settings["use_default_filter"]; passwordTextBox.Enabled = parentalControlsCheckBox.Checked; parentalContolsButton.Enabled = parentalControlsCheckBox.Checked; defineCategoriesButton.Enabled = categoriesCheckBox.Checked; defaultFilterCombo.Enabled = defaultFilterCheckBox.Checked; sortFieldComboBox.Setting = MovingPicturesCore.Settings["default_sort_field"]; sortFieldComboBox.EnumType = typeof(SortingFields); clickGoesToDetails = MovingPicturesCore.Settings["click_to_details"]; dvdInsertedAction = MovingPicturesCore.Settings["on_disc_loaded"]; defaultView = MovingPicturesCore.Settings["default_view"]; // initialize filter combo to manage the default filter defaultFilterCombo.TreePanel.TranslationParser = new TranslationParserDelegate(Translation.ParseString); defaultFilterCombo.Menu = MovingPicturesCore.Settings.FilterMenu; defaultFilterCombo.SelectedNode = MovingPicturesCore.Settings.DefaultFilter; }
public bool DeleteTriggerMaintenance_ByMaintenanceValue(DBSetting dbSetting, CategoryEnum category, ActionTypeEnum actionType, string maintenanceValue) { return(TriggerMaintenanceDomain.Instance.DeleteTriggerMaintenance_ByMaintenanceValue(dbSetting, category, actionType, maintenanceValue)); }
public string GetServiceConfigureDetail(DBSetting dbSetting, SyncDataTypeEnum type) { return(MasterDomain.Instance.GetServiceConfigureDetail(dbSetting, type)); }
public bool GetRealTimeSyncStatus(DBSetting dbSetting, SyncDataTypeEnum type) { return(MasterDomain.Instance.GetRealTimeSyncStatus(dbSetting, type)); }