public void Update(Zone zone)
{
OleDbHelper.ExecuteNonQuery("Main", @"UPDATE 防区资料
SET [主机编号]=@Account
,[防区编号]=@ZoneNum
,[分区编号]=@PartitionNum
,[防区类型]=@ZoneType
,[探测器型号]=@DetectorType
,[安装位置]=@InstallSide
,[防区状态]=@ZoneStatus
,[横坐标]=@Abscissa
,[纵坐标]=@Ordinate
,[防区状态更新时间]=@StatusRefreshTime
,[最近一次上报时间]=@EedEventTime
,[是否报警]=@IsAlarm
WHERE [序号]=@ID",
new OleDbParameter("@Account", OleDbHelper.ToDbValue(zone.Account)),
new OleDbParameter("@ZoneNum", OleDbHelper.ToDbValue(zone.ZoneNum)),
new OleDbParameter("@PartitionNum", OleDbHelper.ToDbValue(zone.PartitionNum)),
new OleDbParameter("@ZoneType", OleDbHelper.ToDbValue(zone.ZoneType)),
new OleDbParameter("@DetectorType", OleDbHelper.ToDbValue(zone.DetectorType)),
new OleDbParameter("@InstallSide", OleDbHelper.ToDbValue(zone.InstallSide)),
new OleDbParameter("@ZoneStatus", OleDbHelper.ToDbValue(zone.ZoneStatus)),
new OleDbParameter("@Abscissa", OleDbHelper.ToDbValue(zone.Abscissa)),
new OleDbParameter("@Ordinate", OleDbHelper.ToDbValue(zone.Ordinate)),
new OleDbParameter("@StatusRefreshTime", OleDbHelper.ToDbValue(zone.StatusRefreshTime)),
new OleDbParameter("@EedEventTime", OleDbHelper.ToDbValue(zone.EedEventTime)),
new OleDbParameter("@IsAlarm", OleDbHelper.ToDbValue(zone.IsAlarm)),
new OleDbParameter("@ID", OleDbHelper.ToDbValue(zone.ID)));
}
public void Update(User user)
{
OleDbHelper.ExecuteNonQuery("Main", @"UPDATE [用户资料]
SET 用户名称 = @UserName
,用户地址 = @Address
,主机编号 = @Account
,用户类型 = @UserType
,通讯格式 = @Protocol
,主机类型 = @PanelName
,安装人员 = @Installer
,安装日期 = @InstallDate
,安装单位 = @InstallCompany
,收费标准 = @Charge
,合同期限 = @Deadline
,备注说明 = @Mark
WHERE 序号=@ID",
new OleDbParameter("@Name", OleDbHelper.ToDbValue(user.UserName)),
new OleDbParameter("@Address", OleDbHelper.ToDbValue(user.Address)),
new OleDbParameter("@Account", OleDbHelper.ToDbValue(user.Account)),
new OleDbParameter("@UserType", OleDbHelper.ToDbValue(user.UserType)),
new OleDbParameter("@Protocol", OleDbHelper.ToDbValue(user.Protocol)),
new OleDbParameter("@PanelName", OleDbHelper.ToDbValue(user.PanelName)),
new OleDbParameter("@Installer", OleDbHelper.ToDbValue(user.Installer)),
new OleDbParameter("@InstallDate", OleDbHelper.ToDbValue(user.InstallDate)),
new OleDbParameter("@InstallCompany", OleDbHelper.ToDbValue(user.InstallCompany)),
new OleDbParameter("@Charge", OleDbHelper.ToDbValue(user.Charge)),
new OleDbParameter("@Deadline", OleDbHelper.ToDbValue(user.Deadline)),
new OleDbParameter("@Mark", OleDbHelper.ToDbValue(user.Mark)),
new OleDbParameter("@ID", OleDbHelper.ToDbValue(user.ID)));
}
public void Update(Receiver receiver)
{
OleDbHelper.ExecuteNonQuery("Main", @"UPDATE [串口设置]
SET [接警机名]=@ReceiverName
,[接警机类型]=@ReceiverType
,[版本号]=@Version
,[波特率]=@BaudRate
,[数据位]=@DataBits
,[停止位]=@StopBits
,[流控制]=@FlowControl
,[校验]=@Parity
,[结束代码]=@EndCode
,[握手代码]=@ACK
,[连接检查间隔]=@CheckTimer
,[是否检查连接]=@IsCheck
,[串口序号]=@SerialPortNum
,[备注]=@Mark
WHERE [序号]=@ID",
new OleDbParameter("@ReceiverName", OleDbHelper.ToDbValue(receiver.ReceiverName)),
new OleDbParameter("@ReceiverType", OleDbHelper.ToDbValue(receiver.ReceiverType)),
new OleDbParameter("@Version", OleDbHelper.ToDbValue(receiver.Version)),
new OleDbParameter("@BaudRate", OleDbHelper.ToDbValue(receiver.BaudRate)),
new OleDbParameter("@DataBits", OleDbHelper.ToDbValue(receiver.DataBits)),
new OleDbParameter("@StopBits", OleDbHelper.ToDbValue(receiver.StopBits)),
new OleDbParameter("@FlowControl", OleDbHelper.ToDbValue(receiver.FlowControl)),
new OleDbParameter("@Parity", OleDbHelper.ToDbValue(receiver.Parity)),
new OleDbParameter("@EndCode", OleDbHelper.ToDbValue(receiver.EndCode)),
new OleDbParameter("@ACK", OleDbHelper.ToDbValue(receiver.ACK)),
new OleDbParameter("@CheckTimer", OleDbHelper.ToDbValue(receiver.CheckTimer)),
new OleDbParameter("@IsCheck", OleDbHelper.ToDbValue(receiver.IsCheck)),
new OleDbParameter("@SerialPortNum", OleDbHelper.ToDbValue(receiver.SerialPortNum)),
new OleDbParameter("@Mark", OleDbHelper.ToDbValue(receiver.Mark)),
new OleDbParameter("@ID", OleDbHelper.ToDbValue(receiver.ID)));
}
public void Insert(Event e)
{
OleDbParameter[] parameters = new OleDbParameter[22];
parameters[0] = new OleDbParameter("@ID", OleDbHelper.ToDbValue(e.ID));
parameters[1] = new OleDbParameter("@UserName", OleDbHelper.ToDbValue(e.UserName));
parameters[2] = new OleDbParameter("@Address", OleDbHelper.ToDbValue(e.Address));
parameters[3] = new OleDbParameter("@Account", OleDbHelper.ToDbValue(e.Account));
parameters[4] = new OleDbParameter("@UserType", OleDbHelper.ToDbValue(e.UserType));
parameters[5] = new OleDbParameter("@PanelType", OleDbHelper.ToDbValue(e.PanelType));
parameters[6] = new OleDbParameter("@PartitionNumber", OleDbHelper.ToDbValue(e.PartitionNumber));
parameters[7] = new OleDbParameter("@ZoneNumber", OleDbHelper.ToDbValue(e.ZoneNumber));
parameters[8] = new OleDbParameter("@ZoneType", OleDbHelper.ToDbValue(e.ZoneType));
parameters[9] = new OleDbParameter("@DetectorType", OleDbHelper.ToDbValue(e.DetectorType));
parameters[10] = new OleDbParameter("@InstallSide", OleDbHelper.ToDbValue(e.InstallSide));
parameters[11] = new OleDbParameter("@EventTpye", OleDbHelper.ToDbValue(e.EventTpye));
parameters[12] = new OleDbParameter("@EventInfomation", OleDbHelper.ToDbValue(e.EventInfomation));
parameters[13] = new OleDbParameter("@Classify", OleDbHelper.ToDbValue(e.Classify));
parameters[14] = new OleDbParameter("@DataCode", OleDbHelper.ToDbValue(e.DataCode));
parameters[15] = new OleDbParameter("@MarkEvent", OleDbHelper.ToDbValue(e.MarkEvent));
parameters[16] = new OleDbParameter("@Operator", OleDbHelper.ToDbValue(e.Operator));
parameters[17] = new OleDbParameter("@EventFontColor", OleDbHelper.ToDbValue(e.EventFontColor));
parameters[18] = new OleDbParameter("@EventBackgroundColor", OleDbHelper.ToDbValue(e.EventBackgroundColor));
parameters[19] = new OleDbParameter("@TellNum", OleDbHelper.ToDbValue(e.TellNum));
parameters[20] = new OleDbParameter("@Side", OleDbHelper.ToDbValue(e.Side));
parameters[21] = new OleDbParameter("@TowLeverSide", OleDbHelper.ToDbValue(e.TowLeverSide));
OleDbHelper.ExecuteNonQuery1("Event", @"INSERT INTO [报警事件]
([序号],[用户名称],[用户地址],[主机编号],[用户类型],[主机类型],[分区编号],[防区编号],[防区类型],[探测器型号],[安装位置],[事件类型]
,[辅助信息],[归类处理],[通讯代码],[处理内容],[值班员姓名],[事件字体颜色],[事件背景颜色],[来电号码],[站点编号],[二级站点])
VALUES
(@ID,@UserName,@Address,@Account,@UserType,@PanelType,@PartitionNumber,@ZoneNumber,@ZoneType,@DetectorType,@InstallSide,@EventTpye,
@EventInfomation,@Classify,@DataCode,@MarkEvent,@Operator,@EventFontColor,@EventBackgroundColor,@TellNum,@Side,@TowLeverSide)",
parameters);
}
public void Update(Event e)
{
OleDbParameter[] parameters = new OleDbParameter[22];
parameters[0] = new OleDbParameter("@UserName", OleDbHelper.ToDbValue(e.UserName));
parameters[1] = new OleDbParameter("@Address", OleDbHelper.ToDbValue(e.Address));
parameters[2] = new OleDbParameter("@Account", OleDbHelper.ToDbValue(e.Account));
parameters[3] = new OleDbParameter("@UserType", OleDbHelper.ToDbValue(e.UserType));
parameters[4] = new OleDbParameter("@PanelType", OleDbHelper.ToDbValue(e.PanelType));
parameters[5] = new OleDbParameter("@PartitionNumber", OleDbHelper.ToDbValue(e.PartitionNumber));
parameters[6] = new OleDbParameter("@ZoneNumber", OleDbHelper.ToDbValue(e.ZoneNumber));
parameters[7] = new OleDbParameter("@ZoneType", OleDbHelper.ToDbValue(e.ZoneType));
parameters[8] = new OleDbParameter("@DetectorType", OleDbHelper.ToDbValue(e.DetectorType));
parameters[9] = new OleDbParameter("@InstallSide", OleDbHelper.ToDbValue(e.InstallSide));
parameters[10] = new OleDbParameter("@EventTpye", OleDbHelper.ToDbValue(e.EventTpye));
parameters[11] = new OleDbParameter("@EventInfomation", OleDbHelper.ToDbValue(e.EventInfomation));
parameters[12] = new OleDbParameter("@Classify", OleDbHelper.ToDbValue(e.Classify));
parameters[13] = new OleDbParameter("@DataCode", OleDbHelper.ToDbValue(e.DataCode));
parameters[14] = new OleDbParameter("@MarkEvent", OleDbHelper.ToDbValue(e.MarkEvent));
parameters[15] = new OleDbParameter("@Operator", OleDbHelper.ToDbValue(e.Operator));
parameters[16] = new OleDbParameter("@EventFontColor", OleDbHelper.ToDbValue(e.EventFontColor));
parameters[17] = new OleDbParameter("@EventBackgroundColor", OleDbHelper.ToDbValue(e.EventBackgroundColor));
parameters[18] = new OleDbParameter("@TellNum", OleDbHelper.ToDbValue(e.TellNum));
parameters[19] = new OleDbParameter("@Side", OleDbHelper.ToDbValue(e.Side));
parameters[20] = new OleDbParameter("@TowLeverSide", OleDbHelper.ToDbValue(e.TowLeverSide));
parameters[21] = new OleDbParameter("@ID", OleDbHelper.ToDbValue(e.ID));
OleDbHelper.ExecuteNonQuery1("Event", @"UPDATE [报警事件]
SET [用户名称]=@UserName,[用户地址]=@Address,[主机编号]=@Account,[用户类型]=@UserType,[主机类型]=@PanelType,[分区编号]=@PartitionNumber,
[防区编号]=@ZoneNumber,[防区类型]=@ZoneType,[探测器型号]=@DetectorType,[安装位置]=@InstallSide,[事件类型]=@EventTpye,
[辅助信息]=@EventInfomation,[归类处理]=@Classify,[通讯代码]=@DataCode,[处理内容]=@MarkEvent,[值班员姓名]=@Operator,[事件字体颜色]=@EventFontColor,
[事件背景颜色]=@EventBackgroundColor,[来电号码]=@TellNum,[站点编号]=@Side,[二级站点]=@TowLeverSide
WHERE [序号]=@ID"
, parameters);
}
public void Insert(Contacts contacts)
{
OleDbHelper.ExecuteNonQuery("Main", @"INSERT INTO [联系人资料]
(主机编号,联系人序号,姓名,职务,电话)
VALUES (@Account,@ContactsID,@ContactsName,@ContactsJob,@ContactsPhoneNumber)",
new OleDbParameter("@Account", OleDbHelper.ToDbValue(contacts.Account)),
new OleDbParameter("@ContactsID", OleDbHelper.ToDbValue(contacts.ContactsID)),
new OleDbParameter("@ContactsName", OleDbHelper.ToDbValue(contacts.ContactsName)),
new OleDbParameter("@ContactsJob", OleDbHelper.ToDbValue(contacts.ContactsJob)),
new OleDbParameter("@ContactsPhoneNumber", OleDbHelper.ToDbValue(contacts.ContactsPhoneNumber)));
}
public void Insert(string tableName, CID cid)
{
OleDbHelper.ExecuteNonQuery("Main", @"INSERT INTO " + tableName +
@" (CID码,是否是新事件,事件类型,辅助信息,处理策略,是否发送短信)
VALUES (@CIDCode,@IsNewEvent,@EventTpye,@EventInformation,@StrategiesName,@IsSendMessage)",
new OleDbParameter("@CIDCode", OleDbHelper.ToDbValue(cid.CIDCode)),
new OleDbParameter("@IsNewEvent", OleDbHelper.ToDbValue(cid.IsNewEvent)),
new OleDbParameter("@EventTpye", OleDbHelper.ToDbValue(cid.EventTpye)),
new OleDbParameter("@EventInformation", OleDbHelper.ToDbValue(cid.EventInformation)),
new OleDbParameter("@StrategiesName", OleDbHelper.ToDbValue(cid.StrategiesName)),
new OleDbParameter("@IsSendMessage", OleDbHelper.ToDbValue(cid.IsSendMessage)));
}
public void Insert(Strategies strategies)
{
OleDbHelper.ExecuteNonQuery("Main", @"INSERT INTO 处理策略
(策略编号,策略名称,事件字体颜色,事件背景颜色,提示类型,自动打印,报警声文件)
VALUES (@StrategiesID,@StrategiesName,@EventFontColor,@EventBackgroundColor,@NoticeType,@IsPrint,@SoundFile)",
new OleDbParameter("@StrategiesID", OleDbHelper.ToDbValue(strategies.StrategiesID)),
new OleDbParameter("@StrategiesName", OleDbHelper.ToDbValue(strategies.StrategiesName)),
new OleDbParameter("@EventFontColor", OleDbHelper.ToDbValue(strategies.EventFontColor)),
new OleDbParameter("@EventBackgroundColor", OleDbHelper.ToDbValue(strategies.EventBackgroundColor)),
new OleDbParameter("@NoticeType", OleDbHelper.ToDbValue(strategies.NoticeType)),
new OleDbParameter("@IsPrint", OleDbHelper.ToDbValue(strategies.IsPrint)),
new OleDbParameter("@SoundFile", OleDbHelper.ToDbValue(strategies.SoundFile)));
}
public void Update(Contacts contacts)
{
OleDbHelper.ExecuteNonQuery("Main", @"UPDATE [联系人资料]
SET [主机编号]=@Account
,[联系人序号]=@ContactsID
,[姓名]=@ContactsName
,[职务]=@ContactsJob
,[电话]=@PartitionNum
WHERE [序号]=@ID",
new OleDbParameter("@Account", OleDbHelper.ToDbValue(contacts.Account)),
new OleDbParameter("@ContactsID", OleDbHelper.ToDbValue(contacts.ContactsID)),
new OleDbParameter("@ContactsName", OleDbHelper.ToDbValue(contacts.ContactsName)),
new OleDbParameter("@ContactsJob", OleDbHelper.ToDbValue(contacts.ContactsJob)),
new OleDbParameter("@ContactsPhoneNumber", OleDbHelper.ToDbValue(contacts.ContactsPhoneNumber)),
new OleDbParameter("@ID", OleDbHelper.ToDbValue(contacts.ID)));
}
public void Update(string tableName, CID cid)
{
OleDbHelper.ExecuteNonQuery("Main", @"UPDATE " + tableName +
@" SET [CID码]=@CIDCode
,[是否是新事件]=@IsNewEvent
,[事件类型]=@EventTpye
,[辅助信息]=@EventInformation
,[处理策略]=@StrategiesName
,[是否发送短信]=@IsSendMessage
WHERE [序号]=@ID",
new OleDbParameter("@CIDCode", OleDbHelper.ToDbValue(cid.CIDCode)),
new OleDbParameter("@IsNewEvent", OleDbHelper.ToDbValue(cid.IsNewEvent)),
new OleDbParameter("@EventTpye", OleDbHelper.ToDbValue(cid.EventTpye)),
new OleDbParameter("@EventInformation", OleDbHelper.ToDbValue(cid.EventInformation)),
new OleDbParameter("@StrategiesName", OleDbHelper.ToDbValue(cid.StrategiesName)),
new OleDbParameter("@IsSendMessage", OleDbHelper.ToDbValue(cid.IsSendMessage)),
new OleDbParameter("@ID", OleDbHelper.ToDbValue(cid.ID)));
}
public void Insert(Zone zone)
{
OleDbHelper.ExecuteNonQuery("Main", @"INSERT INTO 防区资料
([主机编号],[防区编号],[分区编号],[防区类型],[探测器型号],[安装位置],[防区状态],[横坐标],[纵坐标],[防区状态更新时间],[最近一次上报时间],[是否报警])
VALUES (@Account,@ZoneNum,@PartitionNum,@ZoneType,@DetectorType,@InstallSide,@ZoneStatus,@Abscissa,@Ordinate,@StatusRefreshTime,@EedEventTime,@IsAlarm)",
new OleDbParameter("@Account", OleDbHelper.ToDbValue(zone.Account)),
new OleDbParameter("@ZoneNum", OleDbHelper.ToDbValue(zone.ZoneNum)),
new OleDbParameter("@PartitionNum", OleDbHelper.ToDbValue(zone.PartitionNum)),
new OleDbParameter("@ZoneType", OleDbHelper.ToDbValue(zone.ZoneType)),
new OleDbParameter("@DetectorType", OleDbHelper.ToDbValue(zone.DetectorType)),
new OleDbParameter("@InstallSide", OleDbHelper.ToDbValue(zone.InstallSide)),
new OleDbParameter("@ZoneStatus", OleDbHelper.ToDbValue(zone.ZoneStatus)),
new OleDbParameter("@Abscissa", OleDbHelper.ToDbValue(zone.Abscissa)),
new OleDbParameter("@Ordinate", OleDbHelper.ToDbValue(zone.Ordinate)),
new OleDbParameter("@StatusRefreshTime", OleDbHelper.ToDbValue(zone.StatusRefreshTime)),
new OleDbParameter("@EedEventTime", OleDbHelper.ToDbValue(zone.EedEventTime)),
new OleDbParameter("@IsAlarm", OleDbHelper.ToDbValue(zone.IsAlarm)));
}
public void Insert(User user)
{
OleDbHelper.ExecuteNonQuery("Main", @"INSERT INTO [用户资料]
(主机编号,用户名称,用户地址,用户类型,通讯格式,主机类型,安装人员,安装日期,安装单位,收费标准,合同期限,备注说明)
VALUES
(@Account,@UserName, @Address,@UserType,@Protocol,@PanelName,@Installer,@InstallDate,@InstallCompany,@Charge,@Deadline,@Mark)",
new OleDbParameter("@Account", OleDbHelper.ToDbValue(user.Account)),
new OleDbParameter("@UserName", OleDbHelper.ToDbValue(user.UserName)),
new OleDbParameter("@Address", OleDbHelper.ToDbValue(user.Address)),
new OleDbParameter("@UserType", OleDbHelper.ToDbValue(user.UserType)),
new OleDbParameter("@Protocol", OleDbHelper.ToDbValue(user.Protocol)),
new OleDbParameter("@PanelName", OleDbHelper.ToDbValue(user.PanelName)),
new OleDbParameter("@Installer", OleDbHelper.ToDbValue(user.Installer)),
new OleDbParameter("@InstallDate", OleDbHelper.ToDbValue(user.InstallDate)),
new OleDbParameter("@InstallCompany", OleDbHelper.ToDbValue(user.InstallCompany)),
new OleDbParameter("@Charge", OleDbHelper.ToDbValue(user.Charge)),
new OleDbParameter("@Deadline", OleDbHelper.ToDbValue(user.Deadline)),
new OleDbParameter("@Mark", OleDbHelper.ToDbValue(user.Mark)));
}
public void Update(Strategies strategies)
{
OleDbHelper.ExecuteNonQuery("Main", @"UPDATE 处理策略
SET [策略编号]=@StrategiesID
,[策略名称]=@StrategiesName
,[事件字体颜色]=@EventFontColor
,[事件背景颜色]=@EventBackgroundColor
,[提示类型]=@NoticeType
,[自动打印]=@IsPrint
,[报警声文件]=@SoundFile
WHERE [序号]=@ID",
new OleDbParameter("@StrategiesID", OleDbHelper.ToDbValue(strategies.StrategiesID)),
new OleDbParameter("@StrategiesName", OleDbHelper.ToDbValue(strategies.StrategiesName)),
new OleDbParameter("@EventFontColor", OleDbHelper.ToDbValue(strategies.EventFontColor)),
new OleDbParameter("@EventBackgroundColor", OleDbHelper.ToDbValue(strategies.EventBackgroundColor)),
new OleDbParameter("@NoticeType", OleDbHelper.ToDbValue(strategies.NoticeType)),
new OleDbParameter("@IsPrint", OleDbHelper.ToDbValue(strategies.IsPrint)),
new OleDbParameter("@SoundFile", OleDbHelper.ToDbValue(strategies.SoundFile)),
new OleDbParameter("@ID", OleDbHelper.ToDbValue(strategies.ID)));
}
public void Insert(Receiver receiver)
{
OleDbHelper.ExecuteNonQuery("Main", @"INSERT INTO [串口设置]
([串口序号],[接警机名],[接警机类型],[版本号],[波特率],[数据位],[停止位],[流控制],[校验],[结束代码],[握手代码],[连接检查间隔],[是否检查连接],[备注])
VALUES (@SerialPortNum,@ReceiverName,@ReceiverType,@Version,@BaudRate,@DataBits,@StopBits,@FlowControl,@Parity,@EndCode,@ACK,@CheckTimer,@IsCheck,@Mark)",
new OleDbParameter("@SerialPortNum", OleDbHelper.ToDbValue(receiver.SerialPortNum)),
new OleDbParameter("@ReceiverName", OleDbHelper.ToDbValue(receiver.ReceiverName)),
new OleDbParameter("@ReceiverType", OleDbHelper.ToDbValue(receiver.ReceiverType)),
new OleDbParameter("@Version", OleDbHelper.ToDbValue(receiver.Version)),
new OleDbParameter("@BaudRate", OleDbHelper.ToDbValue(receiver.BaudRate)),
new OleDbParameter("@DataBits", OleDbHelper.ToDbValue(receiver.DataBits)),
new OleDbParameter("@StopBits", OleDbHelper.ToDbValue(receiver.StopBits)),
new OleDbParameter("@FlowControl", OleDbHelper.ToDbValue(receiver.FlowControl)),
new OleDbParameter("@Parity", OleDbHelper.ToDbValue(receiver.Parity)),
new OleDbParameter("@EndCode", OleDbHelper.ToDbValue(receiver.EndCode)),
new OleDbParameter("@ACK", OleDbHelper.ToDbValue(receiver.ACK)),
new OleDbParameter("@CheckTimer", OleDbHelper.ToDbValue(receiver.CheckTimer)),
new OleDbParameter("@IsCheck", OleDbHelper.ToDbValue(receiver.IsCheck)),
new OleDbParameter("@Mark", OleDbHelper.ToDbValue(receiver.Mark)));
}