/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.material_type model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update material_type set "); strSql.Append("type_name=@type_name,"); strSql.Append("type_comment=@type_comment"); strSql.Append(" where type_id=@type_id "); MySqlParameter[] parameters = { new MySqlParameter("@type_name", MySqlDbType.VarChar, 128), new MySqlParameter("@type_comment", MySqlDbType.VarChar, 255), new MySqlParameter("@type_id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.type_name; parameters[1].Value = model.type_comment; parameters[2].Value = model.type_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.material_type model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into material_type("); strSql.Append("type_id,type_name,type_comment)"); strSql.Append(" values ("); strSql.Append("@type_id,@type_name,@type_comment)"); MySqlParameter[] parameters = { new MySqlParameter("@type_id", MySqlDbType.Int32, 11), new MySqlParameter("@type_name", MySqlDbType.VarChar, 128), new MySqlParameter("@type_comment", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.type_id; parameters[1].Value = model.type_name; parameters[2].Value = model.type_comment; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.material_type DataRowToModel(DataRow row) { Model.material_type model = new Model.material_type(); if (row != null) { if (row["type_id"] != null && row["type_id"].ToString() != "") { model.type_id = int.Parse(row["type_id"].ToString()); } if (row["type_name"] != null) { model.type_name = row["type_name"].ToString(); } if (row["type_comment"] != null) { model.type_comment = row["type_comment"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.material_type GetModel(int type_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select type_id,type_name,type_comment from material_type "); strSql.Append(" where type_id=@type_id "); MySqlParameter[] parameters = { new MySqlParameter("@type_id", MySqlDbType.Int32, 11) }; parameters[0].Value = type_id; Model.material_type model = new Model.material_type(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }