/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.学生表 GetModel(string 学号, string 邮箱) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 姓名,性别,生日,学院,专业,班级,学号,邮箱,头像地址 from 学生表 "); strSql.Append(" where 学号=@学号 or 邮箱=@邮箱 "); SqlParameter[] parameters = { new SqlParameter("@学号", SqlDbType.Char, 12), new SqlParameter("@邮箱", SqlDbType.VarChar, 20) }; parameters[0].Value = 学号; parameters[1].Value = 邮箱; Maticsoft.Model.学生表 model = new Maticsoft.Model.学生表(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
//得到学生详细信息 public List <object> getUserCardInfoDetails(string userid) { Maticsoft.Model.学生证表 newinfo = new Maticsoft.Model.学生证表(); Maticsoft.BLL.学生证表 SQLOption = new Maticsoft.BLL.学生证表(); Maticsoft.Model.学生表 XueshengInfo = new Maticsoft.Model.学生表(); Maticsoft.BLL.学生表 SQLXueshengInfo = new Maticsoft.BLL.学生表(); if (SQLOption.Exists(userid)) { newinfo = SQLOption.GetModel(userid); //得到学生证实体类 XueshengInfo = SQLXueshengInfo.GetModel(userid, ""); //得到学生信息 } var data = new List <object>() { new { StuName = newinfo.姓名, StuSex = XueshengInfo.性别, StuBirth = XueshengInfo.生日, StuInstitution = XueshengInfo.学院, StuPro = XueshengInfo.专业, StuClass = XueshengInfo.班级, StuId = newinfo.学号, StuFazhengTime = newinfo.发证日期, StuYouxiaoTime = newinfo.效期, Option = "测试", }, }; return(data); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.学生表 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 学生表 set "); strSql.Append("姓名=@姓名,"); strSql.Append("性别=@性别,"); strSql.Append("生日=@生日,"); strSql.Append("学院=@学院,"); strSql.Append("专业=@专业,"); strSql.Append("班级=@班级,"); strSql.Append("头像地址=@头像地址"); strSql.Append(" where 学号=@学号 and 邮箱=@邮箱 "); SqlParameter[] parameters = { new SqlParameter("@姓名", SqlDbType.VarChar, 10), new SqlParameter("@性别", SqlDbType.Char, 2), new SqlParameter("@生日", SqlDbType.Date, 3), new SqlParameter("@学院", SqlDbType.VarChar, 20), new SqlParameter("@专业", SqlDbType.VarChar, 20), new SqlParameter("@班级", SqlDbType.Char, 10), new SqlParameter("@头像地址", SqlDbType.VarChar, 20), new SqlParameter("@学号", SqlDbType.Char, 12), new SqlParameter("@邮箱", SqlDbType.VarChar, 20) }; parameters[0].Value = model.姓名; parameters[1].Value = model.性别; parameters[2].Value = model.生日; parameters[3].Value = model.学院; parameters[4].Value = model.专业; parameters[5].Value = model.班级; parameters[6].Value = model.头像地址; parameters[7].Value = model.学号; parameters[8].Value = model.邮箱; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.学生表 DataRowToModel(DataRow row) { Maticsoft.Model.学生表 model = new Maticsoft.Model.学生表(); if (row != null) { if (row["姓名"] != null) { model.姓名 = row["姓名"].ToString(); } if (row["性别"] != null) { model.性别 = row["性别"].ToString(); } if (row["生日"] != null && row["生日"].ToString() != "") { model.生日 = DateTime.Parse(row["生日"].ToString()); } if (row["学院"] != null) { model.学院 = row["学院"].ToString(); } if (row["专业"] != null) { model.专业 = row["专业"].ToString(); } if (row["班级"] != null) { model.班级 = row["班级"].ToString(); } if (row["学号"] != null) { model.学号 = row["学号"].ToString(); } if (row["邮箱"] != null) { model.邮箱 = row["邮箱"].ToString(); } if (row["头像地址"] != null) { model.头像地址 = row["头像地址"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.学生表 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into 学生表("); strSql.Append("姓名,性别,生日,学院,专业,班级,学号,邮箱,头像地址)"); strSql.Append(" values ("); strSql.Append("@姓名,@性别,@生日,@学院,@专业,@班级,@学号,@邮箱,@头像地址)"); SqlParameter[] parameters = { new SqlParameter("@姓名", SqlDbType.VarChar, 10), new SqlParameter("@性别", SqlDbType.Char, 2), new SqlParameter("@生日", SqlDbType.Date, 3), new SqlParameter("@学院", SqlDbType.VarChar, 20), new SqlParameter("@专业", SqlDbType.VarChar, 20), new SqlParameter("@班级", SqlDbType.Char, 10), new SqlParameter("@学号", SqlDbType.Char, 12), new SqlParameter("@邮箱", SqlDbType.VarChar, 20), new SqlParameter("@头像地址", SqlDbType.VarChar, 20) }; parameters[0].Value = model.姓名; parameters[1].Value = model.性别; parameters[2].Value = model.生日; parameters[3].Value = model.学院; parameters[4].Value = model.专业; parameters[5].Value = model.班级; parameters[6].Value = model.学号; parameters[7].Value = model.邮箱; parameters[8].Value = model.头像地址; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }