/// <summary> /// 首页达标率和 运行达标情况 /// </summary> /// <param name="info"></param> /// <returns></returns> public CommerceStandardModel GetCommerceStandard(CommerceInModel info) { CommerceStandardModel retInfo = null; string strSql = string.Format(@" select id, total_standard, meat_standard, veg_standard, check_date, check_month, check_year, insert_time, update_time from bl_commerce_standard where check_month=:v_check_date "); DataTable dt = OracleHelper.Query(strSql, new OracleParameter(":v_check_date", info.CheckMonth)); if (dt != null) { if (dt.Rows.Count > 0) { retInfo = new CommerceStandardModel(); retInfo.CheckMonth = info.CheckMonth; retInfo.MeatStandard = DBNull.Value == dt.Rows[0]["meat_standard"] ? string.Empty : dt.Rows[0]["meat_standard"].ToString(); retInfo.TotalStandard = DBNull.Value == dt.Rows[0]["total_standard"] ? string.Empty : dt.Rows[0]["total_standard"].ToString(); retInfo.VegStandard = DBNull.Value == dt.Rows[0]["veg_standard"] ? string.Empty : dt.Rows[0]["veg_standard"].ToString(); } } return(retInfo); }
/// <summary> /// 企业达标情况 /// </summary> /// <param name="_"></param> /// <returns></returns> public string CommerceStandard(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(); CommerceStandardModel info = messageBll.GetCommerceStandard(recdata.data); if (info != null) { return(this.SendData <CommerceStandardModel>(info, "获取考核达标情况成功", 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)); } }