/// <summary>
///
/// </summary>
/// <param name="data"></param>
internal void InsertXd100eData(int deviceID, Xd100eData data)
{
string columns = //string.Empty;
"DeviceID, DT,";
string values = // string.Empty;
string.Format("{0}, '{1}',", deviceID, data.DT.ToString());
for (int i = Xd100eData.BeginChannelNO; i <= Xd100eData.EndChannelNO; i++)
{
columns += "ai" + i + ",";
values += data.GetChannelDataAI(i).ToString() + ",";
columns += "di" + i + ",";
values += (data.GetChannelDataDI(i) ? "1" : "0") + ",";
}
columns += "ir,sr,REx,";
values += string.Format("{0}, {1}, '{2}',", data.IR, data.SR, data.REx);
//
//
columns += "if1, sf1, ih1, sh1,";
values += string.Format("{0}, {1}, {2}, {3},", data.IF1, data.SF1, data.IH1, data.SH1);
columns = RemoveLastChar(columns);
values = RemoveLastChar(values);
string s = string.Format("insert into tblXd100eData({0}) values({1})", columns, values);
ExecuteScalar(s);
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
internal void InsertXd100eData(int deviceID, Xd100eData data)
{
string columns = //string.Empty;
"DeviceID, DT,";
string values =// string.Empty;
string.Format("{0}, '{1}',", deviceID, data.DT.ToString());
for (int i = Xd100eData.BeginChannelNO; i <= Xd100eData.EndChannelNO; i++)
{
columns += "ai" + i + ",";
values += data.GetChannelDataAI(i).ToString() + ",";
columns += "di" + i + ",";
values += (data.GetChannelDataDI(i) ? "1" : "0") + ",";
}
columns += "ir,sr,REx,";
values += string.Format("{0}, {1}, '{2}',", data.IR, data.SR, data.REx);
//
//
columns += "if1, sf1, ih1, sh1,";
values += string.Format("{0}, {1}, {2}, {3},", data.IF1, data.SF1, data.IH1, data.SH1);
columns = RemoveLastChar(columns);
values = RemoveLastChar(values);
string s = string.Format("insert into tblXd100eData({0}) values({1})", columns, values);
ExecuteScalar(s);
}
