Beispiel #1
0
        public bool DeleteS35MenuDetailSanXuat(S35MenuDetailSanXuat data)
        {
            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("@S35MenuDetailSXID", data.S35MenuDetailSXID),
                new SqlParameter("@CompanyID", CommonInfo.CompanyInfo.CompanyID)
            };

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

            return(true);
        }
Beispiel #2
0
        public bool UpdateS35MenuDetailSanXuat(S35MenuDetailSanXuat data)
        {
            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("@S35MenuDetailSXID", data.S35MenuDetailSXID),
                new SqlParameter("@CompanyID", CommonInfo.CompanyInfo.CompanyID),
                new SqlParameter("@S35MenuSXID", data.S35MenuSXID),
                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("@UpdateUser", UserInfo.UserID)
            };

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

            return(true);
        }