03-07-18, 04:20 PM
(آخر تعديل لهذه المشاركة : 03-07-18, 04:22 PM {2} بواسطة aloush.
تعديل السبب: عدم ارفاق المشروع
)
سلام شباب كيفكن في عندي سورس كود برنامج محاسبة تقريبا كامل حاولت انو حولو للغة السي شارب ولكن في ايرور بيطلعلي بس افتح الفاتورة و الايرور عبارة عن فونكشن معمول بالسيكوال سيرفر عن تفقيت الأرقام الى احرف
public DataTable show_bill1(int id_, string PARENT_)
{
CON = new CLS_CON();
DT = new DataTable();
DT.Clear();
// 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
DT = CON.SELECT_TXT("SELECT dbo.BILL1.GUID, dbo.BILL1.PARENT_GUID, dbo.BILL1.NUMBER, dbo.BILL1.DELETE_NUM, dbo.BILL1.CUST, dbo.BILL1.Date_Delete, dbo.BILL1.NOTE, dbo.BILL1.STORE_GUID, dbo.STORE.NAME AS Expr2, dbo.BILL1.DATE, dbo.BILL1.disc, dbo.BILL1.type_pay, dbo.BILL1.GUID_CURRENCY, dbo.CURRENCY.NAME AS Expr3, dbo.BILL1.CURRENCY_VAL, dbo.BILL1.EXTEA, dbo.BILL1.type_dis, dbo.BILL1.disc_rate, dbo.BILL1.CUSTOMER_NAME, dbo.BILL1.CUSTOMER_MOBILE1, dbo.BILL1.CUSTOMER_MOBILE2, dbo.BILL1.CUSTOMER_COMPANY, dbo.BILL1.CUSTOMER_STREET, dbo.BILL1.CUSTOMER_PHON, dbo.BILL1.CUSTOMER_EMAIL, dbo.BILL1.PAY_1_PAY, dbo.BILL1.PAY_1_GUID, dbo.BILL1.TRAN_POS_GUID, dbo.BILL1.TRAN_POS_PAY, dbo.BILL1.VAT, (select [dbo].FNTafkeet(BILL1.total,BILL1.GUID_CURRENCY)) FROM dbo.BILL1 INNER JOIN dbo.STORE ON dbo.BILL1.STORE_GUID = dbo.STORE.GUID INNER JOIN dbo.CURRENCY ON dbo.BILL1.GUID_CURRENCY = dbo.CURRENCY.GUID WHERE (dbo.BILL1.DELETE_NUM = 0)and(BILL1.PARENT_GUID='" + PARENT_ + "')and(BILL1.NUMBER=" + id_ + ")");
return DT;
}
public DataTable show_bill1(int id_, string PARENT_)
{
CON = new CLS_CON();
DT = new DataTable();
DT.Clear();
// 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
DT = CON.SELECT_TXT("SELECT dbo.BILL1.GUID, dbo.BILL1.PARENT_GUID, dbo.BILL1.NUMBER, dbo.BILL1.DELETE_NUM, dbo.BILL1.CUST, dbo.BILL1.Date_Delete, dbo.BILL1.NOTE, dbo.BILL1.STORE_GUID, dbo.STORE.NAME AS Expr2, dbo.BILL1.DATE, dbo.BILL1.disc, dbo.BILL1.type_pay, dbo.BILL1.GUID_CURRENCY, dbo.CURRENCY.NAME AS Expr3, dbo.BILL1.CURRENCY_VAL, dbo.BILL1.EXTEA, dbo.BILL1.type_dis, dbo.BILL1.disc_rate, dbo.BILL1.CUSTOMER_NAME, dbo.BILL1.CUSTOMER_MOBILE1, dbo.BILL1.CUSTOMER_MOBILE2, dbo.BILL1.CUSTOMER_COMPANY, dbo.BILL1.CUSTOMER_STREET, dbo.BILL1.CUSTOMER_PHON, dbo.BILL1.CUSTOMER_EMAIL, dbo.BILL1.PAY_1_PAY, dbo.BILL1.PAY_1_GUID, dbo.BILL1.TRAN_POS_GUID, dbo.BILL1.TRAN_POS_PAY, dbo.BILL1.VAT, (select [dbo].FNTafkeet(BILL1.total,BILL1.GUID_CURRENCY)) FROM dbo.BILL1 INNER JOIN dbo.STORE ON dbo.BILL1.STORE_GUID = dbo.STORE.GUID INNER JOIN dbo.CURRENCY ON dbo.BILL1.GUID_CURRENCY = dbo.CURRENCY.GUID WHERE (dbo.BILL1.DELETE_NUM = 0)and(BILL1.PARENT_GUID='" + PARENT_ + "')and(BILL1.NUMBER=" + id_ + ")");
return DT;
}