private void comboBoxEdit_Grade_SelectedIndexChanged(object sender, System.EventArgs e) { comboBoxEdit_Class.Properties.Items.Clear(); // comboBoxEdit_Class.Text = ""; comboBoxEdit_Class.Properties.Items.Add("全部"); comboBoxEdit_Class.SelectedItem = "全部"; DataSet gradeInfo = new GradeSystem().GetGradeInfoList(1); DataSet classInfo = new ClassSystem().GetClassInfoList(); if(classInfo.Tables[0].Rows.Count>0) { if(comboBoxEdit_Grade.SelectedItem.ToString().Equals("全部")) { foreach(DataRow classes in classInfo.Tables[0].Rows) { comboBoxEdit_Class.Properties.Items.Add(classes["info_className"].ToString()); } } else { foreach(DataRow grade in gradeInfo.Tables[0].Rows) { if(grade["info_gradeName"].ToString().Equals(comboBoxEdit_Grade.SelectedItem.ToString())) { foreach(DataRow classes in classInfo.Tables[0].Rows) { if(Convert.ToInt32(classes["info_gradeNumber"]) == Convert.ToInt32(grade["info_gradeNumber"])) { comboBoxEdit_Class.Properties.Items.Add(classes["info_className"].ToString()); } } } } } } loadPage(new TeacherBaseSystem().SearchTcBaseInfoByCondition(comboBoxEdit_Grade.SelectedItem.ToString().Replace(" ",""), comboBoxEdit_Class.SelectedItem.ToString().Replace(" ",""),textEdit_Name.Text.Replace(" ",""),textEdit_Number.Text.Replace(" ",""))); simpleButton_SaveButton.Enabled = false; }
private void LoadDropDownList() { comboBoxEdit_Grade.Properties.Items.Clear(); tDept.Properties.Items.Clear(); comboBoxEdit_Grade.Properties.Items.Add("全部"); DataSet gradeInfo = new GradeSystem().GetGradeInfoList(1); if(gradeInfo.Tables[0].Rows.Count>0) { foreach(DataRow grade in gradeInfo.Tables[0].Rows) { comboBoxEdit_Grade.Properties.Items.Add(grade["info_gradeName"].ToString()); tDept.Properties.Items.Add(grade["info_gradeName"].ToString()); } } }
private void tDept_SelectedIndexChanged(object sender, System.EventArgs e) { tDuty.Properties.Items.Clear(); DataSet gradeInfo = new GradeSystem().GetGradeInfoList(1); DataSet classInfo = new ClassSystem().GetClassInfoList(); if ( classInfo.Tables[0].Rows.Count > 0 ) { if ( tDept.SelectedIndex != -1 ) { foreach ( DataRow grade in gradeInfo.Tables[0].Rows ) { if ( grade["info_gradeName"].ToString().Equals(tDept.SelectedItem.ToString()) ) { foreach ( DataRow classes in classInfo.Tables[0].Rows ) { if ( Convert.ToInt32(classes["info_gradeNumber"]) == Convert.ToInt32(grade["info_gradeNumber"]) ) tDuty.Properties.Items.AddRange(new object[]{ classes["info_className"].ToString() }); } } } if ( tDuty.Properties.Items.Count == 0 ) tDuty.Text = "班级不存在"; else tDuty.SelectedItem = tDuty.Properties.Items[0].ToString(); } else tDuty.SelectedIndex = -1; } }
//修改年级信息 private void simpleButton_GradeModify_Click(object sender, System.EventArgs e) { // if(DialogResult.Yes != // MessageBox.Show("确认修改?","系统信息!", // MessageBoxButtons.OK,MessageBoxIcon.Warning)) // return; string message = "是否确认修改?"; string caption = "消息提示框!"; DialogResult messageResult = MessageBox.Show(message,caption,MessageBoxButtons.YesNo,MessageBoxIcon.Question); if ( messageResult != DialogResult.Yes ) return; int rowsAffected = 0; Grade grade = new Grade(); grade.GradeID = gradeID; grade.GradeName = comboBoxEdit_GradeModify.SelectedItem.ToString(); grade.GradeRemark = comboBoxEdit_GradeRemarkModify.SelectedItem.ToString(); if(grade.GradeName!=string.Empty) { try { rowsAffected = new GradeSystem().UpdateGradeInfo(grade); if(rowsAffected>0) { MessageBox.Show(radioGroup_Grade.SelectedIndex == 0?"年级名称修改成功":"部门名称修改成功","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Information); gradeDataBinding(); // gradeModifyInfoReset(); } else if(rowsAffected == -1) { MessageBox.Show("年级名称已存在,请重试","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); } else { MessageBox.Show("年级信息修改失败,请重试","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); } } catch(Exception ex) { MessageBox.Show("年级信息修改失败,请重试","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); CPTT.SystemFramework.Util.WriteLog(ex.Message,CPTT.SystemFramework.Util.EXCEPTION_LOG_TITLE); } } else { MessageBox.Show("请先选择要修改的年级","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); } }
//删除年级信息 private void simpleButton_DeleteGrade_Click(object sender, System.EventArgs e) { int rowsAffected = 0; if(comboBoxEdit_GradeModify.SelectedIndex!=-1) { try { rowsAffected = new GradeSystem().DeleteGradeInfo(gradeID); if(rowsAffected>0) { gradeDataBinding(); gradeModifyInfoReset(); } else { MessageBox.Show("年级信息删除失败,请重试","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); } } catch(Exception ex) { MessageBox.Show("年级信息删除失败,请重试","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); CPTT.SystemFramework.Util.WriteLog(ex.Message,CPTT.SystemFramework.Util.EXCEPTION_LOG_TITLE); } } else { MessageBox.Show("请先选择要删除的年级","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); } }
//保存年级信息 private void simpleButton_GradeInfoSave_Click(object sender, System.EventArgs e) { if(textEdit_GradeName.Text.Trim() != string.Empty)//检查数据是否合法 { Grade grade = new Grade(); grade.GradeName = textEdit_GradeName.Text.Trim(); if (comboBoxEdit_gradeNumber.SelectedItem.ToString().Equals("已到达年级最大容量")) { MessageBox.Show("年级容量已经到达最大容量,无法进行添加操作!"); return; } if (radioGroup_Grade.SelectedIndex == 0) grade.GradeID = Convert.ToInt32(comboBoxEdit_gradeNumber.SelectedItem); else grade.GradeID = 0; grade.GradeRemark = comboBoxEdit_GradeRemark.SelectedItem.ToString(); grade.GradeType = radioGroup_Grade.SelectedIndex.ToString(); int rowsAffected = 0; try { rowsAffected = new GradeSystem().InsertGradeInfo(grade); if(rowsAffected > 0) { //清空文本框 resetGradeInfoAdd(); MessageBox.Show("插入成功.","系统信息!",MessageBoxButtons.OK,MessageBoxIcon.Information); gradeDataBinding();//重新绑定年级信息 } else if(rowsAffected == -1) { string info = radioGroup_Grade.SelectedIndex == 0 ? "年级" : "部门"; MessageBox.Show(info+"名称重复,请更改名称后重试","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); } else { MessageBox.Show("插入失败,请重试","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); } } catch(Exception ex) { MessageBox.Show("插入失败,请重试","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Information); CPTT.SystemFramework.Util.WriteLog(ex.Message,CPTT.SystemFramework.Util.EXCEPTION_LOG_TITLE); } } else { MessageBox.Show("*号为必须填写内容,请检查输入","系统信息!", MessageBoxButtons.OK,MessageBoxIcon.Warning); } }
private void comboBoxEdit_Graphic_TeaDept_SelectedIndexChanged(object sender, System.EventArgs e) { comboBoxEdit_Graphic_TeaDuty.Properties.Items.Clear(); comboBoxEdit_Graphic_TeaDuty.Properties.Items.Add("全部"); comboBoxEdit_Graphic_TeaDuty.SelectedItem = "全部"; DataSet deptInfo = new GradeSystem().GetGradeInfoList(1); DataSet dutyInfo = new ClassSystem().GetClassInfoList(); if ( dutyInfo.Tables[0].Rows.Count > 0 ) { if ( comboBoxEdit_Graphic_TeaDept.SelectedItem.ToString().Equals("全部") ) { // foreach ( DataRow duty in dutyInfo.Tables[0].Rows ) // { // comboBoxEdit_Graphic_TeaDuty.Properties.Items.Add(duty["info_className"].ToString()); // } } else { foreach ( DataRow dept in deptInfo.Tables[0].Rows ) { if ( dept["info_gradeName"].ToString().Equals(comboBoxEdit_Graphic_TeaDept.SelectedItem.ToString()) ) { foreach ( DataRow duty in dutyInfo.Tables[0].Rows ) { if(Convert.ToInt32(duty["info_gradeNumber"]) == Convert.ToInt32(dept["info_gradeNumber"])) { comboBoxEdit_Graphic_TeaDuty.Properties.Items.Add(duty["info_className"].ToString()); } } } } } } }
//出勤页面 private void comboBoxEdit_TeaDutyDetailsSearByGrade_SelectedIndexChanged(object sender, System.EventArgs e) { // if(getStuInfoByCondition.getGradeInfo(comboBoxEdit_TeaDutyDetailsSearByGrade.SelectedItem.ToString(),"").Tables[0].Rows.Count > 0) // { // // comboBoxEdit_TeaDutyDetailsSearByClass.Properties.Items.Clear(); // comboBoxEdit_TeaDutyDetailsSearByClass.Properties.Items.AddRange(new object[]{"全部"}); // comboBoxEdit_TeaDutyDetailsSearByClass.SelectedItem = "全部"; // // //根据年级选择获取年级编号 // getGradeNumberFromCombo = getStuInfoByCondition.getGradeInfo( // comboBoxEdit_TeaDutyDetailsSearByGrade.SelectedItem.ToString(),"").Tables[0].Rows[0][0].ToString(); // foreach(DataRow getClassList in getStuInfoByCondition.getClassInfo("","", // getGradeNumberFromCombo).Tables[0].Rows) // { // comboBoxEdit_TeaDutyDetailsSearByClass.Properties.Items.AddRange( // new object[]{getClassList[1].ToString()}); // } // } comboBoxEdit_TeaDutyDetailsSearByClass.Properties.Items.Clear(); comboBoxEdit_TeaDutyDetailsSearByClass.Properties.Items.Add("全部"); comboBoxEdit_TeaDutyDetailsSearByClass.SelectedItem = "全部"; DataSet deptInfo = new GradeSystem().GetGradeInfoList(1); DataSet dutyInfo = new ClassSystem().GetClassInfoList(); if ( dutyInfo.Tables[0].Rows.Count > 0 ) { if ( comboBoxEdit_TeaDutyDetailsSearByGrade.SelectedItem.ToString().Equals("全部") ) { // foreach ( DataRow duty in dutyInfo.Tables[0].Rows ) // { // comboBoxEdit_TeaDutyDetailsSearByClass.Properties.Items.Add(duty["info_className"].ToString()); // } } else { foreach ( DataRow dept in deptInfo.Tables[0].Rows ) { if ( dept["info_gradeName"].ToString().Equals(comboBoxEdit_TeaDutyDetailsSearByGrade.SelectedItem.ToString()) ) { foreach ( DataRow duty in dutyInfo.Tables[0].Rows ) { if(Convert.ToInt32(duty["info_gradeNumber"]) == Convert.ToInt32(dept["info_gradeNumber"])) { comboBoxEdit_TeaDutyDetailsSearByClass.Properties.Items.Add(duty["info_className"].ToString()); } } } } } } }
private void LoadGradeClassInfo() { // foreach(DataRow getGradeList in getStuInfoByCondition.getGradeInfo("","").Tables[0].Rows) // { // comboBoxEdit_DutySearTeaGarde.Properties.Items.AddRange( // new object[]{getGradeList[1].ToString()}); // comboBoxEdit_TeaDutyDetailsSearByGrade.Properties.Items.AddRange( // new object[]{getGradeList[1].ToString()}); // } DataSet deptInfo = new GradeSystem().GetGradeInfoList(1); if ( deptInfo.Tables[0].Rows.Count > 0 ) { foreach(DataRow dept in deptInfo.Tables[0].Rows) { comboBoxEdit_DutySearTeaGarde.Properties.Items.AddRange(new object[]{dept[1].ToString()}); comboBoxEdit_TeaDutyDetailsSearByGrade.Properties.Items.AddRange(new object[]{dept[1].ToString()}); comboBoxEdit_Graphic_TeaDept.Properties.Items.AddRange(new object[]{dept[1].ToString()}); } } }
private void SendClassName() { if (currentMachineAddr == 0) { setVolumeFailed = true; login.setMachineVolumn.Resume(); MessageBox.Show(string.Format("对门口机{0}设定容量失败!", currentMachineAddr)); return; } DataFrame data = new DataFrame(); data.sym = new byte[]{(byte)'@',(byte)'@'}; data.desAddr = currentMachineAddr; data.srcAddr = 0; data.protocol = CPTT.SystemFramework.Util.SEND_CLASSNAME_TOKEN; data.seq = CPTT.SystemFramework.Util.FRAME_SEQUENCE_VALUE; ArrayList nameList = new ArrayList(); ArrayList numberList = new ArrayList(); int totalNameLength = 0; int classNumberTemp = 0; for(int i = 0;i < gridView2.DataRowCount;i ++) { int gradeNumber = Convert.ToInt32(gridView2.GetDataRow(i)["info_gradeNumber"]); if (currentGradeNumber != gradeNumber) { if (currentGradeNumber < gradeNumber) { currentGradeNumber = gradeNumber; break; } } else { byte[] nameBytes = System.Text.Encoding.GetEncoding("gb2312").GetBytes(gridView2.GetDataRow(i)["info_className"].ToString()); nameList.Add(nameBytes); totalNameLength += nameBytes.Length; classNumberTemp = Convert.ToInt32(gridView2.GetDataRow(i)["machine_address"]); int classNum = classNumberTemp; classNum = classNum/10*16 + classNum%10; numberList.Add(classNum); } if (i == gridView2.DataRowCount - 1) isLast = true; } if (nameList.Count != numberList.Count) { setVolumeFailed = true; login.setMachineVolumn.Resume(); MessageBox.Show(string.Format("对门口机{0}设定容量失败!", currentMachineAddr)); return; } //numberList.Count * 2 其中包括一个字节描述namebytes的长度 //1个字节描述年级 data.comFrameLen = Convert.ToByte(8 + 1 + numberList.Count * 2 + totalNameLength); data.frameData = new byte[1 + numberList.Count * 2 + totalNameLength]; DataSet gradeInfo = new GradeSystem().GetGradeInfo(classNumberTemp / 10); int gradeNumberMapping = 5; if (gradeInfo.Tables.Count > 0) { string gradeName = gradeInfo.Tables[0].Rows[0]["info_gradeName"].ToString(); switch(gradeName) { case "托班":gradeNumberMapping = 1; break; case "小班":gradeNumberMapping = 2; break; case "中班":gradeNumberMapping = 3; break; case "大班":gradeNumberMapping = 4; break; default:gradeNumberMapping = 5; break; } } data.frameData[0] = Convert.ToByte(gradeNumberMapping); int cursor = 1; for(int i = 0; i < nameList.Count; i++) { data.frameData[cursor++] = Convert.ToByte(numberList[i]); byte[] nameBytes = (byte[])nameList[i]; data.frameData[cursor++] = Convert.ToByte(nameBytes.Length); for(int j = 0; j < nameBytes.Length; j++) { data.frameData[cursor++] = nameBytes[j]; } } data.computeCheckSum(); Monitor.Enter(Login.syncRoot); try { Login.handleComClass.WriteSerialCmd(data.comFrameLen, data.frameToBytes());//发送问询帧 } finally { Monitor.Exit(Login.syncRoot); } }