//查格口状态 public bool SelectState(string plcid, string code) { try { DataTable tb = new DataTable(); string sqlStr = "SELECT * FROM t_prot where prot=(select prot from t_djmx WHERE ExpressNo='" + code + "'and plcid='" + plcid + "') "; tb = SqliteDbHelp.Query(sqlStr, null); if (tb != null) { if (tb.Rows.Count > 0) { if (tb.Rows[0]["sts"].ToString() == "0") { return(false); } else { return(true); } } } return(false); } catch (Exception ex) { return(false); } }
public DataTable SelectOldData() { string selectStr = "select ExpressNo,plcid from t_djmx order by djsj desc limit 0,5 "; try { //DataSet data = SqliteDbHelp.ExecuteDataSet(sqlStr); DataTable currentDt = SqliteDbHelp.Query(selectStr, null); return(currentDt); } catch (Exception ex) { return(null); } }
//查询格口号状态为 1或2的格口 public DataTable GetProtSend() { //1代表还没传送给WMS 2代表已经传送给WMS string sqlStr = "select * from t_prot where datasts='1' "; try { DataTable currentDt = SqliteDbHelp.Query(sqlStr, null); return(currentDt); } catch (Exception ex) { return(null); } }
//查询前200条条码数据 public DataTable TwohundredData() { string selectStr = "select * from t_djmx order by djsj desc limit 0,100 "; //string sqlStr = "select top 200 * from t_djmx order by djsj desc ;select prot,(case sts when '0' then'解锁' when '1' then '锁定' end) sts,count from t_prot "; try { DataTable currentDt = SqliteDbHelp.Query(selectStr, null); return(currentDt); } catch (Exception ex) { return(null); } }
//查询格口状态、数量 public DataTable GetTaskData() { string selectStr = "select prot,(case sts when '0' then'解锁' when '1' then '锁定' end) sts,count from t_prot "; //string sqlStr = "select top 200 * from t_djmx order by djsj desc ;select prot,(case sts when '0' then'解锁' when '1' then '锁定' end) sts,count from t_prot "; try { //DataSet data = SqliteDbHelp.ExecuteDataSet(sqlStr); DataTable currentDt = SqliteDbHelp.Query(selectStr, null); return(currentDt); } catch (Exception ex) { return(null); } }
//查询实际格口是否写入 public DataTable MatchingData() { lock (this) { //1代表还没匹配到DB块的值 2代表已经匹配到值 string sqlStr = "Select * from t_protstate where state='1' "; try { DataTable currentDt = SqliteDbHelp.Query(sqlStr, null); return(currentDt); } catch (Exception ex) { return(null); } } }
// 根据 快递单号模糊查询 public DataTable queryByExpressNo(string expressNo, string start, string end) { DataTable tb = new DataTable(); try { string sqlStr = "select * from t_djmx where ExpressNo like '%" + expressNo + "' " + " and (djsj between '" + start + "' and '" + end + "') order by djsj desc"; tb = SqliteDbHelp.Query(sqlStr, null); return(tb); } catch (Exception ex) { //SystemCommon.WriteLog("异常:" + ex.Message.ToString()); return(null); } }
public DataTable GetPlcSednCode() { lock (this) { //1代表还没传送给WMS 2代表已经传送给WMS string sqlStr = "Select * from t_djmx where endsts='1' "; try { DataTable currentDt = SqliteDbHelp.Query(sqlStr, null); return(currentDt); } catch (Exception ex) { //SystemCommon.WriteLog("异常:" + ex.Message.ToString()); return(null); } } }