/// <summary> /// 增加一条数据 /// </summary> public bool Add(Student.Model.CLASS_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CLASS_INFO("); strSql.Append("MAJORDIRCTNO,CLASSNAME,TEACHERNO1,TEACHERNO2,TEACHERNO3)"); strSql.Append(" values ("); strSql.Append("@MAJORDIRCTNO,@CLASSNAME,@TEACHERNO1,@TEACHERNO2,@TEACHERNO3)"); SqlParameter[] parameters = { new SqlParameter("@MAJORDIRCTNO", SqlDbType.Int, 4), new SqlParameter("@CLASSNAME", SqlDbType.VarChar, 10), new SqlParameter("@TEACHERNO1", SqlDbType.Int, 4), new SqlParameter("@TEACHERNO2", SqlDbType.Int, 4), new SqlParameter("@TEACHERNO3", SqlDbType.Int, 4) }; parameters[0].Value = model.MAJORDIRCTNO; parameters[1].Value = model.CLASSNAME; parameters[2].Value = model.TEACHERNO1; parameters[3].Value = model.TEACHERNO2; parameters[4].Value = model.TEACHERNO3; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.CLASS_INFO DataRowToModel(DataRow row) { Student.Model.CLASS_INFO model = new Student.Model.CLASS_INFO(); if (row != null) { if (row["CLASSNO"] != null && row["CLASSNO"].ToString() != "") { model.CLASSNO = int.Parse(row["CLASSNO"].ToString()); } if (row["MAJORDIRCTNO"] != null && row["MAJORDIRCTNO"].ToString() != "") { model.MAJORDIRCTNO = int.Parse(row["MAJORDIRCTNO"].ToString()); } if (row["CLASSNAME"] != null) { model.CLASSNAME = row["CLASSNAME"].ToString(); } if (row["TEACHERNO1"] != null && row["TEACHERNO1"].ToString() != "") { model.TEACHERNO1 = int.Parse(row["TEACHERNO1"].ToString()); } if (row["TEACHERNO2"] != null && row["TEACHERNO2"].ToString() != "") { model.TEACHERNO2 = int.Parse(row["TEACHERNO2"].ToString()); } if (row["TEACHERNO3"] != null && row["TEACHERNO3"].ToString() != "") { model.TEACHERNO3 = int.Parse(row["TEACHERNO3"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Student.Model.CLASS_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CLASS_INFO set "); strSql.Append("MAJORDIRCTNO=@MAJORDIRCTNO,"); strSql.Append("CLASSNAME=@CLASSNAME,"); strSql.Append("TEACHERNO1=@TEACHERNO1,"); strSql.Append("TEACHERNO2=@TEACHERNO2,"); strSql.Append("TEACHERNO3=@TEACHERNO3"); strSql.Append(" where CLASSNO=@CLASSNO "); SqlParameter[] parameters = { new SqlParameter("@MAJORDIRCTNO", SqlDbType.Int, 4), new SqlParameter("@CLASSNAME", SqlDbType.VarChar, 10), new SqlParameter("@TEACHERNO1", SqlDbType.Int, 4), new SqlParameter("@TEACHERNO2", SqlDbType.Int, 4), new SqlParameter("@TEACHERNO3", SqlDbType.Int, 4), new SqlParameter("@CLASSNO", SqlDbType.Int, 4) }; parameters[0].Value = model.MAJORDIRCTNO; parameters[1].Value = model.CLASSNAME; parameters[2].Value = model.TEACHERNO1; parameters[3].Value = model.TEACHERNO2; parameters[4].Value = model.TEACHERNO3; parameters[5].Value = model.CLASSNO; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.CLASS_INFO GetModel(string CLASSNAME) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 CLASSNO,MAJORDIRCTNO,CLASSNAME,TEACHERNO1,TEACHERNO2,TEACHERNO3 from CLASS_INFO "); strSql.Append(" where CLASSNAME=@CLASSNAME "); SqlParameter[] parameters = { new SqlParameter("@CLASSNAME", SqlDbType.VarChar, 10) }; parameters[0].Value = CLASSNAME; Student.Model.CLASS_INFO model = new Student.Model.CLASS_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); } }