| 提交 | 用户 | age | ||
| 8e1d1f | 1 | using DIXWeb.DAL; |
| A | 2 | using DIXWeb.Entity.Workflow; |
| 3 | using System; | |
| 4 | using System.Collections.Generic; | |
| 7b83a6 | 5 | using System.Data; |
| 8e1d1f | 6 | using System.Linq; |
| A | 7 | using System.Text; |
| 8 | using System.Threading.Tasks; | |
| 9 | ||
| 10 | namespace DIXWeb.Business.GlobalM | |
| 11 | { | |
| 12 | public class WorkflowNodeDetailBusiness | |
| 13 | { | |
| 14 | public List<WorkflowOrgType> GetWorkflowOrgType() | |
| 15 | { | |
| 16 | List<WorkflowOrgType> list = null; | |
| 17 | using (DBContext db =new DBContext()) | |
| 18 | { | |
| 19 | list = db.WorkflowOrgType.ToList(); | |
| 20 | } | |
| 21 | return list; | |
| 22 | } | |
| 23 | ||
| 24 | public List<WorkflowRoleType> GetWorkflowRoleType() | |
| 25 | { | |
| 26 | List<WorkflowRoleType> list = null; | |
| 27 | using (DBContext db = new DBContext()) | |
| 28 | { | |
| 29 | list = db.WorkflowRoleType.ToList(); | |
| 30 | } | |
| 31 | return list; | |
| 32 | } | |
| 15b421 | 33 | |
| 7b83a6 | 34 | public Receive GetWorkflowNDetail(int NodeId, int pageIndex, int pageSize) |
| 15b421 | 35 | { |
| 7b83a6 | 36 | Receive receive = new Receive(); |
| A | 37 | try |
| 15b421 | 38 | { |
| 7b83a6 | 39 | using (DBContext db = new DBContext()) |
| A | 40 | { |
| 41 | System.Data.SqlClient.SqlParameter[] paramList = new System.Data.SqlClient.SqlParameter[] { | |
| 42 | new System.Data.SqlClient.SqlParameter("@NodeId", NodeId), | |
| 43 | new System.Data.SqlClient.SqlParameter("@pageIndex", pageIndex), | |
| 44 | new System.Data.SqlClient.SqlParameter("@pageSize", pageSize), | |
| 45 | new System.Data.SqlClient.SqlParameter("@Total", 0), | |
| 46 | }; | |
| 47 | int index = paramList.Length - 1; | |
| 48 | paramList[index].Direction = ParameterDirection.Output; | |
| 49 | receive.rows = db.Database.SqlQuery<ReceiveNodeDetail>("exec meta.p_getWorkflowNDetailByNodeId @NodeId,@pageIndex,@pageSize,@Total output ", paramList).ToList(); | |
| 50 | receive.total = int.Parse(paramList[index].Value.ToString()); | |
| 51 | receive.Code = 200; | |
| 52 | receive.Message = "SUCCESS"; | |
| 53 | } | |
| 15b421 | 54 | } |
| 7b83a6 | 55 | catch (Exception ex) |
| A | 56 | { |
| 57 | receive.Code = 500; | |
| 58 | receive.Message = ex.Message; | |
| 59 | } | |
| 60 | return receive; | |
| 15b421 | 61 | } |
| A | 62 | |
| 63 | public void Insert(WorkflowNodeDetail record) | |
| 64 | { | |
| 65 | using (DBContext db = new DBContext()) | |
| 66 | { | |
| 67 | db.WorkflowNodeDetail.Add(record); | |
| 68 | db.SaveChanges(); | |
| 69 | } | |
| 70 | } | |
| 71 | ||
| 72 | public void Update(WorkflowNodeDetail record) | |
| 73 | { | |
| 74 | using (DBContext db = new DBContext()) | |
| 75 | { | |
| 76 | WorkflowNodeDetail tempRecord = db.WorkflowNodeDetail.Find(record.Id); | |
| 77 | //tempRecord.WorkflowId = record.WorkflowId; | |
| 78 | //tempRecord.NodeId = record.NodeId; | |
| 79 | tempRecord.OrgTypeId = record.OrgTypeId; | |
| 80 | tempRecord.OrgId = record.OrgId; | |
| 81 | tempRecord.RoleTypeId = record.RoleTypeId; | |
| 82 | tempRecord.RoleId = record.RoleId; | |
| 83 | tempRecord.DetailLevel = record.DetailLevel; | |
| 1bf8ef | 84 | tempRecord.ActiveType = record.ActiveType; |
| 15b421 | 85 | tempRecord.ChTime = record.ChTime; |
| A | 86 | tempRecord.ChUserId = record.ChUserId; |
| 87 | db.SaveChanges(); | |
| 88 | } | |
| 89 | } | |
| 90 | ||
| 91 | public ReceiveNodeDetail SelectById(int Id) | |
| 92 | { | |
| 93 | ReceiveNodeDetail record = null; | |
| 94 | using (DBContext db = new DBContext()) | |
| 95 | { | |
| 96 | System.Data.SqlClient.SqlParameter[] paramList = new System.Data.SqlClient.SqlParameter[] { | |
| 97 | new System.Data.SqlClient.SqlParameter("@Id", Id), | |
| 98 | }; | |
| 99 | record = db.Database.SqlQuery<ReceiveNodeDetail>("EXEC meta.p_getWorkflowNDetailById @Id ", paramList).FirstOrDefault(); | |
| 100 | } | |
| 101 | return record; | |
| 102 | } | |
| 8e1d1f | 103 | } |
| A | 104 | } |
