protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { string activityid; if (e.Row.RowType == DataControlRowType.DataRow) { ((Label)e.Row.FindControl("Label1")).Text = ((Label)e.Row.FindControl("Label1")).Text.Replace("\r\n", "<br/>"); ACMS.DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); if (ActivityType == "1") { activityid = ((HiddenField)e.Row.FindControl("hiID")).Value; if (myActivityRegistDAO.IsPersonRegisted(new Guid(activityid), clsAuth.ID, "", "1") > 0) { e.Row.FindControl("lbtnRegist").Visible = false; } } } }
//檢查欲報名者是否已經報過名 protected void btnNext_Click(object sender, EventArgs e) { if (Wizard1.ActiveStepIndex == 1 && MyFormMode == FormViewMode.Insert) { ACMS.DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); if (myActivityRegistDAO.IsPersonRegisted(ActivityID, EmpID, "", "1") > 0) { clsMyObj.ShowMessage(@"已存在此員工的報名成功紀錄!請選擇其他員工執行代理報名。"); Wizard1.MoveTo(Wizard1.WizardSteps[0]); } } else if (Wizard1.ActiveStepIndex == 1 && MyFormMode != FormViewMode.Insert) { if (GridView_RegisterPeoplinfo.SelectedIndex == -1) { clsMyObj.ShowMessage(@"請選擇要編輯的人員。"); Wizard1.MoveTo(Wizard1.WizardSteps[0]); } } if (Wizard1.ActiveStepIndex == 2) { RadioButtonList rblidno_type = (RadioButtonList)FormView_fixA.FindControl("tr_person_fix1").FindControl("rblidno_type"); TextBox txtperson_fix1 = (TextBox)FormView_fixA.FindControl("tr_person_fix1").FindControl("txtperson_fix1"); if (rblidno_type.SelectedIndex == 0 && rblidno_type.Visible) { if (clsMyObj.IDChk(txtperson_fix1.Text) != "0") { clsMyObj.ShowMessage("身分證字號格式不正確!"); Wizard1.MoveTo(Wizard1.WizardSteps[1]); } } } }
protected void btnOK_Click(object sender, EventArgs e) { string emp_id1 = ""; string emp_id2 = ""; string path = Server.MapPath("~/UpFiles"); // 先檢查是否低於下限 int membersInt = 0; foreach (GridViewRow gvr in GridView1.Rows) { if ((gvr.FindControl("CheckBox1") as CheckBox).Checked == false) { membersInt += 1; } } ACMS.BO.ActivatyBO aBO = new ACMS.BO.ActivatyBO(); ACMS.VO.ActivatyVO aVO = aBO.SelectActivatyByActivatyID(new Guid(activity_id)); if (membersInt < aVO.team_member_min) { // string sdoPostScript = " __doPostBack('" + btnCancelAll1.ClientID + "','1'); "; // string ScriptAll = " if (confirm('取消報名則團隊人數將低於下限,是否要全隊取消報名?')==true) { alert ('1232456'); window.open('http://www.google.com.tw');" + sdoPostScript + "} "; // string ScriptAll = " if (confirm('取消報名則團隊人數將低於下限,是否要全隊取消報名?')==true) { alert ('1232456')} "; //BasePage.RunClientScript (this.Page , ScriptAll); //clsMyObj.ShowMessage("若您取消報名則團隊人數將低於下限,因此系統將取消整個團隊的報名資格,若確定要取消報名,請點選「確定」按鈕後於下個視窗點選「確定取消報名」按鈕!"); btnOK.Visible = false; btnCancelAll.Visible = false; btnOK0.Visible = true; lblMessage.Visible = true; GridView1.Visible = false; mpSearch.Show(); return; } //已換隊長 if (newBoss != "") { foreach (GridViewRow gvr in GridView1.Rows) { if ((gvr.FindControl("CheckBox1") as CheckBox).Checked == true) { if (GridView1.DataKeys[gvr.RowIndex].Value.ToString() == newBoss) { clsMyObj.ShowMessage("您為此隊隊長,請更換隊長,再進行取消!"); this.mpSearch.Show(); return; } } } ACMS.DAO.ActivityTeamMemberDAO myActivityTeamMemberDAO = new ACMS.DAO.ActivityTeamMemberDAO(); myActivityTeamMemberDAO.ChangeBoss(new Guid(activity_id), newBoss, emp_id); } foreach (GridViewRow gvr in GridView1.Rows) { if ((gvr.FindControl("CheckBox1") as CheckBox).Checked == true && (gvr.FindControl("RadioButton1") as RadioButton).Checked == true) { clsMyObj.ShowMessage("您為此隊隊長,請更換隊長,再進行取消!"); this.mpSearch.Show(); return; } } foreach (GridViewRow gvr in GridView1.Rows) { if ((gvr.FindControl("CheckBox1") as CheckBox).Checked == true) { emp_id1 += string.Format("{0},", GridView1.DataKeys[gvr.RowIndex].Value.ToString()); } emp_id2 += string.Format("{0},", GridView1.DataKeys[gvr.RowIndex].Value.ToString()); } if (emp_id1.EndsWith(",")) { emp_id1 = emp_id1.Substring(0, emp_id1.Length - 1); } if (emp_id1 == "" && newBoss == "") { clsMyObj.ShowMessage("您未取消報名也未更換隊長,程式沒有修改任資料!"); return; } MySingleton.AlterRegistResult MyResult = MySingleton.AlterRegistResult.CancelRegistSucess; if (!string.IsNullOrEmpty(emp_id1)) { string aa = string.Format("{0}://{1}{2}", HttpContext.Current.Request.Url.Scheme, HttpContext.Current.Request.Url.Authority, HttpContext.Current.Request.ApplicationPath).TrimEnd('/'); //MySingleton.AlterRegistResult MyResult = MySingleton.GetMySingleton().AlterRegist_Team(null, null, null, MySingleton.AlterRegistType.CancelRegist, new Guid(activity_id), emp_id1, regist_deadline, cancelregist_deadline, ((Button)sender).Page.Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.IndexOf('/', 7)) + "/ACMS/WebForm/RegistActivity/RegistedActivityQuery.aspx", path); MyResult = MySingleton.GetMySingleton().AlterRegist_Team(null, null, null, MySingleton.AlterRegistType.CancelRegist, new Guid(activity_id), emp_id1, regist_deadline, cancelregist_deadline, aa + "/Default.aspx", path, "", aa + "/Default.aspx"); //.ResolveUrl("~/WebForm/RegistActivity/RegistedActivityQuery.aspx")); GridView1.DataBind(); } if (CancelTeamRegistClick != null) { this.Visible = false; CancelTeamRegistClick(this, e); } ACMS.DAO.ActivityRegistDAO regDao = new ACMS.DAO.ActivityRegistDAO(); emp_id2 = emp_id2.TrimEnd(','); string members = regDao.AllTeamMemberByMembers(new Guid(activity_id), emp_id2); if (members == "") { clsMyObj.ShowMessage("已達人數下限,目前已取消該隊的報名資格"); return; } if (MyResult == MySingleton.AlterRegistResult.CancelRegistSucess) { if (newBoss == "" && emp_id1 != "") { clsMyObj.ShowMessage("取消報名完成。"); } if (newBoss != "" && emp_id1 != "") { clsMyObj.ShowMessage("更換隊長及取消報名完成。"); } if (newBoss != "" && emp_id1 == "") { clsMyObj.ShowMessage("更換隊長完成。"); } } else if (MyResult == MySingleton.AlterRegistResult.CancelRegistFail_DayOver) { clsMyObj.ShowMessage("取消報名截止日之後無法取消報名!。"); } else if (MyResult == MySingleton.AlterRegistResult.CancelRegistFail) { clsMyObj.ShowMessage("取消報名失敗!。"); } }
//匯出名單 protected void lbtnExport_Click(object sender, EventArgs e) { try { string activity_id = GridView1.DataKeys[((sender as LinkButton).NamingContainer as GridViewRow).RowIndex].Values[0].ToString(); string activity_type = GridView1.DataKeys[((sender as LinkButton).NamingContainer as GridViewRow).RowIndex].Values[1].ToString(); //「匯出名單」的功能需帶出「報名編號(團隊編號)、部門、工號、姓名、分機、e-mail與額外填寫欄位」等欄位資訊 DataTable table = new DataTable(); ACMS.DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); table = myActivityRegistDAO.SelectEmployeesByID(new Guid(activity_id), activity_type); if (table.Rows.Count == 0) { clsMyObj.ShowMessage("沒有資料"); return; } DataTable dt = new DataTable(); dt.Columns.Add("報名編號", System.Type.GetType("System.String")); dt.Columns.Add("部門代號", System.Type.GetType("System.String")); dt.Columns.Add("部門", System.Type.GetType("System.String")); dt.Columns.Add("工號", System.Type.GetType("System.String")); dt.Columns.Add("姓名", System.Type.GetType("System.String")); dt.Columns.Add("分機", System.Type.GetType("System.String")); dt.Columns.Add("EMAIL", System.Type.GetType("System.String")); dt.Columns.Add("進度狀態", System.Type.GetType("System.String")); //================================================================= ACMS.DAO.CustomFieldValueDAO myCustFieldValueDAO = new ACMS.DAO.CustomFieldValueDAO(); List <ACMS.VO.CustomFieldValueVO> myCustomFieldValueVOList; if (table.Rows[0]["activity_type"].ToString() == "2") { myCustomFieldValueVOList = myCustFieldValueDAO.SelectCustomFieldValue(new Guid(table.Rows[0]["id"].ToString()), table.Rows[0]["boss_id"].ToString()); dt.Columns.Add("隊名", System.Type.GetType("System.String")); } else { myCustomFieldValueVOList = myCustFieldValueDAO.SelectCustomFieldValue(new Guid(table.Rows[0]["id"].ToString()), table.Rows[0]["emp_id"].ToString()); } dt.Columns.Add("身份證_護照", System.Type.GetType("System.String")); ACMS.BO.CustomFieldItemBO myCustFieldItemBO = new ACMS.BO.CustomFieldItemBO(); List <ACMS.VO.CustomFieldItemVO> myFieldVOS; foreach (ACMS.VO.CustomFieldValueVO custFieldVO in myCustomFieldValueVOList) { if (custFieldVO.field_control.ToLower() == "textbox") { dt.Columns.Add(custFieldVO.field_name, System.Type.GetType("System.String")); } if (custFieldVO.field_control.ToLower() == "textboxlist") { myFieldVOS = myCustFieldItemBO.SelectByField_id(custFieldVO.field_id); foreach (ACMS.VO.CustomFieldItemVO myFieldvo in myFieldVOS) { dt.Columns.Add(custFieldVO.field_name + '_' + myFieldvo.field_item_name, System.Type.GetType("System.Decimal")); } dt.Columns.Add(custFieldVO.field_name + "合計", System.Type.GetType("System.Decimal")); } if (custFieldVO.field_control.ToLower() == "radiobuttonlist") { // dt.Columns.Add(custFieldVO.field_name, System.Type.GetType("System.String")); myFieldVOS = myCustFieldItemBO.SelectByField_id(custFieldVO.field_id); foreach (ACMS.VO.CustomFieldItemVO myFieldvo in myFieldVOS) { dt.Columns.Add(custFieldVO.field_name + '_' + myFieldvo.field_item_name, System.Type.GetType("System.String")); } } if (custFieldVO.field_control.ToLower() == "checkboxlist") { //dt.Columns.Add(custFieldVO.field_name, System.Type.GetType("System.String")); myFieldVOS = myCustFieldItemBO.SelectByField_id(custFieldVO.field_id); foreach (ACMS.VO.CustomFieldItemVO myFieldvo in myFieldVOS) { dt.Columns.Add(custFieldVO.field_name + '_' + myFieldvo.field_item_name, System.Type.GetType("System.String")); } } } // dt.Columns.Add("自訂欄位", System.Type.GetType("System.String")); string teamName = ""; int seqno = 0; int seqno1 = 0; DataRow dtDr; foreach (DataRow dr in table.Rows) { dtDr = dt.NewRow(); if (dr["activity_type"].ToString() == "2") { if (teamName != dr["boss_id"].ToString().Trim()) { seqno++; } if (seqno > int.Parse(dr["team_max"].ToString())) { seqno1++; } } else { seqno++; if (seqno > int.Parse(dr["team_max"].ToString())) { seqno1++; } } if (seqno1 > 0) { dtDr["報名編號"] = "備取:" + seqno1.ToString(); } else { dtDr["報名編號"] = "正取:" + seqno.ToString(); } dtDr["部門代號"] = dr["DEPT_ID"].ToString(); dtDr["部門"] = dr["C_DEPT_NAME"].ToString(); dtDr["工號"] = dr["WORK_ID"].ToString(); dtDr["姓名"] = dr["NATIVE_NAME"].ToString(); dtDr["分機"] = dr["OFFICE_PHONE"].ToString(); dtDr["EMAIL"] = dr["OFFICE_MAIL"].ToString(); dtDr["進度狀態"] = dr["check_status"].ToString(); dtDr["身份證_護照"] = dr["idno"].ToString(); if (dr["activity_type"].ToString() == "2") { if (dr["boss_id"].ToString() != teamName) { // dtDr["自訂欄位"] = GetCustomField(dr["id"].ToString(), dr["boss_id"].ToString()); GetCustomFieldNew(dr["id"].ToString(), dr["boss_id"].ToString(), ref dtDr); dtDr["隊名"] = dr["team_name"].ToString().Trim(); } teamName = dr["boss_id"].ToString().Trim(); } else { // dtDr["自訂欄位"] = GetCustomField(dr["id"].ToString(), dr["emp_id"].ToString()); GetCustomFieldNew(dr["id"].ToString(), dr["emp_id"].ToString(), ref dtDr); } dt.Rows.Add(dtDr); } if (table != null && table.Rows.Count > 0) { table.Columns[0].ColumnName = "員工編號"; table.Columns[1].ColumnName = "員工姓名"; table.Columns[2].ColumnName = "員工部門"; // 產生 Excel 資料流。 //MemoryStream ms = DataTableRenderToExcel.RenderDataTableToExcel(table) as MemoryStream; MemoryStream ms = DataTableRenderToExcel.RenderDataTableToExcel(dt) as MemoryStream; // 設定強制下載標頭。 Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", Server.UrlEncode("RegistedList"))); // 輸出檔案。 Response.BinaryWrite(ms.ToArray()); ms.Close(); ms.Dispose(); } else { clsMyObj.ShowMessage("沒有資料!"); } } catch (Exception ex) { WriteErrorLog("ExportExcel", ex.Message, "0"); } }
/// <summary> /// 取得取消名單清冊 /// </summary> /// <param name="activity_id">活動代號</param> /// <param name="name">員工或隊長的中英文名字</param> /// <returns>取得取消名單清冊</returns> public DataTable GetCancelRegist(Guid activity_id, string name) { DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); return(myActivityRegistDAO.GetCancelRegist(activity_id, name)); }
/// <summary> /// 取得報名後的報名順序 /// </summary> /// <param name="activity">活動代號</param> /// <returns>取得報名後的報名順序</returns> public string getSNByActivity(Guid activity_id, string emp_id) { DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); return(myActivityRegistDAO.getSNByActivity(activity_id, emp_id)); }
public DataTable SelectEmployeesByID(Guid activity_id, string activity_type) { DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); return(myActivityRegistDAO.SelectEmployeesByID(activity_id, activity_type)); }
public VO.ActivityRegistVO SelectActivityRegistByPK(Guid activity_id, string emp_id) { DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); return(myActivityRegistDAO.SelectActivityRegistByPK(activity_id, emp_id)); }
public DataTable SelectEmployeesByID(Guid activity_id, string activity_type) { DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); return myActivityRegistDAO.SelectEmployeesByID(activity_id, activity_type); }
public VO.ActivityRegistVO SelectActivityRegistByPK(Guid activity_id, string emp_id) { DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); return myActivityRegistDAO.SelectActivityRegistByPK(activity_id, emp_id); }
/// <summary> /// 取得報名後的報名順序 /// </summary> /// <param name="activity">活動代號</param> /// <returns>取得報名後的報名順序</returns> public string getSNByActivity(Guid activity_id, string emp_id) { DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); return myActivityRegistDAO.getSNByActivity(activity_id, emp_id); }
/// <summary> /// 取得取消名單清冊 /// </summary> /// <param name="activity_id">活動代號</param> /// <param name="name">員工或隊長的中英文名字</param> /// <returns>取得取消名單清冊</returns> public DataTable GetCancelRegist(Guid activity_id, string name) { DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); return myActivityRegistDAO.GetCancelRegist(activity_id, name); }
//完成 protected void FinishButton_Click(object sender, EventArgs e) { ACMS.DAO.ActivityGroupLimitDAO limDAO = new ACMS.DAO.ActivityGroupLimitDAO(); //預覽時 if (Session["form_mode1"] != null) { if (Session["form_mode1"].ToString() == "preview") { Session.Remove("form_mode1"); Response.Redirect("~/WebForm/ManageActivity/ActivityEditQuery.aspx"); } } if (MyFormMode == FormViewMode.ReadOnly) { Response.Redirect("RegistedActivityQuery.aspx?type=1"); } try { //以新增方式進來時 ACMS.VO.ActivityRegistVO myActivityRegistVO = GetActivityRegistVO(); //取得報名資訊 ACMS.DAO.ActivityRegistDAO dao = new ACMS.DAO.ActivityRegistDAO(); List <ACMS.VO.CustomFieldValueVO> myCustomFieldValueVOList = GetCustomFieldValueVOList(); //取得自訂欄位值 //ACMS.DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO(); string path = Server.MapPath("~/UpFiles"); //報名 MySingleton.AlterRegistResult MyResult; if (limDAO.GroupLimitIsExist(ActivityID.ToString(), myActivityRegistVO.emp_id) == false) { clsMyObj.ShowMessage(myActivityRegistVO.emp_id + "不在可報名的名單中!"); return; } if (MyFormMode == FormViewMode.Insert) { if (dao.IsPersonRegisted(ActivityID, myActivityRegistVO.emp_id, "", "1") > 0) { clsMyObj.ShowMessage("已報名,無法重覆報名"); return; } if (dao.RegistableCount(ActivityID) < 0) { clsMyObj.ShowMessage("已額滿,無法報名"); return; } // MyResult = MySingleton.GetMySingleton().AlterRegist(myActivityRegistVO, myCustomFieldValueVOList, MySingleton.AlterRegistType.RegistInsert, new Guid(), "", "", "", this.Page.Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.IndexOf('/', 7)) + "/ACMS/WebForm/RegistActivity/RegistedActivityQuery.aspx", path); string aa = string.Format("{0}://{1}{2}", HttpContext.Current.Request.Url.Scheme, HttpContext.Current.Request.Url.Authority, HttpContext.Current.Request.ApplicationPath).TrimEnd('/'); MyResult = MySingleton.GetMySingleton().AlterRegist(myActivityRegistVO, myCustomFieldValueVOList, MySingleton.AlterRegistType.RegistInsert, new Guid(), "", "", "", aa + "/Default.aspx", path, "", aa + "/Default.aspx"); } else { // MyResult = MySingleton.GetMySingleton().AlterRegist(myActivityRegistVO, myCustomFieldValueVOList, MySingleton.AlterRegistType.RegistUpdate, new Guid(), "", "", "", this.Page.Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.IndexOf('/', 7)) + "/ACMS/WebForm/RegistActivity/RegistedActivityQuery.aspx",path); string aa = string.Format("{0}://{1}{2}", HttpContext.Current.Request.Url.Scheme, HttpContext.Current.Request.Url.Authority, HttpContext.Current.Request.ApplicationPath).TrimEnd('/'); MyResult = MySingleton.GetMySingleton().AlterRegist(myActivityRegistVO, myCustomFieldValueVOList, MySingleton.AlterRegistType.RegistUpdate, new Guid(), "", "", "", aa + "/Default.aspx", path, "", aa + "/Default.aspx"); } if (MyResult == MySingleton.AlterRegistResult.RegistFail_Already) { clsMyObj.ShowMessage("已存在報名成功紀錄,無法重複報名!"); return; } else if (MyResult == MySingleton.AlterRegistResult.RegistFail_Full) { clsMyObj.ShowMessage(@"抱歉,報名已額滿!若錄取名額有增加則可再次報名。"); return; } else if (MyResult == MySingleton.AlterRegistResult.RegistFail) { clsMyObj.ShowMessage(@"資料存檔發生錯誤,無法完成報名。"); return; } else { } } catch (Exception ex) { WriteErrorLog("SaveData", ex.Message, "0"); return; } Response.Redirect("RegistedActivityQuery.aspx?type=1"); }