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