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