public void Insert(MemberInfo data)
{
try
{
using (var db = newSQLiteConnection(path))
{
(data);
}
}
catch(Exception e)
{
throw e;
}
}
publicvoid Delete(int id)
{
try
{
T data = Select(id);
using (var db = newSQLiteConnection(path))
{
(data);
}
}
catch(Exception e)
{
throw e;
}
}
public void Insert(T data)
{
try
{
using (var db = newSQLiteConnection(path))
{
(data);
}
}
catch(Exception e)
{
throw e;
}
}
publicvoid Delete(int id)
{
try
{
T data = Select(id);
using (var db = newSQLiteConnection(path))
{
(data);
}
}
catch(Exception e)
{
throw e;
}
}
public MemberInfo Select(int id)
{
try
{
MemberInfo data = null;
using (var db = newSQLiteConnection(path))
{
List<object> obj = (newTableMapping(typeof(MemberInfo)), ("Select * from MemberInfo where ID={0}", id));
if (obj != null&&>0)
{
data = obj[0] as MemberInfo;
}
}
return data;
}
catch (Exception e)
{
throw e;
}
}
publicvoid Updata(MemberInfo data)
{
try
{
using (var db = newSQLiteConnection(path))
{
(data);
}
}
catch(Exception e)
{
throw e;
}
}
publicObservableCollection<MemberInfo> SelectAll()
{
ObservableCollection<MemberInfo> list = newObservableCollection<MemberInfo>();
using (var db =newSQLiteConnection(path))
{
List<object> query = (newTableMapping(typeof(MemberInfo)), "select * from MemberInfo");
foreach (var mem in query)
{
MemberInfo info = mem asMemberInfo;
(info);
}
}
return list;
}