Example #1
0
        public IActionResult getParticularSlotById(long slotId)
        {
            DBHelper dbHelper = new DBHelper();

            try
            {
                var res = new ParticularSlot();
                res.areas = AreaController.getAreasById(slotId);
                if (res.areas == null)
                {
                    return(NotFound("暂无场次"));
                }
                string            query             = "SELECT MAP,SELLER_ID,SHOW_ID FROM SLOT WHERE ID = :slotId";
                OracleParameter[] parameterForQuery = { new OracleParameter(":slotId", OracleDbType.Long, 10) };
                parameterForQuery[0].Value = slotId;

                DataTable dt = dbHelper.ExecuteTable(query, parameterForQuery);
                res.map      = dt.Rows[0]["MAP"].ToString() == string.Empty ? null : Convert.ToBase64String((byte[])(dt.Rows[0]["MAP"]));
                res.sellerId = long.Parse(dt.Rows[0]["SELLER_ID"].ToString());
                long              showId                = long.Parse(dt.Rows[0]["SHOW_ID"].ToString());
                string            queryName             = "SELECT NAME FROM SHOW WHERE ID=:showId";
                OracleParameter[] parameterForQueryName = { new OracleParameter(":showId", OracleDbType.Long, 10) };
                parameterForQueryName[0].Value = showId;
                DataTable dtForName = dbHelper.ExecuteTable(queryName, parameterForQueryName);
                string    name      = dtForName.Rows[0]["NAME"].ToString();
                res.showName = name;

                return(Ok(new JsonResult(res)));
            }
            catch (OracleException oe)
            {
                return(BadRequest("数据库请求错误 " + "错误代码 " + oe.Number.ToString()));
            }
        }
Example #2
0
        public IActionResult GetSlot(long?sellerId)
        {
            if (sellerId is null)
            {
                return(BadRequest("商家id为空"));
            }
            DBHelper dbHelper = new DBHelper();

            try
            {
                var               res                   = new List <SellerSlot>();
                string            querySlotStr          = "SELECT ID ,SHOW_ID ,PLACE ,DAY ,TIME_START ,TIME_END FROM SLOT WHERE IS_VALID = 1 AND SELLER_ID = :sellerId";
                OracleParameter[] parameterForQuerySlot =
                {
                    new OracleParameter(":sellerId", OracleDbType.Long)
                };
                parameterForQuerySlot[0].Value = sellerId;
                DataTable dtSlot = dbHelper.ExecuteTable(querySlotStr, parameterForQuerySlot);
                foreach (DataRow row in dtSlot.Rows)
                {
                    long              Id                    = long.Parse(row["ID"].ToString());
                    long              showId                = long.Parse(row["SHOW_ID"].ToString());
                    string            queryShowName         = "SELECT NAME FROM SHOW WHERE ID =:showId";
                    OracleParameter[] parameterForQueryName = { new OracleParameter(":showId", OracleDbType.Long, 10) };
                    parameterForQueryName[0].Value = showId;
                    DataTable dtForName = dbHelper.ExecuteTable(queryShowName, parameterForQueryName);
                    string    name      = dtForName.Rows[0]["NAME"].ToString();
                    res.Add(new SellerSlot()
                    {
                        id        = Id,
                        showName  = name,
                        place     = row["PLACE"].ToString(),
                        day       = row["DAY"].ToString(),
                        timeStart = row["TIME_START"].ToString(),
                        timeEnd   = row["TIME_END"].ToString(),
                        areas     = AreaController.getAreasById(Id),
                    });
                }
                if (res.Count == 0)
                {
                    return(NotFound("无匹配结果"));
                }
                else
                {
                    return(Ok(new JsonResult(res)));
                }
            }
            catch (OracleException oe)
            {
                return(BadRequest("数据库请求错误" + "错误代码" + oe.Number));
            }
        }