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