protected void btnADD_Click(object sender, EventArgs e) { EasyDataProvide ModulePictures = new EasyDataProvide("ModulePictures"); FileUploadSetup fus = new FileUploadSetup(); fus.name = "picUrl"; fus.fileType = FileUploadSetup.UpfileType.Image; fus.allowNoFile = false; ThumbnailImage timg = new ThumbnailImage(); timg.suffix = "s"; timg.maxWidth = 142; timg.MaxHight = 89; fus.ThumbnailImages.Add(timg); ModulePictures.FileUploadSetups.Add(fus); try { ModulePictures.SetPageFormQuest(); } catch (Exception ex1) { lblError.Text = ex1.Message; return; } ModulePictures.AddParameter("publishID", Request["publishID"].ToString()); ModulePictures.Insert(); string Publish = "_News_Pictures.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["publishID"]; My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", Publish)); }
protected void btnADD_Click(object sender, EventArgs e) { EasyDataProvide ModuleFiles = new EasyDataProvide("ModuleFiles"); //宣告檔案上傳設定 FileUploadSetup fus = new FileUploadSetup(); fus.name = "fileUrl"; fus.fileType = FileUploadSetup.UpfileType.File; fus.allowNoFile = false; ModuleFiles.FileUploadSetups.Add(fus); try //捕抓自訂錯誤 { ModuleFiles.SetPageFormQuest(); } catch (Exception ex1) { lblError.Text = ex1.Message; return; } ModuleFiles.AddParameter("publishID", Request["publishID"].ToString()); //處理上傳檔案 if (ddlFile.SelectedValue == "檔案連結") { ModuleFiles.AddParameter("fileUrl", fileUrlPath.Text); } ModuleFiles.Insert(); string Publish = "_Discusses_Files.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["publishID"]; My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", Publish)); }
protected void Button1_Click(object sender, EventArgs e) { DataLayer dataLayer = new DataLayer(); DataRow row = dataLayer.Login(User.Identity.Name, Password.Text); if (row == null) { My.WebForm.doJavaScript("alert('密碼錯誤')"); return; } Person person = new Person(); EasyDataProvide StudentContactBookMessage = new EasyDataProvide("StudentContactBookMessage"); StudentContactBookMessage.AddParameter("studentContactBook_id", ViewState["studentContactBook_id"].ToString()); //先刪除 StudentContactBookMessage.AddParameter("studentContactBook_id", ViewState["studentContactBook_id"].ToString()); StudentContactBookMessage.Delete("studentContactBook_id=@studentContactBook_id and Role=2"); //後新增 StudentContactBookMessage.AddParameter("student_id", Request["people_id"]); StudentContactBookMessage.AddParameter("people_id", person.people_id); StudentContactBookMessage.AddParameter("Role", "2"); StudentContactBookMessage.AddParameter("article", txtArticle.Text); StudentContactBookMessage.AddParameter("contactBookDate", ViewState["date"].ToString()); StudentContactBookMessage.Insert(); EasyDataProvide StudentContactBook = new EasyDataProvide("StudentContactBook"); StudentContactBook.AddParameter("isSign", "true"); StudentContactBook.UpdateById(ViewState["studentContactBook_id"].ToString()); My.WebForm.doJavaScript(String.Format("alert('新增成功');location.href='ContactBook_ForParent.aspx?people_id={0}'", Request["people_id"])); }
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 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 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) { EasyDataProvide EmailTemplats = new EasyDataProvide("EmailTemplats"); EmailTemplats.SetPlaceHolderFormQuest(); EmailTemplats.Insert(); Response.Redirect("EmailTemplat_List.aspx?ModuleID=" + Request["ModuleID"]); }
protected void btnADD_Click(object sender, EventArgs e) { EasyDataProvide ModuleLinks = new EasyDataProvide("ModuleLinks"); ModuleLinks.SetPageFormQuest(); ModuleLinks.AddParameter("publishID", Request["publishID"].ToString()); ModuleLinks.Insert(); string Publish = "_News_Links.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["publishID"]; My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", Publish)); }
protected void Button1_Click(object sender, EventArgs e) { Person person = new Person(); EasyDataProvide TemplateMessage = new EasyDataProvide("TemplateMessage"); TemplateMessage.AddParameter("messages", messages.Text); TemplateMessage.AddParameter("people_id", person.people_id); TemplateMessage.Insert(); My.WebForm.doJavaScript("parent.tb_remove();parent.location.reload()"); }
//秀出所有學校名單(下拉式選單) /* * private void ShowSchools() { EasyDataProvide School = new EasyDataProvide("School"); DataTable dt = School.GetData("disable='False'"); school_id.DataTextField ="name"; school_id.DataValueField = "id"; school_id.DataSource = dt; school_id.DataBind(); } * */ protected void InsertButton_Click(object sender, EventArgs e) { //新增班級 EasyDataProvide grade = new EasyDataProvide("Grade"); grade.SetPlaceHolderFormQuest(); grade.AddParameter("school_id", (new Person()).School_id); grade.Insert(); My.WebForm.doJavaScript("alert('新增成功');location.href='Grade_List.aspx'"); }
protected void InsertButton_Click(object sender, EventArgs e) { EasyDataProvide courseSubject = new EasyDataProvide("CourseSubject"); courseSubject.SetPlaceHolderFormQuest(); courseSubject.AddParameter("school_id",(new Person()).School_id); courseSubject.Insert(); My.WebForm.doJavaScript("alert('新增成功');location.href='CourseSubject_List.aspx'"); }
protected void InsertButton_Click(object sender, EventArgs e) { EasyDataProvide OutputDate = new EasyDataProvide("OutputDate"); OutputDate.SetPlaceHolderFormQuest(); OutputDate.Insert(); Response.Redirect("Output_list.aspx?ModuleID=" + Request["ModuleID"]); }
protected void btnAdd_Click(object sender, EventArgs e) { EasyDataProvide ModuleClass = new EasyDataProvide("ModuleClass"); ModuleClass.AddParameter("className", txtAdd.Text); ModuleClass.AddParameter("moduleID", Request["ModuleID"]); ModuleClass.Insert(); txtAdd.Text = ""; Show(); }
protected void InsertButton_Click(object sender, EventArgs e) { EasyDataProvide InputData = new EasyDataProvide("InputData"); InputData.SetPlaceHolderFormQuest(); InputData.AddParameter("customerID", ddlCustomer.SelectedValue); InputData.AddParameter("aliasName", ddlCustomer.SelectedItem.Text); InputData.Insert(); Response.Redirect("Input_list.aspx?ModuleID=" + Request["ModuleID"]); }
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; } } _BookCase.SetPlaceHolderFormQuest(); _BookCase.UpdateById(Request["id"]); _AttachmentFile.SetPlaceHolderFormQuest(); string Path = GetMyPath(); 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)); _AttachmentFile.AddParameter("coverPicName", filePic); } _AttachmentFile.UpdateById(ViewState["file_id"].ToString()); EasyDataProvide BookCaseGrade = new EasyDataProvide("BookCaseGrade"); if (_myPerson.Role == Person.LoginRole.Teacher) { BookCaseGrade.AddParameter("bookCase_id", Request["id"]); BookCaseGrade.Delete("bookCase_id=@bookCase_id"); foreach (ListItem item in cblGrade.Items) { if (item.Selected) { BookCaseGrade.AddParameter("bookCase_id", Request["id"]); BookCaseGrade.AddParameter("grade_id", item.Value); BookCaseGrade.Insert(); } } } My.WebForm.doJavaScript("alert('修改成功');location.href='BookCase_List.aspx'"); }
protected void btnUpdate_Click(object sender, EventArgs e) { EasyDataProvide Role = new EasyDataProvide("Role"); Role.SetPlaceHolderFormQuest(); Role.AddParameter("permission", PermissionUserControl2.permissionString); Role.Insert(); Response.Redirect("Role_list.aspx?ModuleID=A02"); }
protected void InsertButton_Click(object sender, EventArgs e) { string strUserData = ((FormsIdentity)(HttpContext.Current.User.Identity)).Ticket.UserData; EasyDataProvide InputData = new EasyDataProvide("InputData"); InputData.SetPlaceHolderFormQuest(); InputData.AddParameter("customerID", User.Identity.Name); InputData.AddParameter("aliasName", strUserData); InputData.Insert(); My.WebForm.doJavaScript("alert('已送出!管理者審核中!');location='index.aspx'"); }
protected void btnAdd_Click(object sender, EventArgs e) { if (ddlCourseSubject.Items.Count > 0) { EasyDataProvide GradeCourseSubject = new EasyDataProvide("GradeCourseSubject"); GradeCourseSubject.AddParameter("courseSubject_id", ddlCourseSubject.SelectedValue); GradeCourseSubject.AddParameter("grade_id", Request["id"]); GradeCourseSubject.AddParameter("teacher_id", ddlTeacher.SelectedValue); GradeCourseSubject.Insert(); Response.Redirect(Request.Url.ToString()); } }
protected void btnReply_Click(object sender, EventArgs e) { string strUserData = ((FormsIdentity)(HttpContext.Current.User.Identity)).Ticket.UserData; EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents"); ModuleContents.AddParameter("publishID", Request["id"]); ModuleContents.AddParameter("articleTitle", strUserData); ModuleContents.AddParameter("article", txtReply.Text); ModuleContents.AddParameter("type", "1"); ModuleContents.Insert(); Response.Redirect(Request.Url.ToString()); }
protected void BtnAdd2_Click(object sender, EventArgs e) { EasyDataProvide RoleUserMapping = new EasyDataProvide("RoleUserMapping"); RoleUserMapping.AddParameter("roleID", Request["RoleID"]); foreach (GridViewRow row in GridView2.Rows) { string strID = GridView2.DataKeys[row.RowIndex].Value.ToString(); RoleUserMapping.AddParameter("userID", strID); RoleUserMapping.Insert(); } My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", "Role_Mapping.aspx?RoleID=" + Request["RoleID"])); }
protected void btnSend_Click(object sender, EventArgs e) { EasyDataProvide ParentChildren = new EasyDataProvide("ParentChildren"); foreach (GridViewRow row in GridView1.Rows) { string ID = GridView1.DataKeys[row.RowIndex].Value.ToString(); ParentChildren.AddParameter("student_id", ID); ParentChildren.AddParameter("parent_id", Request["ParentId"].ToString()); ParentChildren.Insert(); } Session["Datatable"] = null; //session 清空 My.WebForm.doJavaScript("parent.tb_remove();parent.location.reload()"); }
protected void lnkAddMyBookCase_Click(object sender, EventArgs e) { EasyDataProvide BookCase = new EasyDataProvide("BookCase"); BookCase.SetPlaceHolderFormQuest(); BookCase.AddParameter("file_id", ViewState["file_id"].ToString()); BookCase.AddParameter("school_id", _myPerson.School_id); BookCase.AddParameter("people_id", _myPerson.people_id); BookCase.AddParameter("tab_id", "9"); BookCase.AddParameter("role", _myPerson.Role == Person.LoginRole.Teacher ? "0" : "1"); BookCase.Insert(); Response.Redirect("BookCase_List.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { if (txtAdd.Text.Trim() == "") { return; } EasyDataProvide ModuleClass = new EasyDataProvide("ModuleClass"); ModuleClass.AddParameter("className", txtAdd.Text); ModuleClass.AddParameter("OrgID", Request["grade_id"]); ModuleClass.AddParameter("moduleID", Request["ModuleID"]); ModuleClass.Insert(); txtAdd.Text = ""; Show(); }
protected void btnSend_Click(object sender, EventArgs e) { EasyDataProvide GradeTeacher = new EasyDataProvide("GradeTeacher"); foreach (GridViewRow row in GridView1.Rows) { string ID = GridView1.DataKeys[row.RowIndex].Value.ToString(); GradeTeacher.AddParameter("teacher_id", ID); GradeTeacher.AddParameter("grade_id", Request["GradeId"].ToString()); DropDownList ddlClassify = (DropDownList)row.FindControl("ddlClassify"); GradeTeacher.AddParameter("classify", ddlClassify.SelectedValue); GradeTeacher.Insert(); } Session["Datatable"] = null; //session 清空 My.WebForm.doJavaScript("parent.tb_remove();parent.location.reload()"); }
protected void InsertButton_Click(object sender, EventArgs e) { Person person = new Person(); EasyDataProvide StudentContactBookMessage = new EasyDataProvide("StudentContactBookMessage"); //先刪除 StudentContactBookMessage.AddParameter("studentContactBook_id", ViewState["contactBook_id"].ToString()); StudentContactBookMessage.Delete("studentContactBook_id=@studentContactBook_id"); //後新增 StudentContactBookMessage.AddParameter("student_id", Request["people_id"]); StudentContactBookMessage.AddParameter("people_id", person.people_id); StudentContactBookMessage.AddParameter("Role", "0"); StudentContactBookMessage.AddParameter("article", article.Text); StudentContactBookMessage.AddParameter("contactBookDate", ViewState["date"].ToString()); StudentContactBookMessage.Insert(); My.WebForm.doJavaScript("alert('新增成功');location.href='ContactBook_detail.aspx'"); }
protected void btnSure_Click(object sender, EventArgs e) { EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents"); ModuleContents.AddParameter("publishID", Request["ID"]); DataRow row = ModuleContents.GetSingleRow("publishID=@publishID"); ModuleContents.SetPlaceHolderFormQuest(); if (row == null) { ModuleContents.Insert(); } else { //DataLayer.setBehaviour("�ʺA�o���t��", "�ק�" + ViewState["title"]); ModuleContents.Update("publishID=@publishID"); } Response.Redirect("_News_Files.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["ID"]); }
protected void Button1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(allName.Text)) { My.WebForm.doJavaScript("alert('您的姓名尚未填寫!');"); return; } if (string.IsNullOrEmpty(emailAddress.Text)) { My.WebForm.doJavaScript("alert('您的電子郵件尚未填寫!');"); return; } if (!My.WebForm.IsValidEmail(emailAddress.Text)) { My.WebForm.doJavaScript("alert('您的電子郵件格式有誤!');"); return; } if (string.IsNullOrEmpty(phoneNumber.Text)) { My.WebForm.doJavaScript("alert('您的聯絡電話尚未填寫!');"); return; } if (string.IsNullOrEmpty(article.Text)) { My.WebForm.doJavaScript("alert('問題或建議必填!');"); return; } if (txtVCode.Text != ViewState["Captcha"].ToString()) { My.WebForm.doJavaScript("alert('驗證碼輸入錯誤!');"); return; } ViewState["GUID"] = Guid.NewGuid().ToString(); EasyDataProvide Contact = new EasyDataProvide("Contact"); Contact.SetPlaceHolderFormQuest(); Contact.AddParameter("id", ViewState["GUID"].ToString()); Contact.AddParameter("questionClass", ddlQuestionClass.SelectedValue); Contact.Insert(); My.WebForm.doJavaScript("alert('問題已送出,感謝您的意見!');location.href='index.aspx'"); }
protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e) { //更新到資料庫 DropDownList ddlGradeCourseSubject = (DropDownList)e.Item.FindControl("ddlGradeCourseSubject"); if (ddlGradeCourseSubject.Items.Count > 0) { string id = DataList1.DataKeys[e.Item.ItemIndex].ToString(); EasyDataProvide TimeTable = new EasyDataProvide("TimeTable"); TimeTable.AddParameter("grade_id", Request["id"]); TimeTable.AddParameter("sectionIndex_id", id); TimeTable.Delete("grade_id=@grade_id and sectionIndex_id=@sectionIndex_id"); TimeTable.AddParameter("gradeCourseSubject_id", ddlGradeCourseSubject.SelectedValue); TimeTable.Insert(); } DataList1.EditItemIndex = -1; Show(); }
protected void btnADD_Click(object sender, EventArgs e) { EasyDataProvide ModuleFiles = new EasyDataProvide("ModuleFiles"); //宣告檔案上傳設定 FileUploadSetup fus = new FileUploadSetup(); fus.name = "fileUrl"; fus.fileType = FileUploadSetup.UpfileType.File; fus.allowNoFile = false; ModuleFiles.FileUploadSetups.Add(fus); try //捕抓自訂錯誤 { ModuleFiles.SetPageFormQuest(); } catch (Exception ex1) { lblError.Text = ex1.Message; return; } ModuleFiles.AddParameter("publishID", Request["publishID"].ToString()); //處理上傳檔案 if (ddlFile.SelectedValue == "檔案連結") { ModuleFiles.AddParameter("fileUrl", fileUrlPath.Text); } ModuleFiles.Insert(); string Publish = "_News_Files.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["publishID"]; My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", Publish)); }
protected void btnADD_Click(object sender, EventArgs e) { EasyDataProvide ModulePictures = new EasyDataProvide("ModulePictures"); ModulePictures.SetPageFormQuest(); //處理上傳圖片 if (fuPic.HasFile) { if (fuPic.PostedFile.ContentType.IndexOf("image") == -1) { My.WebForm.doJavaScript("alert('檔案型態錯誤!');"); return; } //取得副檔名 string Extension = fuPic.FileName.Split('.')[fuPic.FileName.Split('.').Length - 1]; //新檔案名稱 string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fuPic.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Images/{0}", fileName))); ModulePictures.AddParameter("picUrl", fileName); //產生縮圖 My.WebForm.GenerateThumbnailImage(fileName, fuPic.PostedFile.InputStream, Server.MapPath("~/UploadFiles/Images/"), "S", 142, 89); } else { My.WebForm.doJavaScript("alert('沒有上傳檔案');"); return; } ModulePictures.AddParameter("publishID", Request["publishID"].ToString()); ModulePictures.Insert(); string Publish = "_News_Pictures.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + Request["publishID"]; My.WebForm.doJavaScript(String.Format("parent.tb_remove();parent.location='{0}';", Publish)); }
protected void InsertButton_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(article.Text)) { My.WebForm.doJavaScript("alert('詳細說明不可以空白.');"); return; } DateTime d = DateTime.Now; EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish"); ModulePublish.SetPlaceHolderFormQuest(); ModulePublish.AddParameter("id", ViewState["GUID"].ToString()); ModulePublish.AddParameter("moduleID", "N02"); ModulePublish.AddParameter("startDate", d.ToString()); ModulePublish.AddParameter("endDate", "2800/1/1"); string strUserData = ((FormsIdentity)(HttpContext.Current.User.Identity)).Ticket.UserData; ModulePublish.AddParameter("poster", strUserData); ModulePublish.Insert(); EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents"); ModuleContents.AddParameter("publishID", ViewState["GUID"].ToString()); ModuleContents.AddParameter("article", article.Text); ModuleContents.Insert(); EasyDataProvide ModuleFiles = new EasyDataProvide("ModuleFiles"); //取得副檔名 if (fileUrl.HasFile) { string Extension = fileUrl.FileName.Split('.')[fileUrl.FileName.Split('.').Length - 1]; //新檔案名稱 string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fileUrl.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Files/{0}", fileName))); ModuleFiles.AddParameter("fileUrl", fileName); ModuleFiles.AddParameter("fileName", "點我下載"); ModuleFiles.AddParameter("publishID", ViewState["GUID"].ToString()); //處理上傳檔案 if (ddlFile.SelectedValue == "檔案連結") { ModuleFiles.AddParameter("fileUrl", fileUrlPath.Text); } ModuleFiles.Insert(); } else if (fileUrlPath.Text != "") { ModuleFiles.AddParameter("fileName", "點我下載"); ModuleFiles.AddParameter("publishID", ViewState["GUID"].ToString()); //處理上傳檔案 if (ddlFile.SelectedValue == "檔案連結") { ModuleFiles.AddParameter("fileUrl", fileUrlPath.Text); } ModuleFiles.Insert(); } if (chkAlert.Checked) { EasyDataProvide Customer = new EasyDataProvide("Customer"); DataTable dtCustomer = Customer.GetData("emailAddress IS NOT NULL AND emailAddress<>''"); string subject = "【雲施團分享】" + title.Text; string mailBody = article.Text.Replace(@"/UploadFiles/", ConfigurationManager.AppSettings["ServerHost"] + @"/UploadFiles/"); mailBody += "<br />發表人:" + strUserData + "|發表日期:" + d.ToShortDateString(); mailBody += "<br /><br />文章出處:<a href='" + ConfigurationManager.AppSettings["ServerHost"] + "MemberNews_Detail.aspx?id=" + ViewState["GUID"].ToString() + "'>" + ConfigurationManager.AppSettings["ServerHost"] + "MemberNews_Detail.aspx?id=" + ViewState["GUID"].ToString() + "</a>"; foreach (DataRow row in dtCustomer.Rows) { My.WebForm.SystemSendMailCC("*****@*****.**", row["emailAddress"].ToString(), subject, mailBody); } } Response.Redirect("index.aspx"); }
protected void InsertButton_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(article.Text)) { My.WebForm.doJavaScript("alert('�Բӻ������i�H�ť�.');"); return; } if (shortDescription.Text.Length >= 500) { My.WebForm.doJavaScript("alert('²�满�����i�H�W�L500�Ӧr.');"); return; } Person person = new Person(); EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish"); ModulePublish.SetPlaceHolderFormQuest(); //�B�z�W���ɮ� if (ddlFile.SelectedValue == "�ɮפW��" && fuFile.HasFile) { //���o���ɦW string Extension = fuFile.FileName.Split('.')[fuFile.FileName.Split('.').Length - 1]; //�s�ɮצW�� string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fuFile.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Files/{0}", fileName))); ModulePublish.AddParameter("fileUrl", fileName); } //�B�z�W�ǹϤ� if (fuPic.HasFile) { if (fuPic.PostedFile.ContentType.IndexOf("image") == -1) { My.WebForm.doJavaScript("alert('�ɮ��A���~!');"); return; } //���o���ɦW string Extension = fuPic.FileName.Split('.')[fuPic.FileName.Split('.').Length - 1]; //�s�ɮצW�� string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fuPic.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Images/{0}", fileName))); ModulePublish.AddParameter("picUrl", fileName); } ModulePublish.AddParameter("id", ViewState["GUID"].ToString()); ModulePublish.AddParameter("moduleID", Request["ModuleID"]); ModulePublish.AddParameter("OrgID", person.School_id); //ModulePublish.AddParameter("OrgNames", ddlOrg.SelectedItem.Text); ModulePublish.AddParameter("classID", ddlClass1.SelectedValue); ModulePublish.AddParameter("poster", person.people_id); //�������ɡA�]�w�@��800�~�᪺��� if (string.IsNullOrEmpty(endDate.Text)) { ModulePublish.AddParameter("endDate", "2800/1/1"); } //if (DataLayer.IsInRole("admins", HttpContext.Current.User.Identity.Name)) //{ // ModulePublish.addParameter("beSelect", "1"); //admin �s�յo�G�� //} ModulePublish.Insert(); EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents"); ModuleContents.AddParameter("publishID", ViewState["GUID"].ToString()); ModuleContents.AddParameter("article", article.Text); ModuleContents.Insert(); Session[Request["ModuleID"] + "ddlOrg"] = ddlOrg.SelectedValue; Session[Request["ModuleID"] + "Class1"] = ddlClass1.SelectedValue; Response.Redirect("News_List.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + ViewState["GUID"]); }
protected void InsertButton_Click(object sender, EventArgs e) { Person person = new Person(); EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish"); ModulePublish.SetPlaceHolderFormQuest(); //處理上傳檔案 if (ddlFile.SelectedValue == "檔案上傳" && fuFile.HasFile) { //取得副檔名 string Extension = fuFile.FileName.Split('.')[fuFile.FileName.Split('.').Length - 1]; //新檔案名稱 string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fuFile.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Files/{0}", fileName))); ModulePublish.AddParameter("fileUrl", fileName); } //處理上傳圖片 if (fuPic.HasFile) { if (fuPic.PostedFile.ContentType.IndexOf("image") == -1) { My.WebForm.doJavaScript("alert('檔案型態錯誤!');"); return; } //取得副檔名 string Extension = fuPic.FileName.Split('.')[fuPic.FileName.Split('.').Length - 1]; //新檔案名稱 string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fuPic.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Images/{0}", fileName))); My.WebForm.GenerateThumbnailImage(fileName, fuPic.PostedFile.InputStream, Server.MapPath("~/UploadFiles/Images"), "S", 69, 50); ModulePublish.AddParameter("picUrl", fileName); } ModulePublish.AddParameter("id", ViewState["GUID"].ToString()); ModulePublish.AddParameter("moduleID", Request["ModuleID"]); ModulePublish.AddParameter("OrgID", Request["grade_id"]); //ModulePublish.AddParameter("OrgNames", ddlOrg.SelectedItem.Text); ModulePublish.AddParameter("classID", ddlClass1.SelectedValue); ModulePublish.AddParameter("poster", person.people_id); //不填結束日期時,設定一個800年後的日期 if (string.IsNullOrEmpty(endDate.Text)) { ModulePublish.AddParameter("endDate", "2800/1/1"); } //if (DataLayer.IsInRole("admins", HttpContext.Current.User.Identity.Name)) //{ // ModulePublish.addParameter("beSelect", "1"); //admin 群組發佈的 //} ModulePublish.Insert(); //EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents"); //ModuleContents.AddParameter("publishID", ViewState["GUID"].ToString()); //ModuleContents.AddParameter("article", article.Text); //ModuleContents.Insert(); Session[Request["ModuleID"] + "Class1"] = ddlClass1.SelectedValue; Response.Redirect("Discusses_List.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + ViewState["GUID"] + "&grade_id=" + Request["grade_id"]); }
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(); }
protected void InsertButton_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(article.Text)) { My.WebForm.doJavaScript("alert('詳細說明不可以空白.');"); return; } //if (shortDescription.Text.Length >= 500) //{ // My.WebForm.doJavaScript("alert('簡單說明不可以超過500個字.');"); // return; //} EasyDataProvide ModulePublish = new EasyDataProvide("ModulePublish"); ModulePublish.SetPlaceHolderFormQuest(); //處理上傳檔案 if (ddlFile.SelectedValue == "檔案上傳" && fuFile.HasFile) { //取得副檔名 string Extension = fuFile.FileName.Split('.')[fuFile.FileName.Split('.').Length - 1]; //新檔案名稱 string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fuFile.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Files/{0}", fileName))); ModulePublish.AddParameter("fileUrl", fileName); } //處理上傳圖片 if (fuPic.HasFile) { if (fuPic.PostedFile.ContentType.IndexOf("image") == -1) { My.WebForm.doJavaScript("alert('檔案型態錯誤!');"); return; } //取得副檔名 string Extension = fuPic.FileName.Split('.')[fuPic.FileName.Split('.').Length - 1]; //新檔案名稱 string fileName = String.Format("{0:yyyyMMddhhmmsss}.{1}", DateTime.Now, Extension); fuPic.SaveAs(Server.MapPath(String.Format("~/UploadFiles/Images/{0}", fileName))); My.WebForm.GenerateThumbnailImage(fileName, fuPic.PostedFile.InputStream, Server.MapPath("~/UploadFiles/Images/"), "S", 127, 127); ModulePublish.AddParameter("picUrl", fileName); } ModulePublish.AddParameter("id", ViewState["GUID"].ToString()); ModulePublish.AddParameter("moduleID", Request["ModuleID"]); ModulePublish.AddParameter("OrgID", ddlOrg.SelectedValue); ModulePublish.AddParameter("OrgNames", ddlOrg.SelectedItem.Text); ModulePublish.AddParameter("classID", ddlClass1.SelectedValue); Person person = new Person(); ModulePublish.AddParameter("poster", person.name); ModulePublish.AddParameter("posterUnit", person.organization); ModulePublish.AddParameter("updater", person.name); ModulePublish.AddParameter("updaterUnit", person.organization); //不填結束日期時,設定一個800年後的日期 if (string.IsNullOrEmpty(endDate.Text)) { ModulePublish.AddParameter("endDate", "2800/1/1"); } if (initDate.Text == DateTime.Now.ToString("yyyy/MM/dd")) { DateTime d = DateTime.Now; ModulePublish.AddParameter("initDate", d.ToString()); ModulePublish.AddParameter("lastupdated", d.ToString()); } else { ModulePublish.AddParameter("lastupdated", initDate.Text); } //if (DataLayer.IsInRole("admins", HttpContext.Current.User.Identity.Name)) //{ // ModulePublish.addParameter("beSelect", "1"); //admin 群組發佈的 //} ModulePublish.Insert(); EasyDataProvide ModuleContents = new EasyDataProvide("ModuleContents"); ModuleContents.AddParameter("publishID", ViewState["GUID"].ToString()); ModuleContents.AddParameter("article", article.Text); ModuleContents.Insert(); if (chkAlert.Checked) { EasyDataProvide Customer = new EasyDataProvide("Customer"); DataTable dtCustomer = Customer.GetData("emailAddress IS NOT NULL AND emailAddress<>''"); string subject = "【雲施團分享】" + title.Text; string mailBody = article.Text.Replace(@"/UploadFiles/", ConfigurationManager.AppSettings["ServerHost"] + @"/UploadFiles/"); mailBody += "<br />發表人:團長|發表日期:" + DateTime.Now.ToShortDateString(); mailBody += "<br /><br />文章網址:<a href='" + ConfigurationManager.AppSettings["ServerHost"] + "News_Detail.aspx?id=" + ViewState["GUID"].ToString() + "'>" + ConfigurationManager.AppSettings["ServerHost"] + "News_Detail.aspx?id=" + ViewState["GUID"].ToString() + "</a>"; //My.WebForm.SystemSendMailCC("*****@*****.**", "*****@*****.**", subject, mailBody); foreach (DataRow row in dtCustomer.Rows) { My.WebForm.SystemSendMailCC("*****@*****.**", row["emailAddress"].ToString(), subject, mailBody); } } Session[Request["ModuleID"] + "ddlOrg"] = ddlOrg.SelectedValue; Session[Request["ModuleID"] + "Class1"] = ddlClass1.SelectedValue; Response.Redirect("_News_Files.aspx?ModuleID=" + Request["ModuleID"] + "&ID=" + ViewState["GUID"]); }