using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.ComponentModel;
using FirebirdSql.Data.FirebirdClient;
namespace PcDr_Asat_Scada
{
public class Class1
{
private static FbConnection con;
private static FbDataAdapter adapter;
//private static DataTable dt = null;
static string FSelectQuery = "";
public static void Baglan()
{
con = new FbConnection("data source=127.0.0.1;user id=SYSDBA;initial catalog=C:dataAsat_Scada.GDB;password=masterkey");
con.Open();
if (adapter == null) adapter = new FbDataAdapter();
}
public static void BaglantiKes()
{
//dt.Dispose();
adapter.Dispose();
con.Close();
con.Dispose();
}
public static void cmdAyarla()
{
string aQry = "";
aQry = "INSERT INTO SORGU VALUES (@SIRA_NO,@IST_BLG,@IST_ADI,@IST_ID,@TRH,@ACK)";
adapter.InsertCommand = new FbCommand(aQry, con);
verParametre(adapter.InsertCommand);
aQry = "UPDATE sorgu SET IST_BLG=@IST_BLG, IST_ADI=@IST_ADI, IST_ID=@IST_ID, TRH=@TRH, ACK=@ACK WHERE SIRA_NO=@SIRA_NO";
adapter.UpdateCommand = new FbCommand(aQry, con);
verParametre(adapter.UpdateCommand);
aQry = "DELETE FROM SORGU WHERE SIRA_NO = @SIRA_NO";
adapter.DeleteCommand = new FbCommand(aQry, con);
verParametre(adapter.DeleteCommand);
}
private static void verParametre(FbCommand Acmd)
{
FbParameter param = null;
if (Acmd == adapter.DeleteCommand)
{
param = adapter.DeleteCommand.Parameters.Add("@SIRA_NO", FbDbType.Integer);
param.SourceColumn = "SIRA_NO";
param.SourceVersion = DataRowVersion.Original;
}
else
{
param = Acmd.Parameters.Add("@SIRA_NO", FbDbType.Integer);
param.SourceColumn = "SIRA_NO";
param.SourceVersion = DataRowVersion.Original;
param = Acmd.Parameters.Add("@IST_BLG", FbDbType.Text);
param.SourceVersion = DataRowVersion.Current;
param.SourceColumn = "IST_BLG";
param = Acmd.Parameters.Add("@IST_ADI", FbDbType.Text);
param.SourceVersion = DataRowVersion.Current;
param.SourceColumn = "IST_ADI";
param = Acmd.Parameters.Add("@IST_ID", FbDbType.Text);
param.SourceVersion = DataRowVersion.Current;
param.SourceColumn = "IST_ID";
param = Acmd.Parameters.Add("@TRH", FbDbType.Text);
param.SourceVersion = DataRowVersion.Current;
param.SourceColumn = "TRH";
param = Acmd.Parameters.Add("@ACK", FbDbType.Text);
param.SourceVersion = DataRowVersion.Current;
param.SourceColumn = "ACK";
}
}
private static DataTable alListeSORGU()
{
FSelectQuery = "SELECT * FROM SORGU";
adapter.SelectCommand = new FbCommand(FSelectQuery, con);
DataTable dt = new DataTable("SORGU");
adapter.Fill(dt);
return dt;
}
public static DataTable ListeSORGU
{
get
{
return alListeSORGU();
}
}
public static FbDataAdapter AlDataAdapter()
{
return adapter;
}
public static void Kaydet(DataTable dt)
{
//try
//{
adapter.Update(dt);
//}
//catch (Exception ex)
// {
// Console.Write(ex.ToString());
//}
}
}
}