public static void Delete(PinTuo entity)
{
string sql = string.Empty;
sql = "delete from pintuo where sn='" + entity.Sn + "'";
SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery(sql);
}
public static bool CheckExists(PinTuo entity)
{
string sql = string.Empty;
sql = "select * from pintuo where sn='" + entity.Sn + "'";
DataTable dt = SqliteDbFactory.GetSqliteDbOperator().SelectFromSql(sql);
return dt != null && dt.Rows.Count == 1;
}
public static bool CheckExists(PinTuo entity)
{
string sql = string.Empty;
sql = "select * from pintuo where sn='" + entity.Sn + "'";
DataTable dt = SqliteDbFactory.GetSqliteDbOperator().SelectFromSql(sql);
return(dt != null && dt.Rows.Count == 1);
}
/*
create table pintuo(id integer primary key autoincrement,
* tph varchar(20),sn varchar(20),wz varchar(30),
* xxjh varchar(20),scaner varchar(30),scantime datetime);
*/
public static void Save(PinTuo entity)
{
string sql = string.Empty;
sql = "insert into pintuo(tph,sn,xxjh,wz,scaner,scantime) values('" +
entity.Tph + "','" + entity.Sn + "','" +entity.Xxjh+"','"+
entity.Wz + "','" + entity.Scaner + "','" +
System.DateTime.Now.ToString("s")
+ "')";
SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery(sql);
}
private PinTuo ComputeData()
{
PinTuo pintuo = new PinTuo();
pintuo.Sn = this.txt_SN.Text.Trim();
pintuo.Tph = this.txt_TrayNo.Text.Trim();
pintuo.Wz = this.txt_Location.Text.Trim();
pintuo.Xxjh = this.txt_XiaXiangJi.Text.Trim();
pintuo.Scaner = Program.UserID;
pintuo.date = System.DateTime.Now;
return pintuo;
}
/*
* create table pintuo(id integer primary key autoincrement,
* tph varchar(20),sn varchar(20),wz varchar(30),
* xxjh varchar(20),scaner varchar(30),scantime datetime);
*/
public static void Save(PinTuo entity)
{
string sql = string.Empty;
sql = "insert into pintuo(tph,sn,xxjh,wz,scaner,scantime) values('" +
entity.Tph + "','" + entity.Sn + "','" + entity.Xxjh + "','" +
entity.Wz + "','" + entity.Scaner + "','" +
System.DateTime.Now.ToString("s")
+ "')";
SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery(sql);
}
public static void Delete(PinTuo entity)
{
string sql = string.Empty;
sql = "delete from pintuo where sn='" + entity.Sn + "'";
SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery(sql);
}
