public ActionResult login(Dictionary <string, string> queryvalues)
{
string username = queryvalues.ContainsKey("username") ? queryvalues["username"] : "";
string password = queryvalues.ContainsKey("password") ? queryvalues["password"] : "";
string ReturnUrl = queryvalues.ContainsKey("ReturnUrl") ? queryvalues["ReturnUrl"] : "";
CLoginUser user = ClubBLL.GetCLoginUserByLoginName(new CLoginUser {
UserAccount = username
});
if (user == null || string.IsNullOrEmpty(user.UserAccount))
{
return(Json(
new { result = Result.UserDoesNotExist }
));
}
if (user.UserPassword == password)
{
Session["name"] = username;
return(Json(RedirectToLocal(ReturnUrl)));
}
else
{
return(Json(new { result = Result.PasswordIsIncorrect }));
}
}
public static CLoginUser GetCLoginUserByLoginName(CLoginUser user)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
IEnumerable <CLoginUser> i = cn.Query <CLoginUser>(@"select * from " + database2 + @".C_LoginUser where UserAccount = @UserAccount", user);
cn.Close();
return(i.FirstOrDefault());
}
}
internal static int AddCLoginUser(CLoginUser loginUser)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
string sql = "insert into " + database2 + @".C_LoginUser(UserAccount,UserPassword,DateTime) values(@UserAccount,@UserPassword,'" + DateTime.Now + "')";
cn.Open();
cn.Query <Resource>(sql, loginUser);
return(1);
}
}
internal static int DeleteCLoginUser(CLoginUser loginUser)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
string sql = @"delete from " + database2 + @".C_LoginUser where UserId =@UserId;
delete from " + database2 + @".C_LoginUserClub where UserId =@UserId;
";
cn.Open();
cn.Query <Resource>(sql, loginUser);
return(1);
}
}
internal static int CancleCRebateUser(CLoginUser loginUser)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
string sql = "";
if (loginUser.Num == 1)
{
sql = @"delete from " + database2 + @".C_RebateUser where GroupID=@GroupID;delete from " + database2 + @".C_RebateGroup where GroupID = @GroupID;";
}
if (loginUser.Num == 2)
{
sql = @"delete from " + database2 + @".C_RebateUser where UserID=@GroupID;";
}
cn.Open();
int i = cn.Execute(sql, loginUser);
return(i);
}
}
internal static int AddCRebateUser(CLoginUser loginUser)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
string sql = "";
int i = 0;
cn.Open();
if (loginUser.Name != "")
{
sql = "insert into " + database2 + @".C_RebateGroup(GroupName,GroupDesc,RebatePer) values(@Name,@Desc,@Num)";
i = cn.Execute(sql, loginUser);
}
else
{
sql = "call " + database2 + @".f_split(@GroupID ,@ClubIds)";
//i = Convert.ToInt32(cn.Query(sql, loginUser).First());
i = cn.Execute(sql, loginUser);
}
return(i);
}
}
public ActionResult LogIn(CLoginUser loginuser)
{
Console.WriteLine(loginuser.theID);
Console.WriteLine(loginuser.thePW);
return(RedirectToAction("Index", loginuser));
}
public static CLoginUser GetCLoginUserByLoginName(CLoginUser user)
{
return(ClubDAL.GetCLoginUserByLoginName(user));
}
/// <summary>
/// 删除登录用户
/// </summary>
/// <param name="loginUser"></param>
/// <returns></returns>
public static bool DeleteCLoginUser(CLoginUser loginUser)
{
return(ClubDAL.DeleteCLoginUser(loginUser) > 0);
}
public static int AddCRebateUser(CLoginUser loginUser)
{
return(ClubDAL.AddCRebateUser(loginUser));
}
public static int CancleCRebateUser(CLoginUser loginUser)
{
return(ClubDAL.CancleCRebateUser(loginUser));
}
/// <summary>
/// 添加登录用户
/// </summary>
/// <param name="loginUser"></param>
/// <returns></returns>
public static bool AddCLoginUser(CLoginUser loginUser)
{
return(ClubDAL.AddCLoginUser(loginUser) > 0);
}
