/// <summary>
/// Updates the user.
/// </summary>
/// <param name="user">User.</param>
public int UpdateUser(Sys_User user)
{
SqliteHelper.SqliteInit (_dburl);
return SqliteHelper.ExecuteNonQuery (
"update sys_user " +
"set Name_CN=@Name_CN," +
"LoginName=@LoginName," +
"PassWord=@PassWord," +
"UserTypeID=@UserTypeID," +
"DealerID=@DealerID," +
"DealerName=@DealerName," +
"LastLoginDate=@LastLoginDate," +
"IsValid=@IsValid " +
"where UserID=@UserID",
new object[] {
user.UserID,
user.Name_CN,
user.LoginName,
user.PassWord,
user.UserTypeID,
user.DealerID,
string.IsNullOrEmpty(user.DealerName)?"":user.DealerName,
DateTime.Today.ToString (),
user.IsValid
});
}
/// <summary>
/// Inserts the user.
/// </summary>
/// <param name="user">User.</param>
/// <param name="dburl">Dburl.</param>
public int InsertUser(Sys_User user)
{
SqliteHelper.SqliteInit(_dburl);
return SqliteHelper.ExecuteNonQuery ("delete from sys_user where UserID=@UserID;" +
"insert into sys_user(UserID,Name_CN,LoginName,PassWord,UserTypeID,DealerID,DealerName,LastLoginDate,IsValid) " +
"values(@UserID,@Name_CN,@LoginName,@PassWord,@UserTypeID,@DealerID,@DealerName,@LastLoginDate,@IsValid)",
new object[] {
user.UserID,
user.UserID,
user.Name_CN,
user.LoginName,
user.PassWord,
user.UserTypeID,
user.DealerID,
string.IsNullOrEmpty(user.DealerName)?"":user.DealerName,
DateTime.Today.ToString (),
true
});
}
public int UpdateUser(Sys_User user)
{
return userDal.UpdateUser (user);
}
public int UserInsert(Sys_User user)
{
return userDal.InsertUser (user);
}
/// <summary>
/// Gets the last login user.
/// </summary>
/// <returns>The last login user.</returns>
public Sys_User GetLastLoginUser()
{
Sys_User user = null;
SqliteHelper.SqliteInit (_dburl);
DataSet ds = SqliteHelper.ExecuteDataSet ("select UserID,Name_CN,LoginName,PassWord,UserTypeID,DealerID,DealerName,LastLoginDate,IsValid from sys_user where IsValid=1 order by LastLoginDate desc", null);
if (ds != null && ds.Tables.Count > 0) {
foreach (DataRow dr in ds.Tables[0].Rows) {
user = new Sys_User ();
user.UserID = int.Parse(dr ["UserID"].ToString());
user.Name_CN = dr ["Name_CN"].ToString();
user.LoginName = dr ["LoginName"].ToString();
user.PassWord = dr ["PassWord"].ToString();
user.DealerID = int.Parse(dr ["DealerID"].ToString());
user.DealerName = dr ["DealerName"].ToString();
user.UserTypeID = int.Parse(dr ["UserTypeID"].ToString());
user.lastLoginDate = DateTime.Parse(dr ["LastLoginDate"].ToString());
break;
}
}
return user;
}
