private String ExceuteCreateSubscriptionQuery() { QueryClass lcQueryClass; lcQueryClass = new QueryClass(QueryClass.QueryType.SPRCreateSubscription); lcQueryClass.ReplaceDictionaryPlaceHolder(clAuthenticationBlock); lcQueryClass.ReplaceDictionaryPlaceHolder(clDataBlock); return(Convert.ToString(lcQueryClass.GetResult())); }
public void ReplaceQueryPlaceHolder(QueryClass paQueryClass) { UserRow lcUserRow; if (paQueryClass != null) { if (ApplicationFrame.GetInstance().ActiveSessionController.User.IsLoggedIn) { paQueryClass.ReplacePlaceHolder("$USERID", ApplicationFrame.GetInstance().ActiveSessionController.User.ActiveRow.UserID.ToString(), true); } paQueryClass.ReplaceRowPlaceHolder(ApplicationFrame.GetInstance().ActiveSubscription.ActiveRow.Row); paQueryClass.ReplaceRowPlaceHolder(ApplicationFrame.GetInstance().ActiveEservice.ActiveRow.Row); if ((lcUserRow = ApplicationFrame.GetInstance().ActiveSessionController.User.ActiveRow) == null) { lcUserRow = new UserRow(TableManager.GetInstance().GetNewRow(TableManager.TableType.User, true)); } paQueryClass.ReplaceRowPlaceHolder(lcUserRow.Row); paQueryClass.ReplacePlaceHolder("$ACTIVELANGUAGE", ApplicationFrame.GetInstance().ActiveSubscription.ActiveSetting.Language, true); paQueryClass.ReplaceDictionaryPlaceHolder(clFormParam, false); } }
public DataSet RunRetrieveQueryEx() { QueryClass lcQuery; if (!String.IsNullOrEmpty(ActiveRow.RetrieveQuery)) { lcQuery = new QueryClass(ActiveRow.RetrieveQuery, clConnectionMode); ReplaceQueryPlaceHolder(lcQuery); lcQuery.ReplaceDictionaryPlaceHolder(clFormParam); return(lcQuery.RunQueryEx()); } else { return(null); } }
private DataTable RetrieveData() { QueryClass lcQuery; if (!String.IsNullOrEmpty(clFormInfoRow.RetrieveQuery)) { try { lcQuery = new QueryClass(clFormInfoRow.RetrieveQuery, clConnectionMode); lcQuery.ReplaceDictionaryPlaceHolder(clFormParam); return(lcQuery.RunQuery()); } catch (Exception paException) { General.WriteExceptionLog(paException, "FORMINFOMANAGER.RETRIEVEDATA"); } } return(null); }
private bool UpdatDataRecord(Dictionary <String, String> paActiveDataList) { QueryClass lcQuery; try { lcQuery = new QueryClass(clUpdateQuery, clConnectionMode); lcQuery.ReplaceDictionaryPlaceHolder(paActiveDataList); lcQuery.ReplacePlaceHolder("$COLUMNLIST", "N\'(" + paActiveDataList.GetData(ctKEYDataColumnList) + ")\'", false); lcQuery.ReplacePlaceHolder("$VALUELIST", BuildSQLValueString(paActiveDataList, ctKEYDataColumnList, ctComma), false); lcQuery.ReplacePlaceHolder("$UPDATEDATASTRING", BuildSQLColumnValueString(paActiveDataList, ctKEYDataColumnList, ctComma), false); lcQuery.ReplacePlaceHolder("$CONDITIONSTRING", BuildSQLColumnValueString(paActiveDataList, ctKEYKeyColumnList, " And "), false); return(lcQuery.ExecuteNonQuery() > 0); } catch (Exception paException) { General.WriteExceptionLog(paException, "UPDATEDATA : " + ApplicationFrame.GetInstance().ActiveSubscription.ActiveRow.SubscriptionID); return(false); } }