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);
}
