public async Task SendPasswordResetLinkAsync(SysUsers user, string link = null)
{
if (user.PasswordResetCode.IsNullOrEmpty())
{
throw new Exception("PasswordResetCode should be set in order to send password reset link.");
}
var emailTemplate = GetTitleAndSubTitle("Restablecer contraseña", string.Empty);
var mailMessage = new StringBuilder();
mailMessage.AppendLine("<b>" + "Nombre completo" + "</b>: " + user.DisplayName + "<br />");
mailMessage.AppendLine("<b>" + "Usuario" + "</b>: " + user.DisplayName + "<br />");
//mailMessage.AppendLine("<b>" + "Codigo de Reseteo" + "</b>: " + user.PasswordResetCode + "<br />");
if (!link.IsNullOrEmpty())
{
link = link.Replace("{userId}", user.Id.ToString());
link = link.Replace("{resetCode}", Uri.EscapeDataString(user.PasswordResetCode));
mailMessage.AppendLine("<br />");
var linkHtml = "<a href=\"" + link + "\">" + "restablecer su contraseña" + "</a>";
mailMessage.AppendLine(("Por favor siga el enlace a continuación para " + linkHtml) + "<br /><br />");
//mailMessage.AppendLine("<a href=\"" + link + "\">" + "restablecer su contraseña" + "</a>");
}
await ReplaceBodyAndSend(user.Email, ("Rosario Bus | Restablecer contraseña"), emailTemplate, mailMessage);
}
private static async Task SeedAdmin(UserManager <SysUsers> userManager)
{
var u = await userManager.FindByNameAsync("admin");
if (u == null)
{
u = new SysUsers
{
UserName = "******",
Email = "*****@*****.**",
SecurityStamp = Guid.NewGuid().ToString(),
IsLock = false,
};
var x = await userManager.CreateAsync(u, "Admin1234!");
}
var uc = await userManager.GetClaimsAsync(u);
if (!uc.Any(x => x.Type == "admin"))
{
await userManager.AddClaimAsync(u, new System.Security.Claims.Claim("admin", true.ToString()));
}
if (!await userManager.IsInRoleAsync(u, "admin"))
{
await userManager.AddToRoleAsync(u, "admin");
}
}
public async Task <IActionResult> PostLogin([FromBody] SysLoginViewModel model)
{
var result = new Result();
try
{
SysUsers manager = await _userManager.FindByNameAsync(model.UserName);
var password = await _userManager.CheckPasswordAsync(manager, model.Password);
if (password)
{
result.Succeeded = true;
result.Message = "请求成功";
result.Data = _tokenProvider.GeTokenViewModel(model.UserName, manager.Id);
}
else
{
result.Code = -101;
result.Message = "用户名或密码错误！";
result.Succeeded = false;
}
}
catch (Exception e)
{
result.Code = -100;
result.Message = "数据异常";
result.Succeeded = false;
}
return(Json(result));
}
protected void btnLogin_Click(object sender, EventArgs e)
{
objAdmin.LoginId = this.texLoginId.Text.Trim();
objAdmin.LoginPwd = this.texLoginPwd.Text.Trim();
try
{
//objAdmin = new AdminService().AdminLogin(objAdmin);
objAdmin = new UserService().UserLogin(objAdmin);
if (objAdmin == null)
{
//this.ltaInfo.Text = "用户名身份或密码错误！";
}
else
{
Session["CurrentUser"] = objAdmin.LoginName;
if (objAdmin.LoginType == 1)
{
Response.Redirect("/views/TopicManage.aspx");
}
Response.Redirect("/views/Firstpage.aspx");
}
}
catch (Exception)
{
this.ltaInfo.Text = "发生异常！";
}
}
public void ProcessRequest(HttpContext context)
{
string user = context.Request.QueryString["user"];
string pass = context.Request.QueryString["pass"];
SysUsers player = DbCenter.QueryDb.SysUsers.SingleOrDefault(c => c.UserName == user && c.PassWord == pass);
if (player != null)
{
var list = from g in DbCenter.QueryDb.GameUsersGoods
join m in DbCenter.QueryDb.GameSysgoodsmodels on g.GoodsModelId equals m.ID
where g.UserId == player.ID && g.State == 0
select new Goods {
Good = g, Model = m
};
XElement node = new XElement("list");
foreach (var t in list)
{
node.Add(FlashUtils.CreateGoods(t));
}
context.Response.ContentType = "text/plain";
context.Response.Write(node.ToString(false));
}
else
{
context.Response.Write(string.Format("用户不存在:{0}", user));
}
}
public void ProcessRequest(HttpContext context)
{
string user = context.Request.Params["user"];
string pass = context.Request.Params["pass"];
XElement result = new XElement("result");
if (!string.IsNullOrEmpty(user) && !string.IsNullOrEmpty(pass))
{
SysUsers p = DbCenter.QueryDb.SysUsers.First(c => c.UserName == user && c.PassWord == pass);
if (user != null)
{
context.Response.Cookies.Add(new HttpCookie("id", p.ID.ToString()));
result.Add(new XAttribute("value", true));
}
else
{
result.Add(new XAttribute("value", false));
result.Add(new XAttribute("message", "用户名或者密码错误!"));
}
}
else
{
result.Add(new XAttribute("value", false));
result.Add(new XAttribute("message", "参数个数不正确!"));
}
context.Response.ContentType = "text/plain";
context.Response.Write(result.ToString());
}
public void ProcessRequest(HttpContext context)
{
if (!string.IsNullOrEmpty(context.Request["index"]) && !string.IsNullOrEmpty(context.Request["sceneid"]))
{
int page = Convert.ToInt32(context.Request["index"]);
var query = from w in DbCenter.QueryDb.GameUserextendwishes
select w;
query = query.Where(wh => wh.SceneId == context.Request["sceneid"].ToString());
IList <GameUserextendwishes> list = query.OrderByDescending(c => c.Indexs).Skip(page - 1).Take(1).ToList();
XElement item;
foreach (GameUserextendwishes w in list)
{
SysUsers user = DbCenter.QueryDb.SysUsers.Single(u => u.ID == w.ExtendUserId);
item = new XElement("item", new XAttribute("id", w.Id.ToString()),
new XAttribute("index", w.Indexs.ToString()),
new XAttribute("userId", w.ExtendUserId.ToString()),
new XAttribute("content", w.Content.ToString()),
new XAttribute("nickName", user.PetName),
new XAttribute("wishType", w.Wishtype.ToString()),
new XAttribute("time", w.Date.ToShortDateString()),
new XAttribute("stone", w.SceneId.ToString()),
new XAttribute("viewNums", w.ViewNum.ToString()),
new XAttribute("isAnonymity", w.IsNim.ToString())
);
context.Response.ContentType = "text/plain";
context.Response.Write(item.ToString());
}
}
}
/// <summary>
/// 登录
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <returns></returns>
public static SysUsers Login(string userName, string password)
{
SysUsers user = CommonDAO.GetInstance().GetUserByUserName(userName);
if (user == null)
{
return(null);
}
string url = "http://localhost:5000/api/TokenAuth/Authenticate"; //本地API 正式使用时改为正式API 或者改为可配置API
RSACryptoService rSACryptoService = new RSACryptoService("");
password = rSACryptoService.Encrypt(password);
var str = HttpApi(url, "{\"userNameOrEmailAddress\":\"" + userName + "\",\"password\":\"" + password + "\",\"rememberClient\":\"true\"}", "post");
if (string.IsNullOrEmpty(str))
{
return(null);
}
ApiResult result = JsonConvert.DeserializeObject <ApiResult>(str);
if (result.success)
{
return(user);
}
return(null);
}
///// <summary>首次连接数据库时初始化数据，仅用于实体类重载，用户不应该调用该方法</summary>
//[EditorBrowsable(EditorBrowsableState.Never)]
//protected override void InitData()
//{
// base.InitData();
// // InitData一般用于当数据表没有数据时添加一些默认数据，该实体类的任何第一次数据库操作都会触发该方法，默认异步调用
// // Meta.Count是快速取得表记录数
// if (Meta.Count > 0) return;
// // 需要注意的是，如果该方法调用了其它实体类的首次数据库操作，目标实体类的数据初始化将会在同一个线程完成
// if (XTrace.Debug) XTrace.WriteLine("开始初始化{0}[{1}]数据……", typeof(SysRole).Name, Meta.Table.DataTable.DisplayName);
// var entity = new SysRole();
// entity.Serialnum = "abc";
// entity.CreateTime = DateTime.Now;
// entity.CreateSysUserSerialnum = "abc";
// entity.UpdateTime = DateTime.Now;
// entity.UpdateSysUserSerialnum = "abc";
// entity.Name = "abc";
// entity.Url = "abc";
// entity.IsSystem = true;
// entity.Description = "abc";
// entity.Status = 0;
// entity.Permission = "abc";
// entity.Sort = 0;
// entity.Remark = "abc";
// entity.Insert();
// if (XTrace.Debug) XTrace.WriteLine("完成初始化{0}[{1}]数据！", typeof(SysRole).Name, Meta.Table.DataTable.DisplayName);
//}
/// <summary>已重载。删除关联数据</summary>
/// <returns></returns>
protected override int OnDelete()
{
if (SysRoleMenus != null)
{
SysRoleMenus.Delete();
}
if (SysUsers != null)
{
SysUsers.Delete();
}
return(base.OnDelete());
}
protected override void Seed(VeccContext context)
{
//初始化用户数据 没有数据库时执行一次
string salt;
var code = UtilityHelper.CreateHashCodePW(GlobalConfigHelper.GetAdminInitialPassword(), out salt);
SysUsers user = new SysUsers {
UserName = "******", RoleId = 1, AccountStatus = 3, UserType = 0, CreateDate = DateTime.Now, IsDel = 0, Password = code, Salt = salt
};
//角色基础数据
List <SysRole> sysRoles = new List <SysRole> {
new SysRole {
RoleDescribe = "vecc管理员", RoleName = "admin", IsDel = 0
},
new SysRole {
RoleDescribe = "sgs检测机构", RoleName = "sgs", IsDel = 0
},
new SysRole {
RoleDescribe = "engineer工程师", RoleName = "engineer", IsDel = 0
}
};
//基础参数设置
List <SysParams> sysParams = new List <SysParams> {
new SysParams {
ParamNumber = "001", ParamName = "数据审批状态", ParamType = "pending", ParamValue = 1, IsDel = 0
},
new SysParams {
ParamNumber = "001", ParamName = "数据审批状态", ParamType = "fail", ParamValue = 2, IsDel = 0
},
new SysParams {
ParamNumber = "001", ParamName = "数据审批状态", ParamType = "passed", ParamValue = 3, IsDel = 0
},
new SysParams {
ParamNumber = "002", ParamName = "用户审批状态", ParamType = "pending", ParamValue = 1, IsDel = 0
},
new SysParams {
ParamNumber = "002", ParamName = "用户审批状态", ParamType = "fail", ParamValue = 2, IsDel = 0
},
new SysParams {
ParamNumber = "002", ParamName = "用户审批状态", ParamType = "passed", ParamValue = 3, IsDel = 0
}
};
//保存
context.SysUser.Add(user);
context.SysRole.AddRange(sysRoles);
context.SysParams.AddRange(sysParams);
context.SaveChanges();
}
public int UserRegister(SysUsers objAdmin)
{
string LoginId = objAdmin.LoginId;
string LoginPwd = objAdmin.LoginPwd;
string LoginName = objAdmin.LoginName;
int LoginType = objAdmin.LoginType;
string sqlStr = "insert into UserInfo values('"+LoginId+"','"+LoginName+"','"+LoginPwd+"',"+LoginType+")";
int sdr = SQLHelper.Update(sqlStr);
if(sdr == 1)
{
return 1;
}
return 0;
}
private XElement CreatePlayerNode(SysUsers u)
{
return new XElement("item", new XAttribute("id", u.IdentityID),
new XAttribute("guidId", u.ID),
new XAttribute("nickName", u.PetName),
new XAttribute("sex", u.Sex),
new XAttribute("style", u.Style),
new XAttribute("styleType", u.ClassType),
new XAttribute("email", u.UserName),
new XAttribute("state", u.State),
new XAttribute("level", u.Grade),
new XAttribute("score", u.Mark),
new XAttribute("friendVerify", u.FriendVerify),
new XAttribute("sign", u.UserSign),
new XAttribute("university", ""),
new XAttribute("memberType", (bool)u.IsApprove ? 0 : 1));
}
private XElement CreatePlayerNode(SysUsers u)
{
return(new XElement("item", new XAttribute("id", u.IdentityID),
new XAttribute("guidId", u.ID),
new XAttribute("nickName", u.PetName),
new XAttribute("sex", u.Sex),
new XAttribute("style", u.Style),
new XAttribute("styleType", u.ClassType),
new XAttribute("email", u.UserName),
new XAttribute("state", u.State),
new XAttribute("level", u.Grade),
new XAttribute("score", u.Mark),
new XAttribute("friendVerify", u.FriendVerify),
new XAttribute("sign", u.UserSign),
new XAttribute("university", ""),
new XAttribute("memberType", (bool)u.IsApprove ? 0 : 1)));
}
public ActionResult Index()
{
try
{
lstSourceLoaiDTuong = new List <AutoCompleteEntry>();
// lấy dữ liệu đổ source cho combobox Loại đối tượng
List <string> lstDieuKien = new List <string>();
lstDieuKien.Add(DatabaseConstant.DanhMuc.LOAI_DTUONG_KTHAC_TNGUYEN.getValue());
DataCombobox.GenAutoComboBox(ref lstSourceLoaiDTuong, DatabaseConstant.DanhSachTruyVan.COMBOBOX_DMUC.getValue(), lstDieuKien);
var model = new SysUsers {
LstSourceLoaiDTuong = lstSourceLoaiDTuong
};
model.LstNhNsd = qtht.layNhomNSD(ClientInformation.LoaiNguoiSuDung);
return(View(model));
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
public async Task <IActionResult> Create(SysUsersCreateViewModel model)
{
if (ModelState.IsValid)
{
var entity = new SysUsers();
entity.Id = SequenceQueue.NewIdString("");
entity.UserName = model.Username;
entity.FullName = model.FullName;
entity.IsLock = false;
entity.Email = model.Email;
entity.EmailConfirmed = false;
entity.TwoFactorEnabled = false;
entity.PhoneNumber = model.Tel;
entity.PhoneNumberConfirmed = false;
entity.LockoutEnabled = true;
entity.CreateTime = DateTime.Now;
try
{
entity.Roles.Add(new SysUserRole()
{
UserId = entity.Id
});
var result = await _userManager.CreateAsync(entity, model.Password);
foreach (var error in result.Errors)
{
ModelState.AddModelError("", error.Description);
}
if (!ModelState.IsValid)
{
return(View());
}
}
catch (Exception ex)
{
throw;
}
return(Redirect("/SiteManager/SysUsers/Index"));
}
return(View());
}
public SysUsers IsAuthenticated([FromBody] SecurityTokenWrapper securityTokenWrapper)
{
JwtSecurityTokenHandler handler = new JwtSecurityTokenHandler();
JwtSecurityToken decodedToken = handler.ReadToken(securityTokenWrapper.SecurityToken) as JwtSecurityToken;
int.TryParse(decodedToken.Claims.FirstOrDefault(claim => claim.Type == "employeeId")?.Value, out int employeeId);
SysUsers user = new SysUsers
{
Username = decodedToken.Claims.FirstOrDefault(claim => claim.Type == JwtRegisteredClaimNames.GivenName)?.Value,
Email = decodedToken.Claims.FirstOrDefault(claim => claim.Type == "email")?.Value,
EmployeeId = employeeId,
IsSuperAdmin = bool.Parse(decodedToken.Claims.FirstOrDefault(claim => claim.Type == "isSuperAdmin")?.Value),
// NeedResetPassword = bool.Parse(decodedToken.Claims.FirstOrDefault(claim => claim.Type == "needResetPassword")?.Value)
};
return(user);
}
public ActionResult List(string type)
{
try
{
var model = new SysUsers {
LstSourceLoaiDTuong = lstSourceLoaiDTuong
};
if (type.Equals("NHNSD"))
{
model.LstNhNsd = qtht.layNhomNSD(ClientInformation.LoaiNguoiSuDung);
}
else if (type.Equals("NSD"))
{
model.LstNsd = qtht.layNSD(ClientInformation.LoaiNguoiSuDung);
}
return(View(model));
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
public void ProcessRequest(HttpContext context)
{
if (!string.IsNullOrEmpty(context.Request["user"]) && !string.IsNullOrEmpty(context.Request["pass"]))
{
SysUsers user = DbCenter.QueryDb.SysUsers.SingleOrDefault(u => u.Email == context.Request["user"] && u.PassWord == context.Request["pass"]);
if (user == null)
{
return;
}
XElement list = new XElement("list");
XElement item;
var glist = from g in DbCenter.QueryDb.GameUserdefinedgoods where g.UserId == user.ID && g.State == 0 select g;
foreach (GameUserdefinedgoods g in glist)
{
GameSysgoodsmodels model = DbCenter.QueryDb.GameSysgoodsmodels.SingleOrDefault(m => m.ID == g.GoodsModelId);
if (model != null)
{
item = new XElement("item", new XAttribute("id", g.ID.ToString()),
new XAttribute("posX", g.PosX.ToString()),
new XAttribute("posY", g.PosY.ToString()),
new XAttribute("dir", g.Dir.ToString()),
new XAttribute("height", model.Height),
new XAttribute("roomId", g.InObjectId),
new XAttribute("asset", model.Asset),
new XAttribute("func", model.Func),
new XAttribute("type", model.CategoryId),
new XAttribute("riseNum", g.RiseNum)
);
list.Add(item);
}
}
context.Response.ContentType = "text/plain";
context.Response.Write(list.ToString(false));
}
}
public SysUsers UserLogin(SysUsers objAdmin)
{
string LoginId = objAdmin.LoginId;
string LoginPwd = objAdmin.LoginPwd;
int LoginType = objAdmin.LoginType;
string sqlStr = "select LoginName from UserInfo where LoginId='" + LoginId + "' and LoginPwd='" + LoginPwd + "'and LoginType=" + LoginType + "";
SqlDataReader sdr = SQLHelper.GetReader(sqlStr);
if (sdr.Read())
{
objAdmin.LoginName = sdr["LoginName"].ToString();
}
else
{
objAdmin = null;
}
return objAdmin;
}
public async Task <ActionResult> Login(SysLoginViewModel model, string returnUrl = null)
{
try
{
if (!ModelState.IsValid)
{
return(View());
}
SysUsers manager = await _userManager.FindByNameAsync(model.UserName);
var result = await _userManager.CheckPasswordAsync(manager, model.Password);
switch (result)
{
case true:
if (returnUrl != null)
{
//await _signInManager.SignInAsync(manager, true);
SetCalims(model.UserName, model.Rememberme, manager.Id);
return(Redirect("~" + returnUrl));
}
else
{
//await _signInManager.SignInAsync(manager, true);
SetCalims(model.UserName, model.Rememberme, manager.Id);
}
return(Redirect("/SysManager/Home/Index"));
default:
return(View());
}
}
catch (Exception ex)
{
}
return(View());
}
///// <summary>首次连接数据库时初始化数据，仅用于实体类重载，用户不应该调用该方法</summary>
//[EditorBrowsable(EditorBrowsableState.Never)]
//protected override void InitData()
//{
// base.InitData();
// // InitData一般用于当数据表没有数据时添加一些默认数据，该实体类的任何第一次数据库操作都会触发该方法，默认异步调用
// // Meta.Count是快速取得表记录数
// if (Meta.Count > 0) return;
// // 需要注意的是，如果该方法调用了其它实体类的首次数据库操作，目标实体类的数据初始化将会在同一个线程完成
// if (XTrace.Debug) XTrace.WriteLine("开始初始化{0}[{1}]数据……", typeof(SysDepartment).Name, Meta.Table.DataTable.DisplayName);
// var entity = new SysDepartment();
// entity.Serialnum = "abc";
// entity.CreateTime = DateTime.Now;
// entity.CreateSysUserSerialnum = "abc";
// entity.UpdateTime = DateTime.Now;
// entity.UpdateSysUserSerialnum = "abc";
// entity.SysAreaSerialnum = "abc";
// entity.Name = "abc";
// entity.ParentSerialnum = "abc";
// entity.Status = 0;
// entity.Description = "abc";
// entity.Sort = 0;
// entity.Remark = "abc";
// entity.Insert();
// if (XTrace.Debug) XTrace.WriteLine("完成初始化{0}[{1}]数据！", typeof(SysDepartment).Name, Meta.Table.DataTable.DisplayName);
//}
/// <summary>已重载。删除关联数据</summary>
/// <returns></returns>
protected override int OnDelete()
{
if (AreaStations != null)
{
AreaStations.Delete();
}
if (AWProducts != null)
{
AWProducts.Delete();
}
if (CameraStationss != null)
{
CameraStationss.Delete();
}
if (Companys != null)
{
Companys.Delete();
}
if (Farms != null)
{
Farms.Delete();
}
if (SysUsers != null)
{
SysUsers.Delete();
}
if (WeatherStations != null)
{
WeatherStations.Delete();
}
if (WeatherWarns != null)
{
WeatherWarns.Delete();
}
return(base.OnDelete());
}
public void ProcessRequest(HttpContext context)
{
if (!string.IsNullOrEmpty(context.Request["id"]))
{
Guid id = new Guid(context.Request["id"]);
XElement list = new XElement("list");
XElement wish;
XElement item;
GameUserextendwishes w = DbCenter.QueryDb.GameUserextendwishes.Single(c => c.Id == id);
if (w != null)
{
w.ViewNum++;
DbCenter.QueryDb.SubmitChanges();
SysUsers u = DbCenter.QueryDb.SysUsers.Single(us => us.ID == w.ExtendUserId);
wish = new XElement("wish", new XAttribute("id", w.Id.ToString()),
new XAttribute("index", w.Indexs.ToString()),
new XAttribute("userId", w.ExtendUserId.ToString()),
new XAttribute("content", w.Content),
new XAttribute("nickName", u.PetName),
new XAttribute("wishType", w.Wishtype.ToString()),
new XAttribute("time", w.Date.ToShortDateString()),
new XAttribute("stone", w.StoneId.ToString()),
new XAttribute("viewNums", w.ViewNum.ToString()),
new XAttribute("isAnonymity", w.IsNim.ToString())
);
item = FlashUtils.CreateBaseMemberInfo(u, "");
list.Add(wish);
list.Add(item);
}
context.Response.ContentType = "text/plain";
context.Response.Write(list.ToString(false));
}
}
public void ProcessRequest(HttpContext context)
{
if (!string.IsNullOrEmpty(context.Request["user"]) && !string.IsNullOrEmpty(context.Request["pass"]) && !string.IsNullOrEmpty(context.Request["shopid"]) && !string.IsNullOrEmpty(context.Request["fitments"]))
{
int NeedMarkTal = 0, MarkTal = 0, buynum = 0;
decimal NeedVirtualMoneyTal = 0m, AccountTal = 0m;
XElement list;
XElement item;
SysUsers user = DbCenter.QueryDb.SysUsers.SingleOrDefault(u => u.Email == context.Request["user"] && u.PassWord == context.Request["pass"]);
//判断用户名与密码
if (user == null)
{
list = new XElement("list", new XAttribute("result", "false"),
new XAttribute("msg", "用户名与密码不正确")
);
context.Response.ContentType = "text/plain";
context.Response.Write(list.ToString(false));
context.Response.End();
}
MarkTal = user.Mark;
AccountTal = (decimal)user.Account;
string fitments = context.Request["fitments"];
string[] fitmentsArr = Regex.Split(fitments, ",", RegexOptions.IgnoreCase);
foreach (string i in fitmentsArr)//计算所需要的积分与金币
{
Guid id = new Guid(i.Split('|')[0]);
int count = Convert.ToInt32(i.Split('|')[1]);
GameSysgoodsmodels model = DbCenter.QueryDb.GameSysgoodsmodels.SingleOrDefault(m => m.ID == id);
if (model != null)
{
NeedMarkTal += model.NeedMark * count;
NeedVirtualMoneyTal += (decimal)model.NeedVirtualMoney * count;
}
buynum += count;
}
//判断金币与积分够
if (MarkTal < NeedMarkTal || AccountTal < NeedVirtualMoneyTal)
{
list = new XElement("list", new XAttribute("result", "false"),
new XAttribute("msg", "金币或者积分不够")
);
context.Response.ContentType = "text/plain";
context.Response.Write(list.ToString(false));
context.Response.End();
}
var query = from g in DbCenter.QueryDb.GameUserdefinedgoods where g.UserId == user.ID && g.IsInObject == false select g;
if ((query.Count() + buynum) > 1000)
{
list = new XElement("list", new XAttribute("result", "false"),
new XAttribute("msg", "仓库已满")
);
context.Response.ContentType = "text/plain";
context.Response.Write(list.ToString(false));
context.Response.End();
}
GameShops shop = DbCenter.QueryDb.GameShops.SingleOrDefault(s => s.Code == context.Request["shopid"]);
if (shop == null)
{
list = new XElement("list", new XAttribute("result", "false"),
new XAttribute("msg", "商店不存在")
);
context.Response.ContentType = "text/plain";
context.Response.Write(list.ToString(false));
context.Response.End();
}
list = new XElement("list");
foreach (string i in fitmentsArr)//计算所需要的积分与金币
{
Guid id = new Guid(i.Split('|')[0]);
int count = Convert.ToInt32(i.Split('|')[1]);
GameSysgoodsmodels model = DbCenter.QueryDb.GameSysgoodsmodels.SingleOrDefault(m => m.ID == id);
if (model != null)
{
for (int x = 0; x < count; x++)
{
GameUserdefinedgoods g = new GameUserdefinedgoods();
g.ID = Guid.NewGuid();
g.AddTime = DateTime.Now;
g.BuyDate = DateTime.Now;
g.CategoryId = Convert.ToInt32(model.CategoryId);
g.GoodsModelId = model.ID;
g.InObjectId = Guid.Empty;
g.IsInObject = false;
g.UserId = user.ID;
g.PosX = 0;
g.PosY = 0;
g.Dir = 0;
DbCenter.QueryDb.GameUserdefinedgoods.InsertOnSubmit(g);
item = new XElement("item", new XAttribute("id", g.ID),
new XAttribute("posX", g.PosX),
new XAttribute("posY", g.PosY),
new XAttribute("dir", g.Dir),
new XAttribute("height", model.Height),
new XAttribute("type", model.CategoryId),
new XAttribute("asset", model.Asset),
new XAttribute("func", model.Func)
);
list.Add(item);
}
}
}
user.Mark -= NeedMarkTal;
user.Account -= NeedVirtualMoneyTal;
DbCenter.QueryDb.SubmitChanges();
list.Add(new XAttribute("result", "true"));
list.Add(new XAttribute("msg", "true"));
list.Add(new XAttribute("spareMark", user.Mark));
list.Add(new XAttribute("spareMoney", user.Account));
context.Response.ContentType = "text/plain";
context.Response.Write(list.ToString(false));
context.Response.End();
}
}
public static SysUsersCreateViewModel ToModel(this SysUsers entity)
{
return(entity.MapTo <SysUsers, SysUsersCreateViewModel>());
}
public void ProcessRequest(HttpContext context)
{
//if (!string.IsNullOrEmpty(context.Request["keyword"]))
//{
string keyword = context.Request["keyword"];
int page = 1, totalpage = 0;
if (!string.IsNullOrEmpty(context.Request["page"]))
{
page = Convert.ToInt32(context.Request["page"]);
}
int type = 0;
if (!string.IsNullOrEmpty(context.Request["type"]))
{
type = Convert.ToInt32(context.Request["type"]);
}
var query = from w in DbCenter.QueryDb.GameUserextendwishes
join u in DbCenter.QueryDb.SysUsers on w.ExtendUserId equals u.ID
join s in DbCenter.QueryDb.GameScenes on w.SceneId equals s.ID
orderby w.Indexs descending
select new UserWish {
User = u, SceneId = s.ID, Wish = w
};
switch (type)
{
case 0:
break;
case 1:
SysUsers user = DbCenter.QueryDb.SysUsers.Single(u => u.ID == new Guid(keyword));
query = query.Where(u => u.User.SchoolId == user.SchoolId);
break;
case 2:
query = query.Where(u => u.User.Sex == true);
break;
case 3:
query = query.Where(u => u.User.Sex == false);
break;
case 4:
query = query.Where(u => u.User.PetName.Equals(keyword));
break;
case 5:
query = query.Where(u => u.User.TrueName.Equals(keyword));
break;
case 6:
query = query.Where(u => u.User.Email.Equals(keyword));
break;
}
if (!string.IsNullOrEmpty(context.Request["sceneid"]))
{
query = query.Where(w => w.SceneId == context.Request["sceneid"].ToString());
}
int totalcout = query.Count();
if ((totalcout % 8) != 0)
{
totalpage = (totalcout / 8) + 1;
}
else
{
totalpage = totalcout / 8;
}
IList <UserWish> list = query.Take(page * 8).Except(query.Take((page - 1) * 8)).ToList();
XElement node = new XElement("list");
foreach (UserWish i in list)
{
node.Add(new XElement("item", new XAttribute("id", i.Wish.Id.ToString()),
new XAttribute("index", i.Wish.Indexs.ToString()),
new XAttribute("userId", i.Wish.ExtendUserId.ToString()),
new XAttribute("content", i.Wish.Content),
new XAttribute("nickName", i.User.PetName),
new XAttribute("wishType", i.Wish.Wishtype.ToString()),
new XAttribute("time", i.Wish.Date.ToShortDateString()),
new XAttribute("stone", i.Wish.StoneId.ToString()),
new XAttribute("viewNums", i.Wish.ViewNum.ToString()),
new XAttribute("isAnonymity", i.Wish.IsNim.ToString()),
new XAttribute("totalPages", totalpage.ToString())
));
}
//context.Response.Write(totalcout.ToString());
context.Response.ContentType = "text/plain";
context.Response.Write(node.ToString(false));
//}
}
public int Update(SysUsers sysUser)
{
return(_dbServiceReposity.Update(sysUser));
}
public int Insert(SysUsers sysUser)
{
return(_dbServiceReposity.Add(sysUser));
}
public void ProcessRequest(HttpContext context)
{
if (!string.IsNullOrEmpty(context.Request["id"]))
{
Guid id = new Guid(context.Request.Params["id"]);
SysUsers u = DbCenter.QueryDb.SysUsers.Single(c => c.ID == id);
if (u != null)
{
var f1 = from f in DbCenter.QueryDb.UserFriends
where f.UserID == u.ID
group f by f.UserID into g
select g.Count();
var f2 = from f in DbCenter.QueryDb.UserFriends
where f.FriendID == u.ID
group f by f.FriendID into g
select g.Count();
BlogBlogers blog = DbCenter.QueryDb.BlogBlogers.SingleOrDefault(c => c.UserId == u.ID);
var bbs = from c in DbCenter.QueryDb.BbsUserinf
where c.UserID == u.ID
select c.BbsArticlesAnswers;
var study = from s in DbCenter.QueryDb.UserStudyrecord
where s.UserID == u.ID
select s;
int hotByBlog = blog == null ? 0 : blog.DiarViewCount + blog.PhotoViewCount;
int hotByBbs = bbs.SingleOrDefault() * 2 + u.LookedNumInGame;
int hotByFriends = f1.SingleOrDefault() + f2.SingleOrDefault() * 3;
UserStudyrecord re = DbCenter.QueryDb.UserStudyrecord.Single(c => c.UserID == u.ID);
SysUniversityprofessionals pro = DbCenter.QueryDb.SysUniversityprofessionals.SingleOrDefault(c => c.Id == re.Professional);
SchoolRoominghouses house = DbCenter.QueryDb.SchoolRoominghouses.SingleOrDefault(c => c.Id == re.UniversityRoomingHouses);
XElement list = new XElement("list");
XElement node = new XElement("player", new XElement("item", new XAttribute("id", u.IdentityID),
new XAttribute("guidId", u.ID),
new XAttribute("nickName", u.PetName),
new XAttribute("realName", u.TrueName),
new XAttribute("sex", u.Sex),
new XAttribute("style", u.Style),
new XAttribute("styleType", u.ClassType),
new XAttribute("email", u.UserName),
new XAttribute("state", u.State),
new XAttribute("level", u.Grade),
new XAttribute("score", u.Mark),
new XAttribute("friendVerify", u.FriendVerify),
new XAttribute("sign", u.UserSign == null ? "" : u.UserSign),
new XAttribute("university", re.UniversityName),
new XAttribute("universityId", u.SchoolId),
new XAttribute("memberType", (bool)u.IsApprove ? 0 : 1),
new XAttribute("country", u.Country == null ? "" : u.Country),
new XAttribute("age", u.Age),
new XAttribute("city", u.City == null ? "" : u.City),
new XAttribute("province", u.Provice == null ? "" : u.Provice),
new XAttribute("highSchool", re.SeniorName == null ? "" : re.SeniorName),
new XAttribute("blood", u.BloodType == null ? "" : u.BloodType),
new XAttribute("hotPoint", hotByBbs + hotByBlog + hotByFriends),
new XAttribute("hotPointByBlog", hotByBlog),
new XAttribute("hotPointByBbs", hotByBbs),
new XAttribute("hotPointByFriend", hotByFriends),
new XAttribute("introduce", u.Introduction == null ? "" : u.Introduction),
new XAttribute("birthday", u.Birthday == null ? "" : u.Birthday.ToString()),
new XAttribute("star", u.StarSigns == null ? "" : u.StarSigns),
new XAttribute("animal", u.BirthPet == null ? "" : u.BirthPet),
new XAttribute("univerYear", re.UniversityScope == null ? "" : re.UniversityScope.ToString()),
new XAttribute("department", re.DepartMentName == null ? "" : re.DepartMentName),
new XAttribute("profession", pro == null ? "" : pro.ProfessionalName),
new XAttribute("dorm", house == null ? "" : house.HouseName),
new XAttribute("figureURL", u.XxBigPicUrl == null ? "" : u.XxBigPicUrl),
new XAttribute("highSchoolYear", re.SeniorName == null?"":re.SeniorName),
new XAttribute("high_one", re.SeniorOneClass == null?"":re.SeniorOneClass),
new XAttribute("high_two", re.SeniorSecondClass == null?"":re.SeniorSecondClass),
new XAttribute("high_three", re.SeniorThreeClass == null?"":re.SeniorThreeClass),
new XAttribute("junior", re.UniorSchoolName == null?"":re.UniorSchoolName),
new XAttribute("juniorYear", re.UniorScope),
new XAttribute("grade", re.PrimarySchool == null?"":re.PrimarySchool),
new XAttribute("gradeYear", re.PrimaryScope == null?"":re.PrimaryScope.ToString()),
new XAttribute("studentKind", re.UniversityKind == null?"":re.UniversityKind)
));
list.Add(node);
XElement diary = new XElement("diarylist");
XElement photo = new XElement("photolist");
if (blog != null)
{
var dl = from d in DbCenter.QueryDb.BlogerDiars
where d.UserId == id
orderby d.AddTime
select d;
foreach (BlogerDiars b in dl.Take(4))
{
diary.Add(new XElement("item", new XAttribute("Id", b.ID),
new XAttribute("Title", b.Title),
new XAttribute("Url", string.Format("blog/TheDiar.aspx?diarid={0}", b.ID)),
new XAttribute("ViewCount", b.ViewCount),
new XAttribute("CommentCount", b.CommentCount)));
}
var pl = from f in DbCenter.QueryDb.AlbumPhotos
where f.UserId == id
orderby f.AddTime
select f;
foreach (AlbumPhotos p in pl.Take(4))
{
photo.Add(new XElement("item", new XAttribute("Id", p.ID),
new XAttribute("PicPath", p.SmallXxPicPath.Replace("../", "")),
new XAttribute("Url", string.Format("blog/ThisPhoto.aspx?photoid={0}&bloger={1}", p.ID, blog.BlogName))));
}
}
list.Add(diary);
list.Add(photo);
context.Response.ContentType = "text/plain";
context.Response.Write(list.ToString(false));
}
}
}
