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)); }