Ejemplo n.º 1
0
        /// <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);
        }
Ejemplo n.º 2
0
        /// <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));
            }
        }