/// <summary>
///保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
//先删除数据再新增
string strSQL = string.Format("DELETE FROM SHOOLAR_APPLY_STUDY WHERE SEQ_NO = '{0}' ", Get("seq_no"));
if (ds.ExecuteTxtNonQuery(strSQL) < 0)
{
return("保存上学年度综合考评成绩失败！");
}
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_study>("Shoolar_apply_studyInsertTransaction");
Shoolar_apply_study head = new Shoolar_apply_study();
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = Get("seq_no");
head.SCORE_RANK = cod.ChangeInt(Post("SCORE_RANK"));
head.SCORE_TOTAL_NUM = cod.ChangeInt(Post("SCORE_TOTAL_NUM"));
head.MUST_COURSE_NUM = cod.ChangeInt(Post("MUST_COURSE_NUM"));
head.PASS_COURSE_NUM = cod.ChangeInt(Post("PASS_COURSE_NUM"));
head.COM_SCORE_RANK = cod.ChangeInt(Post("COM_SCORE_RANK"));
head.COM_SCORE_TOTAL_NUM = cod.ChangeInt(Post("COM_SCORE_TOTAL_NUM"));
head.COM_SCORE = cod.ChangeDecimal(Post("COM_SCORE"));
head.IS_SCORE_FLAG = Post("IS_SCORE_FLAG");
head.PREYEAR_SCORE = Math.Round(cod.ChangeDecimal(Post("PREYEAR_SCORE")), 1);
inserttrcn.EntityList.Add(head);
if (!inserttrcn.Commit())
{
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);
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>
/// 数据加载
/// </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 获奖列表
}
