/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo GetModel(int ControllerID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ControllerID,ControllerType,ControllerName,ControllerLocation,EncryptionType,CommunicateType,ControllerVersion,ControllerMAC,ControllerIP,ControllerSubnetMask,ControllerGateway,ControllerPort,ControllerDNS,ControllerBUDNS,ControllerAddr485,ControllerBaudrate,ControllerDataBits,ControllerStopBits,ControllerParityCheck,ControllerFlowControl,ControllerSAM,ControllerSAMType,DoorUnitCounts,ExpansionBoardCounts from ControllerInfo "); strSql.Append(" where ControllerID=@ControllerID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ControllerID", DbType.Int32, 4) }; parameters[0].Value = ControllerID; KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo model = new KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo GetModel(int ControllerID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select ControllerID,ControllerType,ControllerName,ControllerLocation,EncryptionType,CommunicateType,ControllerVersion,ControllerMAC,ControllerIP,ControllerSubnetMask,ControllerGateway,ControllerPort,ControllerDNS,ControllerBUDNS,ControllerAddr485,ControllerBaudrate,ControllerDataBits,ControllerStopBits,ControllerParityCheck,ControllerFlowControl,ControllerSAM,ControllerSAMType,DoorUnitCounts,ExpansionBoardCounts from ControllerInfo "); strSql.Append(" where ControllerID=@ControllerID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ControllerID", DbType.Int32,4) }; parameters[0].Value = ControllerID; KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo model=new KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo(); DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo model=new KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo(); if (row != null) { if(row["ControllerID"]!=null && row["ControllerID"].ToString()!="") { model.ControllerID=int.Parse(row["ControllerID"].ToString()); } if(row["ControllerType"]!=null && row["ControllerType"].ToString()!="") { model.ControllerType=int.Parse(row["ControllerType"].ToString()); } if(row["ControllerName"]!=null) { model.ControllerName=row["ControllerName"].ToString(); } if(row["ControllerLocation"]!=null) { model.ControllerLocation=row["ControllerLocation"].ToString(); } if(row["EncryptionType"]!=null && row["EncryptionType"].ToString()!="") { model.EncryptionType=int.Parse(row["EncryptionType"].ToString()); } if(row["CommunicateType"]!=null && row["CommunicateType"].ToString()!="") { model.CommunicateType=int.Parse(row["CommunicateType"].ToString()); } if(row["ControllerVersion"]!=null) { model.ControllerVersion=row["ControllerVersion"].ToString(); } if(row["ControllerMAC"]!=null) { model.ControllerMAC=row["ControllerMAC"].ToString(); } if(row["ControllerIP"]!=null) { model.ControllerIP=row["ControllerIP"].ToString(); } if(row["ControllerSubnetMask"]!=null) { model.ControllerSubnetMask=row["ControllerSubnetMask"].ToString(); } if(row["ControllerGateway"]!=null) { model.ControllerGateway=row["ControllerGateway"].ToString(); } if(row["ControllerPort"]!=null && row["ControllerPort"].ToString()!="") { model.ControllerPort=int.Parse(row["ControllerPort"].ToString()); } if(row["ControllerDNS"]!=null) { model.ControllerDNS=row["ControllerDNS"].ToString(); } if(row["ControllerBUDNS"]!=null) { model.ControllerBUDNS=row["ControllerBUDNS"].ToString(); } if(row["ControllerAddr485"]!=null && row["ControllerAddr485"].ToString()!="") { model.ControllerAddr485=int.Parse(row["ControllerAddr485"].ToString()); } if(row["ControllerBaudrate"]!=null && row["ControllerBaudrate"].ToString()!="") { model.ControllerBaudrate=int.Parse(row["ControllerBaudrate"].ToString()); } if(row["ControllerDataBits"]!=null && row["ControllerDataBits"].ToString()!="") { model.ControllerDataBits=int.Parse(row["ControllerDataBits"].ToString()); } if(row["ControllerStopBits"]!=null && row["ControllerStopBits"].ToString()!="") { model.ControllerStopBits=int.Parse(row["ControllerStopBits"].ToString()); } if(row["ControllerParityCheck"]!=null) { model.ControllerParityCheck=row["ControllerParityCheck"].ToString(); } if(row["ControllerFlowControl"]!=null) { model.ControllerFlowControl=row["ControllerFlowControl"].ToString(); } if(row["ControllerSAM"]!=null && row["ControllerSAM"].ToString()!="") { model.ControllerSAM=int.Parse(row["ControllerSAM"].ToString()); } if(row["ControllerSAMType"]!=null && row["ControllerSAMType"].ToString()!="") { model.ControllerSAMType=int.Parse(row["ControllerSAMType"].ToString()); } if(row["DoorUnitCounts"]!=null && row["DoorUnitCounts"].ToString()!="") { model.DoorUnitCounts=int.Parse(row["DoorUnitCounts"].ToString()); } if(row["ExpansionBoardCounts"]!=null && row["ExpansionBoardCounts"].ToString()!="") { model.ExpansionBoardCounts=int.Parse(row["ExpansionBoardCounts"].ToString()); } } return model; }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ControllerInfo("); strSql.Append("ControllerID,ControllerType,ControllerName,ControllerLocation,EncryptionType,CommunicateType,ControllerVersion,ControllerMAC,ControllerIP,ControllerSubnetMask,ControllerGateway,ControllerPort,ControllerDNS,ControllerBUDNS,ControllerAddr485,ControllerBaudrate,ControllerDataBits,ControllerStopBits,ControllerParityCheck,ControllerFlowControl,ControllerSAM,ControllerSAMType,DoorUnitCounts,ExpansionBoardCounts)"); strSql.Append(" values ("); strSql.Append("@ControllerID,@ControllerType,@ControllerName,@ControllerLocation,@EncryptionType,@CommunicateType,@ControllerVersion,@ControllerMAC,@ControllerIP,@ControllerSubnetMask,@ControllerGateway,@ControllerPort,@ControllerDNS,@ControllerBUDNS,@ControllerAddr485,@ControllerBaudrate,@ControllerDataBits,@ControllerStopBits,@ControllerParityCheck,@ControllerFlowControl,@ControllerSAM,@ControllerSAMType,@DoorUnitCounts,@ExpansionBoardCounts)"); SQLiteParameter[] parameters = { new SQLiteParameter("@ControllerID", DbType.Int32, 4), new SQLiteParameter("@ControllerType", DbType.Int32, 4), new SQLiteParameter("@ControllerName", DbType.String), new SQLiteParameter("@ControllerLocation", DbType.String), new SQLiteParameter("@EncryptionType", DbType.Int32, 4), new SQLiteParameter("@CommunicateType", DbType.Int32, 4), new SQLiteParameter("@ControllerVersion", DbType.String), new SQLiteParameter("@ControllerMAC", DbType.String), new SQLiteParameter("@ControllerIP", DbType.String), new SQLiteParameter("@ControllerSubnetMask", DbType.String), new SQLiteParameter("@ControllerGateway", DbType.String), new SQLiteParameter("@ControllerPort", DbType.Int32, 4), new SQLiteParameter("@ControllerDNS", DbType.String), new SQLiteParameter("@ControllerBUDNS", DbType.String), new SQLiteParameter("@ControllerAddr485", DbType.Int32, 4), new SQLiteParameter("@ControllerBaudrate", DbType.Int32, 4), new SQLiteParameter("@ControllerDataBits", DbType.Int32, 4), new SQLiteParameter("@ControllerStopBits", DbType.Int32, 4), new SQLiteParameter("@ControllerParityCheck", DbType.String), new SQLiteParameter("@ControllerFlowControl", DbType.String), new SQLiteParameter("@ControllerSAM", DbType.Int32, 4), new SQLiteParameter("@ControllerSAMType", DbType.Int32, 4), new SQLiteParameter("@DoorUnitCounts", DbType.Int32, 4), new SQLiteParameter("@ExpansionBoardCounts", DbType.Int32, 4) }; parameters[0].Value = model.ControllerID; parameters[1].Value = model.ControllerType; parameters[2].Value = model.ControllerName; parameters[3].Value = model.ControllerLocation; parameters[4].Value = model.EncryptionType; parameters[5].Value = model.CommunicateType; parameters[6].Value = model.ControllerVersion; parameters[7].Value = model.ControllerMAC; parameters[8].Value = model.ControllerIP; parameters[9].Value = model.ControllerSubnetMask; parameters[10].Value = model.ControllerGateway; parameters[11].Value = model.ControllerPort; parameters[12].Value = model.ControllerDNS; parameters[13].Value = model.ControllerBUDNS; parameters[14].Value = model.ControllerAddr485; parameters[15].Value = model.ControllerBaudrate; parameters[16].Value = model.ControllerDataBits; parameters[17].Value = model.ControllerStopBits; parameters[18].Value = model.ControllerParityCheck; parameters[19].Value = model.ControllerFlowControl; parameters[20].Value = model.ControllerSAM; parameters[21].Value = model.ControllerSAMType; parameters[22].Value = model.DoorUnitCounts; parameters[23].Value = model.ExpansionBoardCounts; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo model = new KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo(); if (row != null) { if (row["ControllerID"] != null && row["ControllerID"].ToString() != "") { model.ControllerID = int.Parse(row["ControllerID"].ToString()); } if (row["ControllerType"] != null && row["ControllerType"].ToString() != "") { model.ControllerType = int.Parse(row["ControllerType"].ToString()); } if (row["ControllerName"] != null) { model.ControllerName = row["ControllerName"].ToString(); } if (row["ControllerLocation"] != null) { model.ControllerLocation = row["ControllerLocation"].ToString(); } if (row["EncryptionType"] != null && row["EncryptionType"].ToString() != "") { model.EncryptionType = int.Parse(row["EncryptionType"].ToString()); } if (row["CommunicateType"] != null && row["CommunicateType"].ToString() != "") { model.CommunicateType = int.Parse(row["CommunicateType"].ToString()); } if (row["ControllerVersion"] != null) { model.ControllerVersion = row["ControllerVersion"].ToString(); } if (row["ControllerMAC"] != null) { model.ControllerMAC = row["ControllerMAC"].ToString(); } if (row["ControllerIP"] != null) { model.ControllerIP = row["ControllerIP"].ToString(); } if (row["ControllerSubnetMask"] != null) { model.ControllerSubnetMask = row["ControllerSubnetMask"].ToString(); } if (row["ControllerGateway"] != null) { model.ControllerGateway = row["ControllerGateway"].ToString(); } if (row["ControllerPort"] != null && row["ControllerPort"].ToString() != "") { model.ControllerPort = int.Parse(row["ControllerPort"].ToString()); } if (row["ControllerDNS"] != null) { model.ControllerDNS = row["ControllerDNS"].ToString(); } if (row["ControllerBUDNS"] != null) { model.ControllerBUDNS = row["ControllerBUDNS"].ToString(); } if (row["ControllerAddr485"] != null && row["ControllerAddr485"].ToString() != "") { model.ControllerAddr485 = int.Parse(row["ControllerAddr485"].ToString()); } if (row["ControllerBaudrate"] != null && row["ControllerBaudrate"].ToString() != "") { model.ControllerBaudrate = int.Parse(row["ControllerBaudrate"].ToString()); } if (row["ControllerDataBits"] != null && row["ControllerDataBits"].ToString() != "") { model.ControllerDataBits = int.Parse(row["ControllerDataBits"].ToString()); } if (row["ControllerStopBits"] != null && row["ControllerStopBits"].ToString() != "") { model.ControllerStopBits = int.Parse(row["ControllerStopBits"].ToString()); } if (row["ControllerParityCheck"] != null) { model.ControllerParityCheck = row["ControllerParityCheck"].ToString(); } if (row["ControllerFlowControl"] != null) { model.ControllerFlowControl = row["ControllerFlowControl"].ToString(); } if (row["ControllerSAM"] != null && row["ControllerSAM"].ToString() != "") { model.ControllerSAM = int.Parse(row["ControllerSAM"].ToString()); } if (row["ControllerSAMType"] != null && row["ControllerSAMType"].ToString() != "") { model.ControllerSAMType = int.Parse(row["ControllerSAMType"].ToString()); } if (row["DoorUnitCounts"] != null && row["DoorUnitCounts"].ToString() != "") { model.DoorUnitCounts = int.Parse(row["DoorUnitCounts"].ToString()); } if (row["ExpansionBoardCounts"] != null && row["ExpansionBoardCounts"].ToString() != "") { model.ExpansionBoardCounts = int.Parse(row["ExpansionBoardCounts"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.SQLite.Model.ControllerRelation.ControllerInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ControllerInfo set "); strSql.Append("ControllerType=@ControllerType,"); strSql.Append("ControllerName=@ControllerName,"); strSql.Append("ControllerLocation=@ControllerLocation,"); strSql.Append("EncryptionType=@EncryptionType,"); strSql.Append("CommunicateType=@CommunicateType,"); strSql.Append("ControllerVersion=@ControllerVersion,"); strSql.Append("ControllerMAC=@ControllerMAC,"); strSql.Append("ControllerIP=@ControllerIP,"); strSql.Append("ControllerSubnetMask=@ControllerSubnetMask,"); strSql.Append("ControllerGateway=@ControllerGateway,"); strSql.Append("ControllerPort=@ControllerPort,"); strSql.Append("ControllerDNS=@ControllerDNS,"); strSql.Append("ControllerBUDNS=@ControllerBUDNS,"); strSql.Append("ControllerAddr485=@ControllerAddr485,"); strSql.Append("ControllerBaudrate=@ControllerBaudrate,"); strSql.Append("ControllerDataBits=@ControllerDataBits,"); strSql.Append("ControllerStopBits=@ControllerStopBits,"); strSql.Append("ControllerParityCheck=@ControllerParityCheck,"); strSql.Append("ControllerFlowControl=@ControllerFlowControl,"); strSql.Append("ControllerSAM=@ControllerSAM,"); strSql.Append("ControllerSAMType=@ControllerSAMType,"); strSql.Append("DoorUnitCounts=@DoorUnitCounts,"); strSql.Append("ExpansionBoardCounts=@ExpansionBoardCounts"); strSql.Append(" where ControllerID=@ControllerID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ControllerType", DbType.Int32, 4), new SQLiteParameter("@ControllerName", DbType.String), new SQLiteParameter("@ControllerLocation", DbType.String), new SQLiteParameter("@EncryptionType", DbType.Int32, 4), new SQLiteParameter("@CommunicateType", DbType.Int32, 4), new SQLiteParameter("@ControllerVersion", DbType.String), new SQLiteParameter("@ControllerMAC", DbType.String), new SQLiteParameter("@ControllerIP", DbType.String), new SQLiteParameter("@ControllerSubnetMask", DbType.String), new SQLiteParameter("@ControllerGateway", DbType.String), new SQLiteParameter("@ControllerPort", DbType.Int32, 4), new SQLiteParameter("@ControllerDNS", DbType.String), new SQLiteParameter("@ControllerBUDNS", DbType.String), new SQLiteParameter("@ControllerAddr485", DbType.Int32, 4), new SQLiteParameter("@ControllerBaudrate", DbType.Int32, 4), new SQLiteParameter("@ControllerDataBits", DbType.Int32, 4), new SQLiteParameter("@ControllerStopBits", DbType.Int32, 4), new SQLiteParameter("@ControllerParityCheck", DbType.String), new SQLiteParameter("@ControllerFlowControl", DbType.String), new SQLiteParameter("@ControllerSAM", DbType.Int32, 4), new SQLiteParameter("@ControllerSAMType", DbType.Int32, 4), new SQLiteParameter("@DoorUnitCounts", DbType.Int32, 4), new SQLiteParameter("@ExpansionBoardCounts", DbType.Int32, 4), new SQLiteParameter("@ControllerID", DbType.Int32, 4) }; parameters[0].Value = model.ControllerType; parameters[1].Value = model.ControllerName; parameters[2].Value = model.ControllerLocation; parameters[3].Value = model.EncryptionType; parameters[4].Value = model.CommunicateType; parameters[5].Value = model.ControllerVersion; parameters[6].Value = model.ControllerMAC; parameters[7].Value = model.ControllerIP; parameters[8].Value = model.ControllerSubnetMask; parameters[9].Value = model.ControllerGateway; parameters[10].Value = model.ControllerPort; parameters[11].Value = model.ControllerDNS; parameters[12].Value = model.ControllerBUDNS; parameters[13].Value = model.ControllerAddr485; parameters[14].Value = model.ControllerBaudrate; parameters[15].Value = model.ControllerDataBits; parameters[16].Value = model.ControllerStopBits; parameters[17].Value = model.ControllerParityCheck; parameters[18].Value = model.ControllerFlowControl; parameters[19].Value = model.ControllerSAM; parameters[20].Value = model.ControllerSAMType; parameters[21].Value = model.DoorUnitCounts; parameters[22].Value = model.ExpansionBoardCounts; parameters[23].Value = model.ControllerID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }