/// <summary>
/// An internal function to bind values parameters for insert
/// </summary>
/// <param name="parms">Database parameters</param>
/// <param name="RQ">Values to bind to parameters</param>
private void SetAdapterParameters(OracleParameter[] parms, Model.SewPeriodDataInfo ws)
{
parms[0].Value = ws.DEVID;
if (null != ws.UPTIME)
{
parms[1].Value = ws.UPTIME;
}
else
{
parms[1].Value = DBNull.Value;
}
if (null != ws.CO)
{
parms[2].Value = ws.CO;
}
else
{
parms[2].Value = DBNull.Value;
}
if (null != ws.O2)
{
parms[3].Value = ws.O2;
}
else
{
parms[3].Value = DBNull.Value;
}
if (null != ws.H2S)
{
parms[4].Value = ws.H2S;
}
else
{
parms[4].Value = DBNull.Value;
}
if (null != ws.FIREGAS)
{
parms[5].Value = ws.FIREGAS;
}
else
{
parms[5].Value = DBNull.Value;
}
}
/// <summary>
/// A method to insert a new Adapter
/// </summary>
/// <param name="rqs">An adapter entity with information about the new adapter</param>
public void insert(Model.SewPeriodDataInfo sew)
{
IDAL.ISewPeriodData dal = SensorHub.DALFactory.SewPeriodData.Create();
dal.insert(sew);
}
public override void ExecuteCommand(WSSession session, StringRequestInfo requestInfo)
{
try
{
//SewPeriodData：设备ID，上传时间，CO数据，O2氧气数据，H2S数据，可燃气体数据\r\n
session.Logger.Info("污水数据已经上传!");
session.Logger.Info(requestInfo.Body);
string[] bt = requestInfo.Body.Split(',');
if (string.IsNullOrEmpty(session.MacID))
{
session.MacID = bt[0];
}
Model.SewPeriodDataInfo sew = new Model.SewPeriodDataInfo();
sew.DEVID = bt[0];
//转换bt[1] 20131212101010 bug fix by predator
string sdate = bt[1].Substring(0, 4) + "-" + bt[1].Substring(4, 2) + "-" + bt[1].Substring(6, 2) + " " + bt[1].Substring(8, 2) + ":" + bt[1].Substring(10, 2) + ":" + bt[1].Substring(12, 2);
sew.UPTIME = Convert.ToDateTime(sdate);
sew.CO = bt[2];
sew.O2 = bt[3];
sew.H2S = bt[4];
sew.FIREGAS = bt[5];
new BLL.SewPeriodData().insert(sew);
//send the time calibrating cmd
/*
* string sdata = "SewTiming:" + bt[0]+","+DateTime.Now.ToString("yyyyMMddHHmmss");
* byte[] data = new byte[sdata.Length + 2];
* Encoding.ASCII.GetBytes(sdata, 0, sdata.Length, data, 0);
* data[sdata.Length] = 0x0D;
* data[sdata.Length + 1] = 0x0A;
* session.Send(data, 0, data.Length);
* */
//send the success cmd;
string sdata0 = "SewPeriodData:success";
byte[] data0 = new byte[sdata0.Length + 2];
Encoding.ASCII.GetBytes(sdata0, 0, sdata0.Length, data0, 0);
data0[sdata0.Length] = 0x0D;
data0[sdata0.Length + 1] = 0x0A;
session.Send(data0, 0, data0.Length);
//增加设备运行日志
BLL.DeviceLog bllLog = new DeviceLog();
BLL.Device bllDevice = new Device();
Model.DeviceLogInfo log = new Model.DeviceLogInfo();
log.DEVICE_ID = Convert.ToInt32(bllDevice.getDeviceIdByCode(session.MacID));
log.MESSAGE = "污水数据上报";
log.OPERATETYPE = "上报";
log.LOGTIME = DateTime.Now;
bllLog.insert(log);
}
catch (Exception e)
{
session.Logger.Error("污水数据保存失败!");
session.Logger.Error(e.ToString());
}
}
