/// <summary>
/// 更新数据
/// </summary>
/// <param name="mi"></param>
/// <param name="isMd5Encrying"></param>
/// <returns></returns>
public int Update(ManagerInfo mi, bool isMd5Encrying)
{
string sqlText = "update ManagerInfo set MName = @Name,MPwd = @Pwd,MType = @Type where MId = @Id";
SQLiteParameter[] parameters =
{
new SQLiteParameter("@Name", DbType.String),
new SQLiteParameter("@Pwd", DbType.String),
new SQLiteParameter("@Type", DbType.Int32),
new SQLiteParameter("@Id", DbType.Int32)
};
parameters[0].Value = mi.MName;
if (isMd5Encrying)
{
parameters[1].Value = MD5Helper.Encrying(mi.MPwd);
}
else
{
parameters[1].Value = mi.MPwd;
}
parameters[2].Value = mi.MType;
parameters[3].Value = mi.MId;
return(SQLiteHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="mi"></param>
/// <returns></returns>
public int Insert(ManagerInfo mi)
{
string sqlText = "insert into ManagerInfo(MName,MPwd,MType) values(@Name,@Pwd,@Type)";
SQLiteParameter[] parameters =
{
new SQLiteParameter("@Name", DbType.String),
new SQLiteParameter("@Pwd", DbType.String),
new SQLiteParameter("@Type", DbType.Int32),
};
parameters[0].Value = mi.MName;
parameters[1].Value = MD5Helper.Encrying(mi.MPwd);
parameters[2].Value = mi.MType;
return(SQLiteHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 表示是否能成功登录
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public bool Login(string name, string pwd, out int type)
{
type = -1;
ManagerInfo mi = miDal.GetManagerInfo(name);
if (mi == null)
{
return(false);
}
string correctPwd = mi.MPwd;
if (MD5Helper.Encrying(pwd) != correctPwd)
{
return(false);
}
type = Convert.ToInt32(mi.MType);
return(true);
}
