/// <summary>
/// 运行情况
/// </summary>
/// <returns></returns>
public List <GoalStateGoal> GetRunConditionList()
{
var model = DbProcedureHelper.ExecuteDt("p_getState", null);
var goalstate = JsonConvert.SerializeObject(model);
var list = JsonConvert.DeserializeObject <List <GoalStateGoal> >(goalstate);
return(list);
}
/// <summary>
/// 根据登录人的id获取积分列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable GetUserIntergal(int id)
{
MySqlParameter sqlParameters = new MySqlParameter("@User_Id", MySqlDbType.Int32);
sqlParameters.Value = id;
var model = DbProcedureHelper.ExecuteDt("P_IntegralList", sqlParameters);
return(model);
}
/// <summary>
/// 各公司红绿灯百分比排名
/// </summary>
/// <returns></returns>
public DataTable GetTrafficLightRankingList()
{
var model = DbProcedureHelper.ExecuteDt("P_RedGreen", null);
return(model);
}
