private void GetPrintData(string oid)
{
#region 奖助申请信息
//奖助申请信息
head.OID = oid;
ds.RetrieveObject(head);
if (head == null)
{
return;
}
strPrintCode = ComHandleClass.getInstance().GetStuWorNo(head.STU_NUMBER, head.PROJECT_YEAR);
head.XY = cod.GetDDLTextByValue("ddl_department", head.XY);
head.ZY = cod.GetDDLTextByValue("ddl_zy", head.ZY);
head.STUDY_LEVEL = cod.GetDDLTextByValue("ddl_apply_study_level", head.STUDY_LEVEL);
//大文本数据
if (ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO) != null)
{
txt = ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO);
}
#endregion 奖助申请信息
#region 学生基础信息
//学生基础信息
if (StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER) != null)
{
stu = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
stu.NATION = cod.GetDDLTextByValue("ddl_mz", stu.NATION);
stu.SYSTEM = cod.GetDDLTextByValue("ddl_edu_system", stu.SYSTEM);
}
#endregion 学生基础信息
}
/// <summary>
/// COUNTRY_FIRST 国家一等助学金：表13
/// COUNTRY_SECOND 国家二等助学金：表14
/// SOCIETY_OFFER 社会捐资类奖学金：表16
/// </summary>
/// <param name="txt"></param>
/// <param name="rewardList"></param>
/// <returns></returns>
private string Check_13_14_16(Shoolar_apply_head head, Shoolar_apply_txt txt, List <Shoolar_apply_study_list> studyList, List <Shoolar_apply_family_list> familyList)
{
#region 校验“申请理由”字数
if (txt == null)
{
return("不满足提交条件：申请理由字数太少！");
}
if (txt.APPLY_REASON.Length < 200)
{
return("不满足提交条件：申请理由字数太少！");
}
#endregion 校验“申请理由”字数
#region 校验家庭成员
if (familyList == null)
{
return("不满足提交条件：家庭成员未填写！");
}
if (familyList.Count <= 0)
{
return("不满足提交条件：家庭成员未填写！");
}
#endregion 校验家庭成员
#region 校验科目成绩（需填写）
if (head.PROJECT_TYPE.Equals("SOCIETY_OFFER"))
{
if (head.STU_TYPE.Equals(CValue.USER_STUTYPE_B))
{
if (studyList == null)
{
return("不满足提交条件：科目成绩未填写！");
}
if (studyList.Count == 0)
{
return("不满足提交条件：科目成绩未填写！");
}
//ZZ 20171026 新增：成绩设至少填4项，最多21项，样板表格设置的是一列7行，共三列。
if (studyList.Count < 4 || studyList.Count > 21)
{
return("不满足提交条件：科目成绩至少填4项，最多21项！");
}
}
}
#endregion 校验科目成绩（需填写）
return(string.Empty);
}
/// <summary>
/// SCHOOL_SINGLE 单项奖学金：表18
/// </summary>
/// <param name="txt"></param>
/// <param name="rewardList"></param>
/// <returns></returns>
private string Check_18(Shoolar_apply_txt txt)
{
#region 校验“个人突出事迹”字数
if (txt == null)
{
return("不满足提交条件：个人突出事迹字数太少！");
}
if (txt.APPLY_REASON.Length < 150)
{
return("不满足提交条件：个人突出事迹字数太少！");
}
#endregion 校验“个人突出事迹”字数
return(string.Empty);
}
/// <summary>
/// COUNTRY_B 国家奖学金（本科）：表11+1,11+2
/// </summary>
/// <param name="txt"></param>
/// <returns></returns>
private string Check_11(Shoolar_apply_txt txt, List <Shoolar_apply_file> fileList, List <Shoolar_apply_file> fileList_photo)
{
#region 校验“申请理由”字数
if (txt == null)
{
return("不满足提交条件：申请理由字数太少！");
}
if (txt.APPLY_REASON.Length == 0)
{
return("不满足提交条件：申请理由字数太少！");
}
#endregion 校验“申请理由”字数
#region 校验附件
if (fileList == null)
{
return("不满足提交条件：未上传附件！");
}
if (fileList.Count == 0)
{
return("不满足提交条件：未上传附件！");
}
#endregion 校验附件
#region 校验个人生活照
if (fileList_photo == null)
{
return("不满足提交条件：未上传个人生活照附件！");
}
if (fileList_photo.Count == 0)
{
return("不满足提交条件：未上传个人生活照附件！");
}
#endregion 校验个人生活照
return(string.Empty);
}
/// <summary>
/// 通过奖助类型判断检查内容
/// </summary>
/// <param name="strProjectType"></param>
/// <param name="txt"></param>
/// <param name="rewardList"></param>
/// <returns></returns>
private string ByProjectTypeCheckInfo(Shoolar_apply_head head, Shoolar_apply_txt txt, List <Shoolar_apply_reward> rewardList, List <Shoolar_apply_study_list> studyList, List <Shoolar_apply_family_list> familyList, List <Shoolar_apply_file> fileList, List <Shoolar_apply_file> fileList_photo)
{
string strResult = string.Empty;
switch (head.PROJECT_TYPE)
{
case "COUNTRY_B": //国家奖学金（本科）：表11+1,11+2
strResult = Check_11(txt, fileList, fileList_photo);
break;
case "COUNTRY_ENCOUR": //国家励志奖学金：表12
case "AREA_GOV": //自治区人民政府奖学金：表15
strResult = Check_12_15(head, txt, studyList, familyList);
break;
case "COUNTRY_FIRST": //国家一等助学金：表13
case "COUNTRY_SECOND": //国家二等助学金：表14
case "SOCIETY_OFFER": //社会捐资类奖学金：表16
strResult = Check_13_14_16(head, txt, studyList, familyList);
break;
case "SCHOOL_GOOD": //三好学生：表17+1
case "SCHOOL_MODEL": //三好学生标兵：表17+1,17+2,17+3
strResult = Check_17(head, txt, studyList, fileList, fileList_photo);
break;
case "SCHOOL_SINGLE": //单项奖学金：表18
strResult = Check_18(txt);
break;
case "COUNTRY_YP": //国家奖学金（研究生）：表19+1,19+2
case "COUNTRY_STUDY": //国家学业奖学金：表20
case "SCHOOL_NOTCOUNTRY": //非学校级奖学金：表21
case "SOCIETY_NOCOUNTRY": //非社会级奖学金：表21
strResult = Check_19_20_21(head, txt, studyList, fileList, fileList_photo);
break;
default:
break;
}
return(strResult);
}
/// <summary>
///保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
//先删除数据再新增
string strSQL = string.Format("DELETE FROM SHOOLAR_APPLY_TXT WHERE SEQ_NO = '{0}' ", Get("seq_no"));
if (ds.ExecuteTxtNonQuery(strSQL) < 0)
{
return("保存大文本数据失败！");
}
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_txt>("Shoolar_apply_txtInsertTransaction");
Shoolar_apply_txt head = new Shoolar_apply_txt();
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = Get("seq_no");
inserttrcn.EntityList.Add(head);
if (!inserttrcn.Commit())
{
return("保存大文本数据失败！");
}
//重新保存界面的文本数据
StringBuilder strTxt = new StringBuilder();
strTxt.AppendFormat("APPLY_REASON = '{0}', ", Post("APPLY_REASON")); //申请理由
strTxt.AppendFormat("SKILL_INFO = '{0}', ", Post("SKILL_INFO")); //英语、计算机过级情况
strTxt.AppendFormat("PUBLISH_INFO = '{0}', ", Post("PUBLISH_INFO")); //论文发表、获得专利等情况
strTxt.AppendFormat("MOTTO = '{0}', ", Post("MOTTO")); //人生格言
strTxt.AppendFormat("TEACHER_INFO = '{0}', ", Post("TEACHER_INFO")); //师长点评
strTxt.AppendFormat("MODEL_INFO = '{0}' ", Post("MODEL_INFO")); //事迹正文
if (!ComHandleClass.getInstance().UpdateTextContent(Get("seq_no"), "SEQ_NO", strTxt.ToString(), "SHOOLAR_APPLY_TXT"))
{
return("保存大文本数据失败！");
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请，保存大文本数据失败：" + ex.ToString());
return(string.Empty);
}
}
private void GetPrintData(string oid)
{
#region 奖助申请信息
//奖助申请信息
head.OID = oid;
ds.RetrieveObject(head);
if (head == null)
{
return;
}
strPrintCode = ComHandleClass.getInstance().GetStuWorNo(head.STU_NUMBER, head.PROJECT_YEAR);
//标题
if (head.PROJECT_TYPE.Equals("COUNTRY_B"))//国家奖学金（本科）
{
strTitle = string.Format("国家奖学金申请者个人先进事迹");
}
else if (head.PROJECT_TYPE.Equals("SCHOOL_MODEL"))//三好学生标兵
{
strTitle = string.Format("校级三好学生标兵申请者个人先进事迹");
}
head.XY = cod.GetDDLTextByValue("ddl_department", head.XY);
head.ZY = cod.GetDDLTextByValue("ddl_zy", head.ZY);
//大文本数据
if (ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO) != null)
{
txt = ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO);
}
#endregion 奖助申请信息
#region 学生基础信息
//学生基础信息
if (StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER) != null)
{
stu = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
stu.NATION = cod.GetDDLTextByValue("ddl_mz", stu.NATION);
}
#endregion 学生基础信息
#region 获奖情况（区分获奖列表与奖助列表）
#region 获奖列表
//获奖列表
Dictionary <string, string> param_o = new Dictionary <string, string>();
param_o.Add("SEQ_NO", head.SEQ_NO);
param_o.Add(string.Format("REWARD_TYPE != 'P' "), "");//其他
List <Shoolar_apply_reward> rewardList = ProjectApplyHandleClass.getInstance().GetRewardListInfo(param_o);
if (rewardList != null)
{
if (rewardList.Count == 0)
{
divReward.InnerHtml = "无";
}
else
{
StringBuilder strR_O = new StringBuilder();
foreach (Shoolar_apply_reward item in rewardList)
{
if (item == null)
{
continue;
}
strR_O.AppendFormat("{0} {1} {2}<br/>", cod.GetDDLTextByValue("ddl_year_type", item.REWARD_DATE), item.REWARD_NAME, item.AWARD_DEPARTMENT);
}
divReward.InnerHtml = strR_O.ToString();
}
}
#endregion 获奖列表
#region 奖助列表
//奖助列表
Dictionary <string, string> param_p = new Dictionary <string, string>();
param_p.Add("SEQ_NO", head.SEQ_NO);
param_p.Add("REWARD_TYPE", "P");//奖助
List <Shoolar_apply_reward> proList = ProjectApplyHandleClass.getInstance().GetRewardListInfo(param_p);
if (proList != null)
{
if (proList.Count == 0)
{
divPassPro.InnerHtml = "无";
}
else
{
StringBuilder strR_P = new StringBuilder();
foreach (Shoolar_apply_reward item in rewardList)
{
if (item == null)
{
continue;
}
strR_P.AppendFormat("{0} {1} {2}<br/>", cod.GetDDLTextByValue("ddl_year_type", item.REWARD_DATE), item.REWARD_NAME, item.AWARD_DEPARTMENT);
}
divPassPro.InnerHtml = strR_P.ToString();
}
}
#endregion 奖助列表
#endregion 获奖情况（区分获奖列表与奖助列表）
}
private void GetPrintData(string oid)
{
#region 奖助申请信息
//奖助申请信息
head.OID = oid;
ds.RetrieveObject(head);
if (head == null)
{
return;
}
strPrintCode = ComHandleClass.getInstance().GetStuWorNo(head.STU_NUMBER, head.PROJECT_YEAR);
head.PROJECT_YEAR = cod.GetDDLTextByValue("ddl_year_type", head.PROJECT_YEAR);
//标题
if (head.PROJECT_TYPE.Equals("SCHOOL_GOODD"))//三好学生
{
strTitle = string.Format(" 广西师范大学({0}学年)三好学生登记表", head.PROJECT_YEAR);
}
else if (head.PROJECT_TYPE.Equals("SCHOOL_MODEL"))//三好学生标兵
{
strTitle = string.Format(" 广西师范大学({0}学年)三好学生标兵登记表", head.PROJECT_YEAR);
}
else if (head.PROJECT_TYPE.Equals("SCHOOL_SINGLE"))//单项奖学金
{
strTitle = string.Format(" 广西师范大学({0}学年)单项奖学金登记表", head.PROJECT_YEAR);
}
head.XY = cod.GetDDLTextByValue("ddl_department", head.XY);
head.ZY = cod.GetDDLTextByValue("ddl_zy", head.ZY);
head.GRADE = cod.GetDDLTextByValue("ddl_grade", head.GRADE);
head.REWARD_FLAG = cod.GetDDLTextByValue("ddl_apply_reward_flag", head.REWARD_FLAG);
//大文本数据
if (ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO) != null)
{
txt = ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO);
}
#endregion 奖助申请信息
#region 学生基础信息
//学生基础信息
if (StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER) != null)
{
stu = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
stu.SEX = cod.GetDDLTextByValue("ddl_xb", stu.SEX);
stu.POLISTATUS = cod.GetDDLTextByValue("ddl_zzmm", stu.POLISTATUS);
stu.NATION = cod.GetDDLTextByValue("ddl_mz", stu.NATION);
}
#endregion 学生基础信息
#region 公共参数
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
#endregion 公共参数
#region 获奖列表
//获奖列表
List <Shoolar_apply_reward> rewardList = ProjectApplyHandleClass.getInstance().GetRewardListInfo(param);
if (rewardList == null)
{
return;
}
#region 跨行数
if (rewardList.Count == 0)
{
nRewardList = 1;
}
else
{
nRewardList = rewardList.Count + 1;
}
#endregion 跨行数
strRewardJson = ProjectResultHandleClass.getInstance().GetRewardList(rewardList);
StringBuilder strR = new StringBuilder();
foreach (Shoolar_apply_reward item in rewardList)
{
if (item == null)
{
continue;
}
strR.AppendFormat("<tr><td>{0}</td><td colspan=\"4\">{1}</td><td colspan=\"2\">{2}</td></tr>", cod.GetDDLTextByValue("ddl_year_type", item.REWARD_DATE), item.REWARD_NAME, item.AWARD_DEPARTMENT);
}
divReward.InnerHtml = strR.ToString();
#endregion 获奖列表
#region 学习情况（分为 成绩信息 与 科目成绩列表）
#region 成绩信息
//成绩信息
if (ProjectApplyHandleClass.getInstance().GetStudyInfo(param) != null)
{
study = ProjectApplyHandleClass.getInstance().GetStudyInfo(param);
study.IS_SCORE_FLAG = cod.GetDDLTextByValue("ddl_yes_no", study.IS_SCORE_FLAG);
}
#endregion 成绩信息
#region 科目成绩列表
//科目成绩列表
List <Shoolar_apply_study_list> studyList = ProjectApplyHandleClass.getInstance().GetStudyListInfo(param);
if (studyList == null)
{
return;
}
if (studyList.Count != 0)
{
nScoreList = nScoreList + studyList.Count;
}
StringBuilder strS = new StringBuilder();
foreach (Shoolar_apply_study_list item in studyList)
{
if (item == null)
{
continue;
}
strS.AppendFormat("<tr><td colspan=\"4\">{0}</td><td colspan=\"3\">{1}</td></tr>", item.COURSE_NAME, item.SCORE);
}
divScore.InnerHtml = strS.ToString();
#endregion 科目成绩列表
#endregion 学习情况（分为 成绩信息 与 科目成绩列表）
}
private void GetPrintData(string oid)
{
#region 奖助申请信息
//奖助申请信息
head.OID = oid;
ds.RetrieveObject(head);
if (head == null)
{
return;
}
strPrintCode = ComHandleClass.getInstance().GetStuWorNo(head.STU_NUMBER, head.PROJECT_YEAR);
head.PROJECT_YEAR = cod.GetDDLTextByValue("ddl_year_type", head.PROJECT_YEAR);
//标题
if (head.PROJECT_TYPE.Equals("COUNTRY_ENCOUR"))//国家励志奖学金
{
strTitle = string.Format(" 广西师范大学({0}学年)国家励志奖学金申请表", head.PROJECT_YEAR);
}
else if (head.PROJECT_TYPE.Equals("AREA_GOV"))//自治区人民政府奖学金
{
strTitle = string.Format(" 广西师范大学({0}学年)自治区人民政府奖学金申请表", head.PROJECT_YEAR);
}
head.XY = cod.GetDDLTextByValue("ddl_department", head.XY);
head.ZY = cod.GetDDLTextByValue("ddl_zy", head.ZY);
head.GRADE = cod.GetDDLTextByValue("ddl_grade", head.GRADE);
//大文本数据
if (ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO) != null)
{
txt = ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO);
}
#endregion 奖助申请信息
#region 学生基础信息
//学生基础信息
if (StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER) != null)
{
stu = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
stu.SEX = cod.GetDDLTextByValue("ddl_xb", stu.SEX);
stu.POLISTATUS = cod.GetDDLTextByValue("ddl_zzmm", stu.POLISTATUS);
stu.NATION = cod.GetDDLTextByValue("ddl_mz", stu.NATION);
}
#endregion 学生基础信息
#region 公共参数
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
#endregion 公共参数
#region 家庭情况（分为 家庭信息 与 家庭成员）
#region 家庭信息
//家庭信息
if (ProjectApplyHandleClass.getInstance().GetFamilyInfo(param) != null)
{
family = ProjectApplyHandleClass.getInstance().GetFamilyInfo(param);
family.HK = cod.GetDDLTextByValue("ddl_stu_basic_hk", family.HK);
family.COGRIZA_INFO = cod.GetDDLTextByValue("ddl_dst_level", family.COGRIZA_INFO);
}
#endregion 家庭信息
#region 家庭成员信息
//家庭成员信息
List <Shoolar_apply_family_list> familyList = ProjectApplyHandleClass.getInstance().GetFamilyListInfo(param);
if (familyList != null)
{
if (familyList.Count == 0)
{
nMemberList = 1;
}
else
{
nMemberList = familyList.Count + 1;
}
StringBuilder strM = new StringBuilder();
foreach (Shoolar_apply_family_list item in familyList)
{
if (item == null)
{
continue;
}
strM.AppendFormat("<tr><td>{0}</td><td>{1}</td><td colspan=\"2\">{2}</td><td colspan=\"3\">{3}</td></tr>", item.MEMBER_NAME, item.MEMBER_AGE, item.MEMBER_RELATION, item.MEMBER_UNIT);
}
divMember.InnerHtml = strM.ToString();
}
#endregion 家庭成员信息
#endregion 家庭情况（分为 家庭信息 与 家庭成员）
#region 获奖情况
//获得奖助列表
List <Shoolar_apply_reward> proList = ProjectApplyHandleClass.getInstance().GetRewardListInfo(param);
if (proList != null)
{
if (proList.Count == 0)
{
divReward.InnerHtml = "无";
}
else
{
StringBuilder strR = new StringBuilder();
foreach (Shoolar_apply_reward item in proList)
{
if (item == null)
{
continue;
}
strR.AppendFormat("{0} {1} {2}<br/>", cod.GetDDLTextByValue("ddl_year_type", item.REWARD_DATE), item.REWARD_NAME, item.AWARD_DEPARTMENT);
}
divReward.InnerHtml = strR.ToString();
}
}
#endregion 获奖情况
#region 学习情况（分为 成绩信息 与 科目成绩列表）
#region 成绩信息
//成绩信息
if (ProjectApplyHandleClass.getInstance().GetStudyInfo(param) != null)
{
study = ProjectApplyHandleClass.getInstance().GetStudyInfo(param);
study.IS_SCORE_FLAG = cod.GetDDLTextByValue("ddl_yes_no", study.IS_SCORE_FLAG);
}
#endregion 成绩信息
#region 科目成绩列表
//科目成绩列表
List <Shoolar_apply_study_list> studyList = ProjectApplyHandleClass.getInstance().GetStudyListInfo(param);
if (studyList == null)
{
return;
}
if (studyList.Count != 0)
{
nScoreList = nScoreList + studyList.Count;
}
StringBuilder strS = new StringBuilder();
foreach (Shoolar_apply_study_list item in studyList)
{
if (item == null)
{
continue;
}
strS.AppendFormat("<tr><td colspan=\"5\">{0}</td><td colspan=\"2\">{1}</td></tr>", item.COURSE_NAME, item.SCORE);
}
divScore.InnerHtml = strS.ToString();
#endregion 科目成绩列表
#endregion 学习情况（分为 成绩信息 与 科目成绩列表）
}
/// <summary>
/// COUNTRY_YP 国家奖学金（研究生）：表19+1,19+2
/// COUNTRY_STUDY 国家学业奖学金：表20
/// SCHOOL_NOTCOUNTRY 非学校级奖学金：表21
/// SOCIETY_NOCOUNTRY 非社会级奖学金：表21
/// </summary>
/// <param name="txt"></param>
/// <param name="rewardList"></param>
/// <returns></returns>
private string Check_19_20_21(Shoolar_apply_head head, Shoolar_apply_txt txt, List <Shoolar_apply_study_list> studyList, List <Shoolar_apply_file> fileList, List <Shoolar_apply_file> fileList_photo)
{
#region 校验“申请理由”字数
if (txt == null)
{
return("不满足提交条件：申请理由字数太少！");
}
if (txt.APPLY_REASON.Length < 200)
{
return("不满足提交条件：申请理由字数太少！");
}
#endregion 校验“申请理由”字数
#region 校验科目成绩（需填写）
if (head.STU_TYPE.Equals(CValue.USER_STUTYPE_B))
{
if (studyList == null)
{
return("不满足提交条件：科目成绩未填写！");
}
if (studyList.Count == 0)
{
return("不满足提交条件：科目成绩未填写！");
}
//ZZ 20171026 新增：成绩设至少填4项，最多21项，样板表格设置的是一列7行，共三列。
if (studyList.Count < 4 || studyList.Count > 21)
{
return("不满足提交条件：科目成绩至少填4项，最多21项！");
}
}
#endregion 校验科目成绩（需填写）
if (head.PROJECT_TYPE.Equals("COUNTRY_YP"))
{
#region 校验附件
if (fileList == null)
{
return("不满足提交条件：未上传附件！");
}
if (fileList.Count == 0)
{
return("不满足提交条件：未上传附件！");
}
#endregion 校验附件
#region 校验个人生活照
if (fileList_photo == null)
{
return("不满足提交条件：未上传个人生活照附件！");
}
if (fileList_photo.Count == 0)
{
return("不满足提交条件：未上传个人生活照附件！");
}
#endregion 校验个人生活照
}
return(string.Empty);
}
/// <summary>
/// SCHOOL_GOOD 三好学生：表17+1
/// SCHOOL_MODEL 三好学生标兵：表17+1,17+2,17+3
/// </summary>
/// <param name="txt"></param>
/// <param name="rewardList"></param>
/// <returns></returns>
private string Check_17(Shoolar_apply_head head, Shoolar_apply_txt txt, List <Shoolar_apply_study_list> studyList, List <Shoolar_apply_file> fileList, List <Shoolar_apply_file> fileList_photo)
{
#region 校验“政治思想、纪律、体育锻炼表现”字数
if (txt == null)
{
return("不满足提交条件：政治思想、纪律、体育锻炼表现字数太少！");
}
if (txt.APPLY_REASON.Length < 200)
{
return("不满足提交条件：政治思想、纪律、体育锻炼表现字数太少！");
}
#endregion 校验“政治思想、纪律、体育锻炼表现”字数
#region 校验科目成绩（需填写）
if (head.STU_TYPE.Equals(CValue.USER_STUTYPE_B))
{
if (studyList == null)
{
return("不满足提交条件：科目成绩未填写！");
}
if (studyList.Count == 0)
{
return("不满足提交条件：科目成绩未填写！");
}
//ZZ 20171026 新增：成绩设至少填4项，最多21项，样板表格设置的是一列7行，共三列。
if (studyList.Count < 4 || studyList.Count > 21)
{
return("不满足提交条件：科目成绩至少填4项，最多21项！");
}
}
#endregion 校验科目成绩（需填写）
if (head.PROJECT_TYPE.Equals("SCHOOL_MODEL"))
{
#region 校验附件
if (fileList == null)
{
return("不满足提交条件：未上传附件！");
}
if (fileList.Count == 0)
{
return("不满足提交条件：未上传附件！");
}
#endregion 校验附件
#region 校验个人生活照
if (fileList_photo == null)
{
return("不满足提交条件：未上传个人生活照附件！");
}
if (fileList_photo.Count == 0)
{
return("不满足提交条件：未上传个人生活照附件！");
}
#endregion 校验个人生活照
//ZZ20171026 新增：先进事迹 字数校验
#region 校验先进事迹
if (txt.MOTTO.Length < 0)
{
return("不满足提交条件：人生格言字数太少！");
}
if (txt.TEACHER_INFO.Length < 0)
{
return("不满足提交条件：师长点评字数太少！");
}
if (txt.MODEL_INFO.Length < 1000)
{
return("不满足提交条件：事迹正文字数太少！");
}
#endregion 校验先进事迹
}
return(string.Empty);
}
/// <summary>
/// 判断是否满足提交条件
/// </summary>
/// <returns></returns>
private string ChkIsCanSubmit()
{
try
{
#region 基础校验
if (string.IsNullOrEmpty(Get("id")))
{
return("请先保存数据之后再进行提交！");
}
Shoolar_apply_head head = new Shoolar_apply_head();
head.OID = Get("id");
ds.RetrieveObject(head);
if (head == null)
{
return("读取奖助申请信息出错,不允许提交！");
}
#endregion 基础校验
//20171121 ZZ 新增：在提交之前再次进行一次申请条件校验（人数不用放在这里校验，还是到院级审批）
#region 申请条件校验
Basic_stu_info stu_info = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
Shoolar_project_head project_head = ProjectSettingHandleClass.getInstance().GetProjectHead(head.PROJECT_SEQ_NO);
if (stu_info == null || project_head == null)
{
return("删除失败，原因：学生信息为空或者奖助项目信息为空！");
}
string strMsg = string.Empty;
#region 项目限制条件
if (!ProjectApplyHandleClass.getInstance().CheckProjectLimit(stu_info, project_head, out strMsg))
{
return(strMsg);
}
#endregion 项目限制条件
#region 可兼得条件
if (!ProjectApplyHandleClass.getInstance().CheckProjectNotBoth(stu_info, project_head, out strMsg))
{
return(strMsg);
}
#endregion 可兼得条件
#endregion 申请条件校验
#region 参数设置
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
Dictionary <string, string> param_file = new Dictionary <string, string>();
param_file.Add("SEQ_NO", head.SEQ_NO);
param_file.Add("FILE_TYPE != '6' ", string.Empty);//附件
Dictionary <string, string> param_file_photo = new Dictionary <string, string>();
param_file_photo.Add("SEQ_NO", head.SEQ_NO);
param_file_photo.Add("FILE_TYPE = '6' ", string.Empty);//附件：个人生活照
Shoolar_apply_txt txt = ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO);
List <Shoolar_apply_reward> rewardList = ProjectApplyHandleClass.getInstance().GetRewardListInfo(param);
//系统限制条件改为，本科生限制不变（需填写4-21门），研究生不限制填写条数。
List <Shoolar_apply_study_list> studyList = ProjectApplyHandleClass.getInstance().GetStudyListInfo(param);
List <Shoolar_apply_family_list> familyList = ProjectApplyHandleClass.getInstance().GetFamilyListInfo(param);
List <Shoolar_apply_file> fileList = ProjectApplyHandleClass.getInstance().GetFileListInfo(param_file);
//国奖和三好学生标兵需要在系统上传生活照，学校宣传用。
List <Shoolar_apply_file> fileList_photo = ProjectApplyHandleClass.getInstance().GetFileListInfo(param_file_photo);
#endregion 参数设置
return(ByProjectTypeCheckInfo(head, txt, rewardList, studyList, familyList, fileList, fileList_photo));
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "判断是否满足奖助申请提交条件，出错：" + ex.ToString());
return("是否满足提交条件校验出现异常！");
}
}
/// <summary>
/// 数据加载
/// </summary>
/// <param name="oid"></param>
private void GetPrintData(string oid)
{
#region 奖助申请信息
//奖助申请信息
head.OID = oid;
ds.RetrieveObject(head);
if (head == null)
{
return;
}
strPrintCode = ComHandleClass.getInstance().GetStuWorNo(head.STU_NUMBER, head.PROJECT_YEAR);
head.PROJECT_YEAR = cod.GetDDLTextByValue("ddl_year_type", head.PROJECT_YEAR);
head.XY = cod.GetDDLTextByValue("ddl_department", head.XY);
head.ZY = cod.GetDDLTextByValue("ddl_zy", head.ZY);
head.REWARD_FLAG = cod.GetDDLTextByValue("ddl_apply_reward_flag_2", head.REWARD_FLAG);
//大文本数据
if (ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO) != null)
{
txt = ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO);
}
#endregion 奖助申请信息
#region 学生基础信息
//学生基础信息
if (StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER) != null)
{
stu = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
stu.SEX = cod.GetDDLTextByValue("ddl_xb", stu.SEX);
stu.POLISTATUS = cod.GetDDLTextByValue("ddl_zzmm", stu.POLISTATUS);
stu.NATION = cod.GetDDLTextByValue("ddl_mz", stu.NATION);
stu.SYSTEM = cod.GetDDLTextByValue("ddl_edu_system", stu.SYSTEM);
}
#endregion 学生基础信息
#region 公共参数
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
#endregion 公共参数
#region 成绩信息
//成绩信息
if (ProjectApplyHandleClass.getInstance().GetStudyInfo(param) != null)
{
study = ProjectApplyHandleClass.getInstance().GetStudyInfo(param);
study.IS_SCORE_FLAG = cod.GetDDLTextByValue("ddl_yes_no", study.IS_SCORE_FLAG);
}
#endregion 成绩信息
#region 获奖列表
//获奖列表
List <Shoolar_apply_reward> rewardList = ProjectApplyHandleClass.getInstance().GetRewardListInfo(param);
if (rewardList != null)
{
if (rewardList.Count == 0)
{
divReward.InnerHtml = "无";
}
else
{
StringBuilder strR = new StringBuilder();
foreach (Shoolar_apply_reward item in rewardList)
{
if (item == null)
{
continue;
}
strR.AppendFormat("{0} {1} {2}<br/>", cod.GetDDLTextByValue("ddl_year_type", item.REWARD_DATE), item.REWARD_NAME, item.AWARD_DEPARTMENT);
}
divReward.InnerHtml = strR.ToString();
}
}
#endregion 获奖列表
}
private void GetPrintData(string oid)
{
#region 奖助申请信息
//奖助申请信息
head.OID = oid;
ds.RetrieveObject(head);
if (head == null)
{
return;
}
strPrintCode = ComHandleClass.getInstance().GetStuWorNo(head.STU_NUMBER, head.PROJECT_YEAR);
head.PROJECT_YEAR = cod.GetDDLTextByValue("ddl_year_type", head.PROJECT_YEAR);
//标题
if (head.PROJECT_TYPE.Equals("COUNTRY_YP"))//国家奖学金（研究生/博士）
{
strTitle = string.Format("广西师范大学{0}学年研究生国家奖学金申请审批表", head.PROJECT_YEAR);
}
else if (head.PROJECT_TYPE.Equals("COUNTRY_STUDY"))//国家学业奖学金
{
strTitle = string.Format(" 广西师范大学({0}学年)学业奖学金申请审批表", head.PROJECT_YEAR);
}
else if (head.PROJECT_TYPE.Equals("SCHOOL_NOTCOUNTRY"))//非国家级奖学金
{
strTitle = string.Format(" 广西师范大学({0}学年)研究生{1}申请审批表", head.PROJECT_YEAR, head.PROJECT_NAME);
}
head.XY = cod.GetDDLTextByValue("ddl_department", head.XY);
head.ZY = cod.GetDDLTextByValue("ddl_zy", head.ZY);
head.TRAIN_TYPE = cod.GetDDLTextByValue("ddl_apply_train_type", head.TRAIN_TYPE);
head.STUDY_LEVEL = cod.GetDDLTextByValue("ddl_apply_study_level", head.STUDY_LEVEL);
//大文本数据
if (ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO) != null)
{
txt = ProjectApplyHandleClass.getInstance().GetTxtInfo(head.SEQ_NO);
}
#endregion 奖助申请信息
#region 学生基础信息
//学生基础信息
if (StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER) != null)
{
stu = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
stu.SEX = cod.GetDDLTextByValue("ddl_xb", stu.SEX);
stu.POLISTATUS = cod.GetDDLTextByValue("ddl_zzmm", stu.POLISTATUS);
stu.NATION = cod.GetDDLTextByValue("ddl_mz", stu.NATION);
stu.SYSTEM = cod.GetDDLTextByValue("ddl_edu_system", stu.SYSTEM);
}
#endregion 学生基础信息
#region 公共参数
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
#endregion 公共参数
#region 学习情况（分为 成绩信息 与 科目成绩列表）
#region 成绩信息
//成绩信息
if (ProjectApplyHandleClass.getInstance().GetStudyInfo(param) != null)
{
study = ProjectApplyHandleClass.getInstance().GetStudyInfo(param);
study.IS_SCORE_FLAG = cod.GetDDLTextByValue("ddl_yes_no", study.IS_SCORE_FLAG);
}
#endregion 成绩信息
#region 科目成绩列表
//科目成绩列表
List <Shoolar_apply_study_list> studyList = ProjectApplyHandleClass.getInstance().GetStudyListInfo(param);
if (studyList == null)
{
return;
}
if (studyList.Count != 0)
{
nScoreList = nScoreList + studyList.Count;
}
StringBuilder strS = new StringBuilder();
foreach (Shoolar_apply_study_list item in studyList)
{
if (item == null)
{
continue;
}
strS.AppendFormat("<tr><td colspan=\"4\">{0}</td><td colspan=\"2\">{1}</td></tr>", item.COURSE_NAME, item.SCORE);
}
divScore.InnerHtml = strS.ToString();
#endregion 科目成绩列表
#endregion 学习情况（分为 成绩信息 与 科目成绩列表）
#region 获奖列表
//获奖列表
List <Shoolar_apply_reward> rewardList = ProjectApplyHandleClass.getInstance().GetRewardListInfo(param);
if (rewardList != null)
{
if (rewardList.Count == 0)
{
divReward.InnerHtml = "无";
}
else
{
StringBuilder strR = new StringBuilder();
foreach (Shoolar_apply_reward item in rewardList)
{
if (item == null)
{
continue;
}
strR.AppendFormat("{0} {1} {2}<br/>", cod.GetDDLTextByValue("ddl_year_type", item.REWARD_DATE), item.REWARD_NAME, item.AWARD_DEPARTMENT);
}
divReward.InnerHtml = strR.ToString();
}
}
#endregion 获奖列表
}
