C# (CSharp) Eyousoft_yhq.Model.MComLianMeng 예제들

예제 #1

        /// <summary>
        /// 获取公司配置信息
        /// </summary>
        public Eyousoft_yhq.Model.MComLianMeng GetComLianMeng()
        {
            var strSql = new StringBuilder();

            strSql.Append("SELECT SUM(OrderPrice) AS SealMoney,(SELECT COUNT(1) FROM dbo.tbl_Member WHERE IsAgent='1')AS Agent,COUNT(1) AS OorderCount FROM dbo.tbl_Order");

            DbCommand dc = _db.GetSqlStringCommand(strSql.ToString());

            var model = new Eyousoft_yhq.Model.MComLianMeng();

            using (IDataReader dr = DbHelper.ExecuteReader(dc, _db))
            {
                while (dr.Read())
                {
                    model.Agent       = dr.IsDBNull(dr.GetOrdinal("Agent")) ? 0 : dr.GetInt32(dr.GetOrdinal("Agent"));
                    model.OorderCount = dr.IsDBNull(dr.GetOrdinal("OorderCount")) ? 0 : dr.GetInt32(dr.GetOrdinal("OorderCount"));
                    model.SealMoney   = dr.IsDBNull(dr.GetOrdinal("SealMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("SealMoney"));
                }
            }

            return(model);
        }

예제 #2

파일: KV.cs 프로젝트: uwitec/O2O

        /// <summary>
        /// 获取公司配置信息
        /// </summary>
        public Eyousoft_yhq.Model.MComLianMeng GetComLianMeng()
        {
            var strSql = new StringBuilder();

            strSql.Append("SELECT SUM(OrderPrice) AS SealMoney,(SELECT COUNT(1) FROM dbo.tbl_Member WHERE IsAgent='1')AS Agent,COUNT(1) AS OorderCount FROM dbo.tbl_Order");

            DbCommand dc = _db.GetSqlStringCommand(strSql.ToString());

            var model = new Eyousoft_yhq.Model.MComLianMeng();
            using (IDataReader dr = DbHelper.ExecuteReader(dc, _db))
            {
                while (dr.Read())
                {
                    model.Agent = dr.IsDBNull(dr.GetOrdinal("Agent")) ? 0 : dr.GetInt32(dr.GetOrdinal("Agent"));
                    model.OorderCount = dr.IsDBNull(dr.GetOrdinal("OorderCount")) ? 0 : dr.GetInt32(dr.GetOrdinal("OorderCount"));
                    model.SealMoney = dr.IsDBNull(dr.GetOrdinal("SealMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("SealMoney"));

                }
            }

            return model;
        }