private SqlParameter[] GetIsExistAdminInfoParms()
{
SqlParameter[] parms = DBOperation.GetCachedParameters(SQL_SELECT_IS_EXIST_ADMIN_USERNAME);
if (parms == null)
{
parms = new SqlParameter[] {
new SqlParameter(PARM_ADMIN_USERNAME, SqlDbType.VarChar)
};
DBOperation.CacheParameters(SQL_SELECT_IS_EXIST_ADMIN_USERNAME, parms);
}
return(parms);
}
/*得到根据员工编号集合删除员工信息的sql语句的参数信息*/
private SqlParameter[] GetDeleteEmployeeInfoParms()
{
/*在数据层操作类缓冲区中根据哈希表关键字查找sql参数对象数组是否已经存在*/
SqlParameter[] parms = DBOperation.GetCachedParameters(SQL_DELETE_EMPLOYEE_INFO_BY_NOS);
/*如果不存在就创建sql参数对象数组并加入到数据层缓冲区中*/
if (parms == null)
{
parms = new SqlParameter[] {
new SqlParameter(PARM_EMPLOYEE_NOS, SqlDbType.VarChar)
};
DBOperation.CacheParameters(SQL_DELETE_EMPLOYEE_INFO_BY_NOS, parms);
}
return(parms);
}
/*得到查找是否存在该员工编号信息sql语句的参数信息*/
private SqlParameter[] GetSelectIsExistEmployeeNoParms()
{
/*在数据层操作类缓冲区中根据哈希表关键字查找sql参数对象数组是否已经存在*/
SqlParameter[] parms = DBOperation.GetCachedParameters(SQL_SELECT_IS_EXIST_EMPLOYEE_NO);
/*如果不存在就创建sql参数对象数组并加入到数据层缓冲区中*/
if (parms == null)
{
parms = new SqlParameter[] {
new SqlParameter(PARM_EMPLOYEE_NO, SqlDbType.VarChar)
};
DBOperation.CacheParameters(SQL_SELECT_IS_EXIST_EMPLOYEE_NO, parms);
}
return(parms);
}
/*得到根据条件从员工信息视图中查找信息的sql语句的参数信息*/
private SqlParameter[] GetQueryEmployeeInfoViewParms()
{
/*在数据层操作类缓冲区中根据哈希表关键字查找sql参数对象数组是否已经存在*/
SqlParameter[] parms = DBOperation.GetCachedParameters(SQL_SELECT_EMPLOYEE_INFO_FROM_VIEW);
/*如果不存在就创建sql参数对象数组并加入到数据层缓冲区中*/
if (parms == null)
{
parms = new SqlParameter[] {
new SqlParameter(PARM_EMPLOYEE_NO, SqlDbType.VarChar),
new SqlParameter(PARM_EMPLOYEE_NAME, SqlDbType.NVarChar)
};
DBOperation.CacheParameters(SQL_SELECT_EMPLOYEE_INFO_FROM_VIEW, parms);
}
return(parms);
}
/*得到更新员工信息的sql语句的参数信息*/
private SqlParameter[] GetUpdateEmployeeInfoParms()
{
/*在数据层操作类缓冲区中根据哈希表关键字查找sql参数对象数组是否已经存在*/
SqlParameter[] parms = DBOperation.GetCachedParameters(SQL_UPDATE_EMPLOYEE_INFO_BY_NO);
/*如果不存在就创建sql参数对象数组并加入到数据层缓冲区中*/
if (parms == null)
{
parms = new SqlParameter[] {
new SqlParameter(PARM_EMPLOYEE_NAME, SqlDbType.NVarChar),
new SqlParameter(PARM_EMPLOYEE_PASSWORD, SqlDbType.VarChar),
new SqlParameter(PARM_EMPLOYEE_SEX, SqlDbType.NChar),
new SqlParameter(PARM_EMPLOYEE_BIRTHDAY, SqlDbType.DateTime),
new SqlParameter(PARM_EMPLOYEE_EDUCATION_ID, SqlDbType.Int),
new SqlParameter(PARM_EMPLOYEE_HOME_TEL, SqlDbType.VarChar),
new SqlParameter(PARM_EMPLOYEE_MOBILE, SqlDbType.VarChar),
new SqlParameter(PARM_EMPLOYEE_CARD, SqlDbType.VarChar),
new SqlParameter(PARM_EMPLOYEE_EMAIL, SqlDbType.VarChar),
new SqlParameter(PARM_EMPLOYEE_ADDRESS, SqlDbType.NVarChar),
new SqlParameter(PARM_EMPLOYEE_NO, SqlDbType.VarChar)
};
DBOperation.CacheParameters(SQL_UPDATE_EMPLOYEE_INFO_BY_NO, parms);
}
return(parms);
}
