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