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(); }