public static StatusReport BussinessHandler_Save(string instanceId, string userId, string leaveMessage,
string docTableName, string docTableId, string tableUpdateData, string updateKeys, string registId,
string transformConditionAndExplain, string checkResult, string businessId, string tableNumber, string nextControlLinkId,
string nextControlLink_UserId, string nextOutOfControlLinkIds, string nextOutOfControlLink_UserIds)
{
string updateString = GetUpdateString(tableUpdateData, updateKeys);
//return null;
string sqlString = "[sp_extcall_业务处理保存]";
SqlParameter spInstanceId = new SqlParameter("@实例ID", SqlDbType.Int);
SqlParameter spUserId = new SqlParameter("@用户ID", SqlDbType.Int);
SqlParameter spLeaveMessage = new SqlParameter("@留言", SqlDbType.NVarChar);
SqlParameter spDocTableName = new SqlParameter("@文档表名称", SqlDbType.NVarChar);
SqlParameter spDocTableId = new SqlParameter("@文档表ID", SqlDbType.Int);
SqlParameter spTableUpdateData = new SqlParameter("@表单更新数据", SqlDbType.NVarChar);
SqlParameter spRegistId = new SqlParameter("@登记ID", SqlDbType.Int);
SqlParameter spTransformConditionAndExplain = new SqlParameter("@传递条件及说明", SqlDbType.NVarChar);
SqlParameter spCheckResult = new SqlParameter("@审核结果", SqlDbType.NVarChar);
SqlParameter spBusinessId = new SqlParameter("@业务ID", SqlDbType.Int);
SqlParameter spTableNumber = new SqlParameter("@表单编号", SqlDbType.NVarChar);
SqlParameter spNextControlLinkId = new SqlParameter("@下一控制环节ID", SqlDbType.Int);
SqlParameter spNextControlLink_UserId = new SqlParameter("@下一控制环节_用户ID", SqlDbType.Int);
SqlParameter spNextOutOfControlLinkIds = new SqlParameter("@下一非控制环节IDs", SqlDbType.NVarChar);
SqlParameter spNextOutOfControlLink_UserIds = new SqlParameter("@下一非控制环节_用户IDs", SqlDbType.NVarChar);
spInstanceId.Value = Convert.ToInt32(instanceId);
spUserId.Value = Convert.ToInt32(userId);
spLeaveMessage.Value = DataTypeHelper.GetDBValue(leaveMessage);
spDocTableName.Value = DataTypeHelper.GetDBValue(docTableName);
spDocTableId.Value = Convert.ToInt32(docTableId);
spTableUpdateData.Value = DataTypeHelper.GetDBValue(updateString);
spRegistId.Value = Convert.ToInt32(registId);
spTransformConditionAndExplain.Value = DataTypeHelper.GetDBValue(transformConditionAndExplain);
spCheckResult.Value = DataTypeHelper.GetDBValue(checkResult);
spBusinessId.Value = Convert.ToInt32(businessId);
spTableNumber.Value = DataTypeHelper.GetDBValue(tableNumber);
//spNextControlLinkId.Value = DBNull.Value;
//spNextOutOfControlLinkIds.Value = DBNull.Value;
//spNextOutOfControlLink_UserIds.Value = DBNull.Value;
spNextControlLinkId.Value = Convert.ToInt32(nextControlLinkId);
//spNextControlLink_UserId.Value = DataTypeHelper.GetDBValue(nextControlLink_UserId);
spNextOutOfControlLinkIds.Value = DataTypeHelper.GetDBValue(nextOutOfControlLinkIds);
spNextOutOfControlLink_UserIds.Value = DataTypeHelper.GetAllowEmptyDBValue(nextOutOfControlLink_UserIds);
if (Convert.ToInt32(nextControlLink_UserId) == 0)
{
spNextControlLink_UserId.Value = DBNull.Value;
}
else
{
spNextControlLink_UserId.Value = Convert.ToInt32(nextControlLink_UserId);
}
//return null;
StatusReport sr = new StatusReport();
try
{
DataSet ds = SQLHelper.ExecuteProcedure("wyt", sqlString, spInstanceId, spUserId, spLeaveMessage, spDocTableName,
spDocTableId, spTableUpdateData, spRegistId, spTransformConditionAndExplain, spCheckResult, spBusinessId, spTableNumber,
spNextControlLinkId, spNextControlLink_UserId, spNextOutOfControlLinkIds, spNextOutOfControlLink_UserIds);
sr.status = "Success";
sr.result = "成功";
return(sr);
}
catch (Exception e)
{
sr.status = "Fail";
sr.result = "传递到下一步失败：" + e.Message;
return(sr);
}
//DataTable dtallowReceiveLinks = ds.Tables[0];
//List<object> allowReceiveLinkList = new List<object>();
//foreach (DataRow dr in dtallowReceiveLinks.Rows)
//{
// var item = new
// {
// linkId = DataTypeHelper.GetIntValue(dr["环节ID"]),
// task = DataTypeHelper.GetIntValue(dr["任务"]),
// staffId = DataTypeHelper.GetIntValue(dr["人员ID"]),
// operationStaff = DataTypeHelper.GetStringValue(dr["操作人员"]),
// department = DataTypeHelper.GetStringValue(dr["部门"]),
// selectExplain = DataTypeHelper.GetStringValue(dr["选择说明"]),
// selectCondition = DataTypeHelper.GetStringValue(dr["选择条件"]),
// assignOperator = DataTypeHelper.GetIntValue(dr["指定具体接收人"]),
// objectExplain = DataTypeHelper.GetStringValue(dr["对象描述"]),
// operationStaffLimit = DataTypeHelper.GetStringValue(dr["操作人员限制"]),
// selectedRoleMemberId = DataTypeHelper.GetIntValue(dr["指定角色成员ID"]),
// staffHandling = DataTypeHelper.GetStringValue(dr["经手人信息"]),
// staffHandled = DataTypeHelper.GetStringValue(dr["曾经经手"])
// };
// allowReceiveLinkList.Add(item);
//}
//var data = new
//{
// //allowReceiveLinks = allowReceiveLinkList.ToArray(),
// //allowReceiveStaffs = BussinessHandler_NextLink_ReceiveStaffs_Private(userId, registId, businessId, DataTypeHelper.GetStringValue(dtallowReceiveLinks.Rows[0]["环节ID"]), DataTypeHelper.GetStringValue(dtallowReceiveLinks.Rows[0]["任务"]), DataTypeHelper.GetStringValue(dtallowReceiveLinks.Rows[0]["人员ID"]), DataTypeHelper.GetStringValue(dtallowReceiveLinks.Rows[0]["操作人员限制"]), DataTypeHelper.GetStringValue(dtallowReceiveLinks.Rows[0]["指定角色成员ID"]), DataTypeHelper.GetStringValue(dtallowReceiveLinks.Rows[0]["经手人信息"]), lastInstanceId, department, secondDepartment, thirdDepartment, registerId)
//};
}
