private static void CopyFiles(Assignment assignment, Submit submit, string teamSubmitDirName, SystemSettings systemSettings)
{
MoCS.BuildService.Business.FileSystemWrapper fileSystem = new Business.FileSystemWrapper();
// Copy nunit.framework.dll to this directory
fileSystem.FileCopy(Path.Combine(systemSettings.NunitAssemblyPath, "nunit.framework.dll"),
Path.Combine(teamSubmitDirName, "nunit.framework.dll"), true);
//copy the file to this directory
using (Stream target = fileSystem.FileOpenWrite(Path.Combine(teamSubmitDirName, submit.FileName)))
{
try
{
target.Write(submit.Data, 0, submit.Data.Length);
}
finally
{
target.Flush();
}
}
// Copy the interface file
//delete the file if it existed already
AssignmentFile interfaceFile = assignment.AssignmentFiles.Find(af => af.Name == "InterfaceFile");
fileSystem.DeleteFileIfExists(Path.Combine(teamSubmitDirName, interfaceFile.FileName));
fileSystem.FileCopy(Path.Combine(assignment.Path, interfaceFile.FileName),
Path.Combine(teamSubmitDirName, interfaceFile.FileName));
//copy the server testfile
//delete the file if it existed already
AssignmentFile serverTestFile = assignment.AssignmentFiles.Find(af => af.Name == "NunitTestFileServer");
fileSystem.DeleteFileIfExists(Path.Combine(teamSubmitDirName, serverTestFile.FileName));
fileSystem.FileCopy(Path.Combine(assignment.Path, serverTestFile.FileName),
Path.Combine(teamSubmitDirName, serverTestFile.FileName));
//copy additional serverfiles
List <AssignmentFile> serverFilesToCopy = assignment.AssignmentFiles.FindAll(af => af.Name == "ServerFileToCopy");
foreach (AssignmentFile serverFileToCopy in serverFilesToCopy)
{
fileSystem.DeleteFileIfExists(Path.Combine(teamSubmitDirName, serverFileToCopy.FileName));
fileSystem.FileCopy(Path.Combine(assignment.Path, serverFileToCopy.FileName),
Path.Combine(teamSubmitDirName, serverFileToCopy.FileName));
}
//copy the client testfile
AssignmentFile clientTestFile = assignment.AssignmentFiles.Find(af => af.Name == "NunitTestFileClient");
//delete the file if it existed already
fileSystem.DeleteFileIfExists(Path.Combine(teamSubmitDirName, clientTestFile.FileName));
fileSystem.FileCopy(Path.Combine(assignment.Path, clientTestFile.FileName),
Path.Combine(teamSubmitDirName, clientTestFile.FileName));
}
/// <summary>
/// Display the assignment file link and URL
/// </summary>
/// <param name="file">The assignment file</param>
/// <param name="counter">The number of the file</param>
private void DisplayFileLink(AssignmentFile file, int counter)
{
HyperLink fileLink = new HyperLink();
fileLink.ID = "file" + counter.ToString(CultureInfo.InvariantCulture);
fileLink.Text = file.Name;
fileLink.Style.Add("display", string.Empty);
DropBoxEditMode editMode = Status == LearnerAssignmentState.Completed ? DropBoxEditMode.Edit : DropBoxEditMode.View;
DropBoxEditDetails editDetails = dropBox.GenerateDropBoxEditDetails(file, SPWeb, editMode, returnUrl);
fileLink.NavigateUrl = editDetails.Url;
if (string.IsNullOrEmpty(editDetails.OnClick) == false)
{
fileLink.Attributes.Add("onclick", editDetails.OnClick + "return false;");
}
else
{
if (SlkStore.Settings.DropBoxSettings.OpenSubmittedInSameWindow)
{
fileLink.Attributes.Add("onclick", "window.top.location='" + editDetails.Url + "';");
}
}
FilePanel.Controls.Add(new LiteralControl("<div>"));
FilePanel.Controls.Add(fileLink);
FilePanel.Controls.Add(new LiteralControl("</div>"));
}
private void DeleteAndCopySingleAssignmentFile(string fileName, string teamSubmitDirName, Assignment assignment)
{
AssignmentFile file = assignment.AssignmentFiles.Find(af => af.Name == fileName);
FileSystem.DeleteFileIfExists(Path.Combine(teamSubmitDirName, file.FileName));
FileSystem.FileCopy(Path.Combine(assignment.Path, file.FileName),
Path.Combine(teamSubmitDirName, file.FileName));
}
public static Assignment FillAssignmentDetailsFromXml(Assignment a, IFileSystem fileSystem, bool includeServerFiles)
{
if (a == null)
{
return(null); //no active assignment
}
string path = Path.Combine(a.Path, "assignment.xml");
if (fileSystem.FileExists(path))
{
XmlDocument doc = fileSystem.LoadXml(path);
a.FriendlyName = GetNodeValue(doc, "Assignment/DisplayName");
//a.Tagline = GetNodeValue(doc, "Assignment/Hint");
a.Difficulty = int.Parse(GetNodeValue(doc, "Assignment/Difficulty"));
a.Author = GetNodeValue(doc, "Assignment/Author");
a.Category = GetNodeValue(doc, "Assignment/Category");
a.InterfaceNameToImplement = GetNodeValue(doc, "Assignment/Rules/InterfaceNameToImplement");
a.ClassNameToImplement = GetNodeValue(doc, "Assignment/Rules/ClassNameToImplement");
//a.ClassFileName = GetNodeValue(doc, "Assignment/Files/ClassFile");
//a.InterfaceFileName = GetNodeValue(doc, "Assignment/Files/InterfaceFile");
//a.UnitTestClientFileName = GetNodeValue(doc, "Assignment/Files/NunitTestFileClient");
//a.UnitTestServerFileName = GetNodeValue(doc, "Assignment/Files/NunitTestFileServer");
//a.CaseFileName = GetNodeValue(doc, "Assignment/Files/Case");
a.AssignmentFiles = new List <AssignmentFile>();
XmlNode fileNode = doc.SelectSingleNode("Assignment/Files");
foreach (XmlNode fileChildNode in fileNode.ChildNodes)
{
string nodeName = fileChildNode.Name;
string fileName = fileChildNode.InnerText;
string filepath = Path.Combine(a.Path, fileName);
if (File.Exists(filepath))
{
if (includeServerFiles || (nodeName != "NunitTestFileServer" && nodeName != "ServerFileToCopy"))
{
AssignmentFile assignmentFile = new AssignmentFile();
assignmentFile.Name = nodeName;
assignmentFile.FileName = fileName;
assignmentFile.Data = FacadeHelpers.ReadByteArrayFromFile(filepath);
a.AssignmentFiles.Add(assignmentFile);
}
}
}
}
else
{
throw new ApplicationException("Details for the assignment could not be found");
}
return(a);
}
private void FindDocumentUrl()
{
DropBoxManager manager = new DropBoxManager(AssignmentProperties);
AssignmentFile[] files = manager.LastSubmittedFiles(true);
if (files.Length == 0)
{
// Intial copy must have failed.
CopyDocumentToDropBox();
}
else if (files.Length > 0)
{
assignmentFile = files[0];
}
}
private void SetupFileAction(AssignmentFile file, SlkButton button, bool includeReload)
{
DropBoxManager dropBoxMgr = new DropBoxManager(AssignmentProperties);
DropBoxEditMode editMode = DropBoxEditMode.Edit;
switch (LearnerAssignmentProperties.Status)
{
case LearnerAssignmentState.Completed:
case LearnerAssignmentState.Final:
editMode = DropBoxEditMode.View;
break;
}
DropBoxEditDetails editDetails = dropBoxMgr.GenerateDropBoxEditDetails(file, SPWeb, editMode, Page.Request.RawUrl);
string script = editDetails.OnClick;
if (string.IsNullOrEmpty(script))
{
if (includeReload)
{
script = string.Format(CultureInfo.InvariantCulture, "window.location='{0}&{1}=true';", CurrentUrl, startQueryStringName);
}
}
else
{
if (LearnerAssignmentProperties.Status == LearnerAssignmentState.NotStarted && includeReload)
{
script = string.Format(CultureInfo.InvariantCulture, "{0}window.location='{1}&{2}=true';return false;", script, CurrentUrl, startQueryStringName);
}
else
{
script = script + "return false;";
}
}
button.OnClientClick = script;
button.NavigateUrl = editDetails.Url;
}
/// <summary>
/// (未上传则)上传作业/(已上传则)重新上传作业
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUp_Click(object sender, EventArgs e)
{
this.lbtUp.Enabled = false;
this.btSubmit.Enabled = false;
//贡献分
DataTable member = new Search().GetMenbersByGroupId(Convert.ToInt32(HiddenField2.Value));
List<int> members = new List<int>();
List<int> scores = new List<int>();
int sumScore = 0;
for (int i = 0; i < member.Rows.Count; i++)
{
members.Add(Convert.ToInt32(member.Rows[i]["ID"]));
string score = ((TextBox)StuScores.Controls[i].Controls[1]).Text;
if (score == "")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('成员贡献分不可为空！')</script>");
return;
}
scores.Add(Convert.ToInt32(score));
sumScore += scores[i];
}
if (sumScore > 100)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('成员贡献分之和超出100！')</script>");
return;
}
else if (sumScore < 100)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('成员贡献分之和不足100！')</script>");
return;
}
bool fileIsValid = false;
//如果确认了上传文件，则判断文件类型是否符合要求
if (this.InputFile1.HasFile)
{
//获取上传文件的后缀
String fileExtension = System.IO.Path.GetExtension(this.InputFile1.FileName).ToLower();
String[] restrictExtension = { ".rar", ".zip" };
//判断文件类型是否符合要求
for (int i = 0; i < restrictExtension.Length; i++)
{
if (fileExtension == restrictExtension[i])
{
fileIsValid = true;
}
}
////////////////////////////////////////////////////////////
/////可以增加一条,时间过期,不准再上传文件
////其实这样子写数据库操作很不规范，真正的三层架构是不许这样子写的，
////但是时间原因和编码人员的习惯问题导致，希望后续人员能够改进
////////////////////////////////////////////////////////////
//连接数据库
SqlConnection sqlCon = CC.GetConnection();
//定义SQL语句
int assmtID = Convert.ToInt32(HiddenField1.Value);
string SqlStr = "select * from Assignment where ID=" + assmtID;
//实例化SqlDataAdapter对象
SqlDataAdapter da = new SqlDataAdapter(SqlStr, sqlCon);
//实例化数据集DataSet
DataSet ds = new DataSet();
da.Fill(ds, "GroupAssmtInfo");
DateTime deadline = Convert.ToDateTime(ds.Tables["GroupAssmtInfo"].Rows[0][4]);
DateTime time = DateTime.Now;
sqlCon.Close();
//连接数据库
SqlConnection sqlCon1 = CC.GetConnection();
//定义SQL语句
//int assmtID = Convert.ToInt32(HiddenField1.Value);
int grpID = Convert.ToInt32(HiddenField2.Value);
string SqlStr1 = "select * from Assignment_Group where assignmentID=" + assmtID + " and groupID=" + grpID;
//实例化SqlDataAdapter对象
SqlDataAdapter da1 = new SqlDataAdapter(SqlStr1, sqlCon1);
//实例化数据集DataSet
DataSet ds1 = new DataSet();
da1.Fill(ds1, "AssmtFile");
bool n = ds1.Tables["AssmtFile"].Rows[0][7] == DBNull.Value ? false : true;
sqlCon1.Close();
if (time < deadline)
{
//如果文件类型符合要求,调用moveto方法实现上传,并显示相关信息;在此处修改贡献分
if (fileIsValid == true)
{
if (new Student().AttributeScores(members, scores, Convert.ToInt32(HiddenField1.Value), Convert.ToInt32(HiddenField2.Value)))
{
try
{
//胡媛媛修改，上传大文件到服务器，2010-3-11，修改作业上传的位置，2010-6-11
string FilePath = Server.MapPath("..//") + "SiteFile" + "\\" + "homework";
// this.FileUpload1.SaveAs(FilePath + "//" + FileUpload1.FileName);
string SaveFileName = FilePath + "\\" + InputFile1.FileName;
// this.InputFile1.MoveTo(SaveFileName, Brettle.Web.NeatUpload.MoveToOptions.Overwrite);
//胡媛媛修改，上传大文件到服务器，2010-3-11，修改作业上传的位置，2010-6-11
/////////////////////////////////////////////////////////////////////////////
/////////////向数据库里相关表里插入一条记录并改变其他表相关字段的值
////////////////////////////////////////////////////////////////////////////
if (false == n)//n=1的时候是第一次上传文件
{
bool success = false;
AssignmentFile afile = new AssignmentFile();
AssignmentFileInfo afileInfo = new AssignmentFileInfo();
afileInfo.StrFileName = InputFile1.FileName;
afileInfo.StrFileTrueName = "[" + new AssignmentFile().GetAutoId() + "]" + InputFile1.FileName;
afileInfo.StrFileURL = FilePath + "\\" + afileInfo.StrFileTrueName;
afileInfo.IAssignmentId = Convert.ToInt32(HiddenField1.Value);
afileInfo.IGroupId = Convert.ToInt32(HiddenField2.Value);
afileInfo.DtSubmitTime = DateTime.Now;
//上传文件的函数，想数据库中添加
success = afile.UploadAssignmentFile(afileInfo);
if (true == success)
{
//胡媛媛修改，调整文件保存的位置，使其先删除后保存，2010-6-4
this.InputFile1.MoveTo(afileInfo.StrFileURL, Brettle.Web.NeatUpload.MoveToOptions.Overwrite);
//胡媛媛修改，调整文件保存的位置，使其先删除后保存，2010-6-4
this.Label1.Text = "上传成功！";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('上传成功！');location=location;</script>");
n = true;
return;
}
else
{
//回滚
string myupdate = "delete Assignment_Group where assignmentID='" + assmtID + "'and groupID=' " + grpID + "'";
sqlCon1.Open();
SqlCommand mycmd = new SqlCommand(myupdate, sqlCon1);
mycmd.ExecuteNonQuery();
sqlCon1.Close();
this.Label1.Text = "上传失败！";
}
}
else
{
//重新上传
//胡媛媛添加，获取原来上传的文件ID，2010-03-03
int assmfileid = Convert.ToInt32(ds1.Tables["AssmtFile"].Rows[0][0]);
//胡媛媛添加，获取原来上传的文件ID，2010-03-03
bool success = false;
AssignmentFile afile = new AssignmentFile();
AssignmentFileInfo afileInfo = new AssignmentFileInfo();
afileInfo.StrFileName = InputFile1.FileName;
afileInfo.StrFileTrueName = "[" + new AssignmentFile().GetAutoId() + "]" + InputFile1.FileName;
afileInfo.StrFileURL = FilePath + "\\" + afileInfo.StrFileTrueName;
afileInfo.IAssignmentId = Convert.ToInt32(HiddenField1.Value);
afileInfo.IGroupId = Convert.ToInt32(HiddenField2.Value);
afileInfo.DtSubmitTime = DateTime.Now;
//胡媛媛添加，得到原来上传的文件Id，2010-03-03
afileInfo.IAssignmentFileId = assmfileid;
//胡媛媛添加，得到原来上传的文件Id，2010-03-03
success = afile.ReuploadAssignmentFile(afileInfo);
if (true == success)
{
//胡媛媛修改，调整文件保存的位置，使其先删除后保存，2010-6-4
this.InputFile1.MoveTo(afileInfo.StrFileURL, Brettle.Web.NeatUpload.MoveToOptions.Overwrite);
//胡媛媛修改，调整文件保存的位置，使其先删除后保存，2010-6-4
this.Label1.Text = "上传成功！";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('上传成功！');location=location;</script>");
n = true;
//Response.AddHeader("Refresh", "0");
return;
}
else
{
this.Label1.Text = "上传失败！";
n = true;
}
}
}
catch
{
this.Label1.Text = "文件上传不成功！";
}
}
else
{
this.Label1.Text = "服务器繁忙，请稍后再试!";
}
}
else
{
this.Label1.Text = "只能是.zip或.rar文件";
}
}
else
{
this.Label1.Text = "超过作业要求上传最后期限，不能上传！";
}
}
else
{
this.Label1.Text = "未选择需上传的文件";
}
}
//页面加载
protected void Page_Load(object sender, EventArgs e)
{
//判断用户名是否为空
if (Session["UserName"] == null)
{
System.Web.HttpContext.Current.Response.Write("<script>alert('请先登录');window.location.href='../Default.aspx'</script>");
return;
}
//判断用户类型是否为学生
if (Session["Type"].ToString() == "Student")
{
System.Web.HttpContext.Current.Response.Write("<script>window.location.href='../WarningPage.aspx'</script>");
return;
}
//判断用户类型是否为教师并且激活
if (Session["Type"].ToString() == "Teacher" && Session["UserState"].ToString() != "Active")
{
System.Web.HttpContext.Current.Response.Write("<script>alert('帐号未激活,请激活后重试');window.location.href='../Activate.aspx'</script>");
return;
}
try
{
course = Session["Course"].ToString();
strUserName = Session["UserName"].ToString();
type = Session["Type"].ToString();
assmtID = Int32.Parse(Request.QueryString["aid"]).ToString();
groupID = Int32.Parse(Request.QueryString["gid"]).ToString();
}
catch
{
Response.Redirect("../Default.aspx");
return;
}
//设置默认焦点在评语发表框
if (!IsPostBack)
{
//程军添加，教师点击新留言后，使newMsg状态变为0。2010-3-10
int aid = Convert.ToInt32(assmtID);
int gid = Convert.ToInt32(groupID);
string sql = ConfigurationManager.AppSettings["SQLConnStringSTEduSys"].ToString();
SqlConnection myConn = new SqlConnection(sql);
myConn.Open();
string mySql = "update Assignment_Group set newMsgNum = 0 where assignmentID = " + aid + "and groupID = " + gid;
SqlCommand myCmd = myConn.CreateCommand();
myCmd.CommandText = mySql;
myCmd.ExecuteNonQuery();
myConn.Close();
//程军添加，教师点击新留言后，使newMsg状态变为0。2010-3-10
tbNewMsg.Focus();
if (assmtID != null)
{
RepeaterDataBind();
if (1 != index)
{
this.lbfirst.Visible = false;
}
//SubjectInfo si = new Forum().GetSubjectById(Convert.ToInt32(Request.QueryString["id"]));
//AssignmentInfo ass = new Assignment().GetAssignmentById(Convert.ToInt32(Request.QueryString["aid"]));
//获得作业名
AssignmentInfo ass = new Assignment().GetAssignmentById(Convert.ToInt32(assmtID));
lbAssTitle.Text = ass.StrTitle;
//DataTable dt = new Assignment().GetClassNameandGroupNO(Convert.ToInt32(Request.QueryString["aid"]), Convert.ToInt32(Request.QueryString["gid"]));
//获得组的班组号
DataTable dt = new Assignment().GetClassNameandGroupNO(Convert.ToInt32(groupID));
if (null != dt)
{
string classname = Convert.ToString(dt.Rows[0][0]);
string groupNO = Convert.ToString(dt.Rows[0][1]);
lbGroup.Text = classname + groupNO + "组";
}
else
lbGroup.Text="不存在该组！";
//获得组内学生姓名
string groupLeader = new Search().GetGroupLeaderByGroupID(Convert.ToInt32(groupID));
DataTable sdt = new Search().GetMenbersByGroupId(Convert.ToInt32(groupID));
if (null != sdt)
{
string stuname = null;
for (int i = 0; i < sdt.Rows.Count; i++)
{
if (sdt.Rows[i][3].ToString() == groupLeader)
{
stuname = stuname + sdt.Rows[i][3] + "(组长) ";
}
else
{
stuname = stuname + sdt.Rows[i][3] + " ";
}
}
lbMembers.Text = stuname;
}
else
lbMembers.Text = "不存在该组学生！";
//获得作业名
DataTable ads = new AssignmentFile().GetAssignmentFileByAssignmentIdAndGroupID(Convert.ToInt32(assmtID), Convert.ToInt32(groupID));
if (ads.Rows.Count!=0)
{
string af =Convert.ToString( ads.Rows[0][1]);
lbFileName.Text = af;
}
else
lbFileName.Text = "未提交";
//lbTitle.Text = "主题：" + si.StrTheme;
//UserControl_ThemeOfMsg theme = this.ThemeOfMsg1;
//theme.Subject = si;
}
}
}
private void CopyDocumentToDropBox()
{
DropBoxManager manager = new DropBoxManager(AssignmentProperties);
assignmentFile = manager.CopyFileToDropBox();
}
/// <summary>
/// 文件打包下载这个功能未实现,如要实现时 可以参考SAssignmentInfo.aspx.cs 只需一个文件路径即可 问题是要得到所有的路径并分班打包
/// 打包函数用张航留下的那个
/// 可能需要引用gridview单元格内的内容(比如班级),可以试一试用GridView1.Rows[i].Cells[1].ToString();
/// 路径这个字段在TAssmtInfo视图中有可以参考下一行注释使用这个字段
/// 如另想要TAssmtInfo视图的其他字段可以再在页面添加
/// <asp:BoundField DataField="submitTime" HeaderText="提交日期" Visible=false/>之类的,但是注意要Visible=false就可以
/// 关于复选框的获得可以参考admin中学生管理页面的cs代码
/// 当然,如果不用gridview实现的话,上面都是废话了
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
///胡媛媛添加btDownLoad_Click事件代码，2010-03-06
protected void btDownLoad_Click(object sender, EventArgs e)
{
int asscount = 0;
int flag = 1; //用来判断是否有小组未上传作业，初始值为1，如果有小组未交上传作业则值为0；
List<pathitem> FilePathArray = new List<pathitem>();
//ArrayList FilePathArray = new ArrayList();
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
//建立模板列中CheckBox控件的引用
CheckBox chk = (CheckBox)GridView1.Rows[i].FindControl("chkCheck");
if (chk.Checked == true)
{
asscount++; //统计选中的作业数目
if (GridView1.Rows[i].Cells[3].Text == " ") //文件名为空，作业未上传。
{
flag = 0;
}
}
}
if (asscount == 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script>alert('未选中任何作业，请选择一个作业后再下载！')</script>");
return;
}
if (flag == 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script>alert('有小组未交作业，无法下载！')</script>;");
return;
}
if ((asscount != 0) && (flag == 1))
{
//胡媛媛修改，获取班级名称和文件路径，2010-3-13
// ArrayList classname = new ArrayList(); //记录班级的名称
// int k=0;
SqlConnection myconn = CC.GetConnection();
string mystr = "select fileName,fileURL from Assignment_Group where assignmentID =" + Convert.ToInt32(id);
SqlDataAdapter mydata = new SqlDataAdapter(mystr, myconn);
DataSet ds = new DataSet();
mydata.Fill(ds, "AssmtFile");
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
CheckBox chk = (CheckBox)GridView1.Rows[i].FindControl("chkCheck");
if (chk.Checked == true)
{
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
if (GridView1.Rows[i].Cells[3].Text == ds.Tables[0].Rows[j][0].ToString())
{
string tmpname = GridView1.Rows[i].Cells[1].Text;
StringBuilder filename = new StringBuilder(tmpname);
filename.Append(GridView1.Rows[i].Cells[2].Text).Append("组");
pathitem item1 = new pathitem(filename.ToString(), ds.Tables[0].Rows[j][1].ToString());
FilePathArray.Add(item1);
}
}
}
}
AssignmentFile zfile = new AssignmentFile();
bool fg=zfile.Compreassmtfile(FilePathArray, this.lbTitle.Text);
//胡媛媛修改，获取班级名称和文件路径，2010-3-13
//程军修改,2010-3-9
if (fg==true)
{
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
CheckBox chk = (CheckBox)GridView1.Rows[i].FindControl("chkCheck");
if (chk.Checked == true)
{
string className = GridView1.Rows[i].Cells[1].Text.ToString();
int groupNO = Convert.ToInt32(GridView1.Rows[i].Cells[2].Text.ToString());
SqlParameter[] parms = {
new SqlParameter("@className",className),
new SqlParameter("@groupNO",groupNO),
new SqlParameter("@courseName", course)
};
SqlDataReader reader = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringSTEduSys, CommandType.StoredProcedure, "SP_GetGroupIdByClassNameAndGroupNO", parms);
reader.Read();
int groupID = Convert.ToInt32(reader[0].ToString());
reader.Close();
SqlConnection myConn = CC.GetConnection();
myConn.Open();
string mySql = "update Assignment_Group set state = 2 where assignmentID=" + Convert.ToInt32(id) + "and groupID =" + groupID;
SqlCommand myCmd = myConn.CreateCommand();
myCmd.CommandText = mySql;
myCmd.ExecuteNonQuery();
myConn.Close();
}
}
Response.Write("<script>window.location.reload(true);</script>");
}
else
{
Response.Write("<script>alert('下载失败！');</script>");
}
System.Web.HttpContext.Current.Response.End();
//程军修改,2010-3-9
}
}
