/// <summary> /// 考核报告内容 /// </summary> /// <param name="info"></param> /// <returns></returns> public CommerceReportModel GetReport(CommerceInModel info) { CommerceReportModel temp = null; string strSql = string.Format(@" select report_content, id, check_month, check_year, check_date, insert_time, update_time from bl_commerce_report t where CHECK_MONTH=:V_CHECK_MONTH "); List <OracleParameter> aslgList = new List <OracleParameter>(); aslgList.Add(new OracleParameter(":V_CHECK_MONTH", info.CheckMonth)); DataTable dt = OracleHelper.Query(strSql, aslgList.ToArray()); if (dt != null) { if (dt.Rows.Count > 0) { temp = new CommerceReportModel(); temp.ReportContent = DBNull.Value == dt.Rows[0]["report_content"] ? string.Empty : dt.Rows[0]["report_content"].ToString(); } } return(temp); }
public string Report(dynamic _) { var recdata = this.GetResquetData <CommerceInModel>(); try { #region "接口调用验证" //bool flag = DataValidation(recdata.DateTime, recdata.Random, recdata.Sign); //if (!flag) //{ // return this.WriteValidationLog("LoginModule", recdata.DeviceId); //} #endregion CommerceBusiness messageBll = new CommerceBusiness(); CommerceReportModel list = messageBll.GetReport(recdata.data); if (list != null) { return(this.SendData <CommerceReportModel>(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)); } }