图书管理系统

 public class MemberDAL
    {
        //列表的显示与查询。
        public static Member M_select_list(string name,string addr, int tel = 0)
        {
            var sql = $"select * from Menber where 1=1";
            if (name != "")
            {
                sql += " and M_name like'%" + name + "%'";
            }
            if (addr != "")
            {
                sql += " and M_address like'%" + addr + "%'";
            }
            if (tel!=0)
            {
                sql += " and M_tel like'%" + tel + "%'";
            }
            DataTable adap = DB.Query(sql);
            if (adap.Rows.Count > 0)
            {
                var row = adap.Rows[0];
                Member mer = new Member()
                {
                    M_name = Convert.ToString(row["M_name"]),
                    M_tel = Convert.ToInt32(row["M_tel"]),
                    M_sex = Convert.ToString(row["M_sex"]),
                    M_address = Convert.ToString(row["M_address"]),
                    M_tstart = Convert.ToDateTime(row["M_tstart"]),
                    M_tend = Convert.ToDateTime(row["M_tend"])
                };
                return mer;
            }
            return null;
        }
        //添加与修改
        public static int add(Member mer)
        {
            var sql = $"insert into Member values('{mer.M_name}','{mer.M_tel}','{mer.M_sex}','{mer.M_address}','{mer.M_tstart}','{mer.M_tend}')";
            int adap = DB.NoQuery(sql);
            return adap;
        }
        public static int update(Member mer)
        {
            var sql = $"update Menber SET M_name = '{mer.M_name}',M_sex='{mer.M_sex}',M_address='{mer.M_address}' where M_userid = '{mer.M_userid}' ";
            return DB.NoQuery(sql);
        }
        //删除
        public static int delect(int userid)
        {
            var sql = $"delete from Menber where M_userid='{userid}'; ";
            return DB.NoQuery(sql);
        }
    }