/// <summary>
/// 获得该学年设置的评议主题
/// </summary>
/// <returns></returns>
private string GetPeerProject()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT SEQ_NO VALUE,PEER_NAME TEXT ");
strSql.Append("FROM PEER_PROJECT_HEAD ");
strSql.Append("WHERE 1=1 ");
//查询项目种类区分
if (!string.IsNullOrEmpty(Fetch.Get("peer_flag")))
{
if (Fetch.Get("peer_flag").ToLower().Equals("end")) //查询已经结束的项目
{
strSql.AppendFormat("AND PEER_END < '{0}' ", DateTime.Now.ToString("yyyy-MM-dd"));
}
}
//过滤条件
if (Fetch.Get("year_code").Length > 0)
{
strSql.AppendFormat("AND PEER_YEAR = '{0}' ", Fetch.Get("year_code"));
}
//排序
strSql.Append("ORDER BY OP_TIME DESC ");
comdata cod = new comdata();
return(cod.GetComboxJsonStr(ds.ExecuteTxtDataTable(strSql.ToString())));
}
/// <summary>
/// 通过学院获得所属的专业
/// </summary>
/// <returns></returns>
private string Get_Zy()
{
string sql = string.Format("SELECT zy VALUE,mc TEXT FROM t_jx_zy WHERE 1=1 {0} ORDER BY xy ASC", Fetch.Get("xy_code").Length > 0 ? string.Format("AND xy = '{0}'", Fetch.Get("xy_code")) : "");
comdata cod = new comdata();
return(cod.GetComboxJsonStr(ds.ExecuteTxtDataTable(sql)));
}
/// <summary>
/// 根据项目类别代码获取相应项目类型代码
/// </summary>
/// <returns></returns>
private string Get_Class_Type()
{
string sql = string.Format("SELECT TYPE_CODE VALUE,TYPE_NAME TEXT FROM SHOOLAR_PROJECT_TYPE WHERE 1=1 {0} ORDER BY SEQENCE ASC", Fetch.Get("class_code").Length > 0 ? string.Format("AND CLASS_CODE = '{0}'", Fetch.Get("class_code")) : "");
comdata cod = new comdata();
return(cod.GetComboxJsonStr(ds.ExecuteTxtDataTable(sql)));
}
private string GetHiredEmployer()
{
string strSql_Apply = string.Format("SELECT DISTINCT EMPLOYER FROM QZ_JOB_APPLY_HEAD WHERE EMPLOY_FLAG = 'Y' AND SCH_YEAR = '{0}' AND SCH_TERM = '{1}' AND STU_NUMBER = '{2}'", sch_info.CURRENT_YEAR, sch_info.CURRENT_XQ, user.User_Id);
string strSql = string.Format("SELECT DW VALUE, MC TEXT FROM T_XT_DEPARTMENT WHERE DW IN ({0})", strSql_Apply);
strSql += " ORDER BY DW DESC";
comdata cod = new comdata();
return(cod.GetComboxJsonStr(ds.ExecuteTxtDataTable(strSql)));
}
private string GetHiredJob()
{
string strSql_Apply = string.Format("SELECT DISTINCT EXPECT_JOB1 FROM QZ_JOB_APPLY_HEAD WHERE EMPLOY_FLAG = 'Y' AND SCH_YEAR = '{0}' AND SCH_TERM = '{1}' AND STU_NUMBER = '{2}'", sch_info.CURRENT_YEAR, sch_info.CURRENT_XQ, user.User_Id);
if (!string.IsNullOrEmpty(Fetch.Get("employer")))
{
strSql_Apply += string.Format(" AND EMPLOYER = '{0}'", Fetch.Get("employer"));
}
string strSql = string.Format("SELECT SEQ_NO VALUE, JOB_NAME TEXT FROM QZ_JOB_MANAGE WHERE SEQ_NO IN ({0})", strSql_Apply);
strSql += " ORDER BY OP_TIME DESC";
comdata cod = new comdata();
return(cod.GetComboxJsonStr(ds.ExecuteTxtDataTable(strSql)));
}
/// <summary>
/// 根据项目类型代码获取项目
/// </summary>
/// <returns></returns>
private string Get_Jz_Project()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT SEQ_NO VALUE,PROJECT_NAME TEXT ");
strSql.Append("FROM SHOOLAR_PROJECT_HEAD ");
strSql.Append("WHERE 1=1 ");
//查询项目种类区分
if (!string.IsNullOrEmpty(Fetch.Get("pro_flag")))
{
if (Fetch.Get("pro_flag").ToLower().Equals("end")) //查询已经结束的项目
{
strSql.AppendFormat("AND APPLY_END < '{0}' ", DateTime.Now.ToString("yyyy-MM-dd"));
}
}
//过滤条件
if (!string.IsNullOrEmpty(Fetch.Get("class_code")))
{
strSql.AppendFormat("AND PROJECT_CLASS = '{0}' ", Fetch.Get("class_code"));
}
if (!string.IsNullOrEmpty(Fetch.Get("type_code")))
{
strSql.AppendFormat("AND PROJECT_TYPE = '{0}' ", Fetch.Get("type_code"));
}
if (!string.IsNullOrEmpty(Fetch.Get("year_code")))
{
strSql.AppendFormat("AND APPLY_YEAR = '{0}' ", Fetch.Get("year_code"));
}
//排序
strSql.Append("ORDER BY APPLY_END ASC ");
comdata cod = new comdata();
return(cod.GetComboxJsonStr(ds.ExecuteTxtDataTable(strSql.ToString())));
}
/// <summary>
/// 学费补偿贷款代偿管理：通过学费补偿贷款代偿类型获得所属的学费补偿贷款代偿项目
/// </summary>
/// <returns></returns>
private string Get_Makeup_Project()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT SEQ_NO VALUE,MAKEUP_NAME TEXT ");
strSql.Append("FROM MAKEUP_PROJECT_HEAD ");
strSql.Append("WHERE 1=1 ");
//过滤条件
if (Fetch.Get("type_code").Length > 0)
{
strSql.AppendFormat("AND MAKEUP_TYPE = '{0}' ", Fetch.Get("type_code"));
}
if (Fetch.Get("year_code").Length > 0)
{
strSql.AppendFormat("AND MAKEUP_YEAR = '{0}' ", Fetch.Get("year_code"));
}
//排序
strSql.Append("ORDER BY OP_TIME DESC ");
comdata cod = new comdata();
return(cod.GetComboxJsonStr(ds.ExecuteTxtDataTable(strSql.ToString())));
}
/// <summary>
/// 通过学院、专业、年级获得所属班级
/// </summary>
/// <returns></returns>
private string Get_Class()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT CLASSCODE AS VALUE,CLASSNAME AS TEXT FROM BASIC_CLASS_INFO ");
strSql.Append("WHERE 1=1 ");
//ZZ 20171024 修改：由于研究生与本科生班级规则不同，所有查询有所改变
if (!string.IsNullOrEmpty(Get("xy_code")))
{
strSql.AppendFormat("AND XY = '{0}' ", Get("xy_code"));
}
if (!string.IsNullOrEmpty(Get("zy_code")))
{
strSql.AppendFormat("AND (ZY = '{0}' OR ZY = '') ", Get("zy_code"));
}
if (!string.IsNullOrEmpty(Get("grade_code")))
{
strSql.AppendFormat("AND GRADE = '{0}' ", Get("grade_code"));
}
if (!user.User_Id.Equals(ApplicationSettings.Get("AdminUser").ToString()))
{
if (user.User_Role.Equals("F"))
{
string strFClass = ComHandleClass.getInstance().ByFGetClassCode(user.User_Id);
if (strFClass.Length > 0)
{
strSql.AppendFormat("AND CLASSCODE IN ({0}) ", ComHandleClass.getInstance().GetNoRepeatAndNoEmptyStringSql(strFClass));
}
}
}
strSql.Append("ORDER BY CLASSCODE ASC ");
comdata cod = new comdata();
return(cod.GetComboxJsonStr(ds.ExecuteTxtDataTable(strSql.ToString())));
}
