示例#1
0
        protected void btnManPowerAdd_Click(object sender, EventArgs e)
        {
            msgSuccess.Text = "";
            msgErr.Text     = "";
            msgAlert.Text   = "";
            string          sql_chk = "select * from tbl_manpower where manpower_pos_id = '" + txtAffAdd.SelectedValue + "' and manpower_cpoint_id = '" + txtCpoint.SelectedValue + "'";
            MySqlDataReader rs      = dBScript.selectSQL(sql_chk);

            if (!rs.Read())
            {
                string sql = "INSERT INTO tbl_manpower (manpower_pos_id,manpower_full,manpower_cpoint_id,manpower_year) VALUES ('" + txtAffAdd.SelectedValue + "','" + txtFullAdd.Text + "','" + txtCpoint.SelectedValue + "','" + txtYear.SelectedValue + "')";
                if (dBScript.actionSql(sql))
                {
                    msgSuccess.Text = "เพิ่มอัตรากำลัง " + txtCpoint.SelectedItem + " สำเร็จ<br/>";
                    txtFullAdd.Text = "";
                }
                else
                {
                    msgErr.Text = "เพิ่มอัตรากำลัง " + txtCpoint.SelectedItem + " ล้มเหลว<br/>";
                }
                BindData();
            }
            else
            {
                msgErr.Text = "เพิ่มอัตรากำลัง " + txtCpoint.SelectedItem + " ล้มเหลว<br/> - " + txtCpoint.SelectedItem + " มีข้อมูลอัตตรากำลัง " + txtAffAdd.SelectedItem + " อยู่แล้ว<br/>";
            }
        }
示例#2
0
 protected void btnConfirmPass_Click(object sender, EventArgs e)
 {
     msgSuccess.Text = "";
     msgErr.Text = "";
     msgAlert.Text = "";
     if (txtNewPass.Text.Trim() == txtConfirmNewPass.Text.Trim()&& txtNewPass.Text.Trim() != "" && txtConfirmNewPass.Text.Trim() != "")
     {
         string sql = "UPDATE tbl_emp_user SET emp_user_pass = '******' WHERE emp_user_name='"+ Session["User"].ToString() + "'";
         if (dbScript.actionSql(sql))
         {
             txtNewPass.Text = "";
             txtConfirmNewPass.Text = "";
             msgSuccess.Text = "เปลี่ยนรหัสผ่านสำเร็จสำเร็จ<br/>";
         }
         else
         {
             msgErr.Text = "เปลี่ยนรหัสผ่านสำเร็จล้มเหลว<br/>";
         }
     }
     else
     {
         msgErr.Text ="ใส่ข้อมูลไม่ครบถ้วน หรือ รหัสผ่านใหม่ไม่ตรงกัน";
     }
     dbScript.CloseConnection();
 }
示例#3
0
        protected void YearGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            msgSuccess.Text = "";
            msgErr.Text     = "";
            msgAlert.Text   = "";

            string sql = "DELETE FROM tbl_year WHERE year = '" + YearGridView.DataKeys[e.RowIndex].Value + "'";

            if (dbScript.actionSql(sql))
            {
                msgSuccess.Text = "ลบปีงบประมาณสำเร็จ<br/>";
            }
            else
            {
                msgErr.Text = "ลบปีงบประมาณล้มเหลว<br/>";
            }
            YearGridView.EditIndex = -1;
            BindData();
        }
        protected void CpointGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            msgSuccess.Text = "";
            msgErr.Text     = "";
            msgAlert.Text   = "";
            TextBox txtCpointId = (TextBox)CpointGridView.Rows[e.RowIndex].FindControl("txtCpointId");
            TextBox txtCpoint   = (TextBox)CpointGridView.Rows[e.RowIndex].FindControl("txtCpoint");

            string sql = "UPDATE tbl_cpoint SET cpoint_id='" + txtCpointId.Text + "', cpoint_name='" + txtCpoint.Text + "' WHERE cpoint_id = '" + CpointGridView.DataKeys[e.RowIndex].Value + "'";

            if (dbScript.actionSql(sql))
            {
                msgSuccess.Text = "แก้ไขด่านฯ สำเร็จ<br/>";
            }
            else
            {
                msgErr.Text = "แก้ไขด่านฯ ล้มเหลว<br/>";
            }
            CpointGridView.EditIndex = -1;
            BindData();
        }
