public static Dictionary <string, List <FpStudentObject> > QueryGroupbySchool(IDataAccess dataAccess, string busType, string startDate, string endDate)
{
SimpleOrmOperator.InitDataAccess(dataAccess);
string sqlCondition = "";
sqlCondition = "where create_time between to_date('{0}','YYYY-MM-DD') and to_date('{1}','YYYY-MM-DD') order by create_time desc";
ArrayList students = SimpleOrmOperator.QueryConditionList <FpStudentObject>(string.Format(sqlCondition, startDate, endDate));
Dictionary <string, List <FpStudentObject> > dictStudents = new Dictionary <string, List <FpStudentObject> >();
foreach (FpStudentObject student in students)
{
if (string.IsNullOrEmpty(student.SCHOOL_CODE))
{
continue;
}
if (!dictStudents.ContainsKey(student.SCHOOL_CODE))
{
dictStudents.Add(student.SCHOOL_CODE, new List <FpStudentObject>());
}
dictStudents[student.SCHOOL_CODE].Add(student);
}
SimpleOrmOperator.InitDataAccess(null);
return(dictStudents);
}
public static FpStudentObject loadbyIdCard(IDataAccess dataAccess, String idCard)
{
SimpleOrmOperator.InitDataAccess(dataAccess);
FpStudentObject student = SimpleOrmOperator.Query <FpStudentObject>(idCard);
SimpleOrmOperator.InitDataAccess(null);
return(student);
}
public static Dictionary <string, DepartMent> queryDict(IDataAccess dataAccess)
{
SimpleOrmOperator.InitDataAccess(dataAccess);
ArrayList deps = SimpleOrmOperator.QueryListAll(typeof(DepartMent));
Dictionary <string, DepartMent> dictDeps = new Dictionary <string, DepartMent>();
foreach (DepartMent dep in deps)
{
if (string.IsNullOrEmpty(dep.DepCode))
{
continue;
}
if (!dictDeps.ContainsKey(dep.DepCode))
{
dictDeps.Add(dep.DepCode, dep);
}
}
SimpleOrmOperator.InitDataAccess(null);
return(dictDeps);
}
private void 查看日志ToolStripMenuItem_Click_1(object sender, EventArgs e)
{
SimpleOrmOperator.InitDataAccess(null);
NoUserHelper.ShowLogs();
}
private void EntityForm_Load(object sender, EventArgs e)
{
SimpleOrmOperator.InitDataAccess(DAL.DataAccessFactory.GetDataAccess());
}