public void searchbyid(string id)
{
//CacheCommand cc;
//CacheDataReader cr;
IRISCommand ic;
IRISDataReader ir;
try
{
//cc = new CacheCommand("Select AID, ACITY, ANAME, ABTHDAY, ASTREET , APHHOME , APHWORK, AAGE, AZIP from ADBK WHERE AID = ?", adbksrc.conn);
ic = new IRISCommand("Select AID, ACITY, ANAME, ABTHDAY, ASTREET , APHHOME , APHWORK, AAGE, AZIP from ADBK WHERE AID = ?", adbksrc.conn);
//CacheParameter cp = new CacheParameter("id", CacheDbType.NVarChar);
IRISParameter ip = new IRISParameter("id", IRISDbType.NVarChar);
//cp.Value = id;
//cc.Parameters.Add(cp);
//cr = cc.ExecuteReader();
//updatedatamodel(cr);
ip.Value = id;
ic.Parameters.Add(ip);
ir = ic.ExecuteReader();
updatedatamodel(ir);
}
catch (Exception err)
{
MessageBox.Show("seachbyid エラー " + err.Message);
}
}
public Boolean delete(string id)
{
//CacheCommand cc;
IRISCommand ic;
if (MessageBox.Show("削除しますか", "削除", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
//cc = new CacheCommand("DELETE FROM ADBK WHERE AID = ?", adbksrc.conn);
//CacheParameter cp = new CacheParameter("id", CacheDbType.NVarChar);
//cp.Value = id;
//cc.Parameters.Add(cp);
//cc.ExecuteNonQuery();
ic = new IRISCommand("DELETE FROM ADBK WHERE AID = ?", adbksrc.conn);
IRISParameter ip = new IRISParameter("id", IRISDbType.NVarChar);
ip.Value = id;
ic.Parameters.Add(ip);
ic.ExecuteNonQuery();
return(true);
}
catch (Exception err)
{
MessageBox.Show("削除エラー" + err.Message);
return(false);
}
}
return(false);
}
public List <string> searchbyname(string name)
{
idlist.Clear();
List <string> anamelist = new List <string>();
//CacheCommand cc = User.ADBK.ByName(adbksrc.conn);
//CacheParameter cp = new CacheParameter("Name", CacheDbType.NVarChar);
//cp.Value = name;
//cc.Parameters.Add(cp);
string SQLtext = "call sqluser.ADBK_byname(?)";
IRISCommand ic = new IRISCommand(SQLtext, adbksrc.conn);
IRISParameter ip = new IRISParameter("Name", IRISDbType.NVarChar);
ip.Value = name;
ic.Parameters.Add(ip);
//CacheDataReader reader = cc.ExecuteReader();
IRISDataReader reader = ic.ExecuteReader();
while (reader.Read())
{
string id = reader[reader.GetOrdinal("AID")].ToString();
string aname = reader[reader.GetOrdinal("ANAME")].ToString();
anamelist.Add(aname);
idlist.Add(id);
}
return(anamelist);
}
static void Main(string[] args)
{
IRISCommand spIRIS;
IRISConnection cnIRIS;
IRISTransaction txIRIS = null;
//存在するファイルを指定する
FileStream fs = new FileStream(
@"c:\temp\test.jpeg", FileMode.Open, FileAccess.Read);
int fileSize = (int)fs.Length; // ファイルのサイズ
byte[] buf = new byte[fileSize]; // データ格納用配列
long readSize; // Readメソッドで読み込んだバイト数
int remain = fileSize; // 読み込むべき残りのバイト数
readSize = fs.Read(buf, 0, (int)fs.Length);
string IRISConnectString = "Server = localhost;Port=1972;Namespace=User;Password=SYS;User ID = _SYSTEM;";
cnIRIS = new IRISConnection(IRISConnectString);
cnIRIS.Open();
spIRIS = new IRISCommand("Insert into MyApp.Person2(Name, Picture) Values(?, ?)", cnIRIS, txIRIS);
IRISParameter pName = new IRISParameter();
pName.ParameterName = "Name";
pName.IRISDbType = IRISDbType.NVarChar;
pName.Direction = ParameterDirection.Input;
pName.Value = "Hoge Hoge";
spIRIS.Parameters.Add(pName);
IRISParameter pPicture = new IRISParameter();
pPicture.ParameterName = "Picture";
pPicture.IRISDbType = IRISDbType.LongVarBinary;
pPicture.Direction = ParameterDirection.Input;
pPicture.Value = buf;
spIRIS.Parameters.Add(pPicture);
spIRIS.ExecuteNonQuery();
fs.Dispose();
cnIRIS.Close();
}
public List <string> searchbyname(string name)
{
//CacheCommand cc;
IRISCommand ic;
idlist.Clear();
List <string> anamelist = new List <string>();
try
{
//cc = new CacheCommand("Select AID, ANAME from ADBK WHERE ANAME %startswith ?", adbksrc.conn);
//CacheParameter cp = new CacheParameter("Name", CacheDbType.NVarChar);
//cp.Value = name;
//cc.Parameters.Add(cp);
//CacheDataReader reader = cc.ExecuteReader();
ic = new IRISCommand("Select AID, ANAME from ADBK WHERE ANAME %startswith ?", adbksrc.conn);
IRISParameter ip = new IRISParameter("Name", IRISDbType.NVarChar);
ip.Value = name;
ic.Parameters.Add(ip);
IRISDataReader reader = ic.ExecuteReader();
while (reader.Read())
{
string id = reader[reader.GetOrdinal("AID")].ToString();
string aname = reader[reader.GetOrdinal("ANAME")].ToString();
anamelist.Add(aname);
idlist.Add(id);
}
return(anamelist);
}
catch (Exception err)
{
MessageBox.Show("searchbynameエラー " + err.Message);
return(anamelist);
}
//return anamelist;
}
public void save(string id)
{
//CacheCommand cc;
//CacheParameter cp;
//CacheTransaction ctx;
IRISCommand ic;
IRISParameter ip;
IRISTransaction itx;
try
{
//ctx = adbksrc.conn.BeginTransaction(IsolationLevel.ReadCommitted);
itx = adbksrc.conn.BeginTransaction(IsolationLevel.ReadCommitted);
if (newflag == true)
{
//cc = new CacheCommand("INSERT INTO ADBK (ANAME,ASTREET,APHHOME,APHWORK,AZIP,ABTHDAY) VALUES(?,?,?,?,?,?)", adbksrc.conn,ctx);
//cp = new CacheParameter("Name", CacheDbType.NVarChar);
//cp.Value = Name;
//cc.Parameters.Add(cp);
//cp = new CacheParameter("Street", CacheDbType.NVarChar);
//cp.Value = Street;
//cc.Parameters.Add(cp);
//cp = new CacheParameter("HomePhone", CacheDbType.NVarChar);
//cp.Value = HomePhone;
//cc.Parameters.Add(cp);
//cp = new CacheParameter("WorkPhone", CacheDbType.NVarChar);
//cp.Value = WorkPhone;
//cc.Parameters.Add(cp);
//cp = new CacheParameter("ZipCode", CacheDbType.NVarChar);
//cp.Value = ZipCode;
//cc.Parameters.Add(cp);
//cp = new CacheParameter("Dob", CacheDbType.Date);
//cp.Value = dob.ToString().Split(' ')[0].ToString();
//cc.Parameters.Add(cp);
ic = new IRISCommand("INSERT INTO ADBK (ANAME,ASTREET,APHHOME,APHWORK,AZIP,ABTHDAY) VALUES(?,?,?,?,?,?)", adbksrc.conn, itx);
ip = new IRISParameter("Name", IRISDbType.NVarChar);
ip.Value = Name;
ic.Parameters.Add(ip);
ip = new IRISParameter("Street", IRISDbType.NVarChar);
ip.Value = Street;
ic.Parameters.Add(ip);
ip = new IRISParameter("HomePhone", IRISDbType.NVarChar);
ip.Value = HomePhone;
ic.Parameters.Add(ip);
ip = new IRISParameter("WorkPhone", IRISDbType.NVarChar);
ip.Value = WorkPhone;
ic.Parameters.Add(ip);
ip = new IRISParameter("ZipCode", IRISDbType.NVarChar);
ip.Value = ZipCode;
ic.Parameters.Add(ip);
ip = new IRISParameter("Dob", IRISDbType.Date);
ip.Value = dob.ToString().Split(' ')[0].ToString();
ic.Parameters.Add(ip);
}
else
{
/*
* cc = new CacheCommand("UPDATE ADBK SET ANAME = ?,ASTREET = ?,APHHOME = ?,APHWORK = ?,AZIP = ?,ABTHDAY = ? WHERE AID = ?", adbksrc.conn,ctx);
*
* cp = new CacheParameter("Name", CacheDbType.NVarChar);
* cp.Value = Name;
* cc.Parameters.Add(cp);
* cp = new CacheParameter("Street", CacheDbType.NVarChar);
* cp.Value = Street;
* cc.Parameters.Add(cp);
* cp = new CacheParameter("HomePhone", CacheDbType.NVarChar);
* cp.Value = HomePhone;
* cc.Parameters.Add(cp);
* cp = new CacheParameter("WorkPhone", CacheDbType.NVarChar);
* cp.Value = WorkPhone;
* cc.Parameters.Add(cp);
* cp = new CacheParameter("ZipCode", CacheDbType.NVarChar);
* cp.Value = ZipCode;
* cc.Parameters.Add(cp);
* cp = new CacheParameter("Dob", CacheDbType.Date);
* cp.Value = dob.ToString().Split(' ')[0].ToString();
* cc.Parameters.Add(cp);
* cp = new CacheParameter("id", CacheDbType.NVarChar);
* cp.Value = id;
* cc.Parameters.Add(cp);
*/
ic = new IRISCommand("UPDATE ADBK SET ANAME = ?,ASTREET = ?,APHHOME = ?,APHWORK = ?,AZIP = ?,ABTHDAY = ? WHERE AID = ?", adbksrc.conn, itx);
ip = new IRISParameter("Name", IRISDbType.NVarChar);
ip.Value = Name;
ic.Parameters.Add(ip);
ip = new IRISParameter("Street", IRISDbType.NVarChar);
ip.Value = Street;
ic.Parameters.Add(ip);
ip = new IRISParameter("HomePhone", IRISDbType.NVarChar);
ip.Value = HomePhone;
ic.Parameters.Add(ip);
ip = new IRISParameter("WorkPhone", IRISDbType.NVarChar);
ip.Value = WorkPhone;
ic.Parameters.Add(ip);
ip = new IRISParameter("ZipCode", IRISDbType.NVarChar);
ip.Value = ZipCode;
ic.Parameters.Add(ip);
ip = new IRISParameter("Dob", IRISDbType.Date);
ip.Value = dob.ToString().Split(' ')[0].ToString();
ic.Parameters.Add(ip);
ip = new IRISParameter("id", IRISDbType.NVarChar);
ip.Value = id;
ic.Parameters.Add(ip);
}
//cc.ExecuteNonQuery();
ic.ExecuteNonQuery();
if (newflag == true)
{
//cc = new CacheCommand("SELECT MAX(AID) FROM ADBK", adbksrc.conn,ctx);
//cc = new CacheCommand("SELECT LAST_IDENTITY() FROM ADBK", adbksrc.conn, ctx);
//CacheDataReader reader = cc.ExecuteReader();
ic = new IRISCommand("SELECT LAST_IDENTITY() FROM ADBK", adbksrc.conn, itx);
IRISDataReader reader = ic.ExecuteReader();
while (reader.Read())
{
string aid = reader[0].ToString();
id = aid;
//cc = new CacheCommand("Select AID, ACITY, ANAME, ABTHDAY, ASTREET , APHHOME , APHWORK, AAGE, AZIP from ADBK WHERE AID = ?", adbksrc.conn,ctx);
//CacheParameter cp2 = new CacheParameter("id", CacheDbType.NVarChar);
//cp2.Value = aid;
//cc.Parameters.Add(cp2);
//CacheDataReader cr = cc.ExecuteReader();
//updatedatamodel(cr);
ic = new IRISCommand("Select AID, ACITY, ANAME, ABTHDAY, ASTREET , APHHOME , APHWORK, AAGE, AZIP from ADBK WHERE AID = ?", adbksrc.conn, itx);
IRISParameter ip2 = new IRISParameter("id", IRISDbType.NVarChar);
ip2.Value = aid;
ic.Parameters.Add(ip2);
IRISDataReader ir = ic.ExecuteReader();
updatedatamodel(ir);
}
}
//ctx.Commit();
itx.Commit();
}
catch (Exception err)
{
MessageBox.Show("保存エラー " + err.Message);
}
}
// Save trade into database using ADO.NET - which is slower than using XEP
public static long StoreUsingADO(EventPersister persist, Trade[] sampleArray)
{
long totalTime = new long();
long startTime = DateTime.Now.Ticks;
// Loop through objects to insert
try
{
IRISDataAdapter da = new IRISDataAdapter();
String ClassName = "myApp.Trade";
IRISADOConnection con = (IRISADOConnection)persist.GetAdoNetConnection();
String SQL = "select purchaseDate, purchasePrice, stockName, shares, traderName from " + ClassName;
da.SelectCommand = con.CreateCommand();
da.SelectCommand.CommandText = SQL;
SQL = "INSERT INTO myApp.Trade (purchaseDate, purchasePrice, stockName, shares, traderName) VALUES (?,?,?,?,?)";
IRISCommand cmd = con.CreateCommand();
cmd.CommandText = SQL;
da.InsertCommand = cmd;
IRISParameter date_param = new IRISParameter("purchaseDate", IRISDbType.DateTime);
cmd.Parameters.Add(date_param);
date_param.SourceColumn = "purchaseDate";
IRISParameter price_param = new IRISParameter("purchasePrice", IRISDbType.Double);
cmd.Parameters.Add(price_param);
price_param.SourceColumn = "purchasePrice";
IRISParameter name_param = new IRISParameter("stockName", IRISDbType.NVarChar);
cmd.Parameters.Add(name_param);
name_param.SourceColumn = "stockName";
IRISParameter shares_param = new IRISParameter("shares", IRISDbType.Int);
cmd.Parameters.Add(shares_param);
shares_param.SourceColumn = "shares";
IRISParameter trader_param = new IRISParameter("traderName", IRISDbType.NVarChar);
cmd.Parameters.Add(trader_param);
trader_param.SourceColumn = "traderName";
da.TableMappings.Add("Table", ClassName);
DataSet ds = new DataSet();
da.Fill(ds);
for (int i = 0; i < sampleArray.Length; i++)
{
DataRow newRow = ds.Tables[0].NewRow();
newRow["purchaseDate"] = sampleArray[i].purchaseDate;
newRow["purchasePrice"] = sampleArray[i].purchasePrice;
newRow["stockName"] = sampleArray[i].stockName;
newRow["shares"] = sampleArray[i].shares;
newRow["traderName"] = sampleArray[i].traderName;
ds.Tables[0].Rows.Add(newRow);
}
da.Update(ds);
Console.WriteLine("Inserted " + sampleArray.Length + " item(s) via ADO.NET successfully.");
totalTime = DateTime.Now.Ticks - startTime;
}
catch (Exception e)
{
Console.WriteLine("There was a problem storing items using ADO.NET.\n" + e);
}
return(totalTime / TimeSpan.TicksPerMillisecond);
}
