/// <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); }