/// <summary>
/// 保存流程实例
/// </summary>
/// <returns></returns>
private string SaveWorkFlowInstance()
{
WorkFlowInstance workFlowInstance = wf_WorkFlowInstance.GetWorkFlowInstanceByFormId(FormId);
if (workFlowInstance == null)
{
workFlowInstance = new WorkFlowInstance();
workFlowInstance.InstanceId = Guid.NewGuid().ToString();
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.AppId = AppID;
workFlowInstance.FormId = FormId;
workFlowInstance.CreateDeptCode = CurrentEmployee.DepartCode;
workFlowInstance.CreateDeptName = CurrentEmployee.DepartName;
workFlowInstance.CreateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.CreateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.FormTitle = GetFormTitle();
workFlowInstance.WfStatus = "0";
wf_WorkFlowInstance.AddWorkFlowInstance(workFlowInstance);
SaveWorkItem(workFlowInstance.InstanceId);
_BPMContext.ProcID = workFlowInstance.InstanceId;
}
else
{
workFlowInstance.CreateDeptCode = CurrentEmployee.DepartCode;
workFlowInstance.CreateDeptName = CurrentEmployee.DepartName;
workFlowInstance.UpdateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.UpdateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.FormTitle = GetFormTitle();
wf_WorkFlowInstance.UpdateWorkFlowInstance(workFlowInstance);
}
return(workFlowInstance == null ? "" : workFlowInstance.InstanceId);
}
private bool SaveWorkFlowInstance(string WfStatus, DateTime?SumitTime, string WfInstanceId)
{
bool result = false;
WorkFlowInstance workFlowInstance = null;
try
{
workFlowInstance = wf_WorkFlowInstance.GetWorkFlowInstanceByFormId(FormId);
bool isEdit = false;
if (workFlowInstance == null)
{
workFlowInstance = new WorkFlowInstance();
workFlowInstance.InstanceId = Guid.NewGuid().ToString();
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.AppId = "10105";
workFlowInstance.CreateDeptCode = CurrentEmployee.DepartCode;
workFlowInstance.CreateDeptName = CurrentEmployee.DepartName;
workFlowInstance.CreateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.CreateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.FormTitle = PaymentApplication_Common.GetErpFormTitle(this);
_BPMContext.ProcID = workFlowInstance.InstanceId;
}
else
{
isEdit = true;
workFlowInstance.UpdateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.UpdateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.AppId = "10105";
}
workFlowInstance.FormId = FormId;
workFlowInstance.WfStatus = WfStatus;
if (SumitTime != null)
{
workFlowInstance.SumitTime = SumitTime;
}
if (WfInstanceId != "")
{
workFlowInstance.WfInstanceId = WfInstanceId;
}
if (!isEdit)
{
result = wf_WorkFlowInstance.AddWorkFlowInstance(workFlowInstance);
}
else
{
result = wf_WorkFlowInstance.UpdateWorkFlowInstance(workFlowInstance);
}
FlowRelated1.ProcId = workFlowInstance.InstanceId;
Countersign1.ProcId = workFlowInstance.InstanceId;
Countersign1.SaveData(true);//会签数据保存
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 保存工作流实例
/// </summary>
/// <param name="p"></param>
/// <param name="dateTime"></param>
/// <param name="p_2"></param>
/// <returns></returns>
private bool SaveWorkFlowInstance(string WfStatus, DateTime?SumitTime, string WfInstanceId)
{
bool result = false;
WorkFlowInstance workFlowInstance = null;
try
{
workFlowInstance = wf_WorkFlowInstance.GetWorkFlowInstanceByFormId(FormId);
bool isEdit = false;
if (workFlowInstance == null)
{
workFlowInstance = new WorkFlowInstance();
workFlowInstance.InstanceId = Guid.NewGuid().ToString();
workFlowInstance.CreateAtTime = DateTime.Now;
//appid和应用管理创建新的管理的应用号是一致的
workFlowInstance.AppId = "10113";
workFlowInstance.CreateDeptCode = ddlDepartName.SelectedItem.Value.ToString();
workFlowInstance.CreateDeptName = ddlDepartName.SelectedItem.Text;
workFlowInstance.CreateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.CreateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.FormTitle = tbTitle.Text;
}
else
{
isEdit = true;
workFlowInstance.UpdateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.UpdateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.FormTitle = tbTitle.Text;
workFlowInstance.AppId = "10113";
}
workFlowInstance.FormId = FormId;
workFlowInstance.WfStatus = WfStatus;
if (SumitTime != null)
{
workFlowInstance.SumitTime = SumitTime;
}
if (WfInstanceId != "")
{
workFlowInstance.WfInstanceId = WfInstanceId;
}
if (!isEdit)
{
result = wf_WorkFlowInstance.AddWorkFlowInstance(workFlowInstance);
}
else
{
result = wf_WorkFlowInstance.UpdateWorkFlowInstance(workFlowInstance);
}
FlowRelated1.ProcId = workFlowInstance.InstanceId;
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
private bool SaveWorkFlowInstance(InstructionOfPKURGIInfo obj, string WfStatus, DateTime?SumitTime, string WfInstanceId)
{
bool result = false;
WorkFlowInstance workFlowInstance = null;
try
{
workFlowInstance = wf_WorkFlowInstance.GetWorkFlowInstanceByFormId(obj.FormID);
bool isEdit = false;
if (workFlowInstance == null)
{
workFlowInstance = new WorkFlowInstance();
workFlowInstance.InstanceId = Guid.NewGuid().ToString();
workFlowInstance.CreateDeptCode = ddlDepartName.SelectedItem.Value.ToString();
workFlowInstance.CreateDeptName = ddlDepartName.SelectedItem.Text;
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.CreateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.CreateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.AppId = "3001";
}
else
{
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.UpdateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.UpdateByUserName = CurrentEmployee.EmployeeName;
isEdit = true;
}
workFlowInstance.FormId = obj.FormID;
workFlowInstance.FormTitle = obj.Title;
workFlowInstance.WfStatus = WfStatus;
if (SumitTime != null)
{
workFlowInstance.SumitTime = SumitTime;
}
if (WfInstanceId != "")
{
workFlowInstance.WfInstanceId = WfInstanceId;
}
if (!isEdit)
{
result = wf_WorkFlowInstance.AddWorkFlowInstance(workFlowInstance);
}
else
{
result = wf_WorkFlowInstance.UpdateWorkFlowInstance(workFlowInstance);
}
FlowRelated1.ProcId = workFlowInstance.InstanceId;
Countersign1.ProcId = workFlowInstance.InstanceId;
Countersign1.SaveData(true);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 保存流程实例
/// </summary>
/// <returns></returns>
private string SaveWorkFlowInstance()
{
string startDeptName = "";
if (string.IsNullOrWhiteSpace(StartDeptId))
{
StartDeptId = CurrentEmployee.DepartCode;
startDeptName = CurrentEmployee.DepartName;
}
else
{
Department deptInfo = new Pkurg.PWorld.Services.DepartmentService().GetByDepartCode(StartDeptId);
if (deptInfo != null)
{
startDeptName = deptInfo.Remark;
}
}
WorkFlowInstance workFlowInstance = wf_WorkFlowInstance.GetWorkFlowInstanceByFormId(FormId);
if (workFlowInstance == null)
{
workFlowInstance = new WorkFlowInstance();
workFlowInstance.InstanceId = Guid.NewGuid().ToString();
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.AppId = AppID;
workFlowInstance.FormId = FormId;
workFlowInstance.CreateDeptCode = StartDeptId;// CurrentEmployee.DepartCode;
workFlowInstance.CreateDeptName = startDeptName;
workFlowInstance.CreateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.CreateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.FormTitle = GetFormTitle();
workFlowInstance.WfStatus = "0";
wf_WorkFlowInstance.AddWorkFlowInstance(workFlowInstance);
SaveWorkItem(workFlowInstance.InstanceId);
_BPMContext.ProcID = workFlowInstance.InstanceId;
}
else
{
workFlowInstance.CreateDeptCode = StartDeptId;
workFlowInstance.CreateDeptName = startDeptName;
workFlowInstance.UpdateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.UpdateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.FormTitle = GetFormTitle();
wf_WorkFlowInstance.UpdateWorkFlowInstance(workFlowInstance);
}
return(workFlowInstance == null ? "" : workFlowInstance.InstanceId);
}
public bool CreateNewFormByInstanceIDAndEmployeeCodeWithStoredProcedure(string InstanceID, string EmployeeCode, string sp)
{
DataProvider dataProvider = new DataProvider();
dataProvider.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString;
BFEmployee bfEmployee = new BFEmployee();
Employee employeeInfo = new Employee();
WF_WorkFlowInstance wFlowInst = new WF_WorkFlowInstance();
BFApprovalRecord bFApprovalRecord = new BFApprovalRecord();
EmployeeAdditional employeeAddition = bfEmployee.GetEmployeeAdditionalById(EmployeeCode);
employeeInfo = bfEmployee.GetEmployeeByEmployeeCode(EmployeeCode);
string EmployeeName = bfEmployee.GetEmployeeNameByEmployeeCode(EmployeeCode);
WorkFlowInstance wFlowInstanceBefore = new WorkFlowInstance();
wFlowInstanceBefore = wFlowInst.GetWorkFlowInstanceById(InstanceID);
WorkFlowInstance newWorkFlowInstance = new WorkFlowInstance();
{
newWorkFlowInstance.InstanceId = Guid.NewGuid().ToString();
newWorkFlowInstance.AppId = wFlowInstanceBefore.AppId;
newWorkFlowInstance.FormId = BPMHelp.GetSerialNumber("SQ_");
newWorkFlowInstance.WfInstanceId = wFlowInstanceBefore.WfInstanceId;
newWorkFlowInstance.OrderNo = wFlowInstanceBefore.OrderNo;
newWorkFlowInstance.IsDel = 0;
newWorkFlowInstance.CreateByUserCode = EmployeeCode;
newWorkFlowInstance.CreateByUserName = EmployeeName;
newWorkFlowInstance.CreateAtTime = System.DateTime.Now;
newWorkFlowInstance.UpdateByUserCode = EmployeeCode;
newWorkFlowInstance.UpdateByUserName = EmployeeName;
newWorkFlowInstance.UpdateAtTime = wFlowInstanceBefore.UpdateAtTime;
newWorkFlowInstance.CreateDeptCode = employeeInfo.DepartCode;
newWorkFlowInstance.CreateDeptName = employeeInfo.DepartName;
newWorkFlowInstance.WorkItemCode = wFlowInstanceBefore.WorkItemCode;
newWorkFlowInstance.WorkItemName = wFlowInstanceBefore.WorkItemName;
newWorkFlowInstance.WfTaskId = wFlowInstanceBefore.WfTaskId;
newWorkFlowInstance.FinishedTime = null;
newWorkFlowInstance.Remark = wFlowInstanceBefore.Remark;
newWorkFlowInstance.FormTitle = wFlowInstanceBefore.FormTitle;
newWorkFlowInstance.WfStatus = "0";
newWorkFlowInstance.SumitTime = null;
newWorkFlowInstance.FormData = wFlowInstanceBefore.FormData;
}
var newApprovalRecord = new Pkurg.PWorldBPM.Business.Sys.WF_Approval_Record();
newApprovalRecord.ApprovalID = Guid.NewGuid().ToString();
newApprovalRecord.FormID = newWorkFlowInstance.FormId;
newApprovalRecord.InstanceID = newWorkFlowInstance.InstanceId;
newApprovalRecord.CreateByUserCode = employeeInfo.EmployeeCode;
newApprovalRecord.CreateByUserName = employeeInfo.EmployeeName;
newApprovalRecord.CreateAtTime = System.DateTime.Now;
newApprovalRecord.ApproveByUserCode = employeeInfo.EmployeeCode;
newApprovalRecord.ApproveByUserName = employeeInfo.EmployeeName;
newApprovalRecord.UpdateByUserCode = employeeInfo.EmployeeCode;
newApprovalRecord.UpdateByUserName = employeeInfo.EmployeeName;
newApprovalRecord.UpdateAtTime = wFlowInstanceBefore.UpdateAtTime;
newApprovalRecord.CurrentActiveName = "拟稿";
Pkurg.BPM.Entities.FlowRelated relationInfo = new FlowRelated()
{
FlowId = newWorkFlowInstance.InstanceId,
CreatorName = employeeInfo.EmployeeName,
CreateTime = System.DateTime.Now,
CreatorId = employeeInfo.EmployeeCode,
RelatedFlowId = wFlowInstanceBefore.InstanceId,
RelatedFlowCreator = wFlowInstanceBefore.CreateByUserName,
RelatedFlowEndTime = wFlowInstanceBefore.FinishedTime,
RelatedFlowName = wFlowInstanceBefore.FormTitle,
};
WF_Relation.AddRelatedFlowInfo(relationInfo);
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@FormID_Before", System.Data.SqlDbType.NVarChar, 100),
new SqlParameter("@FormID_New", System.Data.SqlDbType.NVarChar, 100)
};
parameters[0].Value = wFlowInstanceBefore.FormId;
parameters[1].Value = newWorkFlowInstance.FormId;
dataProvider.ExecutedProcedure(sp, parameters);
bool isSuccessForInstance = wFlowInst.AddWorkFlowInstance(newWorkFlowInstance);
bool isSuccessForApprovalRecord = bFApprovalRecord.AddApprovalRecord(newApprovalRecord);
if (isSuccessForInstance && isSuccessForApprovalRecord)
{
return(true);
}
else
{
return(false);
}
}
private bool SaveWorkFlowInstance(JC_BidScalingInfo obj, string WfStatus, DateTime?SumitTime, string WfInstanceId)
{
string methodName = "SaveWorkFlowInstance";
Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + Pkurg.PWorldBPM.Common.Log.MessageType.IN);
bool result = false;
WorkFlowInstance workFlowInstance = null;
try
{
workFlowInstance = wf_WorkFlowInstance.GetWorkFlowInstanceByFormId(obj.FormID);
bool isEdit = false;
if (workFlowInstance == null)
{
workFlowInstance = new WorkFlowInstance();
workFlowInstance.InstanceId = Guid.NewGuid().ToString();
workFlowInstance.CreateDeptCode = ddlDepartName.SelectedItem.Value.ToString();
workFlowInstance.CreateDeptName = ddlDepartName.SelectedItem.Text;
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.CreateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.CreateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.AppId = "1003";
}
else
{
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.UpdateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.UpdateByUserName = CurrentEmployee.EmployeeName;
isEdit = true;
}
workFlowInstance.FormId = obj.FormID;
workFlowInstance.FormTitle = obj.Title;
workFlowInstance.WfStatus = WfStatus;
if (SumitTime != null)
{
workFlowInstance.SumitTime = SumitTime;
}
if (WfInstanceId != "")
{
workFlowInstance.WfInstanceId = WfInstanceId;
}
if (!isEdit)
{
result = wf_WorkFlowInstance.AddWorkFlowInstance(workFlowInstance);
}
else
{
result = wf_WorkFlowInstance.UpdateWorkFlowInstance(workFlowInstance);
}
FlowRelated1.ProcId = workFlowInstance.InstanceId;
string StartDeptId = ddlDepartName.SelectedItem.Value;
if (StartDeptId.Substring(0, StartDeptId.LastIndexOf('-')) != PKURGICode)
{
Countersign1.ProcId = workFlowInstance.InstanceId;
Countersign1.SaveData(true);
Countersign_Group1.ProcId = workFlowInstance.InstanceId;
Countersign_Group1.SaveData(true);
}
else
{
Countersign_Group1.ProcId = workFlowInstance.InstanceId;
Countersign_Group1.SaveData(true);
}
}
catch (Exception ex)
{
Logger.Write(this.GetType(), EnumLogLevel.Fatal, className + ":" + methodName + ":" + Pkurg.PWorldBPM.Common.Log.MessageType.Exception + ":" + string.Format("Exception={0}", ex));
throw ex;
}
Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + Pkurg.PWorldBPM.Common.Log.MessageType.OUT);
return(result);
}
private bool SaveWorkFlowInstance(CadresOrRemovalInfo obj, string WfStatus, DateTime?SumitTime, string WfInstanceId)
{
bool result = false;
WorkFlowInstance workFlowInstance = null;
try
{
workFlowInstance = wf_WorkFlowInstance.GetWorkFlowInstanceByFormId(obj.FormID);
bool isEdit = false;
if (workFlowInstance == null)
{
workFlowInstance = new WorkFlowInstance();
workFlowInstance.InstanceId = Guid.NewGuid().ToString();
workFlowInstance.CreateDeptCode = CurrentEmployee.DepartCode;
workFlowInstance.CreateDeptName = CurrentEmployee.DepartName;
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.CreateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.CreateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.AppId = "3013";
}
else
{
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.UpdateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.UpdateByUserName = CurrentEmployee.EmployeeName;
isEdit = true;
}
workFlowInstance.FormId = obj.FormID;
if (chkCadresOrRemoval.SelectedIndex == 0)
{
workFlowInstance.FormTitle = tbCadresName.Text + "的干部任职审批表";
}
else if (chkCadresOrRemoval.SelectedIndex == 1)
{
workFlowInstance.FormTitle = tbRemovalName.Text + "的干部免职审批表";
}
else
{
workFlowInstance.FormTitle = tbCadresName.Text + "的干部任职和" + tbRemovalName.Text + "的干部免职审批表";
}
workFlowInstance.WfStatus = WfStatus;
if (SumitTime != null)
{
workFlowInstance.SumitTime = SumitTime;
}
if (WfInstanceId != "")
{
workFlowInstance.WfInstanceId = WfInstanceId;
}
if (!isEdit)
{
result = wf_WorkFlowInstance.AddWorkFlowInstance(workFlowInstance);
}
else
{
result = wf_WorkFlowInstance.UpdateWorkFlowInstance(workFlowInstance);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
private bool SaveWorkFlowInstance(JC_ElevatorOrderInfo jcInfo, string WfStatus, DateTime?SumitTime, string WfInstanceId)
{
string methodName = "SaveWorkFlowInstance";
Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + Pkurg.PWorldBPM.Common.Log.MessageType.IN);
bool result = false;
WorkFlowInstance workFlowInstance = null;
try
{
workFlowInstance = wf_WorkFlowInstance.GetWorkFlowInstanceByFormId(jcInfo.FormID);
bool isEdit = false;
if (workFlowInstance == null)
{
workFlowInstance = new WorkFlowInstance();
workFlowInstance.InstanceId = Guid.NewGuid().ToString();
workFlowInstance.CreateDeptCode = CurrentEmployee.DepartCode;
workFlowInstance.CreateDeptName = CurrentEmployee.DepartName;
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.CreateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.CreateByUserName = CurrentEmployee.EmployeeName;
workFlowInstance.AppId = "10106";
}
else
{
workFlowInstance.CreateAtTime = DateTime.Now;
workFlowInstance.UpdateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.UpdateByUserName = CurrentEmployee.EmployeeName;
isEdit = true;
}
workFlowInstance.FormId = jcInfo.FormID;
workFlowInstance.FormTitle = jcInfo.ReportTitle;
workFlowInstance.WfStatus = WfStatus;
if (SumitTime != null)
{
workFlowInstance.SumitTime = SumitTime;
}
if (WfInstanceId != "")
{
workFlowInstance.WfInstanceId = WfInstanceId;
}
if (!isEdit)
{
result = wf_WorkFlowInstance.AddWorkFlowInstance(workFlowInstance);
}
else
{
result = wf_WorkFlowInstance.UpdateWorkFlowInstance(workFlowInstance);
}
Countersign1.ProcId = workFlowInstance.InstanceId;
Countersign1.SaveData(true);
}
catch (Exception ex)
{
Logger.Write(this.GetType(), EnumLogLevel.Fatal, className + ":" + methodName + ":" + Pkurg.PWorldBPM.Common.Log.MessageType.Exception + ":" + string.Format("Exception={0}", ex));
throw ex;
}
Logger.Write(this.GetType(), EnumLogLevel.Info, className + ":" + methodName + ":" + Pkurg.PWorldBPM.Common.Log.MessageType.OUT);
return(result);
}
