/// <summary> /// 得到一个对象实体 /// </summary> public kyfly.Model.jichu_zidianbiao DataRowToModel(DataRow row) { kyfly.Model.jichu_zidianbiao model = new kyfly.Model.jichu_zidianbiao(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["字段名称"] != null) { model.字段名称 = row["字段名称"].ToString(); } if (row["字段值"] != null) { model.字段值 = row["字段值"].ToString(); } if (row["类别"] != null) { model.类别 = row["类别"].ToString(); } if (row["分类别"] != null) { model.分类别 = row["分类别"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(kyfly.Model.jichu_zidianbiao model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into 基础_字典表("); strSql.Append("字段名称,字段值,类别,分类别) values ("); strSql.Append("@字段名称,@字段值,@类别,@分类别)"); strSql.Append(";"); MySqlParameter[] parameters = { new MySqlParameter("@字段名称", MySqlDbType.VarChar, 30), new MySqlParameter("@字段值", MySqlDbType.VarChar, 60), new MySqlParameter("@类别", MySqlDbType.VarChar, 30), new MySqlParameter("@分类别", MySqlDbType.VarChar, 30) }; parameters[0].Value = model.字段名称; parameters[1].Value = model.字段值; parameters[2].Value = model.类别; parameters[3].Value = model.分类别; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(rows); } else { return(0); } }
/// <summary> /// 得到一个对象实体 /// </summary> public kyfly.Model.jichu_zidianbiao GetModel(int Id) { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select * from 基础_字典表 "); strSql.Append(" where Id=@Id LIMIT 1"); MySqlParameter[] parameters = { new MySqlParameter("@Id", MySql.Data.MySqlClient.MySqlDbType.Int16, 11) }; parameters[0].Value = Id; kyfly.Model.jichu_zidianbiao model = new kyfly.Model.jichu_zidianbiao(); 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(kyfly.Model.jichu_zidianbiao model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 基础_字典表 set "); strSql.Append("字段名称=@字段名称,"); strSql.Append("字段值=@字段值,"); strSql.Append("类别=@类别,"); strSql.Append("分类别=@分类别"); strSql.Append(" where Id=@Id"); MySqlParameter[] parameters = { new MySqlParameter("@字段名称", MySqlDbType.VarChar, 30), new MySqlParameter("@字段值", MySqlDbType.VarChar, 60), new MySqlParameter("@类别", MySqlDbType.VarChar, 30), new MySqlParameter("@分类别", MySqlDbType.VarChar, 30), new MySqlParameter("@Id", MySqlDbType.Int16, 6) }; parameters[0].Value = model.字段名称; parameters[1].Value = model.字段值; parameters[2].Value = model.类别; parameters[3].Value = model.分类别; parameters[4].Value = model.Id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }