/// <summary> /// 改变BILL的单据状态为 等待审核 /// </summary> /// <param name="yearAndMonth">年月字符串</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>改变成功返回True,改变失败返回False</returns> public bool UpdateBillStatus(string yearAndMonth, out string error) { error = null; try { DepotManagementDataContext dataContext = CommentParameter.DepotDataContext; var varData = from a in dataContext.B_WebForOrderFormBill where a.Ny == yearAndMonth select a; if (varData.Count() != 1) { error = "数据为空或者不唯一"; return(false); } else { B_WebForOrderFormBill lnqBill = varData.Single(); lnqBill.DJZT = "等待审核"; } dataContext.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 修改单据状态 /// </summary> /// <param name="yearAndMonth">操作年月字符串</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>修改成功返回True,修改失败返回False</returns> public bool UpdateBill(string yearAndMonth, out string error) { try { error = null; DepotManagementDataContext dataContext = CommentParameter.DepotDataContext; var varData = from a in dataContext.B_WebForOrderFormBill where a.Ny == yearAndMonth select a; if (varData.Count() != 1) { error = "数据不唯一或者为空"; return(false); } else { B_WebForOrderFormBill lnqBill = varData.Single(); switch (lnqBill.DJZT) { case "等待审核": lnqBill.DJZT = "等待发布"; lnqBill.AuthorizePersonnel = BasicInfo.LoginName; lnqBill.AuthorizeTime = ServerTime.Time; var varOrderFormList = from a in dataContext.B_WebForOrderFormList where a.Ny == yearAndMonth select a; foreach (var item in varOrderFormList) { item.ChangeFlag = false; } break; case "等待发布": lnqBill.DJZT = "单据已完成"; lnqBill.IssuePersonnel = BasicInfo.LoginName; lnqBill.IssueTime = ServerTime.Time; //插入WINFROM 订单表 if (!InsertWinFormOrderForm(dataContext, yearAndMonth, out error)) { return(false); } dataContext.SubmitChanges(); //插入WEB 订单表 if (!InsertWebOrderForm(yearAndMonth, out error)) { return(false); } break; default: break; } dataContext.SubmitChanges(); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }