/// <summary>
/// 班級年級、名稱、ID、座號
/// </summary>
public DStudent(string peopleId)
: base(peopleId)
{
EasyDataProvide gradeStudent = new EasyDataProvide("GradeStudent");
gradeStudent.AddParameter("student_id", peopleId);
DataRow gradeStudentRow = gradeStudent.GetSingleRow("student_id=@student_id");
if (gradeStudentRow != null)
{
_gradeID = gradeStudentRow["grade_id"].ToString();
EasyDataProvide Grade = new EasyDataProvide("Grade");
DataRow gradeRow = Grade.GetById(gradeStudentRow["grade_id"].ToString());
if (gradeRow == null) return;
_currentYear = gradeRow["currentYear"].ToString();
_gradeName = gradeRow["name"].ToString();
}
if (gradeStudentRow != null) _seatNumber = gradeStudentRow["seatNumber"].ToString();
EasyDataProvide student = new EasyDataProvide("Student");
student.AddParameter("id", peopleId);
DataRow studentRow = student.GetSingleRow("id=@id");
if (studentRow != null)
{
_studentNumber = studentRow["studentNumber"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//驗證身份
Person myPerson = new Person();
if (myPerson.Role == Person.LoginRole.Teacher || myPerson.Role == Person.LoginRole.Student || myPerson.Role == Person.LoginRole.Parent)
{
Response.Redirect("~/Default.aspx");
}
if (myPerson.Role == Person.LoginRole.SchoolAdmin)
{
PublishTab1.isOpenEditTab = true;
//addPan.Visible = true;
gvList.Columns[gvList.Columns.Count - 1].Visible = true;
EasyDataProvide Grade = new EasyDataProvide("Grade");
DataRow row = Grade.GetById(Request["id"]);
if (row == null) return;
ViewState["currentYear"] = row["currentYear"].ToString();
ShowTeacher();
ShowCourseSubject();
}
Show();
}
}
private void Show()
{
DataTable dt = dl.GetStudentList((new Person()).School_id, "-1", "", "", "-1", "-1", Request["ID"], "", "order by StudentNumber asc", 70, 1);
gvList.DataSource = dt;
gvList.DataBind();
EasyDataProvide People = new EasyDataProvide("People");
DataRow row = People.GetById(Request["id"]);
ParentName.Text = row["name"].ToString();
}
private void Show()
{
DataTable dt = dl.GetTeacherByGradeID(Request["id"]);
gvList.DataSource = dt;
gvList.DataBind();
EasyDataProvide Grade = new EasyDataProvide("Grade");
DataRow row = Grade.GetById(Request["ID"]);
DGrade dGrade = new DGrade();
AllName.Text = dGrade.GetFullGradeNameById((int)row["id"]);
}
protected void Show()
{
EasyDataProvide Grade = new EasyDataProvide("Grade");
DataRow row = Grade.GetById(Request["ID"]);
if(row==null) return;
DataTable dt = dl.GetStudentList(row["school_id"].ToString(), Request["ID"], "", "", "-1", "-1", "-1", "", "order by SeatNumber asc", 70, 1);
gvList.DataSource = dt;
gvList.DataBind();
DGrade dGrade = new DGrade();
AllName.Text = dGrade.GetFullGradeNameById((int)row["id"]);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
show();
EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish");
DataRow row = ModulePublish.GetById(Request["ID"].ToString());
//if (!DataLayer.IsInRole("admins", User.Identity.Name))
//{
// if (row["beSelect"].ToString() != "0") //���O�ۤv�o�G��
// {
// btnSure.Visible = false;
// }
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
show();
EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish");
DataRow row = ModulePublish.GetById(Request["ID"].ToString());
//if (!DataLayer.IsInRole("admins", User.Identity.Name))
//{
// if (row["beSelect"].ToString() != "0") //不是自己發佈的
// {
// btnSure.Visible = false;
// }
//}
}
}
protected void InsertButton_Click(object sender, EventArgs e)
{
if (_myPerson.Role == Person.LoginRole.Teacher)
{
bool flag = false;
foreach (ListItem item in cblGrade.Items)
{
if (item.Selected)
{
flag = true;
}
}
if (!flag)
{
My.WebForm.doJavaScript("alert('請選擇班級！！')");
return;
}
}
EasyDataProvide AttachmentFile = new EasyDataProvide("AttachmentFile");
EasyDataProvide BookCase = new EasyDataProvide("BookCase");
AttachmentFile.SetPlaceHolderFormQuest();
//取得副檔名
string Path = GetMyPath();
if (!fuFile.HasFile)
{
My.WebForm.doJavaScript("alert('請上傳檔案')");
return;
}
string Extension = fuFile.FileName.Split('.')[fuFile.FileName.Split('.').Length - 1];
//新檔案名稱
string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension);
fuFile.SaveAs(String.Format("{0}/{1}", Path, fileName));
string filePic = "";
if (fuPic.HasFile)
{
string PicExtension = fuPic.FileName.Split('.')[fuPic.FileName.Split('.').Length - 1];
//新檔案名稱
filePic = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, PicExtension);
fuPic.SaveAs(String.Format("{0}/{1}", Path, filePic));
My.WebForm.GenerateThumbnailImage(filePic, fuPic.PostedFile.InputStream, Path, "S", 86, 69);
AttachmentFile.AddParameter("coverPicName", filePic);
}
AttachmentFile.AddParameter("fileName", fileName);
AttachmentFile.AddParameter("extension", Extension);
AttachmentFile.AddParameter("school_id", _myPerson.School_id);
AttachmentFile.AddParameter("people_id", _myPerson.people_id);
EasyDataProvide School = new EasyDataProvide("School");
DataRow row = School.GetById(_myPerson.School_id);
string domainName = "";
if (row != null)
{
domainName = row["domainName"].ToString();
}
AttachmentFile.AddParameter("domainName", domainName);
string file_id = AttachmentFile.InsertReturnValue();
BookCase.SetPlaceHolderFormQuest();
BookCase.AddParameter("file_id", file_id);
BookCase.AddParameter("school_id", _myPerson.School_id);
BookCase.AddParameter("people_id", _myPerson.people_id);
BookCase.AddParameter("role", _myPerson.Role == Person.LoginRole.Teacher ? "0" : "1");
string BookCaseID = BookCase.InsertReturnValue();
EasyDataProvide BookCaseGrade = new EasyDataProvide("BookCaseGrade");
if (_myPerson.Role == Person.LoginRole.Teacher)
{
foreach (ListItem item in cblGrade.Items)
{
if (item.Selected)
{
BookCaseGrade.AddParameter("bookCase_id", BookCaseID);
BookCaseGrade.AddParameter("grade_id", item.Value);
BookCaseGrade.Insert();
}
}
}
else
{
DStudent dStudent=new DStudent(_myPerson.people_id);
BookCaseGrade.AddParameter("bookCase_id", BookCaseID);
BookCaseGrade.AddParameter("grade_id", dStudent.GradeID);
BookCaseGrade.Insert();
}
My.WebForm.doJavaScript("alert('新增成功');location.href='BookCase_List.aspx'");
}
private void Show()
{
EasyDataProvide ParentChildren = new EasyDataProvide("ParentChildren");
ParentChildren.AddParameter("student_id",Request["id"]);
DataRow pcRow = ParentChildren.GetSingleRow("student_id=@student_id");
if(pcRow==null)
{
Panel2.Visible = true;
Panel1.Visible = false;
return;
}else
{
Panel1.Visible = true;
Panel2.Visible = false;
}
DataRow row = _people.FillPlaceHolderControlsById(pcRow["parent_id"].ToString());
if (row == null) return;
myPhoto.ImageUrl = row["myPhoto"].ToString() == "" ? (row["gender"].ToString() == "True" ? "~/images/Male90x85.jpg" : "~/images/FeMale90x85.jpg") : String.Format("{0}/{1}/{2}/M{3}", ConfigurationManager.AppSettings["FileUploadPath"], (new Person()).School_id, row["id"], row["myPhoto"]);
gender.Text = SCode.ToScodeGenderName(gender.Text);
DParent dParent = new DParent(pcRow["parent_id"].ToString());
telephone_id.Text = dParent.Phone;
address_id.Text = dParent.Address;
occupation.Text = dParent.Occupation;
username.Text = dParent.Account;
emailAddress.Text = dParent.Email;
schoolName.Text = dParent.SchoolName;
enable.Text = enable.Text.ToScodeEnableName();
description.Text = My.WebForm.TXT2HTML(description.Text);
EasyDataProvide people = new EasyDataProvide("People");
DataRow peoplwRow = people.GetById(Request["id"]);
StudentName.Text = peoplwRow["name"].ToString();
}
protected void BtnUpFile1_Click1(object sender, EventArgs e)
{
if (ViewState["exist"].ToString() == "False")
{
My.WebForm.doJavaScript("alert('請先輸入課程備註、重要事項或備課事項');");
return;
}
EasyDataProvide TimeTable = new EasyDataProvide("TimeTable");
DataRow rowTime = TimeTable.GetById(Request["timetable_id"]);
if(rowTime==null)
{
My.WebForm.doJavaScript("備課資料有誤！");
return;
}
string grade_id = rowTime["grade_id"].ToString();
Person myPerson = new Person();
EasyDataProvide AttachmentFile = new EasyDataProvide("AttachmentFile");
AttachmentFile.SetPlaceHolderFormQuest();
//取得副檔名
string Path = GetMyPath();
if (!FuFile1.HasFile)
{
My.WebForm.doJavaScript("alert('請上傳檔案')");
return;
}
string Extension = FuFile1.FileName.Split('.')[FuFile1.FileName.Split('.').Length - 1];
//新檔案名稱
string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension);
FuFile1.SaveAs(String.Format("{0}/{1}", Path, fileName));
AttachmentFile.AddParameter("fileName", fileName);
AttachmentFile.AddParameter("extension", Extension);
AttachmentFile.AddParameter("school_id", myPerson.School_id);
AttachmentFile.AddParameter("people_id", myPerson.people_id);
EasyDataProvide School = new EasyDataProvide("School");
DataRow row = School.GetById(myPerson.School_id);
string domainName = "";
if (row != null)
{
domainName = row["domainName"].ToString();
}
AttachmentFile.AddParameter("domainName", domainName);
string file_id = AttachmentFile.InsertReturnValue();
EasyDataProvide PrepareLessonFile = new EasyDataProvide("PrepareLessonFile");
PrepareLessonFile.AddParameter("type", "0");
PrepareLessonFile.AddParameter("prepareLesson_id", ViewState["ID"].ToString());
PrepareLessonFile.AddParameter("file_id", file_id);
PrepareLessonFile.AddParameter("initDate", DateTime.Now.ToShortDateString());
PrepareLessonFile.AddParameter("poster", myPerson.account);
PrepareLessonFile.Insert();
EasyDataProvide BookCase = new EasyDataProvide("BookCase");
BookCase.SetPlaceHolderFormQuest();
BookCase.AddParameter("file_id", file_id);
BookCase.AddParameter("school_id", myPerson.School_id);
BookCase.AddParameter("people_id", myPerson.people_id);
BookCase.AddParameter("role", myPerson.Role == Person.LoginRole.Teacher ? "0" : "1");
string BookCaseID = BookCase.InsertReturnValue();
EasyDataProvide BookCaseGrade = new EasyDataProvide("BookCaseGrade");
BookCaseGrade.AddParameter("bookCase_id", BookCaseID);
BookCaseGrade.AddParameter("grade_id", grade_id);
BookCaseGrade.AddParameter("tab_id", "7");
BookCaseGrade.Insert();
ShowFile1();
}
public DataRow GetBaseRow()
{
EasyDataProvide People = new EasyDataProvide("People");
DataRow row = People.GetById(_pepoleID);
return row;
}