protected void InsertButton_Click(object sender, EventArgs e)
{
EasyDataProvide ContactBook = new EasyDataProvide("ContactBook");
ContactBook.AddParameter("date", date.Text);
ContactBook.AddParameter("grade_id", grade_id.SelectedValue);
int i = ContactBook.GetRowCount("date=@date and grade_id=@grade_id");
if (i > 0)
{
My.WebForm.doJavaScript("alert('該日該班級以建立聯絡簿，請重新選擇！');");
return;
}
ContactBook.AddParameter("description", description.Text);
string ContactBook_id= ContactBook.InsertReturnValue();
EasyDataProvide GradeStudent = new EasyDataProvide("GradeStudent");
GradeStudent.AddParameter("grade_id",grade_id.SelectedValue);
DataTable dtStudent = GradeStudent.GetData("grade_id=@grade_id");
EasyDataProvide StudentContactBook = new EasyDataProvide("StudentContactBook");
foreach (DataRow row in dtStudent.Rows)
{
StudentContactBook.AddParameter("people_id", row["student_id"].ToString());
StudentContactBook.AddParameter("contactBook_id", ContactBook_id);
StudentContactBook.Insert();
}
My.WebForm.doJavaScript("alert('新增成功');location.href='ContactBook_detail.aspx'");
}
protected void InsertButton_Click(object sender, EventArgs e)
{
EasyDataProvide Member = new EasyDataProvide("Member");
Member.SetPlaceHolderFormQuest();
DataRow dataRow = Member.GetSingleRow("account=@account");
if (dataRow != null)
{
My.WebForm.doJavaScript("alert('帳號已使用!');");
return;
}
Member.AddParameter("password", FormsAuthentication.HashPasswordForStoringInConfigFile(password.Text, "MD5"));
string premissionString = PermissionUserControl1.permissionString;
Member.AddParameter("Permission", premissionString);
string userID = Member.InsertReturnValue();
if (ddlRole.Items.Count > 0)
{
EasyDataProvide RoleUserMapping = new EasyDataProvide("RoleUserMapping");
RoleUserMapping.AddParameter("roleID", ddlRole.SelectedValue);
RoleUserMapping.AddParameter("userID", userID);
RoleUserMapping.Insert();
}
Response.Redirect("Account_list.aspx?ModuleID=" + Request["ModuleID"]);
}
protected void InsertButton_Click(object sender, EventArgs e)
{
//新增地址
EasyDataProvide Address = new EasyDataProvide("Address");
Address.AddParameter("city", Request["city"]);
Address.AddParameter("division", Request["division"]);
Address.AddParameter("zip", Request["zip"]);
Address.AddParameter("address", address.Value);
string addressID = Address.InsertReturnValue();
//新增電話
EasyDataProvide Telepone = new EasyDataProvide("Telephone");
Telepone.AddParameter("areaCode", areaCode.Value);
Telepone.AddParameter("numberCode", numberCode.Value);
string telephoneID = Telepone.InsertReturnValue();
//新增學校
EasyDataProvide school = new EasyDataProvide("School");
school.AddParameter("id",id.Text);
int i = school.GetRowCount("id=@id");
if(i>0)
{
My.WebForm.doJavaScript("alert('學校編號已經重複!')");
return;
}
school.RemoveParameter("id");
school.SetPlaceHolderFormQuest();
school.AddParameter("address_id", addressID);
school.AddParameter("telephone_id", telephoneID);
school.Insert();
My.WebForm.doJavaScript("alert('新增成功');location.href='School_List.aspx'");
}
protected void InsertButton_Click(object sender, EventArgs e)
{
//檢查帳號是否重複
EasyDataProvide Account = new EasyDataProvide("Account");
Account.AddParameter("username", username.Text);
DataRow rowCheck = Account.GetSingleRow("username=@username");
if (rowCheck != null)
{
My.WebForm.doJavaScript("alert('帳號已經存在')");
return;
}
string peopleId = Guid.NewGuid().ToString();
//新增地址
EasyDataProvide Address = new EasyDataProvide("Address");
Address.AddParameter("city", Request["city"]);
Address.AddParameter("division", Request["division"]);
Address.AddParameter("zip", Request["zip"]);
Address.AddParameter("address", address.Value);
string addressID = Address.InsertReturnValue();
//新增電話
EasyDataProvide Telepone = new EasyDataProvide("Telephone");
Telepone.AddParameter("areaCode", areaCode.Value);
Telepone.AddParameter("numberCode", numberCode.Value);
string telephoneID = Telepone.InsertReturnValue();
//新增Pepole
EasyDataProvide People = new EasyDataProvide("People");
People.SetPlaceHolderFormQuest();
People.AddParameter("id", peopleId);
People.AddParameter("address_id", addressID);
People.AddParameter("telephone_id", telephoneID);
People.AddParameter("role", "2");
People.Insert();
//新增Parent
EasyDataProvide Parent = new EasyDataProvide("Parent");
Parent.AddParameter("id", peopleId);
Parent.SetPlaceHolderFormQuest();
Parent.Insert();
//新增People_School
EasyDataProvide People_School = new EasyDataProvide("People_School");
People_School.AddParameter("people_id", peopleId);
People_School.AddParameter("school_id", (new Person()).School_id);
People_School.Insert();
//新增帳號
Account.AddParameter("password", FormsAuthentication.HashPasswordForStoringInConfigFile(password.Text, "MD5"));
Account.AddParameter("emailAddress", emailAddress.Text);
Account.AddParameter("people_id", peopleId);
Account.AddParameter("id", Guid.NewGuid().ToString());
Account.Insert();
My.WebForm.doJavaScript("alert('新增成功');location.href='Parent_List.aspx'");
}
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'");
}
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();
}