public int InsertIndihiang(Indihiang.DomainObject.Indihiang obj)
{
SQLiteConnection con = null;
int id = -1;
try
{
con = new SQLiteConnection(GetConnectionStrng());
con.Open();
string query = String.Format("insert into sys_indihiang(sys_item,sys_value) values('{0}','{1}')", obj.Sys_Item, obj.Sys_Value);
using (SQLiteCommand cmd = new SQLiteCommand(query, con))
{
cmd.ExecuteNonQuery();
}
}
catch (Exception err)
{
System.Diagnostics.Debug.WriteLine(err.StackTrace);
}
finally
{
if (con != null)
{
con.Close();
}
}
return(id);
}
public static void InitialIndihiangFile(string file, string year)
{
try
{
DataHelper helper = new DataHelper(file);
Indihiang.DomainObject.Indihiang obj = new Indihiang.DomainObject.Indihiang();
obj.Sys_Item = "indihiang_version";
obj.Sys_Value = Assembly.GetExecutingAssembly().GetName().Version.ToString();
helper.InsertIndihiang(obj);
obj = new Indihiang.DomainObject.Indihiang();
obj.Sys_Item = "dotnet_version";
obj.Sys_Value = Environment.Version.ToString();
helper.InsertIndihiang(obj);
obj = new Indihiang.DomainObject.Indihiang();
obj.Sys_Item = "hostname";
obj.Sys_Value = Environment.MachineName;
helper.InsertIndihiang(obj);
obj = new Indihiang.DomainObject.Indihiang();
obj.Sys_Item = "username";
obj.Sys_Value = Environment.UserName;
helper.InsertIndihiang(obj);
obj = new Indihiang.DomainObject.Indihiang();
obj.Sys_Item = "os_version";
obj.Sys_Value = Environment.OSVersion.VersionString;
helper.InsertIndihiang(obj);
obj = new Indihiang.DomainObject.Indihiang();
obj.Sys_Item = "working_directory";
obj.Sys_Value = Environment.CurrentDirectory;
helper.InsertIndihiang(obj);
obj = new Indihiang.DomainObject.Indihiang();
obj.Sys_Item = "data_year";
obj.Sys_Value = year;
helper.InsertIndihiang(obj);
obj = new Indihiang.DomainObject.Indihiang();
obj.Sys_Item = "last_acces";
obj.Sys_Value = DateTime.Now.ToString();
helper.InsertIndihiang(obj);
}
catch (Exception) { }
}
public List <Indihiang.DomainObject.Indihiang> GetAllIndihiang()
{
SQLiteConnection con = null;
SQLiteDataReader rd = null;
List <Indihiang.DomainObject.Indihiang> list = new List <Indihiang.DomainObject.Indihiang>();
try
{
con = new SQLiteConnection(GetConnectionStrng());
con.Open();
string query = "select * from sys_indihiang";
SQLiteCommand cmd = new SQLiteCommand(query, con);
rd = cmd.ExecuteReader();
while (rd.Read())
{
Indihiang.DomainObject.Indihiang obj = new Indihiang.DomainObject.Indihiang();
if (!rd.IsDBNull(rd.GetOrdinal("id")))
{
obj.Id = Convert.ToInt32(rd["id"].ToString());
}
else
{
obj.Id = -1;
}
if (!rd.IsDBNull(rd.GetOrdinal("sys_item")))
{
obj.Sys_Item = (string)rd["sys_item"];
}
else
{
obj.Sys_Item = "";
}
if (!rd.IsDBNull(rd.GetOrdinal("sys_value")))
{
obj.Sys_Value = (string)rd["sys_value"];
}
else
{
obj.Sys_Value = "";
}
list.Add(obj);
}
}
catch (Exception err)
{
System.Diagnostics.Debug.WriteLine(err.StackTrace);
}
finally
{
if (rd != null)
{
rd.Close();
}
if (con != null)
{
con.Close();
}
}
return(list);
}
