本文整理汇总了C#中DAL.clsDataLayer.fnExecuteDataSet方法的典型用法代码示例。如果您正苦于以下问题：C# clsDataLayer.fnExecuteDataSet方法的具体用法？C# clsDataLayer.fnExecuteDataSet怎么用？C# clsDataLayer.fnExecuteDataSet使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DAL.clsDataLayer的用法示例。
在下文中一共展示了clsDataLayer.fnExecuteDataSet方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetTicketIdByEmail
public DataSet GetTicketIdByEmail()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@EmailID", emailId);
p[1] = new SqlParameter("@MBRefNo", manabusRefNo);
// p[2] = new SqlParameter("@Query", "GetByMBRefNo");
return ObjDAL.fnExecuteDataSet("Sp_PartialCancellation1", p);
}
catch (Exception ex)
{
throw ex;
}
}示例2: GetTransID
public DataSet GetTransID(string RefNo)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@tableName", "GetTransIdByRefNo");
p[1] = new SqlParameter("@ReferenceNo", RefNo);
return ObjDAL.fnExecuteDataSet("sp_DomesticFlightBooking", p);
}
catch (Exception ex)
{
throw ex;
}
}示例3: AddDomesticFlightBooking
public DataTable AddDomesticFlightBooking(FlightBAL objFlightBAL)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[38];
p[0] = new SqlParameter("@ReferenceNo", objFlightBAL.ReferenceNo);
p[1] = new SqlParameter("@TransId", objFlightBAL.TransId);
p[2] = new SqlParameter("@Status", objFlightBAL.Status);
p[3] = new SqlParameter("@AdultPax", objFlightBAL.AdultPax);
p[4] = new SqlParameter("@InfantPax", objFlightBAL.InfantPax);
p[5] = new SqlParameter("@ChildPax", objFlightBAL.ChildPax);
p[6] = new SqlParameter("@Origin_Destination_Id", objFlightBAL.Origin_Destination_Id);
p[7] = new SqlParameter("@Origin_Destination_Key", objFlightBAL.Origin_Destination_Key);
p[8] = new SqlParameter("@ActualBasefare", objFlightBAL.ActualBasefare);
p[9] = new SqlParameter("@Tax", objFlightBAL.Tax);
p[10] = new SqlParameter("@STax", objFlightBAL.STax);
p[11] = new SqlParameter("@Scharge", objFlightBAL.Scharge);
p[12] = new SqlParameter("@TDiscount", objFlightBAL.TDiscount);
p[13] = new SqlParameter("@TPartnerCommission", objFlightBAL.TPartnerCommission);
p[14] = new SqlParameter("@TCharge", objFlightBAL.TCharge);
p[15] = new SqlParameter("@TMarkUp", objFlightBAL.TMarkUp);
p[16] = new SqlParameter("@TSDiscount", objFlightBAL.TSDiscount);
p[17] = new SqlParameter("@Customer_Details", objFlightBAL.Customer_Details);
p[18] = new SqlParameter("@telephone", objFlightBAL.telephone);
p[19] = new SqlParameter("@emailAddress", objFlightBAL.emailAddress);
p[20] = new SqlParameter("@tableName", "InsertDomFlightBooking");
p[21] = new SqlParameter("@CreatedBy", objFlightBAL.CreatedBy);
p[22] = new SqlParameter("@TripMode", objFlightBAL.TripMode);
p[23] = new SqlParameter("@address", objFlightBAL.Address);
p[24] = new SqlParameter("@Type", objFlightBAL.Type);
p[25] = new SqlParameter("@id", objFlightBAL.id);
p[26] = new SqlParameter("@key", objFlightBAL.key);
p[27] = new SqlParameter("@ActualBasefareRet", objFlightBAL.ActualBasefareRet);
p[28] = new SqlParameter("@TaxRet", objFlightBAL.TaxRet);
p[29] = new SqlParameter("@STaxRet", objFlightBAL.STaxRet);
p[30] = new SqlParameter("@SchargeRet", objFlightBAL.SchargeRet);
p[31] = new SqlParameter("@TDiscountRet", objFlightBAL.TDiscountRet);
p[32] = new SqlParameter("@TPartnerCommissionRet", objFlightBAL.TPartnerCommissionRet);
p[33] = new SqlParameter("@TChargeRet", objFlightBAL.TChargeRet);
p[34] = new SqlParameter("@TMarkUpRet", objFlightBAL.TMarkUpRet);
p[35] = new SqlParameter("@TSDiscountRet", objFlightBAL.TSDiscountRet);
p[36] = new SqlParameter("@idRet", objFlightBAL.idRet);
p[37] = new SqlParameter("@keyRet", objFlightBAL.keyRet);
return ObjDAL.fnExecuteDataSet("sp_DomesticFlightBooking", p).Tables[0];
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}示例4: GetCarDetaisl
public DataSet GetCarDetaisl(string RefNo,string carid)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@Query", "getpassengerdetails");
p[1] = new SqlParameter("@ReferanceId", RefNo);
p[2] = new SqlParameter("@CarDetailsId", carid);
return ObjDAL.fnExecuteDataSet("sp_CarProvisional", p);
}
catch (Exception ex)
{
throw ex;
}
}示例5: GetFlightSalesReport
public DataSet GetFlightSalesReport()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@Flag", "FlightSalesReport");
p[1] = new SqlParameter("@FromDate", FromDate);
p[2] = new SqlParameter("@ToDate", ToDate);
p[3] = new SqlParameter("@agentId", agentId);
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_FlightsSalesReport", p);
return ObjDataset;
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}示例6: Upstatus
public string Upstatus(int UserId, double Amount)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@Flag", "upstatus");
p[1] = new SqlParameter("@UserId", UserId);
p[2] = new SqlParameter("@DepositAmount", Amount);
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_AgentDepositRequests", p);
return ObjDataset.ToString();
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}示例7: AddAgentDeposit
public string AddAgentDeposit(int agentId, double amount, string details, int createdBy, string depositType, string transactionNumber, string reason)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[9];
p[0] = new SqlParameter("@Flag", "InsertAgentBalance");
p[1] = new SqlParameter("@AgentId", agentId);
p[2] = new SqlParameter("@Amount", amount);
p[3] = new SqlParameter("@Details", details);
p[4] = new SqlParameter("@CreatedBy", createdBy);
p[5] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[5].Direction = ParameterDirection.Output;
p[6] = new SqlParameter("@DepositType", depositType);
p[7] = new SqlParameter("@TransactionNumber", transactionNumber);
p[8] = new SqlParameter("@Reason", reason);
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_Agents", p);
return Convert.ToString(p[5].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}示例8: GetUsers
public DataSet GetUsers()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@Query", "Get");
return ObjDAL.fnExecuteDataSet("Sp_Users", p);
}
catch (Exception ex)
{
throw ex;
}
}示例9: InsertAgentLogo
public string InsertAgentLogo(int userId, byte[] agentLogo)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@Flag", "InsertAgentLogo");
p[1] = new SqlParameter("@AgentId", userId);
p[3] = new SqlParameter("@AgentLogo", agentLogo);
p[2] = new SqlParameter("@Message", SqlDbType.NVarChar, 4000);
p[2].Direction = ParameterDirection.Output;
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_Agents", p);
return Convert.ToString(p[2].Value.ToString());
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
}示例10: GetUpdatedCouponDetails
public DataSet GetUpdatedCouponDetails()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@PGMBRefNo", manabusRefNo);
p[1] = new SqlParameter("@Query", "UpdateAfterBooking");
return ObjDAL.fnExecuteDataSet("Sp_CashCoupon", p);
}
catch (Exception ex)
{
throw ex;
}
}示例11: GetUserPermissions
public DataSet GetUserPermissions()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@Query", "Get");
p[1] = new SqlParameter("@UserID", ID);
return ObjDAL.fnExecuteDataSet("Sp_Permissions", p);
}
catch (Exception ex)
{
throw ex;
}
}示例12: GetUniqueId
public string GetUniqueId()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@Id", SqlDbType.BigInt);
p[0].Direction = ParameterDirection.Output;
ObjDataset = (DataSet)ObjDAL.fnExecuteDataSet("sp_GetId", p);
return Convert.ToString(p[0].Value.ToString());
}
catch (Exception)
{
throw;
}
}示例13: GetTicketIdByTicketrefNo
public DataSet GetTicketIdByTicketrefNo()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@PGMBRefNo", manabusRefNo);
p[1] = new SqlParameter("@Query", "GetByMBRefNo");
return ObjDAL.fnExecuteDataSet("Sp_TicketBookings", p);
}
catch (Exception ex)
{
throw ex;
}
}示例14: GetTicketIdByrefnoforcancel
public DataSet GetTicketIdByrefnoforcancel()
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@MBRefNo", manabusRefNo);
p[1] = new SqlParameter("@createdBy", createdBy);
return ObjDAL.fnExecuteDataSet("Sp_PartialCancellationAdmin", p);
}
catch (Exception ex)
{
throw ex;
}
}示例15: UpdateSource
public DataSet UpdateSource(string status, string originalId, string modifiedId)
{
try
{
ObjDAL = new clsDataLayer();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@Query", "UpdateSource");
p[1] = new SqlParameter("@Status", status);
p[2] = new SqlParameter("@ID", originalId);
p[3] = new SqlParameter("@ModifiedID", modifiedId);
return ObjDAL.fnExecuteDataSet("Sp_Sources", p);
}
catch (Exception ex)
{
throw ex;
}
}