protected BaseMasterPage()
: base()
{
isUserLogined = false;
currentUser = User.GetCurrentUserCookieInfo();
if (currentUser != null)
{
isUserLogined = true;
}
}
/// <summary>
/// ��֤һ���û��Ƿ���Ч
/// </summary>
/// <param name="email">�û��ʼ���ַ</param>
/// <param name="password">��¼����</param>
/// <param name="uc">UserCookieInfoʵ��</param>
/// <returns></returns>
public static bool IsUser(string email, string password, out UserCookieInfo uc)
{
/*
INV_IsUser
@email varchar(50),
@pass varchar(50)
*/
//[Id],[Email],[Name]
bool bln = false;
int _id;
string _name, _email;
uc = null;
using (SqlDataReader reader = Database.ExecuteReader(CommandType.StoredProcedure, "INV_IsUser",
new SqlParameter[] {
Database.MakeInParam("@email",SqlDbType.VarChar,50,email),
Database.MakeInParam("@param",SqlDbType.VarChar,50,Util.MD5(password))
}))
{
if (reader.Read())
{
_id = reader.GetInt32(0);
_email = reader.GetString(1);
_name = reader.GetString(2);
bln = true;
uc = new UserCookieInfo(_id, _name, _email);
}
reader.Close();
}
return bln;
}
public static UserCookieInfo Get()
{
UserCookieInfo info=null;
if (Cookies.HasCookie(COOKIE_NAME))
{
info = new UserCookieInfo();
try
{
info.id = Convert.ToInt32(Cookies.GetCookieValue(COOKIE_NAME, "ID"));
info.name = Cookies.GetCookieValue(COOKIE_NAME, "NAME");
info.email = Cookies.GetCookieValue(COOKIE_NAME, "EMAIL");
}
catch
{
//
}
}
return info;
}
/// <summary>
/// ���һ�����û�
/// </summary>
/// <param name="u">�û�ʵ��</param>
/// <param name="autoLogin">��ӳɹ����Ƿ��Զ���¼</param>
/// <returns>���û�ID</returns>
public static int AddNew(User u,bool autoLogin)
{
/*
INV_UserAddNew
@email varchar(50),
@pass varchar(50),
@name varchar(10),
@telephone varchar(20)='',
@cellphone varchar(15)='',
@status smallint=1
*/
SqlParameter[] prams = new SqlParameter[] {
Database.MakeReturnValueParam("@returnValue"),
Database.MakeInParam("@email",SqlDbType.VarChar,50,u.email),
Database.MakeInParam("@pass",SqlDbType.VarChar,50,Util.MD5(u.password)),
Database.MakeInParam("@name",SqlDbType.VarChar,10,u.name),
Database.MakeInParam("@telephone",SqlDbType.VarChar,20,u.telephone),
Database.MakeInParam("@cellphone",SqlDbType.VarChar,15,u.cellphone),
Database.MakeInParam("@status",SqlDbType.SmallInt,u.status)
};
int ret = Database.ExecuteNonQuery(CommandType.StoredProcedure, "INV_UserAddNew", prams);
u.id = ret;
if (ret>0 && autoLogin)
{
UserCookieInfo uc = new UserCookieInfo(u);
}
return ret;
}