private void InitTreeView()
        {
            this.treeView_Data.Nodes.Clear();
            TreeNode myTreeNode;
            TreeNode myTreeNode_KindofEmployer;

            myTreeNode      = new TreeNode();
            myTreeNode.Text = "报考单位";
            myTreeNode.Tag  = "报考单位";

            Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployer.ToString()];

            foreach (DataRowView myDataRowView_KindofEmployer in myClass_Data.myDataView)
            {
                myTreeNode_KindofEmployer      = new TreeNode();
                myTreeNode_KindofEmployer.Text = myDataRowView_KindofEmployer["KindofEmployer"].ToString();
                myTreeNode_KindofEmployer.Tag  = myDataRowView_KindofEmployer["KindofEmployer"].ToString();
                if (Class_CustomUser.GetSecurity(Class_zwjPublic.myClass_CustomUser.UserGUID, Class_CustomSecurity.GetSecurityGUID("焊工权限"), Enum_zwjKindofUpdate.Read))
                {
                    myTreeNode.Nodes.Add(myTreeNode_KindofEmployer);
                }
                else if (Class_CustomUser.GetSecurity(Class_zwjPublic.myClass_CustomUser.UserGUID, Class_CustomSecurity.GetSecurityGUID("报考权限"), Enum_zwjKindofUpdate.Read))
                {
                    Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(myDataRowView_KindofEmployer["KindofEmployer"].ToString());
                    if (myClass_KindofEmployer.KindofEmployerManagerID.Equals(Class_zwjPublic.myClass_CustomUser.UserGUID))
                    {
                        myTreeNode.Nodes.Add(myTreeNode_KindofEmployer);
                    }
                }
            }
            this.treeView_Data.Nodes.Add(myTreeNode);
            this.label_Data.Text = string.Format("报考单位:({0})", myTreeNode.Nodes.Count);
        }
        private void button_OnOK_Click(object sender, EventArgs e)
        {
            this.userControl_KindofEmployerBase1.FillClass();
            String str_ErrMessage;

            str_ErrMessage = myClass_KindofEmployer.CheckField();
            if (!string.IsNullOrEmpty(str_ErrMessage))
            {
                this.DialogResult          = DialogResult.None;
                this.label_ErrMessage.Text = str_ErrMessage;
                return;
            }
            if (this.bool_Add)
            {
                if (!Class_KindofEmployer.ExistAndCanDeleteAndDelete(this.myClass_KindofEmployer.KindofEmployer, Enum_zwjKindofUpdate.Exist))
                {
                    this.myClass_KindofEmployer.AddAndModify(Enum_zwjKindofUpdate.Add);
                }
                else
                {
                    this.label_ErrMessage.Text = "该报考单位已添加!";
                    this.DialogResult          = DialogResult.None;
                    return;
                }
            }
            else
            {
                this.myClass_KindofEmployer.AddAndModify(Enum_zwjKindofUpdate.Modify);
            }

            this.DialogResult = DialogResult.OK;
            this.Close();
        }
예제 #3
0
        private void toolStripMenuItem_RowSynchronization_Click(object sender, EventArgs e)
        {
            Form_Welder_Synchronization myForm = new Form_Welder_Synchronization();
            Class_KindofEmployer        myClass_KindofEmployer = new Class_KindofEmployer(this.myEventArgs_KindofEmployer.str_KindofEmployer);

            myForm.myClass_KindofEmployer = myClass_KindofEmployer;
            myForm.ShowDialog();
            if (myForm.bool_Updated)
            {
                this.RefreshData(false);
            }
        }
예제 #4
0
        /// <summary>
        /// 初始化数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void InitDataGridView(object sender, EventArgs_KindofEmployer e)
        {
            Class_DataControlBind.InitializeDataGridView(this.dataGridView_Exam, Enum_DataTable.IssueStudentQCRegistrationNo.ToString(), false);
            this.myEventArgs_KindofEmployer = e;
            Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.KindofEmployerWelder.ToString(), false);
            Class_Data myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployerWelder.ToString()];

            myClass_Data.SetFilter(string.Format("KindofEmployer='{0}'", this.myEventArgs_KindofEmployer.str_KindofEmployer));
            if (this.myEventArgs_KindofEmployer.bool_JustFill)
            {
                if (this.myDataTable.Rows.Count == 0)
                {
                    this.dataGridView_Data.DataSource = null;
                    myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill);
                    this.myDataTable = myClass_Data.myDataTable.Copy();
                    this.myDataView  = new DataView(this.myDataTable);
                    this.dataGridView_Data.DataSource = this.myDataView;
                }
                else
                {
                    myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill, this.myDataTable);
                }
            }
            else
            {
                this.dataGridView_Data.DataSource = null;
                myClass_Data.RefreshData(this.myEventArgs_KindofEmployer.bool_JustFill);
                this.myDataTable = myClass_Data.myDataTable.Copy();
                this.myDataView  = new DataView(this.myDataTable);
                this.dataGridView_Data.DataSource = this.myDataView;
            }
            if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort))
            {
                ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort;
            }
            this.label_Data.Text = string.Format("报考单位焊工信息,({0}):", this.dataGridView_Data.RowCount);
            if (this.dataGridView_Data.CurrentRow == null)
            {
                this.dataGridView_Exam.DataSource = null;
                this.label_Exam.Text = "考试记录:";
                this.userControl_WelderPictureBase1.InitWelderPicture(null);
            }

            Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(e.str_KindofEmployer);

            this.userControl_WelderPictureBase1.button_UploadPicture.Visible = myClass_KindofEmployer.CanUpLoadWelderPicture;
            this.userControl_WelderPictureBase1.button_DeletePicture.Visible = myClass_KindofEmployer.CanDeleteWelderPicture;
            this.userControl_WelderPictureBase1.bool_CanModifyWelderPicture  = myClass_KindofEmployer.CanModifyWelderPicture;
        }
