/// <summary> /// 得到一个对象实体 /// 根据学生姓名查询 /// </summary> public Student.Model.STUDENT_INFO GetModel(string NAME, int flag) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 STUNO,CLASSNO,NAME,IDCARD,SEX,NATION,POLITICAL,SOURCE,INTENTEDDATE,GRADUATIONDATE,PHONE,EMAIL,DORMITORY_ID,FATHERPHONE,MOTHERPHONE,FAMILYPHONE,FAMILYADDRESS,ZIPCODE,QQNO,MICROMESSAGENO,PICTURE,STATUS from STUDENT_INFO "); strSql.Append(" where NAME=@NAME"); SqlParameter[] parameters = { new SqlParameter("@NAME", SqlDbType.VarChar, 20) }; parameters[0].Value = NAME; Student.Model.STUDENT_INFO model = new Student.Model.STUDENT_INFO(); DataSet ds = SqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Student.Model.STUDENT_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into STUDENT_INFO("); strSql.Append("STUNO,CLASSNO,NAME,IDCARD,SEX,NATION,POLITICAL,SOURCE,INTENTEDDATE,GRADUATIONDATE,PHONE,EMAIL,DORMITORY_ID,FATHERPHONE,MOTHERPHONE,FAMILYPHONE,FAMILYADDRESS,ZIPCODE,QQNO,MICROMESSAGENO,PICTURE,STATUS)"); strSql.Append(" values ("); strSql.Append("@STUNO,@CLASSNO,@NAME,@IDCARD,@SEX,@NATION,@POLITICAL,@SOURCE,@INTENTEDDATE,@GRADUATIONDATE,@PHONE,@EMAIL,@DORMITORY_ID,@FATHERPHONE,@MOTHERPHONE,@FAMILYPHONE,@FAMILYADDRESS,@ZIPCODE,@QQNO,@MICROMESSAGENO,@PICTURE,@STATUS)"); SqlParameter[] parameters = { new SqlParameter("@STUNO", SqlDbType.VarChar, 10), new SqlParameter("@CLASSNO", SqlDbType.Int, 4), new SqlParameter("@NAME", SqlDbType.VarChar, 20), new SqlParameter("@IDCARD", SqlDbType.VarChar, 18), new SqlParameter("@SEX", SqlDbType.VarChar, 2), new SqlParameter("@NATION", SqlDbType.VarChar, 20), new SqlParameter("@POLITICAL", SqlDbType.VarChar, 20), new SqlParameter("@SOURCE", SqlDbType.VarChar, 100), new SqlParameter("@INTENTEDDATE", SqlDbType.DateTime), new SqlParameter("@GRADUATIONDATE", SqlDbType.DateTime), new SqlParameter("@PHONE", SqlDbType.VarChar, 20), new SqlParameter("@EMAIL", SqlDbType.VarChar, 40), new SqlParameter("@DORMITORY_ID", SqlDbType.Decimal, 9), new SqlParameter("@FATHERPHONE", SqlDbType.VarChar, 20), new SqlParameter("@MOTHERPHONE", SqlDbType.VarChar, 20), new SqlParameter("@FAMILYPHONE", SqlDbType.VarChar, 20), new SqlParameter("@FAMILYADDRESS", SqlDbType.VarChar, 200), new SqlParameter("@ZIPCODE", SqlDbType.VarChar, 6), new SqlParameter("@QQNO", SqlDbType.VarChar, 20), new SqlParameter("@MICROMESSAGENO", SqlDbType.VarChar, 20), new SqlParameter("@PICTURE", SqlDbType.Image), new SqlParameter("@STATUS", SqlDbType.Int, 4) }; parameters[0].Value = model.STUNO; parameters[1].Value = model.CLASSNO; parameters[2].Value = model.NAME; parameters[3].Value = model.IDCARD; parameters[4].Value = model.SEX; parameters[5].Value = model.NATION; parameters[6].Value = model.POLITICAL; parameters[7].Value = model.SOURCE; parameters[8].Value = model.INTENTEDDATE; parameters[9].Value = model.GRADUATIONDATE; parameters[10].Value = model.PHONE; parameters[11].Value = model.EMAIL; parameters[12].Value = model.DORMITORY_ID; parameters[13].Value = model.FATHERPHONE; parameters[14].Value = model.MOTHERPHONE; parameters[15].Value = model.FAMILYPHONE; parameters[16].Value = model.FAMILYADDRESS; parameters[17].Value = model.ZIPCODE; parameters[18].Value = model.QQNO; parameters[19].Value = model.MICROMESSAGENO; parameters[20].Value = model.PICTURE; parameters[21].Value = model.STATUS; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.STUDENT_INFO DataRowToModel(DataRow row) { Student.Model.STUDENT_INFO model = new Student.Model.STUDENT_INFO(); if (row != null) { if (row["STUNO"] != null) { model.STUNO = row["STUNO"].ToString(); } if (row["CLASSNO"] != null && row["CLASSNO"].ToString() != "") { model.CLASSNO = int.Parse(row["CLASSNO"].ToString()); } if (row["NAME"] != null) { model.NAME = row["NAME"].ToString(); } if (row["IDCARD"] != null) { model.IDCARD = row["IDCARD"].ToString(); } if (row["SEX"] != null) { model.SEX = row["SEX"].ToString(); } if (row["NATION"] != null) { model.NATION = row["NATION"].ToString(); } if (row["POLITICAL"] != null) { model.POLITICAL = row["POLITICAL"].ToString(); } if (row["SOURCE"] != null) { model.SOURCE = row["SOURCE"].ToString(); } if (row["INTENTEDDATE"] != null && row["INTENTEDDATE"].ToString() != "") { model.INTENTEDDATE = DateTime.Parse(row["INTENTEDDATE"].ToString()); } if (row["GRADUATIONDATE"] != null && row["GRADUATIONDATE"].ToString() != "") { model.GRADUATIONDATE = DateTime.Parse(row["GRADUATIONDATE"].ToString()); } if (row["PHONE"] != null) { model.PHONE = row["PHONE"].ToString(); } if (row["EMAIL"] != null) { model.EMAIL = row["EMAIL"].ToString(); } if (row["DORMITORY_ID"] != null && row["DORMITORY_ID"].ToString() != "") { model.DORMITORY_ID = decimal.Parse(row["DORMITORY_ID"].ToString()); } if (row["FATHERPHONE"] != null) { model.FATHERPHONE = row["FATHERPHONE"].ToString(); } if (row["MOTHERPHONE"] != null) { model.MOTHERPHONE = row["MOTHERPHONE"].ToString(); } if (row["FAMILYPHONE"] != null) { model.FAMILYPHONE = row["FAMILYPHONE"].ToString(); } if (row["FAMILYADDRESS"] != null) { model.FAMILYADDRESS = row["FAMILYADDRESS"].ToString(); } if (row["ZIPCODE"] != null) { model.ZIPCODE = row["ZIPCODE"].ToString(); } if (row["QQNO"] != null) { model.QQNO = row["QQNO"].ToString(); } if (row["MICROMESSAGENO"] != null) { model.MICROMESSAGENO = row["MICROMESSAGENO"].ToString(); } if (row["PICTURE"] != null && row["PICTURE"].ToString() != "") { model.PICTURE = (byte[])row["PICTURE"]; } if (row["STATUS"] != null && row["STATUS"].ToString() != "") { model.STATUS = int.Parse(row["STATUS"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Student.Model.STUDENT_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update STUDENT_INFO set "); strSql.Append("CLASSNO=@CLASSNO,"); strSql.Append("NAME=@NAME,"); strSql.Append("IDCARD=@IDCARD,"); strSql.Append("SEX=@SEX,"); strSql.Append("NATION=@NATION,"); strSql.Append("POLITICAL=@POLITICAL,"); strSql.Append("SOURCE=@SOURCE,"); strSql.Append("INTENTEDDATE=@INTENTEDDATE,"); strSql.Append("GRADUATIONDATE=@GRADUATIONDATE,"); strSql.Append("PHONE=@PHONE,"); strSql.Append("EMAIL=@EMAIL,"); strSql.Append("DORMITORY_ID=@DORMITORY_ID,"); strSql.Append("FATHERPHONE=@FATHERPHONE,"); strSql.Append("MOTHERPHONE=@MOTHERPHONE,"); strSql.Append("FAMILYPHONE=@FAMILYPHONE,"); strSql.Append("FAMILYADDRESS=@FAMILYADDRESS,"); strSql.Append("ZIPCODE=@ZIPCODE,"); strSql.Append("QQNO=@QQNO,"); strSql.Append("MICROMESSAGENO=@MICROMESSAGENO,"); strSql.Append("PICTURE=@PICTURE,"); strSql.Append("STATUS=@STATUS"); strSql.Append(" where STUNO=@STUNO "); SqlParameter[] parameters = { new SqlParameter("@CLASSNO", SqlDbType.Int, 4), new SqlParameter("@NAME", SqlDbType.VarChar, 20), new SqlParameter("@IDCARD", SqlDbType.VarChar, 18), new SqlParameter("@SEX", SqlDbType.VarChar, 2), new SqlParameter("@NATION", SqlDbType.VarChar, 20), new SqlParameter("@POLITICAL", SqlDbType.VarChar, 20), new SqlParameter("@SOURCE", SqlDbType.VarChar, 100), new SqlParameter("@INTENTEDDATE", SqlDbType.DateTime), new SqlParameter("@GRADUATIONDATE", SqlDbType.DateTime), new SqlParameter("@PHONE", SqlDbType.VarChar, 20), new SqlParameter("@EMAIL", SqlDbType.VarChar, 40), new SqlParameter("@DORMITORY_ID", SqlDbType.Decimal, 9), new SqlParameter("@FATHERPHONE", SqlDbType.VarChar, 20), new SqlParameter("@MOTHERPHONE", SqlDbType.VarChar, 20), new SqlParameter("@FAMILYPHONE", SqlDbType.VarChar, 20), new SqlParameter("@FAMILYADDRESS", SqlDbType.VarChar, 200), new SqlParameter("@ZIPCODE", SqlDbType.VarChar, 6), new SqlParameter("@QQNO", SqlDbType.VarChar, 20), new SqlParameter("@MICROMESSAGENO", SqlDbType.VarChar, 20), new SqlParameter("@PICTURE", SqlDbType.Image), new SqlParameter("@STATUS", SqlDbType.Int, 4), new SqlParameter("@STUNO", SqlDbType.VarChar, 10) }; parameters[0].Value = model.CLASSNO; parameters[1].Value = model.NAME; parameters[2].Value = model.IDCARD; parameters[3].Value = model.SEX; parameters[4].Value = model.NATION; parameters[5].Value = model.POLITICAL; parameters[6].Value = model.SOURCE; parameters[7].Value = model.INTENTEDDATE; parameters[8].Value = model.GRADUATIONDATE; parameters[9].Value = model.PHONE; parameters[10].Value = model.EMAIL; parameters[11].Value = model.DORMITORY_ID; parameters[12].Value = model.FATHERPHONE; parameters[13].Value = model.MOTHERPHONE; parameters[14].Value = model.FAMILYPHONE; parameters[15].Value = model.FAMILYADDRESS; parameters[16].Value = model.ZIPCODE; parameters[17].Value = model.QQNO; parameters[18].Value = model.MICROMESSAGENO; parameters[19].Value = model.PICTURE; parameters[20].Value = model.STATUS; parameters[21].Value = model.STUNO; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }