private void BindDataByReview()
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfo(UserNo);//传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
}
private void ValidateAction()
{
if (ticket != "" && ticket != null)
{
string url = "http://lzyun.doule.net:20114/aamif/ticketValidate?ticket=" + ticket;
//Response.Write("<script>alert('" + url + "')</script>"); //后台弹出url地址测试
//XDocument oXDoc = XDocument.Load(url);
//创建XDocument对象，并根据url请求返回数据,返回的是xml数据
string userid = UrlHtmlUtil.getuserid(url);
if (userid != "")
{
Session["userid"] = userid;
if (Session != null)
{
userid = Session["userid"].ToString();
}
//请求用户信息的url地址
string url2 = "http://lzyun.doule.net:20107/aam/rest/user/getuserinfo/" + userid + "?token=" + ticket;
//根据URL请求返回获取用户信息数据
JObject ja = UrlHtmlUtil.getHtmlJsonByUrl(url2);
string usernanme = ja["userinfo"]["name"].ToString();
Session["userinfo"] = ja; //将请求返回的用户信息对象存放到Session["userinfo"]
string userID = ((JObject)Session["userinfo"])["userinfo"]["account"].ToString();
if (Session["User"] == null)
{
UrlHtmlUtil.GetUserInfo(userID);
}
}
}
}
private void BindDataToDropList_SchoolGroup()
{
string TextField = "SchoolGroupName";
string ValueField = "SchoolGroupID";
UrlHtmlUtil.BindDataToList2(DropList_SchoolGroup, UrlHtmlUtil.GetSchoolGroup(""), TextField, ValueField);
}
private void BindDataToDropList_District()
{
string TextField = "DistrictName";
string ValueField = "DistrictID";
UrlHtmlUtil.BindDataToList2(DropList_District, UrlHtmlUtil.GetDistrictInfo(""), TextField, ValueField);
}
private void BindDataToDropList_School()
{
string TextField = "SchoolName";
string ValueField = "SchoolID";
UrlHtmlUtil.BindDataToList2(DropList_School, UrlHtmlUtil.GetSchoolInfo("", "", ""), TextField, ValueField);
}
private void BindDataToSubjectList()
{
string TextField = "SubjectName";
string ValueField = "SubjectID";
UrlHtmlUtil.BindDataToList(DropList_Subject, UrlHtmlUtil.GetSubjectInfo(""), TextField, ValueField);
}
private void FullData(ClsWorksInfo[] data, int i)
{
Int32 myEnrolid = data[i].EnrollID;
EnrollID = myEnrolid;
if (UrlHtmlUtil.GetUserRole().Equals("管理员"))
{
DataTable dt = UrlHtmlUtil.GetWorksInfo(myEnrolid);
JumpInterface(GetDataFullTable(dt));
adminRole(true, dt);
}
else
{
GetWorksInfo(myEnrolid, UserNo);
}
//EntriesName.Text = data[i].EntriesName.Trim(); //作品名称
//EnrolName.Text = data[i].EnrolName.Trim(); //作者
//DistrictName.Text = data[i].DistrictName.Trim(); //学区
//SchoolName.Text = data[i].SchoolName.Trim(); //学校
//SchoolGroupName.Text = data[i].SchoolGroupName.Trim();//学段
//EntriesTime.Text = data[i].EntriesTime.Trim(); //作品上传时间
//filePath = data[i].EntriesURL.Trim(); //作品链接
////Lab_EnrolScore1.Text = data[i].EnrolScore.Trim(); //作品得分
//// Lab_EnrolComment.Text = data[i].EnrolComment.Trim(); //评语
//AuditStatus.Text = "状态：" + data[i].AuditStatus.Trim(); //审核状态
////EnrolTime1.Text = data[i].EnrolTime.Trim(); //审核时间
}
public void GetWorksInfo(Int32 myEnrollID, string myUserNo)
{
DataTable dt = UrlHtmlUtil.GetWorksInfo(myEnrollID, myUserNo);
JumpInterface(GetDataFullTable(dt));
adminRole(false, dt);
}
protected void Btn_MyInfoOK_Click(object sender, EventArgs e)
{
//这里修改状态
if (UrlHtmlUtil.UpdateIsFirst(false, UserNo))
{
this.showMyInfo.Style.Add("display", "none");
}
}
private void BindDataToSchoolList(string myUserNo)
{
string TextField = "SchoolName";
string ValueField = "SchoolID";
DataTable dt = UrlHtmlUtil.GetSchoolInfo2(myUserNo, 3);//参数：用户主键ID，2表示高中组
myDistrictName = dt.Rows[0]["DistrictName"].ToString().Trim();
mySchoolName = dt.Rows[0]["SchoolName"].ToString().Trim();
UrlHtmlUtil.BindDataToList(DropList_School, dt, TextField, ValueField);
}
protected void Btn_Submit_Click(object sender, EventArgs e)
{
string CommentText = Comment.Value;
string ScoreText = Score.Value;
if (UrlHtmlUtil.AddEntriesInfoScore(EnrollID, UserNo, ScoreText, CommentText))
{
Response.Write("<script language=javascript>alert('评分成功！');</script>");
GetWorksInfo(EnrollID, UserNo);
}
}
private void BindDataByReview(string myUserNo)
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfoByReview(myUserNo, false);//传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
UserNo = UrlHtmlUtil.GetUserNo();
updateEnrolInfo = new EnrolInfo();
BindDataToSchoolList(UserNo); //绑定学校下拉列表
BindDataByReview();
BindDataToSubjectList(); //绑定学科下拉列表
}
}
protected void deleteEnroll(object sender, EventArgs e)
{
LinkButton txt = (LinkButton)sender;
GridViewRow row = (GridViewRow)txt.NamingContainer;
string EnrollID = GridViewData.Rows[row.DataItemIndex].Cells[0].Text.Trim();
if (UrlHtmlUtil.DeleteEnrolInfo(EnrollID))
{
Response.Write("<script>alert('删除成功!')</script>");
BindDataByReview();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (UrlHtmlUtil.GetUserRole().Equals("申报人"))
{
JumpInterface(UrlHtmlUtil.GetSchoolGroupID());
}
else
{
UrlHtmlUtil.MsgBox("您不具备申报人权限！");
}
}
}
private void BindDataByReview()
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfo2(UserNo);//传申报人ID进去，返回对应的填写参赛信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
if (Convert.ToInt16(dt.Rows[0]["IsFirst"]) == 1)
{
this.showMyInfo.Style.Add("display", "block");
}
}
}
protected void But_outdata_Click(object sender, EventArgs e)
{
DataTable dt;
if (UrlHtmlUtil.GetUserRole().Equals("管理员"))
{
//参数：传送筛选条件查询全部记录
dt = UrlHtmlUtil.PrintEnrollInfo(FindTextRecord);
EportAllDataToExcel(dt);
}
else
{
UrlHtmlUtil.ShowMess("您不具备该权限！");
}
}
protected void btUpFile_Click(object sender, EventArgs e)
{
try
{
if (FileUp1.HasFile)
{
string filePath = Path.GetFullPath(FileUp1.PostedFile.FileName);
if (filePath != "")
{
string savePath = Server.MapPath("~/Fileupload/");//指定上传文件在服务器上的保存路径
//检查服务器上是否存在这个物理路径，如果不存在则创建
if (!System.IO.Directory.Exists(savePath))
{
System.IO.Directory.CreateDirectory(savePath);
}
string worksName = FileUp1.FileName;
string fileName = DateTime.Now.ToString("yyyyMMddhhmmssfff") + worksName;
savePath = savePath + fileName;
FileUp1.SaveAs(savePath);
if (System.IO.File.Exists(savePath))
{
if (UrlHtmlUtil.AddEnrolEntries(EnrollID, worksName, "Fileupload/" + fileName))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "show", "<script>alert('上传成功！')</script>", false);
string iframe = "~/FrmFillMatchInfo.aspx";
Response.Redirect(iframe);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "show", "<script>alert('上传失败！')</script>", false);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "show", "<script>alert('请先选择导入文件后，再执行导入！谢谢！')</script>", false);
}
}
}
catch (Exception)
{
}
}
protected void Btn_Submit_Click(object sender, EventArgs e)
{
EnrolInfo myEnrolInfo = new EnrolInfo();
myEnrolInfo.SchoolID = Convert.ToInt32(DropList_School.Text); //学校ID
myEnrolInfo.EnrolName = Tbx_Name.Text.Trim(); //姓名
myEnrolInfo.EnrolSex = DropList_Sex.SelectedItem.Text; //性别
myEnrolInfo.EnrolBirthday = Tbx_Birthday.Text.Trim(); //出生年月
myEnrolInfo.EnrolTeacherTitle = Tbx_Title.Text.Trim(); //职称
myEnrolInfo.EnrolSubject = Convert.ToInt32(DropList_Subject.Text); //学科
myEnrolInfo.EnrolWorkYear = Tbx_WorkYear.Text.Trim(); //教龄
myEnrolInfo.EnrolTel = Tbx_Tel.Text.Trim(); //联系电话
if (UrlHtmlUtil.AddEnrolInfo(myEnrolInfo))
{
initText();
Response.Write("<script>alert('添加成功!')</script>");
BindDataByReview();
}
}
protected void Btn_Select_Click(object sender, EventArgs e)
{
string sValue = inputtext.Value.ToString().Trim();
if (string.IsNullOrEmpty(sValue))
{
UrlHtmlUtil.ShowMess("请先输入搜索关键字！");
}
else
{
DataTable dt = UrlHtmlUtil.selectEnrolInfoByKeyword(sValue);
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FindTextRecord.AuditStatus = "";
FindTextRecord.District = "0";
FindTextRecord.School = "0";
FindTextRecord.SchoolGroup = "0";
FindTextRecord.Subject = "0";
if (UrlHtmlUtil.GetUserRole().Equals("评审人"))
{
UserNo = UrlHtmlUtil.GetUserNo();
adminRole(false);
BindDataToDropList_District(); //学区
BindDataToDropList_School(); //学校
BindDataToDropList_SchoolGroup(); //学段
BindDataToDropList_Subject(); //学科
BindDataByReview(UserNo);
}
else if (UrlHtmlUtil.GetUserRole().Equals("管理员"))
{
adminRole(true);
UserNo = UrlHtmlUtil.GetUserNo();
BindDataToDropList_District(); //学区
BindDataToDropList_School(); //学校
BindDataToDropList_SchoolGroup(); //学段
BindDataToDropList_Subject(); //学科
DataTable dt = UrlHtmlUtil.GetTEnrolInfoByReview(UserNo, true); //传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
else
{
UrlHtmlUtil.MsgBox("您不具备评审人权限！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
UserNo = UrlHtmlUtil.GetUserNo();
EnrollID = Convert.ToInt32(Request.QueryString["EnrollID"]);
if (UrlHtmlUtil.GetUserRole().Equals("管理员"))
{
ClsWorksInfoArr[0].Index = FindIndex(EnrollID);
DataTable dt = UrlHtmlUtil.GetWorksInfo(EnrollID);
JumpInterface(GetDataFullTable(dt));
adminRole(true, dt);
}
else
{
ClsWorksInfoArr[0].Index = FindIndex(EnrollID, Convert.ToInt32(UserNo));
GetWorksInfo(EnrollID, UserNo);
}
ShowPageUpAndNext();
}
}
protected void Page_Load(object sender, EventArgs e)
{
UserNo = UrlHtmlUtil.GetUserNo();
}
private bool DropListFillData(DropDownList dp)
{
string sText = dp.Text;
string sName = dp.ID.ToString().Trim();
if ("DropList_District".Equals(sName))//学区
{
FindTextRecord.District = sText;
}
else if ("DropList_School".Equals(sName))//学校
{
FindTextRecord.School = sText;
}
else if ("DropList_SchoolGroup".Equals(sName))//学段
{
FindTextRecord.SchoolGroup = sText;
}
else if ("DropList_Subject".Equals(sName))//学科
{
FindTextRecord.Subject = sText;
}
else if ("DropList_AuditStatus".Equals(sName))//评审状态
{
if (sText.Equals("全部"))
{
sText = "";
}
FindTextRecord.AuditStatus = sText;
}
else
{
UrlHtmlUtil.ShowMess("请添加该控件的事件绑定！");
return(false);
}
if (UrlHtmlUtil.GetUserRole().Equals("评审人"))
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfoByReview(UserNo, false, FindTextRecord);//传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
else if (UrlHtmlUtil.GetUserRole().Equals("管理员"))
{
DataTable dt = UrlHtmlUtil.GetTEnrolInfoByReview(UserNo, true, FindTextRecord);//传评审人ID进去，返回对应评审信息
GridViewData.DataSource = dt;
GridViewData.DataBind();
if (dt.Rows.Count > 0)
{
FullDataToclsClsWorksArr(dt);
}
}
else
{
UrlHtmlUtil.ShowMess("您不具备该权限！");
}
return(true);
}
