public void Create(User user)
{
using (var ctx = new LYLQEntities())
{
user.Id = Guid.NewGuid().ToString();
//ctx.Users.Add(user);
//ctx.SaveChanges();
//INSERT INTO User(Account,CreatedBy,CreatedDate,Demartment,Enabled,Id,Name,Password,UpdatedBy,UpdatedDate)VALUES('admin','System','2015/10/23 23:30:58','13533',1,'e56efc45-5f76-43af-90b1-faea2c876bc7','管理员','8C-69-76-E5-B5-41-04-15-BD-E9-08-BD-4D-EE-15-DF-B1-67-A9-C8-73-FC-4B-B8-A8-1F-6F-2A-B4-48-A9-18','System','2015/10/23 23:30:58')
string sql = "INSERT INTO User(Account,CreatedBy,CreatedDate,Demartment,Enabled,Id,Name,Password,UpdatedBy,UpdatedDate)VALUES(@Account,@CreatedBy,@CreatedDate,@Demartment,@Enabled,@Id,@Name,@Password,@UpdatedBy,@UpdatedDate)";
List<SQLiteParameter> sqlParams = new List<SQLiteParameter>();
sqlParams.Add(new SQLiteParameter("@Account", user.Account));
sqlParams.Add(new SQLiteParameter("@CreatedBy", user.CreatedBy));
sqlParams.Add(new SQLiteParameter("@CreatedDate", user.CreatedDate));
sqlParams.Add(new SQLiteParameter("@Demartment", user.Demartment));
sqlParams.Add(new SQLiteParameter("@Enabled", user.Enabled));
sqlParams.Add(new SQLiteParameter("@Id", user.Id));
sqlParams.Add(new SQLiteParameter("@Name", user.Name));
sqlParams.Add(new SQLiteParameter("@Password", user.Password));
sqlParams.Add(new SQLiteParameter("@UpdatedBy", user.UpdatedBy));
sqlParams.Add(new SQLiteParameter("@UpdatedDate", user.UpdatedDate));
ctx.Database.ExecuteSqlCommand(sql, sqlParams.ToArray());
}
}
public DBLayer.User GetDBModel(User user)
{
DBLayer.User dbUser = null;
if (user != null)
{
dbUser = new DBLayer.User();
dbUser.Id = user.Id;
dbUser.Name = user.Name;
dbUser.Account = user.Account;
dbUser.Password = user.Password;
dbUser.Demartment = user.Demartment;
dbUser.Enabled = user.Enabled;
dbUser.CreatedBy = user.CreatedBy;
dbUser.CreatedDate = user.CreatedDate;
dbUser.UpdatedBy = user.UpdatedBy;
dbUser.UpdatedDate = user.UpdatedDate;
}
return dbUser;
}
public void Update(User user)
{
using (var ctx = new LYLQEntities()){
var dbUsers = from dbUser in ctx.Users
where dbUser.Id == user.Id
select dbUser;
var dbModelUser = dbUsers.First();
dbModelUser.Password = user.Password;
dbModelUser.Demartment = user.Demartment;
dbModelUser.Enabled = user.Enabled;
dbModelUser.UpdatedBy = user.UpdatedBy;
dbModelUser.UpdatedDate = DateTime.Now;
//ctx.SaveChanges();
string sql = @"UPDATE User SET Password = @Password,
Demartment = @Demartment,
Enabled= @Enabled,
UpdatedBy = @UpdatedBy,
UpdatedDate = @UpdatedDate
WHERE Id = '" + dbModelUser .Id+ "'";
List<SQLiteParameter> sqlParams = new List<SQLiteParameter>();
sqlParams.Add(new SQLiteParameter("@Password", dbModelUser.Password));
sqlParams.Add(new SQLiteParameter("@Demartment", dbModelUser.Demartment));
sqlParams.Add(new SQLiteParameter("@Enabled", dbModelUser.Enabled));
sqlParams.Add(new SQLiteParameter("@UpdatedBy", dbModelUser.UpdatedBy));
sqlParams.Add(new SQLiteParameter("@UpdatedDate", dbModelUser.UpdatedDate));
ctx.Database.ExecuteSqlCommand(sql, sqlParams.ToArray());
}
}
