/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ControllerInfoInLAN set "); strSql.Append("ControllerName=@ControllerName,"); strSql.Append("ControllerType=@ControllerType,"); strSql.Append("ComunicateType=@ComunicateType,"); strSql.Append("ControllerIP=@ControllerIP,"); strSql.Append("ControllerPort=@ControllerPort,"); 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(" where ControllerID=@ControllerID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ControllerName", DbType.String), new SQLiteParameter("@ControllerType", DbType.Int32, 4), new SQLiteParameter("@ComunicateType", DbType.Int32, 4), new SQLiteParameter("@ControllerIP", DbType.String), new SQLiteParameter("@ControllerPort", DbType.Int32, 4), 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("@ControllerID", DbType.Int32, 4) }; parameters[0].Value = model.ControllerName; parameters[1].Value = model.ControllerType; parameters[2].Value = model.ComunicateType; parameters[3].Value = model.ControllerIP; parameters[4].Value = model.ControllerPort; parameters[5].Value = model.ControllerAddr485; parameters[6].Value = model.ControllerBaudrate; parameters[7].Value = model.ControllerDataBits; parameters[8].Value = model.ControllerStopBits; parameters[9].Value = model.ControllerParityCheck; parameters[10].Value = model.ControllerFlowControl; parameters[11].Value = model.ControllerID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ControllerInfoInLAN("); strSql.Append("ControllerID,ControllerName,ControllerType,ComunicateType,ControllerIP,ControllerPort,ControllerAddr485,ControllerBaudrate,ControllerDataBits,ControllerStopBits,ControllerParityCheck,ControllerFlowControl)"); strSql.Append(" values ("); strSql.Append("@ControllerID,@ControllerName,@ControllerType,@ComunicateType,@ControllerIP,@ControllerPort,@ControllerAddr485,@ControllerBaudrate,@ControllerDataBits,@ControllerStopBits,@ControllerParityCheck,@ControllerFlowControl)"); SQLiteParameter[] parameters = { new SQLiteParameter("@ControllerID", DbType.Int32, 4), new SQLiteParameter("@ControllerName", DbType.String), new SQLiteParameter("@ControllerType", DbType.Int32, 4), new SQLiteParameter("@ComunicateType", DbType.Int32, 4), new SQLiteParameter("@ControllerIP", DbType.String), new SQLiteParameter("@ControllerPort", DbType.Int32, 4), 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) }; parameters[0].Value = model.ControllerID; parameters[1].Value = model.ControllerName; parameters[2].Value = model.ControllerType; parameters[3].Value = model.ComunicateType; parameters[4].Value = model.ControllerIP; parameters[5].Value = model.ControllerPort; parameters[6].Value = model.ControllerAddr485; parameters[7].Value = model.ControllerBaudrate; parameters[8].Value = model.ControllerDataBits; parameters[9].Value = model.ControllerStopBits; parameters[10].Value = model.ControllerParityCheck; parameters[11].Value = model.ControllerFlowControl; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN model=new KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN(); if (row != null) { if(row["ControllerID"]!=null && row["ControllerID"].ToString()!="") { model.ControllerID=int.Parse(row["ControllerID"].ToString()); } if(row["ControllerName"]!=null) { model.ControllerName=row["ControllerName"].ToString(); } if(row["ControllerType"]!=null && row["ControllerType"].ToString()!="") { model.ControllerType=int.Parse(row["ControllerType"].ToString()); } if(row["ComunicateType"]!=null && row["ComunicateType"].ToString()!="") { model.ComunicateType=int.Parse(row["ComunicateType"].ToString()); } if(row["ControllerIP"]!=null) { model.ControllerIP=row["ControllerIP"].ToString(); } if(row["ControllerPort"]!=null && row["ControllerPort"].ToString()!="") { model.ControllerPort=int.Parse(row["ControllerPort"].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(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN GetModel(int ControllerID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select ControllerID,ControllerName,ControllerType,ComunicateType,ControllerIP,ControllerPort,ControllerAddr485,ControllerBaudrate,ControllerDataBits,ControllerStopBits,ControllerParityCheck,ControllerFlowControl from ControllerInfoInLAN "); strSql.Append(" where ControllerID=@ControllerID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ControllerID", DbType.Int32,4) }; parameters[0].Value = ControllerID; KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN model=new KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN(); 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.InteractRelation.ControllerInfoInLAN DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN model = new KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN(); if (row != null) { if (row["ControllerID"] != null && row["ControllerID"].ToString() != "") { model.ControllerID = int.Parse(row["ControllerID"].ToString()); } if (row["ControllerName"] != null) { model.ControllerName = row["ControllerName"].ToString(); } if (row["ControllerType"] != null && row["ControllerType"].ToString() != "") { model.ControllerType = int.Parse(row["ControllerType"].ToString()); } if (row["ComunicateType"] != null && row["ComunicateType"].ToString() != "") { model.ComunicateType = int.Parse(row["ComunicateType"].ToString()); } if (row["ControllerIP"] != null) { model.ControllerIP = row["ControllerIP"].ToString(); } if (row["ControllerPort"] != null && row["ControllerPort"].ToString() != "") { model.ControllerPort = int.Parse(row["ControllerPort"].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(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN GetModel(int ControllerID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ControllerID,ControllerName,ControllerType,ComunicateType,ControllerIP,ControllerPort,ControllerAddr485,ControllerBaudrate,ControllerDataBits,ControllerStopBits,ControllerParityCheck,ControllerFlowControl from ControllerInfoInLAN "); strSql.Append(" where ControllerID=@ControllerID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ControllerID", DbType.Int32, 4) }; parameters[0].Value = ControllerID; KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN model = new KryptonAccessController.SQLite.Model.InteractRelation.ControllerInfoInLAN(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }