/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.WorksDiscuss model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WorksDiscuss(");
strSql.Append("Dwid,Dsnum,Dwords,Dtime,Dip)");
strSql.Append(" values (");
strSql.Append("@Dwid,@Dsnum,@Dwords,@Dtime,@Dip)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Dwid", SqlDbType.Int,4),
new SqlParameter("@Dsnum", SqlDbType.NVarChar,50),
new SqlParameter("@Dwords", SqlDbType.NText),
new SqlParameter("@Dtime", SqlDbType.DateTime),
new SqlParameter("@Dip", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Dwid;
parameters[1].Value = model.Dsnum;
parameters[2].Value = model.Dwords;
parameters[3].Value = model.Dtime;
parameters[4].Value = model.Dip;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Result model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Result(");
strSql.Append("Rnum,Rscore,Rdate)");
strSql.Append(" values (");
strSql.Append("@Rnum,@Rscore,@Rdate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Rnum", SqlDbType.NVarChar,50),
new SqlParameter("@Rscore", SqlDbType.Int,4),
new SqlParameter("@Rdate", SqlDbType.DateTime)};
parameters[0].Value = model.Rnum;
parameters[1].Value = model.Rscore;
parameters[2].Value = model.Rdate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Typer model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Typer(");
strSql.Append("Ttype,Tuse,Ttitle,Tcontent)");
strSql.Append(" values (");
strSql.Append("@Ttype,@Tuse,@Ttitle,@Tcontent)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Ttype", SqlDbType.SmallInt,2),
new SqlParameter("@Tuse", SqlDbType.Int,4),
new SqlParameter("@Ttitle", SqlDbType.NVarChar,100),
new SqlParameter("@Tcontent", SqlDbType.NText)};
parameters[0].Value = model.Ttype;
parameters[1].Value = model.Tuse;
parameters[2].Value = model.Ttitle;
parameters[3].Value = model.Tcontent;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Webstudy model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Webstudy(");
strSql.Append("Wnum,Wpwd,Wvote,Wegg,Wscore,Wcheck,WquotaCurrent)");
strSql.Append(" values (");
strSql.Append("@Wnum,@Wpwd,@Wvote,@Wegg,@Wscore,@Wcheck,@WquotaCurrent)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Wnum", SqlDbType.NVarChar,50),
new SqlParameter("@Wpwd", SqlDbType.NVarChar,50),
new SqlParameter("@Wvote", SqlDbType.Int,4),
new SqlParameter("@Wegg", SqlDbType.Int,4),
new SqlParameter("@Wscore", SqlDbType.Int,4),
new SqlParameter("@Wcheck", SqlDbType.Bit,1),
new SqlParameter("@WquotaCurrent", SqlDbType.Int,4)};
parameters[0].Value = model.Wnum;
parameters[1].Value = model.Wpwd;
parameters[2].Value = model.Wvote;
parameters[3].Value = model.Wegg;
parameters[4].Value = model.Wscore;
parameters[5].Value = model.Wcheck;
parameters[6].Value = model.WquotaCurrent;
object obj =DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Soft model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Soft(");
strSql.Append("Ftitle,Fcontent,Furl,Fhit,Fdate,Ffiletype,Fclass)");
strSql.Append(" values (");
strSql.Append("@Ftitle,@Fcontent,@Furl,@Fhit,@Fdate,@Ffiletype,@Fclass)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Ftitle", SqlDbType.NVarChar,50),
new SqlParameter("@Fcontent", SqlDbType.NText),
new SqlParameter("@Furl", SqlDbType.NVarChar,200),
new SqlParameter("@Fhit", SqlDbType.Int,4),
new SqlParameter("@Fdate", SqlDbType.DateTime),
new SqlParameter("@Ffiletype", SqlDbType.NVarChar,50),
new SqlParameter("@Fclass", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Ftitle;
parameters[1].Value = model.Fcontent;
parameters[2].Value = model.Furl;
parameters[3].Value = model.Fhit;
parameters[4].Value = model.Fdate;
parameters[5].Value = model.Ffiletype;
parameters[6].Value = model.Fclass;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Room model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Room(");
strSql.Append("Rhid,Rgrade,Rclass,Rset,Rpwd)");
strSql.Append(" values (");
strSql.Append("@Rhid,@Rgrade,@Rclass,@Rset,@Rpwd)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Rhid", SqlDbType.Int,4),
new SqlParameter("@Rgrade", SqlDbType.Int,4),
new SqlParameter("@Rclass", SqlDbType.Int,4),
new SqlParameter("@Rset", SqlDbType.Bit,1),
new SqlParameter("@Rpwd", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Rhid;
parameters[1].Value = model.Rgrade;
parameters[2].Value = model.Rclass;
parameters[3].Value = model.Rset;
parameters[4].Value = model.Rpwd;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Teacher model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Teacher(");
strSql.Append("Hname,Hpwd,Hpermiss,Hnote)");
strSql.Append(" values (");
strSql.Append("@Hname,@Hpwd,@Hpermiss,@Hnote)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Hname", SqlDbType.NVarChar,50),
new SqlParameter("@Hpwd", SqlDbType.NVarChar,50),
new SqlParameter("@Hpermiss", SqlDbType.Bit,1),
new SqlParameter("@Hnote", SqlDbType.NText)};
parameters[0].Value = model.Hname;
parameters[1].Value = model.Hpwd;
parameters[2].Value = model.Hpermiss;
parameters[3].Value = model.Hnote;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Ptyper model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Ptyper(");
strSql.Append("Ptid,Psnum,Pscore,Pdate,Pip,Ptype)");
strSql.Append(" values (");
strSql.Append("@Ptid,@Psnum,@Pscore,@Pdate,@Pip,@Ptype)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Ptid", SqlDbType.Int,4),
new SqlParameter("@Psnum", SqlDbType.NVarChar,50),
new SqlParameter("@Pscore", SqlDbType.Int,4),
new SqlParameter("@Pdate", SqlDbType.DateTime),
new SqlParameter("@Pip", SqlDbType.NVarChar,50),
new SqlParameter("@Ptype", SqlDbType.Int,4)};
parameters[0].Value = model.Ptid;
parameters[1].Value = model.Psnum;
parameters[2].Value = model.Pscore;
parameters[3].Value = model.Pdate;
parameters[4].Value = model.Pip;
parameters[5].Value = model.Ptype;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Flection model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Flection(");
strSql.Append("Fcid,Fhid,Fcontent,Fdate)");
strSql.Append(" values (");
strSql.Append("@Fcid,@Fhid,@Fcontent,@Fdate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Fcid", SqlDbType.Int,4),
new SqlParameter("@Fhid", SqlDbType.Int,4),
new SqlParameter("@Fcontent", SqlDbType.NText),
new SqlParameter("@Fdate", SqlDbType.DateTime)};
parameters[0].Value = model.Fcid;
parameters[1].Value = model.Fhid;
parameters[2].Value = model.Fcontent;
parameters[3].Value = model.Fdate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Quiz model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Quiz(");
strSql.Append("Qtype,Question,Qanswer,Qanalyze,Qscore)");
strSql.Append(" values (");
strSql.Append("@Qtype,@Question,@Qanswer,@Qanalyze,@Qscore)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Qtype", SqlDbType.Int,4),
new SqlParameter("@Question", SqlDbType.NText),
new SqlParameter("@Qanswer", SqlDbType.NVarChar,50),
new SqlParameter("@Qanalyze", SqlDbType.NVarChar,50),
new SqlParameter("@Qscore", SqlDbType.Int,4)};
parameters[0].Value = model.Qtype;
parameters[1].Value = model.Question;
parameters[2].Value = model.Qanswer;
parameters[3].Value = model.Qanalyze;
parameters[4].Value = model.Qscore;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.StudentsExcel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into StudentsExcel(");
strSql.Append("Snum,Syear,Sgrade,Sclass,Sname,Spwd,Sex,Saddress,Sphone,Sparents,Sheadtheacher,Sscore,Squiz,Sattitude,Sape)");
strSql.Append(" values (");
strSql.Append("@Snum,@Syear,@Sgrade,@Sclass,@Sname,@Spwd,@Sex,@Saddress,@Sphone,@Sparents,@Sheadtheacher,@Sscore,@Squiz,@Sattitude,@Sape)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Snum", SqlDbType.NVarChar,50),
new SqlParameter("@Syear", SqlDbType.Int,4),
new SqlParameter("@Sgrade", SqlDbType.Int,4),
new SqlParameter("@Sclass", SqlDbType.Int,4),
new SqlParameter("@Sname", SqlDbType.NVarChar,50),
new SqlParameter("@Spwd", SqlDbType.NVarChar,50),
new SqlParameter("@Sex", SqlDbType.NVarChar,2),
new SqlParameter("@Saddress", SqlDbType.NVarChar,200),
new SqlParameter("@Sphone", SqlDbType.NVarChar,50),
new SqlParameter("@Sparents", SqlDbType.NVarChar,50),
new SqlParameter("@Sheadtheacher", SqlDbType.NVarChar,50),
new SqlParameter("@Sscore", SqlDbType.Int,4),
new SqlParameter("@Squiz", SqlDbType.Int,4),
new SqlParameter("@Sattitude", SqlDbType.Int,4),
new SqlParameter("@Sape", SqlDbType.NVarChar,1)};
parameters[0].Value = model.Snum;
parameters[1].Value = model.Syear;
parameters[2].Value = model.Sgrade;
parameters[3].Value = model.Sclass;
parameters[4].Value = model.Sname;
parameters[5].Value = model.Spwd;
parameters[6].Value = model.Sex;
parameters[7].Value = model.Saddress;
parameters[8].Value = model.Sphone;
parameters[9].Value = model.Sparents;
parameters[10].Value = model.Sheadtheacher;
parameters[11].Value = model.Sscore;
parameters[12].Value = model.Squiz;
parameters[13].Value = model.Sattitude;
parameters[14].Value = model.Sape;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Works model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Works(");
strSql.Append("Wnum,Wcid,Wmid,Wmsort,Wfilename,Wurl,Wlength,Wscore,Wdate,Wip,Wtime,Wvote,Wegg,Wcheck)");
strSql.Append(" values (");
strSql.Append("@Wnum,@Wcid,@Wmid,@Wmsort,@Wfilename,@Wurl,@Wlength,@Wscore,@Wdate,@Wip,@Wtime,@Wvote,@Wegg,@Wcheck)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Wnum", SqlDbType.NVarChar,50),
new SqlParameter("@Wcid", SqlDbType.Int,4),
new SqlParameter("@Wmid", SqlDbType.Int,4),
new SqlParameter("@Wmsort", SqlDbType.Int,4),
new SqlParameter("@Wfilename", SqlDbType.NVarChar,50),
new SqlParameter("@Wurl", SqlDbType.NVarChar,200),
new SqlParameter("@Wlength", SqlDbType.Int,4),
new SqlParameter("@Wscore", SqlDbType.Int,4),
new SqlParameter("@Wdate", SqlDbType.DateTime),
new SqlParameter("@Wip", SqlDbType.NVarChar,50),
new SqlParameter("@Wtime", SqlDbType.NVarChar,50),
new SqlParameter("@Wvote", SqlDbType.Int,4),
new SqlParameter("@Wegg", SqlDbType.SmallInt,2),
new SqlParameter("@Wcheck", SqlDbType.Bit,1)};
parameters[0].Value = model.Wnum;
parameters[1].Value = model.Wcid;
parameters[2].Value = model.Wmid;
parameters[3].Value = model.Wmsort;
parameters[4].Value = model.Wfilename;
parameters[5].Value = model.Wurl;
parameters[6].Value = model.Wlength;
parameters[7].Value = model.Wscore;
parameters[8].Value = model.Wdate;
parameters[9].Value = model.Wip;
parameters[10].Value = model.Wtime;
parameters[11].Value = model.Wvote;
parameters[12].Value = model.Wegg;
parameters[13].Value = model.Wcheck;
object obj =DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Courses model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Courses(");
strSql.Append("Ctitle,Cclass,Ccontent,Cdate,Chit,Cobj,Cterm,Cks,Cfiletype,Cupload,Chid,Cpublish)");
strSql.Append(" values (");
strSql.Append("@Ctitle,@Cclass,@Ccontent,@Cdate,@Chit,@Cobj,@Cterm,@Cks,@Cfiletype,@Cupload,@Chid,@Cpublish)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Ctitle", SqlDbType.NVarChar,50),
new SqlParameter("@Cclass", SqlDbType.NVarChar,50),
new SqlParameter("@Ccontent", SqlDbType.NText),
new SqlParameter("@Cdate", SqlDbType.DateTime),
new SqlParameter("@Chit", SqlDbType.Int,4),
new SqlParameter("@Cobj", SqlDbType.Int,4),
new SqlParameter("@Cterm", SqlDbType.Int,4),
new SqlParameter("@Cks", SqlDbType.Int,4),
new SqlParameter("@Cfiletype", SqlDbType.NVarChar,50),
new SqlParameter("@Cupload", SqlDbType.Bit,1),
new SqlParameter("@Chid", SqlDbType.Int,4),
new SqlParameter("@Cpublish", SqlDbType.Bit,1)};
parameters[0].Value = model.Ctitle;
parameters[1].Value = model.Cclass;
parameters[2].Value = model.Ccontent;
parameters[3].Value = model.Cdate;
parameters[4].Value = model.Chit;
parameters[5].Value = model.Cobj;
parameters[6].Value = model.Cterm;
parameters[7].Value = model.Cks;
parameters[8].Value = model.Cfiletype;
parameters[9].Value = model.Cupload;
parameters[10].Value = model.Chid;
parameters[11].Value = model.Cpublish;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Signin model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Signin(");
strSql.Append("Qnum,Qattitude,Qdate,Qyear,Qmonth,Qday,Qweek,Qip,Qnote,Qwork)");
strSql.Append(" values (");
strSql.Append("@Qnum,@Qattitude,@Qdate,@Qyear,@Qmonth,@Qday,@Qweek,@Qip,@Qnote,@Qwork)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Qnum", SqlDbType.NVarChar,50),
new SqlParameter("@Qattitude", SqlDbType.Int,4),
new SqlParameter("@Qdate", SqlDbType.DateTime),
new SqlParameter("@Qyear", SqlDbType.Int,4),
new SqlParameter("@Qmonth", SqlDbType.Int,4),
new SqlParameter("@Qday", SqlDbType.Int,4),
new SqlParameter("@Qweek", SqlDbType.NVarChar,50),
new SqlParameter("@Qip", SqlDbType.NVarChar,50),
new SqlParameter("@Qnote", SqlDbType.NVarChar,50),
new SqlParameter("@Qwork", SqlDbType.Int,4)};
parameters[0].Value = model.Qnum;
parameters[1].Value = model.Qattitude;
parameters[2].Value = model.Qdate;
parameters[3].Value = model.Qyear;
parameters[4].Value = model.Qmonth;
parameters[5].Value = model.Qday;
parameters[6].Value = model.Qweek;
parameters[7].Value = model.Qip;
parameters[8].Value = model.Qnote;
parameters[9].Value = model.Qwork;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Mission model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Mission(");
strSql.Append("Mtitle,Mcid,Mcontent,Mdate,Mhit,Mfiletype,Mupload,Msort,Mpublish)");
strSql.Append(" values (");
strSql.Append("@Mtitle,@Mcid,@Mcontent,@Mdate,@Mhit,@Mfiletype,@Mupload,@Msort,@Mpublish)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Mtitle", SqlDbType.NVarChar,50),
new SqlParameter("@Mcid", SqlDbType.Int,4),
new SqlParameter("@Mcontent", SqlDbType.NText),
new SqlParameter("@Mdate", SqlDbType.DateTime),
new SqlParameter("@Mhit", SqlDbType.Int,4),
new SqlParameter("@Mfiletype", SqlDbType.NVarChar,50),
new SqlParameter("@Mupload", SqlDbType.Bit,1),
new SqlParameter("@Msort", SqlDbType.Int,4),
new SqlParameter("@Mpublish", SqlDbType.Bit,1)};
parameters[0].Value = model.Mtitle;
parameters[1].Value = model.Mcid;
parameters[2].Value = model.Mcontent;
parameters[3].Value = model.Mdate;
parameters[4].Value = model.Mhit;
parameters[5].Value = model.Mfiletype;
parameters[6].Value = model.Mupload;
parameters[7].Value = model.Msort;
parameters[8].Value = model.Mpublish;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(LearnSite.Model.StudentsExcel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update StudentsExcel set ");
strSql.Append("Snum=@Snum,");
strSql.Append("Syear=@Syear,");
strSql.Append("Sgrade=@Sgrade,");
strSql.Append("Sclass=@Sclass,");
strSql.Append("Sname=@Sname,");
strSql.Append("Spwd=@Spwd,");
strSql.Append("Sex=@Sex,");
strSql.Append("Saddress=@Saddress,");
strSql.Append("Sphone=@Sphone,");
strSql.Append("Sparents=@Sparents,");
strSql.Append("Sheadtheacher=@Sheadtheacher,");
strSql.Append("Sscore=@Sscore,");
strSql.Append("Squiz=@Squiz,");
strSql.Append("Sattitude=@Sattitude,");
strSql.Append("Sape=@Sape");
strSql.Append(" where Sid=@Sid ");
SqlParameter[] parameters = {
new SqlParameter("@Sid", SqlDbType.Int,4),
new SqlParameter("@Snum", SqlDbType.NVarChar,50),
new SqlParameter("@Syear", SqlDbType.Int,4),
new SqlParameter("@Sgrade", SqlDbType.Int,4),
new SqlParameter("@Sclass", SqlDbType.Int,4),
new SqlParameter("@Sname", SqlDbType.NVarChar,50),
new SqlParameter("@Spwd", SqlDbType.NVarChar,50),
new SqlParameter("@Sex", SqlDbType.NVarChar,2),
new SqlParameter("@Saddress", SqlDbType.NVarChar,200),
new SqlParameter("@Sphone", SqlDbType.NVarChar,50),
new SqlParameter("@Sparents", SqlDbType.NVarChar,50),
new SqlParameter("@Sheadtheacher", SqlDbType.NVarChar,50),
new SqlParameter("@Sscore", SqlDbType.Int,4),
new SqlParameter("@Squiz", SqlDbType.Int,4),
new SqlParameter("@Sattitude", SqlDbType.Int,4),
new SqlParameter("@Sape", SqlDbType.NVarChar,1)};
parameters[0].Value = model.Sid;
parameters[1].Value = model.Snum;
parameters[2].Value = model.Syear;
parameters[3].Value = model.Sgrade;
parameters[4].Value = model.Sclass;
parameters[5].Value = model.Sname;
parameters[6].Value = model.Spwd;
parameters[7].Value = model.Sex;
parameters[8].Value = model.Saddress;
parameters[9].Value = model.Sphone;
parameters[10].Value = model.Sparents;
parameters[11].Value = model.Sheadtheacher;
parameters[12].Value = model.Sscore;
parameters[13].Value = model.Squiz;
parameters[14].Value = model.Sattitude;
parameters[15].Value = model.Sape;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// 设置学生的cookies值
/// </summary>
/// <param name="Model"></param>
///Snum,Syear,Sgrade,Sclass,Sname,Spwd,Sex,Saddress,Sphone,Sparents,Sheadtheacher,Sscore,Sattitude,Sape
public static bool SetStudentCookies(LearnSite.Model.Students Model)
{
if (Model != null)
{
try
{
DateTime LoginTime = DateTime.Now;
string LoginIp = LearnSite.Common.Computer.GetGuestIP();
LearnSite.BLL.Webstudy wbll = new LearnSite.BLL.Webstudy();
string FtpPwd = wbll.FindWebFtpPwd(Model.Snum);
LearnSite.BLL.Room rm = new LearnSite.BLL.Room();
string Rhid = rm.GetRoomRhid(Model.Sgrade.Value, Model.Sclass.Value);
string ThisTerm = LearnSite.Common.XmlHelp.GetTerm();
HttpCookie StuCookie = new HttpCookie("StudentCookies");
if (Model.Sex == null)
Model.Sex = "无";
if (Model.Saddress == null)
Model.Saddress = "无";
if (Model.Sphone == null)
Model.Sphone = "无";
if (Model.Sparents == null)
Model.Sparents = "无";
if (Model.Sheadtheacher == null)
Model.Sheadtheacher = "无";
if (Model.Sscore == null)
Model.Sscore = 0;
if (Model.Squiz == null)
Model.Squiz = 0;
if (Model.Sattitude == null)
Model.Sattitude = 0;
if (Model.Sape == null)
Model.Sape = "无";
StuCookie.Values.Add("Sid", Model.Sid.ToString());
StuCookie.Values.Add("Snum", UrlEncode(Model.Snum));
StuCookie.Values.Add("Syear", Model.Syear.ToString());
StuCookie.Values.Add("Sgrade", Model.Sgrade.ToString());
StuCookie.Values.Add("Sclass", Model.Sclass.ToString());
StuCookie.Values.Add("Sname", UrlEncode(Model.Sname));
StuCookie.Values.Add("Spwd", Model.Spwd.ToString());
StuCookie.Values.Add("Sex", UrlEncode(Model.Sex));
StuCookie.Values.Add("Saddress", UrlEncode(Model.Saddress));
StuCookie.Values.Add("Sphone", Model.Sphone.ToString());
StuCookie.Values.Add("Sparents", UrlEncode(Model.Sparents));
StuCookie.Values.Add("Sheadtheacher", UrlEncode(Model.Sheadtheacher));
StuCookie.Values.Add("Sscore", Model.Sscore.ToString());
StuCookie.Values.Add("Squiz", Model.Squiz.ToString());
StuCookie.Values.Add("Sattitude", Model.Sattitude.ToString());
StuCookie.Values.Add("Sape", Model.Sape.ToString());
StuCookie.Values.Add("LoginTime", LoginTime.ToString());
StuCookie.Values.Add("LoginIp", LoginIp);
StuCookie.Values.Add("Ftppwd", FtpPwd);
StuCookie.Values.Add("ThisTerm", ThisTerm);
StuCookie.Values.Add("Rhid", Rhid);
string str = LearnSite.Common.XmlHelp.GetStudentCookiesPeriod();
if (str != "0")
{
StuCookie.Expires = StudentCookiesPeriod(str);
StuCookie.Path = "/";
}
HttpContext.Current.Response.AppendCookie(StuCookie);
return true;
}
catch
{
return false;
}
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(LearnSite.Model.StudentsExcel model)
{
dal.Update(model);
}
/// <summary>
/// ����һ������,model����Sscore,Sattitude,Sape
/// </summary>
public int AddFromExcelDs(LearnSite.Model.StudentsExcel model)
{
return dal.AddFromExcelDs(model);
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(LearnSite.Model.WorksDiscuss model)
{
dal.Update(model);
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(LearnSite.Model.Webstudy model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Webstudy set ");
strSql.Append("Wnum=@Wnum,");
strSql.Append("Wpwd=@Wpwd,");
strSql.Append("Wvote=@Wvote,");
strSql.Append("Wegg=@Wegg,");
strSql.Append("Wscore=@Wscore,");
strSql.Append("Wcheck=@Wcheck,");
strSql.Append("WquotaCurrent=@WquotaCurrent");
strSql.Append(" where Wid=@Wid ");
SqlParameter[] parameters = {
new SqlParameter("@Wid", SqlDbType.Int,4),
new SqlParameter("@Wnum", SqlDbType.NVarChar,50),
new SqlParameter("@Wpwd", SqlDbType.NVarChar,50),
new SqlParameter("@Wvote", SqlDbType.Int,4),
new SqlParameter("@Wegg", SqlDbType.Int,4),
new SqlParameter("@Wscore", SqlDbType.Int,4),
new SqlParameter("@Wcheck", SqlDbType.Bit,1),
new SqlParameter("@WquotaCurrent", SqlDbType.Int,4)};
parameters[0].Value = model.Wid;
parameters[1].Value = model.Wnum;
parameters[2].Value = model.Wpwd;
parameters[3].Value = model.Wvote;
parameters[4].Value = model.Wegg;
parameters[5].Value = model.Wscore;
parameters[6].Value = model.Wcheck;
parameters[7].Value = model.WquotaCurrent;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ�����ݣ����¿γ�����
/// </summary>
public void UpdateCourse(LearnSite.Model.Courses model)
{
dal.UpdateCourse(model);
}
/// <summary>
/// �����¿γ̣�Ctitle,Cclass��Cdate,Cobj,Cterm,Cks,Cfiletype,Cupload,Cpublish���������Զ����
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Create(LearnSite.Model.Courses model)
{
return dal.Create(model);
}
/// <summary>
/// ����һ������,���¿γ�����
/// </summary>
public void UpdateCourse(LearnSite.Model.Courses model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Courses set ");
strSql.Append("Ctitle=@Ctitle,");
strSql.Append("Cclass=@Cclass,");
strSql.Append("Ccontent=@Ccontent,");
strSql.Append("Cdate=@Cdate,");
strSql.Append("Cobj=@Cobj,");
strSql.Append("Cterm=@Cterm,");
strSql.Append("Cks=@Cks,");
strSql.Append("Cpublish=@Cpublish");
strSql.Append(" where Cid=@Cid ");
SqlParameter[] parameters = {
new SqlParameter("@Cid", SqlDbType.Int,4),
new SqlParameter("@Ctitle", SqlDbType.NVarChar,50),
new SqlParameter("@Cclass", SqlDbType.NVarChar,50),
new SqlParameter("@Ccontent", SqlDbType.NText),
new SqlParameter("@Cdate", SqlDbType.DateTime),
new SqlParameter("@Cobj", SqlDbType.Int,4),
new SqlParameter("@Cterm", SqlDbType.Int,4),
new SqlParameter("@Cks", SqlDbType.Int,4),
new SqlParameter("@Cpublish", SqlDbType.Bit,1)};
parameters[0].Value = model.Cid;
parameters[1].Value = model.Ctitle;
parameters[2].Value = model.Cclass;
parameters[3].Value = model.Ccontent;
parameters[4].Value = model.Cdate;
parameters[5].Value = model.Cobj;
parameters[6].Value = model.Cterm;
parameters[7].Value = model.Cks;
parameters[8].Value = model.Cpublish;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Courses model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(LearnSite.Model.Soft model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Soft set ");
strSql.Append("Ftitle=@Ftitle,");
strSql.Append("Fcontent=@Fcontent,");
strSql.Append("Furl=@Furl,");
strSql.Append("Fhit=@Fhit,");
strSql.Append("Fdate=@Fdate,");
strSql.Append("Ffiletype=@Ffiletype,");
strSql.Append("Fclass=@Fclass");
strSql.Append(" where Fid=@Fid ");
SqlParameter[] parameters = {
new SqlParameter("@Fid", SqlDbType.Int,4),
new SqlParameter("@Ftitle", SqlDbType.NVarChar,50),
new SqlParameter("@Fcontent", SqlDbType.NText),
new SqlParameter("@Furl", SqlDbType.NVarChar,200),
new SqlParameter("@Fhit", SqlDbType.Int,4),
new SqlParameter("@Fdate", SqlDbType.DateTime),
new SqlParameter("@Ffiletype", SqlDbType.NVarChar,50),
new SqlParameter("@Fclass", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Fid;
parameters[1].Value = model.Ftitle;
parameters[2].Value = model.Fcontent;
parameters[3].Value = model.Furl;
parameters[4].Value = model.Fhit;
parameters[5].Value = model.Fdate;
parameters[6].Value = model.Ffiletype;
parameters[7].Value = model.Fclass;
DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.Signin model)
{
return dal.Add(model);
}
/// <summary>
/// ����һ������
/// </summary>
public void Update(LearnSite.Model.Signin model)
{
dal.Update(model);
}
/// <summary>
/// 设置教师的cookies值
/// </summary>
/// <param name="Model"></param>
public static bool SetTeacherCookies(LearnSite.Model.Teacher Model)
{
if (Model != null)
{
try
{
HttpCookie TCookies = new HttpCookie("TeacherCookies");
if (Model.Hnote == null)
Model.Hnote = " ";
TCookies.Values.Add("Hid", Model.Hid.ToString());
TCookies.Values.Add("Hname", UrlEncode(Model.Hname));
TCookies.Values.Add("Hpwd", Model.Hpwd);
TCookies.Values.Add("Hpermiss", Model.Hpermiss.ToString());
TCookies.Values.Add("Hnote", Model.Hnote);
TCookies.Expires = DateTime.MaxValue;
TCookies.Path = "/";
HttpContext.Current.Response.AppendCookie(TCookies);
return true;
}
catch
{
return false;
}
}
else
{
return false;
}
}
/// <summary>
/// ����һ������
/// </summary>
public int Add(LearnSite.Model.WorksDiscuss model)
{
return dal.Add(model);
}
