public bool Add(Model.Teamhope model)
{
string strSql = "insert into [teamhope] values(@TeamNo,@First,@Second,@Third,@TeacherNo,@Time)";
SqlParameter[] parameters =
{
new SqlParameter("@TeamNo", SqlDbType.VarChar, 50),
new SqlParameter("@First", SqlDbType.VarChar, 50),
new SqlParameter("@Second", SqlDbType.VarChar, 50),
new SqlParameter("@Third", SqlDbType.VarChar, 50),
new SqlParameter("@TeacherNo", SqlDbType.VarChar, 50),
new SqlParameter("@Time", SqlDbType.Int),
};
parameters[0].Value = model.TeamNo;
parameters[1].Value = model.First;
parameters[2].Value = model.Second;
parameters[3].Value = model.Third;
parameters[4].Value = model.TeacherNo;
parameters[5].Value = model.Time;
int n = SqlDbHelper.ExecuteNonQuery(strSql, CommandType.Text, parameters);
if (n == 1)
{
return(true);
}
else
{
return(false);
}
}
public Model.Teamhope Get(string teamNo)
{
string strSql = "select top 1 first,second,third,teacherno,time from [teamhope] where teamno=@TeamNo";
SqlParameter[] parameters =
{
new SqlParameter("@TeamNo", SqlDbType.VarChar, 50),
};
parameters[0].Value = teamNo;
DataTable dt = SqlDbHelper.ExecuteDataTable(strSql, CommandType.Text, parameters);
if (dt.Rows.Count > 0)
{
Model.Teamhope model = new Model.Teamhope();
model.TeamNo = teamNo;
if (dt.Rows[0]["teamNo"] != null && dt.Rows[0]["teamNo"].ToString() != "")
{
model.TeamNo = dt.Rows[0]["StuName"].ToString();
}
if (dt.Rows[0]["first"] != null && dt.Rows[0]["first"].ToString() != "")
{
model.First = dt.Rows[0]["Grade"].ToString();
}
if (dt.Rows[0]["second"] != null && dt.Rows[0]["second"].ToString() != "")
{
model.Second = dt.Rows[0]["Subject"].ToString();
}
if (dt.Rows[0]["third"] != null && dt.Rows[0]["third"].ToString() != "")
{
model.Third = dt.Rows[0]["College"].ToString();
}
if (dt.Rows[0]["teacherno"] != null && dt.Rows[0]["teacherno"].ToString() != "")
{
model.TeacherNo = dt.Rows[0]["Phone"].ToString();
}
if (dt.Rows[0]["time"] != null && dt.Rows[0]["time"].ToString() != "")
{
model.Time = Convert.ToInt32(dt.Rows[0]["Living"]);
}
return(model);
}
else
{
return(null);
}
}
public bool Update(Model.Teamhope model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [teamhope] set ");
strSql.Append("teamno=@teamNo,");
strSql.Append("first=@First,");
strSql.Append("second=@Second,");
strSql.Append("third=@Third,");
strSql.Append("teacherNo=@TeacherNo,");
strSql.Append("time=@Time");
strSql.Append(" where teamno=@teamNo ");
SqlParameter[] parameters =
{
new SqlParameter("@TeamNo", SqlDbType.VarChar, 50),
new SqlParameter("@First", SqlDbType.VarChar, 50),
new SqlParameter("@Second", SqlDbType.VarChar, 50),
new SqlParameter("@Third", SqlDbType.VarChar, 50),
new SqlParameter("@TeacherNo", SqlDbType.VarChar, 50),
new SqlParameter("@Time", SqlDbType.Int),
};
parameters[0].Value = model.TeamNo;
parameters[1].Value = model.First;
parameters[2].Value = model.Second;
parameters[3].Value = model.Third;
parameters[4].Value = model.TeacherNo;
parameters[5].Value = model.Time;
int n = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (n == 1)
{
return(true);
}
else
{
return(false);
}
}
