Пример #1
0
        public bool DeleteS35MenuFinal(S35MenuFinal data)
        {
            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("@S35MenuID", data.S35MenuID),
                new SqlParameter("@CompanyID", CommonInfo.CompanyInfo.CompanyID),
                new SqlParameter("@UserID", UserInfo.UserID)
            };

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

            return(true);
        }
Пример #2
0
        public bool UpdateS35MenuFinal(S35MenuFinal data)
        {
            SqlParameter[] sqlParameters = new SqlParameter[]
            {
                new SqlParameter("@S35MenuFinalID", data.S35MenuFinalID),
                new SqlParameter("@CompanyID", CommonInfo.CompanyInfo.CompanyID),
                new SqlParameter("@ItemID", data.ItemID),
                new SqlParameter("@ItemUnitID", data.ItemUnitID),
                new SqlParameter("@Price", data.Price),
                new SqlParameter("@Quantity", data.Quantity),
                new SqlParameter("@Amount", data.Amount),
                new SqlParameter("@AmountMaterial", data.AmountMaterial),
                new SqlParameter("@S35MenuFinalExID", data.S35MenuFinalExID),
                new SqlParameter("@S35MenuID", data.S35MenuID),
                new SqlParameter("@UpdateUser", UserInfo.UserID)
            };

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

            return(true);
        }