public static Renwu GetRenwuById(int id)
{
UnitOfWork unitOfWork = new UnitOfWork();
Renwu renwu = unitOfWork.renwusRepository.GetByID(id);
return(renwu);
}
public static Message GetStatusByPreDaka(int id, int bid)
{
Message msg = new Message();
UnitOfWork unitOfWork = new UnitOfWork();
string sql = "select top 1 * from Renwu where Id<" + id + " and RenwuBook=" + bid + " order by Id DESC";
var renwus = unitOfWork.renwusRepository.GetWithRawSql(sql);
if (renwus.Count() > 0)
{
Renwu renwu = renwus.First();
var dakas = unitOfWork.renwuDakasRepository.Get(filter: r => r.RenwuName == renwu.Id);
if (dakas.Count() > 0)
{
msg.MessageStatus = "true";
msg.MessageInfo = "打卡";
}
else
{
msg.MessageStatus = "false";
msg.MessageInfo = "解锁";
}
return(msg);
}
else
{
msg.MessageStatus = "true";
msg.MessageInfo = "解锁";
return(msg);
}
}
public ActionResult GetSpaceByDakaId(int rid, int kid)
{
int next_id = 0;
string sql = "select * from RenwuDaka where RenwuZhixingzhe=" + rid + " and Kongjian=" + kid + " order by Id desc";
var renwudakas = unitOfWork.renwuDakasRepository.GetWithRawSql(sql);
if (renwudakas.Count() == 0)
{
next_id = 0;
}
else
{
RenwuDaka daka = renwudakas.First();
int last_id = daka.RenwuName;
string next_sql = "select top 1 * from Renwu where Id>" + last_id + " order by Paixu";
var renwus = unitOfWork.renwusRepository.GetWithRawSql(next_sql);
if (renwus.Count() == 0)
{
next_id = last_id;
}
else
{
Renwu renwu = renwus.First();
next_id = renwu.Id;
}
}
string json = JsonHelper.JsonSerializerBySingleData(next_id);
return(Content(json));
}
public ActionResult GetRenwuById(int id)
{
Renwu _renwu = unitOfWork.renwusRepository.GetByID(id);
string json = JsonHelper.JsonSerializerBySingleData(_renwu);
return(Content(json));
}
public ActionResult Edit(Renwu renwu)
{
if (ModelState.IsValid)
{
unitOfWork.renwusRepository.Update(renwu);
unitOfWork.Save();
return(RedirectToAction("Index", "Renwu", new { bid = renwu.RenwuBook }));
}
return(View(renwu));
}
public ActionResult Edit(int id)
{
Renwu renwu = unitOfWork.renwusRepository.GetByID(id);
if (renwu == null)
{
return(HttpNotFound());
}
return(View(renwu));
}
public ActionResult Create(Renwu renwu)
{
if (ModelState.IsValid)
{
unitOfWork.renwusRepository.Insert(renwu);
unitOfWork.Save();
return(RedirectToAction("Index", "Renwu", new { bid = renwu.RenwuBook }));
}
// return View("Create?bid=" + renwu.RenwuBook, renwu);
return(RedirectToAction("Create", "Renwu", new { bid = renwu.RenwuBook }));
}
public ActionResult Daka(RenwuDaka daka)
{
Ren ren = unitOfWork.rensRepository.GetByID(daka.RenwuZhixingzhe);
Renwu renwu = unitOfWork.renwusRepository.GetByID(daka.RenwuName);
if (ModelState.IsValid)
{
unitOfWork.renwuDakasRepository.Insert(daka);
unitOfWork.Save();
WechatTemplateMessage msgData = new WechatTemplateMessage
{
touser = ren.RenOpenid,
template_id = "YfnxngfPAXv5hgSkDGKS-3bd5aScpZgwlRr1Jn85fWc",
url = "http://peiban.zzd123.com/Wap/ArticleContent?id=" + daka.Id,
data = new
{
first = new
{
value = "你好，完成作业通知。",
color = "#173177"
},
keyword1 = new
{
value = ren.RenNickName,
color = "#173177"
},
keyword2 = new
{
value = renwu.Title,
color = "#173177"
},
keyword3 = new
{
value = DateTime.Now.ToString("yyyy-MM-dd hh:mm"),
color = "#173177"
},
remark = new
{
value = "每一次陪伴都是人生的美好。"
}
}
};
string access_token = AccessTokenService.GetAccessToken();
string postdata = JsonConvert.SerializeObject(msgData);
string result = WechatMessageServices.SendTempletMessge(access_token, postdata);
WechatResult wechatResult = JsonConvert.DeserializeObject <WechatResult>(result);
if (wechatResult.errcode == 0)
{
ViewBag.msg = "模板消息发送成功！操作代码如下：";
ViewBag.result = result;
}
else
{
ViewBag.msg = "模板消息发送失败！错误代码如下：";
ViewBag.result = result;
}
return(RedirectToAction("DakaList", "UHome"));
}
return(View(daka));
}
