public PartialViewResult Problem(string id) { SummaryTargetStrategy t = new SummaryTargetStrategy(); t.Id = 1; t.ProjectName = "ProjectName problem id=" + id.ToString(); t.Status = "Status"; t.Strategy = "Strategy 1"; t.Target = "Target"; return(PartialView("_Problem_" + id, t)); }
/// <summary> /// 一、整体概况 /// </summary> public static List <SummaryTargetStrategy> GetSummaryTargetStrategy(string whereCondition, string limit, MySqlParameter[] parameters, out int totalCount, out int totalPage) { List <SummaryTargetStrategy> targetList = new List <SummaryTargetStrategy>(); MySqlConnection con = new MySqlConnection(ConnectionString); totalCount = 0; try { con.Open(); totalCount = int.Parse(MySqlHelper.ExecuteScalar(con, "select count(*) from Summary_TargetStrategy " + whereCondition, parameters).ToString()); MySqlDataReader reader = MySqlHelper.ExecuteReader(con, "select * from Summary_TargetStrategy " + whereCondition + limit, parameters); while (reader.Read()) { SummaryTargetStrategy t = new SummaryTargetStrategy(); t.Id = int.Parse(reader["Id"].ToString()); t.ProjectName = reader["ProjectName"].ToString(); t.Status = reader["Status"].ToString(); t.Strategy = reader["Strategy"].ToString(); t.Target = reader["Target"].ToString(); t.UserId = reader["UserId"].ToString(); t.Week = int.Parse(reader["Week"].ToString()); t.IsForeign = int.Parse(reader["IsForeign"].ToString()); t.OrderNum = int.Parse(reader["OrderNum"].ToString()); targetList.Add(t); } reader.Close(); } catch (MySqlException e) { Logger.Error("查询SummaryTargetStrategy出错。", e); } finally { con.Close(); } int pageSize = int.Parse(ConfigurationManager.AppSettings["pageSize"]); totalPage = totalCount % pageSize == 0 ? totalCount / pageSize : totalCount / pageSize + 1; return(targetList); }