private void showreply()
{
int sgrade = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString());
int sclass = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sclass"].ToString());
string rsnum = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Snum"].ToString();
int rsid = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sid"].ToString());
int rtid = Int32.Parse(Request.QueryString["Tid"].ToString());
LearnSite.BLL.TopicReply rbll = new LearnSite.BLL.TopicReply();
if (Btnword.Text == "老师总结")
{
GVtopicDiscuss.DataSource = rbll.GetClassList(sgrade, sclass, rtid);
GVtopicDiscuss.DataBind();
Labelreplycount.Text = "共" + GVtopicDiscuss.Rows.Count.ToString() + "贴";
Labelreplycountbtm.Text = Labelreplycount.Text;
}
else
{
if (rbll.ReplyCount(rtid, rsid) > 0)
{
GVtopicDiscuss.DataSource = rbll.GetClassList(sgrade, sclass, rtid);
GVtopicDiscuss.DataBind();
Labelreplycount.Text = "共" + GVtopicDiscuss.Rows.Count.ToString() + "贴";
Labelreplycountbtm.Text = Labelreplycount.Text;
}
}
Labelnostu.Text = rbll.GetNoReplay(sgrade, sclass, rtid);
}
/// <summary>
/// 显示本班级已学和未学学案
/// </summary>
private void Showkc()
{
int Rhid = tcook.Hid;
int Rgrade = Int32.Parse(DDLgrade.SelectedValue);
int Rclass = Int32.Parse(DDLclass.SelectedValue);
LearnSite.BLL.Students sbll = new LearnSite.BLL.Students();
int Syear = sbll.GetYear(Rgrade, Rclass);
LearnSite.BLL.Works wbll = new LearnSite.BLL.Works();
int Wterm = Int32.Parse(LearnSite.Common.XmlHelp.GetTerm());
string Wcids = wbll.ShowDoneWorkCids(Rgrade, Rclass, Wterm, Syear);
LearnSite.BLL.TopicReply Tbll = new LearnSite.BLL.TopicReply();
string Tcids = Tbll.ShowDoneReplyCids(Rgrade, Rclass, Wterm, Syear);
LearnSite.BLL.SurveyFeedback fbll = new LearnSite.BLL.SurveyFeedback();
string Fcids = fbll.ShowFeedbackCids(Rgrade, Rclass, Wterm, Syear);
string allCids = Wcids + Tcids + Fcids;
allCids = LearnSite.Common.WordProcess.SimpleWords(allCids);
LearnSite.BLL.Courses cs = new LearnSite.BLL.Courses();
DLdonekc.DataSource = cs.ShowClassDoneCourse(Rgrade, Rhid, allCids);
DLdonekc.DataBind();
DLnewkc.DataSource = cs.ShowClassnewCourse(Rgrade, Rhid, allCids);
DLnewkc.DataBind();
}
private void showtopic()
{
if (Request.QueryString["Tid"] != null)
{
int tid = Int32.Parse(Request.QueryString["Tid"].ToString());
LearnSite.BLL.TopicDiscuss tbll = new LearnSite.BLL.TopicDiscuss();
LearnSite.Model.TopicDiscuss tmodel = new LearnSite.Model.TopicDiscuss();
tmodel = tbll.GetModel(tid);//获取主题讨论实体
Labeltopic.Text = tmodel.Ttitle;
TcloseCheck.Checked = tmodel.Tclose;
Topics.InnerHtml = "<br/> 讨论内容：" + HttpUtility.HtmlDecode(tmodel.Tcontent);
LearnSite.BLL.Courses cbll = new LearnSite.BLL.Courses();
Labelcourse.Text = cbll.GetTitle(tmodel.Tcid.Value);//获取学案名称
LearnSite.BLL.TopicReply rbll = new LearnSite.BLL.TopicReply();
TopicsResult.InnerHtml = "<br/> 老师总结：";
if (tmodel.Tclose)
{
Btnword.Enabled = false;//不可发表讨论
Btnclock.ImageUrl = "~/Images/clockred.gif" + "?temp=" + DateTime.Now.Millisecond.ToString();
Btnclock.ToolTip = "当前主题讨论关闭！";
}
else
{
Btnword.Enabled = true;//可发表讨论
Btnclock.ImageUrl = "~/Images/clock.gif" + "?temp=" + DateTime.Now.Millisecond.ToString();
Btnclock.ToolTip = "当前主题讨论开启!";
}
}
}
private void showreply()
{
int rtid = Int32.Parse(Request.QueryString["Tid"].ToString());
LearnSite.BLL.TopicReply rbll = new LearnSite.BLL.TopicReply();
Labelreplycount.Text = "共 贴";
Labelreplycountbtm.Text = Labelreplycount.Text;
}
protected void ButtonClearStudent_Click(object sender, EventArgs e)
{
if (CheckBoxDel.Checked)
{
string cip = Page.Request.UserHostAddress; //客户端IP
string sip = LearnSite.Common.Computer.GetServerIp(); //服务器IP
if (cip == sip)
{
string countstu = TextBoxcount.Text;
if (countstu != "" && countstu != "0")
{
int sgrade = Int32.Parse(DDLgrade.SelectedValue);
int sclass = Int32.Parse(DDLclass.SelectedValue);
LearnSite.BLL.Webstudy wbll = new LearnSite.BLL.Webstudy();
wbll.DelWebClass(sgrade, sclass);
LearnSite.BLL.Students sbll = new LearnSite.BLL.Students();
int delcount = sbll.DeleteClassMate(sgrade, sclass);//清空该班级学生
Labelmsg.Text = "您请空了" + DDLgrade.SelectedValue + "年级" + DDLclass.SelectedValue + "班所有学生共" + delcount.ToString() + "位！";
int syear = sbll.GetYear(sgrade, sclass);
LearnSite.BLL.Signin gbll = new LearnSite.BLL.Signin();
gbll.DelSignClass(sgrade, sclass, syear);
//清空签到
LearnSite.BLL.Works kbll = new LearnSite.BLL.Works();
kbll.DelClass(sgrade, sclass, syear);
//清空作品
LearnSite.BLL.SurveyFeedback fbll = new LearnSite.BLL.SurveyFeedback();
fbll.DelClass(sgrade, sclass, syear);
//清空调查
LearnSite.BLL.TopicReply rbll = new LearnSite.BLL.TopicReply();
rbll.DelClass(sgrade, sclass, syear);
//清空讨论
}
else
{
Labelmsg.Text = "无学生记录可清空！";
}
}
else
{
Labelmsg.Text = "此操作只能在服务器上浏览该页面才能执行，谢谢！";
}
}
else
{
Labelmsg.Text = "请在确认操作选项上打勾！";
}
}
protected void ImageBtngoodall_Click(object sender, ImageClickEventArgs e)
{
string mynum = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Snum"].ToString();
if (mynum.IndexOf("s") > -1)
{
int tid = Int32.Parse(Request.QueryString["Tid"].ToString());
int sgrade = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString());
int sclass = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sclass"].ToString());
int syear = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Syear"].ToString());
LearnSite.BLL.TopicReply rbll = new LearnSite.BLL.TopicReply();
rbll.UpdateAllscore(tid, sgrade, sclass, syear);
System.Threading.Thread.Sleep(500);
showreply();
}
}
protected void ImageBtngoodall_Click(object sender, ImageClickEventArgs e)
{
string mynum = cook.Snum;
if (mynum.IndexOf("s") > -1)
{
int tid = Int32.Parse(Request.QueryString["Tid"].ToString());
int sgrade = cook.Sgrade;
int sclass = cook.Sclass;
int syear = cook.Syear;
LearnSite.BLL.TopicReply rbll = new LearnSite.BLL.TopicReply();
rbll.UpdateAllscore(tid, sgrade, sclass, syear);
System.Threading.Thread.Sleep(500);
showreply();
}
}
private void showtopic()
{
if (Request.QueryString["Tid"] != null)
{
int tid = Int32.Parse(Request.QueryString["Tid"].ToString());
LearnSite.BLL.TopicDiscuss tbll = new LearnSite.BLL.TopicDiscuss();
LearnSite.Model.TopicDiscuss tmodel = new LearnSite.Model.TopicDiscuss();
tmodel = tbll.GetModel(tid);//获取主题讨论实体
Labeltopic.Text = tmodel.Ttitle;
TcloseCheck.Checked = tmodel.Tclose;
Topics.InnerHtml = "讨论内容：" + HttpUtility.HtmlDecode(tmodel.Tcontent);
LearnSite.BLL.Courses cbll = new LearnSite.BLL.Courses();
string mynum = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Snum"].ToString();
int sgrade = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString());
int sclass = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sclass"].ToString());
int syear = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Syear"].ToString());
int hid = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Rhid"].ToString());
string teasnum = "s" + hid + syear.ToString() + sgrade.ToString() + sclass.ToString();
LearnSite.BLL.TopicReply rbll = new LearnSite.BLL.TopicReply();
string treply = rbll.getteareply(tid, teasnum);
TopicsResult.InnerHtml = "老师总结：" + HttpUtility.HtmlDecode(treply);
if (mynum == teasnum)
{
Btnclock.Enabled = true;
Btnword.Text = "老师总结";
ImageBtngoodall.Visible = true;
}
if (tmodel.Tclose)
{
Btnword.Enabled = false;//不可发表讨论
Btnclock.ImageUrl = "~/Images/clockred.gif" + "?temp=" + DateTime.Now.Millisecond.ToString();
Btnclock.ToolTip = "主题讨论暂停！";
}
else
{
Btnword.Enabled = true;//可发表讨论
Btnclock.ImageUrl = "~/Images/clock.gif" + "?temp=" + DateTime.Now.Millisecond.ToString();
Btnclock.ToolTip = "主题讨论开启!";
}
}
}
private void getoldCids()
{
int Cterm = cook.ThisTerm;
int Cgrade = cook.Sgrade;
string mySnum = cook.Snum;
LearnSite.BLL.SurveyFeedback fbll = new LearnSite.BLL.SurveyFeedback();
string fcids = fbll.ShowStuFeedbackCids(mySnum, Cterm, Cgrade);
LearnSite.BLL.Works wbll = new LearnSite.BLL.Works();
string wcids = wbll.ShowStuDoneWorkCids(mySnum, Cterm, Cgrade);
LearnSite.BLL.TopicReply tbll = new LearnSite.BLL.TopicReply();
string tcids = tbll.ShowStuDoneReplyCids(mySnum, Cterm, Cgrade);
LearnSite.BLL.TxtFormBack mbll = new LearnSite.BLL.TxtFormBack();
string mcids = mbll.ShowStuDoneBackCids(mySnum, Cterm, Cgrade);
string allcids = "";
if (wcids != "")
{
allcids = allcids + wcids;
}
if (fcids != "")
{
allcids = allcids + fcids;
}
if (tcids != "")
{
allcids = allcids + tcids;
}
if (mcids != "")
{
allcids = allcids + mcids;
}
LabelCids.Text = LearnSite.Common.WordProcess.SimpleWordsNew(allcids);
}
private void getoldCids()
{
int Cterm = Int32.Parse(LearnSite.Common.XmlHelp.GetTerm());
int Cgrade = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString());
string mySnum = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Snum"].ToString();
LearnSite.BLL.SurveyFeedback fbll = new LearnSite.BLL.SurveyFeedback();
string fcids = fbll.ShowStuFeedbackCids(mySnum, Cterm, Cgrade);
LearnSite.BLL.Works wbll = new LearnSite.BLL.Works();
string wcids = wbll.ShowStuDoneWorkCids(mySnum, Cterm, Cgrade);
LearnSite.BLL.TopicReply tbll = new LearnSite.BLL.TopicReply();
string tcids = tbll.ShowStuDoneReplyCids(mySnum, Cterm, Cgrade);
LearnSite.BLL.TxtFormBack mbll = new LearnSite.BLL.TxtFormBack();
string mcids = mbll.ShowStuDoneBackCids(mySnum, Cterm, Cgrade);
string allcids = "";
if (wcids != "")
{
allcids = allcids + wcids;
}
if (fcids != "")
{
allcids = allcids + fcids;
}
if (tcids != "")
{
allcids = allcids + tcids;
}
if (mcids != "")
{
allcids = allcids + mcids;
}
LabelCids.Text = LearnSite.Common.WordProcess.SimpleWordsNew(allcids);
}
protected void Btnword_Click(object sender, EventArgs e)
{
int rsid = Int32.Parse(Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sid"].ToString());
string rsnum = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Snum"].ToString();
string rip = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["LoginIp"].ToString();
string rgrade = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sgrade"].ToString();
string rclass = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sclass"].ToString();
string ryear = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Syear"].ToString();
string rterm = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["ThisTerm"].ToString();
int rtid = Int32.Parse(Request.QueryString["Tid"].ToString());
int rcid = Int32.Parse(Request.QueryString["Cid"].ToString());
string rwords = Request.Form["textareaWord"].Trim();
string tempcut = LearnSite.Common.WordProcess.DropHTML(rwords);
int counts = tempcut.Length;
int rscore = 0;
bool rban = false;
if (counts > 5 && counts < 500)
{
rwords = rwords.Replace("<br />", "");
rwords = rwords.Replace(",", "，");
LearnSite.BLL.TopicReply rbll = new LearnSite.BLL.TopicReply();
LearnSite.Model.TopicReply rmodel = new LearnSite.Model.TopicReply();
rmodel.Rban = rban;
rmodel.Rip = rip;
rmodel.Rscore = rscore;
rmodel.Rsnum = rsnum;
rmodel.Rtid = rtid;
rmodel.Rtime = DateTime.Now;
rmodel.Rwords = HttpUtility.HtmlEncode(rwords);
rmodel.Rgrade = Int32.Parse(rgrade);
rmodel.Rterm = Int32.Parse(rterm);
rmodel.Rcid = rcid;
rmodel.Rclass = Int32.Parse(rclass);
rmodel.Rsid = rsid;
rmodel.Ryear = Int32.Parse(ryear);
rmodel.Redit = false;
rmodel.Ragree = 0;
int myreply = rbll.ReplyCount(rtid, rsid);//获取该学号回复数
if (Btnword.Text == "老师总结")
{
if (myreply > 0)
{
rbll.UpdateTeacher(rtid, rsid, rwords);//更新老师总结
}
else
{
rbll.Add(rmodel);//增加老师总结
}
Labeldiscuss.Text = "总结成功！";
}
else
{
bool historyban = rbll.Isban(rtid, rsid);
if (!historyban)
{
if (myreply < 1)
{
rbll.Add(rmodel);//增加一条回复
Labeldiscuss.Text = "回复成功！";
}
else
{
if (rbll.Isedit(rtid, rsid))
{
rbll.UpdateOne(rmodel);//修改一条回复
Labeldiscuss.Text = "修改成功！";
}
else
{
Labeldiscuss.Text = "默认回复最多为1次！";
}
}
}
else
{
Labeldiscuss.Text = "你在回复中存在违纪言论已被老师禁言！";
}
}
System.Threading.Thread.Sleep(500);
showtopic();
showreply();
}
else
{
Labeldiscuss.Text = "回复不能少于6个汉字或超过300个汉字，谢谢！";
}
}
protected void GVtopicDiscuss_RowCommand(object sender, GridViewCommandEventArgs e)
{
string eid = e.CommandArgument.ToString();
LearnSite.BLL.TopicReply rbll = new LearnSite.BLL.TopicReply();
if (e.CommandName == "Good")
{
int index = Convert.ToInt32(eid);
rbll.Updatescore(index);
System.Threading.Thread.Sleep(500);
showreply();
}
if (e.CommandName == "Less")
{
int index = Convert.ToInt32(eid);
rbll.Lessscore(index);
System.Threading.Thread.Sleep(500);
showreply();
}
if (e.CommandName == "Reply")
{
int index = Convert.ToInt32(eid);
rbll.UpdateEdit(index);
System.Threading.Thread.Sleep(500);
showreply();
}
if (e.CommandName == "Del")
{
int index = Convert.ToInt32(eid);
rbll.Delete(index);
System.Threading.Thread.Sleep(500);
showreply();
}
if (e.CommandName == "Agree")
{
int index = Convert.ToInt32(eid);
string sid = Request.Cookies[LearnSite.Common.CookieHelp.stuCookieNname].Values["Sid"].ToString();
if (Session["Topic" + sid] != null)
{
int agcount = Int32.Parse(Session["Topic" + sid].ToString());
if (agcount < 10)
{
if (Session["Topic" + sid + "Agree" + index.ToString()] == null)
{
Session["Topic" + sid + "Agree" + index.ToString()] = "T";
Session["Topic" + sid] = agcount + 1;
rbll.UpdateAgree(index);
System.Threading.Thread.Sleep(500);
showreply();
}
else
{
LearnSite.Common.WordProcess.Alert("您已经点赞过了！", this.Page);
}
}
else
{
LearnSite.Common.WordProcess.Alert("最多点赞9次！", this.Page);
}
}
else
{
Session["Topic" + sid] = 1;
rbll.UpdateAgree(index);
System.Threading.Thread.Sleep(500);
showreply();
}
}
}
/// <summary>
/// 返回本课的活动、调查、讨论、表单 汇总表
/// </summary>
/// <param name="Cid"></param>
/// <param name="Sgrade"></param>
/// <param name="Sclass"></param>
public DataTable CourseTotals(int Cid, int Sgrade, int Sclass)
{
Students sbll = new Students();
DataTable dtstus = sbll.GetStudentsSnumSname(Sgrade, Sclass).Tables[0];//学号和姓名
if (dtstus.Rows.Count > 0)
{
ListMenu lbll = new ListMenu();
DataTable dt = lbll.GetShowedMenu(Cid).Tables[0];
int dcount = dt.Rows.Count;
if (dcount > 0)
{
Works wbll = new Works();
SurveyFeedback fbll = new SurveyFeedback();
TopicReply rbll = new TopicReply();
TxtFormBack xbll = new TxtFormBack();
for (int i = 0; i < dcount; i++)
{
string Ltype = dt.Rows[i]["Ltype"].ToString(); //获取学案项目类型：1活动2调查3讨论4表单
int Lxid = Convert.ToInt32(dt.Rows[i]["Lxid"].ToString()); //获取对应项目ID编号
string Ltitle = dt.Rows[i]["Ltitle"].ToString().Replace(" ", ""); //获取菜单标题
string Ltitlestr = "l" + Ltype + "x" + Lxid.ToString();
switch (Ltype)
{
case "1": //活动
case "5": //编程
DataTable dtms = wbll.getScoreList(Lxid, Sgrade, Sclass);
if (dtms.Rows.Count > 0)
{
dtstus.Columns.Add(Ltitlestr, typeof(int));
GetScore(dtstus, Ltitlestr, dtms);
dtstus.Columns[Ltitlestr].ColumnName = Ltitle;
}
dtms.Dispose();
break;
case "2": //调查
DataTable dtsf = fbll.GetClassScore(Lxid, Sgrade, Sclass);
if (dtsf.Rows.Count > 0)
{
dtstus.Columns.Add(Ltitlestr, typeof(int));
GetScore(dtstus, Ltitlestr, dtsf);
dtstus.Columns[Ltitlestr].ColumnName = Ltitle;
}
dtsf.Dispose();
break;
case "3": //讨论
DataTable dttr = rbll.GetClassListScore(Sgrade, Sclass, Lxid);
if (dttr.Rows.Count > 0)
{
dtstus.Columns.Add(Ltitlestr, typeof(int));
GetScore(dtstus, Ltitlestr, dttr);
dtstus.Columns[Ltitlestr].ColumnName = Ltitle;
}
dttr.Dispose();
break;
case "4": //表单
DataTable dttx = xbll.GetClassTxtFormScore(Sgrade, Sclass, Lxid);
if (dttx.Rows.Count > 0)
{
dtstus.Columns.Add(Ltitlestr, typeof(int));
GetScore(dtstus, Ltitlestr, dttx);
dtstus.Columns[Ltitlestr].ColumnName = Ltitle;
}
dttx.Dispose();
break;
}
}
}
dt.Dispose();
//汇总
int cml = dtstus.Columns.Count;
if (cml > 2)
{
Signin gbll = new Signin();
DataTable dtatd = gbll.GetClassListQattitude(Sgrade, Sclass, Cid);
if (dtatd.Rows.Count > 0)
{
string clmatd = "clmattitude";
dtstus.Columns.Add(clmatd, typeof(int));
GetScore(dtstus, clmatd, dtatd);
dtstus.Columns[clmatd].ColumnName = "课堂表现";
cml = cml + 1;//新增了课堂表现列
}
dtstus.Columns.Add("汇总", typeof(float));
dtTotal(dtstus, cml);
}
}
dtstus.Columns["Snum"].ColumnName = "学号";
dtstus.Columns["Sname"].ColumnName = "姓名";
return(dtstus);
}