public static int Add(Xueli xl)
{
String sql = "insert into Xueli(degreename) values(@degreename)";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@degreename", xl.XueliName));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
public static List <Xueli> GetAll()
{
String sql = "select * from Xueli";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
List <Xueli> list = new List <Xueli>();
foreach (DataRow dr in dt.Rows)
{
Xueli xl = new Xueli();
xl.ID = Convert.ToInt32(dr["id"]);
xl.XueliName = dr["degreename"].ToString();
list.Add(xl);
}
return(list);
}
public static int Add(Xueli xl)
{
return(FTInterviewDAL.XueliService.Add(xl));
}
