public MigrationDbRepository( ISqlHelper SqlHelper )
{
if ( SqlHelper == null ) {
throw new ArgumentNullException( "SqlHelper" );
}
this.sqlHelper = SqlHelper;
}
public SqlCmdHelper( ISqlHelper SqlHelper )
{
if ( SqlHelper == null ) {
throw new ArgumentNullException( "SqlHelper" );
}
this.sqlHelper = SqlHelper;
}
/// <summary>
/// Creates the Umbraco SQL helper.
/// </summary>
/// <returns>ISqlHelper.</returns>
public static ISqlHelper Get()
{
// If the SQL Helper provided by Umbraco has not yet been initialised,
// create and return another one. This should normally only happen when
// unit testing.
if (_sqlHelper == null)
_sqlHelper = umbraco.BusinessLogic.Application.SqlHelper ?? (UmbracoConfiguration.IsVersion6()
? DataLayerHelper.CreateSqlHelper(
ConfigurationManager.ConnectionStrings["umbracoDbDSN"].ConnectionString)
: DataLayerHelper.CreateSqlHelper(ConfigurationManager.AppSettings["umbracoDbDSN"]));
return _sqlHelper;
}
public Buddha(string connection, string root)
{
ConnectionString = connection;
WebRoot = root;
if (!Directory.Exists(WebRoot + sep + karmaDir))
Directory.CreateDirectory(WebRoot + sep + karmaDir);
_sqlhelper = DataLayerHelper.CreateSqlHelper(ConnectionString);
_config = new XmlDocument();
_config.Load(WebRoot + sep + "config" + sep + "uPowers.config");
}
public bool IsInPublishedHierarchy(int nodeId, ISqlHelper sqlHelper)
{
var parentId = sqlHelper.ExecuteScalar<int>("select parentId from [umbracoNode] where id = @nodeId",
sqlHelper.CreateParameter("nodeId", nodeId));
if (parentId == -1) return true;
else
{
var parentIsPublished =
sqlHelper.ExecuteScalar<int>("select count(*) from [cmsDocument] where nodeId = @nodeId and published = 1 ",
sqlHelper.CreateParameter("nodeId", parentId)) > 0;
if (!parentIsPublished)
return false;
else return (IsInPublishedHierarchy(parentId, sqlHelper));
}
}
internal static UserPrivilege CreateFrom(ISqlHelper sqlHelper, IDictionary <string, object> values)
{
var result =
new UserPrivilege(sqlHelper)
{
User = new Identifier(sqlHelper, values["RDB$USER"].DbValueToString()),
Grantor = new Identifier(sqlHelper, values["RDB$GRANTOR"].DbValueToString()),
Privilege = ConvertFrom(values["RDB$PRIVILEGE"].DbValueToString()),
GrantOption = values["RDB$GRANT_OPTION"].DbValueToBool().GetValueOrDefault(),
ObjectName = new Identifier(sqlHelper, values["RDB$RELATION_NAME"].DbValueToString()),
FieldName = new Identifier(sqlHelper, values["RDB$FIELD_NAME"].DbValueToString()),
UserType = new ObjectType(sqlHelper, values["RDB$USER_TYPE"].DbValueToInt32().GetValueOrDefault()),
ObjectType = new ObjectType(sqlHelper, values["RDB$OBJECT_TYPE"].DbValueToInt32().GetValueOrDefault())
};
result.IsSystemGeneratedObject = sqlHelper.HasSystemPrefix(result.ObjectName);
return(result);
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="cmdType"></param>
/// <param name="cmdText"></param>
/// <param name="spr"></param>
/// <returns></returns>
public static List <OrganizationExecuteResult> GetDataSet(CommandType cmdType, string cmdText, List <SqlParameter> spr)
{
List <OrganizationExecuteResult> result = new List <OrganizationExecuteResult>();
var organizationEntitys = new ConnectionHelper().GetOrganizationEntitys();
foreach (var organizationEntity in organizationEntitys)
{
OrganizationExecuteResult organizationExecuteResult = new OrganizationExecuteResult();
organizationExecuteResult.Code = organizationEntity.Code;
organizationExecuteResult.Name = organizationEntity.Name;
ISqlHelper sqlHelper = SqlConvertHelper.GetInstallSqlHelper(organizationEntity.Connectionstring);
organizationExecuteResult.Data = sqlHelper.GetDataSet(cmdType, cmdText, spr);
result.Add(organizationExecuteResult);
}
return(result);
}
/// <summary>
/// 不带参数的操作语句
/// </summary>
/// <param name="cmdText"></param>
/// <returns></returns>
public static List <Dictionary <string, object> > ExecuteNonQuery(string cmdText)
{
List <Dictionary <string, object> > resDics = new List <Dictionary <string, object> >();
var connDics = new ConnectionHelper().GetOrgConnDic();
foreach (var dic in connDics)
{
Dictionary <string, object> resDic = new Dictionary <string, object>();
resDic["code"] = dic["code"];
resDic["name"] = dic["name"];
ISqlHelper sqlHelper = SqlConvertHelper.GetInstallSqlHelper(dic["connectionstring"]);
resDic["data"] = sqlHelper.ExecuteNonQuery(cmdText);
resDics.Add(resDic);
}
return(resDics);
}
internal static ViewRelation CreateFrom(ISqlHelper sqlHelper, IDictionary <string, object> values)
{
var result =
new ViewRelation(sqlHelper)
{
ViewName = new Identifier(sqlHelper, values["RDB$VIEW_NAME"].DbValueToString()),
ViewContextName = new Identifier(sqlHelper, values["RDB$RELATION_NAME"].DbValueToString()),
ViewContext = values["RDB$VIEW_CONTEXT"].DbValueToInt32().GetValueOrDefault(),
ContextName = values["RDB$CONTEXT_NAME"].DbValueToString()
};
if (sqlHelper.TargetVersion.AtLeast(TargetVersion.Version30))
{
result.ContextType = (ContextTypeType)values["RDB$CONTEXT_TYPE"].DbValueToInt32().GetValueOrDefault();
result.PackageName = new Identifier(sqlHelper, values["RDB$PACKAGE_NAME"].DbValueToString());
}
return(result);
}
internal static DbException CreateFrom(ISqlHelper sqlHelper, IDictionary <string, object> values)
{
var result =
new DbException(sqlHelper)
{
ExceptionName = new Identifier(sqlHelper, values["RDB$EXCEPTION_NAME"].DbValueToString()),
ExceptionNumber = values["RDB$EXCEPTION_NUMBER"].DbValueToInt32().GetValueOrDefault(),
Message = values["RDB$MESSAGE"].DbValueToString(),
Description = values["RDB$DESCRIPTION"].DbValueToString(),
SystemFlag = (SystemFlagType)values["RDB$SYSTEM_FLAG"].DbValueToInt32().GetValueOrDefault()
};
if (sqlHelper.TargetVersion.AtLeast(TargetVersion.Version30))
{
result.OwnerName = new Identifier(sqlHelper, values["RDB$OWNER_NAME"].DbValueToString());
}
return(result);
}
public bool UpdateInvestmentTrust(string NO, string NAME, string IDNO)
{
string SQL = "UPDATE AMD..tblInvestmentTrust SET NAME = @NAME, IDNO = @IDNO WHERE NO = @NO";
var p = new DynamicParameters();
p.Add("@NO", NO);
p.Add("@NAME", NAME);
p.Add("@IDNO", IDNO);
ISqlHelper sqlHelper = SQLHelper.GetInstance("Dapper", Configurations.AMDConnectionString);
sqlHelper.Open();
bool result = sqlHelper.Execute(SQL, 1, (dynamic)p);
sqlHelper.Close();
return(result);
}
public static void GetGuangfuTest(Item item)
{
ISqlHelper sqlHelper = SqlHelperFactory.Create(DbType.MSSQL, item.ConnectionString);
string sql =
string.Format(
@"Select [{0}] as orginDatas from [{1}] where SensorId ={2} and [CollectTime]>'2015-01-13 00:13:08.000' order by [CollectTime] ",
item.FiledName, item.TableName, item.SensorId);
sqlHelper.ExecuteSql(sql);
var dt = sqlHelper.Query(sql).Tables[0];
var workbook = new Workbook();
var worksheet = workbook.Worksheets[0];
worksheet.Name = item.ToString();
var cells = worksheet.Cells;
var j = 1; //column
var z = 0;
cells[0, 0].PutValue("基点2");
const decimal firstValue = 5.4055m;
foreach (DataRow row in dt.Rows)
{
z++;
var value = new AnalysisValue((Convert.ToDecimal(row[0]) - firstValue) * 100);
cells[z, 0].PutValue(value.RawValue);
}
foreach (var config in item.Configs)
{
var k = 1; //row
var window = new ValidateWindow(config);
foreach (DataRow row in dt.Rows)
{
var value = new AnalysisValue((Convert.ToDecimal(row[0]) - firstValue) * 100);
window.ProcessValue(value);
cells[k, j].PutValue(value.ValidValue);
k++;
}
cells[0, j].PutValue(config.ToString());
j++;
}
workbook.Save(item.ToString() + ".xls");
}
public CollectionsService(
ICollectionsRepository collectionsRepository,
IArtifactRepository artifactRepository,
ILockArtifactsRepository lockArtifactsRepository,
IItemInfoRepository itemInfoRepository,
IArtifactPermissionsRepository artifactPermissionsRepository,
ISqlHelper sqlHelper,
ISearchEngineService searchEngineService,
IArtifactListService artifactListService)
{
_collectionsRepository = collectionsRepository;
_artifactRepository = artifactRepository;
_lockArtifactsRepository = lockArtifactsRepository;
_itemInfoRepository = itemInfoRepository;
_artifactPermissionsRepository = artifactPermissionsRepository;
_sqlHelper = sqlHelper;
_searchEngineService = searchEngineService;
_artifactListService = artifactListService;
}
internal static Generator CreateFrom(ISqlHelper sqlHelper, IDictionary <string, object> values)
{
var result =
new Generator(sqlHelper)
{
GeneratorName = new Identifier(sqlHelper, values["RDB$GENERATOR_NAME"].DbValueToString()),
GeneratorId = values["RDB$GENERATOR_ID"].DbValueToInt32().GetValueOrDefault(),
SystemFlag = (SystemFlagType)values["RDB$SYSTEM_FLAG"].DbValueToInt32().GetValueOrDefault(),
Description = values["RDB$DESCRIPTION"].DbValueToString(),
};
if (sqlHelper.TargetVersion.AtLeast30())
{
result.OwnerName = new Identifier(sqlHelper, values["RDB$OWNER_NAME"].DbValueToString());
result.InitialValue = values["RDB$INITIAL_VALUE"].DbValueToInt64();
result.GeneratorIncrement = values["RDB$GENERATOR_INCREMENT"].DbValueToInt32();
}
return(result);
}
public OrionCoreNotificationSubscriber(
ISqlHelper sqlHelper,
ISubscriptionManager subscriptionManager)
{
ISqlHelper isqlHelper = sqlHelper;
if (isqlHelper == null)
{
throw new ArgumentNullException(nameof(sqlHelper));
}
this._sqlHelper = isqlHelper;
ISubscriptionManager isubscriptionManager = subscriptionManager;
if (isubscriptionManager == null)
{
throw new ArgumentNullException(nameof(subscriptionManager));
}
this._subscriptionManager = isubscriptionManager;
}
public RollupModeChangedSubscriber(
ISubscriptionManager subscriptionManager,
ISqlHelper sqlHelper)
{
ISubscriptionManager isubscriptionManager = subscriptionManager;
if (isubscriptionManager == null)
{
throw new ArgumentNullException(nameof(subscriptionManager));
}
this.subscriptionManager = isubscriptionManager;
ISqlHelper isqlHelper = sqlHelper;
if (isqlHelper == null)
{
throw new ArgumentNullException(nameof(sqlHelper));
}
this.sqlHelper = isqlHelper;
}
public LoginViewModel(
ISqlHelper sqlHelper,
LogOnEvent logOnEvent,
IValidateHelper validate,
IFaceitApi api,
UserModel user,
IMapper mapper,
IMapperHelper mapperHelper,
FaceitUserModel faceitUser)
{
_sqlHelper = sqlHelper;
_logOnEvent = logOnEvent;
_validate = validate;
_api = api;
_user = user;
_mapper = mapper;
_faceitUser = faceitUser;
_mapperHelper = mapperHelper;
}
public EnhancedNodeStatusCalculationSubscriber(
ISubscriptionManager subscriptionManager,
ISqlHelper sqlHelper)
{
ISubscriptionManager isubscriptionManager = subscriptionManager;
if (isubscriptionManager == null)
{
throw new ArgumentNullException(nameof(subscriptionManager));
}
this.subscriptionManager = isubscriptionManager;
ISqlHelper isqlHelper = sqlHelper;
if (isqlHelper == null)
{
throw new ArgumentNullException(nameof(sqlHelper));
}
this.sqlHelper = isqlHelper;
}
public static bool Save(User user)
{
ISqlHelper sql_helper = SqlHelperFactory.GetDefaultSqlHelper();
return(false);
//string sql = string.Format("insert into mdtbl_user (u_id, d_id, role_id, u_name, u_login_name, " +
// "u_password, u_status) values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')",
// user.ID, user.Department.ID, user.Role.ID, user.Name, user.LoginName, user.Password, (int)user.State);
//try
//{
// sql_helper.ExecuteNonQuery(sql);
// return true;
//}
//catch
//{
// return false;
//}
}
public void LoadDocTypesTest_CreateDocType()
{
ISqlHelper fakeSql = Isolate.Fake.Instance <ISqlHelper>(Members.CallOriginal);
IRecordsReader fakeReader = Isolate.Fake.Instance <IRecordsReader>();
var dtGuid = Guid.NewGuid();
//get the data for the DT
Isolate.WhenCalled(() => fakeReader.HasRecords).WillReturn(true);
Isolate.WhenCalled(() => fakeReader.Read()).WillReturn(true);
Isolate.WhenCalled(() => fakeReader.Read()).CallOriginal();
Isolate.WhenCalled(() => fakeReader.GetId()).WillReturn(1);
Isolate.WhenCalled(() => fakeReader.GetName()).WillReturn("Name");
Isolate.WhenCalled(() => fakeReader.GetDescription()).WillReturn("Description");
Isolate.WhenCalled(() => fakeReader.GetAlias()).WillReturn("Alias");
Isolate.WhenCalled(() => fakeReader.GetParentId()).WillReturn(-1);
Isolate.WhenCalled(() => fakeSql.ExecuteReader(string.Empty)).WillReturn(fakeReader);
DocTypeObjectBuilder target = new DocTypeObjectBuilder(string.Empty);
Isolate.WhenCalled(() => target.SqlHelper).WillReturn(fakeSql);
target.LoadDocTypes();
Assert.IsNotNull(target.DocumentTypes);
Assert.AreEqual(target.DocumentTypes.Count, 1);
Isolate.Verify.WasCalledWithExactArguments(() => target.BuildDocumentType(fakeReader));
Isolate.Verify.WasCalledWithExactArguments(() => fakeReader.GetAlias());
Isolate.Verify.WasCalledWithExactArguments(() => fakeReader.GetParentId());
Isolate.Verify.WasCalledWithExactArguments(() => fakeReader.GetDescription());
Isolate.Verify.WasCalledWithExactArguments(() => fakeReader.GetName());
Isolate.Verify.WasCalledWithExactArguments(() => fakeReader.GetId());
var dt = target.DocumentTypes[0];
Assert.AreEqual("Alias", dt.Alias);
Assert.AreEqual("Description", dt.Description);
Assert.AreEqual(1, dt.Id);
Assert.AreEqual("Name", dt.Name);
Assert.AreEqual(-1, dt.ParentId);
Assert.AreEqual(0, dt.Properties.Count);
}
/// <summary>
/// Retrieve HTML from the database cache for the given node
/// </summary>
/// <param name="nodeId">Id of the node</param>
/// <param name="fullHtml">string to fill with HTML</param>
/// <returns>bool indicating success/failure</returns>
public static bool GetRecord(int nodeId, out string fullHtml)
{
fullHtml = "";
if (nodeId < 1)
{
return(false);
}
var success = false;
ISqlHelper sqlHelper = null;
IRecordsReader result = null;
try
{
const string sqlQuery = "SELECT fullHTML FROM fullTextCache WHERE nodeId = @nodeId";
sqlHelper = DataLayerHelper.CreateSqlHelper(global::Umbraco.Core.ApplicationContext.Current.DatabaseContext.ConnectionString);
result = sqlHelper.ExecuteReader(sqlQuery, sqlHelper.CreateParameter("@nodeId", nodeId));
if (result != null && result.HasRecords && result.Read() && result.ContainsField("fullHTML"))
{
fullHtml = result.GetString("fullHTML");
success = true;
}
}
catch (umbraco.UmbracoException ex)
{
LogHelper.Error(typeof(DbAccess), "Error In Database Query to fullTextCache", ex);
fullHtml = "";
}
finally
{
if (result != null)
{
result.Close();
}
if (sqlHelper != null)
{
sqlHelper.Dispose();
}
}
return(success);
}
internal static CharacterSet CreateFrom(ISqlHelper sqlHelper, IDictionary <string, object> values)
{
var result =
new CharacterSet(sqlHelper)
{
CharacterSetName = new Identifier(sqlHelper, values["RDB$CHARACTER_SET_NAME"].DbValueToString()),
NumberOfCharacters = values["RDB$NUMBER_OF_CHARACTERS"].DbValueToInt32(),
DefaultCollateName = new Identifier(sqlHelper, values["RDB$DEFAULT_COLLATE_NAME"].DbValueToString()),
CharacterSetId = values["RDB$CHARACTER_SET_ID"].DbValueToInt32().GetValueOrDefault(),
SystemFlag = (SystemFlagType)values["RDB$SYSTEM_FLAG"].DbValueToInt32().GetValueOrDefault(),
Description = values["RDB$DESCRIPTION"].DbValueToString(),
BytesPerCharacter = values["RDB$BYTES_PER_CHARACTER"].DbValueToInt32().GetValueOrDefault()
};
if (sqlHelper.TargetVersion.AtLeast(TargetVersion.Version30))
{
result.OwnerName = new Identifier(sqlHelper, values["RDB$OWNER_NAME"].DbValueToString());
}
return(result);
}
internal static Relation CreateFrom(ISqlHelper sqlHelper, IDictionary <string, object> values, ILookup <Identifier, RelationField> relationFields)
{
var result =
new Relation(sqlHelper)
{
RelationId = values["RDB$RELATION_ID"].DbValueToInt32().GetValueOrDefault(),
MetadataRelationType = (MetadataRelationType)values["RDB$RELATION_TYPE"].DbValueToInt32().GetValueOrDefault(),
RelationName = new Identifier(sqlHelper, values["RDB$RELATION_NAME"].DbValueToString()),
Description = values["RDB$DESCRIPTION"].DbValueToString(),
ViewSource = values["RDB$VIEW_SOURCE"].DbValueToString(),
ExternalFile = values["RDB$EXTERNAL_FILE"].DbValueToString(),
ExternalDescription = values["RDB$EXTERNAL_DESCRIPTION"].DbValueToString(),
OwnerName = values["RDB$OWNER_NAME"].DbValueToString(),
SystemFlag = (SystemFlagType)values["RDB$SYSTEM_FLAG"].DbValueToInt32().GetValueOrDefault()
};
result.Fields = relationFields[result.RelationName].ToArray();
return(result);
}
internal static List <UrlTrackerDomain> GetDomains()
{
if (_urlTrackerDomains == null)
{
lock (_locker)
{
_urlTrackerDomains = new List <UrlTrackerDomain>();
ISqlHelper sqlHelper = Application.SqlHelper;
using (var dr = sqlHelper.ExecuteReader("SELECT * FROM umbracoDomains where CHARINDEX('*',domainName) < 1"))
{
while (dr.Read())
{
_urlTrackerDomains.Add(new UrlTrackerDomain(dr.GetInt("id"), dr.GetInt("domainRootStructureID"), dr.GetString("domainName")));
}
}
_urlTrackerDomains = _urlTrackerDomains.OrderBy(x => x.Node.SortOrder).ThenBy(x => x.UrlWithDomain).ToList();
}
}
return(_urlTrackerDomains);
}
internal static Index CreateFrom(ISqlHelper sqlHelper, IDictionary <string, object> values, ILookup <Identifier, IndexSegment> indexSegments)
{
var result =
new Index(sqlHelper)
{
IndexName = new Identifier(sqlHelper, values["RDB$INDEX_NAME"].DbValueToString()),
RelationName = new Identifier(sqlHelper, values["RDB$RELATION_NAME"].DbValueToString()),
Unique = values["RDB$UNIQUE_FLAG"].DbValueToBool().GetValueOrDefault(),
Description = values["RDB$DESCRIPTION"].DbValueToString(),
SegmentCount = values["RDB$SEGMENT_COUNT"].DbValueToInt32(),
Inactive = values["RDB$INDEX_INACTIVE"].DbValueToBool().GetValueOrDefault(),
Descending = values["RDB$INDEX_TYPE"].DbValueToBool().GetValueOrDefault(),
ForeignKey = new Identifier(sqlHelper, values["RDB$FOREIGN_KEY"].DbValueToString()),
ExpressionSource = values["RDB$EXPRESSION_SOURCE"].DbValueToString(),
SystemFlag = (SystemFlagType)values["RDB$SYSTEM_FLAG"].DbValueToInt32().GetValueOrDefault()
};
result.Segments = indexSegments[result.IndexName].OrderBy(s => s.FieldPosition).ToArray();
return(result);
}
private ISqlHelper GetConnectionStr(int type, ref string conn, ref string sql)
{
ISqlHelper sqlHelper = null;
var radio = this.pDbType.Controls.OfType <RadioButton>().FirstOrDefault(r => r.Checked);
switch (radio.Text)
{
case Data.XmlMysql:
sqlHelper = new MySqlHelper();
conn = "Server=" + this.cmboxServer.Text.Trim() + ";Database=" +
this.cmboxDatabase.Text.Trim() + ";Uid=" + this.txtUserId.Text.Trim() + ";Pwd=" +
this.txtPassword.Text + ";charset=utf8;Port=" + this.txtPort.Text.Trim();
sql = " SELECT schema_name FROM INFORMATION_SCHEMA.SCHEMATA order by schema_name ";
break;
case Data.XmlSqlServer:
sqlHelper = new SqlServerHelper();
conn = string.Empty;
conn += "Server=" + this.cmboxServer.Text.Trim();
if (!string.IsNullOrEmpty(this.txtPort.Text.Trim()))
{
conn += ",";
}
conn += (this.cmboxServer.Text.Contains(",") ? "" : this.txtPort.Text.Trim()) + ";";
conn += "Initial Catalog=" + this.cmboxDatabase.Text.Trim() + ";";
conn += "User ID=" + this.txtUserId.Text.Trim() + ";Password="******" SELECT name FROM sys.databases order by name ";
break;
case Data.XmlOracle:
sqlHelper = new OracleHelper();
conn = string.Empty;
conn += "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=" + this.cmboxServer.Text.Trim() + ")";
conn += "(PORT=" + this.txtPort.Text.Trim() + "))";
conn += "(CONNECT_DATA=(SERVICE_NAME=" + this.cmboxDatabase.Text.Trim() + ")));";
conn += "USER ID=" + this.txtUserId.Text.Trim() + ";PASSWORD="******" SELECT NAME FROM v$database; ";
break;
}
return(sqlHelper);
}
public static void ProcessItem(Item item)
{
ISqlHelper sqlHelper = SqlHelperFactory.Create(DbType.MSSQL, item.ConnectionString);
string sql =
string.Format(
@"Select [{0}] as orginDatas from [{1}] where SENSOR_ID ={2} and [ACQUISITION_DATETIME]>'2014-12-24 22:36:00.000' order by [ACQUISITION_DATETIME] ",
item.FiledName, item.TableName, item.SensorId);
sqlHelper.ExecuteSql(sql);
var dt = sqlHelper.Query(sql).Tables[0];
var workbook = new Workbook();
var worksheet = workbook.Worksheets[0];
worksheet.Name = item.ToString();
var cells = worksheet.Cells;
var j = 1; //column
var z = 0;
cells[0, 0].PutValue("orgin");
foreach (DataRow row in dt.Rows)
{
z++;
var value = new AnalysisValue(Convert.ToDecimal(row[0]));
cells[z, 0].PutValue(value.RawValue);
}
foreach (var config in item.Configs)
{
var k = 1; //row
var window = new ValidateWindow(config);
foreach (DataRow row in dt.Rows)
{
var value = new AnalysisValue(Convert.ToDecimal(row[0]));
window.ProcessValue(value);
cells[k, j].PutValue(value.ValidValue);
k++;
}
cells[0, j].PutValue(config.ToString());
j++;
}
workbook.Save(item.ToString() + ".xls");
}
public static Package CreateFrom(ISqlHelper sqlHelper, IDictionary <string, object> values)
{
var result =
new Package(sqlHelper)
{
PackageName = new Identifier(sqlHelper, values["RDB$PACKAGE_NAME"].DbValueToString()),
PackageHeaderSource = values["RDB$PACKAGE_HEADER_SOURCE"].DbValueToString(),
PackageBodySource = values["RDB$PACKAGE_BODY_SOURCE"].DbValueToString(),
ValidBodyFlag = values["RDB$VALID_BODY_FLAG"].DbValueToFlag(),
OwnerName = new Identifier(sqlHelper, values["RDB$OWNER_NAME"].DbValueToString()),
SystemFlag = (SystemFlagType)values["RDB$SYSTEM_FLAG"].DbValueToInt32().GetValueOrDefault(),
Description = values["RDB$DESCRIPTION"].DbValueToString()
};
if (sqlHelper.TargetVersion.AtLeast(TargetVersion.Version40))
{
result.SqlSecurity = values["RDB$SQL_SECURITY"].DbValueToBool();
}
return(result);
}
internal UsersController
(
IAuthenticationRepository authenticationRepository, IUserRepository userRepository,
ISqlSettingsRepository settingsRepository, IEmailHelper emailHelper,
IApplicationSettingsRepository applicationSettingsRepository, IServiceLogRepository log,
IHttpClientProvider httpClientProvider, IPrivilegesRepository privilegesRepository,
IItemInfoRepository itemInfoRepository, ISendMessageExecutor sendMessageExecutor, IImageService imageService, ISqlHelper sqlHelper)
{
_authenticationRepository = authenticationRepository;
_userRepository = userRepository;
_settingsRepository = settingsRepository;
_emailHelper = emailHelper;
_applicationSettingsRepository = applicationSettingsRepository;
_log = log;
_httpClientProvider = httpClientProvider;
_privilegesManager = new PrivilegesManager(privilegesRepository);
_itemInfoRepository = itemInfoRepository;
_sendMessageExecutor = sendMessageExecutor;
_imageService = imageService;
_sqlHelper = sqlHelper;
}
public Boolean IsInUse()
{
ISqlHelper sqlHelper = Helper.SqlHelper;
string sql = "Select 1 from UFfields where PreValueProvider = @id;";
IRecordsReader rr = sqlHelper.ExecuteReader(sql,
sqlHelper.CreateParameter("@id", Id));
bool inuse = false;
if (rr.Read())
{
inuse = true;
}
rr.Dispose();
return(inuse);
}
static SqlHelper()
{
switch (ConfigHelper.ConfigHelper.DBConfigModal.CurrentDbType)
{
case DBType.SqlServer:
IHelper = new SqlServerHelper();
break;
case DBType.Oracle:
IHelper = new OracleHelper();
break;
case DBType.MySql:
IHelper = new MySqlHelper();
break;
case DBType.Access:
IHelper = new AccessHelper();
break;
}
}
public static List <Role> GetRoleCollection()
{
ISqlHelper sql_helper = SqlHelperFactory.GetDefaultSqlHelper();
string sql = "select * from mdtbl_role";
DataTable dt = sql_helper.ExecuteDataTable(sql);
List <Role> role_list = new List <Role>();
foreach (DataRow row in dt.Rows)
{
Role item = new Role()
{
RoleId = row[0].ToString(),
RoleName = row[1].ToString(),
RoleDescription = row[2].ToString()
};
role_list.Add(item);
}
return(role_list);
}
internal static Collation CreateFrom(ISqlHelper sqlHelper, IDictionary <string, object> values)
{
var result =
new Collation(sqlHelper)
{
CollationName = new Identifier(sqlHelper, values["RDB$COLLATION_NAME"].DbValueToString()),
CollationId = values["RDB$COLLATION_ID"].DbValueToInt32().GetValueOrDefault(),
CharacterSetId = values["RDB$CHARACTER_SET_ID"].DbValueToInt32().GetValueOrDefault(),
CollationAttributes = (CollationAttributes?)values["RDB$COLLATION_ATTRIBUTES"].DbValueToInt32(),
SystemFlag = (SystemFlagType)values["RDB$SYSTEM_FLAG"].DbValueToInt32().GetValueOrDefault(),
Description = values["RDB$DESCRIPTION"].DbValueToString(),
FunctionName = values["RDB$FUNCTION_NAME"].DbValueToString(),
BaseCollationName = new Identifier(sqlHelper, values["RDB$BASE_COLLATION_NAME"].DbValueToString()),
SpecificAttributes = values["RDB$SPECIFIC_ATTRIBUTES"].DbValueToString()
};
if (sqlHelper.TargetVersion.AtLeast30())
{
result.OwnerName = new Identifier(sqlHelper, values["RDB$OWNER_NAME"].DbValueToString());
}
return(result);
}
private List <MenuMapModel> GetMenu(string Url)
{
var MainUrl = Url.Substring(0, Url.LastIndexOf("/"));
var result = new StringBuilder();
var ListSiteMap = new List <MenuMapModel>();
string query = @"
IF EXISTS(SELECT LevelTree FROM SYSDATA..SMSiteMap WITH(NOLOCK) WHERE LevelTree like '%4034%' AND SiteMapURL like @SiteMapURL)
BEGIN
SELECT LevelTree FROM SYSDATA..SMSiteMap WITH(NOLOCK) WHERE LevelTree like '%4034%' AND SiteMapURL like @SiteMapURL
END
ELSE
BEGIN
SELECT LevelTree FROM SYSDATA..SMSiteMap WITH(NOLOCK) WHERE LevelTree like '%4034%' AND SiteMapURL like @SiteMapMainUrl
END";
var p = new DynamicParameters();
p.Add("@SiteMapURL", "%" + Url + "%");
p.Add("@SiteMapMainUrl", "%" + MainUrl + "%");
ISqlHelper sqlHelper = SQLHelper.GetInstance("Dapper", _configurations.SYSDATAConnectionString);
var data = sqlHelper.Query <string>(query, 1, p).FirstOrDefault();
var ListNode = data.Trim(';').Split(";");
ListNode = ListNode.Skip <string>(1).ToArray();
foreach (var SiteMapID in ListNode)
{
query = @"
SELECT SiteMapName,SiteMapURL,SiteMapID
FROM SYSDATA..SMSiteMap WITH(NOLOCK)
WHERE SiteMapID = @SiteMapID";
p = new DynamicParameters();
p.Add("@SiteMapID", SiteMapID);
var model = sqlHelper.Query <MenuMapModel>(query, 1, p).FirstOrDefault();
ListSiteMap.Add(model);
}
sqlHelper.Close();
return(ListSiteMap);
}
public static ISqlHelper Connect(string connection)
{
if (_sqlHelper == null)
{
try
{
if (ConfigurationManager.ConnectionStrings["umbracoDbDSN"] != null)
{
var prov = (ISqlHelperCreator)Activator.CreateInstance(Type.GetType("Umbraco.Forms.Core.Providers.V6SqlHelperCreator, Umbraco.Forms.Core"));
_sqlHelper = prov.Create(connection);
}
else
{
var prov = (ISqlHelperCreator)Activator.CreateInstance(Type.GetType("Umbraco.Forms.Core.Providers.V4SqlHelperCreator, Umbraco.Forms.Core"));
_sqlHelper = prov.Create(connection);
}
}
catch { }
}
return(_sqlHelper);
}
/// <summary>
/// Called when ExecuteNonQuery is executed.
/// </summary>
/// <param name="sqlHelper">The SQL helper.</param>
/// <param name="commandText">The command text.</param>
/// <param name="parameters">The SQL parameters.</param>
public override void OnExecuteNonQuery(ISqlHelper sqlHelper, ref string commandText, ref IParameter[] parameters)
{
AppendToLog(sqlHelper, commandText, parameters);
}
/// <summary>
/// Appends a command to the log stream.
/// </summary>
/// <param name="sqlHelper">The SQL helper executing the command.</param>
/// <param name="commandText">The command text.</param>
/// <param name="parameters">The parameters.</param>
private void AppendToLog(ISqlHelper sqlHelper, string commandText, IParameter[] parameters)
{
m_LogStream.WriteLine(LogLineFormat,
DateTime.Now,
new StackFrame(1).GetMethod().Name,
m_SqlParser.ApplyParameters(commandText, parameters));
m_LogStream.Flush();
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlMaterialService"/> class.
/// </summary>
/// <param name="connectionString">The connection string.</param>
private SqlMaterialService(string connectionString)
{
sqlHelper = new SqlHelper(connectionString, "Materials Service");
}
public SqlSmsService(string connectionString)
{
sqlHelper = new SqlHelper(connectionString);
}
public static void AddHelper(string dbType, ISqlHelper helper)
{
helperList[dbType] = helper;
}
public void Dispose()
{
_config = null;
_sqlhelper.Dispose();
_sqlhelper = null;
}
public PlayerRepository(ISqlHelper sqlHelper)
{
this._sqlHelper = sqlHelper;
}
/// <summary>
/// Called when ExecuteNonQuery is executed.
/// </summary>
/// <param name="sqlHelper">The SQL helper.</param>
/// <param name="commandText">The command text.</param>
/// <param name="parameters">The SQL parameters.</param>
public virtual void OnExecuteNonQuery(ISqlHelper sqlHelper, ref string commandText, ref IParameter[] parameters)
{}
public void ResetDI()
{
// FRAGILE: There's no way to undo the ServiceLocator: ServiceLocator.Initialize( null );
this.SqlHelper = null;
this.transaction.Dispose(); // Don't persist data changed during tests
// TODO: Reseed tables changed during tests
}
/// <summary>
/// Called when ExecuteXmlReader is executed.
/// </summary>
/// <param name="sqlHelper">The SQL helper.</param>
/// <param name="commandText">The command text.</param>
/// <param name="parameters">The SQL parameters.</param>
public virtual void OnExecuteXmlReader(ISqlHelper sqlHelper, ref string commandText, ref IParameter[] parameters)
{}
