예제 #1
0
        public List <StockCreationFinishedGood> FinishedGoodsGrid()
        {
            var FinishedGoods = new List <StockCreationFinishedGood>();
            var a             = new StockCreationFinishedGood();

            FinishedGoods.Add(a);
            return(FinishedGoods);
        }
예제 #2
0
        public int InsertFinishedGoods(StockCreationFinishedGood model, IDbConnection connection, IDbTransaction txn)
        {
            string query = @"INSERT INTO StockCreationFinishedGoods
                            (
	                            StockCreationId,
	                            ItemId,
	                            Quantity,
	                            Rate
                            )
                            VALUES
                            (
                                @StockCreationId,
	                            @ItemId,
	                            @Quantity,
	                            @Rate
                            );
                            SELECT CAST(SCOPE_IDENTITY() AS INT)";

            return(connection.Query <int>(query, model, txn).First());
        }