public AlarmInfoForDB AlarmInfoToAlarmInfoForDB(int controlpadId, string controlpadName, AlarmInfo info)
{
if (info == null)
{
return(new AlarmInfoForDB());
}
AlarmInfoForDB db = new AlarmInfoForDB()
{
ControlPadId = controlpadId,
ControlPadName = controlpadName,
CameraId = info.CameraNo,
CameraName = info.CameraName,
X = info.X,
Y = info.Y,
InfoTime = DateTime.Parse(info.InfoTime)
};
return(db);
}
public int Add(AlarmInfoForDB info)
{
string sql = "insert into alarminfo (ControlPadId,ControlPadName,CameraId,CameraName,X,Y,InfoTime) values (@ControlPadId,@ControlPadName,@CameraId,@CameraName,@X,@Y,@InfoTime)";
return(helper.Execute(sql, info));
}
