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