private static object[] BussinessHandler_RoleAndUserData(int linkUserId)
{
string sqlString = "[sp_extcall_业务任务处理_角色用户数据]";
SqlParameter spLinkUserId = new SqlParameter("@业务ID", SqlDbType.Int);
//spBusinessId.Value = 12;
//spTransferObjectId.Value = 28;
//spDocTableName.Value = "业务文档_请款单流程表";
spLinkUserId.Value = linkUserId;
//spTransferObjectId.Value = transferObjectId;
//spDocTableName.Value = docTableName;
DataSet ds = SQLHelper.ExecuteProcedure("wyt", sqlString, spLinkUserId);
DataTable dtDefine = ds.Tables[0];
List <object> defineList = new List <object>();
foreach (DataRow dr in dtDefine.Rows)
{
var item = new
{
id = DataTypeHelper.GetIntValue(dr["ID"]),
taskExplain = DataTypeHelper.GetStringValue(dr["任务说明"]),
checkResult = DataTypeHelper.GetStringValue(dr["审核结果"]),
transferObjectId = DataTypeHelper.GetIntValue(dr["传递对象ID"]),
receiveLinkId = DataTypeHelper.GetIntValue(dr["接收环节ID"]),
receiveLinkIds = DataTypeHelper.GetStringValue(dr["接收环节IDs"]),
//hiddenCondition = DataTypeHelper.GetStringValue(dr["隐藏条件"]),
//selectCondition = DataTypeHelper.GetStringValue(dr["选择条件"]),
isReadOnly = DataTypeHelper.GetBooleanValue(dr["只读性选择"]),
//transConditionAndExplain = DataTypeHelper.GetStringValue(dr["传递条件及说明"])
};
defineList.Add(item);
}
//var data = new { checkDataDefines = defineList.ToArray() };
//StatusReport sr = new StatusReport();
//sr.status = "Success";
//sr.result = "Success";
//sr.data = data;
//return sr;
return(defineList.ToArray());
}
public static StatusReport GetEquipmentReport(string ztcode)
{
StatusReport sr = new StatusReport();
string done = " where (帐套代码 = @帐套代码) AND 是否完成 is null " +
" and (datediff(day,工作日期,GETDATE())> 宽限上延天数) and datediff(day,工作日期,GETDATE())>= 0 " +
" ORDER BY ID DESC";
string sqlstring = " SELECT ID, 分类, 设备运行编号, 设备编号, 设备型号, 设备名称, 系统名称, 出厂日期, " +
" 使用日期, 设备价格, 出厂序号, 设计寿命, 卡号, 安装地点, 产地, 设备保养管理代号, 设备保养管理内容, " +
" 设备保养管理日期, 工作名称, 工作日期, 是否完成, 录入日期, 录入人, 完成说明, 序次, 保养前照片, 保养中照片, 保养后照片, " +
" 宽限上延天数,宽限下延天数 " +
" FROM dbo.小程序_设备管理 ";
sqlstring += done;
DataTable dt = SQLHelper.ExecuteQuery("wyt", sqlstring,
new SqlParameter("@帐套代码", ztcode));
if (dt.Rows.Count == 0)
{
sr.status = "Fail";
sr.result = "未查询到任何数据";
sr.parameters = sqlstring;
return(sr);
}
List <Equipment> equipmentList = new List <Equipment>();
foreach (DataRow dr in dt.Rows)
{
Equipment equipment = new Equipment();
equipment.ID = DataTypeHelper.GetIntValue(dr["ID"]);
equipment.Classify = DataTypeHelper.GetStringValue(dr["分类"]);
equipment.OperationNumber = DataTypeHelper.GetStringValue(dr["设备运行编号"]);
equipment.Number = DataTypeHelper.GetStringValue(dr["设备编号"]);
equipment.Name = DataTypeHelper.GetStringValue(dr["设备名称"]);
equipment.SystemName = DataTypeHelper.GetStringValue(dr["系统名称"]);
equipment.ProductionDate = DataTypeHelper.GetStringValue(dr["出厂日期"]);
equipment.UseDate = DataTypeHelper.GetStringValue(dr["使用日期"]);
equipment.price = DataTypeHelper.GetDoubleValue(dr["设备价格"]);
equipment.ProductionNumber = DataTypeHelper.GetStringValue(dr["出厂序号"]);
equipment.DesignedLife = DataTypeHelper.GetStringValue(dr["设计寿命"]);
equipment.CardNumber = DataTypeHelper.GetStringValue(dr["卡号"]);
equipment.UseAddress = DataTypeHelper.GetStringValue(dr["安装地点"]);
equipment.ProductionAddress = DataTypeHelper.GetStringValue(dr["产地"]);
equipment.MaintainNumber = DataTypeHelper.GetStringValue(dr["设备保养管理代号"]);
equipment.MaintainContent = DataTypeHelper.GetStringValue(dr["设备保养管理内容"]);
equipment.MaintainDate = DataTypeHelper.GetDateStringValue(dr["设备保养管理日期"]);
equipment.WorkDate = DataTypeHelper.GetDateStringValue(dr["工作日期"]);
equipment.IsDone = DataTypeHelper.GetBooleanValue(dr["是否完成"]) == true ? 1 : 0;
equipment.InputDate = DataTypeHelper.GetDateStringValue(dr["录入日期"]);
equipment.InputMan = DataTypeHelper.GetStringValue(dr["录入人"]);
equipment.DoneInfo = DataTypeHelper.GetStringValue(dr["完成说明"]);
equipment.BeforeImage = DataTypeHelper.GetStringValue(dr["保养前照片"]);
equipment.MiddleImage = DataTypeHelper.GetStringValue(dr["保养中照片"]);
equipment.AfterImage = DataTypeHelper.GetStringValue(dr["保养后照片"]);
equipment.Order = DataTypeHelper.GetBooleanValue(dr["序次"]) == true ? "1" : "0";
equipment.BeforeDays = DataTypeHelper.GetIntValue(dr["宽限上延天数"]);
equipment.AfterDays = DataTypeHelper.GetIntValue(dr["宽限下延天数"]);
equipmentList.Add(equipment);
}
sr.status = "Success";
sr.result = "成功";
sr.data = equipmentList.ToArray();
sr.parameters = sqlstring;
return(sr);
}
public static StatusReport BusinessTask(string userId)
{
if (string.IsNullOrEmpty(userId))
{
return(new StatusReport().SetFail("userId不能为空"));
}
string sqlString = "[sp_extcall_业务任务]";
SqlParameter sp = new SqlParameter("@用户ID", SqlDbType.Int);
//sp.Value = 514;
sp.Value = Convert.ToInt32(userId);
DataSet ds = SQLHelper.ExecuteProcedure("wyt", sqlString, sp);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
return(new StatusReport().SetFail("未发现需要处理的流程业务"));
}
List <object> list = new List <object>();
foreach (DataRow dr in dt.Rows)
{
if (DataTypeHelper.GetIntValue(dr["文档表ID"]) == 0)//在返回的行集中，请删除 文档表ID=0 的记录，这类任务表示正在发起，但还没创建表单记录
{
continue;
}
var item = new
{
id = DataTypeHelper.GetIntValue(dr["ID"]),
registId = DataTypeHelper.GetIntValue(dr["登记ID"]),
businessId = DataTypeHelper.GetIntValue(dr["业务ID"]),
linkId = DataTypeHelper.GetIntValue(dr["环节ID"]),
tableNubmer = DataTypeHelper.GetStringValue(dr["表单编号"]),
taskRole = DataTypeHelper.GetStringValue(dr["任务角色"]),
taskExplain = DataTypeHelper.GetStringValue(dr["任务说明"]),
//remark = DataTypeHelper.GetStringValue(dr["备注"]),
summary = DataTypeHelper.GetStringValue(dr["摘要"]),
sender = DataTypeHelper.GetStringValue(dr["送件人"]),
lastInstanceDepartment = DataTypeHelper.GetStringValue(dr["上一实例人员部门"]),
reachTime = DataTypeHelper.GetDateStringValue(dr["送达时间"]),
initiator = DataTypeHelper.GetStringValue(dr["发起人"]),
initiateDepartment = DataTypeHelper.GetStringValue(dr["发起人部门"]),
initiateSecondDepartment = DataTypeHelper.GetStringValue(dr["发起人二级部门"]),
initiateThirdDepartment = DataTypeHelper.GetStringValue(dr["发起人三级部门"]),
initiateTime = DataTypeHelper.GetDateStringValue(dr["发起时间"]),
businessName = DataTypeHelper.GetStringValue(dr["业务名称"]),
docTableName = DataTypeHelper.GetStringValue(dr["文档表名称"]),
docTableId = DataTypeHelper.GetIntValue(dr["文档表ID"]),
task = DataTypeHelper.GetIntValue(dr["任务"]),
remainTime = DataTypeHelper.GetDecimalValue(dr["停留时间"]),
senderLeaveMessage = DataTypeHelper.GetStringValue(dr["送件人留言"]),
leaveMessage = DataTypeHelper.GetStringValue(dr["留言"]),
isRead = DataTypeHelper.GetBooleanValue(dr["阅读"]),
lastInstanceId = DataTypeHelper.GetIntValue(dr["上一实例ID"]),
usedTime = DataTypeHelper.GetDecimalValue(dr["已历时间"]),
objectType = DataTypeHelper.GetStringValue(dr["对象类型"]),
transferObjectId = DataTypeHelper.GetIntValue(dr["传递对象ID"]),
transferObjectType = DataTypeHelper.GetStringValue(dr["传递对象类型"]),
receiveLinkId = DataTypeHelper.GetIntValue(dr["接收环节ID"]),
receiveLinkIds = DataTypeHelper.GetStringValue(dr["接收环节IDs"]),
allowRemainTime = DataTypeHelper.GetDecimalValue(dr["允许停留时间"]),
isImportant = DataTypeHelper.GetBooleanValue(dr["重要"]),
workTip = DataTypeHelper.GetStringValue(dr["工作指引"]),
fieldSpreadOut = DataTypeHelper.GetBooleanValue(dr["表单字段分组展开"]),
transmitConditionAndExplain = DataTypeHelper.GetStringValue(dr["传递条件及说明"]),
staffId = DataTypeHelper.GetIntValue(dr["人员ID"]),
registerId = DataTypeHelper.GetIntValue(dr["登记人ID"]),
linkStaffId = DataTypeHelper.GetIntValue(dr["环节人员ID"]),
tableChangeMarkup = DataTypeHelper.GetStringValue(dr["表单变化标识"]),
objectExplain = DataTypeHelper.GetStringValue(dr["对象描述"])
};
list.Add(item);
}
StatusReport sr = new StatusReport();
sr.status = "Success";
sr.result = "Success";
sr.data = list.ToArray();
return(sr);
}
private static object[] BussinessHandler_CheckData(int businessId, int transferObjectId, string docTableName, int docTableId)
{
string sqlString = "[sp_extcall_业务任务处理_审核数据]";
SqlParameter spBusinessId = new SqlParameter("@业务ID", SqlDbType.Int);
SqlParameter spTransferObjectId = new SqlParameter("@传递对象ID", SqlDbType.Int);
SqlParameter spDocTableName = new SqlParameter("@文档表名称", SqlDbType.NVarChar);
//spBusinessId.Value = 12;
//spTransferObjectId.Value = 28;
//spDocTableName.Value = "业务文档_请款单流程表";
spBusinessId.Value = businessId;
spTransferObjectId.Value = transferObjectId;
spDocTableName.Value = docTableName;
DataSet ds = SQLHelper.ExecuteProcedure("wyt", sqlString, spBusinessId, spTransferObjectId, spDocTableName);
DataTable dtDefine = ds.Tables[0];
List <object> defineList = new List <object>();
foreach (DataRow dr in dtDefine.Rows)
{
string hiddenConditon = DataTypeHelper.GetStringValue(dr["隐藏条件"]);
if (!string.IsNullOrEmpty(hiddenConditon))
{
string hiddenSqlString = "select ID from " + docTableName + " where ID = " + docTableId + " and (" + hiddenConditon + ")";//根据隐藏条件查询
int result = SQLHelper.ExecuteScalar("wyt", hiddenSqlString);
if (result > 0)
{
continue;
}
}
string selectCondition = DataTypeHelper.GetStringValue(dr["选择条件"]);
bool isSelect = false;
if (!string.IsNullOrEmpty(selectCondition))
{
string selectSqlString = "select ID from " + docTableName + " where ID = " + docTableId + " and (" + selectCondition + ")";//根据选择条件查询
int result = SQLHelper.ExecuteScalar("wyt", selectSqlString);
if (result > 0)
{
isSelect = true;
}
}
var item = new
{
id = DataTypeHelper.GetIntValue(dr["ID"]),
taskExplain = DataTypeHelper.GetStringValue(dr["任务说明"]),
checkResult = DataTypeHelper.GetStringValue(dr["审核结果"]),
transferObjectId = DataTypeHelper.GetIntValue(dr["传递对象ID"]),
receiveLinkId = DataTypeHelper.GetIntValue(dr["接收环节ID"]),
receiveLinkIds = DataTypeHelper.GetStringValue(dr["接收环节IDs"]),
hiddenCondition = DataTypeHelper.GetStringValue(dr["隐藏条件"]),
selectCondition = DataTypeHelper.GetStringValue(dr["选择条件"]),
isReadOnly = DataTypeHelper.GetBooleanValue(dr["只读性选择"]),
transConditionAndExplain = DataTypeHelper.GetStringValue(dr["传递条件及说明"]),
isSelect = isSelect
};
defineList.Add(item);
}
//var data = new { checkDataDefines = defineList.ToArray() };
//StatusReport sr = new StatusReport();
//sr.status = "Success";
//sr.result = "Success";
//sr.data = data;
//return sr;
return(defineList.ToArray());
}
public static StatusReport BussinessHandler_TableData(string userId, string linkId, string docTableName, string docTableId, string businessId, string transferObjectId, string objectType, string transferObjectType)
{
string sqlString = "[sp_extcall_业务任务处理_表单数据]";
SqlParameter spUserId = new SqlParameter("@用户ID", SqlDbType.Int);
SqlParameter spLinkId = new SqlParameter("@环节ID", SqlDbType.Int);
SqlParameter spDocTableName = new SqlParameter("@文档表名称", SqlDbType.NVarChar);
SqlParameter spDocTableId = new SqlParameter("@文档表ID", SqlDbType.Int);
//spUserId.Value = 514;
//spLinkId.Value = 132;
//spDocTableName.Value = "业务文档_请款单流程表";
//spDocTableId.Value = 619;
spUserId.Value = Convert.ToInt32(userId);
spLinkId.Value = Convert.ToInt32(linkId);
spDocTableName.Value = docTableName;
spDocTableId.Value = Convert.ToInt32(docTableId);
DataSet ds = SQLHelper.ExecuteProcedure("wyt", sqlString, spUserId, spLinkId, spDocTableName, spDocTableId);
DataTable dtItem = ds.Tables[0];
DataTable dtDefine = ds.Tables[1];
List <object> itemList = new List <object>();
foreach (DataRow dr in dtItem.Rows)
{
List <object> columnList = new List <object>();
foreach (DataColumn dc in dtItem.Columns)
{
string columnName = Convert.ToString(dc.ColumnName);
object content = null;
if (columnName.Substring(columnName.Length - 2) == "时间" || columnName.Substring(columnName.Length - 2) == "日期")
{
content = DataTypeHelper.GetDateStringValue(dr[columnName]);
}
//else if (columnName.Contains("附件"))
//{
// string columnValue = DataTypeHelper.GetStringValue(dr[columnName]);//获取对应列的值
// if (columnValue.Contains("-") && columnValue.Contains("|"))//如果值中存在-和|，执行以下操作
// {
// string docValue = columnValue.Split('-')[columnValue.Split('-').Length - 1];//获取最后一个 “-” 后的所有字符
// string[] splitArr = docValue.Split('|');
// string fileName = splitArr[splitArr.Length - 1];
// string recordId = splitArr[splitArr.Length - 2];
// content = docTableName + "\\" + recordId + "\\" + fileName;
// }
// else
// {
// content = "";
// }
//}
else
{
content = dr[columnName];
}
var item = new { title = columnName, content = content };
columnList.Add(item);
}
itemList.Add(columnList.ToArray());
}
List <object> defineList = new List <object>();
foreach (DataRow dr in dtDefine.Rows)
{
//List<object> columnList = new List<object>();
//foreach(DataColumn dc in dtDefine.Columns)
//{
// string columnName = Convert.ToString(dc.ColumnName);
// var item = new { title = columnName, content = dr[columnName] };
// columnList.Add(item);
//}
//defineList.Add(columnList.ToArray());
var item = new
{
fieldName = DataTypeHelper.GetStringValue(dr["字段名称"]),
fieldSourceName = DataTypeHelper.GetStringValue(dr["字段源名称"]),
required = DataTypeHelper.GetBooleanValue(dr["必填列"]),
defaultValue = DataTypeHelper.GetStringValue(dr["默认写入值"]),
allowEdit = DataTypeHelper.GetBooleanValue(dr["允许编辑"]),
isFile = DataTypeHelper.GetBooleanValue(dr["是否文件字段"])
};
defineList.Add(item);
}
StatusReport sr = new StatusReport();
sr.status = "Success";
sr.result = "Success";
if (transferObjectType == "Decision")
{
sr.data = new { items = itemList.ToArray(), defines = defineList.ToArray(), checkDataDefines = BussinessHandler_CheckData(Convert.ToInt32(businessId), Convert.ToInt32(transferObjectId), docTableName, Convert.ToInt32(docTableId)) };
}
if (objectType == "Terminator")
{
sr.data = new { items = itemList.ToArray(), defines = defineList.ToArray() };
}
//var data = new { items = itemList.ToArray(), defines = defineList.ToArray(), checkDataDefines = BussinessHandler_CheckData(Convert.ToInt32(businessId),Convert.ToInt32(transferObjectId), docTableName) };
//StatusReport sr = new StatusReport();
//sr.status = "Success";
//sr.result = "Success";
//sr.data = data;
return(sr);
}
