public static ESLQueueData Construct(DataTable dt, int rowIndex) { ESLQueueData data = new ESLQueueData(); if (dt.Rows.Count < rowIndex + 1) { return(null); } DataRow dr = dt.Rows[rowIndex]; if (dr == null) { return(null); } try { data.IP = Convert.ToString(dr["IP"]); } catch { } try { data.Pass = Convert.ToString(dr["Pass"]); } catch { } try { data.sTime = Convert.ToDateTime(dr["sTime"]); } catch { } try { data.DeviceID = Convert.ToString(dr["DeviceID"]); } catch { } return(data); }
public static SqlDataReader ReaderSelect(ESLQueueData d) { StringBuilder sql = new StringBuilder(); sql.Append("select * from ESLQueue "); return(WFNetLib.ADO.SQLServerOP.ReaderExecuteSQL(sql.ToString())); }
public static int Insert(ESLQueueData d) { StringBuilder sql = new StringBuilder(); sql.Append("insert into ESLQueue ("); sql.Append("IP, "); sql.Append("Pass, "); sql.Append("sTime, "); sql.Append("DeviceID"); sql.Append(") values ("); sql.Append("'"); sql.Append(d.IP.ToString()); sql.Append("'"); sql.Append(", "); sql.Append("'"); sql.Append(d.Pass.ToString()); sql.Append("'"); sql.Append(", "); sql.Append("'"); sql.Append(d.sTime.ToString("yyyy-MM-dd HH:mm:ss")); sql.Append("'"); sql.Append(", "); sql.Append("'"); sql.Append(d.DeviceID.ToString()); sql.Append("'"); sql.Append(")"); return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString())); }
public static ESLQueueData Construct(IDataReader reader) { ESLQueueData data = new ESLQueueData(); try { data.IP = Convert.ToString(reader["IP"]); } catch { } try { data.Pass = Convert.ToString(reader["Pass"]); } catch { } try { data.sTime = Convert.ToDateTime(reader["sTime"]); } catch { } try { data.DeviceID = Convert.ToString(reader["DeviceID"]); } catch { } return(data); }