/// <summary> /// 数据总体报送得分 /// </summary> /// <param name="_"></param> /// <returns></returns> public string DataUpAllInfo(dynamic _) { var recdata = this.GetResquetData <DataUpInModel>(); try { #region "接口调用验证" //bool flag = DataValidation(recdata.DateTime, recdata.Random, recdata.Sign); //if (!flag) //{ // return this.WriteValidationLog("LoginModule", recdata.DeviceId); //} #endregion DataUpBusiness messageBll = new DataUpBusiness(); DataUpAllInfoModel list = messageBll.GetDataUpAllInfo(recdata.data); if (list != null) { return(this.SendData <DataUpAllInfoModel>(list, "获取数据总体报送得分情况成功", ResponseType.Success)); } else { return(this.SendData("数据总体报送得分情况为空!", ResponseType.Success)); } } catch (Exception ex) { return(this.WriteExceptionLog("LoginModule", recdata.DeviceId, recdata.DeviceId, "获取数据总体报送得分情况异常:" + Json.ToJson(recdata) + "[异常信息:" + ex.Message + "]", "获取数据总体报送得分情况异常:" + ex.Message)); } }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public DataUpAllInfoModel GetDataUpAllInfo(DataUpInModel info) { DataUpAllInfoModel temp = null; string strSql = string.Format(@" select id, total_number, dataup_score, quality_score, dataup_standard_score, data_complete_score, data_price_score, data_weight_score, meat_trace_score, veg_trace_score, check_month, check_year, check_date, insert_time,DATA_GROW_SCORE, update_time from bl_data_up_info t where CHECK_MONTH=:V_CHECK_MONTH "); DataTable dt = OracleHelper.Query(strSql, new OracleParameter(":V_CHECK_MONTH", info.CheckMonth)); if (dt != null) { if (dt.Rows.Count > 0) { temp = new DataUpAllInfoModel(); temp.DataCompleteScore = DBNull.Value == dt.Rows[0]["data_complete_score"] ? string.Empty : dt.Rows[0]["data_complete_score"].ToString(); temp.DataPriceScore = DBNull.Value == dt.Rows[0]["data_price_score"] ? string.Empty : dt.Rows[0]["data_price_score"].ToString(); temp.DataUpGrowScore = DBNull.Value == dt.Rows[0]["DATA_GROW_SCORE"] ? string.Empty : dt.Rows[0]["DATA_GROW_SCORE"].ToString(); temp.DataUpScore = DBNull.Value == dt.Rows[0]["dataup_score"] ? string.Empty : dt.Rows[0]["dataup_score"].ToString(); temp.DataUpStandardScore = DBNull.Value == dt.Rows[0]["dataup_standard_score"] ? string.Empty : dt.Rows[0]["dataup_standard_score"].ToString(); temp.DataWeightScore = DBNull.Value == dt.Rows[0]["data_weight_score"] ? string.Empty : dt.Rows[0]["data_weight_score"].ToString(); temp.MeatTraceScore = DBNull.Value == dt.Rows[0]["meat_trace_score"] ? string.Empty : dt.Rows[0]["meat_trace_score"].ToString(); temp.QualityScore = DBNull.Value == dt.Rows[0]["quality_score"] ? string.Empty : dt.Rows[0]["quality_score"].ToString(); temp.TotalNumber = DBNull.Value == dt.Rows[0]["total_number"] ? string.Empty : dt.Rows[0]["total_number"].ToString(); temp.VegTraceScore = DBNull.Value == dt.Rows[0]["veg_trace_score"] ? string.Empty : dt.Rows[0]["veg_trace_score"].ToString(); } } return(temp); }