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