基于C#+Oracle的考勤管理系统的设计与开发

基于C#+Oracle的考勤管理系统的设计与开发

{

string[] temp = { dgvKQGL.SelectedRows[0].Cells[1].Value.ToString(), dgvKQGL.SelectedRows[0].Cells[2].Value.ToString() }; string YGBH = temp[0].Substring(0, temp[0].IndexOf(\)); string LXBH = temp[1].Substring(0, temp[1].IndexOf(\));

for (int i = 0; i < table1.Rows.Count; ++i) if (Convert.ToDateTime(table1.Rows[i][\]) ==

Convert.ToDateTime(dgvKQGL.SelectedRows[0].Cells[0].Value)) {

tbBZ.Text = dgvKQGL.SelectedRows[0].Cells[3].Value.ToString(); break; }

for (int i = 0; i < table2.Rows.Count; ++i) if (table2.Rows[i][\].ToString() == YGBH) {

cbYG.SelectedIndex = i; break; }

for (int i = 0; i < table3.Rows.Count; ++i) if (table3.Rows[i][\].ToString() == LXBH) {

cbCQQK.SelectedIndex = i; break; } } else {

cbYG.SelectedIndex = 0; cbCQQK.SelectedIndex = 0; tbBZ.Text = \; } }

///

private void dtpTIME_CloseUp(object sender, EventArgs e) {

type = \;

第 29 页 共 44 页

基于C#+Oracle的考勤管理系统的设计与开发

string time = dtpTIME.Value.Day + \ + dtpTIME.Value.Month + \月-\ + dtpTIME.Value.Year;

table1 = Program.ConnRead(\KQRQ, YGBH, XM, LXBH, LX, BZ from KQLXB, YGB, KQGLB where YGBH=YGB.BH and LXBH=KQLXB.BH and KQRQ='\ + time + \); BindData(); type = \; ChangeInfo(); }

///

private void dgvKQGL_SelectionChanged(object sender, EventArgs e) {

ChangeInfo(); }

///

private void btnZJ_Click(object sender, EventArgs e) {

isbj = true; type = \;

cbYG.SelectedIndex = 0; cbCQQK.SelectedIndex = 0; tbBZ.Text = \; ChangeEnabled(); }

///

private void btnXG_Click(object sender, EventArgs e) {

isbj = true; type = \;

第 30 页 共 44 页

基于C#+Oracle的考勤管理系统的设计与开发

ChangeEnabled(); cbYG.Enabled = false; }

///

private void btnBC_Click(object sender, EventArgs e) {

if (type == \) {

for (int i = 0; i < dgvKQGL.Rows.Count; ++i)

if (cbYG.Text == dgvKQGL.Rows[i].Cells[1].Value.ToString()) {

MessageBox.Show(\今天已有该员工的出勤记录。\, \提示\, MessageBoxButtons.OK, MessageBoxIcon.Information); dgvKQGL.Rows[i].Selected = true; type = \;

cbYG.Enabled = false;

}

}

string sql = \;

string time = dtpTIME.Value.Day + \ + dtpTIME.Value.Month + \月-\ + dtpTIME.Value.Year; if (type == \)

sql = \ + time + \ + table2.Rows[cbYG.SelectedIndex][\] + \ +

table3.Rows[cbCQQK.SelectedIndex][\] + \ + tbBZ.Text + \; else if (type == \)

sql = \ + cbCQQK.Text.Substring(0,

cbCQQK.Text.IndexOf(\)) + \ + tbBZ.Text + \ + time + \ + cbYG.Text.Substring(0, cbYG.Text.IndexOf(\\)) + \; else

return;

第 31 页 共 44 页

return;

基于C#+Oracle的考勤管理系统的设计与开发

if (Program.ConnNonRead(sql) > 0) {

if (type == \) {

dgvKQGL.Rows.Add();

dgvKQGL.Rows[dgvKQGL.Rows.Count - 1].Cells[0].Value = dtpTIME.Value.ToLongDateString();

dgvKQGL.Rows[dgvKQGL.Rows.Count - 1].Cells[1].Value = cbYG.Text; dgvKQGL.Rows[dgvKQGL.Rows.Count - 1].Cells[2].Value = cbCQQK.Text;

dgvKQGL.Rows[dgvKQGL.Rows.Count - 1].Cells[3].Value = tbBZ.Text; dgvKQGL.Rows[dgvKQGL.Rows.Count - 1].Selected = true;

MessageBox.Show(\添加成功。\, \提示\, MessageBoxButtons.OK, MessageBoxIcon.Information); } else {

for (int i = 0; i < dgvKQGL.Rows.Count; ++i)

if (dgvKQGL.Rows[i].Cells[1].Value.ToString() == cbYG.Text) {

dgvKQGL.Rows[i].Cells[2].Value = cbCQQK.Text; dgvKQGL.Rows[i].Cells[3].Value = tbBZ.Text;

}

MessageBox.Show(\修改成功。\, \提示\, MessageBoxButtons.OK, MessageBoxIcon.Information); }

isbj = false; type = \; ChangeInfo(); ChangeEnabled(); cbYG.Enabled = true; } else {

第 32 页 共 44 页

break;