public RFIDInfo GetModel(string tID, string ePC) { RFIDInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 TID,EPC,LastUpdatedDate from RFID where TID = @TID and EPC = @EPC " ); SqlParameter[] parms = { new SqlParameter("@TID", SqlDbType.VarChar, 50), new SqlParameter("@EPC", SqlDbType.VarChar, 50) }; parms[0].Value = tID; parms[1].Value = ePC; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new RFIDInfo(); model.TID = reader.GetString(0); model.EPC = reader.GetString(1); model.LastUpdatedDate = reader.GetDateTime(2); } } } return(model); }
public IList <RFIDInfo> GetList() { StringBuilder sb = new StringBuilder(300); sb.Append(@"select TID,EPC,LastUpdatedDate from RFID order by LastUpdatedDate desc " ); IList <RFIDInfo> list = new List <RFIDInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { RFIDInfo model = new RFIDInfo(); model.TID = reader.GetString(0); model.EPC = reader.GetString(1); model.LastUpdatedDate = reader.GetDateTime(2); list.Add(model); } } } return(list); }
public IList <RFIDInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select TID,EPC,LastUpdatedDate from RFID "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.Append("order by LastUpdatedDate desc "); IList <RFIDInfo> list = new List <RFIDInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { RFIDInfo model = new RFIDInfo(); model.TID = reader.GetString(0); model.EPC = reader.GetString(1); model.LastUpdatedDate = reader.GetDateTime(2); list.Add(model); } } } return(list); }
public IList <RFIDInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber, TID,EPC,LastUpdatedDate from RFID " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <RFIDInfo> list = new List <RFIDInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { RFIDInfo model = new RFIDInfo(); model.TID = reader.GetString(1); model.EPC = reader.GetString(2); model.LastUpdatedDate = reader.GetDateTime(3); list.Add(model); } } } return(list); }
public IList <RFIDInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { var sb = new StringBuilder(500); sb.Append(@"select count(*) from RFID r left join Product p on p.ProductCode = r.EPC "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <RFIDInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by r.LastUpdatedDate desc) as RowNumber, r.TID,r.EPC,r.LastUpdatedDate,p.ProductName,p.FullName,p.Specs from RFID r left join Product p on p.ProductCode = r.EPC "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); var list = new List <RFIDInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { var model = new RFIDInfo(); model.TID = reader.GetString(1); model.EPC = reader.GetString(2); model.LastUpdatedDate = reader.GetDateTime(3); model.ProductName = reader.IsDBNull(4) ? "" : reader.GetString(4); model.FullName = reader.IsDBNull(5) ? "" : reader.GetString(5); model.Specs = reader.IsDBNull(6) ? "" : reader.GetString(6); list.Add(model); } } } return(list); }
public bool ReadRFID(string name, out string[] data) { if (RFIDInfo.ContainsKey(name)) { data = RFIDInfo[name]; RFIDInfo.Remove(name); return(true); } data = null; return(false); }
private void Engine_RFIDNewData(string arg1, string[] arg2) { try { if (RFIDInfo.Count == 0) { RFIDInfo.Add(arg1, arg2); } else { RFIDInfo[arg1] = arg2; } } catch (Exception) { throw; } }
private void SetRFID(RunQueueInfo model) { RFIDInfo info = JsonConvert.DeserializeObject <RFIDInfo>(model.RunValue); info.LastUpdatedDate = DateTime.Now; new CustomException(string.Format("info--:{0}", JsonConvert.SerializeObject(info))); var bll = new RFID(); var oldInfo = bll.GetModel(info.TID, info.EPC); if (oldInfo == null) { bll.Insert(info); } else { bll.Update(info); } }
public int Update(RFIDInfo model) { StringBuilder sb = new StringBuilder(500); sb.Append(@"update RFID set LastUpdatedDate = @LastUpdatedDate where TID = @TID and EPC = @EPC " ); SqlParameter[] parms = { new SqlParameter("@TID", SqlDbType.VarChar, 50), new SqlParameter("@EPC", SqlDbType.VarChar, 50), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.TID; parms[1].Value = model.EPC; parms[2].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms)); }
public int Insert(RFIDInfo model) { StringBuilder sb = new StringBuilder(300); sb.Append(@"insert into RFID (TID,EPC,LastUpdatedDate) values (@TID,@EPC,@LastUpdatedDate) " ); SqlParameter[] parms = { new SqlParameter("@TID", SqlDbType.VarChar, 50), new SqlParameter("@EPC", SqlDbType.VarChar, 50), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.TID; parms[1].Value = model.EPC; parms[2].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms)); }
public int Update(RFIDInfo model) { return(dal.Update(model)); }
public int Insert(RFIDInfo model) { return(dal.Insert(model)); }