예제 #1
0
        public bool UpdateS35MenuDetailSanXuatFinal(S35MenuDetailSanXuatFinal data)
        {
            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("@S35MenuDetailSXFNID", data.S35MenuDetailSXFNID),
                new SqlParameter("@CompanyID", CommonInfo.CompanyInfo.CompanyID),
                new SqlParameter("@TPID", data.TPID),
                new SqlParameter("@InvoiceS35ID", data.InvoiceS35ID),
                new SqlParameter("@InvoiceS35DetailID", data.InvoiceS35DetailID),
                new SqlParameter("@ItemID", data.ItemID),
                new SqlParameter("@Quantity", data.Quantity),
                new SqlParameter("@Price", data.Price),
                new SqlParameter("@Amount", data.Amount),
                new SqlParameter("@VAT", data.VAT),
                new SqlParameter("@VATAmount", data.VATAmount),
                new SqlParameter("@TotalAmount", data.TotalAmount),
                new SqlParameter("@QuantityDAPUNG", data.QuantityDAPUNG),
                new SqlParameter("@PriceRoot", data.PriceRoot),
                new SqlParameter("@AmountRoot", data.AmountRoot),
                new SqlParameter("@UpdateUser", UserInfo.UserID)
            };

            this.Context.ExecuteDataFromProcedure("S35MenuDetailSanXuatFinalUpdate", sqlParameters);

            return(true);
        }
예제 #2
0
        public bool DeleteS35MenuDetailSanXuatFinal(S35MenuDetailSanXuatFinal data)
        {
            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("@S35MenuDetailSXFNID", data.S35MenuDetailSXFNID),
                new SqlParameter("@CompanyID", CommonInfo.CompanyInfo.CompanyID)
            };

            this.Context.ExecuteDataFromProcedure("S35MenuDetailSanXuatFinalDelete", sqlParameters);

            return(true);
        }