public static SqlDataReader ReaderSelect(ExDataData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from ExData ");
return(WFNetLib.ADO.SQLServerOP.ReaderExecuteSQL(sql.ToString()));
}
public static ExDataData Construct(DataTable dt, int rowIndex)
{
ExDataData data = new ExDataData();
if (dt.Rows.Count < rowIndex + 1)
{
return(null);
}
DataRow dr = dt.Rows[rowIndex];
if (dr == null)
{
return(null);
}
try { data.ExID = Convert.ToInt32(dr["ExID"]); }
catch { }
try { data.DataTime = Convert.ToDateTime(dr["DataTime"]); }
catch { }
try { data.AI01 = Convert.ToDouble(dr["AI01"]); }
catch { }
try { data.AI02 = Convert.ToDouble(dr["AI02"]); }
catch { }
try { data.AI03 = Convert.ToDouble(dr["AI03"]); }
catch { }
try { data.AI04 = Convert.ToDouble(dr["AI04"]); }
catch { }
try { data.AI05 = Convert.ToDouble(dr["AI05"]); }
catch { }
try { data.AI06 = Convert.ToDouble(dr["AI06"]); }
catch { }
try { data.AI07 = Convert.ToDouble(dr["AI07"]); }
catch { }
try { data.AI08 = Convert.ToDouble(dr["AI08"]); }
catch { }
try { data.AI09 = Convert.ToDouble(dr["AI09"]); }
catch { }
try { data.AI10 = Convert.ToDouble(dr["AI10"]); }
catch { }
try { data.AI11 = Convert.ToDouble(dr["AI11"]); }
catch { }
try { data.AI12 = Convert.ToDouble(dr["AI12"]); }
catch { }
try { data.AI13 = Convert.ToDouble(dr["AI13"]); }
catch { }
try { data.AI14 = Convert.ToDouble(dr["AI14"]); }
catch { }
try { data.AI15 = Convert.ToDouble(dr["AI15"]); }
catch { }
try { data.AI16 = Convert.ToDouble(dr["AI16"]); }
catch { }
try { data.AI17 = Convert.ToDouble(dr["AI17"]); }
catch { }
try { data.AI18 = Convert.ToDouble(dr["AI18"]); }
catch { }
try { data.AI19 = Convert.ToDouble(dr["AI19"]); }
catch { }
try { data.AI20 = Convert.ToDouble(dr["AI20"]); }
catch { }
try { data.AI21 = Convert.ToDouble(dr["AI21"]); }
catch { }
try { data.AI22 = Convert.ToDouble(dr["AI22"]); }
catch { }
try { data.AI23 = Convert.ToDouble(dr["AI23"]); }
catch { }
try { data.AI24 = Convert.ToDouble(dr["AI24"]); }
catch { }
try { data.AI25 = Convert.ToDouble(dr["AI25"]); }
catch { }
try { data.AI26 = Convert.ToDouble(dr["AI26"]); }
catch { }
try { data.AI27 = Convert.ToDouble(dr["AI27"]); }
catch { }
try { data.AI28 = Convert.ToDouble(dr["AI28"]); }
catch { }
try { data.AI29 = Convert.ToDouble(dr["AI29"]); }
catch { }
try { data.AI30 = Convert.ToDouble(dr["AI30"]); }
catch { }
try { data.AI31 = Convert.ToDouble(dr["AI31"]); }
catch { }
try { data.AI32 = Convert.ToDouble(dr["AI32"]); }
catch { }
try { data.AI33 = Convert.ToDouble(dr["AI33"]); }
catch { }
try { data.AI34 = Convert.ToDouble(dr["AI34"]); }
catch { }
try { data.AI35 = Convert.ToDouble(dr["AI35"]); }
catch { }
try { data.AI36 = Convert.ToDouble(dr["AI36"]); }
catch { }
try { data.AI37 = Convert.ToDouble(dr["AI37"]); }
catch { }
try { data.AI38 = Convert.ToDouble(dr["AI38"]); }
catch { }
try { data.AI39 = Convert.ToDouble(dr["AI39"]); }
catch { }
try { data.AI40 = Convert.ToDouble(dr["AI40"]); }
catch { }
try { data.AI41 = Convert.ToDouble(dr["AI41"]); }
catch { }
try { data.AI42 = Convert.ToDouble(dr["AI42"]); }
catch { }
try { data.AI43 = Convert.ToDouble(dr["AI43"]); }
catch { }
try { data.AI44 = Convert.ToDouble(dr["AI44"]); }
catch { }
try { data.AI45 = Convert.ToDouble(dr["AI45"]); }
catch { }
try { data.AI46 = Convert.ToDouble(dr["AI46"]); }
catch { }
try { data.AI47 = Convert.ToDouble(dr["AI47"]); }
catch { }
try { data.AI48 = Convert.ToDouble(dr["AI48"]); }
catch { }
try { data.AI49 = Convert.ToDouble(dr["AI49"]); }
catch { }
try { data.AI50 = Convert.ToDouble(dr["AI50"]); }
catch { }
try { data.AI51 = Convert.ToDouble(dr["AI51"]); }
catch { }
try { data.AI52 = Convert.ToDouble(dr["AI52"]); }
catch { }
try { data.AI53 = Convert.ToDouble(dr["AI53"]); }
catch { }
try { data.AI54 = Convert.ToDouble(dr["AI54"]); }
catch { }
try { data.AI55 = Convert.ToDouble(dr["AI55"]); }
catch { }
try { data.AI56 = Convert.ToDouble(dr["AI56"]); }
catch { }
try { data.AI57 = Convert.ToDouble(dr["AI57"]); }
catch { }
try { data.AI58 = Convert.ToDouble(dr["AI58"]); }
catch { }
try { data.AI59 = Convert.ToDouble(dr["AI59"]); }
catch { }
try { data.AI60 = Convert.ToDouble(dr["AI60"]); }
catch { }
try { data.AI61 = Convert.ToDouble(dr["AI61"]); }
catch { }
try { data.AI62 = Convert.ToDouble(dr["AI62"]); }
catch { }
try { data.AI63 = Convert.ToDouble(dr["AI63"]); }
catch { }
try { data.AI64 = Convert.ToDouble(dr["AI64"]); }
catch { }
return(data);
}
public static ExDataData Construct(IDataReader reader)
{
ExDataData data = new ExDataData();
try { data.ExID = Convert.ToInt32(reader["ExID"]); }
catch { }
try { data.DataTime = Convert.ToDateTime(reader["DataTime"]); }
catch { }
try { data.AI01 = Convert.ToDouble(reader["AI01"]); }
catch { }
try { data.AI02 = Convert.ToDouble(reader["AI02"]); }
catch { }
try { data.AI03 = Convert.ToDouble(reader["AI03"]); }
catch { }
try { data.AI04 = Convert.ToDouble(reader["AI04"]); }
catch { }
try { data.AI05 = Convert.ToDouble(reader["AI05"]); }
catch { }
try { data.AI06 = Convert.ToDouble(reader["AI06"]); }
catch { }
try { data.AI07 = Convert.ToDouble(reader["AI07"]); }
catch { }
try { data.AI08 = Convert.ToDouble(reader["AI08"]); }
catch { }
try { data.AI09 = Convert.ToDouble(reader["AI09"]); }
catch { }
try { data.AI10 = Convert.ToDouble(reader["AI10"]); }
catch { }
try { data.AI11 = Convert.ToDouble(reader["AI11"]); }
catch { }
try { data.AI12 = Convert.ToDouble(reader["AI12"]); }
catch { }
try { data.AI13 = Convert.ToDouble(reader["AI13"]); }
catch { }
try { data.AI14 = Convert.ToDouble(reader["AI14"]); }
catch { }
try { data.AI15 = Convert.ToDouble(reader["AI15"]); }
catch { }
try { data.AI16 = Convert.ToDouble(reader["AI16"]); }
catch { }
try { data.AI17 = Convert.ToDouble(reader["AI17"]); }
catch { }
try { data.AI18 = Convert.ToDouble(reader["AI18"]); }
catch { }
try { data.AI19 = Convert.ToDouble(reader["AI19"]); }
catch { }
try { data.AI20 = Convert.ToDouble(reader["AI20"]); }
catch { }
try { data.AI21 = Convert.ToDouble(reader["AI21"]); }
catch { }
try { data.AI22 = Convert.ToDouble(reader["AI22"]); }
catch { }
try { data.AI23 = Convert.ToDouble(reader["AI23"]); }
catch { }
try { data.AI24 = Convert.ToDouble(reader["AI24"]); }
catch { }
try { data.AI25 = Convert.ToDouble(reader["AI25"]); }
catch { }
try { data.AI26 = Convert.ToDouble(reader["AI26"]); }
catch { }
try { data.AI27 = Convert.ToDouble(reader["AI27"]); }
catch { }
try { data.AI28 = Convert.ToDouble(reader["AI28"]); }
catch { }
try { data.AI29 = Convert.ToDouble(reader["AI29"]); }
catch { }
try { data.AI30 = Convert.ToDouble(reader["AI30"]); }
catch { }
try { data.AI31 = Convert.ToDouble(reader["AI31"]); }
catch { }
try { data.AI32 = Convert.ToDouble(reader["AI32"]); }
catch { }
try { data.AI33 = Convert.ToDouble(reader["AI33"]); }
catch { }
try { data.AI34 = Convert.ToDouble(reader["AI34"]); }
catch { }
try { data.AI35 = Convert.ToDouble(reader["AI35"]); }
catch { }
try { data.AI36 = Convert.ToDouble(reader["AI36"]); }
catch { }
try { data.AI37 = Convert.ToDouble(reader["AI37"]); }
catch { }
try { data.AI38 = Convert.ToDouble(reader["AI38"]); }
catch { }
try { data.AI39 = Convert.ToDouble(reader["AI39"]); }
catch { }
try { data.AI40 = Convert.ToDouble(reader["AI40"]); }
catch { }
try { data.AI41 = Convert.ToDouble(reader["AI41"]); }
catch { }
try { data.AI42 = Convert.ToDouble(reader["AI42"]); }
catch { }
try { data.AI43 = Convert.ToDouble(reader["AI43"]); }
catch { }
try { data.AI44 = Convert.ToDouble(reader["AI44"]); }
catch { }
try { data.AI45 = Convert.ToDouble(reader["AI45"]); }
catch { }
try { data.AI46 = Convert.ToDouble(reader["AI46"]); }
catch { }
try { data.AI47 = Convert.ToDouble(reader["AI47"]); }
catch { }
try { data.AI48 = Convert.ToDouble(reader["AI48"]); }
catch { }
try { data.AI49 = Convert.ToDouble(reader["AI49"]); }
catch { }
try { data.AI50 = Convert.ToDouble(reader["AI50"]); }
catch { }
try { data.AI51 = Convert.ToDouble(reader["AI51"]); }
catch { }
try { data.AI52 = Convert.ToDouble(reader["AI52"]); }
catch { }
try { data.AI53 = Convert.ToDouble(reader["AI53"]); }
catch { }
try { data.AI54 = Convert.ToDouble(reader["AI54"]); }
catch { }
try { data.AI55 = Convert.ToDouble(reader["AI55"]); }
catch { }
try { data.AI56 = Convert.ToDouble(reader["AI56"]); }
catch { }
try { data.AI57 = Convert.ToDouble(reader["AI57"]); }
catch { }
try { data.AI58 = Convert.ToDouble(reader["AI58"]); }
catch { }
try { data.AI59 = Convert.ToDouble(reader["AI59"]); }
catch { }
try { data.AI60 = Convert.ToDouble(reader["AI60"]); }
catch { }
try { data.AI61 = Convert.ToDouble(reader["AI61"]); }
catch { }
try { data.AI62 = Convert.ToDouble(reader["AI62"]); }
catch { }
try { data.AI63 = Convert.ToDouble(reader["AI63"]); }
catch { }
try { data.AI64 = Convert.ToDouble(reader["AI64"]); }
catch { }
return(data);
}
public static int Insert(ExDataData d)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ExData (");
sql.Append("ExID, ");
sql.Append("DataTime, ");
sql.Append("AI01, ");
sql.Append("AI02, ");
sql.Append("AI03, ");
sql.Append("AI04, ");
sql.Append("AI05, ");
sql.Append("AI06, ");
sql.Append("AI07, ");
sql.Append("AI08, ");
sql.Append("AI09, ");
sql.Append("AI10, ");
sql.Append("AI11, ");
sql.Append("AI12, ");
sql.Append("AI13, ");
sql.Append("AI14, ");
sql.Append("AI15, ");
sql.Append("AI16, ");
sql.Append("AI17, ");
sql.Append("AI18, ");
sql.Append("AI19, ");
sql.Append("AI20, ");
sql.Append("AI21, ");
sql.Append("AI22, ");
sql.Append("AI23, ");
sql.Append("AI24, ");
sql.Append("AI25, ");
sql.Append("AI26, ");
sql.Append("AI27, ");
sql.Append("AI28, ");
sql.Append("AI29, ");
sql.Append("AI30, ");
sql.Append("AI31, ");
sql.Append("AI32, ");
sql.Append("AI33, ");
sql.Append("AI34, ");
sql.Append("AI35, ");
sql.Append("AI36, ");
sql.Append("AI37, ");
sql.Append("AI38, ");
sql.Append("AI39, ");
sql.Append("AI40, ");
sql.Append("AI41, ");
sql.Append("AI42, ");
sql.Append("AI43, ");
sql.Append("AI44, ");
sql.Append("AI45, ");
sql.Append("AI46, ");
sql.Append("AI47, ");
sql.Append("AI48, ");
sql.Append("AI49, ");
sql.Append("AI50, ");
sql.Append("AI51, ");
sql.Append("AI52, ");
sql.Append("AI53, ");
sql.Append("AI54, ");
sql.Append("AI55, ");
sql.Append("AI56, ");
sql.Append("AI57, ");
sql.Append("AI58, ");
sql.Append("AI59, ");
sql.Append("AI60, ");
sql.Append("AI61, ");
sql.Append("AI62, ");
sql.Append("AI63, ");
sql.Append("AI64");
sql.Append(") values (");
sql.Append("");
sql.Append(d.ExID.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("'");
sql.Append(d.DataTime.ToString("yyyy-MM-dd HH:mm:ss"));
sql.Append("'");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI01.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI02.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI03.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI04.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI05.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI06.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI07.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI08.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI09.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI10.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI11.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI12.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI13.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI14.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI15.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI16.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI17.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI18.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI19.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI20.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI21.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI22.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI23.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI24.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI25.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI26.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI27.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI28.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI29.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI30.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI31.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI32.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI33.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI34.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI35.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI36.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI37.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI38.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI39.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI40.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI41.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI42.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI43.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI44.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI45.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI46.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI47.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI48.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI49.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI50.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI51.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI52.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI53.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI54.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI55.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI56.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI57.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI58.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI59.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI60.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI61.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI62.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI63.ToString());
sql.Append("");
sql.Append(", ");
sql.Append("");
sql.Append(d.AI64.ToString());
sql.Append("");
sql.Append(")");
return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString()));
}