示例#5
0
        protected void UserGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            msgSuccess.Text = "";
            msgErr.Text     = "";
            msgAlert.Text   = "";
            TextBox      txtEName      = (TextBox)UserGridView.Rows[e.RowIndex].FindControl("txtEName");
            DropDownList txtEPrivilege = (DropDownList)UserGridView.Rows[e.RowIndex].FindControl("txtEPrivilege");

            string sql = "UPDATE tbl_emp_user SET emp_name='" + txtEName.Text + "',emp_user_privilege='" + txtEPrivilege.SelectedValue + "' WHERE emp_user_name = '" + UserGridView.DataKeys[e.RowIndex].Value + "'";

            if (dBScript.actionSql(sql))
            {
                msgSuccess.Text = "แก้ไขสำเร็จ<br/>";
            }
            else
            {
                msgErr.Text = "แก้ไขล้มเหลว<br/>";
            }
            UserGridView.EditIndex = -1;
            BindData();
        }
示例#6
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            //Response.Write("<script>alert('" + txtEmp.SelectedValue + "');</script>");
            //Response.Write("<script>demo.showNotification('top','center');</script>");
            if (txtEmp.SelectedValue != "")
            {
                if (txtDateSchedule.Text.Length == 10)
                {
                    string sql = "INSERT INTO tbl_tmp_cpoint ( tmp_cpoint_emp_id, tmp_cpoint_cpoint_id, tmp_cpoint_date, tmp_cpoint_status,tmp_cpoint_emp_pos,tmp_cpoint_emp_aff,tmp_cpoint_cpoint_old_id ) VALUES ( '" + txtEmp.SelectedValue + "', '" + txtCpoint.SelectedValue + "', '" + txtDateSchedule.Text.Trim() + "', '0','" + dBScript.getEmpData("emp_pos_id", txtEmp.SelectedValue) + "','" + dBScript.getEmpData("emp_affi_id", txtEmp.SelectedValue) + "','" + dBScript.getEmpData("emp_cpoint_id", txtEmp.SelectedValue) + "' )";
                    if (dBScript.actionSql(sql))
                    {
                        icon      = "add_alert";
                        alertType = "success";
                        alert     = "บันทึกข้อมูลสำเร็จ";
                        ClearData();
                    }
                    else
                    {
                        icon      = "error";
                        alertType = "danger";
                        alert     = "Error : บันทึกล้มเหลว!!";
                    }
                }
                else
                {
                    icon      = "warning";
                    alertType = "danger";
                    alert     = "รูปแบบวันที่ไม่ถูกต้อง วัน-เดือน-ปี ตัวอย่างรูปแบบวันที่ " + DateTime.Now.ToString("dd-MM") + "-" + (DateTime.Now.Year + 543);
                }
            }
            else
            {
                icon      = "warning";
                alertType = "danger";
                alert     = "กรุณากรอกชื่อ-สกุล ให้ถูกต้อง";
            }

            BindData();
        }
