public static void Main()
{
CurrentPath = SetPath;
var dex = new CreateFullTimeStudent();
StudentBase st = dex.CreateStudent("Rick", new[] { "020" });
StudentBase st1 = dex.CreateStudent("Alex", new[] { "6", "9" });
var deg = new CreatePartTimeStudent();
StudentBase st2 = deg.CreateStudent("Nick", new[] { "4", "5" });
List <StudentBase> students = new List <StudentBase> {
st, st1, st2
};
Serialize(students);
var c = new CreateTechCourse();
CourseBase co = c.CreateCourse("Math", new[] { "0" }, new[] { "001", "002" });
CourseBase co1 = c.CreateCourse("CS", new[] { "0" }, new[] { "001", "002" });
List <CourseBase> courses = new List <CourseBase> {
co, co1
};
Serialize(courses);
var n = new CreateFullTimeTeacher();
TeacherBase t = n.CreateTeacher("K", 5, new[] { "001", "002" });
var q = new CreatePartTimeTeacher();
TeacherBase t1 = q.CreateTeacher("gfgd", 5, new[] { "009", "005" });
List <TeacherBase> teachers = new List <TeacherBase> {
t, t1
};
Serialize(teachers);
Console.ReadKey();
}
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 UpdateTcBaseInfo(TeacherBase tcBase)
{
int rowsAffected = 0;
try
{
DBCommandWrapper dbCommandWrapper = db.GetStoredProcCommandWrapper("UpdateTeach_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);
}
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();
}
}
