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));
}