示例#7
0
 protected void btnAddTitleGuest_Click(object sender, EventArgs e)
 {
     if (txtTitle.Text != "" && txtRefer.Text != "")
     {
         if (txtGuest_id.Value.ToString() == "")
         {
             string sql      = "INSERT INTO tbl_guest (guest_title,guest_title_to,guest_refer,guest_refer_date,guest_refer_title,guest_offer_date,guest_status) VALUES ('" + txtTitle.Text + "','" + txtTo.Text + "','" + txtRefer.Text + "','" + txtReferDate.Text + "','" + txtReferTitle.Text + "','" + txtOfferDate.Text + "','0')";
             string guest_pk = dBScript.InsertQueryPK(sql);
             if (guest_pk != "")
             {
                 ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('บันทึกสำเร็จ')", true);
                 txtGuest_id.Value   = guest_pk;
                 DivAddGuest.Visible = true;
                 BindData();
             }
             else
             {
                 ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('Error : ล้มเหลว')", true);
             }
         }
         else
         {
             string sql = "UPDATE tbl_guest SET guest_title = '" + txtTitle.Text.Trim() + "',guest_title_to='" + txtTo.Text.Trim() + "',guest_refer = '" + txtRefer.Text.Trim() + "',guest_refer_date = '" + txtReferDate.Text + "',guest_refer_title='" + txtReferTitle.Text.Trim() + "',guest_offer_date='" + txtOfferDate.Text + "' WHERE guest_id = '" + txtGuest_id.Value + "'";
             if (dBScript.actionSql(sql))
             {
                 ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('บันทึกสำเร็จ')", true);
                 BindData();
             }
             else
             {
                 ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('Error : ล้มเหลว')", true);
             }
         }
     }
     else
     {
         ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('กรุณากรอกเรื่อง และกรอกข้อมูลอ้างถึงบันทึกของกองฯ ด้วย')", true);
     }
 }
示例#8
0
        protected void btnAddOldEmp_Click(object sender, EventArgs e)
        {
            alert = "";
            string          empId_new = "";
            string          empId_old = dbScript.getEmpDataIDCard("emp_id", txtIdcard.Text.Trim());
            string          sql       = "SELECT * FROM tbl_emp_profile WHERE emp_id_card = '" + txtIdcard.Text.Trim() + "' AND emp_staus_working <> 1";
            MySqlDataReader rs        = dbScript.selectSQL(sql);

            if (rs.Read())
            {
                rs.Close();
                empId_new = dbScript.createEmpId(txtStartDate);

                if (dbScript.actionSql("UPDATE tbl_emp_profile SET emp_id = '" + empId_new + "',emp_staus_working='1',emp_pos_id='" + txtPos.SelectedValue + "',emp_affi_id='" + txtAffi.SelectedValue + "',emp_cpoint_id='" + txtCpoint.SelectedValue + "' WHERE id='" + dbScript.getEmpDataIDCard("id", txtIdcard.Text.Trim()) + "'"))
                {
                    dbScript.actionSql("DELETE FROM tbl_exp_moterway WHERE emp_id='" + empId_old + "'");
                    dbScript.actionSql("DELETE FROM tbl_work_history WHERE emp_id='" + empId_old + "'");


                    string insert_history_text  = "history_status_id,history_date,history_note,history_emp_id";
                    string insert_history_value = "'1','00-00-0000','', '" + dbScript.getEmpDataIDCard("id", txtIdcard.Text.Trim()) + "'";
                    string insert_history       = "INSERT INTO tbl_history (" + insert_history_text + ") VALUES (" + insert_history_value + ")";
                    dbScript.actionSql(insert_history);

                    Response.Redirect("/Profile/empForm?empID=" + dbScript.getMd5Hash(empId_new));
                }
                else
                {
                    alert += "บันทึกข้อมูลล้มเหลว ลองใหม่อีกครั้ง<br/>"; alertType = "danger"; icon = "error";
                    //msgErr.Text = "บันทึกข้อมูลล้มเหลว ลองใหม่อีกครั้ง";
                }
            }
            else
            {
                alert += "ผิดพลาดไม่พบข้อมูล รหัสบัตรประจำตัวประชาชน : " + txtIdcard.Text + "< br/>"; alertType = "danger"; icon = "error";
                //msgErr.Text = "ผิดพลาดไม่พบข้อมูล รหัสบัตรประจำตัวประชาชน : " + txtIdcard.Text;
            }
            dbScript.CloseConnection();
        }
 protected void btnProfixAdd_Click(object sender, EventArgs e)
 {
     msgSuccess.Text = "";
     msgErr.Text     = "";
     msgAlert.Text   = "";
     if (txtTypeAdd.Text != "")
     {
         string sql = "INSERT INTO tbl_type_add (type_add_name) VALUES ('" + txtTypeAdd.Text + "')";
         if (dbScript.actionSql(sql))
         {
             txtTypeAdd.Text = "";
             msgSuccess.Text = "เพิ่มประเภทที่อยู่สำเร็จ<br/>";
         }
         else
         {
             msgErr.Text = "เพิ่มประเภทที่อยู่ล้มเหลว<br/>";
         }
         BindData();
     }
     else
     {
         msgErr.Text = "เพิ่มประเภทที่อยู่ล้มเหลว<br/>- กรุณาใส่ประเภทที่อยู่";
     }
 }
