/// <summary> /// 增加单个流程实例具体环节 /// </summary> /// <param name="model"></param> public void Add(case_workflowspecificactivitys model) { Entities db = new Entities(); db.case_workflowspecificactivitys.Add(model); db.SaveChanges(); }
/// <summary> /// 获取单个流程实例具体环节根据工作流实例环节编号 /// </summary> /// <param name="WFID">工作流实例环节编号</param> /// <returns></returns> public case_workflowspecificactivitys GetSingle(string WFSAID) { Entities db = new Entities(); case_workflowspecificactivitys model = db.case_workflowspecificactivitys .SingleOrDefault(a => a.wfsaid == WFSAID); return(model); }
/// <summary> /// 修改单个流程实例具体环节 /// </summary> /// <param name="model"></param> public void Update(case_workflowspecificactivitys model) { Entities db = new Entities(); case_workflowspecificactivitys result = db.case_workflowspecificactivitys .SingleOrDefault(a => a.wfsaid == model.wfsaid); if (result != null) { result.status = model.status; result.dealuserid = model.dealuserid; result.dealtime = model.dealtime; db.SaveChanges(); } }
/// <summary> /// 更新或增加当前流程的具体事例 /// </summary> /// <param name="CurrentWFSAID">环节实例编号</param> /// <param name="UserID">当前处理的用户</param> /// <param name="STATUS">当前环节状态</param> /// <param name="WFDID">环节编号</param> /// <param name="oldStatus">返回当前环节是否已经处理完成 1:未处理,2已经处理</param> /// <returns>返回当前环节编号</returns> public string function_Case_DealCurentActivity(string WFSAID, string WFSID, int UserID, int STATUS, string WFDID, out decimal oldStatus, DateTime?stime, DateTime?etime) { oldStatus = 1; case_workflowspecificactivitys wfsaModel = new Case_WorkFlowSpecificActivitysDAL().GetSingle(WFSAID); #region 处理当前环节 if (wfsaModel != null) //当前环节,如果存在,则修改状态,和更新处理人 { if (wfsaModel.status != 2) //状态为已经更新,则就不需要更新 { //更新环节 wfsaModel.status = 2; wfsaModel.dealtime = DateTime.Now; wfsaModel.dealuserid = UserID; new Case_WorkFlowSpecificActivitysDAL().Update(wfsaModel); } else { oldStatus = 2; } WFSAID = wfsaModel.wfsaid; } else//否则增加状态 { //增加当前环节 wfsaModel = new case_workflowspecificactivitys(); wfsaModel.wfsaid = GetNewId(); wfsaModel.createtime = DateTime.Now; wfsaModel.wfsid = WFSID; wfsaModel.status = STATUS; wfsaModel.dealuserid = UserID; wfsaModel.dealtime = DateTime.Now; wfsaModel.wfdid = WFDID; wfsaModel.stime = stime; wfsaModel.etime = etime; new Case_WorkFlowSpecificActivitysDAL().Add(wfsaModel); WFSAID = wfsaModel.wfsaid; } #endregion return(WFSAID); }