public static void Delete(JieTuo entity) { string sql = string.Empty; sql = "delete from jietuo where tph='" + entity.Tph + "' and sn='" + entity.Sn + "' and iswhole="+ entity.IsWhole+" and scaner='" + entity.Scaner + "'"; SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery(sql); }
public static void Delete(JieTuo entity) { string sql = string.Empty; sql = "delete from jietuo where tph='" + entity.Tph + "' and sn='" + entity.Sn + "' and iswhole=" + entity.IsWhole + " and scaner='" + entity.Scaner + "'"; SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery(sql); }
private JieTuo ComputeData() { JieTuo entity = new JieTuo(); entity.IsWhole = this.cb_AllTary.Checked ? 1 : 0; entity.Sn = this.txt_SN.Text.Trim(); entity.Tph = this.txt_TrayNo.Text.Trim(); entity.Scaner = Program.UserID; entity.date = System.DateTime.Now; return entity; }
public static bool CheckExists(JieTuo entity) { string sql = string.Empty; sql = "select * from jietuo where tph='" + entity.Tph + "' and sn='" + entity.Sn + "' and iswhole=" + entity.IsWhole + " and scaner='" + entity.Scaner + "'"; DataTable dt = SqliteDbFactory.GetSqliteDbOperator().SelectFromSql(sql); return dt != null && dt.Rows.Count == 1; }
/* create table jietuo(id integer primary key autoincrement, * tph varchar(20),sn varchar(20),iswhole integer, * scaner varchar(30),scantime datetime); */ public static void Save(JieTuo entity) { string sql = string.Empty; sql = "insert into jietuo(tph,sn,iswhole,scaner,scantime) values('" + entity.Tph + "','" + entity.Sn + "',"+entity.IsWhole+",'" + entity.Scaner + "','" + System.DateTime.Now.ToString("s") + "')"; //MessageBox.Show(sql); SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery(sql); }
public static bool CheckExists(JieTuo entity) { string sql = string.Empty; sql = "select * from jietuo where tph='" + entity.Tph + "' and sn='" + entity.Sn + "' and iswhole=" + entity.IsWhole + " and scaner='" + entity.Scaner + "'"; DataTable dt = SqliteDbFactory.GetSqliteDbOperator().SelectFromSql(sql); return(dt != null && dt.Rows.Count == 1); }
/* * create table jietuo(id integer primary key autoincrement, * tph varchar(20),sn varchar(20),iswhole integer, * scaner varchar(30),scantime datetime); */ public static void Save(JieTuo entity) { string sql = string.Empty; sql = "insert into jietuo(tph,sn,iswhole,scaner,scantime) values('" + entity.Tph + "','" + entity.Sn + "'," + entity.IsWhole + ",'" + entity.Scaner + "','" + System.DateTime.Now.ToString("s") + "')"; //MessageBox.Show(sql); SqliteDbFactory.GetSqliteDbOperator().ExecuteNonQuery(sql); }