protected void InitFlowInfo() { string AppInstanceID = Request.QueryString["AppInstanceID"] == null ? string.Empty : Request.QueryString["AppInstanceID"].ToString(); if (!string.IsNullOrEmpty(AppInstanceID)) { int leaveID = int.Parse(AppInstanceID); HrsLeaveEntity hrsLeaveEntity = WorkFlows.GetHrsLeaveModel(leaveID); if (hrsLeaveEntity != null && hrsLeaveEntity.ID > 0) { selectLeaveType.Value = hrsLeaveEntity.LeaveType.ToString(); selectLeaveType.Disabled = true; txtDays.Value = hrsLeaveEntity.Days.ToString(); txtFromDate.Value = hrsLeaveEntity.FromDate.ToString("yyyy-MM-dd"); txtToDate.Value = hrsLeaveEntity.ToDate.ToString("yyyy-MM-dd"); this.txtDepmanagerRemark.Value = hrsLeaveEntity.DepManagerRemark; this.txtDirectorRemark.Value = hrsLeaveEntity.DirectorRemark; //主管总监 this.txtDeputyGeneralRemark.Value = hrsLeaveEntity.DeputyGeneralRemark; //副总经理 this.txtGeneralManagerRemark.Value = hrsLeaveEntity.GeneralManagerRemark; //总经理 txtCreatedByUserName.Value = hrsLeaveEntity.CreatedUserName; txtCreatedDateTime.Value = hrsLeaveEntity.CreatedDate.ToString("yyyy-MM-dd"); } } }
protected void InitFlowInfo() { int AppInstanceID = Request.QueryString["AppInstanceID"] == null ? 0 : Helper.ConverToInt32(Request.QueryString["AppInstanceID"].ToString()); if (AppInstanceID > 0) { HrsLeaveEntity hrsLeaveEntity = WorkFlows.GetHrsLeaveModel(AppInstanceID); if (hrsLeaveEntity != null && hrsLeaveEntity.ID > 0) { selectLeaveType.Value = hrsLeaveEntity.LeaveType.ToString(); selectLeaveType.Disabled = true; txtDays.Value = hrsLeaveEntity.Days.ToString(); txtFromDate.Value = hrsLeaveEntity.FromDate.ToString("yyyy-MM-dd"); txtToDate.Value = hrsLeaveEntity.ToDate.ToString("yyyy-MM-dd"); this.txtDepmanagerRemark.Value = hrsLeaveEntity.DepManagerRemark; this.txtDirectorRemark.Value = hrsLeaveEntity.DirectorRemark; //主管总监 this.txtDeputyGeneralRemark.Value = hrsLeaveEntity.DeputyGeneralRemark; //副总经理 this.txtGeneralManagerRemark.Value = hrsLeaveEntity.GeneralManagerRemark; //总经理 txtCreatedByUserName.Value = hrsLeaveEntity.CreatedUserName; txtCreatedDateTime.Value = hrsLeaveEntity.CreatedDate.ToString("yyyy-MM-dd"); } } }
/// <summary> /// 得到一个对象实体 /// </summary> private static HrsLeaveEntity GetHrsLeaveModel(DataTable dt) { if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { HrsLeaveEntity model = new HrsLeaveEntity(); if (dt.Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[0]["ID"].ToString()); } if (dt.Rows[0]["LeaveType"].ToString() != "") { model.LeaveType = int.Parse(dt.Rows[0]["LeaveType"].ToString()); } if (dt.Rows[0]["Days"].ToString() != "") { model.Days = decimal.Parse(dt.Rows[0]["Days"].ToString()); } if (dt.Rows[0]["FromDate"].ToString() != "") { model.FromDate = DateTime.Parse(dt.Rows[0]["FromDate"].ToString()); } if (dt.Rows[0]["ToDate"].ToString() != "") { model.ToDate = DateTime.Parse(dt.Rows[0]["ToDate"].ToString()); } model.CurrentActivityText = dt.Rows[0]["CurrentActivityText"].ToString(); if (dt.Rows[0]["Status"].ToString() != "") { model.Status = int.Parse(dt.Rows[0]["Status"].ToString()); } if (dt.Rows[0]["CreatedUserID"].ToString() != "") { model.CreatedUserID = int.Parse(dt.Rows[0]["CreatedUserID"].ToString()); } model.CreatedUserName = dt.Rows[0]["CreatedUserName"].ToString(); if (dt.Rows[0]["CreatedDate"].ToString() != "") { model.CreatedDate = DateTime.Parse(dt.Rows[0]["CreatedDate"].ToString()); } model.DepManagerRemark = dt.Rows[0]["DepManagerRemark"].ToString(); model.DirectorRemark = dt.Rows[0]["DirectorRemark"].ToString(); model.DeputyGeneralRemark = dt.Rows[0]["DeputyGeneralRemark"].ToString(); model.GeneralManagerRemark = dt.Rows[0]["GeneralManagerRemark"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条请假数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int AddHrsLeave(HrsLeaveEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into HrsLeave("); strSql.Append("LeaveType,Days,FromDate,ToDate,CurrentActivityText,Status,CreatedUserID,CreatedUserName,CreatedDate"); strSql.Append(") values ("); strSql.Append("@LeaveType,@Days,@FromDate,@ToDate,@CurrentActivityText,@Status,@CreatedUserID,@CreatedUserName,@CreatedDate"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@LeaveType", SqlDbType.SmallInt, 2), new SqlParameter("@Days", SqlDbType.Decimal, 18), new SqlParameter("@FromDate", SqlDbType.DateTime, 3), new SqlParameter("@ToDate", SqlDbType.DateTime, 3), new SqlParameter("@CurrentActivityText", SqlDbType.NVarChar, 50), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@CreatedUserID", SqlDbType.Int, 4), new SqlParameter("@CreatedUserName", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedDate", SqlDbType.DateTime, 3) }; int idx = 0; parameters[idx++].Value = model.LeaveType; parameters[idx++].Value = model.Days; parameters[idx++].Value = model.FromDate; parameters[idx++].Value = model.ToDate; parameters[idx++].Value = model.CurrentActivityText; parameters[idx++].Value = model.Status; parameters[idx++].Value = model.CreatedUserID; parameters[idx++].Value = model.CreatedUserName; parameters[idx++].Value = model.CreatedDate; object obj = SQLHelper.ExecuteScalar(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public ResponseResult UpdateLeave([FromBody] HrsLeaveEntity entity) { var result = ResponseResult.Default(); try { var hrsService = new HrsLeaveService(); var entityDB = hrsService.GetByID(entity.ID); entityDB.Opinions = entity.Opinions; hrsService.Update(entityDB); result = ResponseResult.Success(); } catch (System.Exception ex) { result = ResponseResult.Error(ex.Message); } return(result); }
/// <summary> /// 更新请假活动步骤数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateHrsLeave(HrsLeaveEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update HrsLeave set "); strSql.Append(" DepManagerRemark = @DepManagerRemark , "); strSql.Append(" DirectorRemark = @DirectorRemark , "); strSql.Append(" DeputyGeneralRemark = @DeputyGeneralRemark , "); strSql.Append(" GeneralManagerRemark = @GeneralManagerRemark , "); strSql.Append(" CurrentActivityText = @CurrentActivityText "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@DepManagerRemark", SqlDbType.NVarChar, 50), new SqlParameter("@DirectorRemark", SqlDbType.NVarChar, 50), new SqlParameter("@DeputyGeneralRemark", SqlDbType.NVarChar, 50), new SqlParameter("@GeneralManagerRemark", SqlDbType.NVarChar, 50), new SqlParameter("@CurrentActivityText", SqlDbType.NVarChar, 50) }; int idx = 0; parameters[idx++].Value = model.ID; parameters[idx++].Value = model.DepManagerRemark; parameters[idx++].Value = model.DirectorRemark; parameters[idx++].Value = model.DeputyGeneralRemark; parameters[idx++].Value = model.GeneralManagerRemark; parameters[idx++].Value = model.CurrentActivityText; int rows = SQLHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void Submit(HrsLeaveEntity entity) { var runner = WfAppRunner; var session = SessionFactory.CreateSession(); try { session.BeginTrans(); entity.CreatedDateTime = System.DateTime.Now; entity.ToDate = entity.FromDate.AddDays(Decimal.ToDouble(entity.Days)); var appInstanceID = QuickRepository.Insert <HrsLeaveEntity>(session.Connection, entity, session.Transaction); //保存流程中关于业务信息的关联信息 runner.AppInstanceID = appInstanceID.ToString(); runner.AppInstanceCode = string.Format("A4L-{0}", appInstanceID.ToString()); var wfService = new WorkflowService(); var wfResult = wfService.StartProcess(session.Connection, runner, session.Transaction); if (wfResult.Status == WfExecutedStatus.Success) { session.Commit(); } else { session.Rollback(); throw new ApplicationException(wfResult.Message); } } catch (System.Exception ex) { session.Rollback(); throw; } finally { session.Dispose(); } }
//提交请假信息 protected void btnSave_Click(object sender, EventArgs e) { try { string processGUID = this.txtProcessGUID.Value.ToString(); decimal days = Helper.ConverToDecimal(this.txtDays.Value); int leaveType = Helper.ConverToInt32(selectLeaveType.Value); string strNextActivityPerformers = hiddenNextActivityPerformers.Value.ToString().Trim(); IDictionary <string, PerformerList> nextActivityPerformers = NextActivityPerformers(strNextActivityPerformers); if (nextActivityPerformers == null) { base.RegisterStartupScript("", "<script>alert('请选择办理步骤或办理人员--Please select next step and user');</script>"); return; } DateTime now = DateTime.Now; //请假业务数据 HrsLeaveEntity hrsLeaveEntity = new HrsLeaveEntity(); hrsLeaveEntity.LeaveType = leaveType; hrsLeaveEntity.Days = days; try { hrsLeaveEntity.FromDate = Helper.ConvertToDateTime(this.txtFromDate.Value, now); } catch (Exception ex) { hrsLeaveEntity.FromDate = now; } try { hrsLeaveEntity.ToDate = Helper.ConvertToDateTime(this.txtToDate.Value, now); } catch (Exception ex) { hrsLeaveEntity.ToDate = now; } hrsLeaveEntity.CurrentActivityText = string.Empty; hrsLeaveEntity.Status = 0; hrsLeaveEntity.CreatedUserID = LoginUserID; hrsLeaveEntity.CreatedUserName = this.LoginUserName; hrsLeaveEntity.CreatedDate = now; int instanceId = WorkFlows.AddHrsLeave(hrsLeaveEntity); if (instanceId > 0) { //调用流程 IWorkflowService service = new WorkflowService(); WfAppRunner initiator = new WfAppRunner(); initiator.AppName = "请假流程(AskforLeaveProcess)"; initiator.AppInstanceID = instanceId.ToString(); initiator.ProcessGUID = processGUID; initiator.UserID = LoginUserID.ToString(); initiator.UserName = LoginUserName; initiator.Conditions = GetCondition(string.Format("days-{0}", days)); WfExecutedResult startedResult = service.StartProcess(initiator); if (startedResult.Status != WfExecutedStatus.Success) { base.RegisterStartupScript("", "<script>alert('" + startedResult.Message + "');</script>"); return; } //送往下一步 /* * PerformerList pList = new PerformerList(); * pList.Add(new Performer(nextUserID.ToString(), nextUserName)); * * initiator.NextActivityPerformers = new Dictionary<String, PerformerList>(); * initiator.NextActivityPerformers.Add(stepGuid, pList); */ initiator.NextActivityPerformers = nextActivityPerformers; WfExecutedResult runAppResult = service.RunProcessApp(initiator); if (runAppResult.Status != WfExecutedStatus.Success) { base.RegisterStartupScript("", "<script>alert('" + runAppResult.Message + "');</script>"); return; } //保存业务数据 //BizAppFlowEntity AppFlowEntity = new Entity.BizAppFlowEntity(); //AppFlowEntity.AppName = "流程发起"; //AppFlowEntity.AppInstanceID = instanceId.ToString(); //AppFlowEntity.ActivityName = "流程发起"; //AppFlowEntity.Remark = string.Format("申请人:{0}-{1}", LoginUserID, LoginUserName); //AppFlowEntity.ChangedTime = now; //AppFlowEntity.ChangedUserID = LoginUserID.ToString(); //AppFlowEntity.ChangedUserName = LoginUserName; //WorkFlows.AddBizAppFlow(AppFlowEntity); HrsLeaveOpinionEntity hrsleaveOpinionEntity = new HrsLeaveOpinionEntity(); hrsleaveOpinionEntity.AppInstanceID = instanceId.ToString(); hrsleaveOpinionEntity.ActivityID = System.Guid.Empty.ToString(); hrsleaveOpinionEntity.ActivityName = "流程发起(Apply)"; hrsleaveOpinionEntity.Remark = string.Format("申请人(Applicant):{0}-{1}", LoginUserID, LoginUserName); hrsleaveOpinionEntity.ChangedTime = now; hrsleaveOpinionEntity.ChangedUserID = LoginUserID.ToString(); hrsleaveOpinionEntity.ChangedUserName = LoginUserName; WorkFlows.AddHrsLeaveOpinion(hrsleaveOpinionEntity); base.RegisterStartupScript("", "<script>alert('流程发起成功--Successed');window.location.href='FlowList.aspx';</script>"); } } catch (Exception ex) { base.RegisterStartupScript("", "<script>alert('流程发起出现异常--EXCEPTION:" + ex.ToString() + "');</script>"); } }
//提交请假信息 protected void btnSave_Click(object sender, EventArgs e) { try { string processGUID = this.txtProcessGUID.Value.ToString(); string stepGuid = this.hiddenStepGuid.Value.ToString(); int stepUserID = Helper.ConverToInt32(this.hiddenStepUser.Value.ToString().Trim()); decimal days = Helper.ConverToDecimal(this.txtDays.Value); int leaveType = Helper.ConverToInt32(selectLeaveType.Value); int nextUserID = 0; string nextUserName = string.Empty; SysUserEntity userEntity = WorkFlows.GetSysUserModel(stepUserID); if (userEntity != null && userEntity.ID > 0) { nextUserID = userEntity.ID; nextUserName = userEntity.UserName; } DateTime now = DateTime.Now; //请假业务数据 HrsLeaveEntity hrsLeaveEntity = new HrsLeaveEntity(); hrsLeaveEntity.LeaveType = leaveType; hrsLeaveEntity.Days = days; try { hrsLeaveEntity.FromDate = Helper.ConvertToDateTime(this.txtFromDate.Value, now); } catch (Exception ex) { hrsLeaveEntity.FromDate = now; } try { hrsLeaveEntity.ToDate = Helper.ConvertToDateTime(this.txtToDate.Value, now); } catch (Exception ex) { hrsLeaveEntity.ToDate = now; } hrsLeaveEntity.CurrentActivityText = string.Empty; hrsLeaveEntity.Status = 0; hrsLeaveEntity.CreatedUserID = LoginUserID; hrsLeaveEntity.CreatedUserName = this.LoginUserName; hrsLeaveEntity.CreatedDate = now; int instanceId = WorkFlows.AddHrsLeave(hrsLeaveEntity); if (instanceId > 0) { //调用流程 IWorkflowService service = new WorkflowService(); WfAppRunner initiator = new WfAppRunner(); initiator.AppName = "请假流程"; initiator.AppInstanceID = instanceId.ToString(); initiator.ProcessGUID = processGUID; initiator.UserID = LoginUserID.ToString(); initiator.UserName = LoginUserName; initiator.Conditions = GetCondition(string.Format("days-{0}", days)); WfExecutedResult startedResult = service.StartProcess(initiator); if (startedResult.Status != WfExecutedStatus.Success) { base.RegisterStartupScript("", "<script>alert('" + startedResult.Message + "');</script>"); return; } //送往下一步 PerformerList pList = new PerformerList(); pList.Add(new Performer(nextUserID.ToString(), nextUserName)); initiator.NextActivityPerformers = new Dictionary <String, PerformerList>(); initiator.NextActivityPerformers.Add(stepGuid, pList); WfExecutedResult runAppResult = service.RunProcessApp(initiator); if (runAppResult.Status != WfExecutedStatus.Success) { base.RegisterStartupScript("", "<script>alert('" + runAppResult.Message + "');</script>"); return; } //保存业务数据 BizAppFlowEntity AppFlowEntity = new Entity.BizAppFlowEntity(); AppFlowEntity.AppName = "流程发起"; AppFlowEntity.AppInstanceID = instanceId.ToString(); AppFlowEntity.ActivityName = "流程发起"; AppFlowEntity.Remark = string.Format("申请人:{0}-{1}", LoginUserID, LoginUserName); AppFlowEntity.ChangedTime = now; AppFlowEntity.ChangedUserID = LoginUserID; AppFlowEntity.ChangedUserName = LoginUserName; WorkFlows.AddBizAppFlow(AppFlowEntity); base.RegisterStartupScript("", "<script>alert('流程发起成功');window.location.href='FlowList.aspx';</script>"); } } catch (Exception ex) { base.RegisterStartupScript("", "<script>alert('流程发起出现异常 EXCEPTION:" + ex.ToString() + "');</script>"); } }
/// <summary> /// 增加一条请假数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int AddHrsLeave(HrsLeaveEntity model) { return(WorkFlowManager.AddHrsLeave(model)); }
/// <summary> /// 更新请假活动步骤数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateHrsLeave(HrsLeaveEntity model) { return(WorkFlowManager.UpdateHrsLeave(model)); }
protected void InitFlowInfo() { string AppInstanceID = Request.QueryString["AppInstanceID"] == null ? string.Empty : Request.QueryString["AppInstanceID"].ToString(); string ProcessGUID = Request.QueryString["ProcessGUID"] == null ? string.Empty : Request.QueryString["ProcessGUID"].ToString(); int ActivityInstanceID = Request.QueryString["ActivityInstanceID"] == null ? 0 : Helper.ConverToInt32(Request.QueryString["ActivityInstanceID"].ToString()); if (!string.IsNullOrEmpty(AppInstanceID)) { int leaveID = int.Parse(AppInstanceID); HrsLeaveEntity hrsLeaveEntity = WorkFlows.GetHrsLeaveModel(leaveID); if (hrsLeaveEntity != null && hrsLeaveEntity.ID > 0) { selectLeaveType.Value = hrsLeaveEntity.LeaveType.ToString(); selectLeaveType.Disabled = true; txtDays.Value = hrsLeaveEntity.Days.ToString(); txtFromDate.Value = hrsLeaveEntity.FromDate.ToString("yyyy-MM-dd"); txtToDate.Value = hrsLeaveEntity.ToDate.ToString("yyyy-MM-dd"); hiddenInstanceId.Value = hrsLeaveEntity.ID.ToString(); hiddenActivityInstanceID.Value = ActivityInstanceID.ToString(); this.txtDepmanagerRemark.Value = hrsLeaveEntity.DepManagerRemark; this.txtDirectorRemark.Value = hrsLeaveEntity.DirectorRemark; //主管总监 this.txtDeputyGeneralRemark.Value = hrsLeaveEntity.DeputyGeneralRemark; //副总经理 this.txtGeneralManagerRemark.Value = hrsLeaveEntity.GeneralManagerRemark; //总经理 //权限设置 IWorkflowService service = new WorkflowService(); ActivityInstanceEntity activityInstanceEntity = service.GetActivityInstance(ActivityInstanceID); ProcessInstanceEntity processInstanceEntity = service.GetProcessInstance(activityInstanceEntity.ProcessInstanceID); this.txtProcessGUID.Value = activityInstanceEntity.ProcessGUID; if (activityInstanceEntity != null) { ActivityEntity activityEntity = service.GetActivityEntity(processInstanceEntity.ProcessGUID, processInstanceEntity.Version, activityInstanceEntity.ActivityGUID); var roles = service.GetActivityRoles(processInstanceEntity.ProcessGUID, processInstanceEntity.Version, activityInstanceEntity.ActivityGUID); if (activityEntity != null && roles != null && roles.Count > 0) { foreach (var role in roles) { if (role.ID == LoginRoleID.ToString()) { switch (role.ID) { case "2": //部门经理 this.txtDepmanagerRemark.Disabled = false; hiddenPerformField.Value = "DepManager"; break; case "4": //主管总监 this.txtDirectorRemark.Disabled = false; hiddenPerformField.Value = "Director"; break; case "7": //副总经理 this.txtDeputyGeneralRemark.Disabled = false; hiddenPerformField.Value = "Deputy"; break; case "8": //总经理 this.txtGeneralManagerRemark.Disabled = false; hiddenPerformField.Value = "General"; break; } } } } } } } }
public void Update(HrsLeaveEntity entity) { QuickRepository.Update <HrsLeaveEntity>(entity); }