public static SqlDataReader ReaderSelect(KeyDataWorkLogData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from KeyDataWorkLog ");
return(WFNetLib.ADO.SQLServerOP.ReaderExecuteSQL(sql.ToString()));
}
public static DataTable DataTableSelect(KeyDataWorkLogData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from KeyDataWorkLog where QueueID=");
sql.Append("");
sql.Append(d.QueueID.ToString());
sql.Append("");
return(WFNetLib.ADO.SQLServerOP.DataTableSQL(sql.ToString()));
}
public static int Delete(KeyDataWorkLogData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("delete from KeyDataWorkLog ");
sql.Append(" where QueueID=");
sql.Append("");
sql.Append(d.QueueID.ToString());
sql.Append("");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
public static int Update(KeyDataWorkLogData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("update KeyDataWorkLog set ");
sql.Append("DeviceID=");
sql.Append("'");
sql.Append(d.DeviceID.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("SSID=");
sql.Append("'");
sql.Append(d.SSID.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("IP=");
sql.Append("'");
sql.Append(d.IP.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("sTime=");
sql.Append("'");
sql.Append(d.sTime.ToString("yyyy-MM-dd HH:mm:ss"));
sql.Append("'");
sql.Append(", ");
sql.Append("eTime=");
sql.Append("'");
sql.Append(d.eTime.ToString("yyyy-MM-dd HH:mm:ss"));
sql.Append("'");
sql.Append(", ");
sql.Append("bOK=");
sql.Append("");
if (d.bOK)
{
sql.Append("1");
}
else
{
sql.Append("0");
}
sql.Append("");
sql.Append(", ");
sql.Append("Key7_51=");
sql.Append("'");
sql.Append(d.Key7_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key6_51=");
sql.Append("'");
sql.Append(d.Key6_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key5_51=");
sql.Append("'");
sql.Append(d.Key5_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key4_51=");
sql.Append("'");
sql.Append(d.Key4_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key3_51=");
sql.Append("'");
sql.Append(d.Key3_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key2_51=");
sql.Append("'");
sql.Append(d.Key2_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key1_51=");
sql.Append("'");
sql.Append(d.Key1_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key0_51=");
sql.Append("'");
sql.Append(d.Key0_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key7_41=");
sql.Append("'");
sql.Append(d.Key7_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key6_41=");
sql.Append("'");
sql.Append(d.Key6_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key5_41=");
sql.Append("'");
sql.Append(d.Key5_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key4_41=");
sql.Append("'");
sql.Append(d.Key4_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key3_41=");
sql.Append("'");
sql.Append(d.Key3_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key2_41=");
sql.Append("'");
sql.Append(d.Key2_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key1_41=");
sql.Append("'");
sql.Append(d.Key1_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key0_41=");
sql.Append("'");
sql.Append(d.Key0_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key7_11=");
sql.Append("'");
sql.Append(d.Key7_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key6_11=");
sql.Append("'");
sql.Append(d.Key6_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key5_11=");
sql.Append("'");
sql.Append(d.Key5_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key4_11=");
sql.Append("'");
sql.Append(d.Key4_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key3_11=");
sql.Append("'");
sql.Append(d.Key3_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key2_11=");
sql.Append("'");
sql.Append(d.Key2_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key1_11=");
sql.Append("'");
sql.Append(d.Key1_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("Key0_11=");
sql.Append("'");
sql.Append(d.Key0_11.ToString());
sql.Append("'");
sql.Append(" where QueueID=");
sql.Append("");
sql.Append(d.QueueID.ToString()); sql.Append("");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
public static int Insert(KeyDataWorkLogData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into KeyDataWorkLog (");
sql.Append("QueueID,DeviceID, ");
sql.Append("SSID, ");
sql.Append("IP, ");
sql.Append("sTime, ");
sql.Append("eTime, ");
sql.Append("bOK, ");
sql.Append("Key7_51, ");
sql.Append("Key6_51, ");
sql.Append("Key5_51, ");
sql.Append("Key4_51, ");
sql.Append("Key3_51, ");
sql.Append("Key2_51, ");
sql.Append("Key1_51, ");
sql.Append("Key0_51, ");
sql.Append("Key7_41, ");
sql.Append("Key6_41, ");
sql.Append("Key5_41, ");
sql.Append("Key4_41, ");
sql.Append("Key3_41, ");
sql.Append("Key2_41, ");
sql.Append("Key1_41, ");
sql.Append("Key0_41, ");
sql.Append("Key7_11, ");
sql.Append("Key6_11, ");
sql.Append("Key5_11, ");
sql.Append("Key4_11, ");
sql.Append("Key3_11, ");
sql.Append("Key2_11, ");
sql.Append("Key1_11, ");
sql.Append("Key0_11");
sql.Append(") values (");
sql.Append(d.QueueID.ToString());
sql.Append(",");
sql.Append("'");
sql.Append(d.DeviceID.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.SSID.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.IP.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.eTime.ToString("yyyy-MM-dd HH:mm:ss"));
sql.Append("'");
sql.Append(", ");
sql.Append("");
if (d.bOK)
{
sql.Append("1");
}
else
{
sql.Append("0");
}
sql.Append("");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key7_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key6_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key5_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key4_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key3_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key2_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key1_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key0_51.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key7_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key6_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key5_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key4_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key3_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key2_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key1_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key0_41.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key7_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key6_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key5_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key4_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key3_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key2_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key1_11.ToString());
sql.Append("'");
sql.Append(", ");
sql.Append("'");
sql.Append(d.Key0_11.ToString());
sql.Append("'");
sql.Append(")");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
public static KeyDataWorkLogData Construct(DataRow dr)
{
KeyDataWorkLogData data = new KeyDataWorkLogData();
try { data.DeviceID = Convert.ToString(dr["DeviceID"]); }
catch { }
try { data.SSID = Convert.ToString(dr["SSID"]); }
catch { }
try { data.IP = Convert.ToString(dr["IP"]); }
catch { }
try { data.QueueID = Convert.ToInt32(dr["QueueID"]); }
catch { }
try { data.sTime = Convert.ToDateTime(dr["sTime"]); }
catch { }
try { data.eTime = Convert.ToDateTime(dr["eTime"]); }
catch { }
try { data.bOK = Convert.ToBoolean(dr["bOK"]); }
catch { }
try { data.Key7_51 = Convert.ToString(dr["Key7_51"]); }
catch { }
try { data.Key6_51 = Convert.ToString(dr["Key6_51"]); }
catch { }
try { data.Key5_51 = Convert.ToString(dr["Key5_51"]); }
catch { }
try { data.Key4_51 = Convert.ToString(dr["Key4_51"]); }
catch { }
try { data.Key3_51 = Convert.ToString(dr["Key3_51"]); }
catch { }
try { data.Key2_51 = Convert.ToString(dr["Key2_51"]); }
catch { }
try { data.Key1_51 = Convert.ToString(dr["Key1_51"]); }
catch { }
try { data.Key0_51 = Convert.ToString(dr["Key0_51"]); }
catch { }
try { data.Key7_41 = Convert.ToString(dr["Key7_41"]); }
catch { }
try { data.Key6_41 = Convert.ToString(dr["Key6_41"]); }
catch { }
try { data.Key5_41 = Convert.ToString(dr["Key5_41"]); }
catch { }
try { data.Key4_41 = Convert.ToString(dr["Key4_41"]); }
catch { }
try { data.Key3_41 = Convert.ToString(dr["Key3_41"]); }
catch { }
try { data.Key2_41 = Convert.ToString(dr["Key2_41"]); }
catch { }
try { data.Key1_41 = Convert.ToString(dr["Key1_41"]); }
catch { }
try { data.Key0_41 = Convert.ToString(dr["Key0_41"]); }
catch { }
try { data.Key7_11 = Convert.ToString(dr["Key7_11"]); }
catch { }
try { data.Key6_11 = Convert.ToString(dr["Key6_11"]); }
catch { }
try { data.Key5_11 = Convert.ToString(dr["Key5_11"]); }
catch { }
try { data.Key4_11 = Convert.ToString(dr["Key4_11"]); }
catch { }
try { data.Key3_11 = Convert.ToString(dr["Key3_11"]); }
catch { }
try { data.Key2_11 = Convert.ToString(dr["Key2_11"]); }
catch { }
try { data.Key1_11 = Convert.ToString(dr["Key1_11"]); }
catch { }
try { data.Key0_11 = Convert.ToString(dr["Key0_11"]); }
catch { }
return(data);
}
public static KeyDataWorkLogData Construct(DataTable dt, int rowIndex)
{
KeyDataWorkLogData data = new KeyDataWorkLogData();
if (dt.Rows.Count < rowIndex + 1)
{
return(null);
}
DataRow dr = dt.Rows[rowIndex];
if (dr == null)
{
return(null);
}
try { data.DeviceID = Convert.ToString(dr["DeviceID"]); }
catch { }
try { data.SSID = Convert.ToString(dr["SSID"]); }
catch { }
try { data.IP = Convert.ToString(dr["IP"]); }
catch { }
try { data.QueueID = Convert.ToInt32(dr["QueueID"]); }
catch { }
try { data.sTime = Convert.ToDateTime(dr["sTime"]); }
catch { }
try { data.eTime = Convert.ToDateTime(dr["eTime"]); }
catch { }
try { data.bOK = Convert.ToBoolean(dr["bOK"]); }
catch { }
try { data.Key7_51 = Convert.ToString(dr["Key7_51"]); }
catch { }
try { data.Key6_51 = Convert.ToString(dr["Key6_51"]); }
catch { }
try { data.Key5_51 = Convert.ToString(dr["Key5_51"]); }
catch { }
try { data.Key4_51 = Convert.ToString(dr["Key4_51"]); }
catch { }
try { data.Key3_51 = Convert.ToString(dr["Key3_51"]); }
catch { }
try { data.Key2_51 = Convert.ToString(dr["Key2_51"]); }
catch { }
try { data.Key1_51 = Convert.ToString(dr["Key1_51"]); }
catch { }
try { data.Key0_51 = Convert.ToString(dr["Key0_51"]); }
catch { }
try { data.Key7_41 = Convert.ToString(dr["Key7_41"]); }
catch { }
try { data.Key6_41 = Convert.ToString(dr["Key6_41"]); }
catch { }
try { data.Key5_41 = Convert.ToString(dr["Key5_41"]); }
catch { }
try { data.Key4_41 = Convert.ToString(dr["Key4_41"]); }
catch { }
try { data.Key3_41 = Convert.ToString(dr["Key3_41"]); }
catch { }
try { data.Key2_41 = Convert.ToString(dr["Key2_41"]); }
catch { }
try { data.Key1_41 = Convert.ToString(dr["Key1_41"]); }
catch { }
try { data.Key0_41 = Convert.ToString(dr["Key0_41"]); }
catch { }
try { data.Key7_11 = Convert.ToString(dr["Key7_11"]); }
catch { }
try { data.Key6_11 = Convert.ToString(dr["Key6_11"]); }
catch { }
try { data.Key5_11 = Convert.ToString(dr["Key5_11"]); }
catch { }
try { data.Key4_11 = Convert.ToString(dr["Key4_11"]); }
catch { }
try { data.Key3_11 = Convert.ToString(dr["Key3_11"]); }
catch { }
try { data.Key2_11 = Convert.ToString(dr["Key2_11"]); }
catch { }
try { data.Key1_11 = Convert.ToString(dr["Key1_11"]); }
catch { }
try { data.Key0_11 = Convert.ToString(dr["Key0_11"]); }
catch { }
return(data);
}