示例#10
0
 protected void btnAffAdd_Click(object sender, EventArgs e)
 {
     msgSuccess.Text = "";
     msgErr.Text     = "";
     msgAlert.Text   = "";
     if (txtAff.Text != "")
     {
         string sql = "INSERT INTO tbl_affiliation (affi_name) VALUES ('" + txtAff.Text + "')";
         if (dbScript.actionSql(sql))
         {
             txtAff.Text     = "";
             msgSuccess.Text = "เพิ่มหน่วยสำเร็จ<br/>";
         }
         else
         {
             msgErr.Text = "เพิ่มหน่วยล้มเหลว<br/>";
         }
         BindData();
     }
     else
     {
         msgErr.Text = "เพิ่มหน่วยล้มเหลว<br/>- กรุณาใส่หน่วย";
     }
 }
示例#11
0
 protected void btnDocTypeAdd_Click(object sender, EventArgs e)
 {
     msgSuccess.Text = "";
     msgErr.Text     = "";
     msgAlert.Text   = "";
     if (txtDocType.Text != "")
     {
         string sql = "INSERT INTO tbl_type_doc (type_doc_name) VALUES ('" + txtDocType.Text + "')";
         if (dbScript.actionSql(sql))
         {
             txtDocType.Text = "";
             msgSuccess.Text = "เพิ่มประเภทเอกสารสำเร็จ<br/>";
         }
         else
         {
             msgErr.Text = "เพิ่มประเภทเอกสารล้มเหลว<br/>";
         }
         BindData();
     }
     else
     {
         msgErr.Text = "เพิ่มประเภทเอกสารล้มเหลว<br/>- กรุณาใส่ประเภทเอกสาร";
     }
 }
示例#12
0
 protected void btnPosAdd_Click(object sender, EventArgs e)
 {
     msgSuccess.Text = "";
     msgErr.Text     = "";
     msgAlert.Text   = "";
     if (txtPos.Text != "")
     {
         string sql = "INSERT INTO tbl_pos (pos_name) VALUES ('" + txtPos.Text + "')";
         if (dbScript.actionSql(sql))
         {
             txtPos.Text     = "";
             msgSuccess.Text = "เพิ่มตำแหน่งสำเร็จ<br/>";
         }
         else
         {
             msgErr.Text = "เพิ่มตำแหน่งล้มเหลว<br/>";
         }
         BindData();
     }
     else
     {
         msgErr.Text = "เพิ่มตำแหน่งล้มเหลว<br/>- กรุณาใส่ตำแหน่ง";
     }
 }
 protected void btnProvinceAdd_Click(object sender, EventArgs e)
 {
     msgSuccess.Text = "";
     msgErr.Text     = "";
     msgAlert.Text   = "";
     if (txtProvince.Text != "")
     {
         string sql = "INSERT INTO tbl_province (province_name) VALUES ('" + txtProvince.Text + "')";
         if (dbScript.actionSql(sql))
         {
             txtProvince.Text = "";
             msgSuccess.Text  = "เพิ่มจังหวัดสำเร็จ<br/>";
         }
         else
         {
             msgErr.Text = "เพิ่มจังหวัดล้มเหลว<br/>";
         }
         BindData();
     }
     else
     {
         msgErr.Text = "เพิ่มจังหวัดล้มเหลว<br/>- กรุณาใส่จังหวัด";
     }
 }
