private void btnDelet_Click(object sender, EventArgs e) { if (grdView.DataSource == null) { MessageBox.Show("请先选中数据"); } else { string Confirm = string.Format("确认删除编号{0},{1}?", grdView[0, grdView.SelectedCells[0].RowIndex].Value.ToString(), grdView[1, grdView.SelectedCells[1].RowIndex].Value.ToString()); DialogResult dr = MessageBox.Show(Confirm, "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { string id_; string name; int index = 0; string tmp = "delete from z_tmp_user where id_='" + grdView[index, grdView.SelectedCells[0].RowIndex].Value.ToString() + "'"; dbIntface dao = dbFactory.GetDataBase(ComClass.m_DB_Source, ComClass.m_DB_User, ComClass.m_DB_Pwd); dao.ExecuteNonQuery(tmp); id_ = grdView[0, grdView.SelectedCells[0].RowIndex].Value.ToString(); name = grdView[1, grdView.SelectedCells[1].RowIndex].Value.ToString(); log.InfoFormat("删除:编号{0},姓名{1}", id_, name); } } btnQuery_Click(null, null); }
private void btnSubmit_Click(object sender, EventArgs e) { string strCName = txtCNAME.Text.Trim(); if (state == 1) { if (strCName.Length == 0) { MessageBox.Show("请输入课程名称"); } string strSql = "select CID_ from z_tmp_CourseSum"; DataTable dt = new DataTable(); dt = dao.GetDataTable(strSql); int[] arrayA = new int[dt.Rows.Count]; for (int x = 0; x < dt.Rows.Count; x++) { DataRow dr2 = dt.Rows[x]; arrayA[x] = Convert.ToInt16(dr2["CID_"]); } int strId = GetNextID(arrayA); int Cou = 0; string strsql = "insert into z_tmp_CourseSum (CID_,Cname_) values('" + strId + "','" + strCName + "')"; try { Cou = dao.ExecuteNonQuery(strsql); } catch (Exception ex) { log.Error(ex); } if (Cou > 0) { MessageBox.Show("保存成功!"); this.Close(); log.InfoFormat("添加用户{0}", strCName); } else { MessageBox.Show("保存失败!"); } } if (state == 2) { if (strCName.Length == 0) { MessageBox.Show("请输入课程名称"); } string sql = "update z_tmp_CourseSum set Cname_='" + strCName + "' where CID_='" + arr[0] + "'"; int cou = 0; try { cou = dao.ExecuteNonQuery(sql); } catch (Exception ex) { log.Error(ex); } if (cou > 0) { MessageBox.Show("保存成功!"); this.Close(); log.Debug("修改操作"); } else { MessageBox.Show("保存失败!"); } } }
private void btnSubmit_Click(object sender, EventArgs e) { string strName = txtName.Text.Trim(); string strC1 = CoBoxC1.Text.Trim(); string strC2 = CoBoxC2.Text.Trim(); string strDay = CoBoxDay.Text.Trim(); string strCL1 = CoBoxCL1.Text.Trim(); string strCL2 = CoBoxCL2.Text.Trim(); if (states == 1) { if (strName.Length == 0) { MessageBox.Show("请输入姓名"); return; } if (strC1.Length == 0) { MessageBox.Show("请选择负责课程一"); return; } if (strC2.Length == 0) { MessageBox.Show("请选择负责课程二"); return; } if (strDay.Length == 0) { MessageBox.Show("请输入休假日期"); return; } if (strCL1.Length == 0) { MessageBox.Show("请输入负责课程一"); return; } if (strCL2.Length == 0) { MessageBox.Show("请输入负责课程二"); return; } if (strC1 == strC2) { MessageBox.Show("所选择的两门课程不能相同!"); return; } if (strCL1 == strCL2) { MessageBox.Show("所选择的两负责班级不能相同!"); return; } if (OccupyCheck(strC1, strC2, strCL1, strCL2) == false) { string message = string.Format("{0},{1}班级已存在负责课程{2}或{3}的老师", strCL1, strCL2, strC1, strC2); MessageBox.Show(message); } else { int Cou = 0; string Sql = "insert into z_tmp_teacherinfo (tid_,tname_,course1_,course2_,timeoff,CClass1,CClass2) values(seq_teacher.nextval,'" + strName + "','" + strC1 + "','" + strC2 + "','" + strDay + "','" + strCL1 + "','" + strCL2 + "')"; try { Cou = dao.ExecuteNonQuery(Sql); } catch (Exception ex) { log.Error(ex); } if (Cou > 0) { MessageBox.Show("保存成功!"); this.Close(); log.InfoFormat("添加用户{0}", strName); } else { MessageBox.Show("保存失败!"); } } } if (states == 2) { if (strName.Length == 0) { MessageBox.Show("请输入姓名"); } if (strC1.Length == 0) { MessageBox.Show("请输入负责课程一"); } if (strC2.Length == 0) { MessageBox.Show("请输入负责课程二"); } if (strDay.Length == 0) { MessageBox.Show("请输入休假日期"); } if (strCL1.Length == 0) { MessageBox.Show("请输入负责课程一"); } if (strCL2.Length == 0) { MessageBox.Show("请输入负责课程二"); } if (strC1 == strC2) { MessageBox.Show("所选择的两门课程不能相同!"); return; } if (strCL1 == strCL2) { MessageBox.Show("所选择的两负责班级不能相同!"); return; } if (strC1 == strC2) { MessageBox.Show("所选择的两门课程不能相同!"); return; } if (strCL1 == strCL2) { MessageBox.Show("所选择的两负责班级不能相同!"); return; } if (OccupyCheck(strC1, strC2, strCL1, strCL2) == false) { string message = string.Format("{0},{1}班级已存在负责课程{2}或{3}的老师", strCL1, strCL2, strC1, strC2); MessageBox.Show(message); } else { string sql = "update z_tmp_teacherinfo set tname_='" + strName + "',course1_='" + strC1 + "',course2_='" + strC2 + "',timeoff='" + strDay + "',CClass1='" + strCL1 + "',CClass2='" + strCL2 + "' where tid_ = '" + arr[0] + "'"; int cou = 0; try { cou = dao.ExecuteNonQuery(sql); } catch (Exception ex) { log.Error(ex); } if (cou > 0) { MessageBox.Show("保存成功!"); this.Close(); log.Debug("修改操作"); } else { MessageBox.Show("保存失败!"); } } } }
private void btnSubmit_Click(object sender, EventArgs e) { string strUserName = txtName.Text.Trim(); string strUserDep = txtDep.Text.Trim(); string strUserPhone = txtPhone.Text.Trim(); string strUserCountry = txtCountry.Text.Trim(); string strGED = ""; if (status == 0) { if (strUserName.Length == 0) { MessageBox.Show("请输入姓名!"); txtName.Focus(); return; } if (strUserName.Length > 30) { MessageBox.Show("姓名过长!"); txtName.Focus(); return; } if (strUserDep.Length == 0) { MessageBox.Show("请输入部门!"); txtDep.Focus(); return; } if (strUserDep.Length > 30) { MessageBox.Show("部门名字过长!"); txtDep.Focus(); return; } if (strUserCountry.Length == 0) { MessageBox.Show("请输入国籍!"); txtCountry.Focus(); return; } if (strUserCountry.Length > 30) { MessageBox.Show("国家名字过长!"); txtCountry.Focus(); return; } if (strUserPhone.Length == 0) { MessageBox.Show("请输入手机号!"); txtPhone.Focus(); return; } if (strUserPhone.Length > 11) { MessageBox.Show("手机号非法"); txtPhone.Focus(); return; } if (comboBox1.SelectedIndex == 0) { strGED = "男"; } if (comboBox1.SelectedIndex == 1) { strGED = "女"; } if (strGED == "") { MessageBox.Show("请输入性别!"); return; } string StrRegTime = DateTime.Now.ToString("yyyy-MM-dd"); dbIntface dao = dbFactory.GetDataBase(ComClass.m_DB_Source, ComClass.m_DB_User, ComClass.m_DB_Pwd); string strSql1 = "alter session set nls_date_format = 'yyyy/mm/dd'"; //初始化日期格式 string strSql2 = "select ID_ from z_tmp_user"; DataTable dt = new DataTable(); dt = dao.GetDataTable(strSql2); string strSql3 = "insert into z_tmp_user(id_, uname_, dep_,country_,phone_,regdate_,gender_)values(seq_z_tmp_user.nextval,'" + strUserName + "', '" + strUserDep + "','" + strUserCountry + "','" + strUserPhone + "','" + StrRegTime + "','" + strGED + "')"; int nCou1 = 0; log.InfoFormat("添加新员工{0}", strUserName); try { dao.ExecuteNonQuery(strSql1); nCou1 = dao.ExecuteNonQuery(strSql3); } catch (Exception ex) { log.ErrorFormat("错误:{0}", ex.Message); } if (nCou1 > 0) { MessageBox.Show("保存成功!"); this.Close(); } else { MessageBox.Show("保存失败!"); } } if (status == 1) { if (comboBox1.SelectedIndex == 0) { strGED = "男"; } if (comboBox1.SelectedIndex == 1) { strGED = "女"; } dbIntface dao = dbFactory.GetDataBase(ComClass.m_DB_Source, ComClass.m_DB_User, ComClass.m_DB_Pwd); string strSql = "update z_tmp_user set uname_='" + strUserName + "',dep_='" + strUserDep + "', phone_='" + strUserPhone + "', country_='" + strUserCountry + "' ,gender_='" + strGED + "' where id_ = '" + arr[0] + "'"; int nCou = 0; log.Debug("修改操作"); try { nCou = dao.ExecuteNonQuery(strSql); } catch (Exception ex) { log.Error(ex); } if (nCou > 0) { MessageBox.Show("修改成功!"); } else { MessageBox.Show("修改失败!"); } } }
private void truncateTable() { string sql = "truncate table z_tmp_TimeTable"; dao.ExecuteNonQuery(sql); }