/// <summary> /// 更新一条数据 /// </summary> public void Update(LearnSite.Model.TermTotal model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update TermTotal set "); strSql.Append("Tnum=@Tnum,"); strSql.Append("Tterm=@Tterm,"); strSql.Append("Tgrade=@Tgrade,"); strSql.Append("Tscore=@Tscore,"); strSql.Append("Tgscore=@Tgscore,"); strSql.Append("Tquiz=@Tquiz,"); strSql.Append("Tattitude=@Tattitude,"); strSql.Append("Twscore=@Twscore,"); strSql.Append("Ttscore=@Ttscore,"); strSql.Append("Tpscore=@Tpscore,"); strSql.Append("Tallscore=@Tallscore,"); strSql.Append("Tape=@Tape"); strSql.Append(" where Tid=@Tid "); SqlParameter[] parameters = { new SqlParameter("@Tid", SqlDbType.Int,4), new SqlParameter("@Tnum", SqlDbType.NVarChar,50), new SqlParameter("@Tterm", SqlDbType.Int,4), new SqlParameter("@Tgrade", SqlDbType.Int,4), new SqlParameter("@Tscore", SqlDbType.Int,4), new SqlParameter("@Tgscore", SqlDbType.Int,4), new SqlParameter("@Tquiz", SqlDbType.Int,4), new SqlParameter("@Tattitude", SqlDbType.Int,4), new SqlParameter("@Twscore", SqlDbType.Int,4), new SqlParameter("@Ttscore", SqlDbType.Int,4), new SqlParameter("@Tpscore", SqlDbType.Int,4), new SqlParameter("@Tallscore", SqlDbType.Int,4), new SqlParameter("@Tape", SqlDbType.NVarChar,1)}; parameters[0].Value = model.Tid; parameters[1].Value = model.Tnum; parameters[2].Value = model.Tterm; parameters[3].Value = model.Tgrade; parameters[4].Value = model.Tscore; parameters[5].Value = model.Tgscore; parameters[6].Value = model.Tquiz; parameters[7].Value = model.Tattitude; parameters[8].Value = model.Twscore; parameters[9].Value = model.Ttscore; parameters[10].Value = model.Tpscore; parameters[11].Value = model.Tallscore; parameters[12].Value = model.Tape; DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(LearnSite.Model.TermTotal model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into TermTotal("); strSql.Append("Tnum,Tterm,Tgrade,Tscore,Tgscore,Tquiz,Tattitude,Twscore,Ttscore,Tpscore,Tallscore,Tape)"); strSql.Append(" values ("); strSql.Append("@Tnum,@Tterm,@Tgrade,@Tscore,@Tgscore,@Tquiz,@Tattitude,@Twscore,@Ttscore,@Tpscore,@Tallscore,@Tape)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Tnum", SqlDbType.NVarChar,50), new SqlParameter("@Tterm", SqlDbType.Int,4), new SqlParameter("@Tgrade", SqlDbType.Int,4), new SqlParameter("@Tscore", SqlDbType.Int,4), new SqlParameter("@Tgscore", SqlDbType.Int,4), new SqlParameter("@Tquiz", SqlDbType.Int,4), new SqlParameter("@Tattitude", SqlDbType.Int,4), new SqlParameter("@Twscore", SqlDbType.Int,4), new SqlParameter("@Ttscore", SqlDbType.Int,4), new SqlParameter("@Tpscore", SqlDbType.Int,4), new SqlParameter("@Tallscore", SqlDbType.Int,4), new SqlParameter("@Tape", SqlDbType.NVarChar,1)}; parameters[0].Value = model.Tnum; parameters[1].Value = model.Tterm; parameters[2].Value = model.Tgrade; parameters[3].Value = model.Tscore; parameters[4].Value = model.Tgscore; parameters[5].Value = model.Tquiz; parameters[6].Value = model.Tattitude; parameters[7].Value = model.Twscore; parameters[8].Value = model.Ttscore; parameters[9].Value = model.Tpscore; parameters[10].Value = model.Tallscore; parameters[11].Value = model.Tape; object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 1; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 得到一个对象实体 /// </summary> public LearnSite.Model.TermTotal GetModel(int Tid) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Tid,Tnum,Tterm,Tgrade,Tscore,Tgscore,Tquiz,Tattitude,Twscore,Ttscore,Tpscore,Tallscore,Tape from TermTotal "); strSql.Append(" where Tid=@Tid "); SqlParameter[] parameters = { new SqlParameter("@Tid", SqlDbType.Int,4)}; parameters[0].Value = Tid; LearnSite.Model.TermTotal model=new LearnSite.Model.TermTotal(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["Tid"].ToString()!="") { model.Tid=int.Parse(ds.Tables[0].Rows[0]["Tid"].ToString()); } model.Tnum=ds.Tables[0].Rows[0]["Tnum"].ToString(); if(ds.Tables[0].Rows[0]["Tterm"].ToString()!="") { model.Tterm=int.Parse(ds.Tables[0].Rows[0]["Tterm"].ToString()); } if(ds.Tables[0].Rows[0]["Tgrade"].ToString()!="") { model.Tgrade=int.Parse(ds.Tables[0].Rows[0]["Tgrade"].ToString()); } if(ds.Tables[0].Rows[0]["Tscore"].ToString()!="") { model.Tscore=int.Parse(ds.Tables[0].Rows[0]["Tscore"].ToString()); } if(ds.Tables[0].Rows[0]["Tgscore"].ToString()!="") { model.Tgscore=int.Parse(ds.Tables[0].Rows[0]["Tgscore"].ToString()); } if(ds.Tables[0].Rows[0]["Tquiz"].ToString()!="") { model.Tquiz=int.Parse(ds.Tables[0].Rows[0]["Tquiz"].ToString()); } if(ds.Tables[0].Rows[0]["Tattitude"].ToString()!="") { model.Tattitude=int.Parse(ds.Tables[0].Rows[0]["Tattitude"].ToString()); } if(ds.Tables[0].Rows[0]["Twscore"].ToString()!="") { model.Twscore=int.Parse(ds.Tables[0].Rows[0]["Twscore"].ToString()); } if(ds.Tables[0].Rows[0]["Ttscore"].ToString()!="") { model.Ttscore=int.Parse(ds.Tables[0].Rows[0]["Ttscore"].ToString()); } if(ds.Tables[0].Rows[0]["Tpscore"].ToString()!="") { model.Tpscore=int.Parse(ds.Tables[0].Rows[0]["Tpscore"].ToString()); } if(ds.Tables[0].Rows[0]["Tallscore"].ToString()!="") { model.Tallscore=int.Parse(ds.Tables[0].Rows[0]["Tallscore"].ToString()); } model.Tape=ds.Tables[0].Rows[0]["Tape"].ToString(); return model; } else { return null; } }