示例#14
0
 protected void btnStatusAdd_Click(object sender, EventArgs e)
 {
     msgSuccess.Text = "";
     msgErr.Text     = "";
     msgAlert.Text   = "";
     if (txtStatus.Text != "")
     {
         string sql = "INSERT INTO tbl_status_working (status_working_name) VALUES ('" + txtStatus.Text + "')";
         if (dbScript.actionSql(sql))
         {
             txtStatus.Text  = "";
             msgSuccess.Text = "เพิ่มสถานะสำเร็จ<br/>";
         }
         else
         {
             msgErr.Text = "เพิ่มสถานะล้มเหลว<br/>";
         }
         BindData();
     }
     else
     {
         msgErr.Text = "เพิ่มสถานะล้มเหลว<br/>- กรุณาใส่สถานะ";
     }
 }
 protected void btnLevelEdu_Click(object sender, EventArgs e)
 {
     msgSuccess.Text = "";
     msgErr.Text     = "";
     msgAlert.Text   = "";
     if (txtLevelEdu.Text != "")
     {
         string sql = "INSERT INTO tbl_level_edu (level_edu_name) VALUES ('" + txtLevelEdu.Text + "')";
         if (dbScript.actionSql(sql))
         {
             txtLevelEdu.Text = "";
             msgSuccess.Text  = "เพิ่มระดับการศึกษาสำเร็จ<br/>";
         }
         else
         {
             msgErr.Text = "เพิ่มระดับการศึกษาล้มเหลว<br/>";
         }
         BindData();
     }
     else
     {
         msgErr.Text = "เพิ่มระดับการศึกษาล้มเหลว<br/>- กรุณาใส่ระดับการศึกษา";
     }
 }
示例#16
0
        protected void btnSaveLeave_Click(object sender, EventArgs e)
        {
            string emp_leave_sick            = "";
            string emp_leave_relax           = "";
            string emp_leave_ordain          = "";
            string emp_leave_maternity       = "";
            string emp_leave_military        = "";
            string emp_leave_deduction_wages = "";

            string emp_medical_certificate = rbMedicalCertificate.SelectedValue;
            string emp_leave_date_start    = txtStartLeave.Text.Trim();
            string emp_leave_date_end      = txtEndLeave.Text.Trim();
            string emp_leave_emp_id        = dBScript.getEmpIDMD5("emp_id", Request.Params["empID"]);
            string emp_leave_note          = txtNote.Text.Trim();

            switch (rdTypeLeave.SelectedValue)
            {
            case "1":
                emp_leave_sick = txtTotalDay.Text.Trim();
                break;

            case "2": emp_leave_relax = txtTotalDay.Text.Trim();;
                break;

            case "3": emp_leave_maternity = txtTotalDay.Text.Trim();
                break;

            case "4": emp_leave_military = txtTotalDay.Text.Trim();
                break;
            }

            if (ckTypeLeave.Checked)
            {
                emp_leave_ordain = "true";
            }
            else
            {
                emp_leave_ordain = "false";
            }

            switch (rbDeductionWages.SelectedValue)
            {
            case "0":
                emp_leave_deduction_wages = "0";
                break;

            case "1":
                emp_leave_deduction_wages = txtTotalDay.Text.Trim();
                break;

            case "2":
                emp_leave_deduction_wages = txtDeductionWages.Text.Trim();
                break;
            }

            string sql = "INSERT INTO tbl_emp_leave ( emp_leave_sick, emp_leave_relax, emp_leave_ordain, emp_leave_maternity, emp_leave_military, emp_leave_deduction_wages, emp_medical_certificate, emp_leave_date_start, emp_leave_date_end, emp_leave_emp_id, emp_leave_year, emp_leave_note ) VALUES ( '" + emp_leave_sick + "', '" + emp_leave_relax + "', '" + emp_leave_ordain + "', '" + emp_leave_maternity + "', '" + emp_leave_military + "', '" + emp_leave_deduction_wages + "', '" + emp_medical_certificate + "', '" + emp_leave_date_start + "', '" + emp_leave_date_end + "', '" + emp_leave_emp_id + "', '" + dBScript.getBudgetYear(emp_leave_date_start) + "', '" + emp_leave_note + "' )";

            if (dBScript.actionSql(sql))
            {
                msgError = "บันทึกข้อมูลสำเร็จ";
            }
            else
            {
                msgError = "ERROR : บันทึกข้อมูลลมเหลว";
            }

            string script = "alert('" + msgError + "');";

            ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true);
            BindData();
        }