/// <summary> /// 得到一个对象实体 /// </summary> public zhangte.Model.tb_navigation GetModel(int Id) { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select * from tb_navigation "); strSql.Append(" where Id=@Id LIMIT 1"); MySqlParameter[] parameters = { new MySqlParameter("@Id", MySql.Data.MySqlClient.MySqlDbType.Int16, 11) }; parameters[0].Value = Id; zhangte.Model.tb_navigation model = new zhangte.Model.tb_navigation(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(zhangte.Model.tb_navigation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_navigation set "); strSql.Append("MenuName=@MenuName,"); strSql.Append("Pagelogo=@Pagelogo,"); strSql.Append("ParentId=@ParentId,"); strSql.Append("LinkAddress=@LinkAddress,"); strSql.Append("Icon=@Icon,"); strSql.Append("Sort=@Sort,"); strSql.Append("IsShow=@IsShow"); strSql.Append(" where Id=@Id"); MySqlParameter[] parameters = { new MySqlParameter("@MenuName", MySqlDbType.VarChar, 50), new MySqlParameter("@Pagelogo", MySqlDbType.VarChar, 50), new MySqlParameter("@ParentId", MySqlDbType.Int32, 11), new MySqlParameter("@LinkAddress", MySqlDbType.VarChar, 100), new MySqlParameter("@Icon", MySqlDbType.VarChar, 50), new MySqlParameter("@Sort", MySqlDbType.Int32, 11), new MySqlParameter("@IsShow", MySqlDbType.Int32, 11), new MySqlParameter("@Id", MySqlDbType.Int16, 6) }; parameters[0].Value = model.MenuName; parameters[1].Value = model.Pagelogo; parameters[2].Value = model.ParentId; parameters[3].Value = model.LinkAddress; parameters[4].Value = model.Icon; parameters[5].Value = model.Sort; parameters[6].Value = model.IsShow; parameters[7].Value = model.Id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public zhangte.Model.tb_navigation DataRowToModel(DataRow row) { zhangte.Model.tb_navigation model = new zhangte.Model.tb_navigation(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["MenuName"] != null) { model.MenuName = row["MenuName"].ToString(); } if (row["Pagelogo"] != null) { model.Pagelogo = row["Pagelogo"].ToString(); } if (row["ParentId"] != null && row["ParentId"].ToString() != "") { model.ParentId = int.Parse(row["ParentId"].ToString()); } if (row["LinkAddress"] != null) { model.LinkAddress = row["LinkAddress"].ToString(); } if (row["Icon"] != null) { model.Icon = row["Icon"].ToString(); } if (row["Sort"] != null && row["Sort"].ToString() != "") { model.Sort = int.Parse(row["Sort"].ToString()); } if (row["IsShow"] != null && row["IsShow"].ToString() != "") { model.IsShow = int.Parse(row["IsShow"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(zhangte.Model.tb_navigation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_navigation("); strSql.Append("MenuName,Pagelogo,ParentId,LinkAddress,Icon,Sort,IsShow) values ("); strSql.Append("@MenuName,@Pagelogo,@ParentId,@LinkAddress,@Icon,@Sort,@IsShow)"); strSql.Append(";"); MySqlParameter[] parameters = { new MySqlParameter("@MenuName", MySqlDbType.VarChar, 50), new MySqlParameter("@Pagelogo", MySqlDbType.VarChar, 50), new MySqlParameter("@ParentId", MySqlDbType.Int32, 11), new MySqlParameter("@LinkAddress", MySqlDbType.VarChar, 100), new MySqlParameter("@Icon", MySqlDbType.VarChar, 50), new MySqlParameter("@Sort", MySqlDbType.Int32, 11), new MySqlParameter("@IsShow", MySqlDbType.Int32, 11) }; parameters[0].Value = model.MenuName; parameters[1].Value = model.Pagelogo; parameters[2].Value = model.ParentId; parameters[3].Value = model.LinkAddress; parameters[4].Value = model.Icon; parameters[5].Value = model.Sort; parameters[6].Value = model.IsShow; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(rows); } else { return(0); } }