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);
}
}
