예제 #1
0
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            Good   good     = new Good();
            Window addGoods = new AddGoods(good);

            addGoods.Show();
            addGoods.Closed += AddGoods_Closed;
        }
예제 #2
0
        private void BtnAction_Click(object sender, RoutedEventArgs e)
        {
            Button button = (Button)sender;
            string goodId = button.Uid;

            Good good = Util.ToObject <Good>(new GoodService().GetGoodById(goodId));

            Window addGoods = new AddGoods(good);

            addGoods.Title = "编辑商品";
            addGoods.Show();
            addGoods.Closed += AddGoods_Closed;
        }
예제 #3
0
 /// <summary>
 /// конструктор
 /// </summary>
 public MainWindow()
 {
     InitializeComponent();
     // Создадим набор данных для 8 запроса
     dataSetQuery8 = new DataSet();
     dataSetQuery9 = new DataSet();
     // Очищаем набор данных
     dataSetQuery8.Clear();
     dataSetQuery9.Clear();
     // задаим строки подключения
     conn_A          = new NpgsqlConnection("server=students.ami.nstu.ru; database=risbd4; user Id=risbd4_ext; password=ris14bd4_ext");
     conn_B          = new NpgsqlConnection("server=localhost; database=postgres; user Id=test; password=test");
     formAddCategory = new AddCategory(conn_B);
     formAddClient   = new AddClient(conn_A, conn_B);
     formAddCompany  = new AddCompany(conn_A, conn_B);
     formAddGoods    = new AddGoods(conn_A, conn_B);
     // formAddCategory.Show();
 }
예제 #4
0
        public IActionResult addGoods(AddGoods goods)        // 首先查找要添加的周边关联的演出ID是否是本商家的,然后利用主码自增添加周边到GOODS表,再将每个生成的ID对应的周边的价格和库存加到SELLER_GOODS表
        {
            try
            {
                //首先查找要添加的周边关联的演出ID是否已在本商家发布的场次中
                DBHelper          dbHelper          = new DBHelper();
                string            query             = "SELECT * FROM SLOT WHERE SHOW_ID=:showId AND SELLER_ID=:sellerId AND IS_VALID = 1";
                OracleParameter[] parameterForQuery =
                {
                    new OracleParameter(":showId",   OracleDbType.Long, 10),
                    new OracleParameter(":sellerId", OracleDbType.Long, 10)
                };
                parameterForQuery[0].Value = goods.showId;
                parameterForQuery[1].Value = goods.sellerId;
                DataTable dt = dbHelper.ExecuteTable(query, parameterForQuery);
                if (dt.Rows.Count == 0)
                {
                    return(BadRequest("未查询到关联演出,添加失败"));
                }
                else
                {
                    //添加周边到GOODS表
                    ulong id = dbHelper.ExecuteMax("GOODS");        //利用主码自增生成周边id
                    id++;

                    string            insert_into_goods            = "INSERT INTO GOODS VALUES(:id,:goodsName,:showId,:is_valid,:photo)";
                    OracleParameter[] parametersForInsertIntoGoods =
                    {
                        new OracleParameter(":id",        OracleDbType.Long,     10),
                        new OracleParameter(":goodsName", OracleDbType.Varchar2, 10),
                        new OracleParameter(":showId",    OracleDbType.Long,     10),
                        new OracleParameter(":is_valid",  OracleDbType.Long,      1),
                        new OracleParameter(":photo",     OracleDbType.Blob)
                    };

                    parametersForInsertIntoGoods[0].Value = id;
                    parametersForInsertIntoGoods[1].Value = goods.goodsName;
                    parametersForInsertIntoGoods[2].Value = goods.showId;
                    parametersForInsertIntoGoods[3].Value = 1;     //添加时默认有效位为1
                    byte[] blob = System.Text.Encoding.Default.GetBytes(goods.goodsPhoto);
                    parametersForInsertIntoGoods[4].Value = blob;

                    dbHelper.ExecuteNonQuery(insert_into_goods, parametersForInsertIntoGoods);


                    //添加周边到SELLER_GOODS表
                    string            insert = "INSERT INTO SELLER_GOODS VALUES(:sellerId,:goodsId,:price,:available)";
                    OracleParameter[] parametersForInsert =
                    {
                        new OracleParameter(":sellerId",  OracleDbType.Long,    10),
                        new OracleParameter(":goodsId",   OracleDbType.Long,    10),
                        new OracleParameter(":price",     OracleDbType.Double),
                        new OracleParameter(":available", OracleDbType.Long,     5),
                    };

                    parametersForInsert[0].Value = goods.sellerId;
                    parametersForInsert[1].Value = id;
                    parametersForInsert[2].Value = goods.price;
                    parametersForInsert[3].Value = goods.available;

                    dbHelper.ExecuteNonQuery(insert, parametersForInsert);
                    return(Ok("添加成功"));
                }
            }
            catch (OracleException)
            {
                return(BadRequest("发生异常,添加失败"));
            }
        }