/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model = new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone(); if (row != null) { if (row["ReaderTimeZoneID"] != null && row["ReaderTimeZoneID"].ToString() != "") { model.ReaderTimeZoneID = int.Parse(row["ReaderTimeZoneID"].ToString()); } if (row["TimeZone1"] != null) { model.TimeZone1 = row["TimeZone1"].ToString(); } if (row["OperateMode1"] != null && row["OperateMode1"].ToString() != "") { model.OperateMode1 = int.Parse(row["OperateMode1"].ToString()); } if (row["TimeZone2"] != null) { model.TimeZone2 = row["TimeZone2"].ToString(); } if (row["OperateMode2"] != null && row["OperateMode2"].ToString() != "") { model.OperateMode2 = int.Parse(row["OperateMode2"].ToString()); } if (row["TimeZone3"] != null) { model.TimeZone3 = row["TimeZone3"].ToString(); } if (row["OperateMode3"] != null && row["OperateMode3"].ToString() != "") { model.OperateMode3 = int.Parse(row["OperateMode3"].ToString()); } if (row["TimeZone4"] != null) { model.TimeZone4 = row["TimeZone4"].ToString(); } if (row["OperateMode4"] != null && row["OperateMode4"].ToString() != "") { model.OperateMode4 = int.Parse(row["OperateMode4"].ToString()); } if (row["TimeZone5"] != null) { model.TimeZone5 = row["TimeZone5"].ToString(); } if (row["OperateMode5"] != null && row["OperateMode5"].ToString() != "") { model.OperateMode5 = int.Parse(row["OperateMode5"].ToString()); } if (row["TimeZone6"] != null) { model.TimeZone6 = row["TimeZone6"].ToString(); } if (row["OperateMode6"] != null && row["OperateMode6"].ToString() != "") { model.OperateMode6 = int.Parse(row["OperateMode6"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReaderTimeZone set "); strSql.Append("TimeZone1=@TimeZone1,"); strSql.Append("OperateMode1=@OperateMode1,"); strSql.Append("TimeZone2=@TimeZone2,"); strSql.Append("OperateMode2=@OperateMode2,"); strSql.Append("TimeZone3=@TimeZone3,"); strSql.Append("OperateMode3=@OperateMode3,"); strSql.Append("TimeZone4=@TimeZone4,"); strSql.Append("OperateMode4=@OperateMode4,"); strSql.Append("TimeZone5=@TimeZone5,"); strSql.Append("OperateMode5=@OperateMode5,"); strSql.Append("TimeZone6=@TimeZone6,"); strSql.Append("OperateMode6=@OperateMode6"); strSql.Append(" where ReaderTimeZoneID=@ReaderTimeZoneID "); SQLiteParameter[] parameters = { new SQLiteParameter("@TimeZone1", DbType.String), new SQLiteParameter("@OperateMode1", DbType.Int32, 4), new SQLiteParameter("@TimeZone2", DbType.String), new SQLiteParameter("@OperateMode2", DbType.Int32, 4), new SQLiteParameter("@TimeZone3", DbType.String), new SQLiteParameter("@OperateMode3", DbType.Int32, 4), new SQLiteParameter("@TimeZone4", DbType.String), new SQLiteParameter("@OperateMode4", DbType.Int32, 4), new SQLiteParameter("@TimeZone5", DbType.String), new SQLiteParameter("@OperateMode5", DbType.Int32, 4), new SQLiteParameter("@TimeZone6", DbType.String), new SQLiteParameter("@OperateMode6", DbType.Int32, 4), new SQLiteParameter("@ReaderTimeZoneID", DbType.Int32, 4) }; parameters[0].Value = model.TimeZone1; parameters[1].Value = model.OperateMode1; parameters[2].Value = model.TimeZone2; parameters[3].Value = model.OperateMode2; parameters[4].Value = model.TimeZone3; parameters[5].Value = model.OperateMode3; parameters[6].Value = model.TimeZone4; parameters[7].Value = model.OperateMode4; parameters[8].Value = model.TimeZone5; parameters[9].Value = model.OperateMode5; parameters[10].Value = model.TimeZone6; parameters[11].Value = model.OperateMode6; parameters[12].Value = model.ReaderTimeZoneID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ReaderTimeZone("); strSql.Append("ReaderTimeZoneID,TimeZone1,OperateMode1,TimeZone2,OperateMode2,TimeZone3,OperateMode3,TimeZone4,OperateMode4,TimeZone5,OperateMode5,TimeZone6,OperateMode6)"); strSql.Append(" values ("); strSql.Append("@ReaderTimeZoneID,@TimeZone1,@OperateMode1,@TimeZone2,@OperateMode2,@TimeZone3,@OperateMode3,@TimeZone4,@OperateMode4,@TimeZone5,@OperateMode5,@TimeZone6,@OperateMode6)"); SQLiteParameter[] parameters = { new SQLiteParameter("@ReaderTimeZoneID", DbType.Int32, 4), new SQLiteParameter("@TimeZone1", DbType.String), new SQLiteParameter("@OperateMode1", DbType.Int32, 4), new SQLiteParameter("@TimeZone2", DbType.String), new SQLiteParameter("@OperateMode2", DbType.Int32, 4), new SQLiteParameter("@TimeZone3", DbType.String), new SQLiteParameter("@OperateMode3", DbType.Int32, 4), new SQLiteParameter("@TimeZone4", DbType.String), new SQLiteParameter("@OperateMode4", DbType.Int32, 4), new SQLiteParameter("@TimeZone5", DbType.String), new SQLiteParameter("@OperateMode5", DbType.Int32, 4), new SQLiteParameter("@TimeZone6", DbType.String), new SQLiteParameter("@OperateMode6", DbType.Int32, 4) }; parameters[0].Value = model.ReaderTimeZoneID; parameters[1].Value = model.TimeZone1; parameters[2].Value = model.OperateMode1; parameters[3].Value = model.TimeZone2; parameters[4].Value = model.OperateMode2; parameters[5].Value = model.TimeZone3; parameters[6].Value = model.OperateMode3; parameters[7].Value = model.TimeZone4; parameters[8].Value = model.OperateMode4; parameters[9].Value = model.TimeZone5; parameters[10].Value = model.OperateMode5; parameters[11].Value = model.TimeZone6; parameters[12].Value = model.OperateMode6; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone GetModel(int ReaderTimeZoneID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ReaderTimeZoneID,TimeZone1,OperateMode1,TimeZone2,OperateMode2,TimeZone3,OperateMode3,TimeZone4,OperateMode4,TimeZone5,OperateMode5,TimeZone6,OperateMode6 from ReaderTimeZone "); strSql.Append(" where ReaderTimeZoneID=@ReaderTimeZoneID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ReaderTimeZoneID", DbType.Int32, 4) }; parameters[0].Value = ReaderTimeZoneID; KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model = new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone(); 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.ReaderTimeZone DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model=new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone(); if (row != null) { if(row["ReaderTimeZoneID"]!=null && row["ReaderTimeZoneID"].ToString()!="") { model.ReaderTimeZoneID=int.Parse(row["ReaderTimeZoneID"].ToString()); } if(row["TimeZone1"]!=null) { model.TimeZone1=row["TimeZone1"].ToString(); } if(row["OperateMode1"]!=null && row["OperateMode1"].ToString()!="") { model.OperateMode1=int.Parse(row["OperateMode1"].ToString()); } if(row["TimeZone2"]!=null) { model.TimeZone2=row["TimeZone2"].ToString(); } if(row["OperateMode2"]!=null && row["OperateMode2"].ToString()!="") { model.OperateMode2=int.Parse(row["OperateMode2"].ToString()); } if(row["TimeZone3"]!=null) { model.TimeZone3=row["TimeZone3"].ToString(); } if(row["OperateMode3"]!=null && row["OperateMode3"].ToString()!="") { model.OperateMode3=int.Parse(row["OperateMode3"].ToString()); } if(row["TimeZone4"]!=null) { model.TimeZone4=row["TimeZone4"].ToString(); } if(row["OperateMode4"]!=null && row["OperateMode4"].ToString()!="") { model.OperateMode4=int.Parse(row["OperateMode4"].ToString()); } if(row["TimeZone5"]!=null) { model.TimeZone5=row["TimeZone5"].ToString(); } if(row["OperateMode5"]!=null && row["OperateMode5"].ToString()!="") { model.OperateMode5=int.Parse(row["OperateMode5"].ToString()); } if(row["TimeZone6"]!=null) { model.TimeZone6=row["TimeZone6"].ToString(); } if(row["OperateMode6"]!=null && row["OperateMode6"].ToString()!="") { model.OperateMode6=int.Parse(row["OperateMode6"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone GetModel(int ReaderTimeZoneID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select ReaderTimeZoneID,TimeZone1,OperateMode1,TimeZone2,OperateMode2,TimeZone3,OperateMode3,TimeZone4,OperateMode4,TimeZone5,OperateMode5,TimeZone6,OperateMode6 from ReaderTimeZone "); strSql.Append(" where ReaderTimeZoneID=@ReaderTimeZoneID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ReaderTimeZoneID", DbType.Int32,4) }; parameters[0].Value = ReaderTimeZoneID; KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model=new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone(); DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }