public long InsertRole(string userName, string name, byte avatar, byte sex, byte occupation, byte roleLevel, long experience, long mapID, string lastIP, string remarks)
{
using (L2SDataContext dc = new L2SDataContext()) {
return Convert.ToInt64(dc.p_InsertRole(userName, name, avatar, sex, occupation, roleLevel, experience, mapID, lastIP, "").ReturnValue);
}
}
public List<Role> GetRoleByUserName(string userName)
{
using (L2SDataContext dc = new L2SDataContext()) {
return dc.p_GetRoleByUserName(userName).ToList<Role>();
}
}
public int GetUserRoleNum(string userName)
{
using (L2SDataContext dc = new L2SDataContext()) {
return dc.p_GetUserRoleNum(userName);
}
}
public int DeleteRole(string roleName)
{
using (L2SDataContext dc = new L2SDataContext()) {
return dc.p_DeleteRole(roleName);
}
}
public int CheckUserExist(string userName)
{
using (L2SDataContext dc = new L2SDataContext()) {
return dc.p_CheckUserExist(userName);
}
}
public int CheckRoleExist(string name)
{
using (L2SDataContext dc = new L2SDataContext()) {
return dc.p_CheckRoleExist(name);
}
}
public int UserLogonValidate(string userName, string password)
{
using (L2SDataContext dc = new L2SDataContext()) {
return dc.p_CheckUserLogon(userName, password);
}
}
public long InsertUser(string userName, string password, string realName, string idCard, string eMail, string address)
{
using (L2SDataContext dc = new L2SDataContext()) {
return Convert.ToInt64(dc.p_InsertUser(userName, password, realName, idCard, eMail, address, "", "").ReturnValue);
}
}
