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