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)