本文整理汇总了C#中IO.ExecuteActionQuery方法的典型用法代码示例。如果您正苦于以下问题:C# IO.ExecuteActionQuery方法的具体用法?C# IO.ExecuteActionQuery怎么用?C# IO.ExecuteActionQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IO
的用法示例。
在下文中一共展示了IO.ExecuteActionQuery方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: AddRateDetail
public static bool AddRateDetail(Hashtable values)
{
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("MASTERDATA_ADDRATEDETAIL",
Param.CreateParam("RATEID", SqlDbType.Int, values["RATENAME"]),
Param.CreateParam("RATELOCALRENEW", SqlDbType.Decimal, values["RATELOCALRENEW"]),
Param.CreateParam("RATELOCALNEW", SqlDbType.Decimal, values["RATELOCALNEW"]),
Param.CreateParam("RATENATIONALRENEW", SqlDbType.Decimal, values["RATENATIONALRENEW"]),
Param.CreateParam("RATENATIONALNEW", SqlDbType.Decimal, values["RATENATIONALNEW"]),
Param.CreateParam("RATEEFFECTIVEDATE", SqlDbType.Date, values["RATEEFFECTIVEDATE"]),
Param.CreateParam("ACTIVE", SqlDbType.VarChar, values["ACTIVE"]),
Param.CreateParam("ISPACKAGE", SqlDbType.Int, values["ISPACKAGE"]),
Param.CreateParam("ENTEREDBY", SqlDbType.VarChar, Security.GetCurrentUserId)));
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
return false;
}
return true;
}
示例2: AddCreditCheckNote
public bool AddCreditCheckNote(int id, string contractNumber, string companyId, string creditAppReq, string creditChecked, string notes)
{
try
{
string enteredBy = Security.GetCurrentUserId;
using (IO io = new IO(WebCommon.ConnectionString))
{
using (System.Data.SqlClient.SqlCommand cmd = IO.CreateCommandFromStoredProc("COLLECTIONS_ADDCREDITCHECKNOTE"))
{
cmd.Parameters.Add(Param.CreateParam("CONTRACTNUMBER", SqlDbType.Int, Convert.ToInt32(contractNumber)));
cmd.Parameters.Add(Param.CreateParam("COMPANYID", SqlDbType.Int, Convert.ToInt32(companyId)));
cmd.Parameters.Add(Param.CreateParam("CREDITAPPPREPAY", SqlDbType.VarChar, creditAppReq));
cmd.Parameters.Add(Param.CreateParam("CREDITCHECKED", SqlDbType.VarChar, creditChecked));
cmd.Parameters.Add(Param.CreateParam("NOTES", SqlDbType.NText, notes));
cmd.Parameters.Add(Param.CreateParam("ENTEREDBY", SqlDbType.VarChar, enteredBy));
io.ExecuteActionQuery(cmd);
}
}
return true;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
return false;
}
}
示例3: DeleteProfitCenterRateXrefRecord
public static bool DeleteProfitCenterRateXrefRecord(int rateProfitCenterXrefId)
{
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("MASTERDATA_DELETERATEPROFITCENTERXREFRECORD", Param.CreateParam("RATEPROFITCENTERXREFID", SqlDbType.Int, rateProfitCenterXrefId)));
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
return false;
}
return true;
}
示例4: AddProfitCenterRateXrefRecord
public static bool AddProfitCenterRateXrefRecord(Hashtable values)
{
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("MASTERDATA_ADDRATEPROFITCENTERXREFRECORD",
Param.CreateParam("PROFITCENTERID", SqlDbType.Int, values["PROFITCENTERID"]),
Param.CreateParam("RATEID", SqlDbType.Int, values["RATEID"]),
Param.CreateParam("EFFECTIVEDATE", SqlDbType.Date, values["EFFECTIVEDATE"])));
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
return false;
}
return true;
}
示例5: AddNotes
public static bool AddNotes(string contractNumber, string companyId, string noteText)
{
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("ADDNOTE",
Param.CreateParam("CONTRACTNUMBER", SqlDbType.Int, Convert.ToInt32(contractNumber)),
Param.CreateParam("COMPANYID", SqlDbType.Int, Convert.ToInt32(companyId)),
Param.CreateParam("NOTETEXT", SqlDbType.NText, noteText),
Param.CreateParam("USERID", SqlDbType.VarChar, Security.GetCurrentUserId))); ;
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
return false;
}
return true;
}
示例6: AddUpdateUninvoicedContractNote
public bool AddUpdateUninvoicedContractNote(int id, int uidCmpgn, string companyId, string notes)
{
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("QUATTRO_ADDUPDATEUNINVOICEDNOTE",
Param.CreateParam("UID_CMPGN", SqlDbType.Int, uidCmpgn),
Param.CreateParam("NOTETEXT", SqlDbType.VarChar, notes),
Param.CreateParam("COMPANYID", SqlDbType.Int, Convert.ToInt32(companyId)),
Param.CreateParam("ADDEDBY", SqlDbType.VarChar, Security.GetFullUserNameFromId(Security.GetCurrentUserId))));
}
return true;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
return false;
}
}
示例7: DeleteBooking
public void DeleteBooking(int bookingId)
{
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("PRODUCTION_DELETEBOOKING", Param.CreateParam("BOOKINGID", SqlDbType.Int, bookingId)));
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to delete the Booking.");
}
}
示例8: DeactivateSelected
public void DeactivateSelected(string selectedIds)
{
string[] ids = selectedIds.Split(';');
DataTable selected = GetDigitalLibraryIdTable();
foreach (string id in ids)
{
selected.Rows.Add(id.Split(':')[0]);
}
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("DIGITALLIBRARY_UPDATEISDELETEDGROUP",
Param.CreateParam("IDGROUP", SqlDbType.Structured, selected),
Param.CreateParam("ISDELETED", SqlDbType.Int, 1)));
}
}
示例9: Save
/// <summary>TBD</summary>
public void Save()
{
List<System.Data.SqlClient.SqlParameter> spParams = new List<System.Data.SqlClient.SqlParameter>();
spParams.Add(Param.CreateParam("FLATRATENEW", SqlDbType.Decimal, this.FlatRateNew));
spParams.Add(Param.CreateParam("FLATRATERENEW", SqlDbType.Decimal, this.FlatRateRenew));
spParams.Add(Param.CreateParam("FLATRATEEFFECTIVEDATE", SqlDbType.Date, this.FlatRateEffectiveDate));
spParams.Add(Param.CreateParam("ENTEREDBY", SqlDbType.VarChar, Security.GetCurrentUserId));
string storedProcName = "";
if (this.FlatRateId == -1)
{
spParams.Add(Param.CreateParam("AEID", SqlDbType.VarChar, this.AEId));
spParams.Add(Param.CreateParam("COMPANYID", SqlDbType.Int, this.CompanyId));
storedProcName = "MASTERDATA_ADDAEFLATRATE";
}
else
{
spParams.Add(Param.CreateParam("FLATRATEID", SqlDbType.Int, this.FlatRateId));
storedProcName = "MASTERDATA_UPDATEAEFLATRATE";
}
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc(storedProcName, spParams));
}
}
示例10: DeleteRecord
/// <summary>TBD</summary>
/// <param name="aeFlatRateId">TBD</param>
public static void DeleteRecord(int aeFlatRateId)
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("MASTERDATA_DELETEFLATRATERECORD",
Param.CreateParam("AEFLATRATEID", SqlDbType.Int, aeFlatRateId),
Param.CreateParam("ENTEREDBY", SqlDbType.VarChar, Security.GetCurrentUserId)));
}
}
示例11: TagSelectedSingle
public bool TagSelectedSingle(Hashtable values)
{
try
{
DataTable tag = GetDigitalLibraryTagTable();
int id = Convert.ToInt32(values["ID"]);
string[] lineItems = Convert.ToString(values["LINE_ITEM_NUMBER"]).Split(';');
int contractNumber = Convert.ToInt32(values["CONTRACT_NUMBER"]);
string isHeroQuality = ((bool)values["IS_HERO_QUALITY"]) ? "Y" : "N";
string isMarketingQuality = ((bool)values["IS_MARKETING_QUALITY"]) ? "Y" : "N";
string takenBy = (string)values["TAKEN_BY"];
string notes = (string)values["NOTES"];
string salesMarketOverride = (string)values["SALES_MARKET_OVERRIDE"];
string stationMarketId = (string)values["STATION_MARKET_ID"];
string stationId = (string)values["STATION_ID"];
string ethnicityId = (string)values["ETHNICITY_ID"];
int companyId = 1;
try
{
companyId = Convert.ToInt32(values["COMPANY_ID"]);
}
catch
{
}
//Multiple line items may have been selected
foreach (string lineItemNumber in lineItems)
{
tag.Rows.Add(id, contractNumber, lineItemNumber, isHeroQuality, isMarketingQuality, takenBy, notes, salesMarketOverride, stationMarketId, stationId, ethnicityId, companyId);
//tag.Rows.Add(id, contractNumber, lineItemNumber, isHeroQuality, isMarketingQuality, takenBy, notes, salesMarketOverride, stationMarketId, stationId, companyId);
}
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("DIGITALLIBRARY_ADDTAGGROUP", Param.CreateParam("TAGGROUP", SqlDbType.Structured, tag)));
}
return true;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error has occurred while trying to tag your image(s).");
}
}
示例12: AddUpdateProdOverride
public bool AddUpdateProdOverride(int id, string overrideProdPerc, string overrideProdAmount, string overrideId, string contractNumber, string companyId)
{
try
{
List<System.Data.SqlClient.SqlParameter> spParams = new List<System.Data.SqlClient.SqlParameter>();
spParams.Add(Param.CreateParam("OVERRIDEID", SqlDbType.Int, Convert.ToInt32(overrideId)));
spParams.Add(Param.CreateParam("CONTRACTNUMBER", SqlDbType.Int, Convert.ToInt32(contractNumber)));
spParams.Add(Param.CreateParam("COMPANYID", SqlDbType.Int, Convert.ToInt32(companyId)));
if (!String.IsNullOrEmpty(overrideProdPerc))
{
spParams.Add(Param.CreateParam("OVERRIDEPERCENTAGE", SqlDbType.Decimal, Convert.ToDouble(overrideProdPerc)));
}
if (!String.IsNullOrEmpty(overrideProdAmount))
{
spParams.Add(Param.CreateParam("OVERRIDEAMOUNT", SqlDbType.Decimal, Convert.ToDouble(overrideProdAmount)));
}
spParams.Add(Param.CreateParam("ENTEREDBY", SqlDbType.VarChar, Security.GetCurrentUserId));
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("COMMISSIONS_UPSERTPRODUCTIONOVERRIDE", spParams));
}
return true;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
return false;
}
}
示例13: SaveReportData
public static void SaveReportData(int companyId, int reportMonth, int reportYear, string reportData)
{
try
{
using (IO io = new IO(WebCommon.KPIConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("KPI_REPORT_UPSERTREPORTDATA",
Param.CreateParam("KPIREPORTMONTH", SqlDbType.Int, reportMonth),
Param.CreateParam("KPIREPORTYEAR", SqlDbType.Int, reportYear),
Param.CreateParam("KPIREPORTCREATEDBY", SqlDbType.VarChar, Security.GetCurrentUserId),
Param.CreateParam("KPIREPORTDATA", SqlDbType.VarChar, reportData)));
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to save the report Data.");
}
}
示例14: DeleteHistoryItem
public static bool DeleteHistoryItem(Hashtable values)
{
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("COMMISSIONS_DeleteContractDetailHistoryItem",
Param.CreateParam("COMMISSIONID", SqlDbType.Int, values["COMMISSIONID"]),
Param.CreateParam("ENTEREDBY", SqlDbType.VarChar, values["ENTEREDBY"])));
}
return true;
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to delete the history item.");
}
}
示例15: SaveContractData
public static bool SaveContractData(Hashtable values)
{
List<System.Data.SqlClient.SqlParameter> spParams = new List<SqlParameter>();
spParams.Add(Param.CreateParam("CONTRACTNUMBER", SqlDbType.Int, Convert.ToInt32(values["CONTRACTNUMBER"])));
spParams.Add(Param.CreateParam("EFFECTIVEDATE", SqlDbType.DateTime, GetNullableField(values["EFFECTIVEDATE"])));
spParams.Add(Param.CreateParam("PACKAGEID", SqlDbType.Int, GetNullableField(values["PACKAGE"])));
spParams.Add(Param.CreateParam("AE1ID", SqlDbType.VarChar, GetNullableField(values["AE1ID"])));
spParams.Add(Param.CreateParam("AE1REVPERCENTAGE", SqlDbType.Decimal, GetNullableField(values["AE1REV"])));
spParams.Add(Param.CreateParam("AE1COMPERCENTAGE", SqlDbType.Decimal, GetNullableField(values["AE1COM"])));
spParams.Add(Param.CreateParam("AE1POINTS", SqlDbType.Decimal, GetNullableField(values["AE1FIXED"])));
spParams.Add(Param.CreateParam("AE2ID", SqlDbType.VarChar, GetNullableField(values["AE2ID"])));
spParams.Add(Param.CreateParam("AE2REVPERCENTAGE", SqlDbType.Decimal, GetNullableField(values["AE2REV"])));
spParams.Add(Param.CreateParam("AE2COMPERCENTAGE", SqlDbType.Decimal, GetNullableField(values["AE2COM"])));
spParams.Add(Param.CreateParam("AE2POINTS", SqlDbType.Decimal, GetNullableField(values["AE2FIXED"])));
spParams.Add(Param.CreateParam("AE3ID", SqlDbType.VarChar, GetNullableField(values["AE3ID"])));
spParams.Add(Param.CreateParam("AE3REVPERCENTAGE", SqlDbType.Decimal, GetNullableField(values["AE3REV"])));
spParams.Add(Param.CreateParam("AE3COMPERCENTAGE", SqlDbType.Decimal, GetNullableField(values["AE3COM"])));
spParams.Add(Param.CreateParam("AE3POINTS", SqlDbType.Decimal, GetNullableField(values["AE3FIXED"])));
spParams.Add(Param.CreateParam("USEPOINTS", SqlDbType.VarChar, GetNullableField(values["USEPOINTS"])));
spParams.Add(Param.CreateParam("APPROVEDBYID", SqlDbType.VarChar, GetNullableField(values["APPROVEDBY"])));
spParams.Add(Param.CreateParam("APPROVEDBYDATE", SqlDbType.DateTime, GetNullableField(values["APPROVEDBYDATE"])));
spParams.Add(Param.CreateParam("ENTEREDBY", SqlDbType.VarChar, Security.GetCurrentUserId));
spParams.Add(Param.CreateParam("COMPANYID", SqlDbType.Int, Convert.ToInt32(values["COMPANYID"])));
try
{
using (IO io = new IO(WebCommon.ConnectionString))
{
if (Convert.ToInt32(values["COMMISSIONID"]) != -1 && (Convert.ToInt32(values["ISUPDATING"]) != 0))
{
spParams.Add(Param.CreateParam("COMMISSIONID", SqlDbType.Int, Convert.ToInt32(values["COMMISSIONID"])));
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("COMMISSIONS_UpdateCommissionAllocation", spParams));
}
else
{
io.ExecuteActionQuery(IO.CreateCommandFromStoredProc("COMMISSIONS_AddCommissionAllocation", spParams));
}
return true;
}
}
catch (Exception ex)
{
WebCommon.LogExceptionInfo(ex);
throw new Exception("An error occurred while trying to save the contract data.");
}
}