本文整理汇总了C#中LumexDBPlayer.AddParameters方法的典型用法代码示例。如果您正苦于以下问题：C# LumexDBPlayer.AddParameters方法的具体用法？C# LumexDBPlayer.AddParameters怎么用？C# LumexDBPlayer.AddParameters使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类LumexDBPlayer的用法示例。
在下文中一共展示了LumexDBPlayer.AddParameters方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: 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;
}
}示例2: 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;
}
}示例3: 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;
}示例4: 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;
}
}示例5: 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;
}
}示例6: 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;
}示例7: 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;
}示例8: SaveCreditVoucherCash
public DataTable SaveCreditVoucherCash(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("@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_CASH", true);
return dt;
}
catch (Exception)
{
throw;
}
finally
{
debitCreditVoucher = null;
}
}示例9: SaveMenuGroup
public DataTable SaveMenuGroup(AppMenuBLL appMenu, LumexDBPlayer db)
{
try
{
db.AddParameters("@MenuGroupName", appMenu.MenuGroupName.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("@URL", appMenu.URL.Trim());
db.AddParameters("@MenuType", appMenu.MenuType.Trim());
db.AddParameters("@MenuForApp", appMenu.MenuForApp.Trim());
DataTable dt = db.ExecuteDataTable("INSERT_MENU_GROUP", true);
return dt;
}
catch (Exception)
{
throw;
}
finally
{
appMenu = null;
}
}示例10: GetCustomerReceivableList
public DataTable GetCustomerReceivableList(string customerId, LumexDBPlayer db)
{
try
{
db.AddParameters("@CustomerId", customerId.Trim());
db.AddParameters("@SalesCenterId", (string)LumexSessionManager.Get("UserSalesCenterId"));
DataTable dt = db.ExecuteDataTable("GET_CUSTOMER_RECEIVABLE_LIST_BY_ID", true);
return dt;
}
catch (Exception)
{
throw;
}
}示例11: CreateId
public DataTable CreateId(LumexDBPlayer db, string flag)
{
try
{
db.AddParameters("@HeadName",flag);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
DataTable dt = db.ExecuteDataTable("[GET_AUTO_GENERATE_NUMBER_FROM_IDCREATE]", true);
return dt;
}
catch (Exception)
{
throw;
}
}示例12: GetCustomerListByActivationStatusAndJoiningSC
public DataTable GetCustomerListByActivationStatusAndJoiningSC(string isActive, string joiningSalesCenterId, LumexDBPlayer db)
{
try
{
db.AddParameters("@IsActive", isActive.Trim());
db.AddParameters("@SalesCenterId", joiningSalesCenterId.Trim());
DataTable dt = db.ExecuteDataTable("GET_CUSTOMERS_BY_SC_AND_ACTIVATION_STATUS", true);
return dt;
}
catch (Exception)
{
throw;
}
}示例13: 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;
}
}示例14: DeleteTodaysCashOutEntryBySerial
public void DeleteTodaysCashOutEntryBySerial(string serial, LumexDBPlayer db)
{
try
{
db.AddParameters("@Serial", serial);
db.AddParameters("@DeletedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@DeletedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("DELETE_TODAYS_CASH_OUT_ENTRY_BY_SERIAL", true);
}
catch (Exception)
{
throw;
}
}示例15: GetTodaysCashOutEntryList
public DataTable GetTodaysCashOutEntryList(CashOutBLL cashOut, LumexDBPlayer db)
{
try
{
db.AddParameters("@SalesCenterId", cashOut.SalesCenterId);
db.AddParameters("@EntryDate", cashOut.EntryDate);
db.AddParameters("@Staus", cashOut.Status);
DataTable dt = db.ExecuteDataTable("GET_TODAYS_CASH_OUT_ENTRY_LIST", true);
return dt;
}
catch (Exception)
{
throw;
}
}