/// <summary>
/// 删除工作
/// </summary>
/// <param name="model"></param>
public void Delete(Modules.OA_FlowRun model)
{
FineOffice.Entity.OA_FlowRun entity = new Entity.OA_FlowRun
{
ID = model.ID,
};
dal.Delete(entity);
}
/// <summary>
/// 修改
/// </summary>
public FineOffice.Modules.OA_FlowRun Update(FineOffice.Modules.OA_FlowRun model)
{
dal.Initialization();
FineOffice.Entity.OA_FlowRun entity = new Entity.OA_FlowRun
{
CreateTime = model.CreateTime,
Creator = model.Creator,
FlowID = model.FlowID,
ID = model.ID,
WorkNO = model.WorkNO,
State = model.State,
Remark = model.Remark,
WorkName = model.WorkName,
};
dal.Update(entity);
dal.Dispose();
return(null);
}
/// <summary>
/// 增加
/// </summary>
public FineOffice.Modules.OA_FlowRun Add(FineOffice.Modules.OA_FlowRun model)
{
dal.Initialization();
FineOffice.Entity.OA_FlowRun entity = new Entity.OA_FlowRun
{
CreateTime = model.CreateTime,
Creator = model.Creator,
FlowID = model.FlowID,
ID = model.ID,
WorkNO = model.WorkNO,
State = model.State,
Remark = model.Remark,
WorkName = model.WorkName
};
for (int i = 0; i < model.OA_FlowRunProcessList.Count; i++)
{
FineOffice.Modules.OA_FlowRunProcess f = model.OA_FlowRunProcessList[i];
FineOffice.Entity.OA_FlowRunProcess runProcess = new Entity.OA_FlowRunProcess
{
ID = f.ID,
ProcessID = f.ProcessID,
Remark = f.Remark,
AcceptID = f.AcceptID,
AcceptTime = f.AcceptTime,
HandleTime = f.HandleTime,
Pattern = f.Pattern,
IsEntrance = f.IsEntrance,
PreviousID = f.PreviousID,
SendID = f.SendID,
Version = f.Version,
TransmitAdvice = f.TransmitAdvice,
RunID = f.RunID,
State = f.State
};
entity.OA_FlowRunProcess.Add(runProcess);
}
dal.Add(entity);
dal.Dispose();
return(this.GetModel(f => f.ID == entity.ID));
}
public override void Delete(Entity.OA_FlowRun entity)
{
this.Initialization();
Entity.OA_FlowRun flowRun = this.Get(f => f.ID == entity.ID);
List <Entity.OA_FlowRunProcess> runList = flowRun.OA_FlowRunProcess.ToList();
List <CommandInfo> transation = new List <CommandInfo>();
foreach (Entity.OA_FlowRunProcess p in runList)
{
SqlParameter[] transmit = { new SqlParameter("@RunProcessID", SqlDbType.Int, 4) };
transmit[0].Value = p.ID;
CommandInfo transmitInfo = new CommandInfo("delete from OA_FlowRunTransmit where RunProcessID=@RunProcessID", transmit);
transation.Add(transmitInfo);
SqlParameter[] attachment = { new SqlParameter("@RunProcessID", SqlDbType.Int, 4) };
attachment[0].Value = p.ID;
CommandInfo attachmentInfo = new CommandInfo("delete from OA_Attachment where RunProcessID=@RunProcessID", attachment);
transation.Add(attachmentInfo);
SqlParameter[] flowRunData = { new SqlParameter("@RunProcessID", SqlDbType.Int, 4) };
flowRunData[0].Value = p.ID;
CommandInfo flowRunDataInfo = new CommandInfo("delete from OA_FlowRunData where RunProcessID=@RunProcessID", flowRunData);
transation.Add(flowRunDataInfo);
}
this.Dispose();
SqlParameter[] runProcess = { new SqlParameter("@RunID", SqlDbType.Int, 4) };
runProcess[0].Value = flowRun.ID;
CommandInfo runProcessInfo = new CommandInfo("delete from OA_FlowRunProcess where RunID=@RunID", runProcess);
transation.Add(runProcessInfo);
SqlParameter[] flowRunParmeter = { new SqlParameter("@ID", SqlDbType.Int, 4) };
flowRunParmeter[0].Value = entity.ID;
CommandInfo flowRunInfo = new CommandInfo("delete from OA_FlowRun where ID=@ID", flowRunParmeter);
transation.Add(flowRunInfo);
DbHelperSQL.ExecuteSqlTran(transation);
}
