public void Execute() { exportProxyForm = new ExportProxyForm(); exportProxyForm.InvisibleFields = new List<string>() { "畢業學年期", "異動代碼" }; exportProxyForm.QuerySQL = this.SetQueryString(); exportProxyForm.AutoSaveFile = false; exportProxyForm.AutoSaveLog = true; exportProxyForm.KeyField = "學生系統編號"; //Dictionary<string, List<KeyValuePair<string, string>>> dicReplaceFields = new Dictionary<string, List<KeyValuePair<string, string>>>(); //dicReplaceFields.Add("現職", new List<KeyValuePair<string, string>>()); //dicReplaceFields["現職"].Add(new KeyValuePair<string, string>("true", "是")); //dicReplaceFields["現職"].Add(new KeyValuePair<string, string>("false", "否")); exportProxyForm.ReplaceFields = null; exportProxyForm.Text = "匯出學生基本資料"; //exportProxyForm.HideSemesterControls(); DialogResult dr = exportProxyForm.ShowDialog(); if (dr == DialogResult.Cancel) return; if (dr == DialogResult.OK) { BackgroundWorker _BGWLoadData = exportProxyForm.SalvageOperation; _BGWLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_BGWLoadData_RunWorkerCompleted); } }
public void Execute() { exportProxyForm = new ExportProxyForm(); exportProxyForm.AutoSaveFile = false; exportProxyForm.AutoSaveLog = true; exportProxyForm.KeyField = "學生繳費記錄系統編號"; exportProxyForm.InvisibleFields = new List<string>() { "學生繳費記錄系統編號" }; exportProxyForm.ReplaceFields = null; exportProxyForm.QuerySQL = this.SetQueryString(); exportProxyForm.Text = "匯出學生繳費記錄"; //exportProxyForm.HideSemesterControls(); exportProxyForm.FieldContainer.Enabled = false; exportProxyForm.chkSelectAll.Visible = false; DialogResult dr = exportProxyForm.ShowDialog(); if (dr == DialogResult.Cancel) return; if (dr == DialogResult.OK) { BackgroundWorker _BGWLoadData = exportProxyForm.SalvageOperation; _BGWLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_BGWLoadData_RunWorkerCompleted); } }
public void Execute() { string querySQL = string.Format(@"select course.id as 課程系統編號, subject.dept_code as 系所代碼, ce.subject_code as 課程識別碼, ce.class_name as 開課班次, course.credit as 學分數, ce.is_required as 必選修, course.course_name as 開課, subject.eng_name as 課程英文名稱, te.employee_no as 員工代碼, te.ntu_system_no as 教師代碼, teacher.teacher_name as 授課教師, te.english_name as 授課教師英文名稱, subject.remark as 備註, ce.new_subject_code as 課號, teacher.id as 教師系統編號 from course left join $ischool.emba.course_ext as ce on ce.ref_course_id=course.id left join $ischool.emba.subject as subject on subject.uid= ce.ref_subject_id left join $ischool.emba.course_instructor as ci on course.id=ci.ref_course_id left join teacher on teacher.id=ci.ref_teacher_id left join $ischool.emba.teacher_ext as te on teacher.id=te.ref_teacher_id where course.id in ({0}) order by course.id", String.Join(",", K12.Presentation.NLDPanels.Course.SelectedSource)); exportProxyForm = new ExportProxyForm(querySQL, true, false, "課程系統編號", new List<string>() { "課程系統編號", "教師系統編號" }, null); //exportProxyForm.HideSemesterControls(); exportProxyForm.Text = "匯出課程檔(Excel 格式)"; exportProxyForm.lblExplanation.Text = ""; exportProxyForm.chkSelectAll.Visible = false; exportProxyForm.FieldContainer.Enabled = false; exportProxyForm.FieldContainer.Items.Clear(); exportProxyForm.chkSelectAll.Visible = false; exportProxyForm.Size = new System.Drawing.Size(exportProxyForm.Size.Width, 90); exportProxyForm.SizeChanged += (x, y) => { exportProxyForm.Size = new System.Drawing.Size(exportProxyForm.Size.Width, 90); }; DialogResult dr = exportProxyForm.ShowDialog(); if (dr == DialogResult.Cancel) return; if (dr == DialogResult.OK) { BackgroundWorker _BGWLoadData = exportProxyForm.SalvageOperation; _BGWLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_BGWLoadData_RunWorkerCompleted); } }
public void Execute() { string querySQL = string.Format(@"select student.id as 學生系統編號, class.class_name as 教學分班, student.student_number as 學號, student.name as 姓名, eb.school_name as 學校名稱, eb.department as 系所, eb.degree as 學位 from student left join $ischool.emba.education_background as eb on eb.ref_student_id=student.id left join class on class.id=student.ref_class_id where student.id in ({0})", String.Join(",", K12.Presentation.NLDPanels.Student.SelectedSource)); exportProxyForm = new ExportProxyForm(querySQL, true, true, "學生系統編號", null, null); //exportProxyForm.HideSemesterControls(); exportProxyForm.Text = "匯出學生學歷資料"; exportProxyForm.Tag = exportProxyForm.Text; exportProxyForm.ShowDialog(); this.Dispose(); }
public void Execute() { string querySQL = string.Format(@"select student.id as 學生系統編號, class.class_name as 教學分班, student.student_number as 學號, student.name as 姓名, ex.company_name as 公司名稱, ex.position as 職稱, ex.industry as 產業別, ex.department_category as 部門類別, ex.post_level as 層級別, ex.work_place as 工作地點, ex.work_status as 工作狀態, date_part('year', ex.work_begin_date) || '/' || date_part('month', ex.work_begin_date) || '/' || date_part('day', ex.work_begin_date) as 工作起日, date_part('year', ex.work_end_date) || '/' || date_part('month', ex.work_end_date) || '/' || date_part('day', ex.work_end_date) as 工作迄日, ex.publicist as 公關連絡人, ex.public_relations_office_telephone as 公關室電話, ex.public_relations_office_fax as 公關室傳真, ex.publicist_email as 公關EMAIL, ex.company_website as 公司網址, sb2.remark as 備註, case when lower(ex.action_by)='student' then '是' else ex.action_by end as 學生修改, ex.time_stamp as 最後更新日期 from student left join $ischool.emba.experience as ex on ex.ref_student_id=student.id left join class on class.id=student.ref_class_id left join $ischool.emba.student_brief2 as sb2 on sb2.ref_student_id=student.id where student.id in ({0})", String.Join(",", K12.Presentation.NLDPanels.Student.SelectedSource)); exportProxyForm = new ExportProxyForm(querySQL, true, true, "學生系統編號", null, null); //exportProxyForm.HideSemesterControls(); exportProxyForm.Text = "匯出學生經歷資料"; exportProxyForm.Tag = exportProxyForm.Text; exportProxyForm.ShowDialog(); this.Dispose(); }
public void Execute() { string querySQL = string.Format(@"select course.id as 課程系統編號, course.course_name as 開課, course.school_year as 學年度, course.semester as 學期, ce.class_name as 開課班次, ce.course_type as 類別, ce.subject_code as 課程識別碼, ce.new_subject_code as 課號, course.credit as 學分數, ce.is_required as 必選修, ce.serial_no as 流水號, ce.capacity as 人數上限 from course left join $ischool.emba.course_ext as ce on ce.ref_course_id=course.id where course.id in ({0})", String.Join(",", K12.Presentation.NLDPanels.Course.SelectedSource)); Dictionary<string, List<KeyValuePair<string, string>>> dicReplaceFields = new Dictionary<string,List<KeyValuePair<string,string>>>(); List<KeyValuePair<string,string>> replaceFields = new List<KeyValuePair<string,string>>(); replaceFields.Add(new KeyValuePair<string,string>("FALSE", "選修")); replaceFields.Add(new KeyValuePair<string,string>("TRUE", "必修")); dicReplaceFields.Add("必選修", replaceFields); exportProxyForm = new ExportProxyForm(querySQL, true, true, "課程系統編號", null, dicReplaceFields); //exportProxyForm.HideSemesterControls(); exportProxyForm.Text = "匯出課程基本資料"; exportProxyForm.Tag = exportProxyForm.Text; exportProxyForm.ShowDialog(); }
public void Execute() { string querySQL = string.Format(@"select uid as 課程系統編號, name as 課程中文名稱, eng_name as 課程英文名稱, subject_code as 課程識別碼, dept_name as 開課系所, dept_code as 系所代碼, credit as 學分數, description as 內容簡介, web_url as 網頁連結, is_required as 必選修, remark as 備註, new_subject_code as 課號 from $ischool.emba.subject"); Dictionary<string, List<KeyValuePair<string, string>>> dicReplaceFields = new Dictionary<string, List<KeyValuePair<string, string>>>(); List<KeyValuePair<string, string>> replaceFields = new List<KeyValuePair<string, string>>(); replaceFields.Add(new KeyValuePair<string, string>("false", "選修")); replaceFields.Add(new KeyValuePair<string, string>("true", "必修")); dicReplaceFields.Add("必選修", replaceFields); exportProxyForm = new ExportProxyForm(querySQL, true, true, "課程系統編號", null, dicReplaceFields); //exportProxyForm.HideSemesterControls(); exportProxyForm.Text = "匯出課程總檔"; exportProxyForm.Tag = exportProxyForm.Text; exportProxyForm.ShowDialog(); this.Dispose(); }
public void Execute() { string querySQL = string.Format(@"select t.id 教師系統編號, te.employee_no 人事編號, te.ntu_system_no 教師編號, t.teacher_name 姓名, te.english_name 英文姓名, t.nickname 暱稱, t.id_number 身分證號, t.gender 性別, te.birthday 生日, t.st_login_name 登入帳號, t.email 電子信箱, t.contact_phone 聯絡電話, te.mobil 手機, te.phone 電話, te.other_phone 研究室電話, te.research 研究室, te.address 戶籍地址, te.major_work_place 所屬單位, te.website_url 個人網址, te.memo 備註, t.status 教師狀態 from teacher t left join $ischool.emba.teacher_ext te on t.id=te.ref_teacher_id where t.id in ({0})", String.Join(",", K12.Presentation.NLDPanels.Teacher.SelectedSource)); Dictionary<string, List<KeyValuePair<string, string>>> dicReplaceFields = new Dictionary<string, List<KeyValuePair<string, string>>>(); List<KeyValuePair<string, string>> replaceFields = new List<KeyValuePair<string, string>>(); replaceFields.Add(new KeyValuePair<string, string>("1", "一般")); replaceFields.Add(new KeyValuePair<string, string>("256", "刪除")); dicReplaceFields.Add("教師狀態", replaceFields); exportProxyForm = new ExportProxyForm(querySQL, true, true, "教師系統編號", null, dicReplaceFields); //exportProxyForm.HideSemesterControls(); exportProxyForm.Text = "匯出教師基本資料"; exportProxyForm.Tag = exportProxyForm.Text; exportProxyForm.ShowDialog(); this.Dispose(); }