/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.NEEDYSTUDENT_INFO DataRowToModel(DataRow row) { Student.Model.NEEDYSTUDENT_INFO model = new Student.Model.NEEDYSTUDENT_INFO(); if (row != null) { if (row["RCD_ID"] != null && row["RCD_ID"].ToString() != "") { model.RCD_ID = decimal.Parse(row["RCD_ID"].ToString()); } if (row["STUNO"] != null) { model.STUNO = row["STUNO"].ToString(); } if (row["TERMNO"] != null && row["TERMNO"].ToString() != "") { model.TERMNO = int.Parse(row["TERMNO"].ToString()); } if (row["RANKING"] != null && row["RANKING"].ToString() != "") { model.RANKING = int.Parse(row["RANKING"].ToString()); } if (row["TYPE"] != null && row["TYPE"].ToString() != "") { model.TYPE = int.Parse(row["TYPE"].ToString()); } if (row["MEMO"] != null) { model.MEMO = row["MEMO"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Student.Model.NEEDYSTUDENT_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into NEEDYSTUDENT_INFO("); strSql.Append("STUNO,TERMNO,RANKING,TYPE,MEMO)"); strSql.Append(" values ("); strSql.Append("@STUNO,@TERMNO,@RANKING,@TYPE,@MEMO)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@STUNO", SqlDbType.VarChar, 10), new SqlParameter("@TERMNO", SqlDbType.Int, 4), new SqlParameter("@RANKING", SqlDbType.Int, 4), new SqlParameter("@TYPE", SqlDbType.Int, 4), new SqlParameter("@MEMO", SqlDbType.VarChar, 2000) }; parameters[0].Value = model.STUNO; parameters[1].Value = model.TERMNO; parameters[2].Value = model.RANKING; parameters[3].Value = model.TYPE; parameters[4].Value = model.MEMO; object obj = SqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Student.Model.NEEDYSTUDENT_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update NEEDYSTUDENT_INFO set "); strSql.Append("STUNO=@STUNO,"); strSql.Append("TERMNO=@TERMNO,"); strSql.Append("RANKING=@RANKING,"); strSql.Append("TYPE=@TYPE,"); strSql.Append("MEMO=@MEMO"); strSql.Append(" where RCD_ID=@RCD_ID"); SqlParameter[] parameters = { new SqlParameter("@STUNO", SqlDbType.VarChar, 10), new SqlParameter("@TERMNO", SqlDbType.Int, 4), new SqlParameter("@RANKING", SqlDbType.Int, 4), new SqlParameter("@TYPE", SqlDbType.Int, 4), new SqlParameter("@MEMO", SqlDbType.VarChar, 2000), new SqlParameter("@RCD_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.STUNO; parameters[1].Value = model.TERMNO; parameters[2].Value = model.RANKING; parameters[3].Value = model.TYPE; parameters[4].Value = model.MEMO; parameters[5].Value = model.RCD_ID; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.NEEDYSTUDENT_INFO GetModel(decimal RCD_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RCD_ID,STUNO,TERMNO,RANKING,TYPE,MEMO from NEEDYSTUDENT_INFO "); strSql.Append(" where RCD_ID=@RCD_ID"); SqlParameter[] parameters = { new SqlParameter("@RCD_ID", SqlDbType.Decimal) }; parameters[0].Value = RCD_ID; Student.Model.NEEDYSTUDENT_INFO model = new Student.Model.NEEDYSTUDENT_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); } }