public static LoaiKhachDTO LaylKhach(int MLK) { OleDbConnection link = null; LoaiKhachDTO LK = new LoaiKhachDTO(); try { link = KetNoi(); string chuoiLenh = "Select * from LoaiKhach where MaLoaiKH=@MLK"; OleDbCommand lenh = new OleDbCommand(chuoiLenh, link); OleDbParameter thamso = new OleDbParameter("@MLK", OleDbType.Integer); thamso.Value = MLK; lenh.Parameters.Add(thamso); OleDbDataReader Doc = lenh.ExecuteReader(); Doc.Read(); LK.MaLoaiKH = Doc.GetInt16(0); LK.TenLoaiKH = Doc.GetString(1); LK.HeSo = Doc.GetInt16(2); LK.Xoa = Doc.GetString(3); } catch (Exception ex) { } finally { if (link != null && link.State == System.Data.ConnectionState.Open) { link.Close(); } } return(LK); }
/// <summary> /// lit la table dans Access de pokemons /// </summary> private void LireTablePokemons() { commande.CommandText = "SELECT * FROM [pokemon]"; // sélectionne la table à lire OleDbDataReader reader = commande.ExecuteReader(); while (reader.Read()) { List <string> Tempo = new List <string>(); Tempo.Add(reader.GetInt16(0).ToString()); Tempo.Add(reader.GetString(1)); Tempo.Add(reader.GetInt16(2).ToString()); Tempo.Add(reader.GetInt16(3).ToString()); Tempo.Add(reader.GetInt16(4).ToString()); Tempo.Add(reader.GetInt16(5).ToString()); Tempo.Add(reader.GetInt16(6).ToString()); Tempo.Add(reader.GetInt16(7).ToString()); Tempo.Add(reader.GetString(8)); Tempo.Add(reader.GetString(9)); Tempo.Add(reader.GetInt16(10).ToString()); Tempo.Add(reader.GetString(11)); Tempo.Add(reader.GetInt16(12).ToString()); Tempo.Add(reader.GetInt16(13).ToString()); Pokemons.Add(Tempo); } reader.Close(); }
public static List <LoaiKhachDTO> LayDSLoaiKhach() { OleDbConnection link = null; List <LoaiKhachDTO> ds = new List <LoaiKhachDTO>(); try { link = KetNoi(); string chuoiLenh = "Select * from LoaiKhach"; OleDbCommand lenh = new OleDbCommand(chuoiLenh, link); OleDbDataReader Doc = lenh.ExecuteReader(); while (Doc.Read()) { LoaiKhachDTO lphg = new LoaiKhachDTO(); lphg.MaLoaiKH = Doc.GetInt16(0); lphg.TenLoaiKH = Doc.GetString(1); lphg.HeSo = Doc.GetInt16(2); lphg.Xoa = Doc.GetString(3); ds.Add(lphg); } } catch (Exception ex) { ds = new List <LoaiKhachDTO>(); } finally { if (link != null && link.State == System.Data.ConnectionState.Open) { link.Close(); } } return(ds); }
public List <UserDTO> loadAllRankedUsers() { //Step 1: connect to database OleDbConnection connection = Connect(); //Step 2: get information string sql = "SELECT * FROM tblUsers ORDER BY POINT DESC"; OleDbCommand command = new OleDbCommand(sql, connection); OleDbDataReader reader = command.ExecuteReader(); List <UserDTO> result = new List <UserDTO>(); while (reader.Read()) { UserDTO user = new UserDTO(); user.id = reader.GetString(0); user.name = reader.GetString(1); user.email = reader.GetString(2); user.password = reader.GetString(3); user.point = reader.GetInt16(4); user.wmatchs = reader.GetInt16(5); user.dmatchs = reader.GetInt16(6); user.lmatchs = reader.GetInt16(7); result.Add(user); } reader.Close(); // B3: Close connection connection.Close(); return(result); }
public UserDTO getUserByID(string id) { //Step 1: connect to database OleDbConnection connection = Connect(); //Step 2: get information by ID string sql = "SELECT * FROM tblUsers WHERE ID=@ID"; OleDbCommand command = new OleDbCommand(sql, connection); OleDbParameter para = command.Parameters.Add("@ID", OleDbType.VarChar); para.Value = id; OleDbDataReader reader = command.ExecuteReader(); UserDTO result = new UserDTO(); while (reader.Read()) { result.id = reader.GetString(0); result.name = reader.GetString(1); result.email = reader.GetString(2); result.password = reader.GetString(3); result.point = reader.GetInt16(4); result.wmatchs = reader.GetInt16(5); result.dmatchs = reader.GetInt16(6); result.lmatchs = reader.GetInt16(7); } reader.Close(); // B3: Close connection connection.Close(); return(result); }
public String ModeName; //中文 public static void LoadButtonModeFromDatabaseToPublicClass() { CsConst.myPublicButtonMode = new List <ButtonMode>(); string strsql = string.Format("select * from defKeyMode order by KeyModeNO"); OleDbDataReader dr = DataModule.SearchAResultSQLDB(strsql, CsConst.mstrDefaultPath); if (dr != null) { while (dr.Read()) { ButtonMode TmpButtonMode = new ButtonMode(); TmpButtonMode.ModeOrder = (Byte)(dr.GetInt16(0)); TmpButtonMode.ModeSaveID = (Byte)(dr.GetInt16(1)); if (CsConst.iLanguageId == 0) // { TmpButtonMode.ModeName = dr.GetString(3); } else { TmpButtonMode.ModeName = dr.GetString(2); } CsConst.myPublicButtonMode.Add(TmpButtonMode); } dr.Close(); } }
public List <MatchDTO> loadAllSavedMatchs() { //Step 1: connect to database OleDbConnection connection = Connect(); //Step 2: get information string sql = "SELECT * FROM tblMatchs"; OleDbCommand command = new OleDbCommand(sql, connection); OleDbDataReader reader = command.ExecuteReader(); List <MatchDTO> result = new List <MatchDTO>(); while (reader.Read()) { MatchDTO match = new MatchDTO(); match.id = reader.GetString(0); match.player1 = reader.GetString(1); match.player2 = reader.GetString(2); match.password = reader.GetString(3); match.time1 = reader.GetInt16(4); match.time2 = reader.GetInt16(5); match.type = reader.GetInt16(6); match.chessboard = reader.GetString(7); match.check = reader.GetString(8); match.turn = reader.GetInt16(9); match.ate = reader.GetString(10); result.Add(match); } reader.Close(); // B3: Close connection connection.Close(); return(result); }
public static SearchResult CopySearchResultToBO(OleDbDataReader rdr, ref int rowcount) { SearchResult result = new SearchResult { CategoryStatus = rdr.GetInt16(0), CategorySubscriptionLevel = rdr.GetInt32(1), CategoryTitle = rdr.SafeGetString(2), ForumSubject = rdr.SafeGetString(3), ForumSubscriptionLevel = rdr.GetInt32(4), ForumStatus = rdr.GetInt16(5), ForumAccessType = rdr.GetInt32(6), ForumPassword = rdr.SafeGetString(7), CatId = rdr.GetInt32(8), ForumId = rdr.GetInt32(9), Id = rdr.GetInt32(10), AuthorId = rdr.GetInt32(11), Subject = rdr.SafeGetString(12), Status = rdr.GetInt16(13), LastPostDate = rdr.GetSnitzDate(14), LastPostAuthorId = rdr.SafeGetInt32(15), LastReplyId = rdr.SafeGetInt32(16), ReplyCount = rdr.GetInt32(17), UnModeratedReplies = rdr.GetInt32(18), Views = rdr.GetInt32(19), AuthorName = rdr.SafeGetString(21), LastPostAuthorName = rdr.SafeGetString(22) }; //rowcount = rdr.GetInt32(24); return(result); }
public static ReplyInfo CopyReplyToBO(OleDbDataReader rdr) { ReplyInfo reply = new ReplyInfo { Id = rdr.GetInt32(0), CatId = rdr.GetInt32(1), ForumId = rdr.GetInt32(2), TopicId = rdr.GetInt32(3), AuthorId = rdr.GetInt32(4), Date = rdr.GetSnitzDate(5).Value, PosterIp = rdr.SafeGetString(6), Status = rdr.GetInt16(7), LastEditDate = rdr.GetSnitzDate(8), LastEditedById = rdr.SafeGetInt32(9), UseSignatures = rdr.GetInt16(10) == 1, Message = rdr.SafeGetString(11) }; if (rdr.FieldCount > 12) { reply.AuthorName = rdr.SafeGetString(12); reply.EditorName = rdr.SafeGetString(13); reply.AuthorViewSig = rdr.GetInt16(14) == 1; reply.AuthorSignature = rdr.SafeGetString(15).Replace(">", "]").Replace("<", "["); } return(reply); }
/// <summary> /// 从数据库读流程节点信息 /// </summary> /// <param name="obj"></param> private void GetFlowchartActs(FlowChart obj) { string sCmd = "SELECT F_ID,F_PROCESS_ID,F_NAME,F_TIME_ALLOWED,F_RULE_APPLIED," + "F_EX_PRE_RULE_FUNC,F_EX_POST_RULE_FUNC,F_ACT_TYPE,F_OR_MERGE_FLAG,F_NUM_VOTE_NEEDED," + "F_AUTO_EXEC,F_ACT_DESC FROM WF_ACTIVITY where F_PROCESS_ID=" + obj.ID; OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = sCmd; OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { //数据实例化 wfActivity newact = new wfActivity(); newact.ID = dr.GetValue(0).ToString(); //F_ID newact.Name = dr.IsDBNull(2) ? "" : dr.GetString(2); //F_NAME newact.TimeAllowed = dr.IsDBNull(3) ? 0: dr.GetInt32(3); //F_TIME_ALLOWED newact.ActType = dr.IsDBNull(7) ? "" : dr.GetString(7); //F_ACT_TYPE newact.OrMergeFlag = dr.IsDBNull(8) ? 0 : (int)dr.GetInt16(8); //F_OR_MERGE_FLAG newact.NumVotesNeeded = dr.IsDBNull(9) ? 0 : (int)dr.GetInt16(9); //F_NUM_VOTE_NEEDED newact.AutoExecutive = dr.IsDBNull(10) ? false : dr.GetInt16(10) == 1; //F_AUTO_EXEC newact.Desc = dr.IsDBNull(11) ? "" : dr.GetString(11); //F_ACT_DESC newact.PreRule = dr.IsDBNull(5) ? "" : dr.GetString(5); //添加到fchart 活动列表 obj.AddActivity(newact); //读授权信息 GetActAssgn(newact); } dr.Close(); dr.Dispose(); cmd.Dispose(); }
///<summary> ///读取数据库面板设置,将所有数据读至缓存 ///</summary> public void ReadDevieceInfoFromDB(int intDIndex) { //read basic information of bacnet #region string str = "select * from dbBasicBac where DIndex=" + intDIndex.ToString(); OleDbDataReader dr = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath); if (dr == null) { return; } if (dr.HasRows) { while (dr.Read()) { DeviceName = dr.GetString(1); ValidCount = Convert.ToInt32(dr.GetValue(5).ToString()); intPort = dr.GetInt16(6); blnSwitch = (dr.GetByte(7) == 1); Address = dr.GetInt16(8); } dr.Close(); } #endregion //read bacnet to bus #region str = string.Format("select * from dbBackNet where DIndex={0}", intDIndex); dr = DataModule.SearchAResultSQLDB(str, CsConst.mstrCurPath); otherInfo = new List <OtherInfo>(); if (dr == null) { return; } while (dr.Read()) { OtherInfo tmp = new OtherInfo(); tmp.ID = dr.GetByte(1); tmp.BackNetIDAry = (byte[])dr[2]; tmp.Type = dr.GetInt32(3); tmp.strDevName = dr.GetString(4); tmp.Param1 = dr.GetByte(5); tmp.Param2 = dr.GetByte(6); tmp.Param3 = dr.GetByte(7); tmp.Param4 = dr.GetByte(8); tmp.Remark = dr.GetString(9); otherInfo.Add(tmp); } dr.Close(); #endregion }
// function for load column data private void getEditClmData() { try { /* TbClms = " Clm_No,Clm_Name,Clm_SX,Clm_SY,Clm_Wi,Clm_Hi,Clm_Nm_X,Clm_Nm_Y,Clm_Hight,Clm_Breadth,Clm_Length,"; * TbClms = TbClms + "Clm_Pit_Depth,Clm_Pit_Breadth,Clm_Pit_Length,Clm_Pit_Mat_Thick,Clm_Sand_Rat,Clm_Stone_Rat,"; * TbClms = TbClms + "Clm_Cement_Rat,Clm_NoRod ";*/ int ftv = 0, incv = 0; float FtinV = 0; string Qry = "select * from Window_Tab where Win_Name ='" + HomeFrm.EdtCntrl + "';"; OleDbConnection con = new OleDbConnection(ConStr); OleDbCommand cmd = new OleDbCommand(Qry, con); con.Open(); OleDbDataReader Dr = null; Dr = cmd.ExecuteReader(); if (Dr.HasRows) { while (Dr.Read()) { WinName = Dr.GetString(1); txtWinLeft.Text = Dr.GetInt16(2).ToString(); txtWinTop.Text = Dr.GetInt16(3).ToString(); txtNameLeft.Text = Dr.GetInt16(6).ToString(); txtNameTop.Text = Dr.GetInt16(7).ToString(); FtinV = Dr.GetFloat(8); FtToIn(FtinV, out ftv, out incv); txtWinHeightFt.Text = ftv.ToString(); txtWinHeightIn.Text = incv.ToString(); FtinV = Dr.GetFloat(9); FtToIn(FtinV, out ftv, out incv); txtWinLengthFt.Text = ftv.ToString(); txtWinLengthIn.Text = incv.ToString(); cmbWallName.Text = Dr.GetString(10); } } if (Dr != null) { Dr.Close(); } if (con != null) { con.Close(); } } catch (Exception ex) { MessageBox.Show("Can\'t load all edit column data\n " + ex.Message, "Error", MessageBoxButtons.OK); } }
public static TopicInfo CopyTopicToBO(OleDbDataReader rdr) { TopicInfo topic; try { topic = new TopicInfo { Id = rdr.GetInt32(0), CatId = rdr.GetInt32(1), ForumId = rdr.GetInt32(2), Status = rdr.GetInt16(3), Subject = rdr.SafeGetString(4), AuthorId = rdr.GetInt32(5), ReplyCount = rdr.GetInt32(6), Views = rdr.GetInt32(7), LastPostDate = rdr.GetSnitzDate(8), Date = rdr.GetSnitzDate(9).Value, PosterIp = rdr.SafeGetString(10), LastPostAuthorId = rdr.SafeGetInt32(11), IsSticky = rdr.GetInt16(12) == 1, LastEditDate = rdr.GetSnitzDate(13), LastEditedById = rdr.SafeGetInt32(14), UseSignatures = rdr.GetInt16(15) == 1, LastReplyId = rdr.SafeGetInt32(16), UnModeratedReplies = rdr.GetInt32(17), Message = rdr.SafeGetString(18) }; if (rdr.FieldCount > 19) { topic.AuthorName = rdr.SafeGetString(19); topic.LastPostAuthorName = rdr.SafeGetString(20); topic.EditorName = rdr.SafeGetString(21); if (rdr.FieldCount > 22) { topic.AuthorViewSig = rdr.GetInt16(22) == 1; topic.AuthorSignature = rdr.SafeGetString(23); } } } catch (Exception) { return(null); } return(topic); }
private void cargarLista() { ctdor = 0; lstPersonas.Items.Clear(); abrirConexion(cadenaConexion); comm.CommandText = "SELECT * FROM Personas"; lector = comm.ExecuteReader(); while (lector.Read()) { Persona p = new Persona(); if (!lector.IsDBNull(0)) { p.pDocumento = lector.GetDouble(0); } if (!lector.IsDBNull(1)) { p.pApellido = lector.GetString(1); } if (!lector.IsDBNull(2)) { p.pNombres = lector.GetString(2); } if (!lector.IsDBNull(3)) { p.pTipoDoc = lector.GetInt16(3); } if (!lector.IsDBNull(4)) { p.pEstCivil = lector.GetInt16(4); } if (!lector.IsDBNull(5)) { p.pSexo = lector.GetInt16(5); } if (!lector.IsDBNull(6)) { p.pFallecio = lector.GetInt16(6); } aPersona[ctdor] = p; ctdor++; } lector.Close(); conex.Close(); for (int i = 0; i < ctdor; i++) { lstPersonas.Items.Add(aPersona[i].ToString()); } }
public RechercheVendeur() { InitializeComponent(); Bouton_Ajouter_bien.Enabled = false; Visualiser.Enabled = false; string ChaineBd = "Provider=SQLOLEDB;Data Source=INFO-joyeux;Initial Catalog=IMMOBILLY_JACKYTEAM;Persist Security Info=True; Integrated Security=sspi;"; OleDbConnection dbConnection = new OleDbConnection(ChaineBd); dbConnection.Open(); string sqlS1 = "Select v.Num_Client, v.Nom_Client, v.Prénom_Client, v.Adresse, v.Téléphone, v.E_mail, v.adresse, vi.nom_ville, vi.code_postal"; string sqlF1 = " from Vendeur v left join ville vi on vi.code_ville = v.code_ville"; string sql = sqlS1 + sqlF1; OleDbCommand cmd = new OleDbCommand(sql, dbConnection); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string[] ligne = { reader.GetInt16(0).ToString(), reader.GetString(1), reader.GetString(2) }; ListViewItem lvi = new ListViewItem(ligne); listView1_vendeurs.Items.Add(lvi); } reader.Close(); }
// not used since 25 July 2019 private void nextNo() { Int16 next = 0; try { conn.Open(); comm.Connection = conn; comm.CommandText = "SELECT MAX(PD_NEXT_NO) FROM T_PD_HEADERS"; comm.CommandTimeout = 10000; sdr = comm.ExecuteReader(); sdr.Read(); if (sdr.IsDBNull(0)) { next = 1; sdr.Close(); } else { next = sdr.GetInt16(0); sdr.Close(); } } catch (SystemException err) { next = 0; iMessage.erBoxOk(err.Message); } finally { conn.Close(); } this.pdNextNo = next; }
public void getOrderMedsInfo(Orders order) { string query = "SELECT * FROM OrderDetails WHERE {0} = {1} ;"; query = string.Format(query, DatabaseVars.ORDER_ID, order.OrderId); MedAndOrder mao = new MedAndOrder(); mao.setMedOpj(); OleDbConnection dbConnection = dbManager.openDb(); this.comand.Connection = dbConnection; comand.CommandText = query; OleDbDataReader result = comand.ExecuteReader(); while (result.Read()) { mao.OrderId = result.GetInt32(0); mao.Medicen.MedName = result.GetString(1); mao.Medicen.Parecode = result.GetString(2); mao.NumOfTabes = result.GetInt16(3); mao.TotalPrice = (double)result.GetDecimal(4); order.ListOfMeds.Add(mao); mao = new MedAndOrder(); mao.setMedOpj(); } result.Close(); dbManager.closeDb(); }
private Artikel mkArtikelObject(OleDbDataReader reader) { Artikel a = new Artikel(); int i = 0; a.ArtikelOid = reader.GetInt32(i++); //i++; //if (reader[i] != DBNull.Value) a.ArtikelNr = reader.GetString(i++); //else i++; a.ArtikelNr = Convert.ToString(CheckDBNull(reader[i++])); a.ArtikelGruppe = Convert.ToInt32(CheckDBNull(reader[i++])); //reader.GetInt32(i++); a.Bezeichnung = reader.GetString(i++); //if (reader[i] != DBNull.Value) a.Bestand = Convert.ToInt16(CheckDBNull(reader[i++])); //else i++; if (reader[i] != DBNull.Value) { a.Meldebestand = reader.GetInt16(i++); } a.Verpackung = Convert.ToInt16(reader[i++]); a.VkPreis = reader.GetDecimal(i++); if (reader[i] != DBNull.Value) { a.LetzteEntnahme = reader.GetDateTime(i++); } // Attribute aus DataReader gebildet werden return(a); }
private void nextNo() { try { conn.Open(); trans = conn.BeginTransaction(); comm.Connection = conn; comm.CommandText = "SELECT MAX(PD_NEXT_NO) FROM T_PD_HEADERS"; comm.CommandTimeout = 10000; sdr = comm.ExecuteReader(); if (sdr.HasRows) { sdr.Read(); this.pdNextNo = sdr.GetInt16(3); sdr.Close(); } else { this.pdNextNo = 1; sdr.Close(); } } catch (SystemException err) { iMessage.erBoxOk(err.Message); } finally { conn.Close(); } }
public liste_des_biens() { InitializeComponent(); listView1.Items.Clear(); Visualiser.Enabled = false; //string nomBase = "IMMOBILLY_JACKYTEAM"; string ChaineBd = "Provider=SQLOLEDB;Data Source=INFO-joyeux;Initial Catalog=IMMOBILLY_JACKYTEAM;Persist Security Info=True; Integrated Security=sspi;"; OleDbConnection dbConnection = new OleDbConnection(ChaineBd); dbConnection.Open(); string sql = "select b.CODE_BIEN, b.SURFACE_HABITABLE, b.NB_PIÉCES, b.STATUT,vi.NOM_VILLE, v.NOM_CLIENT, v.PRÉNOM_CLIENT from Bien b join VENDEUR v on b.NUM_CLIENT = v.NUM_CLIENT join ville vi on b.CODE_VILLE = vi.CODE_VILLE where v.nom_client like '%" + textBox2.Text + "%' and b.statut like '%" + statut + "' and date_suppression is null; "; OleDbCommand cmd = new OleDbCommand(sql, dbConnection); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string[] row = { reader.GetInt16(0).ToString(), reader.GetInt32(1).ToString(), reader.GetInt32(2).ToString(), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6) }; ListViewItem lvi = new ListViewItem(row); listView1.Items.Add(lvi); } reader.Close(); }
Event BuildEvent(OleDbConnection connection, OleDbDataReader reader, FixtureProfiles fixtureProfiles, TimeSpan interval) { int i = 0; int idEvent = reader.GetInt32(i++); FixtureClass fixtureClass; Boolean firstCycle = false; if (reader.IsDBNull(i)) { fixtureClass = FixtureClasses.Unclassified; } else { fixtureClass = fixtureProfiles[reader.GetString(i)].FixtureClass; firstCycle = reader.GetString(i).Contains("@"); } i++; Event @event = new Event(fixtureClass); @event.ManuallyClassified = reader.GetBoolean(i++); @event.Channel = (Channel)reader.GetInt16(i++); @event.FirstCycle = firstCycle; using (OleDbCommand commandFlows = new OleDbCommand(BuildLoadFlowsCommand(idEvent), connection)) { using (OleDbDataReader readerFlows = commandFlows.ExecuteReader()) { while (readerFlows.Read()) { @event.Add(BuildFlow(readerFlows, interval)); } } } return(@event); }
private void komadiComboBoxFill(int RezervacijaID = 0) { using (OleDbConnection conn = new OleDbConnection(connectionString)) { conn.Open(); OleDbCommand cmd; if (RezervacijaID != 0) { cmd = new OleDbCommand("SELECT Pozorisni_Komad.KomadID, Naziv FROM Pozorisni_Komad " + "INNER JOIN Stavke_Rezervacije ON Stavke_Rezervacije.KomadID = Pozorisni_Komad.KomadID " + $"WHERE Stavke_Rezervacije.RezervacijaID = {RezervacijaID};", conn); using (OleDbDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { string temp = reader.GetInt32(0).ToString() + " " + reader.GetString(1); KomadiComboBox.Items.Add(temp); KomadiComboBox.SelectedIndex = 0; } } } else { cmd = new OleDbCommand("SELECT Pozorisni_Komad.KomadID, Naziv FROM Pozorisni_Komad", conn); using (OleDbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { KomadiComboBox.Items.Add(reader.GetInt16(0).ToString() + reader.GetString(1)); } } } } }
/// <summary> /// 检查任务状态 /// </summary> /// <param name="ProcessID">流程ID</param> /// <param name="EntityID">业务数据ID</param> /// <returns>0:未开始,1:已结束,2:正在进行,-1:错误或无法确定</returns> public int CheckTaskStatus(string ProcessID, string EntityID) { string sSQL = "SELECT F_STATUS " + "FROM WF_TASK_LIST where F_PROCESS_ID=" + ProcessID + " and F_ENTITY_ID='" + EntityID.Replace("'", "''") + "'"; if (!InitConnection()) { return(-1); } ////// OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = sSQL; OleDbDataReader dr = cmd.ExecuteReader(); int rc = 0; if (dr.Read()) { rc = dr.GetInt16(0); } dr.Close(); dr.Dispose(); cmd.Dispose(); conn.Close(); conn.Dispose(); return(rc); }
private Artikel mkArtikelObject(OleDbDataReader reader) { Artikel a = new Artikel(); a.ArtikelOid = reader.GetInt32(0); try { a.ArtikelNr = reader.GetString(1); } catch (Exception) { } a.ArtikelGruppe = reader.GetInt32(2); a.Bezeichnung = reader.GetString(3); try { a.Bestand = reader.GetByte(4); } catch (Exception) { } a.Meldebestand = reader.GetInt16(5); a.Verpackung = reader.GetInt32(6); a.VkPreis = reader.GetDecimal(7); try { a.LetzteEntnahme = reader.GetDateTime(8); } catch (Exception) { } return(a); }
static public void case_GetInt16_OverBound_Min() { // Open Connection string strConn = connString; OleDbConnection connCubrid = conn; // int test_int = Int32.MinValue; //Int32 -32769 int test_int = Int32.MinValue; string testTable = "t_type_int16_overbound"; string strCreateTable = string.Format("CREATE TABLE {0}(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f_int INT)", testTable); string strDropTable = string.Format("DROP TABLE {0}", testTable); string strSqlInsert = string.Format("INSERT INTO {0}(f_int) VALUE({1})", testTable, test_int); ExecuteMultiQueries(connCubrid, new string[] { strDropTable, strCreateTable, strSqlInsert }); string strSqlSelect = string.Format("SELECT * FROM {0} ORDER BY id DESC;", testTable); OleDbDataReader OleDbReader = CreateReader(connCubrid, strSqlSelect); Console.WriteLine(test_int); // output: -32769 try { Console.WriteLine(OleDbReader.GetInt16(0)); // output: -32768, expected result: OleDbException } catch (Exception ex) { Console.WriteLine(ex.Message); } }
/// <summary> /// Deserialize the object. /// </summary> /// <param name="type">The type being read.</param> /// <param name="reader">The reader to use.</param> /// <returns>Returns the deserialized object.</returns> internal static object Deserialize(Type type, OleDbDataReader reader) { object data = Activator.CreateInstance(type); foreach (PropertyInfo prop in type.GetProperties()) { AccessColumnAttribute attr = prop.GetCustomAttribute <AccessColumnAttribute>(); if (attr != null) { int ordinal = reader.GetOrdinal(attr.Name); object value = null; if (!reader.IsDBNull(ordinal)) { Type fieldType = reader.GetFieldType(ordinal); if (fieldType == typeof(string)) { value = reader.GetString(ordinal); } else if (fieldType == typeof(short)) { value = reader.GetInt16(ordinal); } else if (fieldType == typeof(int)) { value = reader.GetInt32(ordinal); } else if (fieldType == typeof(byte)) { value = reader.GetByte(ordinal); } else if (fieldType == typeof(DateTime)) { value = reader.GetDateTime(ordinal); } else if (fieldType == typeof(double)) { value = reader.GetDouble(ordinal); } else if (fieldType == typeof(decimal)) { value = reader.GetDecimal(ordinal); } else if (fieldType == typeof(bool)) { value = reader.GetBoolean(ordinal); } else { Debugger.Break(); } } prop.SetValue(data, value); } } return(data); }
private void ModifierVisite_Load(object sender, EventArgs e) { //string nomBase = "IMMOBILLY_JACKYTEAM"; string ChaineBd = "Provider=SQLOLEDB;Data Source=INFO-joyeux;Initial Catalog=IMMOBILLY_JACKYTEAM;Persist Security Info=True; Integrated Security=sspi;"; OleDbConnection dbConnection = new OleDbConnection(ChaineBd); dbConnection.Open(); string sql = "select Num_Commercial, Nom, Prenom from COMMERCIAL "; OleDbCommand cmd = new OleDbCommand(sql, dbConnection); OleDbDataReader reader = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Columns.Add("Num_Commercial", typeof(string)); dt.Columns.Add("Nom", typeof(string)); //dt.Columns.Add("Prenom", typeof(string)); dt.Load(reader); comboBox_Commercial.ValueMember = "Num_Commercial"; comboBox_Commercial.DisplayMember = "Nom"; comboBox_Commercial.DataSource = dt; string sql1 = "Select nom_acheteur, PRÉNOM_ACHETEUR, b.CODE_BIEN, b.SURFACE_HABITABLE, b.SURFACE_PARCELLE, b.NB_PIÉCES, b.NB_CHAMBRES, b.NB_SALLE_DE_BAIN,b.GARAGE, b.CAVE,b.PRIX_VENDEUR,p.date,v.Date,b.adresse,vi.nom_ville,vi.code_postal,Acheteur.Num_Acheteur from ACHETEUR inner join souhait s on s.NUM_ACHETEUR = ACHETEUR.NUM_ACHETEUR inner join PROPOSITION p on s.CODE_SOUHAIT = p.CODE_SOUHAIT inner join bien b on p.CODE_BIEN = b.CODE_BIEN left join ville vi on vi.code_ville = b.code_ville inner join VISITE v on v.CODE_PROPOSITION = p.CODE_PROPOSITION where v.CODE_VISITE = " + ApplicationState.id_visite + ";"; OleDbCommand cmd1 = new OleDbCommand(sql1, dbConnection); OleDbDataReader reader1 = cmd1.ExecuteReader(); while (reader1.Read()) { textBox_Nom.Text = reader1.GetString(0); textBox_Prénom.Text = reader1.GetString(1); IdBien.Text = reader1.GetInt16(2).ToString(); textBox_SurfHab.Text = reader1.GetInt32(3).ToString(); textBox_SurfParc.Text = reader1.GetInt32(4).ToString(); textBox_NbPiece.Text = reader1.GetInt32(5).ToString(); textBox_NbChambre.Text = reader1.GetInt32(6).ToString(); textBox_NbSdb.Text = reader1.GetInt32(7).ToString(); if (reader1.GetBoolean(8) == true) { checkBox_Garage.Checked = true; } if (reader1.GetBoolean(9) == true) { checkBox_Cave.Checked = true; } textBox_Prix.Text = reader1.GetInt32(10).ToString(); dateTimePicker2.Text = reader1.GetDateTime(11).ToString(); this.dateTimePicker2.Enabled = false; dateTimePicker1.Text = reader1.GetDateTime(12).ToString(); textBox_VisRueBien.Text = reader1.GetString(13); textBox_Ville.Text = reader1.GetString(14); textBox_VisCPBien.Text = reader1.GetValue(15).ToString(); textBox1.Text = reader1.GetValue(16).ToString(); } reader1.Close(); }
// for load data of Editing Beam private void getEditBeamData() { try { int ftv = 0, incv = 0; float FtinV = 0; string Qry = "select * from Beam_Tab where Bm_Name ='" + HomeFrm.EdtCntrl + "';"; OleDbConnection con = new OleDbConnection(ConStr); OleDbCommand cmd = new OleDbCommand(Qry, con); con.Open(); OleDbDataReader Dr = null; Dr = cmd.ExecuteReader(); if (Dr.HasRows) { while (Dr.Read()) { BmName = Dr.GetString(1); txtStartX.Text = Dr.GetInt16(2).ToString(); txtStartY.Text = Dr.GetInt16(3).ToString(); txtEndX.Text = Dr.GetInt16(4).ToString(); txtEndY.Text = Dr.GetInt16(5).ToString(); txtNmX.Text = Dr.GetInt16(6).ToString(); txtNmY.Text = Dr.GetInt16(7).ToString(); FtinV = Dr.GetFloat(8); FtToIn(FtinV, out ftv, out incv); txtBmHeightFt.Text = ftv.ToString(); txtBmHeightIn.Text = incv.ToString(); FtinV = Dr.GetFloat(9); FtToIn(FtinV, out ftv, out incv); txtBmBreadthFt.Text = ftv.ToString(); txtBmBreadthIn.Text = incv.ToString(); FtinV = Dr.GetFloat(10); FtToIn(FtinV, out ftv, out incv); txtBmLengthFt.Text = ftv.ToString(); txtBmLengthIn.Text = incv.ToString(); txtSand.Text = Dr.GetFloat(11).ToString(); txtStone.Text = Dr.GetFloat(12).ToString(); txtCement.Text = Dr.GetFloat(13).ToString(); txtRods.Text = Dr.GetInt16(14).ToString(); } } if (Dr != null) { Dr.Close(); } if (con != null) { con.Close(); } } catch (Exception ex) { MessageBox.Show("Can\'t load all edit Beam Data.\n" + ex.Message, "Error", MessageBoxButtons.OK); } }
public static int SafeGetInt16(this OleDbDataReader reader, int colIndex) { if (!reader.IsDBNull(colIndex)) { return(reader.GetInt16(colIndex)); } return(0); }
// Token: 0x0600003B RID: 59 RVA: 0x00007510 File Offset: 0x00005710 public frmMasterLevel(string charName) { InitializeComponent(); charName = charName; string text = string.Format("SELECT T_MasterLevelSystem.CHAR_NAME, T_MasterLevelSystem.MASTER_LEVEL, T_MasterLevelSystem.ML_EXP, T_MasterLevelSystem.ML_NEXTEXP, T_MasterLevelSystem.ML_POINT, Character.Class FROM Character INNER JOIN T_MasterLevelSystem ON Character.Name = T_MasterLevelSystem.CHAR_NAME COLLATE Chinese_PRC_CS_AS_KS_WS WHERE (T_MasterLevelSystem.CHAR_NAME = '{0}')", charName); try { OleDbCommand oleDbCommand = new OleDbCommand(text, frmBase.Mu_Conn); OleDbDataReader oleDbDataReader = oleDbCommand.ExecuteReader(); if (oleDbDataReader.Read()) { txtCharacter.Text = Convert.ToString(oleDbDataReader.GetValue(0)); txtLevel.Text = oleDbDataReader.GetInt16(1).ToString(); txtEXP.Text = oleDbDataReader.GetInt64(2).ToString(); txtNextEXP.Text = oleDbDataReader.GetInt64(3).ToString(); txtPoint.Text = oleDbDataReader.GetInt16(4).ToString(); if (oleDbDataReader.GetValue(5) != DBNull.Value) { classID = (int)oleDbDataReader.GetByte(5); } } else { Utils.WarningMessage("对不起,没有找到角色[" + charName + "]对应的帐号信息!"); btnOK.Enabled = false; } oleDbDataReader.Close(); } catch (Exception ex) { Utils.WarningMessage(string.Concat(new string[] { "SQL:", text, "\nError:", ex.Message, "\nSource:", ex.Source, "\nTrace:", ex.StackTrace })); } }