예제 #5
0
        /// <summary>
        /// 更新数据到对象中
        /// </summary>
        public void FillClass()
        {
            myClass_KindofEmployer.KindofEmployer      = this.TextBox_KindofEmployer.Text;
            myClass_KindofEmployer.KindofEmployerLevel = (int)this.NumericUpDown_KindofEmployerLevel.Value;
            if (!string.IsNullOrEmpty(this.textBox_KindofEmployerManager.Text))
            {
                this.myClass_KindofEmployer.KindofEmployerManagerID = new Guid((this.textBox_KindofEmployerManager.Text.Split(':'))[1]);
            }

            myClass_KindofEmployer.KindofEmployerEmployerHPID = this.ComboBox_Employer.SelectedValue.ToString();
            if (this.CheckBox_Department.Checked && this.ComboBox_Department.SelectedValue != null)
            {
                myClass_KindofEmployer.KindofEmployerDepartmentHPID = this.ComboBox_Department.SelectedValue.ToString();
                if (this.CheckBox_WorkPlace.Checked && this.ComboBox_WorkPlace.SelectedValue != null)
                {
                    myClass_KindofEmployer.KindofEmployerWorkPlaceHPID = this.ComboBox_WorkPlace.SelectedValue.ToString();
                }
                else
                {
                    myClass_KindofEmployer.KindofEmployerWorkPlaceHPID = "";
                }
            }
            else
            {
                myClass_KindofEmployer.KindofEmployerDepartmentHPID = "";
            }
            if (this.CheckBox_LaborServiceTeam.Checked && this.ComboBox_LaborServiceTeam.SelectedValue != null)
            {
                myClass_KindofEmployer.KindofEmployerLaborServiceTeamHPID = this.ComboBox_LaborServiceTeam.SelectedValue.ToString();
            }
            else
            {
                myClass_KindofEmployer.KindofEmployerLaborServiceTeamHPID = "";
            }
            myClass_KindofEmployer.CanUpLoadWelderPicture = this.checkBox_CanUpLoadWelderPicture.Checked;
            myClass_KindofEmployer.CanModifyWelderPicture = this.checkBox_CanModifyWelderPicture.Checked;
            myClass_KindofEmployer.CanDeleteWelderPicture = this.checkBox_CanDeleteWelderPicture.Checked;
            myClass_KindofEmployer.KindofEmployerIndex    = (int)this.numericUpDown_KindofEmployerIndex.Value;
            myClass_KindofEmployer.KindofEmployerRemark   = this.TextBox_KindofEmployerRemark.Text;
            myClass_KindofEmployer.KindofEmployerTel      = this.textBox_EmployerTel.Text;
            myClass_KindofEmployer.KindofEmployerFax      = this.textBox_EmployerFax.Text;
            myClass_KindofEmployer.KindofEmployerMobile   = this.textBox_EmployerMobile.Text;
            myClass_KindofEmployer.KindofEmployerEmail    = this.textBox_EmployerEmail.Text;
            if (myClass_KindofEmployerDefault == null)
            {
                myClass_KindofEmployerDefault = new Class_KindofEmployer();
            }
        }
 private void Form_KindofEmployerUpdate_Load(object sender, EventArgs e)
 {
     if (!(this.bool_Add || Class_KindofEmployer.ExistAndCanDeleteAndDelete(myClass_KindofEmployer.KindofEmployer, Enum_zwjKindofUpdate.Exist)))
     {
         MessageBox.Show("不存在该项,可能已删除!");
         this.DialogResult = DialogResult.Cancel;
         this.Close();
         return;
     }
     this.label_ErrMessage.Text = "";
     if (!Class_zwjPublic.myBackColor.IsEmpty)
     {
         this.BackColor = Class_zwjPublic.myBackColor;
     }
     this.userControl_KindofEmployerBase1.InitControl(this.myClass_KindofEmployer, this.bool_Add);
 }
        private void Button_KindofEmployerModify_Click(object sender, EventArgs e)
        {
            string        str_NewKindofEmployer = "";
            Form_InputBox myForm = new Form_InputBox();

            myForm.str_DefaultResponse = this.myClass_KindofEmployer.KindofEmployer;
            myForm.str_Prompt          = "请输入报考单位名称:";
            myForm.str_Title           = "输入报考单位名称";
            if (myForm.ShowDialog() == DialogResult.OK)
            {
                str_NewKindofEmployer = myForm.str_DefaultResponse;
            }
            else
            {
                return;
            }
            if (Class_KindofEmployer.ExistAndCanDeleteAndDelete(str_NewKindofEmployer, ZCCL.ClassBase.Enum_zwjKindofUpdate.Exist) == true)
            {
                MessageBox.Show("报考单位名称重复,操作失败!");
                return;
            }
            this.myClass_KindofEmployer.KindofEmployerModify(str_NewKindofEmployer);
            this.userControl_KindofEmployerBase1.InitControl(this.myClass_KindofEmployer, false);
        }
        public void InitControl(Class_KindofEmployerIssue myClass_KindofEmployerIssue, bool bool_Add)
        {
            Class_Data myClass_ShipandShipClassification = (Class_Data)Class_Public.myHashtable[Enum_DataTable.ShipandShipClassification.ToString()];

            myDataView_ShipandShipClassification      = new DataView(myClass_ShipandShipClassification.myDataTable);
            myDataView_ShipandShipClassification.Sort = myClass_ShipandShipClassification.myDataView.Sort;
            Class_DataControlBind.InitializeComboBox(this.comboBox_ShipboardNo, this.myDataView_ShipandShipClassification, "ShipboardNo", "ShipboardNo");

            Class_Public.InitializeComboBox(this.comboBox_Employer, Enum_DataTable.Employer.ToString(), "EmployerHPID", "Employer");
            Class_Public.InitializeComboBox(this.comboBox_ShipClassificationAb, Enum_DataTable.ShipClassification.ToString(), "ShipClassificationAb", "ShipClassificationAb");
            Class_Public.InitializeComboBox(this.ComboBox_Assemblage, Enum_DataTable.Assemblage.ToString(), "Assemblage", "Assemblage");
            Class_Public.InitializeComboBox(this.ComboBox_KindofExam, Enum_DataTable.KindofExam.ToString(), "KindofExam", "KindofExam");
            Class_Public.InitializeComboBox(this.ComboBox_WeldingProcess, Enum_DataTable.WeldingProcess.ToString(), "WeldingProcessAb", "WeldingProcessAb");
            this.myClass_KindofEmployerIssue = myClass_KindofEmployerIssue;
            this.textBox_KindofEmployer.Text = this.myClass_KindofEmployerIssue.KindofEmployer;

            Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(this.myClass_KindofEmployerIssue.KindofEmployer);

            switch (myClass_KindofEmployer.KindofEmployerLevel)
            {
            case 0:
                break;

            case 1:
            case 2:
            case 3:
            case 4:
                this.comboBox_Employer.Enabled = false;
                break;
            }
            if (bool_Add)
            {
                if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerEmployerHPID))
                {
                    this.comboBox_Employer.SelectedValue = myClass_KindofEmployer.KindofEmployerEmployerHPID;
                }
                if (myClass_KindofEmployerIssueDefault != null)
                {
                    this.InitControlWeldingParameter(myClass_KindofEmployerIssueDefault.myClass_WeldingParameter);
                    this.ComboBox_WeldingProcess.SelectedValue = myClass_KindofEmployerIssueDefault.WeldingProcessAb;
                    if (this.comboBox_Employer.Enabled)
                    {
                        this.comboBox_Employer.SelectedValue = myClass_KindofEmployerIssueDefault.EmployerHPID;
                    }
                    this.myClass_KindofEmployerIssue.EmployerHPID    = myClass_KindofEmployerIssueDefault.EmployerHPID;
                    this.comboBox_ShipClassificationAb.SelectedValue = myClass_KindofEmployerIssueDefault.ShipClassificationAb;
                    this.comboBox_ShipboardNo.SelectedValue          = myClass_KindofEmployerIssueDefault.ShipboardNo;
                }
            }
            else
            {
                this.textBox_KindofEmployerIssueID.Text = this.myClass_KindofEmployerIssue.KindofEmployerIssueID.ToString();
                this.MaskedTextBox_IssueNo.Text         = myClass_KindofEmployerIssue.IssueNo;
                this.textBox_WPSNo.Text                          = myClass_KindofEmployerIssue.IssueWPSNo;
                this.TextBox_IssueRemark.Text                    = myClass_KindofEmployerIssue.IssueRemark;
                this.DateTimePicker_SignUpDate.Value             = myClass_KindofEmployerIssue.SignUpDate;
                this.textBox_KindofEmployer.Text                 = myClass_KindofEmployerIssue.KindofEmployer;
                this.comboBox_Employer.SelectedValue             = myClass_KindofEmployerIssue.EmployerHPID;
                this.ComboBox_WeldingProcess.SelectedValue       = myClass_KindofEmployerIssue.WeldingProcessAb;
                this.comboBox_ShipClassificationAb.SelectedValue = this.myClass_KindofEmployerIssue.ShipClassificationAb;
                this.comboBox_ShipboardNo.SelectedValue          = this.myClass_KindofEmployerIssue.ShipboardNo;

                this.InitControlWeldingParameter(this.myClass_KindofEmployerIssue.myClass_WeldingParameter);
            }
        }
        /// <summary>
        /// 初始化数据
        /// </summary>
        /// <param name="myClass_KindofEmployerWelder"></param>
        /// <param name="bool_Add"></param>
        public void InitControl(Class_KindofEmployerWelder myClass_KindofEmployerWelder, bool bool_Add)
        {
            Class_Data myClass_Data;

            myClass_Data                  = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Employer.ToString()];
            this.myDataView_Employer      = new DataView(myClass_Data.myDataTable);
            this.myDataView_Employer.Sort = myClass_Data.myDataView.Sort;

            myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Department.ToString()];
            this.myDataView_Department      = new DataView(myClass_Data.myDataTable);
            this.myDataView_Department.Sort = myClass_Data.myDataView.Sort;

            myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WorkPlace.ToString()];
            this.myDataView_WorkPlace      = new DataView(myClass_Data.myDataTable);
            this.myDataView_WorkPlace.Sort = myClass_Data.myDataView.Sort;

            myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.LaborServiceTeam.ToString()];
            this.myDataView_LaborServiceTeam      = new DataView(myClass_Data.myDataTable);
            this.myDataView_LaborServiceTeam.Sort = myClass_Data.myDataView.Sort;

            Class_DataControlBind.InitializeComboBox(this.ComboBox_LaborServiceTeam, this.myDataView_LaborServiceTeam, "LaborServiceTeamHPID", "LaborServiceTeam");
            Class_DataControlBind.InitializeComboBox(this.ComboBox_WorkPlace, this.myDataView_WorkPlace, "WorkPlaceHPID", "WorkPlace");
            Class_DataControlBind.InitializeComboBox(this.ComboBox_Department, this.myDataView_Department, "DepartmentHPID", "Department");
            Class_DataControlBind.InitializeComboBox(this.ComboBox_Employer, this.myDataView_Employer, "EmployerHPID", "Employer");
            Class_Public.InitializeComboBox(this.ComboBox_Schooling, Enum_DataTable.Schooling.ToString(), "Schooling", "Schooling");

            this.myClass_KindofEmployerWelder = myClass_KindofEmployerWelder;
            this.textBox_KindofEmployer.Text  = this.myClass_KindofEmployerWelder.KindofEmployer;

            Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(this.myClass_KindofEmployerWelder.KindofEmployer);

            switch (myClass_KindofEmployer.KindofEmployerLevel)
            {
            case 0:
                break;

            case 1:
                this.ComboBox_Employer.Enabled = false;
                break;

            case 2:
                this.ComboBox_Employer.Enabled   = false;
                this.ComboBox_Department.Enabled = false;
                this.CheckBox_Department.Enabled = false;
                break;

            case 3:
                this.ComboBox_Employer.Enabled   = false;
                this.ComboBox_Department.Enabled = false;
                this.CheckBox_Department.Enabled = false;
                this.ComboBox_WorkPlace.Enabled  = false;
                this.CheckBox_WorkPlace.Enabled  = false;
                break;

            case 4:
                this.ComboBox_Employer.Enabled         = false;
                this.ComboBox_LaborServiceTeam.Enabled = false;
                this.CheckBox_LaborServiceTeam.Enabled = false;
                break;
            }
            if (bool_Add)
            {
                if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerEmployerHPID))
                {
                    this.ComboBox_Employer.SelectedValue = myClass_KindofEmployer.KindofEmployerEmployerHPID;
                    if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerDepartmentHPID))
                    {
                        this.ComboBox_Department.SelectedValue = myClass_KindofEmployer.KindofEmployerDepartmentHPID;
                        if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerWorkPlaceHPID))
                        {
                            this.ComboBox_WorkPlace.SelectedValue = myClass_KindofEmployer.KindofEmployerWorkPlaceHPID;
                        }
                    }
                    if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerLaborServiceTeamHPID))
                    {
                        this.ComboBox_LaborServiceTeam.SelectedValue = myClass_KindofEmployer.KindofEmployerLaborServiceTeamHPID;
                    }
                }

                if (myClass_KindofEmployerWelderDefault != null)
                {
                    this.CheckBox_Sex.Checked = myClass_KindofEmployerWelderDefault.Sex == "男";
                    this.DateTimePicker_WeldingBeinning.Value  = myClass_KindofEmployerWelderDefault.WeldingBeginning;
                    this.ComboBox_Schooling.SelectedValue      = myClass_KindofEmployerWelderDefault.Schooling;
                    this.ComboBox_Employer.SelectedValue       = myClass_KindofEmployerWelderDefault.myClass_BelongUnit.EmployerHPID;
                    this.myDataView_Department.RowFilter       = string.Format("EmployerHPID='{0}'", myClass_KindofEmployerWelderDefault.myClass_BelongUnit.EmployerHPID);
                    this.myDataView_LaborServiceTeam.RowFilter = string.Format("EmployerHPID='{0}'", myClass_KindofEmployerWelderDefault.myClass_BelongUnit.EmployerHPID);
                    if (string.IsNullOrEmpty(myClass_KindofEmployerWelderDefault.myClass_BelongUnit.DepartmentHPID))
                    {
                        this.CheckBox_Department.Checked = false;
                    }
                    else
                    {
                        this.ComboBox_Department.SelectedValue = myClass_KindofEmployerWelderDefault.myClass_BelongUnit.DepartmentHPID;
                        this.CheckBox_Department.Checked       = true;
                        this.myDataView_WorkPlace.RowFilter    = string.Format("DepartmentHPID='{0}'", myClass_KindofEmployerWelderDefault.myClass_BelongUnit.DepartmentHPID);
                        if (!string.IsNullOrEmpty(myClass_KindofEmployerWelderDefault.myClass_BelongUnit.WorkPlaceHPID))
                        {
                            this.ComboBox_WorkPlace.SelectedValue = myClass_KindofEmployerWelderDefault.myClass_BelongUnit.WorkPlaceHPID;
                            this.CheckBox_WorkPlace.Checked       = true;
                        }
                        else
                        {
                            this.CheckBox_WorkPlace.Checked = false;
                        }
                    }

                    if (string.IsNullOrEmpty(myClass_KindofEmployerWelderDefault.myClass_BelongUnit.LaborServiceTeamHPID))
                    {
                        this.CheckBox_LaborServiceTeam.Checked = false;
                    }
                    else
                    {
                        this.ComboBox_LaborServiceTeam.SelectedValue = myClass_KindofEmployerWelderDefault.myClass_BelongUnit.LaborServiceTeamHPID;
                        this.CheckBox_LaborServiceTeam.Checked       = true;
                    }
                }
            }
            else
            {
                this.textBox_KindofEmployerWelderID.Text      = this.myClass_KindofEmployerWelder.KindofEmployerWelderID.ToString();
                this.Button_IdentificationCardConvert.Enabled = false;
                this.MaskedTextBox_IdentificationCard.Text    = myClass_KindofEmployerWelder.IdentificationCard;
                this.TextBox_WelderName.Text               = myClass_KindofEmployerWelder.WelderName;
                this.textBox_WelderEnglishName.Text        = myClass_KindofEmployerWelder.WelderEnglishName;
                this.CheckBox_Sex.Checked                  = myClass_KindofEmployerWelder.Sex == "男";
                this.DateTimePicker_WeldingBeinning.Value  = myClass_KindofEmployerWelder.WeldingBeginning;
                this.TextBox_WorkerID.Text                 = myClass_KindofEmployerWelder.myClass_BelongUnit.WorkerID;
                this.TextBox_WelderRemark.Text             = myClass_KindofEmployerWelder.WelderRemark;
                this.ComboBox_Schooling.SelectedValue      = myClass_KindofEmployerWelder.Schooling;
                this.ComboBox_Employer.SelectedValue       = myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID;
                this.myDataView_Department.RowFilter       = string.Format("EmployerHPID='{0}'", myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID);
                this.myDataView_LaborServiceTeam.RowFilter = string.Format("EmployerHPID='{0}'", myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID);
                if (string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID))
                {
                    this.CheckBox_Department.Checked = false;
                }
                else
                {
                    this.ComboBox_Department.SelectedValue = myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID;
                    this.CheckBox_Department.Checked       = true;
                    this.myDataView_WorkPlace.RowFilter    = string.Format("DepartmentHPID='{0}'", myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID);
                    if (!string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID))
                    {
                        this.ComboBox_WorkPlace.SelectedValue = myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID;
                        this.CheckBox_WorkPlace.Checked       = true;
                    }
                    else
                    {
                        this.CheckBox_WorkPlace.Checked = false;
                    }
                }

                if (string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID))
                {
                    this.CheckBox_LaborServiceTeam.Checked = false;
                }
                else
                {
                    this.ComboBox_LaborServiceTeam.SelectedValue = myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID;
                    this.CheckBox_LaborServiceTeam.Checked       = true;
                }
            }
        }
        /// <summary>
        /// 初始化数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void InitDataGridView(object sender, EventArgs_ShipClassification e)
        {
            this.myEventArgs_ShipClassification = e;
            string str_Filter;

            if (!string.IsNullOrEmpty(this.myEventArgs_ShipClassification.str_ShipClassificationAb))
            {
                str_Filter = string.Format("ShipClassificationAb='{0}'", this.myEventArgs_ShipClassification.str_ShipClassificationAb);
                if (!string.IsNullOrEmpty(this.myEventArgs_ShipClassification.str_ShipboardNo))
                {
                    str_Filter += string.Format(" And ShipboardNo='{0}'", this.myEventArgs_ShipClassification.str_ShipboardNo);
                    //if (this.myEventArgs_ShipClassification.bool_GXTheory)
                    //{
                    //    Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.GXTheoryIssue.ToString());
                    //    myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.GXTheoryIssue.ToString()];
                    //}
                }
                else if (!string.IsNullOrEmpty(this.myEventArgs_ShipClassification.str_Year))
                {
                    str_Filter += string.Format(" And (SignUpDate >= '{0}-1-1' and SignUpDate<='{0}-12-31 23:59:59.997')", this.myEventArgs_ShipClassification.str_Year);
                }
            }
            else
            {
                str_Filter = this.myEventArgs_ShipClassification.str_Filter;
            }
            Class_Data myClass_Data;

            if (this.myEventArgs_ShipClassification.bool_GXTheory)
            {
                Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.GXTheoryIssue.ToString(), false);
                myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.GXTheoryIssue.ToString()];
            }
            else
            {
                Class_DataControlBind.InitializeDataGridView(this.dataGridView_Data, Enum_DataTable.Issue.ToString(), false);
                myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Issue.ToString()];
            }

            if (Class_CustomUser.GetSecurity(Class_zwjPublic.myClass_CustomUser.UserGUID, Class_CustomSecurity.GetSecurityGUID("焊工权限"), Enum_zwjKindofUpdate.Read))
            {
            }
            else if (Class_CustomUser.GetSecurity(Class_zwjPublic.myClass_CustomUser.UserGUID, Class_CustomSecurity.GetSecurityGUID("报考权限"), Enum_zwjKindofUpdate.Read))
            {
                Class_Data myClass_Data_KindofEmployer = (Class_Data)Class_Public.myHashtable[Enum_DataTable.KindofEmployer.ToString()];
                string     str_Filter_KindofEmployer   = "(1=0";
                foreach (DataRowView myDataRowView_KindofEmployer in myClass_Data_KindofEmployer.myDataView)
                {
                    Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(myDataRowView_KindofEmployer["KindofEmployer"].ToString());
                    if (myClass_KindofEmployer.KindofEmployerManagerID.Equals(Class_zwjPublic.myClass_CustomUser.UserGUID))
                    {
                        str_Filter_KindofEmployer += string.Format(" or KindofEmployer='{0}'", myClass_KindofEmployer.KindofEmployer);
                    }
                }
                str_Filter_KindofEmployer += ")";
                str_Filter = str_Filter_KindofEmployer + " and (" + str_Filter + ")";
            }


            myClass_Data.SetFilter(str_Filter);
            if (this.myEventArgs_ShipClassification.bool_JustFill)
            {
                if (this.myDataTable.Rows.Count == 0)
                {
                    this.dataGridView_Data.DataSource = null;
                    myClass_Data.RefreshData(this.myEventArgs_ShipClassification.bool_JustFill);
                    this.myDataTable = myClass_Data.myDataTable.Copy();
                    this.myDataView  = new DataView(this.myDataTable);
                    this.dataGridView_Data.DataSource = this.myDataView;
                    if (this.dataGridView_Data.Rows.Count > 0)
                    {
                        this.dataGridView_Data.CurrentCell = this.dataGridView_Data.Rows[this.dataGridView_Data.Rows.Count - 1].Cells["IssueNo"];
                    }
                }
                else
                {
                    myClass_Data.RefreshData(this.myEventArgs_ShipClassification.bool_JustFill, this.myDataTable);
                }
            }
            else
            {
                this.dataGridView_Data.DataSource = null;
                myClass_Data.RefreshData(this.myEventArgs_ShipClassification.bool_JustFill);
                this.myDataTable = myClass_Data.myDataTable.Copy();
                this.myDataView  = new DataView(this.myDataTable);
                this.dataGridView_Data.DataSource = this.myDataView;
                if (this.dataGridView_Data.Rows.Count > 0)
                {
                    this.dataGridView_Data.CurrentCell = this.dataGridView_Data.Rows[this.dataGridView_Data.Rows.Count - 1].Cells["IssueNo"];
                }
            }
            if (string.IsNullOrEmpty(((DataView)this.dataGridView_Data.DataSource).Sort))
            {
                ((DataView)this.dataGridView_Data.DataSource).Sort = myClass_Data.myDataView.Sort;
            }
            this.label_Data.Text = string.Format("班级,({0}):", this.dataGridView_Data.RowCount);
            if (this.dataGridView_Data.RowCount == 0)
            {
                EventArgs_Issue my_e = new EventArgs_Issue(null, this.myEventArgs_ShipClassification.bool_GXTheory);
                Publisher_Issue.OnEventName(my_e);
            }
        }
