public ActionResult DeleteConfirmed(Guid id)
{
BaoxiuBill baoxiuBill = db.BaoxiuBills.Find(id);
db.BaoxiuBills.Remove(baoxiuBill);
db.SaveChanges();
return(RedirectToAction("BillList", new { id = baoxiuBill.ProductSN }));
}
///// <summary>
///// 获取审核通过，尚未报销过，且允许报销的单据。
///// </summary>
///// <returns></returns>
//public IQueryable<BaoxiuBill> GetBills_CanBaoxiao()
//{
// string agreed = Tiyi.Licai.ApprovalStatus.Agreed.ToString();
// var query = from item in dbContext.BaoxiuBill
// where item.ApproveCompleted && item.ApproveResult == agreed
// && item.IsBaoxiaoed == false
// orderby item.ApproveDate
// select item;
// return query.AsQueryable<BaoxiuBill>();
//}
///// <summary>
///// 获取已投资完毕的单据。
///// </summary>
///// <returns></returns>
//public IQueryable<BaoxiuBill> GetBills_hasBaoxiaoed()
//{
// var query = from item in dbContext.BaoxiuBill
// where item.IsBaoxiaoed == true
// select item;
// return query.AsQueryable<BaoxiuBill>();
//}
///// <summary>
///// 保存报销申请单的审核结果数据
///// <para>同时将单子状态设为不可编辑，不可删除。</para>
///// </summary>
///// <param name="record">资金划转记录。</param>
//public void SaveApprovalData(Guid bxId, string approverJobNumber, string approverRealName, string approveResult, string commentary)
//{
// BaoxiuBill bill = this.GetBaoxiuBill(bxId);
// if (bill == null)
// return;
// bill.ApproverJobNumber = approverJobNumber;
// bill.ApproverRealName = approverRealName;
// bill.ApproveResult = approveResult;
// bill.Commentary = commentary;
// bill.ApproveDate = DateTime.Now;
// bill.ApproveCompleted = true;
// bill.CurrentStatus = "审核完毕";
// bill.CanEdit = false;
// bill.CanDelete = false;
// dbContext.SubmitChanges();
//}
/// <summary>
/// 修改报修单信息
/// </summary>
/// <param name="newBaoxiuBill">报修单。</param>
public void UpdateBaoxiuBill(BaoxiuBill newBaoxiuBill)
{
if (newBaoxiuBill == null)
{
return;
}
dbContext.SubmitChanges();
}
/// <summary>
/// 获取指定appId的报修单
/// </summary>
/// <param name="bxId">报修单ID</param>
/// <returns></returns>
public BaoxiuBill GetBaoxiuBill(Guid bxId)
{
var query = from item in dbContext.BaoxiuBill
where item.BxId == bxId
select item;
BaoxiuBill bill = query.FirstOrDefault();
return(bill);
}
public ActionResult Edit([Bind(Include = "BxId,AppId,ProductSN,BigClass,AppType,DepName,Address,UserName,UserMobilePhone,UserMobileShort,FaultPhenomenon,CreateDate,HandleResult,IsAccept")] BaoxiuBill baoxiuBill)
{
if (ModelState.IsValid)
{
baoxiuBill.CreateDate = DateTime.Now;
db.Entry(baoxiuBill).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("BillList", new { id = baoxiuBill.ProductSN }));
}
ViewBag.AppId = new SelectList(db.Appliances, "AppId", "ProductSN", baoxiuBill.AppId);
return(View(baoxiuBill));
}
/// <summary>
/// 该方法供批量创建新报修单时使用
/// <para>不立即提交数据库</para>
/// </summary>
/// <param name="newBaoxiuBill"></param>
public void CreateBaoxiuBillNotSubmit(BaoxiuBill newBaoxiuBill)
{
if (newBaoxiuBill == null)
{
return;
}
newBaoxiuBill.BxId = Guid.NewGuid();
newBaoxiuBill.CreateDate = DateTime.Now;
newBaoxiuBill.IsAccept = false;
newBaoxiuBill.IsCompleted = false;
dbContext.BaoxiuBill.InsertOnSubmit(newBaoxiuBill);
}
// GET: BaoxiuBills/Details/5
public ActionResult Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BaoxiuBill baoxiuBill = db.BaoxiuBills.Find(id);
if (baoxiuBill == null)
{
return(HttpNotFound());
}
return(View(baoxiuBill));
}
// GET: BaoxiuBills/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Baoxiu-Bill-Id is not identified."));
}
BaoxiuBill baoxiuBill = db.BaoxiuBills.Find(id);
if (baoxiuBill == null)
{
return(HttpNotFound("Can't find Baoxiu-Bill."));
}
return(View(baoxiuBill));
}
public ActionResult Create([Bind(Include = "BxId,AppId,ProductSN,BigClass,AppType,DepName,Address,UserName,UserMobilePhone,UserMobileShort,FaultPhenomenon,CreateDate,HandleResult,IsAccept")] BaoxiuBill baoxiuBill)
{
if (ModelState.IsValid)
{
baoxiuBill.BxId = Guid.NewGuid();
baoxiuBill.CreateDate = DateTime.Now;
baoxiuBill.IsAccept = false;
db.BaoxiuBills.Add(baoxiuBill);
db.SaveChanges();
SendWxToAdmin(baoxiuBill);
return(RedirectToAction("CreateSuccess", new { id = baoxiuBill.ProductSN }));
}
ViewBag.AppId = new SelectList(db.Appliances, "AppId", "ProductSN", baoxiuBill.AppId);
return(View(baoxiuBill));
}
/// <summary>
/// 创建新的报修单。
/// </summary>
/// <param name="newBxBill">报修单</param>
/// <returns></returns>
public BaoxiuBill CreateBaoxiuBill(BaoxiuBill newBaoxiuBill)
{
if (newBaoxiuBill == null)
{
return(null);
}
newBaoxiuBill.BxId = Guid.NewGuid();
newBaoxiuBill.CreateDate = DateTime.Now;
newBaoxiuBill.IsAccept = false;
newBaoxiuBill.IsCompleted = false;
dbContext.BaoxiuBill.InsertOnSubmit(newBaoxiuBill);
dbContext.SubmitChanges();
return(newBaoxiuBill);
}
private void SendWxToAdmin(BaoxiuBill bxBill)
{
Tiyi.Weixin.Work.Article article = new Tiyi.Weixin.Work.Article();
article.Title = "设备故障报修";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.AppendLine("设备类型：" + bxBill.BigClass + bxBill.AppType);
sb.AppendLine("详细地址：" + bxBill.DepName + bxBill.Address);
sb.AppendLine("联系方式：" + bxBill.UserName + " " + bxBill.UserMobilePhone + " (短号：" + bxBill.UserMobileShort + ")");
sb.AppendLine("派工时间：" + DateTime.Now.ToString() + "\n");
sb.AppendLine("故障现象：" + bxBill.FaultPhenomenon);
sb.AppendLine("备注信息：" + bxBill.Remark);
article.Description = sb.ToString();
article.Url = "";
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
string articleJson = js.Serialize(article);
ws_wxSender.SendArticleToUser("101527", articleJson, "34");
}
/// <summary>
/// 修改报修单信息
/// </summary>
/// <param name="newBaoxiuBill">报修单。</param>
public void UpdateBaoxiuBill(BaoxiuBill newBaoxiuBill)
{
da.UpdateBaoxiuBill(newBaoxiuBill);
}
/// <summary>
/// 该方法供批量创建新报修单时使用
/// <para>不立即提交数据库</para>
/// </summary>
/// <param name="newBaoxiuBill"></param>
public void CreateBaoxiuBillNotSubmit(BaoxiuBill newBaoxiuBill)
{
da.CreateBaoxiuBillNotSubmit(newBaoxiuBill);
}
/// <summary>
/// 创建新的报修单。
/// </summary>
/// <param name="newBxBill">报修单</param>
/// <returns></returns>
public BaoxiuBill CreateBaoxiuBill(BaoxiuBill newBaoxiuBill)
{
return(da.CreateBaoxiuBill(newBaoxiuBill));
}
