C# LumexDBPlayer类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中LumexDBPlayer类的典型用法代码示例。如果您正苦于以下问题：C# LumexDBPlayer类的具体用法？C# LumexDBPlayer怎么用？C# LumexDBPlayer使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

LumexDBPlayer类属于命名空间，在下文中一共展示了LumexDBPlayer类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: CheckDuplicateChartOfAccount

        public bool CheckDuplicateChartOfAccount(ChartOfAccountBLL chartOfAccount, LumexDBPlayer db)
        {
            bool status = false;

            try
            {
                db.AddParameters("@AccountType", chartOfAccount.AccountType.Trim());
                db.AddParameters("@AccountName", chartOfAccount.AccountName.Trim());
                db.AddParameters("@TotallingAccountNumber", chartOfAccount.TotallingAccountNumber.Trim());

                DataTable dt = db.ExecuteDataTable("CHECK_DUPLICATE_CHART_OF_ACCOUNT", true);

                if (dt.Rows.Count > 0)
                {
                    status = true;
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                chartOfAccount = null;
            }

            return status;
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:28，代码来源:ChartOfAccountDAL.cs

示例2: SaveCreditVoucherCheque

        public DataTable SaveCreditVoucherCheque(DebitCreditVoucherBLL debitCreditVoucher, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@ManualVoucherNumber", debitCreditVoucher.ManualVoucherNumber.Trim());
                db.AddParameters("@AccountId", debitCreditVoucher.AccountId.Trim());
                db.AddParameters("@CounterAccountId", debitCreditVoucher.CounterAccountId.Trim());
                db.AddParameters("@Amount", debitCreditVoucher.Amount.Trim());
                db.AddParameters("@Bank", debitCreditVoucher.Bank.Trim());
                db.AddParameters("@BankBranch", debitCreditVoucher.BankBranch.Trim());
                db.AddParameters("@ChequeNumber", debitCreditVoucher.ChequeNumber.Trim());
                db.AddParameters("@ChequeDate", debitCreditVoucher.ChequeDate.Trim());
                db.AddParameters("@PayToFromCompany", debitCreditVoucher.PayToFromCompany.Trim());
                db.AddParameters("@Narration", debitCreditVoucher.Narration.Trim());
                db.AddParameters("@OfficeBranchId", debitCreditVoucher.SalesCenterId);
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("INSERT_CREDIT_VOUCHER_CHEQUE", true);
                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                debitCreditVoucher = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:30，代码来源:DebitCreditVoucherDAL.cs

示例3: SaveChartOfAccount

        public DataTable SaveChartOfAccount(ChartOfAccountBLL chartOfAccount, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@AccountName", chartOfAccount.AccountName.Trim());
                db.AddParameters("@AccountType", chartOfAccount.AccountType.Trim());
                db.AddParameters("@TotallingAccountNumber", chartOfAccount.TotallingAccountNumber.Trim());
                db.AddParameters("@IsPosted", chartOfAccount.IsPosted.Trim());
                db.AddParameters("@UseAs", chartOfAccount.UseAs.Trim());
                db.AddParameters("@BankAccountNumber", chartOfAccount.BankAccountNumber.Trim());
                db.AddParameters("@Description", chartOfAccount.Description.Trim());
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
                db.AddParameters("@OfficeBranchId", "");

                DataTable dt = db.ExecuteDataTable("INSERT_CHART_OF_ACCOUNT", true);

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                chartOfAccount = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:28，代码来源:ChartOfAccountDAL.cs

示例4: SaveUser

        public DataTable SaveUser(UserBLL user, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@UserId", user.UserId.Trim());
                db.AddParameters("@SalesCenterId", user.SalesCenterId.Trim());
                db.AddParameters("@WareHouseId", user.warehouseId.Trim());
                db.AddParameters("@UserName", user.UserName.Trim());
                db.AddParameters("@EmployeeId", user.EmployeeId.Trim());
                db.AddParameters("@UserGroupId", user.UserGroupId.Trim());
                db.AddParameters("@Department", user.Department.Trim());
                db.AddParameters("@Designation", user.Designation.Trim());
                db.AddParameters("@Address", user.Address.Trim());
                db.AddParameters("@ContactNumber", user.ContactNumber.Trim());
                db.AddParameters("@Email", user.Email.Trim());
                db.AddParameters("@NationalId", user.NationalId.Trim());
                db.AddParameters("@PassportNumber", user.PassportNumber.Trim());
                db.AddParameters("@Password", ProtectPassword(user.Password.Trim()));
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("INSERT_USER", true);

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                user = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:34，代码来源:UserDAL.cs

示例5: SaveSalesPerson

        public DataTable SaveSalesPerson(SalesPersonBLL salesPerson, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@SalesPersonName", salesPerson.SalesPersonName.Trim());
                db.AddParameters("@Address", salesPerson.Address.Trim());
                db.AddParameters("@PostalCode", salesPerson.PostalCode.Trim());
                db.AddParameters("@City", salesPerson.City.Trim());
                db.AddParameters("@District", salesPerson.District.Trim());
                db.AddParameters("@Country", salesPerson.Country.Trim());
                db.AddParameters("@NationalId", salesPerson.NationalId.Trim());
                db.AddParameters("@PassportNumber", salesPerson.PassportNumber.Trim());
                db.AddParameters("@ContactNumber", salesPerson.ContactNumber.Trim());
                db.AddParameters("@Email", salesPerson.Email.Trim());
                db.AddParameters("@JoiningSalesCenterId", salesPerson.JoiningSalesCenterId.Trim());
                db.AddParameters("@WorkingSalesCenterId", salesPerson.WorkingSalesCenterId.Trim());
                db.AddParameters("@JoinDate", salesPerson.JoinDate.Trim());
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("INSERT_SALES_PERSON", true);
                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesPerson = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:32，代码来源:SalesPersonDAL.cs

示例6: SaveWarehouse

        public DataTable SaveWarehouse(WarehouseBLL warehouse, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@WarehouseName", warehouse.WarehouseName.Trim());
                db.AddParameters("@Address", warehouse.Address.Trim());
                db.AddParameters("@Country", warehouse.Country.Trim());
                db.AddParameters("@City", warehouse.City.Trim());
                db.AddParameters("@District", warehouse.District.Trim());
                db.AddParameters("@PostalCode", warehouse.PostalCode.Trim());
                db.AddParameters("@Phone", warehouse.Phone.Trim());
                db.AddParameters("@Mobile", warehouse.Mobile.Trim());
                db.AddParameters("@Fax", warehouse.Fax.Trim());
                db.AddParameters("@Email", warehouse.Email.Trim());
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("INSERT_WAREHOUSE", true);
                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                warehouse = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:29，代码来源:WarehouseDAL.cs

示例7: SaveMenu

        public DataTable SaveMenu(AppMenuBLL appMenu, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@MenuName", appMenu.MenuName.Trim());
                db.AddParameters("@DisplayName", appMenu.DisplayName.Trim());
                db.AddParameters("@MenuTarget", appMenu.MenuTarget.Trim());
                db.AddParameters("@ImageUrl", appMenu.ImageUrl.Trim());
                db.AddParameters("@ToolTipDescription", appMenu.ToolTipDescription.Trim());
                db.AddParameters("@ParentMenuId", appMenu.ParentMenuId.Trim());
                db.AddParameters("@URL", appMenu.URL.Trim());
                db.AddParameters("@MenuGroupId", appMenu.MenuGroupId.Trim());
                db.AddParameters("@MenuType", appMenu.MenuType.Trim());
                db.AddParameters("@MenuForApp", appMenu.MenuForApp.Trim());
                db.AddParameters("@MenuLevel", appMenu.MenuLevel.Trim());
                db.AddParameters("@IsDefault", appMenu.IsDefault.Trim());
                db.AddParameters("@IsDisplay", appMenu.IsDisplay.Trim());
                db.AddParameters("@IsSubParent", appMenu.IsSubParent.Trim());

                DataTable dt = db.ExecuteDataTable("INSERT_MENU", true);

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:32，代码来源:AppMenuDAL.cs

示例8: SavePayToFromCompany

        public DataTable SavePayToFromCompany(PayToFromCompanyBLL payToFromCompany, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@CompanyName", payToFromCompany.CompanyName);
                db.AddParameters("@Description", payToFromCompany.Description);
                db.AddParameters("@CompanyAddress", payToFromCompany.CompanyAddress);
                db.AddParameters("@CompanyContact", payToFromCompany.CompanyContact);
                db.AddParameters("@CompanyEmail", payToFromCompany.CompanyEmail);
                db.AddParameters("@CompanyWeb", payToFromCompany.CompanyWebsite);
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("INSERT_PAY_TO_FROM_COMPANY", true);
                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                payToFromCompany = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:25，代码来源:PayToFromCompanyDAL.cs

示例9: SaveSalesCenter

        public DataTable SaveSalesCenter(SalesCenterBLL salesCenter, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@SalesCenterName", salesCenter.SalesCenterName.Trim());
                db.AddParameters("@Address", salesCenter.Address.Trim());
                db.AddParameters("@Country", salesCenter.Country.Trim());
                db.AddParameters("@City", salesCenter.City.Trim());
                db.AddParameters("@District", salesCenter.District.Trim());
                db.AddParameters("@PostalCode", salesCenter.PostalCode.Trim());
                db.AddParameters("@Phone", salesCenter.Phone.Trim());
                db.AddParameters("@Mobile", salesCenter.Mobile.Trim());
                db.AddParameters("@Fax", salesCenter.Fax.Trim());
                db.AddParameters("@Email", salesCenter.Email.Trim());
                db.AddParameters("@WarehouseId", salesCenter.WarehouseId.Trim());
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("INSERT_SALES_CENTER", true);
                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesCenter = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:30，代码来源:SalesCenterDAL.cs

示例10: SaveCustomer

        public DataTable SaveCustomer(CustomerBLL customer, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@CustomerName", customer.CustomerName.Trim());
                db.AddParameters("@ContactNumber", customer.ContactNumber.Trim());
                db.AddParameters("@Email", customer.Email.Trim());
                db.AddParameters("@Country", customer.Country.Trim());
                db.AddParameters("@City", customer.City.Trim());
                db.AddParameters("@District", customer.District.Trim());
                db.AddParameters("@PostalCode", customer.PostalCode.Trim());
                db.AddParameters("@Address", customer.Address.Trim());
                db.AddParameters("@NationalId", customer.NationalId.Trim());
                db.AddParameters("@AdditionalInfo", customer.Description.Trim());
                db.AddParameters("@PassportNumber", customer.PassportNumber.Trim());
                db.AddParameters("@JoiningSalesCenterId", customer.JoiningSalesCenterId.Trim());
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("INSERT_CUSTOMER", true);
                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                customer = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:31，代码来源:CustomerDAL.cs

示例11: GetSalesCenterListByActivationStatus

        public ReportDocument GetSalesCenterListByActivationStatus(string sortedBy, string sortingOrder, string isActive, LumexDBPlayer db)
        {
            try
            {
                LumexSessionManager.Add("rptName", "Sales_Center_List");
                ReportDocument reportDocument = new ReportDocument();

                db.AddParameters("@SortedBy", sortedBy.Trim());
                db.AddParameters("@SortingOrder", sortingOrder.Trim());
                db.AddParameters("@IsActive", isActive.Trim());

                if (isActive == "All")
                {
                    reportDocument.Load(reportPath + "GET_SALES_CENTERS.rpt");
                }
                else
                {
                    reportDocument.Load(reportPath + "GET_SALES_CENTERS_BY_ACTIVATION_STATUS.rpt");
                }

                reportDocument.SetDataSource(db.ExecuteDataTable("REPORT_GET_SALES_CENTERS_BY_ACTIVATION_STATUS", true));

                return reportDocument;
            }
            catch (Exception)
            {
                throw;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:29，代码来源:GeneralReportsDAL.cs

示例12: ValidateUser

        public static bool ValidateUser(UserBLL user, LumexDBPlayer db)
        {
            bool isValid = false;

            try
            {
                db.AddParameters("@UserId", user.UserId);

                DataTable dt = db.ExecuteDataTable("GET_USER_PASS_ID_AT_LOGIN", true);

                DataTableReader dtr = dt.CreateDataReader();

                if (dtr.Read())
                {
                    if (ProtectPassword(user.Password) == dtr["Password"].ToString())
                    {
                        isValid = true;
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                user = null;
            }

            return isValid;
        }

开发者ID:atiburrahman09，项目名称:globalfxusa，代码行数:31，代码来源:UserDAL.cs

示例13: SaveUserSalesCentersByUserId

        public void SaveUserSalesCentersByUserId(string userId, List<string> salesCenters, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@UserId", userId);
                db.ExecuteNonQuery("DELETE_USER_SALES_CENTERS_BY_USER_ID", true);

                for (int i = 0; i < salesCenters.Count; i++)
                {
                    db.ClearParameters();
                    db.AddParameters("@UserId", userId);
                    db.AddParameters("@SalesCenterId", salesCenters[i].ToString());
                    db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                    db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                    db.ExecuteDataTable("INSERT_USER_SALES_CENTERS_BY_USER_ID", true);
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                salesCenters = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:27，代码来源:SalesCenterDAL.cs

示例14: SaveProductVendorsByProductId

        public void SaveProductVendorsByProductId(string productId, List<string> vendors, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@ProductId", productId);
                db.ExecuteNonQuery("DELETE_PRODUCT_VENDORS_BY_PRODUCT_ID", true);

                for (int i = 0; i < vendors.Count; i++)
                {
                    db.ClearParameters();
                    db.AddParameters("@ProductId", productId);
                    db.AddParameters("@VendorId", vendors[i].ToString());
                    db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                    db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                    db.ExecuteDataTable("INSERT_PRODUCT_VENDORS_BY_PRODUCT_ID", true);
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                vendors = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:27，代码来源:VendorDAL.cs

示例15: SaveBankChequeBook

        public DataTable SaveBankChequeBook(BankChequeBookBLL bankChequeBook, LumexDBPlayer db)
        {
            try
            {
                db.AddParameters("@AccountId", bankChequeBook.AccountId.Trim());
                db.AddParameters("@ChequeBookRefNo", bankChequeBook.ChequeBookRefNo.Trim());
                db.AddParameters("@StartPageNo", bankChequeBook.StartPageNo.Trim());
                db.AddParameters("@EndPageNo", bankChequeBook.EndPageNo.Trim());
                db.AddParameters("@OfficeBranchId", "");
                db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                DataTable dt = db.ExecuteDataTable("INSERT_CHEQUE_BOOK_ENTRY", true);

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                bankChequeBook = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:25，代码来源:BankChequeBookDAL.cs

示例16: CheckDuplicateBankChequeBook

        public bool CheckDuplicateBankChequeBook(BankChequeBookBLL bankChequeBook, LumexDBPlayer db)
        {
            bool status = false;

            try
            {
                db.AddParameters("@AccountId", bankChequeBook.AccountId.Trim());
                db.AddParameters("@StartPageNo", bankChequeBook.StartPageNo.Trim());
                db.AddParameters("@EndPageNo", bankChequeBook.EndPageNo.Trim());

                DataTable dt = db.ExecuteDataTable("CHECK_DUPLICATE_CHEQUE_BOOK_ENTRY", true);

                if (dt.Rows.Count > 0)
                {
                    status = true;
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                bankChequeBook = null;
            }

            return status;
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:28，代码来源:BankChequeBookDAL.cs

示例17: ChangeChequeStatusForOutFlow

 internal bool ChangeChequeStatusForOutFlow(LumexDBPlayer db, chequeInventoryBLL chequeInventoryBLL, string statusType)
 {
     bool status = false;
     try
     {
         db.AddParameters("@Serial", chequeInventoryBLL.chequeSerial.Trim());
         db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString().Trim());
         db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
         db.AddParameters("@Trandate",chequeInventoryBLL.Finaldate.Trim());
         db.AddParameters("@Naration", chequeInventoryBLL.naration.Trim());
         if (statusType == "R")
         {
             status = Convert.ToBoolean(db.ExecuteNonQuery("UPDATE_CHEQUE_INVENTORY_WHEN_REJECT", true));
         }
         if (statusType == "A")
         {
             status = Convert.ToBoolean(db.ExecuteNonQuery("[UPDATE_CHEQUE_INVENTORY_FOR_OUT_WHEN_APPROVE]", true));
         }
         if (statusType == "AC")
         {
             status = Convert.ToBoolean(db.ExecuteNonQuery("[UPDATE_CHEQUE_INVENTORY_FOR_OUT_WHEN_APPROVE_BY_CASH]", true));
         }
     }
     catch (Exception ex)
     {
         throw;
     }
     return status;
 }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:29，代码来源:chequeInventoryDAL.cs

示例18: SaveJournalVoucher

        public DataTable SaveJournalVoucher(string SalesCenter,DataTable dtJournalList, LumexDBPlayer db)
        {
            try
            {
                decimal amt = -1;
                int transactionNo = 0;

                db.AddParameters("@Flag", "JV");
                DataTable dtJournalNumber = db.ExecuteDataTable("GET_AND_UPDATE_AUTO_SERIAL_NUMBER_BY_FLAG", true);

                string journalNumber = dtJournalNumber.Rows[0][0].ToString();

                for (int i = 0; i < dtJournalList.Rows.Count; i++)
                {
                    db.ClearParameters();
                    db.AddParameters("@JournalNumber", journalNumber.Trim());
                    db.AddParameters("@TransactionNumber", dtJournalList.Rows[i]["SN"].ToString());
                    db.AddParameters("@ManualVoucherNumber", dtJournalList.Rows[i]["VoucherNumber"].ToString());
                    db.AddParameters("@AccountId", dtJournalList.Rows[i]["AccountHead"].ToString());
                    db.AddParameters("@DebitCredit", dtJournalList.Rows[i]["DebitCredit"].ToString());
                    db.AddParameters("@Amount", dtJournalList.Rows[i]["Amount"].ToString());
                    db.AddParameters("@Bank", dtJournalList.Rows[i]["Bank"].ToString());
                    db.AddParameters("@BankBranch", dtJournalList.Rows[i]["BankBranch"].ToString());
                    db.AddParameters("@ChequeNumber", dtJournalList.Rows[i]["ChequeNumber"].ToString());
                    db.AddParameters("@ChequeDate", dtJournalList.Rows[i]["ChequeDate"].ToString());
                    db.AddParameters("@PayToFromCompany", dtJournalList.Rows[i]["PayToFromCompany"].ToString());
                    db.AddParameters("@Narration", dtJournalList.Rows[i]["Narration"].ToString());
                    db.AddParameters("@OfficeBranchId", SalesCenter);
                    db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString());
                    db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());

                    DataTable dt = db.ExecuteDataTable("INSERT_JOURNAL_VOUCHER", true);

                    if (amt < decimal.Parse(dtJournalList.Rows[i]["Amount"].ToString()))
                    {
                        amt = decimal.Parse(dtJournalList.Rows[i]["Amount"].ToString());
                        transactionNo = int.Parse(dtJournalList.Rows[i]["SN"].ToString());
                    }
                }

                db.ClearParameters();
                db.AddParameters("@JournalNumber", journalNumber.Trim());
                db.AddParameters("@TransactionNumber", transactionNo);
                db.ExecuteNonQuery("INSERT_JOURNAL_VOUCHER_INTO_GENERAL_LEDGER_APPROVAL_BY_JOURNAL", true);

                return dtJournalNumber;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                dtJournalList = null;
            }
        }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:56，代码来源:JournalVoucherDAL.cs

示例19: GetCustomerList

 public DataTable GetCustomerList(LumexDBPlayer db)
 {
     try
     {
         DataTable dt = db.ExecuteDataTable("GET_CUSTOMERS", false);
         return dt;
     }
     catch (Exception)
     {
         throw;
     }
 }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:12，代码来源:CustomerDAL.cs

示例20: GetOverallProductVAT

 public DataTable GetOverallProductVAT(LumexDBPlayer db)
 {
     try
     {
         DataTable dt = db.ExecuteDataTable("GET_OVERALL_PRODUCT_VAT", false);
         return dt;
     }
     catch (Exception)
     {
         throw;
     }
 }

开发者ID:atiburrahman09，项目名称:Signbd，代码行数:12，代码来源:ProductPriceDAL.cs

注：本文中的LumexDBPlayer类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# MARC类代码示例发布时间：2022-05-24

C# LuceneVersion类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18096|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9618|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8149|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8531|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8432|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9347|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8397|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7833|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8387|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7380|2022-11-06

客服电话

电子邮件

C# LumexDBPlayer类代码示例

示例1: CheckDuplicateChartOfAccount

示例2: SaveCreditVoucherCheque

示例3: SaveChartOfAccount

示例4: SaveUser

示例5: SaveSalesPerson

示例6: SaveWarehouse

示例7: SaveMenu

示例8: SavePayToFromCompany

示例9: SaveSalesCenter

示例10: SaveCustomer

示例11: GetSalesCenterListByActivationStatus

示例12: ValidateUser

示例13: SaveUserSalesCentersByUserId

示例14: SaveProductVendorsByProductId

示例15: SaveBankChequeBook

示例16: CheckDuplicateBankChequeBook

示例17: ChangeChequeStatusForOutFlow

示例18: SaveJournalVoucher

示例19: GetCustomerList

示例20: GetOverallProductVAT

请发表评论

全部评论

上一篇：

下一篇：

CVE-2022-30213

bradtraversy/iweather: Ionic 3 mobile we

Adyen/adyen-node-api-library: Adyen API

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053