private void TableComboBox_DropDownOpened(object sender, EventArgs e)
{
var helper = new SqlDbHelper(ConnectionStringTextBox.Text);
var provider = new SqlServerProvider(helper);
var tables = provider.GetTableSchemas();
TableComboBox.ItemsSource = tables.OrderBy(x => x.Name);
}
public JsonResult Connect(string server, string userName, string password)
{
return ExecuteCommand(
() =>
{
IDatabaseProvider db = new SqlServerProvider();
db.Initialize(server, userName, password);
string serverName = db.GetServerName();
DatabaseProvider = db;
return serverName;
}
);
}
private void TableComboBox_DropDownOpened(object sender, EventArgs e)
{
if (_tables != null
&& _tables.Count() > 0
&& !String.IsNullOrEmpty(_connectionString)
&& !String.IsNullOrEmpty(ConnectionStringTextBox.Text)
&& _connectionString.Equals(ConnectionStringTextBox.Text))
{
TableComboBox.ItemsSource = _tables;
return;
}
var helper = new SqlDbHelper(ConnectionStringTextBox.Text);
var provider = new SqlServerProvider(helper);
var tables = provider.GetTableSchemas();
_tables = tables.OrderBy(x => x.Name);
TableComboBox.ItemsSource = _tables;
}
public static IDbProvider CreateProvider(string providerName)
{
IDbProvider provider = new SqlServerProvider(); //如果连接字符中为设置ProviderName,则默认指定使用SQL数据库
var assembly = Assembly.GetAssembly(typeof(IDbProvider));
var types = assembly.GetTypes();
types.ForEach(t =>
{
if (t.GetInterface("IDbProvider", true) != null
&& t.GetProperty("ProviderName") != null
&& t.GetProperty("ProviderName").GetValue(null, null).ToString() == providerName)
{
provider = assembly.CreateInstance(t.FullName) as IDbProvider;
}
});
return provider;
}
public void AddProviderConfiguration(string name, string connectionString, string providerName, int commandTimeout = 60)
{
if (string.IsNullOrWhiteSpace(name))
{
throw new ArgumentNullException("name");
}
if (string.IsNullOrWhiteSpace(connectionString))
{
throw new ArgumentNullException("connectionString");
}
if (commandTimeout < 0)
{
throw new ArgumentOutOfRangeException("commandTimeout");
}
name = name.Trim();
connectionString = connectionString.Trim();
providerName = (providerName ?? string.Empty).Trim();
if (string.IsNullOrWhiteSpace(providerName))
{
DatabaseProvider strategy = new SqlServerProvider();
strategy.Database.ConnectionString = connectionString;
strategy.Database.Command.CommandTimeout = commandTimeout;
this._databaseStrategies.Add(name, strategy);
}
else
{
if (!providerName.Contains(','))
{
providerName += "," + typeof(DbProviderCache).Assembly.FullName;
}
DatabaseProvider strategy = TypeExtension.CreateInstance<DatabaseProvider>(providerName);
strategy.Database.ConnectionString = connectionString;
strategy.Database.Command.CommandTimeout = commandTimeout < 0 ? COMMAND_TIMEOUT : commandTimeout;
this._databaseStrategies.Add(name, strategy);
}
}
public StoreAggregatorContextFactory()
{
_databaseProvider = new SqlServerProvider();
}
public void common_escaping()
{
Assert.Equal("[mytable]", SqlServerProvider.EscapeIdentifier("mytable"));
Assert.Equal("[my table]", SqlServerProvider.EscapeIdentifier("my table"));
}
public RolePermissionRepository(SqlServerProvider provider, OperateInfo info)
: base(provider, info)
{
}
public SqlServerDataProvider(string name, SqlServerVersion version, SqlServerProvider provider)
: base(
name,
MappingSchemaInstance.Get(version),
SqlServerProviderAdapter.GetInstance(provider))
{
Version = version;
Provider = provider;
SqlProviderFlags.IsDistinctOrderBySupported = false;
SqlProviderFlags.IsSubQueryOrderBySupported = false;
SqlProviderFlags.IsDistinctSetOperationsSupported = true;
SqlProviderFlags.IsCountDistinctSupported = true;
SqlProviderFlags.IsUpdateFromSupported = true;
if (version == SqlServerVersion.v2000)
{
SqlProviderFlags.AcceptsTakeAsParameter = false;
SqlProviderFlags.IsSkipSupported = false;
SqlProviderFlags.IsCountSubQuerySupported = false;
}
else
{
SqlProviderFlags.IsApplyJoinSupported = true;
SqlProviderFlags.TakeHintsSupported = TakeHints.Percent | TakeHints.WithTies;
SqlProviderFlags.IsCommonTableExpressionsSupported = version >= SqlServerVersion.v2008;
}
SetCharField("char", (r, i) => r.GetString(i).TrimEnd(' '));
SetCharField("nchar", (r, i) => r.GetString(i).TrimEnd(' '));
SetCharFieldToType <char>("char", DataTools.GetCharExpression);
SetCharFieldToType <char>("nchar", DataTools.GetCharExpression);
_sqlOptimizer = version switch
{
SqlServerVersion.v2000 => new SqlServer2000SqlOptimizer(SqlProviderFlags),
SqlServerVersion.v2005 => new SqlServer2005SqlOptimizer(SqlProviderFlags),
SqlServerVersion.v2012 => new SqlServer2012SqlOptimizer(SqlProviderFlags),
SqlServerVersion.v2017 => new SqlServer2017SqlOptimizer(SqlProviderFlags),
_ => new SqlServer2008SqlOptimizer(SqlProviderFlags),
};
// missing:
// GetSqlBytes
// GetSqlChars
SetProviderField <SqlBinary, SqlBinary>(SqlTypes.GetSqlBinaryReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlBoolean, SqlBoolean>(SqlTypes.GetSqlBooleanReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlByte, SqlByte>(SqlTypes.GetSqlByteReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlDateTime, SqlDateTime>(SqlTypes.GetSqlDateTimeReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlDecimal, SqlDecimal>(SqlTypes.GetSqlDecimalReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlDouble, SqlDouble>(SqlTypes.GetSqlDoubleReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlGuid, SqlGuid>(SqlTypes.GetSqlGuidReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlInt16, SqlInt16>(SqlTypes.GetSqlInt16ReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlInt32, SqlInt32>(SqlTypes.GetSqlInt32ReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlInt64, SqlInt64>(SqlTypes.GetSqlInt64ReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlMoney, SqlMoney>(SqlTypes.GetSqlMoneyReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlSingle, SqlSingle>(SqlTypes.GetSqlSingleReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlString, SqlString>(SqlTypes.GetSqlStringReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <SqlXml, SqlXml>(Adapter.GetSqlXmlReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <DateTimeOffset>(Adapter.GetDateTimeOffsetReaderMethod, dataReaderType: Adapter.DataReaderType);
SetProviderField <TimeSpan> (Adapter.GetTimeSpanReaderMethod, dataReaderType: Adapter.DataReaderType);
// non-specific fallback
SetProviderField <IDataReader, SqlString, SqlString>((r, i) => r.GetString(i));
SqlServerTypes.Configure(this);
}
protected override string Escape(string name)
{
return(SqlServerProvider.EscapeIdentifier(name));
}
protected override string FormatName(string s)
{
return(SqlServerProvider.EscapeIdentifier(s));
}
protected Service(Service service)
{
this.Provider = service?.GetProvider() ?? DapperProvider.GetProvider(DapperProvider.GetConnString());
}
public RoleMenuRepository(SqlServerProvider provider, OperateInfo info)
: base(provider, info)
{
}
public void ProcessRequest(HttpContext context)
{
YZAuthHelper.OAuth();
//YZAuthHelper.AshxAuthCheck();
//GridPageInfo gridPageInfo = new GridPageInfo(context);
//IDBProvider dbProvider = YZDBProviderManager.CurrentProvider;
int rowcount = 0;
//获得数据
BPMTaskCollection tasks = new BPMTaskCollection();
JsonItem rootItem = new JsonItem();
using (BPMConnection cn = new BPMConnection())
{
cn.WebOpen();
String UserID = context.Request.Params["UserID"];
String Phone = context.Request.Params["Phone"];
//User user = User.FromAccount(cn, UserID);
//YZAuthHelper.SetAuthCookie(realAccount);
//YZAuthHelper.GetCookie();
//将数据转化为Json集合
rootItem.Attributes.Add(JsonItem.TotalRows, rowcount);
JsonItemCollection children = new JsonItemCollection();
rootItem.Attributes.Add("children", children);
int index = 0;
if (Phone == null)
{
DataTable Dt = new SqlServerProvider(context).getUserLogInfo(UserID);
rootItem.Attributes.Add("total", Dt.Rows.Count);
foreach (DataRow Dr in Dt.Rows)
{
JsonItem item = new JsonItem();
children.Add(item);
item.Attributes.Add("ID", index);
item.Attributes.Add("UserAccount", Dr["UserAccount"].ToString());
item.Attributes.Add("DisplayName", Dr["DisplayName"].ToString());
item.Attributes.Add("Company", Dr["Company"].ToString());
item.Attributes.Add("Department", Dr["Department"].ToString());
item.Attributes.Add("Counts", Convert.ToString(Dr["Counts"]));
item.Attributes.Add("Phone", Convert.ToString(Dr["Phone"]));
index++;
}
}
else
{
DataTable Dt = new SqlServerProvider(context).getUserLogInfoDtl(UserID, Phone);
rootItem.Attributes.Add("total", Dt.Rows.Count);
foreach (DataRow Dr in Dt.Rows)
{
JsonItem item = new JsonItem();
children.Add(item);
item.Attributes.Add("ID", index);
item.Attributes.Add("UserAccount", Dr["UserAccount"].ToString());
item.Attributes.Add("DisplayName", Dr["DisplayName"].ToString());
item.Attributes.Add("Company", Dr["Company"].ToString());
item.Attributes.Add("Department", Dr["Department"].ToString());
item.Attributes.Add("UserEMail", Convert.ToString(Dr["UserEMail"]));
item.Attributes.Add("LogDate", Convert.ToString(Dr["LogDate"]));
item.Attributes.Add("Phone", Convert.ToString(Dr["Phone"]));
item.Attributes.Add("UUID", Convert.ToString(Dr["UUID"]));
item.Attributes.Add("DeviceName", Convert.ToString(Dr["DeviceName"]));
item.Attributes.Add("NetWork", Convert.ToString(Dr["NetWork"]));
item.Attributes.Add("Version", Convert.ToString(Dr["Version"]));
item.Attributes.Add("ClientIP", Convert.ToString(Dr["ClientIP"]));
item.Attributes.Add("FullName", Convert.ToString(Dr["FullName"]));
index++;
}
}
}
context.Response.Write(rootItem.ToString());
}
public static IDataProvider GetDataProvider_SqlServer(
SqlServerVersion version = SqlServerVersion.v2008,
SqlServerProvider provider = SqlServerProvider.SystemDataSqlClient) => provider switch
{
public SysOperationLogRepository(SqlServerProvider provider, OperateInfo oInfo = null) : base(provider, oInfo)
{
}
/// <summary>
/// Configure connection to use specific SQL Server provider, dialect and connection string.
/// </summary>
/// <param name="builder">Instance of <see cref="LinqToDBConnectionOptionsBuilder"/>.</param>
/// <param name="connectionString">SQL Server connection string.</param>
/// <param name="provider">SQL Server provider to use.</param>
/// <param name="dialect">SQL Server dialect support level.</param>
/// <returns>The builder instance so calls can be chained.</returns>
public static LinqToDBConnectionOptionsBuilder UseSqlServer(this LinqToDBConnectionOptionsBuilder builder, string connectionString, SqlServerProvider provider, SqlServerVersion dialect)
{
return(builder.UseConnectionString(SqlServerTools.GetDataProvider(dialect, provider), connectionString));
}
public void anything_with_dot_will_be_escaped_as_schema_table()
{
Assert.Equal("[dbo].[mytable]", SqlServerProvider.EscapeIdentifier("dbo.mytable"));
}
public DataSyncRecordRepository(SqlServerProvider provider, OperateInfo oInfo = null) : base(provider, oInfo)
{
}
public SysUserPermissionRepository(SqlServerProvider provider, OperateInfo oInfo = null) : base(provider, oInfo)
{
}
protected override void WriteIndexName()
{
Builder.Append(SqlServerProvider.EscapeIdentifier(Index.Name));
}
public MonitorIndicatorHistoryRecordRepository(SqlServerProvider provider, OperateInfo oInfo = null) : base(provider, oInfo)
{
}
protected override void WriteColumn(IndexColumn column)
{
Builder.Append(SqlServerProvider.EscapeIdentifier(column.Name));
}
protected override void WriteTableName()
{
Builder.Append(SqlServerProvider.EscapeIdentifier(Table.Name));
}
protected override void WriteOnTable()
{
Builder.AppendFormat(" on {0}", SqlServerProvider.EscapeIdentifier(Item.TableName));
}
public OrderInfoRepository(SqlServerProvider provider, OperateInfo oInfo = null) : base(provider, oInfo)
{
}
public void InitializeProvider()
{
provider = new SqlServerProvider();
provider.Initialize(".", "sa", "sasasa");
}
/// <summary> /// Partial method that can be implemented elsewhere in the partial class to allow the provider to be amended for a particular instance. /// </summary> /// <param name="SqlServerDataRepositoryType"> /// The type of the SqlServerDataRepository instance being created. /// </param> /// <param name="provider"> /// The default provider. A new provider may be assigned to this parameter in an implementation, if required. /// </param> partial void OverrideProvider(Type SqlServerDataRepositoryType, ref SqlServerProvider provider);
protected Service(string connString)
{
this.Provider = DapperProvider.GetProvider(string.IsNullOrEmpty(connString) ? DapperProvider.GetConnString() : connString);
}
public SysLoginTokenRepository(SqlServerProvider provider, OperateInfo oInfo = null) : base(provider, oInfo)
{
}
public void already_escaped_id_are_not_escaped()
{
Assert.Equal("dbo.[my.table]", SqlServerProvider.EscapeIdentifier("dbo.[my.table]"));
Assert.Equal("dbo.\"my.table\"", SqlServerProvider.EscapeIdentifier("dbo.\"my.table\""));
}
private void btnConnect_Click(object sender, EventArgs e)
{
if (txtConnStr.Text.Trim().Length == 0)
{
MessageBox.Show("连接字符串不能为空!");
return;
}
if (btnConnect.Text == "断开服务器连接")
{
chkCreateAssembly.Checked = false;
chkCreateAssembly_CheckedChanged(sender, e);
EnableGenEntity(false);
return;
}
RefreshConnectionStringAutoComplete();
DataSet dsTables = null;
DataSet dsViews = null;
try
{
if (radioSql.Checked || radioSql2005.Checked)
{
DbProvider dbProvider = new SqlServerProvider(txtConnStr.Text);
DbSession.SetDefault(dbProvider);
if (radioSql2005.Checked)
{
dsTables = DbSession.Default.FromSql("select [name] from sysobjects where xtype = 'U' and [name] <> 'sysdiagrams' order by [name]").ToDataSet();
}
else
{
dsTables = DbSession.Default.FromSql("select [name] from sysobjects where xtype = 'U' and status > 0 order by [name]").ToDataSet();
}
foreach (DataRow row in dsTables.Tables[0].Rows)
{
tables.Items.Add(row["Name"].ToString());
}
if (radioSql2005.Checked)
{
dsViews = DbSession.Default.FromSql("select [name] from sysobjects where xtype = 'V' order by [name]").ToDataSet();
}
else
{
dsViews = DbSession.Default.FromSql("select [name] from sysobjects where xtype = 'V' and status > 0 order by [name]").ToDataSet();
}
foreach (DataRow row in dsViews.Tables[0].Rows)
{
views.Items.Add(row["Name"].ToString());
}
}
else if (radioOracle.Checked)
{
DbProvider dbProvider = new OracleProvider(txtConnStr.Text);
DbSession.SetDefault(dbProvider);
dsTables = DbSession.Default.FromSql("select table_name Name from user_tables").ToDataSet();
foreach (DataRow row in dsTables.Tables[0].Rows)
{
tables.Items.Add(row["Name"].ToString());
}
dsViews = DbSession.Default.FromSql("select view_name Name from user_views").ToDataSet();
foreach (DataRow row in dsViews.Tables[0].Rows)
{
views.Items.Add(row["Name"].ToString());
}
}
else if (radioAccess.Checked)
{
DbProvider dbProvider = new MsAccessProvider(txtConnStr.Text);
DbSession.SetDefault(dbProvider);
string connStr = txtConnStr.Text;
ADODB.ConnectionClass conn = new ADODB.ConnectionClass();
conn.Open(connStr);
ADODB.Recordset rsTables = conn.GetType().InvokeMember("OpenSchema", BindingFlags.InvokeMethod, null, conn, new object[] { ADODB.SchemaEnum.adSchemaTables }) as ADODB.Recordset;
ADODB.Recordset rsViews = conn.GetType().InvokeMember("OpenSchema", BindingFlags.InvokeMethod, null, conn, new object[] { ADODB.SchemaEnum.adSchemaViews }) as ADODB.Recordset;
while (!rsViews.EOF)
{
if (rsTables.Fields["TABLE_TYPE"].Value.ToString() == "VIEW")
{
views.Items.Add(rsViews.Fields["TABLE_NAME"].Value.ToString());
}
rsViews.MoveNext();
}
while (!rsTables.EOF)
{
if (rsTables.Fields["TABLE_TYPE"].Value.ToString() == "TABLE")
{
tables.Items.Add(rsTables.Fields["TABLE_NAME"].Value.ToString());
}
rsTables.MoveNext();
}
rsTables.Close();
rsViews.Close();
conn.Close();
}
else if (radioSQLite.Checked)
{
DbProvider dbProvider = DbProviderFactory.CreateDbProvider(DbProviderType.SQLite, txtConnStr.Text);
DbSession.SetDefault(dbProvider);
System.Data.Common.DbConnection conn = DbSession.Default.CreateConnection();
conn.Open();
DataTable table1 = conn.GetSchema("TABLES");
DataTable table2 = conn.GetSchema("VIEWS");
conn.Close();
foreach (DataRow row in table1.Rows)
{
if (row["TABLE_TYPE"].ToString().ToUpper() == "TABLE")
{
tables.Items.Add(row["TABLE_NAME"].ToString());
}
}
foreach (DataRow row in table2.Rows)
{
views.Items.Add(row["TABLE_NAME"].ToString());
}
}
else if (radioMySQL.Checked)
{
DbProvider dbProvider = DbProviderFactory.CreateDbProvider(DbProviderType.MySql, txtConnStr.Text);
DbSession.SetDefault(dbProvider);
System.Data.Common.DbConnection conn = DbSession.Default.CreateConnection();
conn.Open();
DataTable table1 = conn.GetSchema("TABLES");
DataTable table2 = conn.GetSchema("VIEWS");
conn.Close();
foreach (DataRow row in table1.Rows)
{
if (row["TABLE_TYPE"].ToString() == "BASE TABLE")
{
tables.Items.Add(row["TABLE_NAME"].ToString());
}
}
foreach (DataRow row in table2.Rows)
{
views.Items.Add(row["TABLE_NAME"].ToString());
}
}
EnableGenEntity(true);
}
catch (Exception ex)
{
EnableGenEntity(false);
MessageBox.Show(ex.Message, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ProcessRequest(HttpContext context)
{
YZAuthHelper.OAuth();
//YZAuthHelper.AshxAuthCheck();
//GridPageInfo gridPageInfo = new GridPageInfo(context);
//IDBProvider dbProvider = YZDBProviderManager.CurrentProvider;
int Mouth;
if (context.Request.Params["byMouth"] == "1")
{
Mouth = 0;
}
else
{
string strMouth = context.Request.Params["Mouth"];
Mouth = String.IsNullOrEmpty(strMouth) ? DateTime.Today.Month : Convert.ToInt32(strMouth);
}
//获得数据
BPMTaskCollection tasks = new BPMTaskCollection();
int rowcount = 0;
JsonItem rootItem = new JsonItem();
using (BPMConnection cn = new BPMConnection())
{
cn.WebOpen();
String UserAccount = context.Request.Params["UserAccount"];
//User user = User.FromAccount(cn, UserID);
//YZAuthHelper.SetAuthCookie(realAccount);
//YZAuthHelper.GetCookie();
DataTable Dt = new SqlServerProvider(context).getWorkTimesLog(UserAccount, Mouth);
//将数据转化为Json集合
rootItem.Attributes.Add(JsonItem.TotalRows, rowcount);
JsonItemCollection children = new JsonItemCollection();
rootItem.Attributes.Add("children", children);
rootItem.Attributes.Add("total", Dt.Rows.Count);
int index = 0;
foreach (DataRow Dr in Dt.Rows)
{
JsonItem item = new JsonItem();
children.Add(item);
String StartTime = String.IsNullOrEmpty(Convert.ToString(Dr["StartTime"])) ? null : Convert.ToString(Dr["StartTime"]);
String EndTime = String.IsNullOrEmpty(Convert.ToString(Dr["EndTime"])) ? null : Convert.ToString(Dr["EndTime"]);
item.Attributes.Add("ID", index);
item.Attributes.Add("EmpID", Dr["EmpID"].ToString());
item.Attributes.Add("WorkDay", Dr["WorkDay"].ToString());
item.Attributes.Add("WeekInt", Dr["WeekInt"].ToString());
item.Attributes.Add("ClassID", Dr["ClassID"].ToString());
item.Attributes.Add("StartTime", YZStringHelper.DateToStringL(Convert.ToDateTime(StartTime)));
item.Attributes.Add("EndTime", YZStringHelper.DateToStringL(Convert.ToDateTime(EndTime)));
item.Attributes.Add("NotCard", Convert.ToString(Dr["NotCard"]));
item.Attributes.Add("GongGan", Convert.ToString(Dr["GongGan"]));
item.Attributes.Add("V1", Convert.ToString(Dr["V1"]));
item.Attributes.Add("V2", Convert.ToString(Dr["V2"]));
item.Attributes.Add("V3", Convert.ToString(Dr["V3"]));
item.Attributes.Add("V4", Convert.ToString(Dr["V4"]));
item.Attributes.Add("V5", Convert.ToString(Dr["V5"]));
item.Attributes.Add("V6", Convert.ToString(Dr["V6"]));
item.Attributes.Add("HDay", Convert.ToString(Dr["HDay"]).Split(',')[0].Replace(" ", ""));
item.Attributes.Add("Holiday", Convert.ToString(Dr["Holiday"]));
item.Attributes.Add("OverTime_H", Convert.ToString(Dr["OverTime_H"]));
item.Attributes.Add("OverTime_W", Convert.ToString(Dr["OverTime_W"]));
item.Attributes.Add("OverTime", Convert.ToString(Dr["OverTime"]));
//item.Attributes.Add("UserShortName", YZStringHelper.GetUserShortName(task.OwnerAccount, task.OwnerDisplayName));
index++;
}
}
//System.Threading.Thread.Sleep(500);
context.Response.AppendHeader("Access-Control-Allow-Origin", "*"); // 响应类型
context.Response.AppendHeader("Access-Control-Allow-Methods", "POST"); // 响应头设置
context.Response.AppendHeader("Access-Control-Allow-Headers", "x-requested-with,content-type");
context.Response.Charset = "gb2312"; //设置字符集类型
context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
context.Response.ContentType = "application/json;charset=gb2312";
//输出数据
context.Response.Write(rootItem.ToString());
}
public BaseRepository(SqlServerProvider provider, OperateInfo oInfo = null)
{
_provider = provider ?? DapperProvider.GetProvider(DapperProvider.GetConnString());
_oInfo = oInfo;
}
/// <summary>
/// 链接字符串写在配置文件里
/// 仅适用本项目WebApi，其他用途，请修改此处代码
/// </summary>
protected Service()
{
this.Provider = DapperProvider.GetProvider(DapperProvider.GetConnString());
}
