/// <summary>
/// 往奖助申报表中插入数据
/// </summary>
/// <param name="project"></param>
private Shoolar_apply_head InsertIntoApplyHead(Shoolar_project_head project, Basic_stu_info stu)
{
Shoolar_apply_head head = new Shoolar_apply_head();
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = BusDataDeclareTransaction.getInstance().GetSeq_no(CValue.DOC_TYPE_BDM03);
head.RET_CHANNEL = CValue.RET_CHANNEL_D4000;
head.CHK_STATUS = CValue.CHK_STATUS_N;
head.DOC_TYPE = CValue.DOC_TYPE_BDM03;
head.CHK_TIME = GetDateLongFormater();
head.DECL_TIME = GetDateLongFormater();
head.DECLARE_TYPE = CValue.DECLARE_TYPE_D;
#region 项目信息
head.PROJECT_SEQ_NO = project.SEQ_NO;
head.PROJECT_CLASS = project.PROJECT_CLASS;
head.PROJECT_TYPE = project.PROJECT_TYPE;
head.PROJECT_YEAR = project.APPLY_YEAR;
head.PROJECT_NAME = project.PROJECT_NAME;
head.PROJECT_MONEY = project.PROJECT_MONEY;
#endregion 项目信息
#region 保存学生信息
//学生信息
head.STU_NUMBER = stu.NUMBER;
head.STU_NAME = stu.NAME;
//学生信息
if (stu.STUTYPE.Equals(CValue.USER_STUTYPE_B))
{
head.STU_TYPE = CValue.USER_STUTYPE_B;
}
else
{
head.STU_TYPE = CValue.USER_STUTYPE_Y;
}
head.XY = stu.COLLEGE;
head.ZY = stu.MAJOR;
head.GRADE = stu.EDULENTH;
head.CLASS_CODE = stu.CLASS;
head.STU_IDCARDNO = stu.IDCARDNO;
head.STU_BANKCODE = StuHandleClass.getInstance().ByStuNoGetBankCode(head.STU_NUMBER);
#endregion 保存学生信息
ds.UpdateObject(head);
return(head);
}
/// <summary>
/// 往申报表中插入数据
/// </summary>
/// <param name="project"></param>
private Insur_project_apply InsertIntoApplyHead(Insur_project_head project, Basic_stu_info stu)
{
Insur_project_apply head = new Insur_project_apply();
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = BusDataDeclareTransaction.getInstance().GetSeq_no(CValue.DOC_TYPE_INS02);
head.RET_CHANNEL = CValue.RET_CHANNEL_D4000;
head.CHK_STATUS = CValue.CHK_STATUS_N;
head.DOC_TYPE = CValue.DOC_TYPE_BDM03;
head.CHK_TIME = GetDateLongFormater();
head.DECL_TIME = GetDateLongFormater();
head.DECLARE_TYPE = CValue.DECLARE_TYPE_D;
head.INSUR_FLAG = "N";//保险信息为N；参保之后为Y
#region 项目信息
head.INSUR_SEQ_NO = project.SEQ_NO;
head.INSUR_TYPE = project.INSUR_TYPE;
head.INSUR_YEAR = project.INSUR_YEAR;
head.INSUR_NAME = project.INSUR_NAME;
head.INSUR_LIMITDATE = project.INSUR_LIMITDATE;
head.INSUR_MONEY = project.INSUR_MONEY;
#endregion 项目信息
#region 保存学生信息
//学生信息
head.STU_NUMBER = stu.NUMBER;
head.STU_NAME = stu.NAME;
//学生信息
if (stu.STUTYPE.Equals(CValue.USER_STUTYPE_B))
{
head.STU_TYPE = CValue.USER_STUTYPE_B;
}
else
{
head.STU_TYPE = CValue.USER_STUTYPE_Y;
}
head.STU_PHONE = stu.MOBILENUM;
head.XY = stu.COLLEGE;
head.ZY = stu.MAJOR;
head.GRADE = stu.EDULENTH;
head.CLASS_CODE = stu.CLASS;
#endregion 保存学生信息
ds.UpdateObject(head);
return(head);
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
Basic_stu_info head = new Basic_stu_info();
if (string.IsNullOrEmpty(Post("OID")))
{
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = BusDataDeclareTransaction.getInstance().GetSeq_no("STU01");
LogDBHandleClass.getInstance().LogOperation(head.SEQ_NO, "学生基础信息管理", CValue.LOG_ACTION_TYPE_3, CValue.LOG_RECORD_TYPE_1, string.Format("新增学生"), user.User_Id, user.User_Name, user.UserLoginIP);
}
else
{
head.OID = Post("OID");
}
ds.RetrieveObject(head);
head.NUMBER = Post("NUMBER");
head.NAME = Post("NAME");
head.SEX = Post("SEX");
head.OP_NAME = user.User_Name;
head.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
head.GARDE = Post("GARDE");
head.EDULENTH = Post("EDULENTH");
head.COLLEGE = Post("COLLEGE");
head.POLISTATUS = Post("POLISTATUS");
head.MAJOR = Post("MAJOR");
head.NATION = Post("NATION");
head.CLASS = Post("CLASS");
head.IDCARDNO = Post("IDCARDNO");
head.US_NAME = Post("US_NAME");
head.HEIGTH = Post("HEIGTH");
head.WEIGTH = Post("WEIGTH");
head.GENIUS = Post("GENIUS");
head.HEALTH = Post("HEALTH");
head.TRAIN = Post("TRAIN");
head.STUWORK = Post("STUWORK");
head.CANDIDATE = Post("CANDIDATE");
head.ENROLLING = Post("ENROLLING");
head.CULTIVATION = Post("CULTIVATION");
head.COUN = Post("COUN");
head.EMAIL = Post("EMAIL");
head.QQNUM = Post("QQNUM");
head.ADDRESS = string.Format("{0}|{1}|{2}|{3}", Post("ADD_PROVINCE"), Post("ADD_CITY"), Post("ADD_COUNTY"), Post("ADD_STREET"));
head.CANDIDATE = Post("CANDIDATE");
head.SYSTEM = Post("SYSTEM");
head.STUTYPE = Post("STUTYPE");
head.REGISTER = Post("REGISTER");
head.DIFFDATE = Post("DIFFDATE");
head.MOBILENUM = Post("MOBILENUM");
ds.UpdateObject(head);
if (string.IsNullOrEmpty(Post("OID")))
{
LogDBHandleClass.getInstance().LogOperation(head.SEQ_NO, "学生基础信息管理", CValue.LOG_ACTION_TYPE_3, CValue.LOG_RECORD_TYPE_1, string.Format("新增学生信息：学号{0}，姓名{1}", head.NUMBER, head.NAME), user.User_Id, user.User_Name, user.UserLoginIP);
}
else
{
LogDBHandleClass.getInstance().LogOperation(head.SEQ_NO, "学生基础信息管理", CValue.LOG_ACTION_TYPE_4, CValue.LOG_RECORD_TYPE_1, string.Format("修改学生信息：学号{0}，姓名{1}", head.NUMBER, head.NAME), user.User_Id, user.User_Name, user.UserLoginIP);
}
InsertOrUpUser(head);
//同步业务数据
ComHandleClass.getInstance().UpdateRelationFunction(head.NUMBER);
return(head.OID);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "新增/修改学生信息出错：" + ex.ToString());
return(string.Empty);
}
}
/// <summary>
///保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
bool result = false;
Shoolar_apply_head head = new Shoolar_apply_head();
if (string.IsNullOrEmpty(Post("hidOid")))//新增
{
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = BusDataDeclareTransaction.getInstance().GetSeq_no(CValue.DOC_TYPE_BDM03);
head.RET_CHANNEL = Ret_Channel_A0000; //预录入 全程通道（回执状态）
head.DOC_TYPE = CValue.DOC_TYPE_BDM03;
GetPageValue(head);
#region 保存项目信息
//项目信息
Dictionary <string, string> param = new Dictionary <string, string>();
if (!string.IsNullOrEmpty(Post("hidProjectSeqNo")))
{
param.Add("SEQ_NO", Post("hidProjectSeqNo"));
}
Shoolar_project_head project = ProjectSettingHandleClass.getInstance().GetProjectList(param)[0];
if (project == null)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, string.Format("通过项目单据编号{0}，读取项目信息出错！", Post("hidProjectSeqNo")));
return(string.Empty);
}
head.PROJECT_SEQ_NO = project.SEQ_NO;
head.PROJECT_CLASS = project.PROJECT_CLASS;
head.PROJECT_TYPE = project.PROJECT_TYPE;
head.PROJECT_YEAR = project.APPLY_YEAR;
head.PROJECT_NAME = project.PROJECT_NAME;
head.PROJECT_MONEY = project.PROJECT_MONEY;
#endregion 保存项目信息
#region 保存学生信息
//学生信息
head.STU_NUMBER = user.User_Id;
head.STU_NAME = user.User_Name;
Basic_stu_info stuInfo = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
if (stuInfo == null)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, string.Format("通过学号{0}，读取学生信息出错！", head.STU_NUMBER));
return(string.Empty);
}
//学生信息
if (stuInfo.STUTYPE.Equals(CValue.USER_STUTYPE_B))
{
head.STU_TYPE = CValue.USER_STUTYPE_B;
}
else
{
head.STU_TYPE = CValue.USER_STUTYPE_Y;
}
head.XY = stuInfo.COLLEGE;
head.ZY = stuInfo.MAJOR;
head.GRADE = stuInfo.EDULENTH;
head.CLASS_CODE = stuInfo.CLASS;
head.STU_IDCARDNO = stuInfo.IDCARDNO;
head.STU_BANKCODE = StuHandleClass.getInstance().ByStuNoGetBankCode(head.STU_NUMBER);
#endregion 保存学生信息
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_head>("Shoolar_apply_headInsertTransaction");
inserttrcn.EntityList.Add(head);
result = inserttrcn.Commit();
if (result)
{
#region 步其他信息数据
//ZZ 20171125 新增：同步学生其他信息，因为在保存之前这些数据是还没有录入的 可以直接同步
#region 家庭情况
string strSynchroMsg = string.Empty;
ProjectApplyHandleClass.getInstance().InsertInto_apply_family(head.SEQ_NO, out strSynchroMsg);
if (strSynchroMsg.Length > 0)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请保存时，同步家庭情况出错：" + strSynchroMsg);
}
#endregion 家庭情况
#region 学习情况
ProjectApplyHandleClass.getInstance().InsertInto_apply_score(head.SEQ_NO, out strSynchroMsg);
if (strSynchroMsg.Length > 0)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请保存时，同步学习情况出错：" + strSynchroMsg);
}
#endregion 学习情况
#region 获奖情况
ProjectApplyHandleClass.getInstance().InsertInto_apply_reward(head.SEQ_NO, out strSynchroMsg);
if (strSynchroMsg.Length > 0)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请保存时，同步获奖情况出错：" + strSynchroMsg);
}
#endregion 获奖情况
#endregion 步其他信息数据
}
}
else//修改
{
head.OID = Post("hidOid");
ds.RetrieveObject(head);
GetPageValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Shoolar_apply_head>("Shoolar_apply_headUpdateTransaction", user.User_Name);
result = updatetrcn.Commit(head);
}
if (result)
{
StringBuilder json = new StringBuilder();//用来存放Json的
json.Append("{");
json.Append(Json.StringToJson(head.OID, "OID"));
json.Append(",");
json.Append(Json.StringToJson(head.SEQ_NO, "SEQ_NO"));
json.Append(",");
json.Append(Json.StringToJson(head.PROJECT_SEQ_NO, "PROJECT_SEQ_NO"));
json.Append("}");
return(json.ToString());
}//保存成功 返回JSON
else
{
return(string.Empty);
}
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保存奖助申请，出错：" + ex.ToString());
return(string.Empty);
}
}