예제 #11
0
        /// <summary>
        /// 初始化数据
        /// </summary>
        /// <param name="myKindofEmployer"></param>
        /// <param name="bool_Add"></param>
        public void InitControl(Class_KindofEmployer myClass_KindofEmployer, bool bool_Add)
        {
            Class_Data myClass_Data;

            myClass_Data                  = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Employer.ToString()];
            this.myDataView_Employer      = new DataView(myClass_Data.myDataTable);
            this.myDataView_Employer.Sort = myClass_Data.myDataView.Sort;

            myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.Department.ToString()];
            this.myDataView_Department      = new DataView(myClass_Data.myDataTable);
            this.myDataView_Department.Sort = myClass_Data.myDataView.Sort;

            myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.WorkPlace.ToString()];
            this.myDataView_WorkPlace      = new DataView(myClass_Data.myDataTable);
            this.myDataView_WorkPlace.Sort = myClass_Data.myDataView.Sort;

            myClass_Data = (Class_Data)Class_Public.myHashtable[Enum_DataTable.LaborServiceTeam.ToString()];
            this.myDataView_LaborServiceTeam      = new DataView(myClass_Data.myDataTable);
            this.myDataView_LaborServiceTeam.Sort = myClass_Data.myDataView.Sort;

            Class_DataControlBind.InitializeComboBox(this.ComboBox_LaborServiceTeam, this.myDataView_LaborServiceTeam, "LaborServiceTeamHPID", "LaborServiceTeam");
            Class_DataControlBind.InitializeComboBox(this.ComboBox_WorkPlace, this.myDataView_WorkPlace, "WorkPlaceHPID", "WorkPlace");
            Class_DataControlBind.InitializeComboBox(this.ComboBox_Department, this.myDataView_Department, "DepartmentHPID", "Department");
            Class_DataControlBind.InitializeComboBox(this.ComboBox_Employer, this.myDataView_Employer, "EmployerHPID", "Employer");

            this.myClass_KindofEmployer = myClass_KindofEmployer;
            if (bool_Add)
            {
                if (myClass_KindofEmployerDefault != null)
                {
                    this.TextBox_KindofEmployer.Text = myClass_KindofEmployerDefault.KindofEmployer;
                }
            }
            else
            {
                this.TextBox_KindofEmployer.ReadOnly = true;
                this.TextBox_KindofEmployer.Text     = myClass_KindofEmployer.KindofEmployer;
                Class_CustomUser myClass_CustomUser = new Class_CustomUser();
                myClass_CustomUser.UserGUID = this.myClass_KindofEmployer.KindofEmployerManagerID;
                if (myClass_CustomUser.FillData())
                {
                    this.textBox_KindofEmployerManager.Text = string.Format("{0}:{1}", myClass_CustomUser.Name, myClass_CustomUser.UserGUID.ToString());
                }
                if (myClass_KindofEmployer.KindofEmployerLevel >= this.NumericUpDown_KindofEmployerLevel.Minimum && myClass_KindofEmployer.KindofEmployerLevel <= this.NumericUpDown_KindofEmployerLevel.Maximum)
                {
                    this.NumericUpDown_KindofEmployerLevel.Value = myClass_KindofEmployer.KindofEmployerLevel;
                }
                this.ComboBox_Employer.SelectedValue       = myClass_KindofEmployer.KindofEmployerEmployerHPID;
                this.myDataView_Department.RowFilter       = string.Format("EmployerHPID='{0}'", myClass_KindofEmployer.KindofEmployerEmployerHPID);
                this.myDataView_LaborServiceTeam.RowFilter = string.Format("EmployerHPID='{0}'", myClass_KindofEmployer.KindofEmployerEmployerHPID);
                if (string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerDepartmentHPID))
                {
                    this.CheckBox_Department.Checked = false;
                    this.CheckBox_WorkPlace.Checked  = false;
                }
                else
                {
                    this.ComboBox_Department.SelectedValue = myClass_KindofEmployer.KindofEmployerDepartmentHPID;
                    this.CheckBox_Department.Checked       = true;
                    this.myDataView_WorkPlace.RowFilter    = string.Format("DepartmentHPID='{0}'", myClass_KindofEmployer.KindofEmployerDepartmentHPID);
                    if (!string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerWorkPlaceHPID))
                    {
                        this.ComboBox_WorkPlace.SelectedValue = myClass_KindofEmployer.KindofEmployerWorkPlaceHPID;
                        this.CheckBox_WorkPlace.Checked       = true;
                    }
                    else
                    {
                        this.CheckBox_WorkPlace.Checked = false;
                    }
                }

                if (string.IsNullOrEmpty(myClass_KindofEmployer.KindofEmployerLaborServiceTeamHPID))
                {
                    this.CheckBox_LaborServiceTeam.Checked = false;
                }
                else
                {
                    this.ComboBox_LaborServiceTeam.SelectedValue = myClass_KindofEmployer.KindofEmployerLaborServiceTeamHPID;
                    this.CheckBox_LaborServiceTeam.Checked       = true;
                }
                this.checkBox_CanUpLoadWelderPicture.Checked = myClass_KindofEmployer.CanUpLoadWelderPicture;
                this.checkBox_CanModifyWelderPicture.Checked = myClass_KindofEmployer.CanModifyWelderPicture;
                this.checkBox_CanDeleteWelderPicture.Checked = myClass_KindofEmployer.CanDeleteWelderPicture;
                this.numericUpDown_KindofEmployerIndex.Value = this.myClass_KindofEmployer.KindofEmployerIndex;
                this.TextBox_KindofEmployerRemark.Text       = myClass_KindofEmployer.KindofEmployerRemark;

                this.textBox_EmployerTel.Text    = myClass_KindofEmployer.KindofEmployerTel;
                this.textBox_EmployerFax.Text    = myClass_KindofEmployer.KindofEmployerFax;
                this.textBox_EmployerMobile.Text = myClass_KindofEmployer.KindofEmployerMobile;
                this.textBox_EmployerEmail.Text  = myClass_KindofEmployer.KindofEmployerEmail;
            }
        }
