/// <summary> /// Підключення до Касового Апарату /// Number //Номер аппарата. //Тип: строка //Умолчание: "1" //Позволяет указать кассовый аппарат для работы в виде: //Логический номер (в виде "число") //Комбинация номер порта, сетевой номер кассы (в виде "порт;сетевойномер") //Комбинация номер порта, сетевой номер кассы, скорость обмена (в виде "порт;сетевойномер;скорость") //Если в момент установки значения свойства сеанс связи с аппаратом был установлен, он закрывается. //При использовании логического номера он должен совпадать с логическим номером, запрограммированным в кассе в параметрах связи с компьютером. //Если используется сетевой номер, то он должен совпадать с сетевым номером, запрограммированным в кассе в параметрах связи с компьютером. //Возможные значения скорости: 9600, 19200, 38400, 57600, 115200. Однако некоторые модели касс не поддерживают скорости 57600 и 115200. Указанная скорость должна совпадать со скоростью обмена с компьютером, запрограммированной в кассе. //Если касса подключена к компьютеру и в её настройках разрешён обмен с компьютером, то с помощью утилиты comtest.exe вы можете выяснить, на какой скорости работает касса, какой протокол она использует для обмена (упрощённый или полный) и какой имеет сетевой номер. Эти данные помогут вам правильно сформировать строку для свойства Number. Иконка comtest.exe устанавливается на рабочем столе Windows большинством инсталляторов, которые устанавливают драйверы EQL.. /// </summary> public void Connect(string Port, string LogicNumber, string UserId, string Password) { connection = new Connection(); string strCnn = "Provider=EQL OLE DB Provider;"; strCnn = strCnn + "Data Source='" + Port + ";" + LogicNumber + "'"; //strCnn = strCnn + "Data Source=’" + Port + ";" + LogicNumber + "’"; strCnn = strCnn + ";User Id=" + UserId + ";Password="******";"; strCnn = strCnn + "Extended Properties = \"Protocol=" + "L2Com.HcComSessionCreator\""; connection.Open(strCnn); srv = new Recordset(); //відкриття службової таблиці srv.Open("EQL_service", connection, CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockOptimistic, 512); //отримання процедурного інтерфейсу proc = srv.Fields[1].Value; fp = (IHcFReg)proc; fpext = (IHcFRegEx)proc; report = (IHcReport)proc; display = (IHcDisplay)proc; fiscPrinter = (IHcFiscPrnt)proc; fiscPrinterLastInfo = (IHmLastInfo)proc; fiscPrinterSound = (IHcSound)proc; this.OutTone(1000, 100); }
public object[] db_access(string strSQL) { ADODB.Connection objCon; ADODB.Recordset objRec; object[,] dataRows; object[] dataSuite; string strCon; objCon = new ADODB.Connection(); objRec = new ADODB.Recordset(); //establish the connection string and open the database connection strCon = "driver={MySQL ODBC 5.1 Driver};server=107.22.232.228;uid=qa_people;pwd=thehandcontrols;" + "database=functional_test_data;option=3"; objCon.Open(strCon); //execute the SQL and return the recrodset of results objRec = objCon.Execute(strSQL, out missing, 0); //populate a two dinmensional object array with the results dataRows = objRec.GetRows(); //get a onedimensional array that can be placed into the Test Suite dropdown dataSuite = thinArray(dataRows); //close the recordset objRec.Close(); //close the database connection objCon.Close(); return(dataSuite); }
private void AssemblyCopyToModel(IGTPolygonGeometry oGeometry) { int ownerID = 0; int lRecords; double dGeoOrientation = 0.0; try { frmAssmbly = new frmAssembly(); frmAssmbly.Application = m_GTApplication; frmAssmbly.FeatureFNO = m_ActiveGraphicComponent.FNO; frmAssmbly.DetailIdentifier = m_ActiveMapWindow.DetailID; frmAssmbly.ShowDialog(); if (frmAssmbly.FeatureIdentifier != 0) { ownerID = GetOwnerIdentifier(); GetAssemblyPointsAndOrientation(oGeometry, ref dGeoOrientation); ADODB.Recordset oRS = m_GTApplication.DataContext.Execute("{call OC_EXECUTE_DEEPCOPY(" + m_ActiveGraphicComponent.FNO.ToString() + " ," + frmAssmbly.FeatureIdentifier.ToString() + ", " + m_ActiveGraphicComponent.FNO.ToString() + ", " + m_ActiveGraphicComponent.CNO.ToString() + ", " + m_ActiveGraphicComponent.FID.ToString() + ", " + ownerID.ToString() + ", " + dGeoOrientation + ", " + m_ActiveMapWindow.DetailID + ")}", out lRecords, 1, new object[1]); } } catch (Exception ex) { throw; } }
} // end function; public int testresetwid(int wid) { ADODB.Recordset recset1 = null; int retval; if (wid == 0) { retval = -1; return(retval); } DbUse.open_ado_rec(globaldb, ref recset1, "Select tblwhatif.* from tblwhatif where wid = " + wid + ";"); if (!recset1.EOF) { retval = -1; } else { retval = 0; glngwid = 0; // !!! reset to 0 basecase !! saveWid(); saveRecalcNeeded(0, -1); model_modified = -1; saveModel_modified(); } DbUse.CloseAdoRec(recset1); recset1 = null; return(retval); }
} // end function; public long Get_whatif_wid(string whatifname) { //on error GoTo Err_Get_whatif_name; ADODB.Recordset recset1 = null; long retval; if (whatifname == "Base Case") { return(0); } else { DbUse.open_ado_rec(globaldb, ref recset1, "Select tblwhatif.* from tblwhatif where name = " + whatifname + ";"); if (recset1.EOF) { retval = -1; } else { retval = (long)recset1.Fields["wid"].Value; } DbUse.CloseAdoRec(recset1); recset1 = null; }; return(retval); //exit Function; } // end function;
public static UsuariosBO UpdateUsuario(UsuariosBO Usuario, ADODB.Connection cn) { var RsUsuarios = new ADODB.Recordset(); var LibORGM = new SQL(); var Serializer = new SerializerFO(); try { RsUsuarios.Open(String.Format("SELECT * FROM dbo.Usuarios WHERE Usuario = '{0}'", Usuario.Usuario), cn, CursorTypeEnum.adOpenDynamic, LockTypeEnum.adLockOptimistic); if (RsUsuarios.EOF) { RsUsuarios.AddNew(); RsUsuarios.Fields["Usuario"].Value = Usuario.Usuario; RsUsuarios.Fields["SenhaAcesso"].Value = Usuario.SenhaAcesso; RsUsuarios.Fields["TokenAcesso"].Value = CriptografiaFO.EncriptarMD5(Usuario.TokenAcesso); } RsUsuarios.Fields["Inativo"].Value = Usuario.Inativo; RsUsuarios.Update(); RsUsuarios.Close(); Usuario = UsuariosDA.GetUsuarios(Usuario.Usuario, cn); } catch (Exception) { throw; } return(Usuario); }
} // end sub; float availtime() { //on error GoTo err_availtime; ADODB.Recordset reccust = null; float X; DbUse.open_ado_rec(globaldb, ref reccust, "tblgeneral"); X = ((float)reccust.Fields["RTU1b"].Value) * ((float)reccust.Fields["RTU1c"].Value); if ((X <= 0)) { X = 1; } ; //exit_availtime: DbUse.CloseAdoRec(reccust); reccust = null; return(X); //exit Function; //err_availtime: // msgbox(ErrorToString(), 0, appl_name); // resume exit_availtime; } // end function;
private void cmbTableUn_SelectedIndexChanged(object sender, EventArgs e) { grdData.Rows.Clear(); grdData.Columns.Clear(); mycon = new ADODB.Connection(); mycon.Open("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " + clsDataStorage.db.Name); recordSet = new ADODB.Recordset(); recordSet.Open("SELECT * FROM " + cmbTableUn.Text, mycon, CursorTypeEnum.adOpenStatic); //clsDataStorage.db.OpenTable(cmbTableUn.Text); foreach (ADODB.Field field in recordSet.Fields) { grdData.Columns.Add("clm" + field.Name, field.Name); } while (!recordSet.EOF) { grdData.Rows.Add(); for (int i = 0; i < recordSet.Fields.Count; i++) { grdData.Rows[r].Cells[i].Value = recordSet.Fields[i].Value; } r++; recordSet.MoveNext(); } r = 0; recordSet.Close(); }
//RETORNA TABELA NO FORMATO DE RECORDSET public ADODB.Recordset ReturnRs(string p_strSql) { ADODB.Recordset objRS = new ADODB.Recordset(); try { if (this._AdodbConn == null) { SetConn(); this._AdodbConn = new Connection(); GenericCLX.CS.Util objUtil = new GenericCLX.CS.Util(); //objUtil.GetConfig(""); this._AdodbConn.Open(objUtil.ConnectionStringXML(), this._User, this._Password, 0); } objRS.CursorLocation = (ADODB.CursorLocationEnum) 3; objRS.Open(p_strSql, this._AdodbConn, (ADODB.CursorTypeEnum) 3, (ADODB.LockTypeEnum) 3, 1); objRS.ActiveConnection = null; } catch (Exception e) { if (TreatedError(e.Message)) { this.ReturnRs(p_strSql); } } return(objRS); }
/// <summary> /// Execute Procudure to Purge Expired Archived Landbase /// </summary> private void DetectOverlapping(int g3eFno, bool selfOverlap) { ADODB.Recordset rs = null; string sqlStmt = "Begin LBM_UTL.DetectOverlappingPolygons({0},{1}); end;"; try { gtApp.BeginWaitCursor(); sqlStmt = string.Format(sqlStmt, g3eFno, selfOverlap); gtApp.SetStatusBarText(GTStatusPanelConstants.gtaspcMessage, "Detecting Overlapping Boundarys...."); gtTransactionManager.Begin("Detect Overlapping Boundarys"); rs = Execute(sqlStmt); gtTransactionManager.Commit(); MessageBox.Show("Detecting Overlapping Boundarys Analysis is Completed", msgBoxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { gtTransactionManager.Rollback(); throw ex; } finally { rs = null; gtTransactionManager.RefreshDatabaseChanges(); gtApp.RefreshWindows(); gtApp.EndWaitCursor(); } }
private void button1_Click(object sender, EventArgs e) { try { U8RefService.IServiceClass obj = new U8RefService.IServiceClass(); obj.RefID = "Inventory_AA"; obj.Mode = U8RefService.RefModes.modeRefing; //obj.FilterSQL = " bbomsub =1"; obj.FillText = txtcinvcode.Text; obj.Web = false; obj.MetaXML = "<Ref><RefSet bMultiSel='0' /></Ref>"; obj.RememberLastRst = false; ADODB.Recordset retRstGrid = null, retRstClass = null; string sErrMsg = ""; obj.GetPortalHwnd((int)this.Handle); Object objLogin = canshu.u8Login; if (obj.ShowRefSecond(ref objLogin, ref retRstClass, ref retRstGrid, ref sErrMsg) == false) { MessageBox.Show(sErrMsg); } else { if (retRstGrid != null) { this.txtcinvcode.Text = DbHelper.GetDbString(retRstGrid.Fields["cinvcode"].Value); } } } catch (Exception ex) { MessageBox.Show("参照失败,原因:" + ex.Message); } }
// An error has occured in validation. Null the ESI Location value. private void ClearESILocation(ref ADODB.Recordset componentRS) { try { // Need to set a flag to let aecEditNotPosted attribute edit control // know that ESI Location is being set to null and skip processing. // Attribute edit control is firing before the attribute is set to null, // so without the flag what happens is the Premise attributes are // set to read-only by the attribute edit control and the ESI Location // is then set to null by this FI, thus locking the attributes including // the null ESI Location. AddProperty(M_PROP_SKIP_AECEDITIFNOTPOSTED, "TRUE"); // Reset recordset position before updating ResetRecordPosition(ref componentRS); componentRS.Fields[FIELD_PREMISE_ESI_LOCATION].Value = null; m_Application.Properties.Remove(M_PROP_SKIP_AECEDITIFNOTPOSTED); } catch (Exception ex) { if (m_InteractiveMode) { MessageBox.Show("Error in fiESILocationUpdate:ClearESILocation - " + ex.Message, "G/Technology", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
/// <summary> /// Execute Procudure to Purge Expired Archived Landbase /// </summary> private void DetectOverlapping(int g3eFno, bool selfOverlap) { ADODB.Recordset rs = null; string sqlStmt = "Begin LBM_UTL.DectectOverlappingPolygons({0},{1}); end;"; string mergeStatus = string.Empty; try { sqlStmt = string.Format(sqlStmt, g3eFno, selfOverlap); rs = Execute(sqlStmt); // gtTransactionManager.Commit(); } catch (Exception ex) { // gtTransactionManager.Rollback(); throw ex; } finally { rs = null; // gtTransactionManager.RefreshDatabaseChanges(); gtApp.RefreshWindows(); // CleanUp(); } MessageBox.Show("Detecting Overlapping Analysis is Completed"); }
public void SetAuditLogin(string appVer) { string pcName = Environment.MachineName.Substring(0, 8); string pcOSVer = Environment.OSVersion.ToString(); string pcPlatForm = Environment.OSVersion.Platform.ToString(); int osMajor = Environment.OSVersion.Version.Major; int osMinor = Environment.OSVersion.Version.Minor; bool bitBool = Environment.Is64BitOperatingSystem; int bit = -1; string appVersion = appVer; if (bitBool) { bit = 64; } else { bit = 32; } long seqNum = GetSeq("annotator.GPJ_AUDIT_SEQ"); int month = DateTime.Now.Month; int day = DateTime.Now.Day; int year = DateTime.Now.Year; conn.Open(); string sqlCommand = $"INSERT INTO GPJ_APP_AUDIT VALUES ({seqNum}, '{pcName}', SYSDATE, 'GPJ', '{pcName}', '{pcOSVer}', '{pcPlatForm}', {osMajor}, {osMinor}, " + $"{bit.ToString()}, 'TWITTER_POSTER', '{appVersion}', 'TWITPSTR', SYSDATE, '{TimeZone.CurrentTimeZone.StandardName}');"; ADODB.Recordset rst = new ADODB.Recordset(); object rowsAffected; rst = conn.Execute(sqlCommand, out rowsAffected); conn.Close(); }
public static bool session_valid(string sdate) { try { ADODB.Connection ADOconn = new ADODB.Connection(); ADODB.Recordset tmp = new ADODB.Recordset(); SqlConnectionStringBuilder decoder = new SqlConnectionStringBuilder(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ConnectionString); ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0); ADODB.Recordset rec = new ADODB.Recordset(); string sql = "SELECT FINANCE_ID FROM FINANCE_SESSION WHERE FINANCE_STATUS=1 AND '" + sdate + "' between finance_start_date and finance_end_date"; Recordset TMP = new Recordset(); TMP.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (TMP.RecordCount == 0) { return(false); } else { return(true); } } catch (Exception ex) { return(false); } }
/// <summary> /// Method to get the Component Number of the Unit Component whose standard/static attributes will be populated /// </summary> /// <param name="sCUCode"></param> /// <param name="iCUCID"></param> /// <param name="m_iCompUnitCNO"></param> /// <param name="m_oDataContext"></param> /// <returns></returns> private int GetUnitComponentCNO(string sCUCode, int iCUCID, int m_iCompUnitCNO, IGTDataContext m_oDataContext) { int sUnitComponentCNO = 0; ADODB.Recordset oRS = null; string sSQL = string.Empty; IGTKeyObject oKeyObject; ///'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' //Query for the ANOs and their values from the m_sCUStaticAttributeTable table. //For each record returned in that query, set the ANO value. ///'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' oKeyObject = m_oApp.DataContext.OpenFeature(Convert.ToInt16(m_oComponents[m_componentName].Recordset.Fields["G3e_FNO"].Value), Convert.ToInt32(m_oComponents[m_componentName].Recordset.Fields["G3e_FID"].Value)); sSQL = @" select distinct a.g3e_cno from CULIB_ATTRIBUTE s,G3E_ATTRIBUTEINFO_OPTABLE a, CULIB_UNITATTRIBUTE b where s.g3e_fno=? and b.cu_id=? and a.g3e_ano=s.g3e_ano and s.category_C = b.category_c and s.ATTRIBUTE_ID = b.ATTRIBUTE_ID order by a.g3e_cno"; oRS = m_oDataContext.OpenRecordset(sSQL, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly, (int)ADODB.CommandTypeEnum.adCmdText, oKeyObject.FNO, sCUCode); if (oRS != null && oRS.RecordCount > 0) { sUnitComponentCNO = Convert.ToInt32(oRS.Fields["g3e_cno"].Value); } return(sUnitComponentCNO); }
/// <summary> /// Execute Procudure to Purge Expired Archived Landbase /// </summary> private void PurgeLandbase() { ADODB.Recordset rs = null; string sqlStmt = "Begin LBM_UTL.PurgeExpiredArchivedLandbase; end;"; string mergeStatus = string.Empty; try { gtTransactionManager.Begin("Purge Expired Landbase"); gtApp.BeginWaitCursor(); rs = Execute(sqlStmt); gtTransactionManager.Commit(); } catch (Exception ex) { gtTransactionManager.Rollback(); throw ex; } finally { rs = null; gtTransactionManager.RefreshDatabaseChanges(); gtApp.RefreshWindows(); gtApp.EndWaitCursor(); } }
/// <summary> /// Method to convert storage coordinates to Latitude and Longitude /// </summary> /// <param name="dXoord">X location</param> /// <param name="dYoord">Y location</param> /// <param name="dZoord">Z location (0)</param> private void ConvertToLatitudeAndLongitude(ref double dXoord, ref double dYoord, ref double dZoord) { try { Intergraph.CoordSystems.Interop.CoordSystemClass coords = new CoordSystemClass(); int outrec = 0; ADODB.Recordset rs = DataContext.Execute("select c.* from g3e_dataconnection_optable d , gcoordsystemtable c where " + " d.g3e_username ='******' and d.g3e_csname=c.name", out outrec, (int)ADODB.CommandTypeEnum.adCmdText, new object[0]); rs.MoveFirst(); object[] rowformat = new object[rs.Fields.Count]; for (int ifld = 0; ifld < rs.Fields.Count; ifld++) { rowformat[ifld] = rs.Fields[ifld].Value; } coords.LoadFromGCoordSystemTableRowFormat(rowformat); coords.TransformPoint(Intergraph.CoordSystems.Interop.CSPointConstants.cspUOR, (int)Intergraph.CoordSystems.CSTransformLinkConstants.cstlDatumTransformation, Intergraph.CoordSystems.Interop.CSPointConstants.cspLLO, (int)Intergraph.CoordSystems.CSTransformLinkConstants.cstlDatumTransformation, ref dXoord, ref dYoord, ref dZoord); dXoord = dXoord * 180 / (4 * Math.Atan(1)); dYoord = dYoord * 180 / (4 * Math.Atan(1)); } catch (Exception) { throw; } }
public void Execute() { short fNo = 0; string attributeValue; try { IGTComponent component = Components[ComponentName]; ADODB.Recordset componentRs = component.Recordset; if (componentRs.RecordCount > 0) { componentRs.MoveFirst(); if (componentRs.Fields["G3E_FNO"].Value == null) { return; } fNo = Convert.ToInt16(componentRs.Fields["G3E_FNO"].Value); CheckForActiveFnoInValueMap(fNo, out attributeValue); if (!String.IsNullOrEmpty(attributeValue)) { componentRs.Fields["ORIENTATION_C"].Value = attributeValue; } } } catch (Exception ex) { MessageBox.Show("Error during Set Attributes By FeatureClass execution. " + ex.Message, "G/Technology"); } }
} // end function; public string Get_whatif_comment(int wid) { //on error GoTo Err_Get_whatif_name; ADODB.Recordset recset1 = null; string retval; if (wid == 0) { retval = "Base Case"; } else { DbUse.open_ado_rec(globaldb, ref recset1, "tblwhatif"); recset1.Filter = "[wid] =" + wid; retval = (string)recset1.Fields["Comm"].Value; DbUse.CloseAdoRec(recset1); recset1 = null; }; // return; //exit _Get_whatif_name: return(retval); //exit Function; //Err_Get_whatif_name: // msgbox(ErrorToString(), 0, appl_name); //RESUME NEXT } // end function;
/// <summary> /// Mcheck Selected features are Valid for Merge /// </summary> /// <param name="g3eFno_trg"></param> /// <param name="g3eFid_trg"></param> /// <param name="g3eFno_src"></param> /// <param name="g3eFid_src"></param> /// <returns></returns> private bool CheckFeaturesAreValidForMerge(int g3eFno_trg, int g3eFid_trg, int g3eFno_src, int g3eFid_src) { ADODB.Recordset rs = null; bool flag = false; string sqlStmt = "SELECT LBM_UTL.FeaturesAreValidForMerge({0},{1},{2},{3}) FROM DUAL"; string mergeStatus = string.Empty; try { rs = Execute(string.Format(sqlStmt, g3eFno_trg, g3eFid_trg, g3eFno_src, g3eFid_src)); if (rs != null) { rs.MoveFirst(); mergeStatus = Convert.ToString(rs.Fields[0].Value.ToString()); if (mergeStatus == "TRUE") { flag = true; } else { flag = false; } } if (!flag) { MessageBox.Show(mergeStatus, msgBoxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("Error " + ex.Message, msgBoxCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); } return(flag); }
public string Get_whatif_name(int wid) { //on error GoTo Err_Get_whatif_name; ADODB.Recordset recset1 = null; string retval; if (wid == 0) { retval = "Basecase"; } else { DbUse.open_ado_rec(globaldb, ref recset1, "Select tblwhatif.* from tblwhatif where wid = " + wid + ";"); if (recset1.EOF) { retval = ""; } else { retval = (string)recset1.Fields["Name"].Value; } DbUse.CloseAdoRec(recset1); recset1 = null; }; return(retval); //exit Function; //Err_Get_whatif_name: // msgbox(ErrorToString(), 0, appl_name); //RESUME NEXT } // end function;
/// <summary> /// /// </summary> /// <param name="queryString"></param> /// <returns></returns> public List <double> QueryDataReturnListDouble(string queryString) { if (con == null || con.State != 1) { this.OpenConnection(); } if (con.State != 1) { return(null); } //open recordset rs = new ADODB.Recordset(); rs.Open(queryString, con); //get data object[,] dataRows = (object[, ])rs.GetRows(); List <double> ts = new List <double>(); for (int i = 0; i < dataRows.GetLength(1); i++) { object[] p = Enumerable.Range(0, dataRows.GetLength(0)).Select(x => dataRows[x, i]).ToArray(); ts.Add((double)p[0]); } //close recordset rs.Close(); rs = null; //return data return(ts); }
private void DisplayResults() { //SS:01/03/2018:2018-R1:ABSEXCH-19796: When Running the ExchDVT.exe, SQL Admin Passwords are visible in dump file. ADODB.Connection conn = new ADODB.Connection(); ADODB.Command cmd = new ADODB.Command(); cmd.CommandText = "SELECT RCount = COUNT(*) " + "FROM [common].[SQLDataValidation] " + "WHERE UPPER(Severity) = 'HIGH' " + "AND SchemaName = '" + CompanyCode + "'"; cmd.CommandTimeout = 10000; if (conn.State == 0) { if (connPassword.Trim() == "") { conn.Open(); } else { conn.Open(ExchequerCommonSQLConnection, "", connPassword.Trim(), (int)ADODB.ConnectModeEnum.adModeUnknown); } } conn.CursorLocation = ADODB.CursorLocationEnum.adUseClient; DataTable dataTable = new DataTable(); cmd.CommandType = ADODB.CommandTypeEnum.adCmdText; cmd.ActiveConnection = conn; ADODB.Recordset recordSet = null; object objRecAff; try { recordSet = (ADODB.Recordset)cmd.Execute(out objRecAff, Type.Missing, (int)ADODB.CommandTypeEnum.adCmdText); } catch { throw; } for (int i = 0; i < recordSet.RecordCount; i++) { if (Convert.ToInt32(recordSet.Fields["RCount"].Value) == 0) { // Posting Enabled PostingEnabledDisabled(true, false); } else { // Posting Disabled PostingEnabledDisabled(false, false); } } File.Delete(fileString); Application.Exit(); }
/// <summary> /// Execute SQL statement /// </summary> /// <param name="sqlStmt"></param> /// <returns></returns> public static Recordset Execute(string sqlStmt) { int recordsAffected; ADODB.Recordset rs = null; rs = _gtDataContext.Execute(sqlStmt, out recordsAffected, (int)ADODB.CommandTypeEnum.adCmdText); return(rs); }
/// <summary> /// Execute SQL statement /// </summary> /// <param name="sqlStmt"></param> /// <returns></returns> private Recordset Execute(string sqlStmt) { int recordsAffected; ADODB.Recordset rs = null; rs = gtApp.DataContext.Execute(sqlStmt, out recordsAffected, (int)ADODB.CommandTypeEnum.adCmdText); return(rs); }
/// <summary> /// Execute SQL Statement /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sqlStmt"></param> /// <returns></returns> public static List <T> Execute <T>(string sqlStmt) { int recordsAffected; ADODB.Recordset rs = null; rs = _gtDataContext.Execute(sqlStmt, out recordsAffected, (int)ADODB.CommandTypeEnum.adCmdText); return(ConvertRSToEntity <T>(rs)); }
private void save_form() { try { //ADOconn.BeginTrans(); ADODB.Recordset cus = new ADODB.Recordset(); //ADOconn.BeginTrans(); if (cmbgrp.Text == "") { MessageBox.Show("Invalid User Group", "Invalid Entry"); return; } dgv1.EndEdit(); ADODB.Connection ADOconn = new ADODB.Connection(); ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0); for (int i = 1; i < dgv1.RowCount; i++) { if (dgv1["id", i].Value == null) { continue; } cus = new ADODB.Recordset(); sql = "SELECT * FROM userpriv where GROUP_NAME ='" + cmbgrp.Text + "' and form_id=" + dgv1["id", i].Value; cus.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (cus.RecordCount == 0) { cus.AddNew(); } cus.Fields["GROUP_NAME"].Value = cmbgrp.Text; cus.Fields["form_id"].Value = dgv1["id", i].Value; cus.Fields["ins"].Value = dgv1["ins", i].Value; cus.Fields["upd"].Value = dgv1["upd", i].Value; //cus.Fields["qry"].Value = dgv1["qry",i].Value; cus.Fields["del"].Value = dgv1["del", i].Value; cus.Fields["dsp"].Value = dgv1["dsp", i].Value; cus.Fields["Menu_Name"].Value = dgv1["Menu_Name", i].Value; cus.Update(); } string grp = cmbgrp.Text; sql = "SELECT distinct group_name FROM UserPriv "; SqlDataAdapter adagrp = new SqlDataAdapter(sql, Conn); ///ada.TableMappings.Add("Table", "Leaders"); DataSet grpds = new DataSet(); adagrp.Fill(grpds, "UserPriv"); cmbgrp.DisplayMember = "group_name"; cmbgrp.DataSource = grpds.Tables[0]; cmbgrp.Text = grp; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ADODB.Recordset GetPreferredCU(string p_CategoryCode) { ADODB.Recordset rs = null; string sql = string.Empty; sql = "select CU_CODE from CUSELECT_USERPREF where PREF_UID = ? and CU_CATEGORY_CODE =?"; rs = m_oApp.DataContext.OpenRecordset(sql, CursorTypeEnum.adOpenDynamic, LockTypeEnum.adLockOptimistic, (int)ADODB.CommandTypeEnum.adCmdText, m_oApp.DataContext.DatabaseUserName, p_CategoryCode); return(rs); }
public void Return_SpreadSheet(string strSQL, string strPath) { ADODB.Connection adoConnection = new ADODB.Connection(); ADODB.Recordset objRecordset = ReturnRecordset(strSQL, ref adoConnection); if (objRecordset.RecordCount > 0) { CreateSpreadSheet(objRecordset, strPath); } }
public static DataTable GetDataTable(string strFileName) { ADODB.Connection oConn = new ADODB.Connection(); oConn.Open("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + System.IO.Path.GetDirectoryName(strFileName) + "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\";", "", "", 0); string strQuery = "SELECT * FROM [" + System.IO.Path.GetFileName(strFileName) + "]"; ADODB.Recordset rs = new ADODB.Recordset(); System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(); DataTable dt = new DataTable(); rs.Open(strQuery, "Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + System.IO.Path.GetDirectoryName(strFileName) + "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\";", ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockReadOnly, 1); adapter.Fill(dt, rs); return dt; }
private void button1_Click(object sender, System.EventArgs e) { short number = short.Parse(this.textBox1.Text); DataSet ds = new DataSet("FromRecordset"); OleDbDataAdapter da = new OleDbDataAdapter(); DataAccess.ProductsClass prod = new DataAccess.ProductsClass(); Recordset rs = new ADODB.Recordset(); rs = prod.Select_(number); da.Fill(ds, rs, "Products"); dataGrid1.SetDataBinding(ds,"Products"); }
private object[] db_access(string strSQL, ref int fndExcep) { ADODB.Connection objCon; ADODB.Recordset objRec; object[,] dataRows; object[] dataSuite; string strCon; string tmpString; dataSuite = null; objCon = new ADODB.Connection(); objRec = new ADODB.Recordset(); try { //establish the connection string and open the database connection strCon = "driver={MySQL ODBC 5.1 Driver};server=107.22.232.228;uid=qa_people;pwd=thehandcontrols;" + "database=functional_test_data;option=3"; objCon.Open(strCon); //execute the SQL and return the recrodset of results objRec = objCon.Execute(strSQL, out missing, 0); //populate a two dinmensional object array with the results dataRows = objRec.GetRows(); //get a one dimensional array that can be placed into the Test Suite dropdown dataSuite = thinArray(dataRows); //close the recordset objRec.Close(); //close the database connection objCon.Close(); } catch (Exception e) { tmpString = e.Message; //set the variable to ternibate the script fndExcep = -1; } return dataSuite; }
static ADODB.Recordset ConvertToRecordset(DataTable inTable) { ADODB.Recordset result = new ADODB.Recordset(); result.CursorLocation = ADODB.CursorLocationEnum.adUseClient; ADODB.Fields resultFields = result.Fields; System.Data.DataColumnCollection inColumns = inTable.Columns; foreach (DataColumn inColumn in inColumns) { resultFields.Append(inColumn.ColumnName , TranslateType(inColumn.DataType) , inColumn.MaxLength , inColumn.AllowDBNull ? ADODB.FieldAttributeEnum.adFldIsNullable : ADODB.FieldAttributeEnum.adFldUnspecified , null); } result.Open(System.Reflection.Missing.Value , System.Reflection.Missing.Value , ADODB.CursorTypeEnum.adOpenStatic , ADODB.LockTypeEnum.adLockOptimistic, 0); foreach (DataRow dr in inTable.Rows) { result.AddNew(System.Reflection.Missing.Value, System.Reflection.Missing.Value); for (int columnIndex = 0; columnIndex < inColumns.Count; columnIndex++) { resultFields[columnIndex].Value = dr[columnIndex]; } } return result; }
static public ADODB.Recordset GetResultsFromQueryToRecordset(string connectionString, string query) { //ConvertToRecordset(GetResultsFromQueryToDataTable(connectionString, query); ADODB.Recordset rstReturn = new ADODB.Recordset(); using (SqlConnection conSQL = new SqlConnection(connectionString)) { using (SqlCommand cmdSQL = new SqlCommand(query, conSQL)) { try { conSQL.Open(); SqlDataReader dr = cmdSQL.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(dr); rstReturn = ConvertToRecordset(dt); } catch (SqlException ex) { Log.logFileTRAP(app, "GetResultsFromQueryToRecordset()", ex.ToString()); rstReturn = null; } catch (Exception ex) { Log.logFileTRAP(app, "GetResultsFromQueryToRecordset()", ex.ToString()); rstReturn = null; } finally { conSQL.Close(); } } } return rstReturn; }
public object[] db_access(string strSQL) { ADODB.Connection objCon; ADODB.Recordset objRec; object[,] dataRows; object[] dataSuite; string strCon; objCon = new ADODB.Connection(); objRec = new ADODB.Recordset(); //establish the connection string and open the database connection strCon = "driver={MySQL ODBC 5.1 Driver};server=107.22.232.228;uid=qa_people;pwd=thehandcontrols;" + "database=functional_test_data;option=3"; objCon.Open(strCon); //execute the SQL and return the recrodset of results objRec = objCon.Execute(strSQL, out missing, 0); //populate a two dinmensional object array with the results dataRows = objRec.GetRows(); //get a onedimensional array that can be placed into the Test Suite dropdown dataSuite = thinArray(dataRows); //close the recordset objRec.Close(); //close the database connection objCon.Close(); return dataSuite; }