/// <summary>
/// 添加一个用户记录
/// test success , 2018.4.9
/// </summary>
/// <param name="model">用户模型数据</param>
/// <returns></returns>
public bool AddUser(UserInformationModel model)
{
bool isSucceeded = false;
StringBuilder builder = new StringBuilder();
try
{
//连接数据库
using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString))
{
sqlConnect.Open();
builder.Append("INSERT INTO ");
builder.Append(TableName);
builder.Append("(UserName,Password,TotalMoney,HadPlayerModelsID,MFriendsID,Name)");
builder.Append(" ");
builder.Append("VALUES");
builder.Append("(");
builder.Append("\'" + model.UserName + "\',");
builder.Append("\'" + model.Password + "\',");
builder.Append(model.TotalMoney + ",");
builder.Append("\'" + model.HadPlayerModelsID + "\',");
builder.Append("\'" + model.MFriendsID + "\',");
builder.Append("\'" + model.Name + "\'");
builder.Append(");");
SQLiteCommand command = sqlConnect.CreateCommand();
command.CommandText = builder.ToString();
//成功添加
if (command.ExecuteNonQuery() == 1)
{
isSucceeded = true;
String getIdCommandString = "SELECT last_insert_rowid() FROM " + TableName;
SQLiteCommand getIdCommand = sqlConnect.CreateCommand();
getIdCommand.CommandText = getIdCommandString;
//读取刚刚插入的ID，赋值给模型
using (SQLiteDataReader reader = getIdCommand.ExecuteReader())
{
reader.Read();
model.ID = reader.GetInt32(0);
}
}
}
return(isSucceeded);
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// 更新一个用户数据
/// test success , 2018.4.9
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpDateUser(UserInformationModel model)
{
StringBuilder builder = new StringBuilder();
try
{
//连接数据库
using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString))
{
sqlConnect.Open();
builder.Append("UPDATE ");
builder.Append(TableName);
builder.Append(" ");
builder.Append("SET ");
builder.Append("UserName="******"\'" + model.UserName + "\',");
builder.Append("Password="******"\'" + model.Password + "\',");
builder.Append("TotalMoney=" + model.TotalMoney + ",");
builder.Append("HadPlayerModelsID=" + "\'" + model.HadPlayerModelsID + "\',");
builder.Append("MFriendsID=" + "\'" + model.MFriendsID + "\',");
builder.Append("Name=" + "\'" + model.Name + "\'");
builder.Append(" ");
builder.Append("WHERE ID=" + model.ID + ";");
SQLiteCommand command = sqlConnect.CreateCommand();
command.CommandText = builder.ToString();
//成功更新
if (command.ExecuteNonQuery() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// 获取所有的用户信息
/// test success , 2018.4.9
/// </summary>
/// <returns></returns>
public List <UserInformationModel> GetAllUser()
{
List <UserInformationModel> result = new List <UserInformationModel>();
try
{
//连接数据库
using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString))
{
sqlConnect.Open();
String commandString = "SELECT * FROM " + TableName;
SQLiteCommand command = sqlConnect.CreateCommand();
command.CommandText = commandString;
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
UserInformationModel user = new UserInformationModel();
user.ID = int.Parse(reader["ID"].ToString());
user.UserName = reader["UserName"].ToString();
user.Password = reader["Password"].ToString();
user.TotalMoney = int.Parse(reader["TotalMoney"].ToString());
user.HadPlayerModelsID = reader["HadPlayerModelsID"].ToString();
user.MFriendsID = reader["MFriendsID"].ToString();
user.Name = reader["Name"].ToString();
result.Add(user);
}
return(result);
}
}
}
catch (Exception e)
{
return(null);
}
}
/// <summary>
/// 从userName获取用户资料
/// test success , 2018.4.21
/// </summary>
/// <param name="userName">用户名</param>
/// <returns></returns>
public UserInformationModel GetUserFromUserName(string userName)
{
UserInformationModel result = null;
try
{
//连接数据库
using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString))
{
sqlConnect.Open();
String commandString = "SELECT * FROM " + TableName + " WHERE UserName = "******"\'" + userName + "\'";
SQLiteCommand command = sqlConnect.CreateCommand();
command.CommandText = commandString;
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
result = new UserInformationModel();
result.ID = int.Parse(reader["ID"].ToString());
result.UserName = reader["UserName"].ToString();
result.Password = reader["Password"].ToString();
result.TotalMoney = int.Parse(reader["TotalMoney"].ToString());
result.HadPlayerModelsID = reader["HadPlayerModelsID"].ToString();
result.MFriendsID = reader["MFriendsID"].ToString();
result.Name = reader["Name"].ToString();
}
return(result);
}
}
}
catch (Exception e)
{
return(null);
}
}
