예제 #1
0
        public ApiMessage <List <StoreGood> > GetGoods(BaseParm parm)
        {
            var page   = new ApiMessage <List <StoreGood> >();
            var strSql = new StringBuilder();

            strSql.Append(@"SELECT DISTINCT p.ID,p.Name,p.TypeID,p1.Url,p2.Price,p2.MemberPrice,p2.LimitNum,p2.UnitName,p2.UnitID,s.Amount ,s.OutAmount
                  FROM product p
                  LEFT JOIN(SELECT * FROM productimg n WHERE n.RowNO = 0)  p1 ON p.ID = p1.ProductID
                  LEFT JOIN productprice p2 ON p.ID = p2.ProductID
                  INNER JOIN store s ON p.ID = s.ProductID AND p2.UnitID = s.UnitID
                  LEFT JOIN producttype  p3 ON p.TypeID = p3.ID
                  WHERE p.IsActive = 1 AND s.Amount>0 ");
            if (!string.IsNullOrEmpty(parm.Name))
            {
                strSql.Append(" And p.name like  CONCAT('%',@name,'%')");
            }
            if (parm.Type == "2")
            {
                if (parm.Code == "1")
                {
                    strSql.Append(" ORDER BY p2.Price Desc");
                }
                else
                {
                    strSql.Append(" ORDER BY p2.Price ");
                }
            }
            else if (parm.Type == "1")
            {
                strSql.Append(" ORDER BY s.OutAmount desc");
            }
            else
            {
                strSql.Append(" ORDER BY p3.OrderByNo, p3.CreateDate, p.OrderByNo ");
            }
            strSql.Append("  LIMIT @m,@n");
            var list =
                _db.Fetch <StoreGood>(strSql.ToString(), new
            {
                name = parm.Name,
                m    = (parm.page - 1) * parm.rows,
                n    = parm.rows
            });

            page.Data = list;
            return(page);
        }
예제 #2
0
        public ApiMessage <userinfo> LoginOn(userinfo user)
        {
            var strSql = PetaPoco.Sql.Builder;

            strSql.Append("select * from userinfo f  ");
            strSql.Where("f.UserCode=@0  and f.IsActive=1", user.UserCode);
            strSql.Where("f.PassWord=@0 ", user.PassWord);
            var loginUser = _db.Fetch <userinfo>(strSql).FirstOrDefault();

            if (string.IsNullOrEmpty(loginUser?.ID))
            {
                return(new ApiMessage <userinfo> {
                    MsgCode = "400", Msg = "用户不存在或密码有误", Success = false
                });
            }
            return(new ApiMessage <userinfo> {
                Data = loginUser
            });
        }
예제 #3
0
        public ApiMessage <staff> LoginOn(staff user)
        {
            var strSql = PetaPoco.Sql.Builder;

            strSql.Append("select f.* from staff f left join station s on s.ID=f.StationID ");
            strSql.Where("f.UserCode=@0  and f.IsActive=1", user.UserCode);
            strSql.Where("f.PassWord=@0 and s.IsActive=1", user.PassWord);
            var loginUser = _db.Fetch <staff>(strSql).FirstOrDefault();

            if (string.IsNullOrEmpty(loginUser?.ID))
            {
                return(new ApiMessage <staff> {
                    MsgCode = "400", Msg = "用户不存在或密码有误", Success = false
                });
            }
            return(new ApiMessage <staff> {
                Data = loginUser
            });
        }