//This method returns a specific connectionstringbuilder object
//based on the value of a DataBaseProvider enum
public static DbConnectionStringBuilder GetConnectionStringBuilder(DataBaseProvider dataProvider, string connectionString)
{
DbConnectionStringBuilder stringBuilder = null;
switch (dataProvider)
{
case DataBaseProvider.SqlServer:
stringBuilder = new SqlConnectionStringBuilder(connectionString);
break;
case DataBaseProvider.OleDb:
stringBuilder = new OleDbConnectionStringBuilder(connectionString);
break;
case DataBaseProvider.Odbc:
stringBuilder = new OdbcConnectionStringBuilder(connectionString);
break;
case DataBaseProvider.None:
break;
default:
break;
}
return(stringBuilder);
}
/// <summary>
/// 商品
/// </summary>
/// <returns></returns>
public ActionResult shangpin()
{
QSmartDatabaseClient db = DataBaseProvider.Create("db");
db.InsertEntity(new ShangPin {
ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "中长款连帽棉服男装"
}.CreateQSmartObject());
db.InsertEntity(new ShangPin {
ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "韩版修身男装棉袄"
}.CreateQSmartObject());
db.InsertEntity(new ShangPin {
ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "时尚羊羔绒棉服外套"
}.CreateQSmartObject());
db.InsertEntity(new ShangPin {
ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "可脱卸大毛领连帽棉衣"
}.CreateQSmartObject());
db.InsertEntity(new ShangPin {
ShangPinFenLeiId = 1, ChiMaZuId = 1, YanSeZuId = 1, PinPaiId = 1, Name = "时尚连帽棉服"
}.CreateQSmartObject());
db.InsertEntity(new ShangPin {
ShangPinFenLeiId = 1, ChiMaZuId = 2, YanSeZuId = 2, PinPaiId = 2, Name = "保暖情侣潮上衣"
}.CreateQSmartObject());
db.InsertEntity(new ShangPin {
ShangPinFenLeiId = 1, ChiMaZuId = 2, YanSeZuId = 2, PinPaiId = 2, Name = "男士长袖POLO衣"
}.CreateQSmartObject());
db.SaveChange();
return(Content("ok"));
}
/// <summary>Raises the <see cref="E:System.Windows.Application.Startup" /> event.</summary>
/// <param name="e">A <see cref="T:System.Windows.StartupEventArgs" /> that contains the event data.</param>
protected override void OnStartup(StartupEventArgs e)
{
var version = typeof(App).Assembly.GetName().Version;
Log.Info($"Managing app started. Program version: {version}.");
AppDomain.CurrentDomain.UnhandledException += CurrentDomainOnUnhandledException;
base.OnStartup(e);
var prioritySearcher = new PriorityVectorSearcher();
var context = new DssContext();
var dataProvider = new DataBaseProvider(context);
var viewModelList = new List <IPageViewModel>
{
new TaskManagingViewModel(dataProvider),
new InputViewModel(dataProvider),
new PairMatrixViewModel(dataProvider),
new ResultViewModel(dataProvider, prioritySearcher)
};
var mainWindowViewModel = new MainWindowViewModel(viewModelList, dataProvider);
var mainWindow = new MainWindow {
DataContext = mainWindowViewModel
};
Log.Info("Initialize is successful");
mainWindow.Show();
}
public void Process(EntityTypeBuilder <T> builder, DataBaseProvider provider, Func <IConfigurationRuleSet, bool> filter = null)
{
var mappingRuleSets = filter == null ? _rulesFactory.Value : _rulesFactory.Value.Where(filter);
foreach (var mappingRuleSet in mappingRuleSets)
{
foreach (var rule in mappingRuleSet.GetRules <T>())
{
var propertyBuilder = builder.Property(rule.PropertyType, rule.PropertyName);
if (rule.IsConcurrencyToken)
{
propertyBuilder = propertyBuilder.IsConcurrencyToken();
}
if (rule.IsRequired)
{
propertyBuilder = propertyBuilder.IsRequired();
}
if (rule.MaxLength.HasValue)
{
propertyBuilder = propertyBuilder.HasMaxLength(rule.MaxLength.Value);
}
var columnName = rule.HasColumnName
? DbColumnBuilder.CreateWithPristineValue(rule.ColumnName, provider).Build()
: DbColumnBuilder.CreateWithNormalizedValue(rule.PropertyName, provider).Build();
propertyBuilder.HasColumnName(columnName);
}
}
}
/// <summary>
/// 处理连接串,参数支持Diction<string,object>,DbParameter[] , new{}
/// </summary>
/// <param name="param"></param>
/// <param name="cmd"></param>
internal void SetupDbCommand(object param, ref DbCommand cmd)
{
if (null == param)
{
return;
}
IEnumerable <DbParameter> dbpars = param as IEnumerable <DbParameter>;
if (null != dbpars)
{
foreach (var ele in dbpars)
{
cmd.Parameters.Add(ele);
}
}
else
{
IDictionary <string, object> dic = SmartCrud.SmartCrudHelper.AsDictionary(param);
if (null != dic)
{
foreach (var ele in dic)
{
#if !REF_ALL_DB || NETFRAMEWORK
var par = this.dbProvider.CreateParameter();
#else
var par = DataBaseProvider.GetParameter(this.DbType);
#endif
par.ParameterName = ele.Key.TrimParaName();
par.Value = ele.Value;
cmd.Parameters.Add(par);
}
}
}
}
//This method returns a specific command object
//based on the value of a DataBaseProvider enum
public static DbCommand GetCommand(DataBaseProvider dataProvider)
{
DbCommand command = null;
switch (dataProvider)
{
case DataBaseProvider.SqlServer:
command = new SqlCommand();
break;
case DataBaseProvider.OleDb:
command = new OleDbCommand();
break;
case DataBaseProvider.Odbc:
command = new OdbcCommand();
break;
case DataBaseProvider.None:
break;
default:
break;
}
return(command);
}
public ActionResult CreateTable()
{
QSmartDatabaseClient db = DataBaseProvider.Create("db");
//db.CreateTable<ShangJia_ShangPin_TuCe>(QSmartTableType.InnoDB);
//db.CreateTable<ShangJia_Sku_Info>(QSmartTableType.InnoDB);
//db.CreateTable<ShangJia_Sku_TuTou>(QSmartTableType.InnoDB);
//db.CreateTable<YanSeZu>(QSmartTableType.InnoDB);
//db.CreateTable<YanSeZuMingXi>(QSmartTableType.InnoDB);
//db.CreateTable<YanSe>(QSmartTableType.InnoDB);
//db.CreateTable<ChiMaZu>(QSmartTableType.InnoDB);
//db.CreateTable<ChiMaZuMingXi>(QSmartTableType.InnoDB);
//db.CreateTable<ChiMa>(QSmartTableType.InnoDB);
//db.CreateTable<PinPai>(QSmartTableType.InnoDB);
db.CreateTable <ShangPin>(QSmartTableType.InnoDB);
//db.CreateTable<ShangPinFenLei>(QSmartTableType.InnoDB);
//db.CreateTable<JingXiaoShang>(QSmartTableType.InnoDB);
//db.CreateTable<CaoZuoYuan>(QSmartTableType.InnoDB);
//db.CreateTable<MenDian>(QSmartTableType.InnoDB);
////db.CreateTable<MenDian_CanZuoYuan_GuanLian>(QSmartTableType.InnoDB);
//db.CreateTable<CangKu>(QSmartTableType.InnoDB);
//db.CreateTable<HuoWei>(QSmartTableType.InnoDB);
//db.CreateTable<RuKu>(QSmartTableType.InnoDB);
//db.CreateTable<RuKuMingXi>(QSmartTableType.InnoDB);
return(Content("ok"));
}
public ActionResult yansechima()
{
QSmartDatabaseClient db = DataBaseProvider.Create("db");
db.InsertEntity(new YanSe {
Name = "红色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "黑色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "藏蓝色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "白色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "墨绿色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "天青色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "黄色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "绿色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "草绿色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "紫色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "宝石蓝色"
}.CreateQSmartObject());
db.InsertEntity(new YanSe {
Name = "磨砂岩色"
}.CreateQSmartObject());
db.InsertEntity(new ChiMa {
Name = "S"
}.CreateQSmartObject());
db.InsertEntity(new ChiMa {
Name = "M"
}.CreateQSmartObject());
db.InsertEntity(new ChiMa {
Name = "L"
}.CreateQSmartObject());
db.InsertEntity(new ChiMa {
Name = "XL"
}.CreateQSmartObject());
db.InsertEntity(new ChiMa {
Name = "XXL"
}.CreateQSmartObject());
db.SaveChange();
return(Content("ok"));
}
public ActionResult CreateTable()
{
QSmartDatabaseClient db = DataBaseProvider.Create("db");
db.CreateTable <Customer>(QSmartTableType.InnoDB);
db.CreateTable <Cart>(QSmartTableType.InnoDB);
db.CreateTable <CustomerAddress>(QSmartTableType.InnoDB);
db.CreateTable <CustomerOrder>(QSmartTableType.InnoDB);
db.CreateTable <Order>(QSmartTableType.InnoDB);
db.CreateTable <OrderGoods>(QSmartTableType.InnoDB);
Customer ct = new Customer
{
Id = Guid.NewGuid().ToString().Replace("-", ""),
LoginName = "admin",
NikeName = "管理员",
Password = "******",
Phone = "123456789"
};
db.InsertEntity(ct.CreateQSmartObject());
db.SaveChange();
db.CreateTable <YanSeZu>(QSmartTableType.InnoDB);
db.CreateTable <YanSeZuMingXi>(QSmartTableType.InnoDB);
db.CreateTable <YanSe>(QSmartTableType.InnoDB);
db.CreateTable <ChiMaZu>(QSmartTableType.InnoDB);
db.CreateTable <ChiMaZuMingXi>(QSmartTableType.InnoDB);
db.CreateTable <ChiMa>(QSmartTableType.InnoDB);
db.CreateTable <PinPai>(QSmartTableType.InnoDB);
db.CreateTable <ShangPin>(QSmartTableType.InnoDB);
db.CreateTable <ShangPinFenLei>(QSmartTableType.InnoDB);
db.CreateTable <JingXiaoShang>(QSmartTableType.InnoDB);
db.CreateTable <CaoZuoYuan>(QSmartTableType.InnoDB);
db.CreateTable <MenDian>(QSmartTableType.InnoDB);
//db.CreateTable<MenDian_CanZuoYuan_GuanLian>(QSmartTableType.InnoDB);
db.CreateTable <CangKu>(QSmartTableType.InnoDB);
db.CreateTable <HuoWei>(QSmartTableType.InnoDB);
db.CreateTable <RuKu>(QSmartTableType.InnoDB);
db.CreateTable <RuKuMingXi>(QSmartTableType.InnoDB);
return(Content("ok"));
/*
* CREATE OR REPLACE VIEW `cartview` AS
* select `cart`.`Id` AS `Id`,`cart`.`Sku` AS `Sku`,`cart`.`CustomerId` AS `CustomerId`,`cart`.`Actived` AS `Actived`,`cart`.`Quantity` AS `Quantity`,`goodsshelves`.`Description` AS `Description`,`goodsshelves`.`Price` AS `Price` from (`cart` left join `goodsshelves` on((`cart`.`Sku` = `goodsshelves`.`Sku`)));
* ;
* */
}
public ChatDataSet(string connectionString, DataBaseProvider provider)
{
_provider = provider;
ConfigurateUsersAdapter(connectionString, out _usersDataAdapter);
ConfigurateMessagesAdapter(connectionString, out _messagesDataAdapter);
CreateDataSet();
FillDataSet();
_usersDV = new DataView(_usersTable);
_messagesDV = new DataView(_messagesTable);
}//c-tor
public Startup(IConfiguration configuration)
{
Configuration = configuration;
_DataBaseProvider = new DataBaseProvider();
// var logRepository = LogManager.GetRepository(Assembly.GetEntryAssembly());
repository = LogManager.CreateRepository("NETCoreRepository");
XmlConfigurator.Configure(repository, new FileInfo("Config/log4net.config"));
}
/// <summary>
/// 经销商
/// </summary>
/// <returns></returns>
public ActionResult jingxiaoshang()
{
QSmartDatabaseClient db = DataBaseProvider.Create("db");
db.InsertEntity(new JingXiaoShang {
Name = "北京服装经销商", Address = "北京 海淀", Phone = "010-666666"
}.CreateQSmartObject());
db.SaveChange();
return(Content("ok"));
}
/// <summary>
/// 门店
/// </summary>
/// <returns></returns>
public ActionResult mendian()
{
QSmartDatabaseClient db = DataBaseProvider.Create("db");
db.InsertEntity(new MenDian {
Name = "北京大红门服装店", JingXiaoShangId = 1, Address = "北京", Phone = "010-666666"
}.CreateQSmartObject());
db.InsertEntity(new MenDian {
Name = "北京西单服装店", JingXiaoShangId = 1, Address = "北京", Phone = "010-666666"
}.CreateQSmartObject());
db.SaveChange();
return(Content("ok"));
}
/// <summary>
/// 品牌
/// </summary>
/// <returns></returns>
public ActionResult pinpai()
{
QSmartDatabaseClient db = DataBaseProvider.Create("db");
db.InsertEntity(new PinPai {
Name = "丹杰仕", Logo = "DANJIESHI"
}.CreateQSmartObject());
db.InsertEntity(new PinPai {
Name = "佐丹奴", Logo = "Giordano"
}.CreateQSmartObject());
db.SaveChange();
return(Content("ok"));
}
/// <summary>
/// 尺码组
/// </summary>
/// <returns></returns>
public ActionResult zhimazu()
{
QSmartDatabaseClient db = DataBaseProvider.Create("db");
db.InsertEntity(new ChiMaZu {
Name = "丹杰仕尺码组", PinPaiId = 1
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZu {
Name = "佐丹奴尺码组", PinPaiId = 2
}.CreateQSmartObject());
db.SaveChange();
return(Content("ok"));
}
public static ArrayList getRecommend()
{
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select * from recommender";
mySqlCommand.CommandText = sqlStr;
mySqlCommand.Connection.OpenAsync();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
ArrayList recommendList = new ArrayList();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
int userId = reader.GetInt32(0);
string userCF = reader.GetString(1);
string itemCF = reader.GetString(2);
Recommend recommend = new Recommend();
recommend.UserId = userId;
recommend.UserCF = userCF;
recommend.ItemCF = itemCF;
recommendList.Add(recommend);
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.CloseAsync();
}
return(recommendList);
}
/// <summary>
/// recommend辅助函数
/// 获取user_id和movie_id的关联字典
/// </summary>
/// <param name="user_id"></param>
/// <returns></returns>
private static PythonDictionary getUserItem(int user_id)
{
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select userId,movieId from rating";
mySqlCommand.CommandText = sqlStr;
mySqlCommand.Connection.OpenAsync();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
PythonDictionary pyDic = new PythonDictionary();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
int userId = reader.GetInt32(0);
int movieId = reader.GetInt32(1);
if (!pyDic.Keys.Contains(userId))
{
pyDic.Add(userId, new ArrayList());
}
ArrayList subList = pyDic[userId] as ArrayList;
subList.Add(movieId);
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.CloseAsync();
}
return(pyDic);
}
public static ArrayList GetAllRating()
{
ArrayList allRating = new ArrayList();
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select * from rating";
mySqlCommand.CommandText = sqlStr;
mySqlCommand.Connection.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
Rating rating = new Rating();
rating.UserId = reader.GetInt32(0);
rating.MovieId = reader.GetInt32(1);
rating.Rate = reader.GetFloat(2);
int tiemStamp = reader.GetInt32(3);
rating.TimeStamp = GetTime(Convert.ToString(tiemStamp));
allRating.Add(rating);
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.Close();
}
return(allRating);
}
public static ArrayList GetRatingByUserId(int user_id)
{
ArrayList ratingList = new ArrayList();
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select * from rating where userId = ?us_id";
mySqlCommand.CommandText = sqlStr;
mySqlCommand.Parameters.AddWithValue("?us_id", user_id);
mySqlCommand.Connection.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
Rating rating = new Rating();
rating.UserId = reader.GetInt32(0);
rating.MovieId = reader.GetInt32(1);
rating.Rate = reader.GetFloat(2);
rating.TimeStamp = GetTime(Convert.ToString(reader.GetInt32(3)));
ratingList.Add(rating);
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.Close();
}
return(ratingList);
}
internal static DataBaseProvider GetProvider()
{
//Read the provider key
string dataProvidrString = ConfigurationManager.AppSettings["Provider"];
//Transform string to enum
DataBaseProvider dataProvider = DataBaseProvider.None;
if (Enum.IsDefined(typeof(DataBaseProvider), dataProvidrString))
{
dataProvider = (DataBaseProvider)Enum.Parse(typeof(DataBaseProvider), dataProvidrString);
return(dataProvider);
}
else
{
return(DataBaseProvider.None);
}
}
public static ArrayList GetGroupLengthsByMovie()
{
ArrayList groupLength = new ArrayList();
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select count(*),movieId from rating group by movieId";
mySqlCommand.Connection.Open();
mySqlCommand.CommandText = sqlStr;
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
Group movieGroup = new Group();
movieGroup.GroupLength = reader.GetInt32(0);
movieGroup.Id = reader.GetInt32(1);
groupLength.Add(movieGroup);
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.Close();
}
return(groupLength);
}
public static ArrayList GetAllUser()
{
ArrayList allUser = new ArrayList();
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select * from user";
mySqlCommand.CommandText = sqlStr;
mySqlCommand.Connection.OpenAsync();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
User user = new User();
user.UserId = reader.GetInt32(0);
allUser.Add(user);
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.CloseAsync();
}
return(allUser);
}
/// <summary>
/// 获取用户ID为user_id相关联的全部电影的ID
/// </summary>
/// <param name="user_id"></param>
/// <returns></returns>
private static IronPython.Runtime.List getUserLikeItem(int user_id)
{
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select movieId from rating where userId = ?us_id";
mySqlCommand.CommandText = sqlStr;
mySqlCommand.Parameters.AddWithValue("?us_id", user_id);
mySqlCommand.Connection.OpenAsync();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
IronPython.Runtime.List pyItemList = new List();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
pyItemList.append(reader.GetInt32(0));
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.CloseAsync();
}
return(pyItemList);
}
public static User GetUserById(int id)
{
User user = new User();
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select * from user where userId = ?us_id";
mySqlCommand.CommandText = sqlStr;
mySqlCommand.Parameters.AddWithValue("?us_id", id);
mySqlCommand.Connection.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
user.UserId = reader.GetInt32(0);
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.Close();
}
return(user);
}
/// <summary>
/// 尺码组明细
/// </summary>
/// <returns></returns>
public ActionResult chimazumingxi()
{
QSmartDatabaseClient db = DataBaseProvider.Create("db");
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 1, ChiMaId = 1
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 1, ChiMaId = 2
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 1, ChiMaId = 3
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 1, ChiMaId = 4
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 1, ChiMaId = 5
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 2, ChiMaId = 1
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 2, ChiMaId = 2
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 2, ChiMaId = 3
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 2, ChiMaId = 4
}.CreateQSmartObject());
db.InsertEntity(new ChiMaZuMingXi {
ChiMaZuId = 2, ChiMaId = 5
}.CreateQSmartObject());
db.SaveChange();
return(Content("ok"));
}
public static string getItemCFRecommend(int user_id)
{
string itemCF = null;
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select itemCF from recommender where userId = ?us_id";
mySqlCommand.CommandText = sqlStr;
mySqlCommand.Parameters.AddWithValue("?us_id", user_id);
mySqlCommand.Connection.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
itemCF = reader.GetString(0);
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.Close();
}
return(itemCF);
}
public static int GetRatingTotal()
{
int ratingTotal = 0;
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = DataBaseProvider.getConnection();
string sqlStr =
@"select count(*) from rating";
mySqlCommand.CommandText = sqlStr;
mySqlCommand.Connection.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
ratingTotal = reader.GetInt32(0);
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
mySqlCommand.Connection.Close();
}
return(ratingTotal);
}
//This method returns a specific adapter object
//based on the value of a DataBaseProvider enum
public static DbDataAdapter GetDataAdapter(DataBaseProvider dataProvider, string commandText, string connectionString)
{
DbDataAdapter adapter = null;
switch (dataProvider)
{
case DataBaseProvider.SqlServer:
adapter = new SqlDataAdapter(commandText, connectionString);
break;
case DataBaseProvider.OleDb:
adapter = new OleDbDataAdapter(commandText, connectionString);
break;
case DataBaseProvider.Odbc:
adapter = new OdbcDataAdapter(commandText, connectionString);
break;
default:
break;
}
return(adapter);
}
//This method returns a specific parameter object
//based on the value of a DataBaseProvider enum
public static DbParameter GetParameter(DataBaseProvider dataProvider)
{
DbParameter parameter = null;
switch (dataProvider)
{
case DataBaseProvider.SqlServer:
parameter = new SqlParameter();
break;
case DataBaseProvider.OleDb:
parameter = new OleDbParameter();
break;
case DataBaseProvider.Odbc:
parameter = new OdbcParameter();
break;
default:
break;
}
return(parameter);
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
var connectionString = "Data Source=.;Initial Catalog=NhibernateDB;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
var config = new Configuration();
config.DataBaseIntegration(x =>
{
x.ConnectionString = connectionString;
x.Driver <SqlClientDriver>();
x.Dialect <MsSql2008Dialect>();
});
config.AddAssembly(typeof(DataBaseProvider).Assembly.GetName().Name);
var sessionFactory = config.BuildSessionFactory();
DataBaseProvider.SetSessionFactory(sessionFactory);
}
/// <summary>
/// 初始化数据库
/// </summary>
/// <param name="Path">链接地址</param>
/// <param name="Type">数据库类型</param>
///
void IniDB(string Path, DataBaseProvider Type)
{
dbOperator = DBService.DBOperator.GetInstance(Path, Type);
}
/// <summary>
/// 初始化数据库
/// </summary>
/// <param name="Path">链接地址</param>
/// <param name="Type">数据库类型</param>
///
void IniDB(string Path, DataBaseProvider Type)
{
try
{
dbOperator = DBService.DBOperator.GetInstance(Path, Type);
info.DBStatic = "连接正常";
}
catch (Exception ex)
{
WRITELOG.Error(ex.Source.ToString() + "||" + ex.Message.ToString() + "||" + DateTime.Now.ToString(), ex);
info.DBStatic = "连接异常";
}
}
public DataBase()
{
_isMono = MiNetServer.IsRunningOnMono();
if(_isMono)
{
_provider = new DataBaseMono();
}
else
{
_provider = new DataBaseNT();
}
LoadAllPerms();
//NT.SQLiteConnection.CreateFile("db.sqlite");
//NT.SQLiteConnection m_dbConnection = new NT.SQLiteConnection("Data Source=db.sqlite;Version=3;");
//m_dbConnection.Open();
//string sql = "CREATE TABLE users (id INTEGER PRIMARY KEY AUTOINCREMENT, nick VARCHAR(64), password VARCHAR(32), role INT)";
//NT.SQLiteCommand command = new NT.SQLiteCommand(sql, m_dbConnection);
//command.ExecuteNonQuery();
}
