protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DalOperationNorm daln = new DalOperationNorm();
DalOperationAboutTeacher dalt = new DalOperationAboutTeacher();
DalOperationAboutUserAuth dalua = new DalOperationAboutUserAuth();
UserAuth auth = dalua.GetUserAuth(pageName);
DataSet ds = dalt.GetTeachers();
DataTable dt = new DataTable();
dt.Columns.Add("teacherNo");
dt.Columns.Add("teacherName");
if (auth != null)
{
if (auth.userIds != null)
{
foreach (string s in auth.userIds.Split(','))
{
DataRow[] drs = ds.Tables[0].Select("teacherNo='" + s + "'");
if (drs.Length > 0)
{
DataRow dr = dt.NewRow();
dr.SetField("teacherNo", drs[0]["teacherNo"].ToString());
dr.SetField("teacherName", drs[0]["teacherName"].ToString());
dt.Rows.Add(dr);
}
}
dsltAuthTeacher.DataSource = dt;
}
}
dsltAuthTeacher.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DalOperationNorm dalOperationNorm = new DalOperationNorm();
if (Request["normId"] != null)
{
int normId = Convert.ToInt32(Request["normId"]);
Norm norm = dalOperationNorm.getNormById(normId);
if (norm != null)
{
this.hidNormId.Value = Convert.ToString(norm.normId);
this.hidParentId.Value = Convert.ToString(norm.parentId);
this.ddltNormType.SelectedValue = Convert.ToString(norm.type);
Norm parent = null;
if ((parent = dalOperationNorm.getNormById(norm.parentId)) != null)
{
this.parentName = parent.name;
}
this.TextNormName.Text = norm.name;
this.TextComment.Text = norm.comment;
}
}
}
}
public void ProcessRequest(HttpContext context)
{
CommonFunction.CheckUser();
context.Response.CacheControl = "no-cache";
context.Response.ContentType = "text/plain";
string term = context.Request["term"];
string searchKey = context.Request["searchKey"].Trim();
string teacherType = context.Request["teacherType"].Trim();
DalOperationNorm dalnorm = new DalOperationNorm();
DataSet ds = dalnorm.getTeacherLoad(term, searchKey, teacherType);
HSSFWorkbook workbook = new HSSFWorkbook();
for (int tableIndex = 0; tableIndex < ds.Tables.Count; tableIndex++)
{
HSSFSheet sheet = workbook.CreateSheet(ds.Tables[tableIndex].TableName);
DataRowCollection drc = ds.Tables[tableIndex].Rows;
for (int i = 0; i < ds.Tables[tableIndex].Columns.Count; i++)
{
sheet.CreateRow(0).CreateCell(i).SetCellValue(ds.Tables[tableIndex].Columns[i].ColumnName);
}
for (int i = 0; i < drc.Count; i++)
{
for (int j = 0; j < ds.Tables[tableIndex].Columns.Count; j++)
{
sheet.CreateRow(i + 1).CreateCell(j).SetCellValue(drc[i][j].ToString());
}
}
}
string fileName = "norm";
System.IO.FileStream file = new System.IO.FileStream(HttpContext.Current.Server.MapPath(fileName + ".xls"), System.IO.FileMode.Create);
workbook.Write(file);
file.Dispose();
////插入值
FileInfo DownloadFile = new FileInfo(context.Server.MapPath(fileName + ".xls"));
context.Response.Clear();
context.Response.ClearHeaders();
context.Response.Buffer = false;
Encoding code = Encoding.GetEncoding("gb2312");
context.Response.ContentEncoding = Encoding.UTF8;
context.Response.HeaderEncoding = code;//这句很重要
context.Response.ContentType = "application/octet-stream";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
context.Response.AppendHeader("Content-Length", DownloadFile.Length.ToString());
context.Response.WriteFile(DownloadFile.FullName);
if (File.Exists(context.Server.MapPath(fileName + ".xls")))
{
File.Delete(context.Server.MapPath(fileName + ".xls"));
}
context.Response.Flush();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Norm norm = new Norm();
norm.normId = Convert.ToInt32(hidNormId.Value);
norm.name = TextNormName.Text;
norm.comment = TextComment.Text;
norm.parentId = Convert.ToInt32(hidParentId.Value);
norm.type = Convert.ToInt32(ddltNormType.SelectedValue);
DalOperationNorm dalOperationNorm = new DalOperationNorm();
dalOperationNorm.EditNorm(norm);
Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2&term=" + Request["year"], Page);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["normId"] != null && Request["termYear"]!=null)
{
normIds = Request["normId"].Trim();
termYear = Request["termYear"].Trim();
DalOperationNorm dal = new DalOperationNorm();
this.dlstChildNorm.DataSource = dal.GetChildNorms(Convert.ToInt32(normIds),0,termYear);
this.dlstChildNorm.DataBind();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DalOperationNorm dalOperationNorm = new DalOperationNorm();
Norm norm = new Norm();
norm.name = TextNormName.Text.Trim();
norm.comment = TextComment.Text.Trim();
norm.type = int.Parse(ddltNormType.SelectedValue);
//if (parentId.Value != null && parentId.Value != "")
//{
// norm.parentId = Convert.ToInt32(parentId.Value);
//}
//else
//{
// norm.parentId = 0;
//}
if (Request["parentId"] == null || Request["parentId"]=="")
{
norm.parentId = 0;
}
else
{
norm.parentId = Convert.ToInt32(Request["parentId"]);
}
if (Request["year"] != null && !Request["year"].Trim().Equals(""))
{
norm.year = Request["year"].Trim();
if (norm.parentId == -1)
{
if ("课程名称".Equals(norm.name) || "学期".Equals(norm.name) || "类型".Equals(norm.name) || "理论课时".Equals(norm.name) || "实验课时".Equals(norm.name))
{
Javascript.Alert("此指标名称在硕士教学中已经存在，不能重复添加！", Page);
return;
}
}
if (dalOperationNorm.ExistNormName(TextNormName.Text.Trim(),norm.parentId , norm.year))
{
Javascript.Alert("存在此指标名称，不能重复输入", Page);
return;
}
dalOperationNorm.AddNorm(norm);
Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2&term=" + Request["year"], Page);
}
else
{
Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2", Page);
}
}
protected void btnCommit_Click(object sender, EventArgs e)
{
DalOperationNorm daln = new DalOperationNorm();
NormConfirm ncom = new NormConfirm
{
teacherNo = Request["teacherNo"].Trim(),
term = Request["term"].Trim(),
question = txtproblem.Text,
type = 1,
value = Request["value"].Trim(),
answer = ""
};
daln.AddNormConfirm(ncom);
Javascript.RefreshParentWindow("/Teacher/NormView.aspx", Page);
}
protected void Page_Load(object sender, EventArgs e)
{
DalOperationNorm dalOperationNorm = new DalOperationNorm();
if (Request["parentId"] != null && Request["parentId"]!="")
{
int parentId = Convert.ToInt32(Request["parentId"]);
Norm norm = dalOperationNorm.getNormById(parentId);
if (norm != null)
{
this.parentId.Value = Convert.ToString(norm.normId);
parentName = norm.name;
}
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
DalOperationNorm dalOperationNorm = new DalOperationNorm();
NormConfirm nc = new NormConfirm{
term=term,
teacherNo = UserCookiesInfo.userNo,
question="OK",
answer="",
value = GetNormValue(0),
type = 0,
};
dalOperationNorm.AddNormConfirm(nc);
Javascript.JavaScriptLocationHref("/Teacher/NormView.aspx", Page);
}
protected void btnCommit_Click(object sender, EventArgs e)
{
NormFormula normformula = new NormFormula
{
targetNormId = Convert.ToInt32(Request["normId"].ToString().Trim()),
formula = this.formula.Value,
formulaShow = this.TextNormFormula.Value,
termYear = termYear
};
DalOperationNorm dal = new DalOperationNorm();
dal.setFormula(normformula);
NormFormula rootformula = dal.GetFormula(0,termYear);
DalOperationAboutTeacher dalteacher = new DalOperationAboutTeacher();
DataSet dsTeacher = dalteacher.GetTeachers();
for (int i = 0; i < dsTeacher.Tables[0].Rows.Count; i++)
{
string teacherNo = dsTeacher.Tables[0].Rows[i]["teacherNo"].ToString().Trim();
if (normformula != null)
{
dal.Execute(normformula, teacherNo,termYear);
}
if (rootformula != null)
{
dal.Execute(rootformula, teacherNo, termYear);
}
}
string t = "template";
if (normformula != null)
{
dal.Execute(normformula, t, termYear);
}
if (rootformula != null)
{
dal.Execute(rootformula, t, termYear);
}
Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2&&term=" + Request["termYear"], Page);
}
protected void dsltAuthTeacher_OnItemCommand(object source, DataListCommandEventArgs e)
{
string teacherNoSelect = this.dsltAuthTeacher.DataKeys[e.Item.ItemIndex].ToString();//取选中行教师编号
if (e.CommandName.Equals("remove"))
{
DalOperationNorm dalOperationNorm = new DalOperationNorm();
DalOperationAboutUserAuth dalua = new DalOperationAboutUserAuth();
UserAuth userAuth = dalua.GetUserAuth(pageName);
string[] ids = userAuth.userIds.Split(',');
List<string> list = new List<string>();
for (int i = 0; i < ids.Length; i++)
{
if (!ids[i].Equals(teacherNoSelect))
{
list.Add(ids[i]);
}
}
userAuth.userIds = string.Join(",", list.ToArray());
dalua.setUserAuth(userAuth);
Javascript.JavaScriptLocationHref("/Administrator/ViewNormAuth.aspx", Page);
}
}
protected void dlstFirstNorm_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataList dataList = (DataList)e.Item.FindControl("dlstSecondNorm");
DataRowView rowv = (DataRowView)e.Item.DataItem;
int mainID = Convert.ToInt32(rowv["normId"]);
DalOperationNorm dalOperationNorm = new DalOperationNorm();
DataSet ds = dalOperationNorm.GetChildNorms(mainID,term);
dataList.DataSource = ds.Tables[0].DefaultView;
dataList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
BaseConfig baseconfig = CacheCollections.GetBaseConfig();
if (!IsPostBack)
{
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
//UserCookiesInfo UserCookiesInfo = CacheCollections.GetUserCookiesInfo();
string nickName = string.Empty;
switch (UserCookiesInfo.userType)
{
case 0:
ulAdmin.Visible = true;
nickName = "老师";
if (UserCookiesInfo.teacherType != null && UserCookiesInfo.teacherType == "本院")
{
drawAdminTeacher.Visible = true;
}
break;
case 1:
case 2:
ulTeacher.Visible = true;
nickName = "老师";
DalOperationNorm dalOperationNorm = new DalOperationNorm();
DalOperationAboutUserAuth dalua = new DalOperationAboutUserAuth();
UserAuth auth = dalOperationNorm.GetUserAuth(pageName);
UserAuth salaryAuth = dalua.GetUserAuth(salaryPageName);
UserAuth projectAuth = dalua.GetUserAuth(projectPageName);
if (auth!=null&&auth.userIds != null)
{
string[] _ids = auth.userIds.Split(',');
if (_ids != null)
{
norm_right = _ids.Contains(UserCookiesInfo.userNo);
}
}
if (salaryAuth!=null&&salaryAuth.userIds != null)
{
string[] _ids = salaryAuth.userIds.Split(',');
if (_ids != null)
{
if (_ids.Contains(UserCookiesInfo.userNo))
{
salary_right = true;
}
}
}
if (projectAuth != null)
{
string projectUserIds = projectAuth.userIds;
if (!(projectUserIds == null || projectUserIds.Trim().Length == 0))
{
if (projectUserIds.Contains(UserCookiesInfo.userNo))
{
project_right = true;
}
}
}
if (UserCookiesInfo.teacherType != null && UserCookiesInfo.teacherType == "本院")
{
drawTeacher.Visible = true;
}
break;
case 3:
ulStudent.Visible = true;
nickName = "同学";
break;
default:
break;
}
user.InnerHtml = "尊敬的" + UserCookiesInfo.userName.Trim() + nickName + " 您好！";
//设置系统配置信息
//DalOperationBaseConfig dobc = new DalOperationBaseConfig();
ltlSystemVersion.Text = baseconfig.systemVersion;
this.lblCopyRight.Text = baseconfig.systemCopyRight;
//判断是否为班主任
DalOperationAboutEnglishExam dalOperationAboutEnglishExam = new DalOperationAboutEnglishExam();
if (dalOperationAboutEnglishExam.CheckIsHeadTeacherByTeacherNo(UserCookiesInfo.userNo))
{
englishExamManage.Visible = true;
}
}
pageTitle.Text = baseconfig.systemName + " 当前系统版本号：" + baseconfig.systemVersion;
}