예제 #12
0
        private void toolStripMenuItem_RowSynchronizationhdhr_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("确认同步用友数据吗?", "确认窗口", MessageBoxButtons.OKCancel) != DialogResult.OK)
            {
                return;
            }
            string         str_SQL           = "SELECT docname FROM [hdhr].[dbo].[v_defdoc_xueli]";
            SqlDataAdapter myAdapter         = new SqlDataAdapter(str_SQL, Properties.Settings.Default.zwjConnhdhr);
            DataTable      myDataTable_xueli = new DataTable();

            myAdapter.Fill(myDataTable_xueli);
            Class_Schooling myClass_Schooling = new Class_Schooling();

            foreach (DataRow myDataRow in myDataTable_xueli.Rows)
            {
                if (!Class_Schooling.ExistAndCanDeleteAndDelete(myDataRow["docname"].ToString(), Enum_zwjKindofUpdate.Exist))
                {
                    myClass_Schooling.Schooling = myDataRow["docname"].ToString();
                    myClass_Schooling.AddAndModify(Enum_zwjKindofUpdate.Add);
                }
            }

            str_SQL = "SELECT [ryid],[ryxm],[ryxb],[xlmc],[rygh],[jcrq],[gsmc],[bmmc],[kscj],[lwgs] FROM [hdhr].[dbo].[v_psninfo_to_hangong]";
            Class_KindofEmployer myClass_KindofEmployer = new Class_KindofEmployer(this.myEventArgs_KindofEmployer.str_KindofEmployer);
            Class_Employer       myClass_Employer       = new Class_Employer(myClass_KindofEmployer.KindofEmployerEmployerHPID);
            Class_Department     myClass_Department     = new Class_Department(myClass_KindofEmployer.KindofEmployerDepartmentHPID);
            Class_WorkPlace      myClass_WorkPlace      = new Class_WorkPlace(myClass_KindofEmployer.KindofEmployerWorkPlaceHPID);

            switch (myClass_KindofEmployer.KindofEmployerLevel)
            {
            case 1:
                str_SQL += string.Format(" where gsmc='{0}'", myClass_Employer.Employer);
                break;

            case 2:
                str_SQL += string.Format(" where gsmc='{0}' and bmmc='{1}'", myClass_Employer.Employer, myClass_Department.Department);
                break;

            case 3:
                str_SQL += string.Format(" where gsmc='{0}' and bmmc='{1}' and kscj='{2}'", myClass_Employer.Employer, myClass_Department.Department, myClass_WorkPlace.WorkPlace);
                break;

            default:
                return;
            }
            myAdapter = new SqlDataAdapter(str_SQL, Properties.Settings.Default.zwjConnhdhr);
            DataTable myDataTable_hdhrhangong = new DataTable();

            myAdapter.Fill(myDataTable_hdhrhangong);
            Class_KindofEmployerWelder myClass_KindofEmployerWelder = new Class_KindofEmployerWelder();

            myClass_KindofEmployerWelder.KindofEmployer = myClass_KindofEmployer.KindofEmployer;
            string        str_Err;
            int           i_success           = 0;
            int           i_success_add       = 0;
            int           i_success_modify    = 0;
            int           i_success_delete    = 0;
            int           i_fail              = 0;
            StringBuilder myStringBuilder_err = new StringBuilder();

            foreach (DataRow myDataRow in this.myDataTable.Rows)
            {
                if (myDataTable_hdhrhangong.Select(string.Format("ryid='{0}'", myDataRow["IdentificationCard"])).GetLength(0) == 0)
                {
                    Class_KindofEmployerWelder.ExistAndCanDeleteAndDelete((int)myDataRow["KindofEmployerWelderID"], Enum_zwjKindofUpdate.Delete);
                    i_success_delete++;
                }
            }

            foreach (DataRow myDataRow in myDataTable_hdhrhangong.Rows)
            {
                myClass_KindofEmployerWelder.IdentificationCard = myDataRow["ryid"].ToString();
                myClass_KindofEmployerWelder.WelderName         = myDataRow["ryxm"].ToString();
                myClass_KindofEmployerWelder.Sex       = myDataRow["ryxb"].ToString();
                myClass_KindofEmployerWelder.Schooling = myDataRow["xlmc"].ToString();
                if (!DateTime.TryParse(myDataRow["jcrq"].ToString(), out myClass_KindofEmployerWelder.WeldingBeginning))
                {
                    myClass_KindofEmployerWelder.WeldingBeginning = DateTime.Now;
                }
                myClass_KindofEmployerWelder.myClass_BelongUnit.WorkerID     = myDataRow["rygh"].ToString();
                myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID = Class_Employer.GetEmployerHPID(myDataRow["gsmc"].ToString());
                if (string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID))
                {
                    i_fail++;
                    myStringBuilder_err.Append(string.Format("\n身份证号码:{0}, 错误信息:公司名称不符", myClass_KindofEmployerWelder.IdentificationCard));
                    continue;
                }
                else
                {
                    myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID = Class_Department.GetDepartmentHPID(myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID, myDataRow["bmmc"].ToString());
                    if (string.IsNullOrEmpty(myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID))
                    {
                        myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID = null;
                    }
                    else
                    {
                        myClass_KindofEmployerWelder.myClass_BelongUnit.WorkPlaceHPID = Class_WorkPlace.GetWorkPlaceHPID(myClass_KindofEmployerWelder.myClass_BelongUnit.DepartmentHPID, myDataRow["kscj"].ToString());
                    }
                    myClass_KindofEmployerWelder.myClass_BelongUnit.LaborServiceTeamHPID = Class_LaborServiceTeam.GetLaborServiceTeamHPID(myClass_KindofEmployerWelder.myClass_BelongUnit.EmployerHPID, myDataRow["lwgs"].ToString());
                }
                str_Err = myClass_KindofEmployerWelder.CheckField();
                if (string.IsNullOrEmpty(str_Err))
                {
                    if (Class_KindofEmployerWelder.ExistSecond(myClass_KindofEmployerWelder.KindofEmployer, myClass_KindofEmployerWelder.IdentificationCard, 0, Enum_zwjKindofUpdate.Add))
                    {
                        myClass_KindofEmployerWelder.KindofEmployerWelderID = Class_KindofEmployerWelder.GetKindofEmployerWelderID(myClass_KindofEmployerWelder.KindofEmployer, myClass_KindofEmployerWelder.IdentificationCard);
                        myClass_KindofEmployerWelder.AddAndModify(Enum_zwjKindofUpdate.Modify);
                        i_success_modify++;
                        i_success++;
                    }
                    else
                    {
                        myClass_KindofEmployerWelder.AddAndModify(Enum_zwjKindofUpdate.Add);
                        i_success_add++;
                        i_success++;
                        if (!Class_Welder.ExistAndCanDeleteAndDelete(myClass_KindofEmployerWelder.IdentificationCard, Enum_zwjKindofUpdate.Exist))
                        {
                            Class_Welder myClass_Welder = new Class_Welder();
                            myClass_Welder.IdentificationCard = myClass_KindofEmployerWelder.IdentificationCard;
                            myClass_Welder.Schooling          = myClass_KindofEmployerWelder.Schooling;
                            myClass_Welder.Sex                = myClass_KindofEmployerWelder.Sex;
                            myClass_Welder.WelderName         = myClass_KindofEmployerWelder.WelderName;
                            myClass_Welder.WeldingBeginning   = myClass_KindofEmployerWelder.WeldingBeginning;
                            myClass_Welder.myClass_BelongUnit = myClass_KindofEmployerWelder.myClass_BelongUnit;
                            myClass_Welder.AddAndModify(Enum_zwjKindofUpdate.Add);
                        }
                    }
                }
                else
                {
                    i_fail++;
                    myStringBuilder_err.Append(string.Format("\n身份证号码:{0}, 错误信息:{1}", myClass_KindofEmployerWelder.IdentificationCard, str_Err));
                }
            }
            this.RefreshData(false);
            MessageBox.Show(string.Format("操作完成,其中同步成功{0}条,添加{1}条,删除{2}条,失败{3}条,失败原因如下:\n{4}", i_success, i_success_add, i_success_delete, i_fail, myStringBuilder_err.ToString()));
        }
예제 #13
0
 private void toolStripMenuItem_RowWelderFluxion_Click(object sender, EventArgs e)
 {
     ZCCL.Tools.Form_DataView myForm = new ZCCL.Tools.Form_DataView();
     myForm.InitDataGridView("流失焊工考试记录", new DataView(Class_KindofEmployer.GetDataTable_WelderFluxion(this.myEventArgs_KindofEmployer.str_KindofEmployer)), Enum_DataTable.WelderIssueStudentQCRegistrationNo.ToString());
     myForm.ShowDialog();
 }