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