public Order_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(ORDER.ORDER_TBL); q += AddFields.Primary(ORDER.ORDER_ID); q += AddFields.Unique_500(ORDER.UNIQUENO); q += AddFields.Foreign(ORDER.ORDER_TBL, ORDER.COMPANY_ID); q += AddFields.Foreign(ORDER.ORDER_TBL, ORDER.ACY_ID); q += AddFields.VARCHAR_500(ORDER.ORDER_NO); q += AddFields.Date(ORDER.ORDER_DATE); q += AddFields.Foreign(ORDER.ORDER_TBL, ORDER.ORDERTYPE_ID); q += AddFields.Foreign(ORDER.ORDER_TBL, ORDER.PARTY_ID); q += AddFields.VARCHAR_500(ORDER.PARTY_REF); q += AddFields.VARCHAR_500(ORDER.REFERED_NO); q += AddFields.Smallint(ORDER.LOCKED); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(ORDER.ORDER_TBL); q += AddFields.EOF; new DAL().Execute(q); OrderItems_Tbl(db); }
public QreceiptTbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(QRECEIPT.QRECEIPT_TBL); q += Fields.Primary(QRECEIPT.QRECEIPT_ID); q += Fields.Unique_500(QRECEIPT.UNIQUENO); q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.COMPANY_ID); q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.DIV_ID); q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.ACY_ID); q += Fields.Int(QRECEIPT.QRECEIPT_NO); q += Fields.Date(QRECEIPT.QRECEIPT_DATE); q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.PARTY_ID); q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.RECEIPTTYPE_ID); q += Fields.VARCHAR_200(QRECEIPT.CHEQ_NO); q += Fields.Decimal_2(QRECEIPT.QRECEIPT_AMOUNT); q += Fields.VARCHAR_100(QRECEIPT.CHEQ_DATE); q += Fields.Foreign(QRECEIPT.QRECEIPT_TBL, QRECEIPT.BANK_ID); q += Fields.Decimal_2(QRECEIPT.TOTAL_AMOUNT); q += Fields.Notes; q += Fields.Active; q += Fields.User_id(QRECEIPT.QRECEIPT_TBL); q += Fields.EOF; new DAL().Execute(q); QreceiptitemsTbl(db); }
public Knitting_receipt_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL); q += Fields.Primary(KNITTING_RECEIPT.KNITTING_RECEIPT_ID); q += Fields.Unique_500(KNITTING_RECEIPT.UNIQUENO); q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.COMPANY_ID); q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.ACY_ID); q += Fields.Int(KNITTING_RECEIPT.KNITTING_RECEIPT_NO); q += Fields.Date(KNITTING_RECEIPT.KNITTING_RECEIPT_DATE); q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.PARTY_ID); q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.RECEIPTTYPE_ID); q += Fields.VARCHAR_200(KNITTING_RECEIPT.CHEQ_NO); q += Fields.Decimal_2(KNITTING_RECEIPT.KNITTING_RECEIPT_AMOUNT); q += Fields.VARCHAR_200(KNITTING_RECEIPT.CHEQ_DATE); q += Fields.Foreign(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL, KNITTING_RECEIPT.BANK_ID); q += Fields.Decimal_2(KNITTING_RECEIPT.TOTAL_AMOUNT); q += Fields.VARCHAR_200(KNITTING_RECEIPT.REFERED_NO); q += Fields.Notes; q += Fields.Active; q += Fields.User_id(KNITTING_RECEIPT.KNITTING_RECEIPT_TBL); q += Fields.EOF; new SYS_DAL().Execute(q); Knitting_receiptItems_Tbl(db); }
public Receipt_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(RECEIPT.RECEIPT_TBL); q += AddFields.Primary(RECEIPT.RECEIPT_ID); q += AddFields.Unique_500(RECEIPT.UNIQUENO); q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.COMPANY_ID); q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.ACY_ID); q += AddFields.Int(RECEIPT.RECEIPT_NO); q += AddFields.Date(RECEIPT.RECEIPT_DATE); q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.PARTY_ID); q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.RECEIPTTYPE_ID); q += AddFields.VARCHAR_200(RECEIPT.CHEQ_NO); q += AddFields.Decimal_2(RECEIPT.RECEIPT_AMOUNT); q += AddFields.VARCHAR_200(RECEIPT.CHEQ_DATE); q += AddFields.Foreign(RECEIPT.RECEIPT_TBL, RECEIPT.BANK_ID); q += AddFields.Decimal_2(RECEIPT.TOTAL_AMOUNT); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(RECEIPT.RECEIPT_TBL); q += AddFields.EOF; new DAL().Execute(q); ReceiptItems_Tbl(db); }
public Garment_order_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(GARMENT_ORDER.GARMENT_ORDER_TBL); q += Fields.Primary(GARMENT_ORDER.GARMENT_ORDER_ID); q += Fields.Unique_500(GARMENT_ORDER.UNIQUENO); q += Fields.Foreign(GARMENT_ORDER.GARMENT_ORDER_TBL, GARMENT_ORDER.COMPANY_ID); q += Fields.Foreign(GARMENT_ORDER.GARMENT_ORDER_TBL, GARMENT_ORDER.ACY_ID); q += Fields.Int(GARMENT_ORDER.GARMENT_ORDER_NO); q += Fields.Date(GARMENT_ORDER.GARMENT_ORDER_DATE); q += Fields.Foreign(GARMENT_ORDER.GARMENT_ORDER_TBL, GARMENT_ORDER.ORDERTYPE_ID); q += Fields.Foreign(GARMENT_ORDER.GARMENT_ORDER_TBL, GARMENT_ORDER.PARTY_ID); q += Fields.VARCHAR_500(GARMENT_ORDER.PARTY_REF); q += Fields.VARCHAR_500(GARMENT_ORDER.STYLE_REF); q += Fields.VARCHAR_500(GARMENT_ORDER.REFERED_NO); q += Fields.Smallint(GARMENT_ORDER.LOCKED); q += Fields.Notes; q += Fields.Active; q += Fields.User_id(GARMENT_ORDER.GARMENT_ORDER_TBL); q += Fields.EOF; new DAL().Execute(q); Garment_orderItems_Tbl(db); }
public Offset_invoice_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(OFFSET_INVOICE.OFFSET_INVOICE_TBL); q += Fields.Primary(OFFSET_INVOICE.OFFSET_INVOICE_ID); q += Fields.Unique_500(OFFSET_INVOICE.UNIQUENO); q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.COMPANY_ID); q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.ACY_ID); q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.TAXTYPE_ID); q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.SALESTYPE_ID); q += Fields.Int(OFFSET_INVOICE.OFFSET_INVOICE_NO); q += Fields.Date(OFFSET_INVOICE.OFFSET_INVOICE_DATE); q += Fields.Foreign(OFFSET_INVOICE.OFFSET_INVOICE_TBL, OFFSET_INVOICE.PARTY_ID); q += Fields.VARCHAR_200(OFFSET_INVOICE.TOTAL_QTY); q += Fields.Decimal_2(OFFSET_INVOICE.TOTAL_TAXABLE_AMOUNT); q += Fields.Decimal_2(OFFSET_INVOICE.TOTAL_CGST); q += Fields.Decimal_2(OFFSET_INVOICE.TOTAL_SGST); q += Fields.Decimal_2(OFFSET_INVOICE.TOTAL_IGST); q += Fields.Decimal_2(OFFSET_INVOICE.GSTTOTAL); q += Fields.VARCHAR_500(OFFSET_INVOICE.LEDGER_ID); q += Fields.Decimal_2(OFFSET_INVOICE.ADDITIONAL); q += Fields.Decimal_2(OFFSET_INVOICE.ROUNDS); q += Fields.Decimal_2(OFFSET_INVOICE.GRANDTOTAL); q += Fields.VARCHAR_200(OFFSET_INVOICE.REFERED_AMT); q += Fields.Smallint(OFFSET_INVOICE.LOCKED); q += Fields.Notes; q += Fields.Active; q += Fields.User_id(OFFSET_INVOICE.OFFSET_INVOICE_TBL); q += Fields.EOF; new SYS_DAL().Execute(q); Offset_invoiceItems_Tbl(db); }
public Party_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(PARTY.PARTY_TBL); q += AddFields.Primary(PARTY.PARTY_ID); q += AddFields.Unique_500(PARTY.PARTY_NAME); q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.CONTACTTYPE_ID); q += AddFields.VARCHAR_500(PARTY.CONTACT_PERSON); q += AddFields.VARCHAR_500(PARTY.STREET_1); q += AddFields.VARCHAR_500(PARTY.STREET_2); q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.CITY_ID); q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.STATE_ID); q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.COUNTRY_ID); q += AddFields.Foreign(PARTY.PARTY_TBL, PARTY.PINCODE_ID); q += AddFields.VARCHAR_500(PARTY.PHONE); q += AddFields.VARCHAR_500(PARTY.CELL); q += AddFields.VARCHAR_500(PARTY.EMAIL); q += AddFields.VARCHAR_500(PARTY.WEBSITE); q += AddFields.VARCHAR_200(PARTY.GSTIN); q += AddFields.VARCHAR_200(PARTY.PAN); q += AddFields.Decimal_2(PARTY.OPENING_BALANCE); q += AddFields.Decimal_2(PARTY.CREDIT_DAYS); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(PARTY.PARTY_TBL); q += AddFields.EOF; new SYS_DAL().Execute(q); }
public Gstfile(string db) { string q = USE.DB(db); q += CREATE.TABLE(GSTFILE.GSTFILE_TBL); q += Fields.Primary(GSTFILE.GSTFILE_ID); q += Fields.VAR100(GSTFILE.MONTH); q += Fields.VAR100(GSTFILE.INVOICEDATE); q += Fields.VAR100(GSTFILE.INVOICENO); q += Fields.Foreign(GSTFILE.GSTFILE_TBL, GSTFILE.PARTY_ID); q += Fields.VAR100(GSTFILE.GSTNO); q += Fields.Decimal_2(GSTFILE.TAXABLEVALUE); q += Fields.Decimal_2(GSTFILE.SGST_PERCENT); q += Fields.Decimal_2(GSTFILE.SGST_AMOUNT); q += Fields.Decimal_2(GSTFILE.CGST_PERCENT); q += Fields.Decimal_2(GSTFILE.CGST_AMOUNT); q += Fields.Decimal_2(GSTFILE.IGST_PERCENT); q += Fields.Decimal_2(GSTFILE.IGST_AMOUNT); q += Fields.Decimal_2(GSTFILE.GST_AMOUNT); q += Fields.Notes; q += Fields.Active; q += Fields.User_id(GSTFILE.GSTFILE_TBL); q += Fields.EOF; new DAL().Execute(q); }
public Garment_Receipt_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL); q += Fields.Primary(GARMENT_RECEIPT.GARMENT_RECEIPT_ID); q += Fields.Unique_500(GARMENT_RECEIPT.UNIQUENO); q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.COMPANY_ID); q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.ACY_ID); q += Fields.Int(GARMENT_RECEIPT.GARMENT_RECEIPT_NO); q += Fields.Date(GARMENT_RECEIPT.GARMENT_RECEIPT_DATE); q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.PARTY_ID); q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.RECEIPTTYPE_ID); q += Fields.VARCHAR_200(GARMENT_RECEIPT.CHEQ_NO); q += Fields.Decimal_2(GARMENT_RECEIPT.GARMENT_RECEIPT_AMOUNT); q += Fields.VARCHAR_200(GARMENT_RECEIPT.CHEQ_DATE); q += Fields.Foreign(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL, GARMENT_RECEIPT.BANK_ID); q += Fields.Decimal_2(GARMENT_RECEIPT.TOTAL_AMOUNT); q += Fields.Notes; q += Fields.Active; q += Fields.User_id(GARMENT_RECEIPT.GARMENT_RECEIPT_TBL); q += Fields.EOF; new SYS_DAL().Execute(q); Garment_receiptItems_Tbl(db); }
public Quotation_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(QUOTATION.QUOTATION_TBL); q += AddFields.Primary(QUOTATION.QUOTATION_ID); q += AddFields.Unique_500(QUOTATION.UNIQUENO); q += AddFields.Foreign(QUOTATION.QUOTATION_TBL, QUOTATION.COMPANY_ID); q += AddFields.Foreign(QUOTATION.QUOTATION_TBL, QUOTATION.ACY_ID); q += AddFields.Foreign(QUOTATION.QUOTATION_TBL, QUOTATION.ORDER_ID); q += AddFields.Int(QUOTATION.QUOTATION_NO); q += AddFields.Date(QUOTATION.QUOTATION_DATE); q += AddFields.Foreign(QUOTATION.QUOTATION_TBL, QUOTATION.PARTY_ID); q += AddFields.Decimal_3(QUOTATION.TOTAL_QTY); q += AddFields.Decimal_2(QUOTATION.TOTAL_TAXABLE_AMOUNT); q += AddFields.VARCHAR_200(QUOTATION.LEDGER_ID); q += AddFields.Decimal_2(QUOTATION.ADDITIONAL); q += AddFields.Decimal_2(QUOTATION.ROUNDS); q += AddFields.Decimal_2(QUOTATION.GRANDTOTAL); q += AddFields.Decimal_2(QUOTATION.REFERED_AMT); q += AddFields.Smallint(QUOTATION.LOCKED); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(QUOTATION.QUOTATION_TBL); q += AddFields.EOF; new SYS_DAL().Execute(q); Tex_invoiceItems_Tbl(db); }
public Outward_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(OUTWARD.OUTWARD_TBL); q += AddFields.Primary(OUTWARD.OUTWARD_ID); q += AddFields.Unique_500(OUTWARD.UNIQUENO); q += AddFields.Foreign(OUTWARD.OUTWARD_TBL, OUTWARD.COMPANY_ID); q += AddFields.Foreign(OUTWARD.OUTWARD_TBL, OUTWARD.ACY_ID); q += AddFields.Foreign(OUTWARD.OUTWARD_TBL, OUTWARD.ORDER_ID); q += AddFields.Int(OUTWARD.OUTWARD_NO); q += AddFields.Date(OUTWARD.OUTWARD_DATE); q += AddFields.Int(OUTWARD.PARTY_ID); q += AddFields.VARCHAR_200(OUTWARD.TOTAL_QTY); q += AddFields.VARCHAR_200(OUTWARD.TOTAL_BUNDEL); q += AddFields.VARCHAR_200(OUTWARD.DELIVREDTHROUGH); q += AddFields.Smallint(OUTWARD.LOCKED); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(OUTWARD.OUTWARD_TBL); q += AddFields.EOF; new DAL().Execute(q); InwardItems_Tbl(db); }
public Offset_po_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(OFFSET_PO.OFFSET_PO_TBL); q += Fields.Primary(OFFSET_PO.OFFSET_PO_ID); q += Fields.Unique_500(OFFSET_PO.UNIQUENO); q += Fields.Foreign(OFFSET_PO.OFFSET_PO_TBL, OFFSET_PO.COMPANY_ID); q += Fields.Foreign(OFFSET_PO.OFFSET_PO_TBL, OFFSET_PO.ACY_ID); q += Fields.Unique_500(OFFSET_PO.OFFSET_PO_NO); q += Fields.Date(OFFSET_PO.OFFSET_PO_DATE); q += Fields.Foreign(OFFSET_PO.OFFSET_PO_TBL, OFFSET_PO.PARTY_ID); q += Fields.VARCHAR_500(OFFSET_PO.PARTY_PO_REF); q += Fields.Date(OFFSET_PO.DELIVERY_DATE); q += Fields.VARCHAR_500(OFFSET_PO.TOTAL_QTY); q += Fields.Decimal_2(OFFSET_PO.TOTAL_AMOUNT); q += Fields.VARCHAR_200(OFFSET_PO.REFERED_NO); q += Fields.Smallint(OFFSET_PO.LOCKED); q += Fields.Notes; q += Fields.Active; q += Fields.User_id(OFFSET_PO.OFFSET_PO_TBL); q += Fields.EOF; new SYS_DAL().Execute(q); Offset_poItems_Tbl(db); }
public Company_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(COMPANY.COMPANY_TBL); q += AddFields.Primary(COMPANY.COMPANY_ID); q += AddFields.Unique_500(COMPANY.COMPANY_NAME); q += AddFields.VARCHAR_500(COMPANY.DISPLAY_NAME); q += AddFields.VARCHAR_500(COMPANY.STREET1); q += AddFields.VARCHAR_500(COMPANY.STREET2); q += AddFields.Foreign(COMPANY.COMPANY_TBL, COMPANY.CITY_ID); q += AddFields.Foreign(COMPANY.COMPANY_TBL, COMPANY.STATE_ID); q += AddFields.Foreign(COMPANY.COMPANY_TBL, COMPANY.COUNTRY_ID); q += AddFields.Foreign(COMPANY.COMPANY_TBL, COMPANY.PINCODE_ID); q += AddFields.VARCHAR_200(COMPANY.CELL1); q += AddFields.VARCHAR_500(COMPANY.CELL2); q += AddFields.VARCHAR_500(COMPANY.PHONE); q += AddFields.VARCHAR_500(COMPANY.EMAIL); q += AddFields.VARCHAR_500(COMPANY.WEBSITE); q += AddFields.VARCHAR_500(COMPANY.GSTIN); q += AddFields.VARCHAR_500(COMPANY.PAN); q += AddFields.VARCHAR_500(COMPANY.COMP_CODE); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(COMPANY.COMPANY_TBL); q += AddFields.EOF; new DAL().Execute(q); }
public Payment_Tbl(string database) { string q = USE.DB(database); q += CREATE.TABLE(PAYMENT.PAYMENT_TBL); q += Fields.Primary(PAYMENT.PAYMENT_ID); q += Fields.Unique(PAYMENT.UNIQUENO); q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.COMPANY_ID); q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.DIV_ID); q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.ACY_ID); q += Fields.Int(PAYMENT.PAYMENT_NO); q += Fields.Date(PAYMENT.PAYMENT_DATE); q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.PARTY_ID); q += Fields.Decimal(PAYMENT.AMOUNT); q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.MODE_ID); q += Fields.VAR100(PAYMENT.CHEQUE_NO); q += Fields.Date(PAYMENT.CHEQUE_DATE); q += Fields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.BANK_ID); q += Fields.Date(PAYMENT.DEPOSITON); q += Fields.Notes(); q += Fields.Active(); q += Fields.User_id(PAYMENT.PAYMENT_TBL); //new DAL().Execute(q); System.Diagnostics.Debug.WriteLine(q); }
public void Insert(string database) { string q = USE.DB(database); q += CREATE.TABLE(INVOICE.INVOICE_TBL); q += Fields.Primary(INVOICE.INVOICE_ID); q += Fields.Unique(INVOICE.UNIQUENO); q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.COMPANY_ID); q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.DIV_ID); q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.ACY_ID); q += Fields.Int(INVOICE.INVOICE_NO); q += Fields.Date(INVOICE.INVOICE_DATE); q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.TAXTYPE_ID); q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.SALESTYPE_ID); q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.PARTY_ID); q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.TRANSPORT_ID); q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.DELIVERYAT_ID); q += Fields.VAR100(INVOICE.BUNDLE); q += Fields.Decimal(INVOICE.TOTAL_TAXABLE_AMOUNT); q += Fields.Decimal(INVOICE.TOTAL_CGST); q += Fields.Decimal(INVOICE.TOTAL_SGST); q += Fields.Decimal(INVOICE.TOTAL_IGST); q += Fields.Decimal(INVOICE.GSTTOTAL); q += Fields.Foreign(INVOICE.INVOICE_TBL, INVOICE.LEDGER_ID); q += Fields.Decimal(INVOICE.ADDITIONAL); q += Fields.Decimal(INVOICE.ROUNDS); q += Fields.Decimal(INVOICE.GRANDTOTAL); q += Fields.Decimal(INVOICE.REFERED_AMT); q += Fields.Notes(); q += Fields.Active(); q += Fields.User_id(INVOICE.INVOICE_TBL); new DAL().Execute(q); }
public Payment_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(PAYMENT.PAYMENT_TBL); q += AddFields.Primary(PAYMENT.PAYMENT_ID); q += AddFields.Unique_500(PAYMENT.UNIQUENO); q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.COMPANY_ID); q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.ACY_ID); q += AddFields.Int(PAYMENT.PAYMENT_NO); q += AddFields.Date(PAYMENT.PAYMENT_DATE); q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.PARTY_ID); q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.RECEIPTTYPE_ID); q += AddFields.VARCHAR_200(PAYMENT.CHEQUE_NO); q += AddFields.Decimal_2(PAYMENT.PAYMENT_AMOUNT); q += AddFields.VARCHAR_200(PAYMENT.CHEQUE_DATE); q += AddFields.Foreign(PAYMENT.PAYMENT_TBL, PAYMENT.BANK_ID); //q += Fields.Decimal_2(GARMENT_PAYMENT.TOTAL_AMOUNT); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(PAYMENT.PAYMENT_TBL); q += AddFields.EOF; new SYS_DAL().Execute(q); paymentItems_Tbl(db); }
public void CreateGlobal(string name) { const string CREATE = @"<AUTHORIZATION><AUTHORIZATIONPACKET action=""addnew"" name=""{0}""/></AUTHORIZATION>"; var answer = Project.ExecuteRQL(CREATE.RQLFormat(name)); CheckAnswer(name, answer); }
public Pincode_Tbl(string database) { string q = USE.DB(database); q += CREATE.TABLE(PINCODE.PINCODE_TBL); q += Fields.Primary(PINCODE.PINCODE_ID); q += Fields.Unique(PINCODE.PINCODE_NAME); q += Fields.Notes(); q += Fields.Active(); new DAL().Execute(q); }
public Role_Tbl(string database) { string q = USE.DB(database); q += CREATE.TABLE(ROLE.ROLE_TBL); q += Fields.Primary(ROLE.ROLE_ID); q += Fields.Unique(ROLE.ROLE_NAME); q += Fields.Notes(); q += Fields.Active(); new DAL().Execute(q); }
public Country_Tbl(string database) { string q = USE.DB(database); q += CREATE.TABLE(COUNTRY.COUNTRY_TBL); q += Fields.Primary(COUNTRY.COUNTRY_ID); q += Fields.Unique(COUNTRY.COUNTRY_NAME); q += Fields.Notes(); q += Fields.Active(); new DAL().Execute(q); }
private void CreateDetail(string elementtype, IRedDotObject obj, string name, AuthorizationType type) { const string CREATE = @"<AUTHORIZATION><{0} guid=""{1}><AUTHORIZATIONPACKET action=""addnew"" name=""{2}"" guid="" type=""{3}""/></{0}></AUTHORIZATION>"; string query = CREATE.RQLFormat(elementtype, obj, name, (int)type); var answer = Project.ExecuteRQL(query); CheckAnswer(name, answer); Standard.InvalidateCache(); }
public Cxversion_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(CXVERSION.CXVERSION_TBL); q += AddFields.Primary(CXVERSION.CXVERSION_ID); q += AddFields.Unique_500(CXVERSION.CXVERSION_NAME); q += AddFields.Date(CXVERSION.CREATED_ON); q += AddFields.EOF; new DAL().Execute(q); }
public Role_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(ROLE.ROLE_TBL); q += AddFields.Primary(ROLE.ROLE_ID); q += AddFields.Unique_500(ROLE.ROLE_NAME); q += AddFields.Notes; q += AddFields.Active; q += AddFields.EOF; new SYS_DAL().Execute(q); }
public Ordertype_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(ORDERTYPE.ORDERTYPE_TBL); q += AddFields.Primary(ORDERTYPE.ORDERTYPE_ID); q += AddFields.Unique_500(ORDERTYPE.ORDERTYPE_NAME); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(ORDERTYPE.ORDERTYPE_TBL); q += AddFields.EOF; new SYS_DAL().Execute(q); }
public Bundle_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(BUNDLE.BUNDLE_TBL); q += AddFields.Primary(BUNDLE.BUNDLE_ID); q += AddFields.Unique_500(BUNDLE.BUNDLE_NAME); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(BUNDLE.BUNDLE_TBL); q += AddFields.EOF; new DAL().Execute(q); }
public Ledgergroup_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(LEDGERGROUP.LEDGERGROUP_TBL); q += AddFields.Primary(LEDGERGROUP.LEDGERGROUP_ID); q += AddFields.Unique_500(LEDGERGROUP.LEDGERGROUP_NAME); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(LEDGERGROUP.LEDGERGROUP_TBL); q += AddFields.EOF; new SYS_DAL().Execute(q); }
public Shipping_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(SHIPPING.SHIPPING_TBL); q += AddFields.Primary(SHIPPING.SHIPPING_ID); q += AddFields.Unique_500(SHIPPING.SHIPPING_NAME); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(SHIPPING.SHIPPING_TBL); q += AddFields.EOF; new DAL().Execute(q); }
public Method_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(METHOD.METHOD_TBL); q += AddFields.Primary(METHOD.METHOD_ID); q += AddFields.Unique_500(METHOD.METHOD_NAME); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(METHOD.METHOD_TBL); q += AddFields.EOF; new DAL().Execute(q); }
public Producttype_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(PRODUCTTYPE.PRODUCTTYPE_TBL); q += AddFields.Primary(PRODUCTTYPE.PRODUCTTYPE_ID); q += AddFields.Unique_500(PRODUCTTYPE.PRODUCTTYPE_NAME); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(PRODUCTTYPE.PRODUCTTYPE_TBL); q += AddFields.EOF; new SYS_DAL().Execute(q); }
public Country_Tbl(string db) { string q = USE.DB(db); q += CREATE.TABLE(COUNTRY.COUNTRY_TBL); q += AddFields.Primary(COUNTRY.COUNTRY_ID); q += AddFields.Unique_500(COUNTRY.COUNTRY_NAME); q += AddFields.Notes; q += AddFields.Active; q += AddFields.User_id(COUNTRY.COUNTRY_TBL); q += AddFields.EOF; new SYS_DAL().Execute(q); }
public static extern int _lcreat([In] [MarshalAs(UnmanagedType.LPStr)] string lpPathName, CREATE iAttribute);