public ActionResult Tasks(TasksModel objTasksModel) { TaskDeatil TskDetails = new TaskDeatil(); TskDetails.TaskName = objTasksModel.TaskName; TskDetails.Description = objTasksModel.Description; TskDetails.PlannedStartDate = objTasksModel.PlannedStartDate; TskDetails.PlannedEndDate = objTasksModel.PlannedEndDate; TskDetails.PlannedEfforts = objTasksModel.PlannedEfforts; TskDetails.ModuleId = objTasksModel.ModuleId; objTMS.TaskDeatils.Add(TskDetails); objTMS.SaveChanges(); return(RedirectToAction("Tasks")); }
//GetTaskList 获取某计划下的所有任务,并进行分类加工 LS 2015-4-22 public static List <Task> GetSpTaskList(DataConnection pclsCache, string PlanNo) { List <Task> TaskList = new List <Task>(); DataTable list = new DataTable(); list.Columns.Add(new DataColumn("Id", typeof(string))); list.Columns.Add(new DataColumn("Type", typeof(string))); list.Columns.Add(new DataColumn("Code", typeof(string))); list.Columns.Add(new DataColumn("CodeName", typeof(string))); list.Columns.Add(new DataColumn("Instruction", typeof(string))); CacheCommand cmd = null; CacheDataReader cdr = null; try { if (!pclsCache.Connect()) { return(null); } cmd = new CacheCommand(); cmd = Ps.Task.GetPsTask(pclsCache.CacheConnectionObject); cmd.Parameters.Add("piUserId", CacheDbType.NVarChar).Value = PlanNo; cdr = cmd.ExecuteReader(); while (cdr.Read()) { list.Rows.Add(cdr["Id"].ToString(), cdr["Type"].ToString(), cdr["Code"].ToString(), cdr["CodeName"].ToString(), cdr["Instruction"].ToString()); } //确保排序 if (list.Rows.Count > 0) { DataView dv = list.DefaultView; dv.Sort = "Type desc"; DataTable list_sort = dv.ToTable(); list_sort.Rows.Add("end", "end", "end", "end", "end"); //用于最后一天输出 if (list_sort.Rows.Count > 1) { string temp_type = list_sort.Rows[0]["Type"].ToString(); Task Task = new Task(); Task.TaskType = list_sort.Rows[0]["Type"].ToString(); TaskDeatil TaskDeatil = new TaskDeatil(); TaskDeatil.TaskName = list_sort.Rows[0]["CodeName"].ToString(); TaskDeatil.Instruction = list_sort.Rows[0]["Instruction"].ToString(); Task.TaskDeatilList.Add(TaskDeatil); if (list.Rows.Count > 2) { for (int i = 1; i <= list_sort.Rows.Count - 1; i++) { if (temp_type == list_sort.Rows[i]["Type"].ToString()) { TaskDeatil = new TaskDeatil(); TaskDeatil.TaskName = list_sort.Rows[i]["CodeName"].ToString(); TaskDeatil.Instruction = list_sort.Rows[i]["Instruction"].ToString(); Task.TaskDeatilList.Add(TaskDeatil); } else { TaskList.Add(Task); if (list_sort.Rows[i]["Type"].ToString() != "end") { Task = new Task(); Task.TaskType = list_sort.Rows[i]["Type"].ToString(); TaskDeatil = new TaskDeatil(); TaskDeatil.TaskName = list_sort.Rows[i]["CodeName"].ToString(); TaskDeatil.Instruction = list_sort.Rows[i]["Instruction"].ToString(); Task.TaskDeatilList.Add(TaskDeatil); temp_type = list_sort.Rows[i]["Type"].ToString(); } } } } } } return(TaskList); } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsTask.GetSpTaskList", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return(null); } finally { if ((cdr != null)) { cdr.Close(); cdr.Dispose(true); cdr = null; } if ((cmd != null)) { cmd.Parameters.Clear(); cmd.Dispose(); cmd = null; } pclsCache.DisConnect(); } }