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;
                }
            }
        }
    }
Example #2
0
    //檢查欲報名者是否已經報過名
    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]);
                }
            }
        }
    }
Example #3
0
    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("取消報名失敗!。");
        }
    }
Example #4
0
    //匯出名單
    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");
        }
    }
Example #5
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));
 }
Example #6
0
 /// <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));
 }
Example #7
0
 public DataTable SelectEmployeesByID(Guid activity_id, string activity_type)
 {
     DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO();
     return(myActivityRegistDAO.SelectEmployeesByID(activity_id, activity_type));
 }
Example #8
0
 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);
 }
Example #10
0
 public VO.ActivityRegistVO SelectActivityRegistByPK(Guid activity_id, string emp_id)
 {
     DAO.ActivityRegistDAO myActivityRegistDAO = new ACMS.DAO.ActivityRegistDAO();
     return myActivityRegistDAO.SelectActivityRegistByPK(activity_id, emp_id);
 }
Example #11
0
 /// <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);
 }
Example #12
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);
 }
Example #13
0
    //完成
    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");
    }