public StuValidationCheck()
{
//
// TODO: 在此处添加构造函数逻辑
//
students = new Students();
getStuInfoByCondition = new GetStuInfoByCondition();
}
public StuBaseInfoPrintSystem()
{
//
// TODO: 在此处添加构造函数逻辑
//
students = new Students();
stuBaseInfoPrintRules = new StuBaseInfoPrintRules();
}
public void InsertStuBasicInfo(Students students)
{
insertStuBasicInfoCommand = "InsertStuBasicInfo";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(insertStuBasicInfoCommand);
dbCommandWrapper.AddInParameter("@info_stuID",DbType.String,students.StuGuid);
dbCommandWrapper.AddInParameter("@info_stuName",DbType.String,students.Name);
dbCommandWrapper.AddInParameter("@info_stuGrade",DbType.String,students.Grade);
dbCommandWrapper.AddInParameter("@info_stuClass",DbType.String,students.Class);
dbCommandWrapper.AddInParameter("@info_stuNumber",DbType.String,students.Number);
dbCommandWrapper.AddInParameter("@info_stuGender",DbType.String,students.Gender);
dbCommandWrapper.AddInParameter("@info_stuBirthday",DbType.DateTime,students.Birthday);
dbCommandWrapper.AddInParameter("@info_stuEntryStatus",DbType.String,students.EntryStatus);
dbCommandWrapper.AddInParameter("@info_stuEntryDate",DbType.DateTime,students.EntryDate);
dbAccess.ExecuteNonQuery(dbCommandWrapper);
}
public void DeleteStuParentInfo(Students students)
{
deleteStuParentInfoCommand = "DeleteStudent_ParentInfo";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(deleteStuParentInfoCommand);
dbCommandWrapper.AddInParameter("@info_stuBasicID",DbType.String,students.StuGuid);
dbAccess.ExecuteNonQuery(dbCommandWrapper);
}
public void UpdateStuParentInfo(Students students)
{
updateStuParentInfoCommand = "UpdateStudent_ParentInfo";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(updateStuParentInfoCommand);
dbCommandWrapper.AddInParameter("@info_stuBasicID",DbType.String,students.StuGuid);
dbCommandWrapper.AddInParameter("@info_stuFatherName",DbType.String,students.FatherName);
dbCommandWrapper.AddInParameter("@info_stuFatherLinkPhone",DbType.String,students.FatherPhone);
dbCommandWrapper.AddInParameter("@info_stuFatherWorkPlace",DbType.String,students.FatherWorkPlace);
dbCommandWrapper.AddInParameter("@info_stuMotherName",DbType.String,students.MotherName);
dbCommandWrapper.AddInParameter("@info_stuMotherLinkPhone",DbType.String,students.MotherPhone);
dbCommandWrapper.AddInParameter("@info_stuMotherWorkPlace",DbType.String,students.MotherWorkPlace);
dbAccess.ExecuteNonQuery(dbCommandWrapper);
}
public void UpdateStuDetailInfo(Students students)
{
updateStuDetailInfoCommand = "UpdateStudent_DetailInfo";
dbCommandWrapper = dbAccess.GetStoredProcCommandWrapper(updateStuDetailInfoCommand);
dbCommandWrapper.AddInParameter("@info_stuBasicID",DbType.String,students.StuGuid);
dbCommandWrapper.AddInParameter("@info_stuRegNote",DbType.String,students.RegNote);
dbCommandWrapper.AddInParameter("@info_stuOrigin",DbType.String,students.Origin);
dbCommandWrapper.AddInParameter("@info_stuNationality",DbType.String,students.Nationality);
dbCommandWrapper.AddInParameter("@info_stuNative",DbType.String,students.Native);
dbCommandWrapper.AddInParameter("@info_stuJieDao",DbType.String,students.JieDao);
dbCommandWrapper.AddInParameter("@info_stuLiWei",DbType.String,students.LiWei);
dbCommandWrapper.AddInParameter("@info_stuFamilyAddr",DbType.String,students.FamilyAddr);
dbCommandWrapper.AddInParameter("@info_stuHuKouAddr",DbType.String,students.HuKouAddr);
dbCommandWrapper.AddInParameter("@info_stuZipCode",DbType.String,students.ZipCode);
dbCommandWrapper.AddInParameter("@info_stuSickHistory",DbType.String,students.SickHistory);
dbCommandWrapper.AddInParameter("@info_stuEMailAddr",DbType.String,students.EMail);
dbCommandWrapper.AddInParameter("@info_stuBankID",DbType.String,students.BankID);
dbCommandWrapper.AddInParameter("@info_stuGraphLocation",DbType.Binary,students.GraphLocation);
dbAccess.ExecuteNonQuery(dbCommandWrapper);
}
public StudentBaseInfo()
{
// This call is required by the Windows.Forms Form Designer.
InitializeComponent();
// TODO: Add any initialization after the InitForm call
getStuInfoByCondition = new GetStuInfoByCondition();
stuValidationCheck = new StuValidationCheck();
students = new Students();
stuBaseInfoPrintSystem = new StuBaseInfoPrintSystem();
rolesSystem = new RolesSystem();
#region 帮助
this.helpProvider_StuBaseInfo.HelpNamespace = System.IO.Path.GetDirectoryName(Application.ExecutablePath)
+ CPTT.SystemFramework.Util.HELP_FILE_NAME;
this.helpProvider_StuBaseInfo.SetHelpKeyword(this.xtraTabControl_StuBaseInfo,"学生基本信息管理");
this.helpProvider_StuBaseInfo.SetHelpNavigator(this.xtraTabControl_StuBaseInfo, System.Windows.Forms.HelpNavigator.KeywordIndex);
this.helpProvider_StuBaseInfo.SetHelpString(this.xtraTabControl_StuBaseInfo, "");
this.helpProvider_StuBaseInfo.SetShowHelp(this.xtraTabControl_StuBaseInfo, true);
#endregion
}
public void StuBaseInfoPrint(Students students,string savePath)
{
try
{
//创建打印副本
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)m_objBooks.Open(excelPath+@"report\StudentBaseInfo.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("G8","H15");
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("B4",m_objOpt);
m_objRange.Value = new GardenInfoDataAccess().GetGardenInfo().Tables[0].Rows[0][1].ToString();
//打印日期
m_objRange = m_objSheet.get_Range("G40",m_objOpt);
m_objRange.Value = DateTime.Now.ToString("yyyy-MM-dd");
//打印学号
m_objRange = m_objSheet.get_Range("B7",m_objOpt);
m_objRange.Value = students.Number;
//打印姓名
m_objRange = m_objSheet.get_Range("B8",m_objOpt);
m_objRange.Value = students.Name;
//打印性别
m_objRange = m_objSheet.get_Range("D8",m_objOpt);
m_objRange.Value = students.Gender;
//打印出生日
m_objRange = m_objSheet.get_Range("F8",m_objOpt);
m_objRange.Value = students.EntryDate;
//打印生源
m_objRange = m_objSheet.get_Range("B10",m_objOpt);
m_objRange.Value = students.Origin;
//打印入托方式
m_objRange = m_objSheet.get_Range("D10",m_objOpt);
m_objRange.Value = students.EntryStatus;
//打印入园日期
m_objRange = m_objSheet.get_Range("F10",m_objOpt);
m_objRange.Value = students.EntryDate;
//打印离园日期
m_objRange = m_objSheet.get_Range("B12",m_objOpt);
if ( students.LeaveDate == DateTime.MinValue )
m_objRange.Value = "";
else
m_objRange.Value = students.LeaveDate;
//打印国籍
m_objRange = m_objSheet.get_Range("B18",m_objOpt);
m_objRange.Value = students.Nationality;
//打印邮编
m_objRange = m_objSheet.get_Range("D18",m_objOpt);
m_objRange.Value = students.ZipCode;
//打印街道
m_objRange = m_objSheet.get_Range("F18",m_objOpt);
m_objRange.Value = students.JieDao;
//打印里委
m_objRange = m_objSheet.get_Range("F20",m_objOpt);
m_objRange.Value = students.LiWei;
//打印籍贯
m_objRange = m_objSheet.get_Range("B20",m_objOpt);
m_objRange.Value = students.Native;
//打印家庭住址
m_objRange = m_objSheet.get_Range("B22",m_objOpt);
m_objRange.Value = students.FamilyAddr;
//打印户口地址
m_objRange = m_objSheet.get_Range("B24",m_objOpt);
m_objRange.Value = students.HuKouAddr;
//打印病史记录
m_objRange = m_objSheet.get_Range("B26",m_objOpt);
m_objRange.Value = students.SickHistory;
//打印父亲姓名
m_objRange = m_objSheet.get_Range("B31",m_objOpt);
m_objRange.Value = students.FatherName;
//打印父亲联系电话
m_objRange = m_objSheet.get_Range("F31",m_objOpt);
m_objRange.Value = students.FatherPhone;
//打印父亲工作地址
m_objRange = m_objSheet.get_Range("B33",m_objOpt);
m_objRange.Value = students.FatherWorkPlace;
//打印母亲姓名
m_objRange = m_objSheet.get_Range("B35",m_objOpt);
m_objRange.Value = students.MotherName;
//打印母亲联系电话
m_objRange = m_objSheet.get_Range("F35",m_objOpt);
m_objRange.Value = students.MotherPhone;
//打印母亲工作地址
m_objRange = m_objSheet.get_Range("B37",m_objOpt);
m_objRange.Value = students.MotherWorkPlace;
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();
}
}