/// <summary>
/// 更新处理意见
/// </summary>
/// <param name="upFlowOperate"></param>
public static void UpdateFlowOperateOpinion(Model.ProjectData_FlowOperate flowOperate)
{
Model.SUBHSSEDB db = Funs.DB;
var upFlowOperate = from x in db.ProjectData_FlowOperate
where x.MenuId == flowOperate.MenuId && x.DataId == flowOperate.DataId && (x.IsClosed == false || !x.IsClosed.HasValue)
select x;
if (upFlowOperate.Count() > 0)
{
foreach (var item in upFlowOperate)
{
item.OperaterId = flowOperate.OperaterId;
item.OperaterTime = flowOperate.OperaterTime;
item.State = flowOperate.State;
item.Opinion = flowOperate.Opinion;
item.IsClosed = flowOperate.IsClosed;
Funs.DB.SubmitChanges();
}
}
else
{
Model.ProjectData_FlowOperate newFlowOperate = new Model.ProjectData_FlowOperate
{
MenuId = flowOperate.MenuId,
DataId = flowOperate.DataId,
OperaterId = flowOperate.OperaterId,
OperaterTime = flowOperate.OperaterTime,
State = flowOperate.State,
Opinion = flowOperate.Opinion,
IsClosed = flowOperate.IsClosed
};
AddProjectData_FlowOperate(newFlowOperate);
}
}
/// <summary>
/// 删除项目单据流程
/// </summary>
/// <param name="flowSetId"></param>
public static void DeleteFlowSetByFlowSetId(string flowSetId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.ProjectData_FlowOperate flowSet = db.ProjectData_FlowOperate.FirstOrDefault(e => e.FlowOperateId == flowSetId);
if (flowSet != null)
{
db.ProjectData_FlowOperate.DeleteOnSubmit(flowSet);
db.SubmitChanges();
}
}
/// <summary>
/// 根据菜单id和步骤序号得到下一个流程
/// </summary>
/// <param name="menuId"></param>
/// <param name="sortIndex"></param>
/// <returns></returns>
public static Model.ProjectData_FlowOperate GetNextProjectData_FlowOperate(string dataId)
{
Model.ProjectData_FlowOperate flowSet = new Model.ProjectData_FlowOperate();
var flowSets = from x in Funs.DB.ProjectData_FlowOperate
where x.DataId == dataId && (!x.IsClosed.HasValue || x.IsClosed == false)
orderby x.SortIndex
select x;
if (flowSets.Count() > 0)
{
int?index = flowSets.Select(x => x.SortIndex).Min();
if (index.HasValue)
{
flowSet = flowSets.FirstOrDefault(x => x.SortIndex == index);
}
}
return(flowSet);
}
/// <summary>
/// 增加项目单据流程
/// </summary>
/// <param name="FlowSetName"></param>
/// <param name="def"></param>
public static void AddProjectData_FlowOperate(Model.ProjectData_FlowOperate flowSet)
{
Model.SUBHSSEDB db = Funs.DB;
Model.ProjectData_FlowOperate newFlowOperate = new ProjectData_FlowOperate
{
FlowOperateId = SQLHelper.GetNewID(typeof(Model.ProjectData_FlowOperate)),
MenuId = flowSet.MenuId,
DataId = flowSet.DataId
};
int newSortIndex = getFlowSetMaxSortIndexByMenuId(flowSet.MenuId, flowSet.DataId);
newFlowOperate.SortIndex = newSortIndex;
newFlowOperate.OperaterId = flowSet.OperaterId;
newFlowOperate.OperaterTime = flowSet.OperaterTime;
newFlowOperate.State = flowSet.State;
newFlowOperate.Opinion = flowSet.Opinion;
newFlowOperate.IsClosed = flowSet.IsClosed;
db.ProjectData_FlowOperate.InsertOnSubmit(newFlowOperate);
db.SubmitChanges();
}