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);
}
}
05-19
735
04-10