public ActionResult IndexTest2()
{
using (var db = new yxbDbContext())
{
// UserList model = db.UserList.FirstOrDefault();
return View();
}
}
public ActionResult SetExpStatus(int id, int state)
{
//var m = model;
try
{
ExpStateEnum s = (ExpStateEnum)state;
using (yxbDbContext con = new yxbDbContext())
{
var model = con.ExpList.Single(o => o.ExpId == id);
//时间戳
model.ExpTime = DateTime.Now;
//var list = con.ExpList.AsNoTracking().Where(o => o.ExpId == model.ExpId).ToList();
model.ExpState = state;
con.Entry(model).State = System.Data.Entity.EntityState.Modified;
ExpContext econtext = new ExpContext();
econtext.expid = model.ExpId;
econtext.expno = model.ExpNo;
econtext.time = DateTime.Now;
switch (s)
{
case ExpStateEnum.OnDistribute:
econtext.context = "派件扫描";
con.ExpContext.Add(econtext);
con.SaveChanges();
break;
case ExpStateEnum.OnSign:
econtext.context = "货物已签收";
con.ExpContext.Add(econtext);
con.SaveChanges();
//短信模板参数
List<string> smsdata = new List<string>();
smsdata.Add(model.From);
smsdata.Add(model.To);
smsdata.Add(model.ExpNo);
smsdata.Add(ExpSMSTemp.ContactTel);
SendExpSMS ss = new SendExpSMS();
if (!string.IsNullOrWhiteSpace(model.From))
{
ExpSMSResponse ret = ss.SendSMS(model.ToMobile, ExpSMSTemp.SignTempId, smsdata.ToArray());
}
break;
default:
return Json(CommenData.ResultMsg(-1, "标记失败"), JsonRequestBehavior.AllowGet);
}
}
return Json(CommenData.ResultMsg(1, "标记成功"), JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(CommenData.ResultMsg(-1, ex.Message), JsonRequestBehavior.AllowGet);
}
}
public ActionResult DelExpContext(int id)
{
using (yxbDbContext con = new yxbDbContext())
{
var model = con.ExpContext.Single(o => o.contextId == id);
model.isdeleted = 1;
con.Entry(model).State = System.Data.Entity.EntityState.Modified;
con.SaveChanges();
return Json(CommenData.ResultMsg(1, "ok"), JsonRequestBehavior.AllowGet);
}
}
public ActionResult DelExp(int id)
{
using (yxbDbContext con = new yxbDbContext())
{
var model = con.ExpList.Single(o => o.ExpId == id);
model.IsDeleted = 1;
con.Entry(model).State = System.Data.Entity.EntityState.Modified;
//删除内容
List<ExpContext> expdetail = con.ExpContext.Where(o => o.expid == model.ExpId).ToList();
foreach (ExpContext ec in expdetail)
{
ec.isdeleted = 1;
}
con.SaveChanges();
return Json(CommenData.ResultMsg(1, "ok"), JsonRequestBehavior.AllowGet);
}
}
public ActionResult SaveExpContext(ExpContext model)
{
//var m = model;
try
{
using (yxbDbContext con = new yxbDbContext())
{
//时间戳
// model.ExpTime = DateTime.Now;
var list = con.ExpContext.AsNoTracking().Where(o => o.contextId == model.contextId).ToList();
model.expno = con.ExpList.Single(o => o.ExpId == model.expid).ExpNo;
if (list.Count() > 0)
{
model.isdeleted = 0;
con.Entry(model).State = System.Data.Entity.EntityState.Modified;
con.SaveChanges();
return Json(CommenData.ResultMsg(1, "信息修改成功"), JsonRequestBehavior.AllowGet);
}
else
{
model.isdeleted = 0;
con.ExpContext.Add(model);
con.SaveChanges();
return Json(CommenData.ResultMsg(1, ""), JsonRequestBehavior.AllowGet);
}
}
}
catch (Exception ex)
{
return Json(CommenData.ResultMsg(-1, ex.Message), JsonRequestBehavior.AllowGet);
}
}
public ActionResult SaveExp(ExpList model)
{
//var m = model;
try
{
using (yxbDbContext con = new yxbDbContext())
{
//时间戳
model.ExpTime = DateTime.Now;
var list = con.ExpList.AsNoTracking().Where(o => o.ExpId == model.ExpId && o.IsDeleted == 0).ToList();
if (list.Count() > 0)
{
var exist = con.ExpList.AsNoTracking().Where(o => o.ExpNo == model.ExpNo && o.ExpId != model.ExpId && o.IsDeleted == 0);
if (exist.Count() > 0)
{
return Json(CommenData.ResultMsg(2, "该单号已录入，请查证后输入。"), JsonRequestBehavior.AllowGet);
}
else
{
con.Entry(model).State = System.Data.Entity.EntityState.Modified;
// int expno = list.First();
List<ExpContext> expdetail = con.ExpContext.Where(o => o.expid == model.ExpId).ToList();
foreach (ExpContext ec in expdetail)
{
ec.expno = model.ExpNo;
}
con.SaveChanges();
//签收短信通知
ExpStateEnum s = (ExpStateEnum)model.ExpState;
switch (s)
{
case ExpStateEnum.OnSign:
//短信模板参数
List<string> smsdata = new List<string>();
smsdata.Add(model.From);
smsdata.Add(model.To);
smsdata.Add(model.ExpNo);
smsdata.Add(ExpSMSTemp.ContactTel);
SendExpSMS ss = new SendExpSMS();
if (!string.IsNullOrWhiteSpace(model.From))
{
ExpSMSResponse ret = ss.SendSMS(model.ToMobile, ExpSMSTemp.SignTempId, smsdata.ToArray());
}
break;
}
return Json(CommenData.ResultMsg(1, "信息修改成功"), JsonRequestBehavior.AllowGet);
}
}
else
{
var exist = con.ExpList.AsNoTracking().Where(o => o.ExpNo == model.ExpNo && o.IsDeleted == 0);
if (exist.Count() > 0)
{
return Json(CommenData.ResultMsg(2, "该单号已录入，请查证后输入。"), JsonRequestBehavior.AllowGet);
}
else
{
con.ExpList.Add(model);
con.SaveChanges();
//添加详情
ExpContext expDetail = new ExpContext();
expDetail.expno = model.ExpNo;
expDetail.context = "揽件扫描";
expDetail.time = DateTime.Now;
expDetail.expid = model.ExpId;
con.ExpContext.Add(expDetail);
con.SaveChanges();
//短信模板参数
List<string> smsdata = new List<string>();
smsdata.Add(model.StartStation);
smsdata.Add(model.ExpNo);
smsdata.Add(ExpSMSTemp.ContactTel);
SendExpSMS ss = new SendExpSMS();
ExpSMSResponse ret = ss.SendSMS(model.ToMobile, ExpSMSTemp.SendTempId, smsdata.ToArray());
return Json(CommenData.ResultMsg(1, ""), JsonRequestBehavior.AllowGet);
}
}
}
}
catch (Exception ex)
{
return Json(CommenData.ResultMsg(-1, ex.Message), JsonRequestBehavior.AllowGet);
}
}
public ActionResult ExpContextEdit(int rowindex, int id, int expid)
{
ViewBag.rowindex = rowindex;
if (id > 0)
{
using (yxbDbContext con = new yxbDbContext())
{
ExpContext exp = con.ExpContext.SingleOrDefault(o => o.contextId == id);
return View(exp);
}
}
else
{
ExpContext exp = new ExpContext();
exp.time = DateTime.Now;
exp.expid = expid;
return View(exp);
}
}
public ActionResult ExpEdit(int id)
{
if (id > 0)
{
using (yxbDbContext con = new yxbDbContext())
{
ExpList exp = con.ExpList.SingleOrDefault(o => o.ExpId == id);
return View(exp);
}
}
else
{
ExpList exp = new ExpList();
exp.ExpDate = DateTime.Now;
exp.ExpTime = DateTime.Now;
return View(exp);
}
}
public ActionResult DelNews(int id)
{
using (yxbDbContext con = new yxbDbContext())
{
//var model = new NewsList() { ID = id };
var model = con.NewsList.Single(o => o.ID == id);
model.IsDeleted = 1;
con.Entry(model).State = System.Data.Entity.EntityState.Modified;
//con.NewsList.Attach(model);
//con.NewsList.Remove(model);
con.SaveChanges();
return Json(CommenData.ResultMsg(1, "ok"), JsonRequestBehavior.AllowGet);
}
}
public ActionResult SaveNews(NewsList model)
{
//var m = model;
try
{
using (yxbDbContext con = new yxbDbContext())
{
var list = con.NewsList.Where(o => o.ID == model.ID);
if (list.Count() > 0)
{
con.Entry(model).State = System.Data.Entity.EntityState.Modified;
con.SaveChanges();
return Json(CommenData.ResultMsg(1, "修改成功"), JsonRequestBehavior.AllowGet);
}
else
{
con.NewsList.Add(model);
con.SaveChanges();
return Json(CommenData.ResultMsg(1, "添加成功"), JsonRequestBehavior.AllowGet);
}
}
}
catch (Exception ex)
{
return Json(CommenData.ResultMsg(-1, ex.Message), JsonRequestBehavior.AllowGet);
}
}
public ActionResult NewsEdit(int id)
{
using (yxbDbContext con = new yxbDbContext())
{
if (id > 0)
{
var model = con.NewsList.SingleOrDefault(o => o.ID == id);
return View(model);
}
else
{
return View(new NewsList() { NewsCreater = "新闻中心", NewsDate = DateTime.Now, NewsType = 2 });
}
}
}
