public string Login(string phoneNumber, string password) { IMeiWei.BLL.user bll_user = new IMeiWei.BLL.user(); IMeiWei.Model.user model_user = new IMeiWei.Model.user(); model_user = bll_user.GetModelList(" phoneNumber = '" + phoneNumber + "'").FirstOrDefault(); if (null != model_user) { if (model_user.Password != password) { return("PASSWORD_ERROR"); } else { string tokenId = Guid.NewGuid().ToString(); Session.Add(tokenId, phoneNumber); return(tokenId); } } else { return("USERNAME_ERROR"); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(IMeiWei.Model.user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into user("); strSql.Append("UserName,Password,UserStatusId,SecurityCode,IsActive,PhoneNumber)"); strSql.Append(" values ("); strSql.Append("@UserName,@Password,@UserStatusId,@SecurityCode,@IsActive,@PhoneNumber)"); MySqlParameter[] parameters = { new MySqlParameter("@UserName", MySqlDbType.VarChar, 255), new MySqlParameter("@Password", MySqlDbType.VarChar, 255), new MySqlParameter("@UserStatusId", MySqlDbType.Int32, 11), new MySqlParameter("@SecurityCode", MySqlDbType.VarChar, 255), new MySqlParameter("@IsActive", MySqlDbType.Bit), new MySqlParameter("@PhoneNumber", MySqlDbType.VarChar, 11) }; parameters[0].Value = model.UserName; parameters[1].Value = model.Password; parameters[2].Value = model.UserStatusId; parameters[3].Value = model.SecurityCode; parameters[4].Value = model.IsActive; parameters[5].Value = model.PhoneNumber; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IMeiWei.Model.user DataRowToModel(DataRow row) { IMeiWei.Model.user model = new IMeiWei.Model.user(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = long.Parse(row["Id"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["Password"] != null) { model.Password = row["Password"].ToString(); } if (row["UserStatusId"] != null && row["UserStatusId"].ToString() != "") { model.UserStatusId = int.Parse(row["UserStatusId"].ToString()); } if (row["SecurityCode"] != null) { model.SecurityCode = row["SecurityCode"].ToString(); } if (row["IsActive"] != null && row["IsActive"].ToString() != "") { if ((row["IsActive"].ToString() == "1") || (row["IsActive"].ToString().ToLower() == "true")) { model.IsActive = true; } else { model.IsActive = false; } } if (row["PhoneNumber"] != null) { model.PhoneNumber = row["PhoneNumber"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IMeiWei.Model.user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update user set "); strSql.Append("UserName=@UserName,"); strSql.Append("Password=@Password,"); strSql.Append("UserStatusId=@UserStatusId,"); strSql.Append("SecurityCode=@SecurityCode,"); strSql.Append("IsActive=@IsActive,"); strSql.Append("PhoneNumber=@PhoneNumber"); strSql.Append(" where Id=@Id"); MySqlParameter[] parameters = { new MySqlParameter("@UserName", MySqlDbType.VarChar, 255), new MySqlParameter("@Password", MySqlDbType.VarChar, 255), new MySqlParameter("@UserStatusId", MySqlDbType.Int32, 11), new MySqlParameter("@SecurityCode", MySqlDbType.VarChar, 255), new MySqlParameter("@IsActive", MySqlDbType.Bit), new MySqlParameter("@PhoneNumber", MySqlDbType.VarChar, 11), new MySqlParameter("@Id", MySqlDbType.Int64, 20) }; parameters[0].Value = model.UserName; parameters[1].Value = model.Password; parameters[2].Value = model.UserStatusId; parameters[3].Value = model.SecurityCode; parameters[4].Value = model.IsActive; parameters[5].Value = model.PhoneNumber; parameters[6].Value = model.Id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public string Registration(string phoneNumber, string password, string securityNumber, string userName) { IMeiWei.BLL.user bll_user = new IMeiWei.BLL.user(); IMeiWei.Model.user model_user = new IMeiWei.Model.user(); List <IMeiWei.Model.user> old_model_users = new List <IMeiWei.Model.user>(); old_model_users = bll_user.GetModelList(" phoneNumber = '" + phoneNumber + "'"); if (null != old_model_users && old_model_users.Count > 0) { return("DUPLICATE"); } model_user.IsActive = false; model_user.Password = password; model_user.SecurityCode = securityNumber; model_user.UserName = userName; model_user.UserStatusId = 1; model_user.PhoneNumber = phoneNumber; bll_user.Add(model_user); return("SUCCESS"); }
/// <summary> /// 得到一个对象实体 /// </summary> public IMeiWei.Model.user GetModel(long Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,UserName,Password,UserStatusId,SecurityCode,IsActive,PhoneNumber from user "); strSql.Append(" where Id=@Id"); MySqlParameter[] parameters = { new MySqlParameter("@Id", MySqlDbType.Int64) }; parameters[0].Value = Id; IMeiWei.Model.user model = new IMeiWei.Model.user(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }