/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MendiaPictureGroup set "); strSql.Append("MendiaPictureGroupName=@MendiaPictureGroupName,"); strSql.Append("MendiaPictureGroupDes=@MendiaPictureGroupDes"); strSql.Append(" where MendiaPictureGroupID=@MendiaPictureGroupID "); SQLiteParameter[] parameters = { new SQLiteParameter("@MendiaPictureGroupName", DbType.String), new SQLiteParameter("@MendiaPictureGroupDes", DbType.String), new SQLiteParameter("@MendiaPictureGroupID", DbType.Int32, 4) }; parameters[0].Value = model.MendiaPictureGroupName; parameters[1].Value = model.MendiaPictureGroupDes; parameters[2].Value = model.MendiaPictureGroupID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MendiaPictureGroup("); strSql.Append("MendiaPictureGroupID,MendiaPictureGroupName,MendiaPictureGroupDes)"); strSql.Append(" values ("); strSql.Append("@MendiaPictureGroupID,@MendiaPictureGroupName,@MendiaPictureGroupDes)"); SQLiteParameter[] parameters = { new SQLiteParameter("@MendiaPictureGroupID", DbType.Int32, 4), new SQLiteParameter("@MendiaPictureGroupName", DbType.String), new SQLiteParameter("@MendiaPictureGroupDes", DbType.String) }; parameters[0].Value = model.MendiaPictureGroupID; parameters[1].Value = model.MendiaPictureGroupName; parameters[2].Value = model.MendiaPictureGroupDes; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup model = new KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup(); if (row != null) { if (row["MendiaPictureGroupID"] != null && row["MendiaPictureGroupID"].ToString() != "") { model.MendiaPictureGroupID = int.Parse(row["MendiaPictureGroupID"].ToString()); } if (row["MendiaPictureGroupName"] != null) { model.MendiaPictureGroupName = row["MendiaPictureGroupName"].ToString(); } if (row["MendiaPictureGroupDes"] != null) { model.MendiaPictureGroupDes = row["MendiaPictureGroupDes"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup model=new KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup(); if (row != null) { if(row["MendiaPictureGroupID"]!=null && row["MendiaPictureGroupID"].ToString()!="") { model.MendiaPictureGroupID=int.Parse(row["MendiaPictureGroupID"].ToString()); } if(row["MendiaPictureGroupName"]!=null) { model.MendiaPictureGroupName=row["MendiaPictureGroupName"].ToString(); } if(row["MendiaPictureGroupDes"]!=null) { model.MendiaPictureGroupDes=row["MendiaPictureGroupDes"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup GetModel(int MendiaPictureGroupID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MendiaPictureGroupID,MendiaPictureGroupName,MendiaPictureGroupDes from MendiaPictureGroup "); strSql.Append(" where MendiaPictureGroupID=@MendiaPictureGroupID "); SQLiteParameter[] parameters = { new SQLiteParameter("@MendiaPictureGroupID", DbType.Int32, 4) }; parameters[0].Value = MendiaPictureGroupID; KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup model = new KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup(); 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.LCDRelation.MendiaPictureGroup GetModel(int MendiaPictureGroupID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select MendiaPictureGroupID,MendiaPictureGroupName,MendiaPictureGroupDes from MendiaPictureGroup "); strSql.Append(" where MendiaPictureGroupID=@MendiaPictureGroupID "); SQLiteParameter[] parameters = { new SQLiteParameter("@MendiaPictureGroupID", DbType.Int32,4) }; parameters[0].Value = MendiaPictureGroupID; KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup model=new KryptonAccessController.SQLite.Model.LCDRelation.MendiaPictureGroup(); DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }