public AlarmDetailModel GetAlarmDetailModel(int id)
{
AlarmDetailModel model = new AlarmDetailModel();
using (Entities db = new Entities())
{
IQueryable <AlarmDetailModel> queryable = from a in db.qw_alarmmemorylocationdatas
join b_join in db.base_users on a.userid equals b_join.id into temp1
from b in temp1.DefaultIfEmpty()
join c_join in db.base_units on b.unitid equals c_join.id into temp2
from c in temp2.DefaultIfEmpty()
where a.id == id
select new AlarmDetailModel
{
alarmstrattime = a.alarmstrattime,
alarmendtime = a.alarmendtime,
alarmtype = a.alarmtype,
state = a.state,
isallege = a.isallege,
username = b.displayname,
unitname = c.name,
id = a.id,
createtime = a.createtime,
content = a.content,
dealtime = a.dealtime,
dealuserid = a.dealuserid,
allegereason = a.allegereason,
allegetime = a.allegetime
};
model = queryable.FirstOrDefault();
}
return(model);
}
/// <summary>
/// 提交申诉
/// </summary>
/// <param name="id"></param>
/// <param name="type"></param>
/// <returns></returns>
public int SubmitAlarmDetailAppeals(AlarmDetailModel model)
{
using (Entities db = new Entities())
{
qw_alarmmemorylocationdatas qwmodel = db.qw_alarmmemorylocationdatas.FirstOrDefault(a => a.id == model.id);
if (qwmodel != null)
{
qwmodel.isallege = model.isallege;
qwmodel.allegereason = model.allegereason;
qwmodel.allegetime = DateTime.Now;
}
return(db.SaveChanges());
}
}
/// <summary>
/// 修改申诉审核
/// </summary>
/// <param name="id"></param>
/// <param name="type"></param>
/// <returns></returns>
public int EditAlarmDetailAppeals(AlarmDetailModel model)
{
using (Entities db = new Entities())
{
qw_alarmmemorylocationdatas qwmodel = db.qw_alarmmemorylocationdatas.FirstOrDefault(a => a.id == model.id);
if (qwmodel != null)
{
qwmodel.appeals = model.appeals;
qwmodel.content = model.content;
qwmodel.dealtime = DateTime.Now;
qwmodel.dealuserid = model.dealuserid;
}
return(db.SaveChanges());
}
}
public HttpResponseMessage EditAlarmDetailAppeals(AlarmDetailModel model)
{
int success = bll.EditAlarmDetailAppeals(model);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
if (success > 0)
{
response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html");
}
else
{
response.Content = new StringContent("{\"success\":falst}", Encoding.GetEncoding("UTF-8"), "text/html");
}
return(response);
}
/// <summary>
/// 提交申诉
/// </summary>
/// <param name="id"></param>
/// <param name="type"></param>
/// <returns></returns>
public int SubmitAlarmDetailAppeals(AlarmDetailModel model)
{
return(dal.SubmitAlarmDetailAppeals(model));
}
/// <summary>
/// 修改申诉状态
/// </summary>
/// <param name="id"></param>
/// <param name="type"></param>
/// <returns></returns>
public int EditAlarmDetailAppeals(AlarmDetailModel model)
{
return(dal.EditAlarmDetailAppeals(model));
}
