C# IO.ExecuteActionQuery方法代码示例

 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;
 }

 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;
     }
 }

 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;
 }

 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;
 }

 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;
 }

 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;
     }
 }

 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.");
     }
 }

 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)));
     }
 }

 /// <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));
     }
 }

 /// <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)));
     }
 }

 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).");
     }
 }

 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;
     }
 }

 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.");
     }
 }

 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.");
     }
 }

 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.");
     }
 }