public ActionResult AdminApply(int id, int state, string msg)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
Supervise model = db.T_Supervise.Find(id);
var vol = db.T_Vol;
Vol vEntity = vol.Find(model.AddUser);
if (model.State != SuperviseRowState.已回复)
{
vEntity.LoveBankScore = vEntity.LoveBankScore + 5;
db.Update<Vol>(vEntity);
db.SaveChanges();
}
model.Msg = msg.Trim();
model.State = (SuperviseRowState)state;
db.Update<Supervise>(model);
db.SaveChanges();
#region 发送通知信息
//短信通知
//string failMsg = "【社区1＋1】您于" + model.AddTime.ToString("yyyy-MM-dd HH:mm") + "投诉的:" + model.Content + ".管理员处理,处理意见是:" + msg;
SMSComm.Send(vEntity.Phone, "【社区1＋1】您于" + model.AddTime.ToString("yyyy-MM-dd HH:mm") + "反映的问题我们将尽快核实处理，感谢您的参与.");
//App 推送通知待完善
#endregion
}
return Success("操作成功");
}
public ActionResult AppPostAddSuggestion(Suggestion entity)
{
JsonMessage retJson = new JsonMessage();
using (LoveBankDBContext db = new LoveBankDBContext())
{
if (entity.AddUser>0)
{
var addUserModel = (from v in db.T_Vol where v.ID == entity.AddUser select new { v.DepId, v.Phone, v.RealName }).FirstOrDefault();
entity.DepId = addUserModel.DepId;
entity.AddUserName = addUserModel.RealName;
entity.AddUserPhone = addUserModel.Phone;
}
entity.AddTime = DateTime.Now;
db.Add<Suggestion>(entity);
db.SaveChanges();
retJson.Status = true;
retJson.Info = "新增成功";
}
return Json(retJson);
}
public ActionResult AppPostTSAdd(Supervise entity)
{
JsonMessage retJson = new JsonMessage();
try
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
entity.AddTime = DateTime.Now;
db.Add(entity);
db.SaveChanges();
retJson.Status = true;
retJson.Info = "新增成功";
}
return Json(retJson);
}
catch (Exception ex)
{
retJson.Status = false;
retJson.Data = ex.Message + ex.TargetSite;
return Json(retJson);
}
}
/// <summary>
/// 必传参数
/// AppUserId/
/// SeekHelperId/
/// Money:捐助的金额
/// BankCard：支付卡号
/// Desc：捐赠寄语
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ActionResult AppPostHelperMoney(SeekHelperRecorde entity)
{
JsonMessage ret = new JsonMessage();
entity.AddTime = DateTime.Now;
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_a = db.T_SeekHelper;
var t_sr = db.T_SeekHelperRecorde;
var t_u = db.T_AppUser; ;
//SeekHelper sh = t_a.Find(entity.SeekHelperId);
AppUser au = t_u.Find(entity.AppUserId);
entity.Name = au.Name;
entity.Phone = au.Phone;
entity.AppUserType = au.Type;
db.Add(entity);
db.SaveChanges();
ret.Status = true;
ret.Info = "捐助成功";
return Json(ret);
}
}
public ActionResult Delete(int id)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
AdminUser user = db.T_AdminUser.Find(id);
db.Delete<AdminUser>(user);
db.SaveChanges();
return Success("操作成功");
}
}
public ActionResult Delete(int id)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
Notice notice = db.T_Notice.Find(id);
db.Delete<Notice>(notice);
db.SaveChanges();
db.Dispose();
return Success("操作成功");
}
}
public ActionResult Delete(int id)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
AppVer img = db.T_AppVer.Find(id);
db.Delete<AppVer>(img);
db.SaveChanges();
db.Dispose();
return Success("操作成功");
}
}
public ActionResult ChangeStateAdImg(int id, int state)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
AppVer img = db.T_AppVer.Find(id);
img.State = state;
db.Update<AppVer>(img);
db.SaveChanges();
db.Dispose();
return Success("操作成功");
}
}
public ActionResult Delete(int id)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_i = db.T_InfoManage;
InfoManage iEntity = t_i.Find(id);
iEntity.State = RowState.删除;
db.Update(iEntity);
db.SaveChanges();
return Success("删除成功");
}
}
public ActionResult PostAddSupervise(Supervise entity)
{
JsonMessage retJson = new JsonMessage();
entity.DepId = BaseWebSiteConifg.DeptId;
using (LoveBankDBContext db = new LoveBankDBContext())
{
if (User != null)
{
entity.AddUserName = User.RealName;
entity.AddUserPhone = User.Phone;
entity.AddUser = User.ID;
}
entity.AddTime = DateTime.Now;
db.Add<Supervise>(entity);
db.SaveChanges();
retJson.Status = true;
retJson.Info = "提交成功";
}
return Json(retJson);
}
public ActionResult PostEdit(UnitInfoAbout parm)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_wsn = db.T_UnitInfoAbout;
UnitInfoAbout model= (from w in t_wsn where w.DeptId == AdminUser.DeptId select w).FirstOrDefault();
if (model==null)
{
parm.AddUserId = AdminUser.ID;
parm.DeptId = AdminUser.DeptId;
parm.AddTime = DateTime.Now;
parm.State = RowState.有效;
db.Add(parm);
db.SaveChanges();
return Success("保存成功");
}
//UnitInfoAbout model = t_wsn.Find(parm.ID);
model.Sort = parm.Sort;
model.Address = parm.Address;
model.Title = parm.Title;
model.Content = parm.Content;
model.EMail = parm.EMail;
model.Fax = parm.Fax;
model.Type = parm.Type;
model.UnitName = parm.UnitName;
db.Update(model);
db.SaveChanges();
return Success("保存成功");
}
}
public ActionResult PostAddDetail(UnionHelpPojectDetail parm)
{
#region 初始化参数
//LoveBank_Ad model = new LoveBank_Ad();
parm.AddTime = DateTime.Now;
parm.AddUserId = AdminUser.ID;
parm.State = RowState.有效;
#endregion
JsonMessage rJson = new JsonMessage();
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.Add(parm);
db.SaveChanges();
rJson.Status = true;
rJson.Info = "新增成功";
rJson.Data = parm;
return Json(rJson);
}
}
public ActionResult PostAdd(UnionHelpPoject parm)
{
#region 初始化参数
//LoveBank_Ad model = new LoveBank_Ad();
parm.AddTime = DateTime.Now;
parm.AddUserId = AdminUser.ID;
parm.State = RowState.有效;
parm.GUID = Guid.NewGuid().ToString();
#endregion
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.Add(parm);
db.SaveChanges();
return Success("添加成功");
}
}
/// <summary>
/// 机器注册接口
/// </summary>
/// <param name="model"></param>
/// <param name="phone"></param>
/// <returns></returns>
public ActionResult App_MachineReg(Machine model, string phone)
{
model.AddTime = DateTime.Now;
model.State = RowState.有效;
model.AddUserId = -1;
JsonMessage retJson = new JsonMessage();
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_a = db.T_AdminUser;
var t_m = db.T_Machine;
if (t_m.Count(x => x.MachineCode == model.MachineCode) > 0)
{
retJson.Status = false;
retJson.Info = "该设备已经注册";
return Json(retJson);
}
if (t_a.Count(x => x.Phone == phone) == 0)
{
retJson.Status = false;
retJson.Info = "手机号不存在";
return Json(retJson);
}
db.Add<Machine>(model);
db.SaveChanges();
if (db.T_MachineModuleShowManage.Count(x => x.DeptId == model.DeptId) == 0)
{
///初始化模块 积分商城：JFSC
MachineModuleShowManage initMachineModule1 = new MachineModuleShowManage()
{
Name = "积分商城",
ModuleKey = "JFSC",
DeptId = model.DeptId,
AddTime = DateTime.Now,
AddUserId = -1,
Guid = "e96fdf19-465c-4190-b47b-27a9af8ecfd4",
Icon = "http://www.24hmart.cn:8082/iplustv/shouye/jfsc.png"
};
///初始化模块 社区公益：SQGY
MachineModuleShowManage initMachineModule2 = new MachineModuleShowManage()
{
Name = "社区公益",
ModuleKey = "SQGY",
DeptId = model.DeptId,
AddTime = DateTime.Now,
AddUserId = -1,
Guid = "bb2ee2e2-3487-4853-846c-75f71558e389",
Icon = "http://www.24hmart.cn:8082/iplustv/shouye/sqgy.png"
};
///初始化模块 网格员：WGY
MachineModuleShowManage initMachineModule3 = new MachineModuleShowManage()
{
Name = "网格员",
ModuleKey = "WGY",
DeptId = model.DeptId,
AddTime = DateTime.Now,
AddUserId = -1,
Guid = "e5eafdf6-076f-4ac7-9fd0-38d3c935dd0c",
Icon = "http://www.24hmart.cn:8082/iplustv/shouye/wgy.png"
};
#region 初始化数据
///初始化模块 办事指南：BSZN
MachineModuleShowManage initMachineModule4 = new MachineModuleShowManage()
{
Name = "办事指南",
ModuleKey = "BSZN",
DeptId = model.DeptId,
AddTime = DateTime.Now,
AddUserId = -1,
Guid = "d2ffce6d-9a2a-4f12-869d-5962b18b571e",
Icon = "http://www.24hmart.cn:8082/iplustv/shouye/bszn.png"
};
///初始化模块 社区动态：SQDT
MachineModuleShowManage initMachineModule5 = new MachineModuleShowManage()
{
Name = "社区动态",
ModuleKey = "SQDT",
DeptId = model.DeptId,
AddTime = DateTime.Now,
AddUserId = -1,
Guid = "de359c69-c7e1-410d-8291-f8717198bc82",
Icon = "http://www.24hmart.cn:8082/iplustv/shouye/sqdt.png"
};
///初始化模块 生活圈：SHQ
MachineModuleShowManage initMachineModule6 = new MachineModuleShowManage()
{
Name = "生活圈",
ModuleKey = "SHQ",
DeptId = model.DeptId,
AddTime = DateTime.Now,
AddUserId = -1,
Guid = "4b6eadc8-48d8-48d9-bd2b-623717d45406",
Icon = "http://www.24hmart.cn:8082/iplustv/shouye/shq.png"
};
///初始化模块 志愿者风采：ZYZFC
MachineModuleShowManage initMachineModule7 = new MachineModuleShowManage()
{
Name = "志愿者风采",
ModuleKey = "ZYZFC",
DeptId = model.DeptId,
AddTime = DateTime.Now,
AddUserId = -1,
Guid = "a1581632-87aa-43e0-9b1a-78a3353c1d54",
Icon = "http://www.24hmart.cn:8082/iplustv/shouye/zyzfc.png"
};
///初始化模块 书记主任信箱：SJZRXX
MachineModuleShowManage initMachineModule8 = new MachineModuleShowManage()
{
Name = "书记主任信箱",
ModuleKey = "SJZRXX",
DeptId = model.DeptId,
AddTime = DateTime.Now,
AddUserId = -1,
Guid = "682f93c7-b9fa-427e-8c8f-cff0632e87be",
Icon = "http://www.24hmart.cn:8082/iplustv/shouye/sjzrxx.png"
};
#endregion
db.Add(initMachineModule1);
db.Add(initMachineModule2);
db.Add(initMachineModule3);
db.Add(initMachineModule4);
db.Add(initMachineModule5);
db.Add(initMachineModule6);
db.Add(initMachineModule7);
db.Add(initMachineModule8);
db.SaveChanges();
}
retJson.Status = true;
retJson.Info = "机器注册成功";
return Json(retJson);
}
}
public ActionResult AppUserReg(AppUser user, string code)
{
if (user == null || string.IsNullOrEmpty(code) || user.Type == null || string.IsNullOrEmpty(user.PassWord) && string.IsNullOrEmpty(user.Phone))
{
Json("注册账号、密码、验证码和用户类型是必填项");
}
user.PassWord = user.PassWord.Hash();//hash
user.AddTime = DateTime.Now;
user.LastLoginTime = DateTime.Now;
JsonMessage returnJson = new JsonMessage();
using (LoveBankDBContext db = new LoveBankDBContext())
{
try
{
if (db.T_AppUser.Count(x => x.Phone == user.Phone) > 0)
{
returnJson.Info = "该手机号已经存在,不能注册";
returnJson.Status = false;
return Json(returnJson);
}
DateTime codeOutTime = DateTime.Now.AddMinutes(-10);
int existCount = db.T_SMS.Count(x => x.Phone == user.Phone.Trim() && x.VCode == code.Trim() && x.Class == SmsClass.注册验证码 && x.AddTime > codeOutTime);
if (existCount == 0)
{
returnJson.Info = "注册验证码失效,请重新获取";
returnJson.Status = false;
return Json(returnJson);
}
db.Add(user);
db.SaveChanges();
returnJson.Status = true;
returnJson.Info = "注册成功";
returnJson.Data = user;
return Json(returnJson);
}
catch (Exception ex)
{
returnJson.Info = ex.Message;
returnJson.Status = false;
return Json(returnJson);
}
}
}
public ActionResult App_UpdateUser(AppUser user)
{
JsonMessage returnJson = new JsonMessage();
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_a = db.T_AppUser;
AppUser entityAppUser = db.T_AppUser.Where(x=>x.ID==user.ID).FirstOrDefault();
entityAppUser.Age = user.Age;
entityAppUser.Name = user.Name;
entityAppUser.NickName = user.NickName;
entityAppUser.Sex = user.Sex;
db.Update(entityAppUser);
db.SaveChanges();
returnJson.Status = true;
returnJson.Info = "修改成功";
returnJson.Data = HttpContext.Error;
return Json(returnJson);
}
returnJson.Status = false;
returnJson.Info = "登录失败,系统异常";
returnJson.Data = HttpContext.Error;
return Json(returnJson);
}
public ActionResult PostAdd(TeamProjectModel parm)
{
#region 初始化参数
TeamProject model = new TeamProject();
model.AddTime = DateTime.Now;
model.AddUserId = AdminUser.ID;
model.State = RowState.有效;
model.Name = parm.Name;
model.Desc = parm.Desc;
model.Type = parm.Type;
//model.RecruitStartDate = parm.RecruitStartDate;
//model.RecruitEndDate = parm.RecruitEndDate;
model.RecruitStartDate = parm.ProjectStartDate;
model.RecruitEndDate = parm.ProjectEndDate;
model.ProjectStartDate = parm.ProjectStartDate;
model.ProjectEndDate = parm.ProjectEndDate;
model.ServiceDate = parm.ServiceDate;
model.Address = parm.Address;
model.ServiceObject = parm.ServiceObject;
model.HtmlUrl = parm.HtmlUrl;
model.LinkMan = parm.LinkMan;
model.LinkPhone = parm.LinkPhone;
model.Score = parm.Score;
model.CommentSocre = parm.CommentSocre;
model.GoodScore = parm.GoodScore;
model.ShareScore = parm.ShareScore;
//model.DeptId = parm.DeptId;
model.DeptId = AdminUser.DeptId;
#endregion
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.Add(model);
db.SaveChanges();
if (parm.SourceFileList != null)
{
foreach (var item in parm.SourceFileList)
{
item.Guid = model.Guid;
item.AddTime = DateTime.Now;
}
db.T_SourceFile.AddRange(parm.SourceFileList);
db.SaveChanges();
}
return Success("添加成功");
}
}
public ActionResult PostAdd(CServiceCenterInfo model)
{
#region 初始化参数
model.AddUserId = AdminUser.ID;
model.DeptId = AdminUser.DeptId;
model.AddTime = DateTime.Now;
model.State = RowState.有效;
#endregion
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.Add(model);
db.SaveChanges();
return Success("添加成功");
}
}
public ActionResult PostRegister(string phone, string Password, string Validate)
{
//if (!phone.MatchAndNotNull(RegularUtil.Phone)) return Error("手机号错误");
var cookie = Request.Cookies["PostRegister_valicode"];
if (cookie == null)
{
return Error("验证码错误.");
}
var cookieValue = cookie.Value;
if (Validate.Hash().Hash() != cookieValue)
{
ModelState.AddModelError("", "验证码错误!");
return Error("验证码错误.");
}
try
{
Vol model = new Vol();
model.RealNameState = 1;
model.State = 1;
model.Type = "志愿者";
model.LoveBankScore = 0;
model.Score = 0;
model.Source = 2;//来源未2标示是爱心银行网站
model.Phone = phone;
model.PassWord = Password;
using (LoveBankDBContext db = new LoveBankDBContext())
{
var tv = db.T_Vol;
if (tv.Count(x => x.Phone == model.Phone) > 0)
{
return Error("该手机号已经存在");
}
db.Add<Vol>(model);
db.SaveChanges();
}
_authenticationService.SignIn(model.ID.ToString(), false);
ViewData["Jump"] = Url.Action("Index", "Home");
//return Redirect("~/");
return RedirectToAction("RegSuccess");
}
catch (Exception ex)
{
return Error(ex.Message);
}
}
/// <summary>
/// 注册验证码
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ActionResult AppRegSMS(string phone)
{
JsonMessage ret = new JsonMessage();
Random rad = new Random();//实例化随机数产生器rad；
int value = rad.Next(1000, 10000);//用rad生成大于等于1000，小于等于9999的随机数；
string code = value.ToString();
//[微愿]你的验证码是xxxx
string msg = "【微愿】你的注册码是" + code + "。";
SMS entity = new SMS();
entity.AddTime = DateTime.Now;
entity.Msg = msg;
entity.VCode = code.Trim();
entity.Class = SmsClass.注册验证码;
entity.Phone = phone;
JsonMessage retMSM = SMSComm.Send(entity.Phone, msg);
if (retMSM.Status == true)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.Add<SMS>(entity);
db.SaveChanges();
retMSM.Info = "发送成功";
}
}
else
{
retMSM.Info = "发送失败." + retMSM.Info;
}
return Json(retMSM);
}
public ActionResult PostEdit(CServiceCenterInfo parm)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_wsn = db.T_CServiceCenterInfo;
CServiceCenterInfo model = t_wsn.Find(parm.ID);
model.Sort = parm.Sort;
model.Type = parm.Type;
model.Title = parm.Title;
model.Content = parm.Content;
db.Update(model);
db.SaveChanges();
return Success("修改成功");
}
}
public ActionResult PostEdit(TeamProjectModel parm)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
var am = db.T_TeamProject;
var t_s = db.T_SourceFile;
TeamProject model = am.Find(parm.ID);
model.Name = parm.Name;
model.Desc = parm.Desc;
model.Type = parm.Type;
//model.RecruitStartDate = parm.RecruitStartDate;
//model.RecruitEndDate = parm.RecruitEndDate;
model.ProjectStartDate = parm.ProjectStartDate;
model.ProjectEndDate = parm.ProjectEndDate;
model.ServiceDate = parm.ServiceDate;
model.Address = parm.Address;
model.ServiceObject = parm.ServiceObject;
model.HtmlUrl = parm.HtmlUrl;
model.LinkMan = parm.LinkMan;
model.LinkPhone = parm.LinkPhone;
model.Score = parm.Score;
model.CommentSocre = parm.CommentSocre;
model.GoodScore = parm.GoodScore;
model.ShareScore = parm.ShareScore;
db.Update<TeamProject>(model);
db.SaveChanges();
///删除原来的,彻底以新增方式进行（修改通过删除在新增实现）
var delSourceFile = from s in t_s where s.Guid == model.Guid select s;
db.T_SourceFile.RemoveRange(delSourceFile);
db.SaveChanges();
if (parm.SourceFileList!=null)
{
foreach (var item in parm.SourceFileList)
{
item.Guid = model.Guid;
item.AddTime = DateTime.Now;
}
db.T_SourceFile.AddRange(parm.SourceFileList);//重新绑定
db.SaveChanges();
}
return Success("修改成功");
}
}
public ActionResult PostAddTeamProjectSummary(TeamProjectSummaryModel parm)
{
TeamProjectSummary model = new TeamProjectSummary();
model.AddTime = DateTime.Now;
model.AddUserId = AdminUser.ID;
model.State = RowState.有效;
model.Guid = Guid.NewGuid().ToString();
model.SubTitle = parm.SubTitle;
model.TeamProjectId = parm.TeamProjectId;
model.Desc = parm.Desc;
//foreach (var item in parm.SourceFileList)
//{
// item.Guid = model.Guid;
// item.AddTime = DateTime.Now;
//}
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.Add<TeamProjectSummary>(model);
db.SaveChanges();
//db.T_SourceFile.AddRange(parm.SourceFileList);
//db.SaveChanges();
return Success("新增成功");
}
}
public ActionResult PostAddTeamPojectStation(TeamPojectStation parm)
{
parm.AddTime = DateTime.Now;
parm.AddUserId = AdminUser.ID;
parm.State = RowState.有效;
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.Add<TeamPojectStation>(parm);
db.SaveChanges();
}
return Success("新增成功");
}
public ActionResult PostAdd(InfoManageModel parm)
{
#region 初始化参数
InfoManage model = new InfoManage();
model.AddTime = DateTime.Now;
model.AddUserId = AdminUser.ID;
model.State = RowState.有效;
model.Guid = Guid.NewGuid().ToString();
model.LinkUrl = parm.LinkUrl;
model.Title = parm.Title;
model.Desc = parm.Desc;
model.LinkUrl = parm.LinkUrl;
model.Contact = parm.Contact;
model.Phone = parm.Phone;
model.DeptId = parm.DeptId;
model.Type = parm.Type;
foreach (var item in parm.SourceFileList)
{
item.Guid = model.Guid;
item.AddTime = DateTime.Now;
}
#endregion
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.Add(model);
db.SaveChanges();
db.T_SourceFile.AddRange(parm.SourceFileList);
db.SaveChanges();
return Success("添加成功");
}
}
public ActionResult App_UserApplyProject(int userId, int teamProjectId)
{
JsonMessage retJson = new JsonMessage();
using (LoveBankDBContext db = new LoveBankDBContext())
{
//var t_vr = db.T_VolAddScoreRecorde;
var t_tps = db.T_TeamPojectStationApply;
var t_v = db.T_Vol;
if (t_tps.Count(x=>x.TeamPojectId==teamProjectId&&x.ApplyUserId==userId)>0)
{
retJson.Status = false;
retJson.Info = "申请失败,你已经申请了";
return Json(retJson);
}
TeamPojectStationApply model = new TeamPojectStationApply();
model.TeamPojectId = teamProjectId;
model.ApplyUserId = userId;
VolShowModel vmodel =( from v in t_v
where v.ID == userId
select new VolShowModel
{
Phone = v.Phone,
RealName=v.RealName
}).FirstOrDefault();
model.Phone = vmodel.Phone;
model.Name = vmodel.RealName;
db.Add(model);
db.SaveChanges();
retJson.Status = true;
retJson.Info ="申请成功";
return Json(retJson);
}
}
public ActionResult PostEdit(InfoManageModel parm)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_m = db.T_Machine;
var t_a = db.T_InfoManage;
var t_s = db.T_SourceFile;
#region 初始化参数
InfoManage model = t_a.Find(parm.ID);
model.Title = parm.Title;
model.Desc = parm.Desc;
model.DeptId = parm.DeptId;
model.LinkUrl = parm.Desc;
model.Phone = parm.Desc;
model.Contact = parm.Desc;
model.Type = parm.Type;
///删除原来的,彻底以新增方式进行（修改通过删除在新增实现）
var delSourceFile = from s in t_s where s.Guid == model.Guid select s;
db.T_SourceFile.RemoveRange(delSourceFile);
#endregion
db.Update<InfoManage>(model);
db.SaveChanges();
db.T_SourceFile.AddRange(parm.SourceFileList);//重新绑定
db.SaveChanges();
return Success("添加成功");
}
}
/// <summary>
/// 兑换产品：
/// 参数：MacineCode机器Id
/// LoveBankProductId:被兑换产品Id
/// MacineCode：被兑换机器唯一码
/// Type: 账号登陆兑换 = 0, 二维码登陆兑换 = 1, NFC登陆兑换 = 2
/// ExChangeCount:兑换数量，默认值是：1
/// AddUserId：兑换人的用户ID
/// Address（可选,兑换的地址）
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ActionResult App_ExchangeProduct(LoveBankProductExchangeLog entity)
{
entity.AddTime = DateTime.Now;
entity.ExChangeCount = entity.ExChangeCount <= 0 ? 1 : entity.ExChangeCount;
entity.Source = "爱心银行";
entity.State = 0;
JsonMessage retJson = new JsonMessage();
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_p = db.T_Product;
var t_v = db.T_Vol;
var t_d = db.T_Department;
var t_m = db.T_Machine;
Product productModel = t_p.Find(entity.LoveBankProductId);
if (productModel == null)
{
retJson.Status = false;
retJson.Info = "产品不存在";
return Json(retJson);
}
if (productModel.Count < entity.ExChangeCount)
{
retJson.Status = false;
retJson.Info = "产品数量不足";
return Json(retJson);
}
Vol vol = t_v.Find(entity.AddUserId);
if (vol == null)
{
retJson.Status = false;
retJson.Info = "用户不存在";
return Json(retJson);
}
MachineModel mm = (from m in t_m
where m.MachineCode == entity.MacineCode
select new MachineModel
{
Address = m.Address,
Lat = m.Lat,
Lon = m.Lon,
DeptId = m.DeptId
}).FirstOrDefault();
if (vol.DepId.IndexOf(mm.DeptId) < 0)//判断该机器和用户是否是同一个社区
{
var depName = (from d in t_d where d.Id == mm.DeptId select d.Name).FirstOrDefault();
retJson.Status = false;
retJson.Info = string.Format("抱歉,该终端只服务于{0}用户", depName);
retJson.Data = "-2";
return Json(retJson);
}
if (vol.DepId.IndexOf(productModel.DeptId) < 0)//判断是否属于该社区
{
var depName = (from d in t_d where d.Id == productModel.DeptId select d.Name).FirstOrDefault();
retJson.Status = false;
retJson.Info = string.Format("抱歉,该产品属于{0}", depName);
retJson.Data = "-2";
return Json(retJson);
}
int totalCostScore = entity.CostScore * entity.ExChangeCount;
if (!vol.LoveBankScore.HasValue || vol.LoveBankScore.Value < totalCostScore)
{
retJson.Status = false;
retJson.Info = "积分不足,可用积分:" + vol.LoveBankScore + ".对应产品所需总积分:" + totalCostScore + ".兑换数量:" + entity.ExChangeCount;
return Json(retJson);
}
productModel.Count = productModel.Count - entity.ExChangeCount;//减少兑换数量
db.Update<Product>(productModel);
db.SaveChanges();
entity.Address = mm.Address;
entity.Lat = mm.Lat;
entity.Lon = mm.Lon;
entity.CostScore = productModel.CostScore * entity.ExChangeCount;
db.Add<LoveBankProductExchangeLog>(entity);//保存兑换记录
db.SaveChanges();
vol.LoveBankScore = vol.LoveBankScore - entity.CostScore * entity.ExChangeCount;//减少积分
db.Update<Vol>(vol);
db.SaveChanges();
retJson.Status = true;
retJson.Info = "兑换成功";
}
return Json(retJson);
}
public ActionResult PostEditTeamProjectSummary(TeamProjectSummaryModel parm)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_s = db.T_SourceFile;
var t_ps = db.T_TeamProjectSummary;
TeamProjectSummary model = t_ps.Find(parm.Id);
//model.AddTime = DateTime.Now;
//model.AddUserId = AdminUser.ID;
//model.State = RowState.有效;
//model.Guid = Guid.NewGuid().ToString();
model.SubTitle = parm.SubTitle;
//model.TeamProjectId = parm.TeamProjectId;
model.Desc = parm.Desc;
//foreach (var item in parm.SourceFileList)
//{
// item.Guid = model.Guid;
// item.AddTime = DateTime.Now;
//}
///删除原来的,彻底以新增方式进行（修改通过删除在新增实现）
//var delSourceFile = from s in t_s where s.Guid == model.Guid select s;
//db.T_SourceFile.RemoveRange(delSourceFile);
//db.SaveChanges();
//db.T_SourceFile.AddRange(parm.SourceFileList);
//db.SaveChanges();
db.Update<TeamProjectSummary>(model);
db.SaveChanges();
return Success("新增成功");
}
}
public ActionResult DeleteEditTeamProjectSummary(int Id)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_ps = db.T_TeamProjectSummary;
TeamProjectSummary model = t_ps.Find(Id);
db.Delete<TeamProjectSummary>(model);
db.SaveChanges();
return Success("删除成功");
}
}
