public TeacherCheckInfo()
{
//
// TODO: 在此处添加构造函数逻辑
//
tchBase = new TeacherBase();
}
public TeaBaseInfoPrintSystem()
{
//
// TODO: 在此处添加构造函数逻辑
//
tBase = new TeacherBase();
teaBaseInfoPrintRules = new TeaBaseInfoPrintRules();
}
public int UpdateTcBaseInfo(TeacherBase tcBase)
{
int rowsAffected = 0;
using(TeacherBaseDataAccess tcBaseDA = new TeacherBaseDataAccess())
{
rowsAffected = tcBaseDA.UpdateTcBaseInfo(tcBase);
}
return rowsAffected;
}
public int InsertTcBaseInfo(TeacherBase tcBase)
{
int rowsAffected = 0;
try
{
DBCommandWrapper dbCommandWrapper = db.GetStoredProcCommandWrapper("InsertTeach_Base_Info");
dbCommandWrapper.AddInParameter("@T_ID",DbType.String,tcBase.TID);
dbCommandWrapper.AddInParameter("@T_Number",DbType.String,tcBase.TNumber);
dbCommandWrapper.AddInParameter("@T_Name",DbType.String,tcBase.TName);
dbCommandWrapper.AddInParameter("@T_Sex",DbType.String,tcBase.TSex);
dbCommandWrapper.AddInParameter("@T_Merrige",DbType.String,tcBase.TMerrige);
dbCommandWrapper.AddInParameter("@T_Addr",DbType.String,tcBase.TAddr);
dbCommandWrapper.AddInParameter("@T_Career",DbType.String,tcBase.TCareer);
dbCommandWrapper.AddInParameter("@T_Home_Tel",DbType.String,tcBase.THomeTel);
dbCommandWrapper.AddInParameter("@T_Phone",DbType.String,tcBase.TPhone);
dbCommandWrapper.AddInParameter("@T_Work_Tel",DbType.String,tcBase.TWorkTel);
dbCommandWrapper.AddInParameter("@T_Depart",DbType.String,tcBase.TDepart);
dbCommandWrapper.AddInParameter("@T_Duty",DbType.String,tcBase.TDuty);
dbCommandWrapper.AddInParameter("@T_Technical_Post",DbType.String,tcBase.TTechnicalPost);
dbCommandWrapper.AddInParameter("@T_Level",DbType.String,tcBase.TLevel);
dbCommandWrapper.AddInParameter("@T_Work_Time",DbType.String,tcBase.TWorkTime);
dbCommandWrapper.AddInParameter("@T_Enter_Time",DbType.String,tcBase.TEnterTime);
dbCommandWrapper.AddInParameter("@T_Image",DbType.Binary,tcBase.ImageData);
dbCommandWrapper.AddOutParameter("@rowsAffected",DbType.Int32,4);
db.ExecuteNonQuery(dbCommandWrapper);
rowsAffected = Convert.ToInt32(dbCommandWrapper.GetParameterValue("@rowsAffected"));
}
catch(Exception ex)
{
throw ex;
}
return rowsAffected;
}
private void simpleButton_ModifyButton_Click(object sender, System.EventArgs e)
{
tID = textEdit_tID.EditValue.ToString();
TeacherBase tcBase = new TeacherBase();
TeacherBaseSystem tcBaseSystem = new TeacherBaseSystem();
DialogResult messageResult = MessageBox.Show("是否确认保存修改内容？","消息提示框！",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
if ( messageResult == DialogResult.Yes )
{
try
{
bool doDataInsertLoopOnce = true;
TeacherCheckInfo teacherCheckInfo = new TeacherCheckInfo();
while(doDataInsertLoopOnce)
{
tcBase.TCareer = tRecord.SelectedItem.ToString().Replace(" ","");
tcBase.TMerrige = tMarrige.SelectedItem.ToString().Replace(" ","");
tcBase.TAddr = tAddr.Text.Replace(" ","");
tcBase.TDepart = tDept.SelectedItem.ToString().Replace(" ","");
tcBase.TLevel = tLevel.SelectedItem.ToString().Replace(" ","");
tcBase.TDuty = tDuty.SelectedItem.ToString().Replace(" ","");
tcBase.TTechnicalPost = tTechnicalPost.SelectedItem.ToString().Replace(" ","");
tcBase.TID = tID;
if(!teacherCheckInfo.isValidTcName(tName.Text.Replace(" ","")))
{
MessageBox.Show("教师姓名请正确填写！");
break;
}
else
tcBase.TName = tName.Text.Replace(" ","");
if ( gridView1.RowCount > 0 )
{
if ( teacherCheckInfo.hasCard(tID,tNumber.Text))
{
MessageBox.Show("该教师已经发过卡，修改工号会存在潜在风险，修改失败！");
break;
}
else
{
//获取顺序工号
if ( tNumber.Text.Equals("") )
tcBase.TNumber = teacherCheckInfo.getSerialTcNumber();
else
{
if ( !teacherCheckInfo.isValidTcNumber(tNumber.Text.Replace(" ","")))
{
MessageBox.Show("请确保输入的工号是有效工号！");
break;
}
else
{
if ( !teacherCheckInfo.hasSameNumber( tNumber.Text.Replace(" ",""),
tcBase.TID ) )
{
MessageBox.Show("您所选择的教师工号已经存在，请更换！");
break;
}
}
tcBase.TNumber = tNumber.Text.Replace(" ","");
}
}
}
else
MessageBox.Show("教师记录不存在还无法进行修改！");
if(!teacherCheckInfo.isValidTcHomePhone(tHomePhone.Text.Replace(" ","")))
{
MessageBox.Show("教师家庭电话填写不正确！");
break;
}
else
tcBase.THomeTel = tHomePhone.Text.Replace(" ","");
if(!teacherCheckInfo.isValidTcTime(tEnterTime.DateTime.Date,tJoinDate.DateTime.Date))
{
MessageBox.Show("时间填写不当，请重新输入！");
break;
}
else
{
tcBase.TEnterTime = Convert.ToDateTime(tEnterTime.Text.Replace(" ",""));
tcBase.TWorkTime = Convert.ToDateTime(tJoinDate.Text.Replace(" ",""));}
if(!teacherCheckInfo.isValidTcSex(tSex.Text.Replace(" ","")))
{
MessageBox.Show("教师性别不正确！");
break;
}
else
tcBase.TSex = tSex.Text.Replace(" ","");
if(!teacherCheckInfo.isValidTcWorkPhone(tWorkPhone.Text.Replace(" ","")))
{
MessageBox.Show("教师办公电话填写不正确，请正确填写！");
break;
}
else
tcBase.TWorkTel = tWorkPhone.Text.Replace(" ","");
if(!teacherCheckInfo.isValidTcPhone(tPhone.Text.Replace(" ","")))
{
MessageBox.Show("教师手机号码不正确！");
break;
}
else
tcBase.TPhone = tPhone.Text.Replace(" ","");
if ( pictureEdit_LoadImageData.Image == null )
imageDataBuffer = null;
else
{
imageMSReader = new MemoryStream();
pictureEdit_LoadImageData.Image.Save(imageMSReader,ImageFormat.Jpeg);
imageDataBuffer = imageMSReader.ToArray();
}
tcBase.ImageData = imageDataBuffer;
tcBaseSystem.UpdateTcBaseInfo(tcBase);
if(!gridView1.GetDataRow(gridView1.GetSelectedRows()[0])["T_Number"].ToString().Equals(tcBase.TNumber))
{
new UserSystem().DeleteUserAccount(gridView1.GetDataRow(gridView1.GetSelectedRows()[0])
["T_Number"].ToString());
new UserSystem().CreateUserAccount(tcBase.TNumber,textEdit_UserPwd.Text);
}
int rtnValue = new UserSystem().UpdateUserRole(tcBase.TNumber,comboBoxEdit_Privilege.SelectedItem.ToString());
if (rtnValue == -1) MessageBox.Show("如果您执行此修改，系统将不存在最高权限，这是不允许的，修改失败！");
else if (rtnValue == 0)
{
new UserSystem().DeleteUserAccount(tcBase.TNumber);
new UserSystem().CreateUserAccount(tcBase.TNumber,textEdit_UserPwd.Text);
new UserSystem().AddUserRole(tcBase.TNumber,comboBoxEdit_Privilege.SelectedItem.ToString());
MessageBox.Show("修改完毕！");
}
else MessageBox.Show("修改完毕！");
doDataInsertLoopOnce = false;
//刷新绑定信息
TextDataUnBindings();
TextDataClear();
// loadPage(new TeacherBaseSystem().SearchTcBaseInfoByCondition("","","",""));
loadPage(new TeacherBaseSystem().SearchTcBaseInfoByCondition(comboBoxEdit_Grade.SelectedItem.ToString().Replace(" ",""),
comboBoxEdit_Class.SelectedItem.ToString().Replace(" ",""),textEdit_Name.Text.Replace(" ",""),textEdit_Number.Text.Replace(" ","")));
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void simpleButton_SaveButton_Click(object sender, System.EventArgs e)
{
tID = textEdit_tID.EditValue.ToString();
TeacherBase tcBase = new TeacherBase();
TeacherBaseSystem tcBaseSystem = new TeacherBaseSystem();
DialogResult messageResult = MessageBox.Show("是否确认保存这些数据？","消息提示框！",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
if ( messageResult == DialogResult.Yes )
{
try
{
bool doDataInsertLoopOnce = true;
TeacherCheckInfo teacherCheckInfo = new TeacherCheckInfo();
while(doDataInsertLoopOnce)
{
tcBase.TCareer = tRecord.SelectedItem.ToString().Replace(" ","");
tcBase.TMerrige = tMarrige.SelectedItem.ToString().Replace(" ","");
tcBase.TDepart = tDept.SelectedItem.ToString().Replace(" ","");
tcBase.TLevel = tLevel.SelectedItem.ToString().Replace(" ","");
tcBase.TDuty = tDuty.SelectedItem.ToString().Replace(" ","");
tcBase.TTechnicalPost = tTechnicalPost.SelectedItem.ToString().Replace(" ","");
if ( !tID.Equals("") )
tcBase.TID = tID;
else
tcBase.TID = Guid.NewGuid().ToString();
if(!teacherCheckInfo.isValidTcName(tName.Text.Replace(" ","")))
{
MessageBox.Show("教师姓名请正确填写！");
break;
}
else{tcBase.TName = tName.Text.Replace(" ","");}
//获取顺序工号
if ( tNumber.Text.Equals("") )
{
tcBase.TNumber = teacherCheckInfo.getSerialTcNumber();
if ( tcBase.TNumber.Equals("-1") )
{
MessageBox.Show("已超出系统所允许的最大教师数量！");
break;
}
}
else
{
if ( !teacherCheckInfo.isValidTcNumber(tNumber.Text.Replace(" ","")))
{
MessageBox.Show("请确保输入的工号是有效工号！");
break;
}
else
{
if ( !teacherCheckInfo.hasSameNumber( tNumber.Text.Replace(" ",""),
tcBase.TID ) )
{
MessageBox.Show("您所选择的教师工号已经存在，请更换！");
break;
}
}
tcBase.TNumber = tNumber.Text.Replace(" ","");
}
if(!teacherCheckInfo.isValidTcHomePhone(tHomePhone.Text.Replace(" ","")))
{
tcBase.THomeTel = "未填写";
MessageBox.Show("教师家庭电话填写不正确！");
break;
}
else
tcBase.THomeTel = tHomePhone.Text.Replace(" ","");
if(!teacherCheckInfo.isValidTcTime(Convert.ToDateTime(tEnterTime.Text.Replace(" ","")),Convert.ToDateTime(tJoinDate.Text.Replace(" ",""))))
{
MessageBox.Show("时间填写不当，请重新输入！");
break;
}
else
{
tcBase.TWorkTime = Convert.ToDateTime(tEnterTime.Text.Replace(" ",""));
tcBase.TEnterTime = Convert.ToDateTime(tJoinDate.Text.Replace(" ",""));
}
if(!teacherCheckInfo.isValidTcSex(tSex.Text.Replace(" ","")))
{
MessageBox.Show("教师性别不正确！");
break;
}
else
tcBase.TSex = tSex.Text.Replace(" ","");
if(!teacherCheckInfo.isValidTcWorkPhone(tWorkPhone.Text.Replace(" ","")))
{
tcBase.TWorkTel = "未填写";
MessageBox.Show("教师办公电话填写不正确，请正确填写！");
break;
}
else
tcBase.TWorkTel = tWorkPhone.Text.Replace(" ","");
if(!teacherCheckInfo.isValidTcPhone(tPhone.Text.Replace(" ","")))
{
tcBase.TPhone = "未填写";
MessageBox.Show("教师手机号码不正确！");
break;
}
else
tcBase.TPhone = tPhone.Text.Replace(" ","");
tcBase.TAddr = tAddr.Text.Replace(" ","");
if ( pictureEdit_LoadImageData.Image == null )
imageDataBuffer = null;
else
{
imageMSReader = new MemoryStream();
pictureEdit_LoadImageData.Image.Save(imageMSReader,ImageFormat.Jpeg);
imageDataBuffer = imageMSReader.ToArray();
}
tcBase.ImageData = imageDataBuffer;
tcBaseSystem.InsertTcBaseInfo(tcBase);
new UserSystem().CreateUserAccount(tcBase.TNumber,
textEdit_UserPwd.Text);
new UserSystem().AddUserRole(tcBase.TNumber,
comboBoxEdit_Privilege.SelectedItem.ToString());
MessageBox.Show("保存完毕！");
doDataInsertLoopOnce = false;
dataNavigator1.Buttons.DoClick(dataNavigator1.Buttons.CancelEdit);
//dataNavigator1.Buttons.CancelEdit.DoClick();
//刷新绑定信息
TextDataUnBindings();
loadPage(new TeacherBaseSystem().SearchTcBaseInfoByCondition("","","",""));
simpleButton_SaveButton.Enabled = false;
simpleButton_ModifyButton.Enabled = true;
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public int UpdateTcBaseInfo(TeacherBase tcBase)
{
return new TeacherBaseRule().UpdateTcBaseInfo(tcBase);
}
public int InsertTcBaseInfo(TeacherBase tcBase)
{
return new TeacherBaseRule().InsertTcBaseInfo(tcBase);
}
public void PrintTeaBaseInfo(TeacherBase tBase,string savePath)
{
try
{
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)m_objBooks.Open(excelPath+@"report\TeacherBaseInfo.xls",
m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,
m_objOpt,m_objOpt,m_objOpt);
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
//获取第一个打印页
m_objSheet = (Excel._Worksheet)m_objSheets.get_Item(1);
if ( NPrintPicture() )
{
m_objPictures = (Excel.Pictures)m_objSheet.Pictures(m_objOpt);
m_objPictures.Insert(@"c:\temp.jpg",m_objOpt);
m_objPicture = (Excel.Picture)m_objPictures.Item(1);
m_objRange = m_objSheet.get_Range("H8","I15");
m_objPicture.Left = (double)m_objRange.Left;
m_objPicture.Top = (double)m_objRange.Top;
m_objPicture.Width = (double)m_objRange.Width;
m_objPicture.Height = (double)m_objRange.Height;
}
//园所名
m_objRange = m_objSheet.get_Range("C6",m_objOpt);
m_objRange.Value = new GardenInfoDataAccess().GetGardenInfo().Tables[0].Rows[0][1].ToString();
//打印日期
m_objRange = m_objSheet.get_Range("H32",m_objOpt);
m_objRange.Value = DateTime.Now.Date.ToString("yyyy.MM.dd");
//姓名
m_objRange = m_objSheet.get_Range("C8",m_objOpt);
m_objRange.Value = tBase.TName;
//性别
m_objRange = m_objSheet.get_Range("E8",m_objOpt);
m_objRange.Value = tBase.TSex;
//学历
m_objRange = m_objSheet.get_Range("G8",m_objOpt);
m_objRange.Value = tBase.TCareer;
//家庭电话
m_objRange = m_objSheet.get_Range("C12",m_objOpt);
m_objRange.Value = tBase.THomeTel;
//手机号码
m_objRange = m_objSheet.get_Range("E12",m_objOpt);
m_objRange.Value = tBase.TPhone;
//办公电话
m_objRange = m_objSheet.get_Range("G12",m_objOpt);
m_objRange.Value = tBase.TWorkTel;
//婚否
m_objRange = m_objSheet.get_Range("C16",m_objOpt);
m_objRange.Value = tBase.TMerrige;
//家庭住址
m_objRange = m_objSheet.get_Range("F16",m_objOpt);
m_objRange.Value = tBase.TAddr;
//所属部门
m_objRange = m_objSheet.get_Range("C20",m_objOpt);
m_objRange.Value = tBase.TDepart;
//职务
m_objRange = m_objSheet.get_Range("F20",m_objOpt);
m_objRange.Value = tBase.TDuty;
//职称
m_objRange = m_objSheet.get_Range("H20",m_objOpt);
m_objRange.Value = tBase.TTechnicalPost;
//教师等级
m_objRange = m_objSheet.get_Range("C24",m_objOpt);
m_objRange.Value = tBase.TLevel;
//参加工作时间
m_objRange = m_objSheet.get_Range("G24",m_objOpt);
m_objRange.Value = tBase.TWorkTime.ToString("yyyy-MM-dd");
//入园时间
m_objRange = m_objSheet.get_Range("C28",m_objOpt);
m_objRange.Value = tBase.TEnterTime.ToString("yyyy-MM-dd");
m_objBook.SaveAs(savePath, m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objRange);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheets);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBooks);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);
}
catch(Exception e)
{
Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE);
}
finally
{
m_objRange = null;
m_objSheet = null;
m_objSheets = null;
m_objBook = null;
m_objBooks = null;
m_objExcel = null;
GC.Collect();
KillProcess();
}
}