/// <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;
}
}
