コード例 #1
0
ファイル: FrmEmploye.cs プロジェクト: 51erp/commission
        private void JobDeptChange()
        {
            if (dataGridView_Employe.CurrentRow == null)
            {
                Prompt.Warning("未选择员工记录!");
                return;
            }

            string salesID    = string.Empty;
            string salesName  = string.Empty;
            string deptID     = string.Empty;
            string deptName   = string.Empty;
            string changeDate = string.Empty;
            string jobType    = string.Empty;

            salesID   = dataGridView_Employe.CurrentRow.Cells["ColID"].Value.ToString();
            salesName = dataGridView_Employe.CurrentRow.Cells["ColSalesName"].Value.ToString();

            FrmOrganization destDept = new FrmOrganization();

            destDept.Text    = "请选择调岗信息";
            destDept.FrmMode = FormMode.view;

            destDept.SalesID = salesID;
            destDept.DeptID  = treeView_Dept.SelectedNode.Name;
            destDept.JobType = dataGridView_Employe.CurrentRow.Cells["ColJobType"].Value.ToString();

            if (destDept.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                bool isOnlyTitle = destDept.DeptID == treeView_Dept.SelectedNode.Name;

                deptID     = destDept.DeptID;
                deptName   = destDept.DeptName;
                changeDate = destDept.ChangeDate;
                jobType    = destDept.JobType;

                ExecChange(isOnlyTitle, salesID, salesName, changeDate, deptID, deptName, jobType);
            }
        }
コード例 #2
0
ファイル: FrmEmploye.cs プロジェクト: 51erp/commission
        private void JobTrack(int type = 0)
        {
            string changeDate = string.Empty;

            if (dataGridView_Employe.CurrentRow == null)
            {
                Prompt.Warning("未选择员工记录!");
                return;
            }

            FrmJobChangeDate frmDate = new FrmJobChangeDate();

            if (frmDate.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                string sql       = string.Format("select Convert(varchar(10), BeginDate, 120) from JobTrack where SalesID = {0} and EndDate is null", dataGridView_Employe.CurrentRow.Cells["ColID"].Value.ToString());
                object objResult = SqlHelper.ExecuteScalar(sql);
                if (objResult != null && objResult != System.DBNull.Value)
                {
                    if (DateTime.Parse(frmDate.ChangeDate) < DateTime.Parse(objResult.ToString()))
                    {
                        Prompt.Warning("调岗日期不能小于当前部门的调入日期!");
                        return;
                    }
                    else
                    {
                        changeDate = frmDate.ChangeDate;
                    }
                }
            }

            FrmOrganization destDept = new FrmOrganization();

            destDept.Text = "请选择调入部门";
            if (destDept.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                using (SqlConnection connection = SqlHelper.OpenConnection())
                {
                    SqlTransaction sqlTran = connection.BeginTransaction();
                    SqlCommand     cmd     = connection.CreateCommand();
                    cmd.Transaction = sqlTran;

                    try
                    {
                        switch (type)
                        {
                        case  0:     //调岗
                            cmd.CommandText = string.Format("update JobTrack set EndDate = '{0}' where SalesID = {1} and DeptID = {2} and EndDate is null",
                                                            changeDate, dataGridView_Employe.CurrentRow.Cells["ColID"].Value.ToString(), dataGridView_Employe.CurrentRow.Cells["ColDeptID"].Value.ToString());

                            cmd.ExecuteNonQuery();

                            cmd.CommandText = string.Format("insert into JobTrack (SalesID, DeptID, DeptName, JobType, BeginDate) values ({0},{1},'{2}','{3}','{4}')",
                                                            dataGridView_Employe.CurrentRow.Cells["ColID"].Value.ToString(),
                                                            destDept.DeptID,
                                                            destDept.DeptName,
                                                            dataGridView_Employe.CurrentRow.Cells["ColJobType"].Value.ToString(), changeDate);

                            cmd.ExecuteNonQuery();

                            break;

                        case 1:     //调入
                            cmd.CommandText = string.Format("insert into JobTrack (SalesID, DeptID, DeptName, JobType, BeginDate) values ({0},{1},'{2}','{3}', '{4}')",
                                                            dataGridView_Employe.CurrentRow.Cells["ColID"].Value.ToString(),
                                                            destDept.DeptID,
                                                            destDept.DeptName,
                                                            dataGridView_Employe.CurrentRow.Cells["ColJobType"].Value.ToString(), changeDate);

                            cmd.ExecuteNonQuery();

                            break;

                        default:
                            break;
                        }

                        sqlTran.Commit();

                        if (type == 0)
                        {
                            dataGridView_Employe.Rows.RemoveAt(dataGridView_Employe.CurrentRow.Index);
                        }

                        Prompt.Information("操作成功!");
                    }
                    catch (Exception ex)
                    {
                        sqlTran.Rollback();
                        Prompt.Error("操作失败, 错误:" + ex.Message);
                    }
                }
            }
        }