public static StatusReport SetLookOverResult(string userName, string isSpotCheck, string items)
{
using (StreamWriter sw = new StreamWriter("D:\\1_importTemp\\TestFile1.txt"))
{
sw.WriteLine(items);
sw.WriteLine(JsonConvert.SerializeObject(items));
}
StatusReport sr = new StatusReport();
string sqlString = " update 基础资料_巡检记录 set 巡检人 = @巡检人, 巡检时间 = @巡检时间, " +
" 是否合格 = @是否合格, 是否抽检 = @是否抽检, 不合格说明 = @不合格说明 " +
" where ID = @ID ";
JArray itemArray = (JArray)JsonConvert.DeserializeObject(items);
for (int i = 0; i < itemArray.Count; i++)
{
JObject item = (JObject)itemArray[i];
sr = SQLHelper.Update("wyt", sqlString,
new SqlParameter("@巡检人", userName),
new SqlParameter("@巡检时间", DateTime.Now),
new SqlParameter("@是否合格", Convert.ToBoolean(item["isNormal"]) ? "是" : "否"),
new SqlParameter("@是否抽检", isSpotCheck),
new SqlParameter("@不合格说明", DataTypeHelper.GetDBValue(item["explain"].ToString())),
new SqlParameter("@ID", DataTypeHelper.GetDBValue(item["id"].ToString())));
}
return(sr);
}
public static StatusReport SetDecorationPatrolResult(string id, string classify, string checkMan, string checkDate,
string dealWay, string havePeople, string isNormal, string otherUnnormalItemExplain, string schedule,
string unnormalItemNumber, string roomNumber)
{
StatusReport sr = new StatusReport();
string sqlString = " insert into 基础资料_装修巡检 " +
" (分类,装修表ID,房产编号,巡检日期,巡检人,是否正常,不合格项编号,其他不合格内容说明,现场是否有人,处理方式,装修进度) " +
" select " +
" @分类,@装修表ID,@房产编号,@巡检日期,@巡检人,@是否正常,@不合格项编号,@其他不合格内容说明,@现场是否有人,@处理方式,@装修进度 " +
" select @@identity ";
sr = SQLHelper.Insert("wyt", sqlString,
new SqlParameter("@分类", DataTypeHelper.GetDBValue(classify)),
new SqlParameter("@装修表ID", DataTypeHelper.GetDBValue(id)),
new SqlParameter("@房产编号", DataTypeHelper.GetDBValue(roomNumber)),
new SqlParameter("@巡检日期", DataTypeHelper.GetDBValue(checkDate)),
new SqlParameter("@巡检人", DataTypeHelper.GetDBValue(checkMan)),
new SqlParameter("@是否正常", DataTypeHelper.GetDBValue(isNormal)),
new SqlParameter("@不合格项编号", DataTypeHelper.GetDBValue(unnormalItemNumber)),
new SqlParameter("@其他不合格内容说明", DataTypeHelper.GetDBValue(otherUnnormalItemExplain)),
new SqlParameter("@现场是否有人", DataTypeHelper.GetDBValue(havePeople)),
new SqlParameter("@处理方式", DataTypeHelper.GetDBValue(dealWay)),
new SqlParameter("@装修进度", DataTypeHelper.GetDBValue(schedule)));
return(sr);
}
public static StatusReport BussinessHandler_End(string instanceId, string userId, string leaveMessage, string isEnd,
string docTableName, string docTableId, string tableUpdateData, string updateDataKeys, string registId,
string transformConditionAndExplain)
{
string updateString = GetUpdateString(tableUpdateData, updateDataKeys);
//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 spIsEnd = new SqlParameter("@是否结束", SqlDbType.Bit);
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);
spInstanceId.Value = Convert.ToInt32(instanceId);
spUserId.Value = Convert.ToInt32(userId);
spLeaveMessage.Value = DataTypeHelper.GetDBValue(leaveMessage);
spIsEnd.Value = Convert.ToInt32(isEnd);
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);
StatusReport sr = new StatusReport();
try
{
DataSet ds = SQLHelper.ExecuteProcedure("wyt", sqlString, spInstanceId, spUserId, spLeaveMessage, spIsEnd, spDocTableName,
spDocTableId, spTableUpdateData, spRegistId, spTransformConditionAndExplain);
sr.status = "Success";
sr.result = "成功";
return(sr);
}
catch (Exception e)
{
sr.status = "Fail";
sr.result = "传递到下一步失败：" + e.Message;
return(sr);
}
}
public static StatusReport SetDecorationResult(string id, string accessController, string accessControllerSignDate,
string checkEngineer, string checkEngineerSignDate, string checkMan1, string checkResult1, string checkResultExplain1,
string checkTime1, string checkMan2, string checkResult2, string checkResultExplain2,
string checkTime2, string engineeringCheckAccessMan, string engineeringCheckAccessManSignDate,
string engineeringCheckMan, string engineeringCheckManSignDate, string engineeringManager,
string engineeringManagerSignDate, string engineeringPatrolMan, string engineeringPatrolManSignDate)
{
StatusReport sr = new StatusReport();
string sqlString =
" update dbo.基础资料_装修管理 set " +
" 第一次验收时间 = @第一次验收时间, 第一次验收人 = @第一次验收人, 第一次验收结果 = @第一次验收结果, 第一次验收结果说明 = @第一次验收结果说明, " +
" 第二次验收时间 = @第二次验收时间, 第二次验收人 = @第二次验收人, 第二次验收结果 = @第二次验收结果, 第二次验收结果说明 = @第二次验收结果说明, " +
" 工程指导人员签字 = @工程指导人员签字, 工程指导人员签字日期 = @工程指导人员签字日期, 门岗进场控制签字 = @门岗进场控制签字, 门岗进场控制签字日期 = @门岗进场控制签字日期, " +
" 工程确认进场签字 = @工程确认进场签字, 工程确认进场签字日期 = @工程确认进场签字日期, 工程封装巡查签字 = @工程封装巡查签字, 工程封装巡查签字日期 = @工程封装巡查签字日期, " +
" 封装完毕验收签字 = @封装完毕验收签字, 封装完毕验收签字日期 = @封装完毕验收签字日期, 工程主管审核 = @工程主管审核, 工程主管审核日期 = @工程主管审核日期 " +
" where ID = @id " +
" select @@identity ";
sr = SQLHelper.Update("wyt", sqlString,
new SqlParameter("@第一次验收时间", DataTypeHelper.GetDBValue(checkTime1)),
new SqlParameter("@第一次验收人", DataTypeHelper.GetDBValue(checkMan1)),
new SqlParameter("@第一次验收结果", DataTypeHelper.GetDBValue(checkResult1)),
new SqlParameter("@第一次验收结果说明", DataTypeHelper.GetDBValue(checkResultExplain1)),
new SqlParameter("@第二次验收时间", DataTypeHelper.GetDBValue(checkTime2)),
new SqlParameter("@第二次验收人", DataTypeHelper.GetDBValue(checkMan2)),
new SqlParameter("@第二次验收结果", DataTypeHelper.GetDBValue(checkResult2)),
new SqlParameter("@第二次验收结果说明", DataTypeHelper.GetDBValue(checkResultExplain2)),
new SqlParameter("@工程指导人员签字", DataTypeHelper.GetDBValue(checkEngineer)),
new SqlParameter("@工程指导人员签字日期", DataTypeHelper.GetDBValue(checkEngineerSignDate)),
new SqlParameter("@门岗进场控制签字", DataTypeHelper.GetDBValue(accessController)),
new SqlParameter("@门岗进场控制签字日期", DataTypeHelper.GetDBValue(accessControllerSignDate)),
new SqlParameter("@工程确认进场签字", DataTypeHelper.GetDBValue(engineeringCheckAccessMan)),
new SqlParameter("@工程确认进场签字日期", DataTypeHelper.GetDBValue(engineeringCheckAccessManSignDate)),
new SqlParameter("@工程封装巡查签字", DataTypeHelper.GetDBValue(engineeringPatrolMan)),
new SqlParameter("@工程封装巡查签字日期", DataTypeHelper.GetDBValue(engineeringPatrolManSignDate)),
new SqlParameter("@封装完毕验收签字", DataTypeHelper.GetDBValue(engineeringCheckMan)),
new SqlParameter("@封装完毕验收签字日期", DataTypeHelper.GetDBValue(engineeringCheckManSignDate)),
new SqlParameter("@工程主管审核", DataTypeHelper.GetDBValue(engineeringManager)),
new SqlParameter("@工程主管审核日期", DataTypeHelper.GetDBValue(engineeringManagerSignDate)),
new SqlParameter("@id", DataTypeHelper.GetDBValue(id)));
return(sr);
}
public static StatusReport SetLookOverResult(string isSpotCheck, string items)
{
StatusReport sr = new StatusReport();
string sqlString = " update 基础资料_巡检记录 set 巡检时间 = @巡检时间, " +
" 是否合格 = @是否合格, 不合格说明 = @不合格说明, 状态 = @状态 " +
" where ID = @ID ";
JArray itemArray = (JArray)JsonConvert.DeserializeObject(items);
for (int i = 0; i < itemArray.Count; i++)
{
JObject item = (JObject)itemArray[i];
sr = SQLHelper.Update("wyt", sqlString,
new SqlParameter("@巡检时间", DateTime.Now),
new SqlParameter("@状态", "已巡检"),
new SqlParameter("@是否合格", Convert.ToBoolean(item["isNormal"]) ? "是" : "否"),
new SqlParameter("@不合格说明", DataTypeHelper.GetDBValue(item["explain"].ToString())),
new SqlParameter("@ID", DataTypeHelper.GetDBValue(item["id"].ToString())));
}
return(sr);
}
public static StatusReport BussinessHandler_Save_Notify(string instanceId, string userId, string leaveMessage, string archiving,
string docTableName, string docTableId, string tableUpdateData, string updateKeys)
{
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 spArchiving = new SqlParameter("@是否归档", SqlDbType.Bit);
SqlParameter spDocTableName = new SqlParameter("@文档表名称", SqlDbType.NVarChar);
SqlParameter spDocTableId = new SqlParameter("@文档表ID", SqlDbType.Int);
SqlParameter spTableUpdateData = new SqlParameter("@表单更新数据", SqlDbType.NVarChar);
spInstanceId.Value = Convert.ToInt32(instanceId);
spUserId.Value = Convert.ToInt32(userId);
spLeaveMessage.Value = DataTypeHelper.GetDBValue(leaveMessage);
spArchiving.Value = Convert.ToByte(archiving);
spDocTableName.Value = DataTypeHelper.GetDBValue(docTableName);
spDocTableId.Value = Convert.ToInt32(docTableId);
spTableUpdateData.Value = DataTypeHelper.GetDBValue(updateString);
StatusReport sr = new StatusReport();
try
{
DataSet ds = SQLHelper.ExecuteProcedure("wyt", sqlString, spInstanceId, spUserId, spLeaveMessage, spArchiving, spDocTableName,
spDocTableId, spTableUpdateData);
sr.status = "Success";
sr.result = "成功";
return(sr);
}
catch (Exception e)
{
sr.status = "Fail";
sr.result = "知会操作失败：" + e.Message;
return(sr);
}
}
public static StatusReport AddFamily(int id, string phoneNumber, string relation, string userName, string roomId)
{
StatusReport sr = new StatusReport();
string sqlStr = "if not exists (select ID from 占用资料 where 占用者ID=@占用者ID and 资源表ID = @资源表ID) " +
" insert into 占用资料 (资源表名称,资源表ID,占用者ID,占用性质) " +
" select @资源表名称, @资源表ID ,@占用者ID, @占用性质 " +
" select @@IDENTITY ";
sr = SQLHelper.Insert("wyt", sqlStr,
new SqlParameter("@资源表名称", "资源资料_房产单元"),
new SqlParameter("@资源表ID", roomId),
new SqlParameter("@占用者ID", id),
new SqlParameter("@占用性质", "正常"));
if (sr.result == "数据已存在" || sr.status == "Success")
{
string sqlString = "insert into 占用资料_占用人员详情 (PID,姓名,与登记占用者关系,联系电话) " +
" select ID, @姓名,@与登记占用者关系,@联系电话 from 占用资料 where 占用者ID = @占用者ID " +
" select @@IDENTITY ";
sr = SQLHelper.Insert("wyt", sqlString,
new SqlParameter("@姓名", DataTypeHelper.GetDBValue(userName)),
new SqlParameter("@与登记占用者关系", DataTypeHelper.GetDBValue(relation)),
new SqlParameter("@联系电话", DataTypeHelper.GetDBValue(phoneNumber)),
new SqlParameter("@占用者ID", id));
}
return(sr);
//string[] roomIds = roomId.Split(',');
//for (int i = 0; i < roomIds.Length; i++)
//{
// string sqlStr = "if not exists (select ID from 占用资料 where 占用者ID=@占用者ID and 资源表ID = @资源表ID) " +
// " insert into 占用资料 (资源表名称,资源表ID,占用者ID,占用性质) " +
// " select @资源表名称, @资源表ID ,@占用者ID, @占用性质 " +
// " select @@IDENTITY ";
// sr = SQLHelper.Insert("wyt", sqlStr,
// new SqlParameter("@资源表名称", "资源资料_房产单元"),
// new SqlParameter("@资源表ID", roomIds[i]),
// new SqlParameter("@占用者ID", id),
// new SqlParameter("@占用性质", "正常"));
// if (sr.result == "数据已存在" || sr.status == "Success")
// {
// string sqlString = "insert into 占用资料_占用人员详情 (PID,姓名,与登记占用者关系,联系电话) " +
// " select ID, @姓名,@与登记占用者关系,@联系电话 from 占用资料 where 占用者ID = @占用者ID " +
// " select @@IDENTITY ";
// sr = SQLHelper.Insert("wyt", sqlString,
// new SqlParameter("@姓名", DataTypeHelper.GetDBValue(userName)),
// new SqlParameter("@与登记占用者关系", DataTypeHelper.GetDBValue(relation)),
// new SqlParameter("@联系电话", DataTypeHelper.GetDBValue(phoneNumber)),
// new SqlParameter("@占用者ID", id));
// if (sr.status == "Success")
// {
// continue;
// }
// else
// {
// break;
// }
// }
// else
// {
// break;
// }
//}
//return sr;
}
/// <summary>
/// 判断该结果是否可选
/// </summary>
//public static object[] CheckSelectCondition(string docTableName, int docTableId, string selectCondition)
//{
// bool isSelect = false;
// if (!string.IsNullOrEmpty(selectCondition))
// {
// string selectSqlString = "select ID from " + docTableName + " where ID = " + docTableId + "(" + selectCondition + ")";//根据选择条件查询
// int result = SQLHelper.ExecuteScalar("wyt", selectSqlString);
// if (result > 0)
// {
// isSelect = true;
// }
// }
//}
private static object[] BussinessHandler_NextLink_ReceiveStaffs_Private(string userId, string registId, string businessId, string linkId, string task, string staffId, string operatorLimit, string roleMemberId, string handlerInfo, string lastInstanceId, string department, string secondDepartment, string thirdDepartment, string registerId)
{
string sqlString = "[sp_extcall_业务任务处理_下一环节数据_接收人]";
SqlParameter spUserId = new SqlParameter("@用户ID", SqlDbType.Int);
SqlParameter spRegistId = new SqlParameter("@登记ID", SqlDbType.Int);
SqlParameter spBusinessId = new SqlParameter("@业务ID", SqlDbType.Int);
SqlParameter spLinkId = new SqlParameter("@环节ID", SqlDbType.Int);
SqlParameter spTask = new SqlParameter("@任务", SqlDbType.Int);
SqlParameter spStaffId = new SqlParameter("@人员ID", SqlDbType.Int);
SqlParameter spOperatorLimit = new SqlParameter("@操作人员限制", SqlDbType.NVarChar);
SqlParameter spRoleMemberId = new SqlParameter("@指定角色成员ID", SqlDbType.NVarChar);
SqlParameter spHandlerInfo = new SqlParameter("@经手人信息", SqlDbType.NVarChar);
SqlParameter spLastInstanceId = new SqlParameter("@上一实例ID", SqlDbType.Int);
SqlParameter spDepartment = new SqlParameter("@发起人部门", SqlDbType.NVarChar);
SqlParameter spSecondDepartment = new SqlParameter("@发起人二级部门", SqlDbType.NVarChar);
SqlParameter spThirdDepartment = new SqlParameter("@发起人三级部门", SqlDbType.NVarChar);
SqlParameter spRegisterId = new SqlParameter("@登记人ID", SqlDbType.Int);
//spUserId.Value = 514;
//spRegistId.Value = 875;
//spBusinessId.Value = 12;
//spLinkId.Value = 196;
//spTask.Value = 2;
//spStaffId.Value = 509;
//spOperatorLimit.Value = DBNull.Value;
//spRoleMemberId.Value = DBNull.Value;
//spHandlerInfo.Value = DBNull.Value;
//spLastInstanceId.Value = 3973;
//spDepartment.Value = "玖珑花园";
//spSecondDepartment.Value = "管理处主任";
//spThirdDepartment.Value = DBNull.Value;
//spRegisterId.Value = 293;
spUserId.Value = Convert.ToInt32(userId);
spRegistId.Value = Convert.ToInt32(registId);
spBusinessId.Value = Convert.ToInt32(businessId);
spLinkId.Value = Convert.ToInt32(linkId);
spTask.Value = Convert.ToInt32(task);
spStaffId.Value = Convert.ToInt32(staffId);
spOperatorLimit.Value = DataTypeHelper.GetDBValue(operatorLimit);
spRoleMemberId.Value = DataTypeHelper.GetDBValue(roleMemberId);
spHandlerInfo.Value = DataTypeHelper.GetDBValue(handlerInfo);
spLastInstanceId.Value = Convert.ToInt32(lastInstanceId);
spDepartment.Value = DataTypeHelper.GetDBValue(department);
spSecondDepartment.Value = DataTypeHelper.GetDBValue(secondDepartment);
spThirdDepartment.Value = DataTypeHelper.GetDBValue(thirdDepartment);
spRegisterId.Value = Convert.ToInt32(registerId);
DataSet ds = SQLHelper.ExecuteProcedure("wyt", sqlString, spUserId, spRegistId, spBusinessId, spLinkId, spTask, spStaffId, spOperatorLimit, spRoleMemberId, spHandlerInfo, spLastInstanceId, spDepartment, spSecondDepartment, spThirdDepartment, spRegisterId);
DataTable dtallowReceiveStaffs = ds.Tables[0];
//DataTable dtDefine = ds.Tables[1];
List <object> allowReceiveStaffList = new List <object>();
var firstItem = new
{
userId = 0,
user = "******",
userDepartment = "不选择",
userChecked = false
};
allowReceiveStaffList.Add(firstItem);
foreach (DataRow dr in dtallowReceiveStaffs.Rows)
{
var item = new
{
userId = DataTypeHelper.GetIntValue(dr["用户ID"]),
user = DataTypeHelper.GetStringValue(dr["用户"]),
userDepartment = DataTypeHelper.GetStringValue(dr["用户部门"]),
userChecked = false
};
allowReceiveStaffList.Add(item);
}
return(allowReceiveStaffList.ToArray());
//var data = new { allowReceiveStaffs = allowReceiveStaffList.ToArray() };
//StatusReport sr = new StatusReport();
//sr.status = "Success";
//sr.result = "Success";
//sr.data = data;
//return sr;
}
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)
//};
}
public static StatusReport BussinessHandler_NextLink(string registId, string transferObjectId, string receiveLinkId, string receiveLinkIds, string userId, string businessId, string linkId, string task, string staffId, string lastInstanceId, string department, string secondDepartment, string thirdDepartment, string registerId)
{
string sqlString = "[sp_extcall_业务任务处理_下一环节数据]";
SqlParameter spRegistId = new SqlParameter("@登记ID", SqlDbType.Int);
SqlParameter spTransferObjectId = new SqlParameter("@传递对象ID", SqlDbType.Int);
SqlParameter spReceiveLinkId = new SqlParameter("@接收环节ID", SqlDbType.Int);
SqlParameter spReceiveLinkIds = new SqlParameter("@接收环节IDs", SqlDbType.NVarChar);
//spRegistId.Value = 868;
//spTransferObjectId.Value = 28;
//spReceiveLinkId.Value = 196;
//spReceiveLinkIds.Value = DBNull.Value;
spRegistId.Value = registId;
spTransferObjectId.Value = transferObjectId;
spReceiveLinkId.Value = DataTypeHelper.GetDBValue(receiveLinkId);
spReceiveLinkIds.Value = DataTypeHelper.GetDBValue(receiveLinkIds);
DataSet ds = SQLHelper.ExecuteProcedure("wyt", sqlString, spRegistId, spTransferObjectId, spReceiveLinkId, spReceiveLinkIds);
DataTable dtallowReceiveLinks = ds.Tables[0];
List <object> allowReceiveLinkList = new List <object>();
List <object> outOfControlLinkList = new List <object>();
foreach (DataRow dr in dtallowReceiveLinks.Rows)
{
int?theTask = DataTypeHelper.GetIntValue(dr["任务"]);
if (theTask.HasValue && (theTask == 4 || theTask == 5))
{
var item = new
{
linkId = DataTypeHelper.GetIntValue(dr["环节ID"]),
task = theTask,
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["曾经经手"]),
userChecked = true
};
outOfControlLinkList.Add(item);
}
else
{
var item = new
{
linkId = DataTypeHelper.GetIntValue(dr["环节ID"]),
task = theTask,
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(), outOfControlLinks = outOfControlLinkList.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) };
StatusReport sr = new StatusReport();
sr.status = "Success";
sr.result = "Success";
sr.data = data;
return(sr);
}
public static StatusReport GetEquipmentTrouble(string classify, string isDone, string name)
{
StatusReport sr = new StatusReport();
string done = "";
if (isDone == "0")
{
done = " where (分类 = @分类) AND 状态 = @状态 and 维修人 = @维修人 ORDER BY ID DESC ";
}
else
{
done = " where (分类 = @分类) AND 状态 = @状态 and 维修人 = @维修人 ORDER BY ID DESC ";
}
string sqlstring = " SELECT * FROM dbo.基础资料_设备故障管理 ";
sqlstring += done;
DataTable dt = SQLHelper.ExecuteQuery("wyt", sqlstring,
new SqlParameter("@分类", DataTypeHelper.GetDBValue(classify)),
new SqlParameter("@状态", isDone == "0" ? "已派单" : "已完成"),
new SqlParameter("@维修人", DataTypeHelper.GetDBValue(name)));
if (dt.Rows.Count == 0)
{
return(sr.SetFail("未查询到任何数据"));
}
List <object> equipmentList = new List <object>();
foreach (DataRow dr in dt.Rows)
{
List <string> beforeList = new List <string>();
List <string> afterList = new List <string>();
for (int i = 1; i <= 3; i++)
{
string beforeImage = DataTypeHelper.GetStringValue(dr["维修前照片" + i.ToString()]);
string afterImage = DataTypeHelper.GetStringValue(dr["处理后照片" + i.ToString()]);
beforeImage = beforeImage.Split('|')[beforeImage.Split('|').Length - 1];
afterImage = afterImage.Split('|')[afterImage.Split('|').Length - 1];
beforeList.Add(beforeImage);
afterList.Add(afterImage);
}
var equipment = new
{
id = DataTypeHelper.GetIntValue(dr["ID"]),
classify = DataTypeHelper.GetStringValue(dr["分类"]),
project = DataTypeHelper.GetStringValue(dr["管理处"]),
registrant = DataTypeHelper.GetStringValue(dr["登记人"]),
registerTime = DataTypeHelper.GetDateStringValue(dr["登记时间"]),
name = DataTypeHelper.GetStringValue(dr["设备名称"]),
number = DataTypeHelper.GetStringValue(dr["设备编号"]),
useAddress = DataTypeHelper.GetStringValue(dr["安装地点"]),
brokenTime = DataTypeHelper.GetDateStringValue(dr["发生时间"]),
brokenInfo = DataTypeHelper.GetStringValue(dr["故障描述"]),
status = DataTypeHelper.GetStringValue(dr["状态"]),
repairMan = DataTypeHelper.GetStringValue(dr["维修人"]),
repairTimeLimit = DataTypeHelper.GetStringValue(dr["维修时限"]),
receiveTime = DataTypeHelper.GetDateStringValue(dr["派工时间"]),
repairInfo = DataTypeHelper.GetStringValue(dr["维修说明"]),
finishTime = DataTypeHelper.GetDateStringValue(dr["完成时间"]),
fee = DataTypeHelper.GetDecimalValue(dr["费用"]),
beforeImage = beforeList.ToArray(),
afterImage = afterList.ToArray(),
};
equipmentList.Add(equipment);
}
sr.status = "Success";
sr.result = "成功";
sr.data = equipmentList.ToArray();
sr.parameters = sqlstring;
return(sr);
}
