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);
}
}
