/// <summary> /// 更新一条数据 /// </summary> public bool Update(Student.Model.COURSE_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update COURSE_INFO set "); strSql.Append("COURSETYPENO=@COURSETYPENO,"); strSql.Append("COURSENAME=@COURSENAME,"); strSql.Append("TOTALHOUR=@TOTALHOUR,"); strSql.Append("THEORYHOUR=@THEORYHOUR,"); strSql.Append("EXPERIMENTHOUR=@EXPERIMENTHOUR,"); strSql.Append("CREDIT=@CREDIT,"); strSql.Append("MEMO=@MEMO"); strSql.Append(" where COURSENO=@COURSENO "); SqlParameter[] parameters = { new SqlParameter("@COURSETYPENO", SqlDbType.Decimal, 9), new SqlParameter("@COURSENAME", SqlDbType.VarChar, 100), new SqlParameter("@TOTALHOUR", SqlDbType.Int, 4), new SqlParameter("@THEORYHOUR", SqlDbType.Int, 4), new SqlParameter("@EXPERIMENTHOUR", SqlDbType.Int, 4), new SqlParameter("@CREDIT", SqlDbType.Float, 8), new SqlParameter("@MEMO", SqlDbType.VarChar, 500), new SqlParameter("@COURSENO", SqlDbType.Decimal, 9) }; parameters[0].Value = model.COURSETYPENO; parameters[1].Value = model.COURSENAME; parameters[2].Value = model.TOTALHOUR; parameters[3].Value = model.THEORYHOUR; parameters[4].Value = model.EXPERIMENTHOUR; parameters[5].Value = model.CREDIT; parameters[6].Value = model.MEMO; parameters[7].Value = model.COURSENO; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.COURSE_INFO DataRowToModel(DataRow row) { Student.Model.COURSE_INFO model = new Student.Model.COURSE_INFO(); if (row != null) { if (row["COURSENO"] != null && row["COURSENO"].ToString() != "") { model.COURSENO = decimal.Parse(row["COURSENO"].ToString()); } if (row["COURSETYPENO"] != null && row["COURSETYPENO"].ToString() != "") { model.COURSETYPENO = decimal.Parse(row["COURSETYPENO"].ToString()); } if (row["COURSENAME"] != null) { model.COURSENAME = row["COURSENAME"].ToString(); } if (row["TOTALHOUR"] != null && row["TOTALHOUR"].ToString() != "") { model.TOTALHOUR = int.Parse(row["TOTALHOUR"].ToString()); } if (row["THEORYHOUR"] != null && row["THEORYHOUR"].ToString() != "") { model.THEORYHOUR = int.Parse(row["THEORYHOUR"].ToString()); } if (row["EXPERIMENTHOUR"] != null && row["EXPERIMENTHOUR"].ToString() != "") { model.EXPERIMENTHOUR = int.Parse(row["EXPERIMENTHOUR"].ToString()); } if (row["CREDIT"] != null && row["CREDIT"].ToString() != "") { model.CREDIT = decimal.Parse(row["CREDIT"].ToString()); } if (row["MEMO"] != null) { model.MEMO = row["MEMO"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Student.Model.COURSE_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into COURSE_INFO("); strSql.Append("COURSETYPENO,COURSENAME,TOTALHOUR,THEORYHOUR,EXPERIMENTHOUR,CREDIT,MEMO)"); strSql.Append(" values ("); strSql.Append("@COURSETYPENO,@COURSENAME,@TOTALHOUR,@THEORYHOUR,@EXPERIMENTHOUR,@CREDIT,@MEMO)"); SqlParameter[] parameters = { new SqlParameter("@COURSETYPENO", SqlDbType.Decimal, 9), new SqlParameter("@COURSENAME", SqlDbType.VarChar, 100), new SqlParameter("@TOTALHOUR", SqlDbType.Int, 4), new SqlParameter("@THEORYHOUR", SqlDbType.Int, 4), new SqlParameter("@EXPERIMENTHOUR", SqlDbType.Int, 4), new SqlParameter("@CREDIT", SqlDbType.Float, 8), new SqlParameter("@MEMO", SqlDbType.VarChar, 500) }; parameters[0].Value = model.COURSETYPENO; parameters[1].Value = model.COURSENAME; parameters[2].Value = model.TOTALHOUR; parameters[3].Value = model.THEORYHOUR; parameters[4].Value = model.EXPERIMENTHOUR; parameters[5].Value = model.CREDIT; parameters[6].Value = model.MEMO; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.COURSE_INFO GetModel(string COURSENAME) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 COURSENO,COURSETYPENO,COURSENAME,TOTALHOUR,THEORYHOUR,EXPERIMENTHOUR,CREDIT,MEMO from COURSE_INFO "); strSql.Append(" where COURSENAME=@COURSENAME "); SqlParameter[] parameters = { new SqlParameter("@COURSENAME", SqlDbType.VarChar, 100) }; parameters[0].Value = COURSENAME; Student.Model.COURSE_INFO model = new Student.Model.COURSE_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); } }