set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[STPGetInvoicePrint] @SerialNo int AS SELECT CASE WHEN invoicetbl.FK_AccountSysCode IS NULL THEN CustomerName ELSE CodeMNGDWNTbl.Title END AS نام, InvoiceTbl.Comment AS توضیحات, InvoiceTbl.InvoiceDate AS تاریخ, InvoiceTbl.InvoiceNo AS شماره, InvoiceTbl.SysDate AS تاریخ_ورود, InvoiceTbl.InvoiceSerialNo AS شماره_سریال, Users.UName AS کاربر, VW_ContactId_ContactSumary.Address AS آدرس, VW_ContactId_ContactSumary.Tel AS تلفن, VW_ContactId_ContactSumary.Mobile AS موبایل, VW_ContactId_ContactSumary.Fax AS فاکس, CodeMNGDWNTbl_1.Title AS بازاریاب, InvoiceTbl.PaymentDate AS سررسید, VW_Account_Remain.Remain AS مانده_حساب, VW_invoice_Cost_Amount.TotalAmount AS مبلغ_کل, VW_invoice_Cost_Amount.CostAmount AS مبلغ_سایر, VW_invoice_Cost_Amount.InvoiceAmount AS مبلغ_فاکتور, dbo.FunConvCurToString(VW_invoice_Cost_Amount.TotalAmount) AS مبلغ_به_حروف FROM CodeMNGDWNTbl AS CodeMNGDWNTbl_1 RIGHT OUTER JOIN VW_invoice_Cost_Amount RIGHT OUTER JOIN InvoiceTbl ON VW_invoice_Cost_Amount.FK_InvoiceSysCode = InvoiceTbl.InvoiceSerialNo ON CodeMNGDWNTbl_1.AccountSysCode = InvoiceTbl.VisitorSyscode LEFT OUTER JOIN PersonTbl INNER JOIN VW_ContactId_ContactSumary ON PersonTbl.ContactId = VW_ContactId_ContactSumary.ID RIGHT OUTER JOIN CodeMNGDWNTbl LEFT OUTER JOIN VW_Account_Remain ON CodeMNGDWNTbl.AccountSysCode = VW_Account_Remain.Account ON PersonTbl.FK_AccountSysCode = CodeMNGDWNTbl.AccountSysCode ON InvoiceTbl.FK_AccountSysCode = CodeMNGDWNTbl.AccountSysCode LEFT OUTER JOIN Users ON InvoiceTbl.UserNo = Users.UID WHERE (InvoiceTbl.InvoiceSerialNo = @SerialNo)