private string Save()
{
if (Request.QueryString["optype"].Equals("add"))
{
model.FUNCTIONID = Guid.NewGuid().ToString();
ds.RetrieveObject(model);
model.PARENTID = Request.QueryString["id"];
GetValue(model);
var inserttrcn = ImplementFactory.GetInsertTransaction <Ua_function>("Ua_functionInsertTransaction", user.User_Name);
inserttrcn.EntityList.Add(model);
if (inserttrcn.Commit())
{
return("保存成功");
}
return("保存失败");
}
else
{
model.FUNCTIONID = Request.QueryString["id"];
ds.RetrieveObject(model);
GetValue(model);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Ua_function>("Ua_functionUpdateTransaction", user.User_Name);
if (updatetrcn.Commit(model))
{
return("保存成功");
}
return("保存失败");
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
string oid = Post("hidOid_Content");
bool res = false;
Peer_project_list notboth = new Peer_project_list();
if (string.IsNullOrEmpty(oid))
{
oid = notboth.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(notboth);
notboth.SEQ_NO = Post("hidSeqNo_Content");
notboth.SEQUEUE = cod.ChangeInt(Post("SEQUEUE"));
notboth.PEER_CONTENT = Post("PEER_CONTENT");
var inserttrcn = ImplementFactory.GetInsertTransaction <Peer_project_list>("Peer_project_listInsertTransaction");
inserttrcn.EntityList.Add(notboth);
res = inserttrcn.Commit();
}
else
{
notboth.OID = oid;
ds.RetrieveObject(notboth);
notboth.SEQUEUE = cod.ChangeInt(Post("SEQUEUE"));
notboth.PEER_CONTENT = Post("PEER_CONTENT");
var updatetrcn = ImplementFactory.GetUpdateTransaction <Peer_project_list>("Peer_project_listUpdateTransaction", user.User_Name);
res = updatetrcn.Commit(notboth);
}
if (res)
{
return(oid);
}
else
{
return(string.Empty);
}
}
/// <summary>
///保存方法
/// </summary>
/// <returns></returns>
private string SaveData()
{
bool result = false;
Peer_coun_head head = new Peer_coun_head();
if (string.IsNullOrEmpty(Post("hidOid")))//新增
{
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = GetSeq_no();
GetPageValue(head);
var inserttrcn = ImplementFactory.GetInsertTransaction <Peer_coun_head>("Peer_coun_headInsertTransaction");
inserttrcn.EntityList.Add(head);
result = inserttrcn.Commit();
}
else//修改
{
head.OID = Post("hidOid");
ds.RetrieveObject(head);
GetPageValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Peer_coun_head>("Peer_coun_headUpdateTransaction", user.User_Name);
result = updatetrcn.Commit(head);
}
if (result)
{
//成功之后保存表体
SaveDataList(head.SEQ_NO, head.PEER_SEQ_NO);
return(head.OID);
}
else
{
return(string.Empty);
}
}
/// <summary>
/// 提交操作
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
if (string.IsNullOrEmpty(Post("hidOid")))
{
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = GetSeq_no();
GetValue(head);
head.DOC_TYPE = this.Doc_type;
head.DECL_NUMBER = user.User_Id;
head.DECL_TIME = GetDateLongFormater();
var inserttrcn = ImplementFactory.GetInsertTransaction <Ua_class_group>("Ua_class_groupInsertTransaction");
inserttrcn.EntityList.Add(head);
if (!inserttrcn.Commit())
{
return("提交失败！");
}
}
else
{
head.OID = Post("hidOid");
ds.RetrieveObject(head);
GetValue(head);
head.DECL_NUMBER = user.User_Id;
head.DECL_TIME = GetDateLongFormater();
var updatetrcn = ImplementFactory.GetUpdateTransaction <Ua_class_group>("Ua_class_groupUpdateTransaction", user.User_Name);
if (!updatetrcn.Commit(head))
{
return("提交失败！");
}
}
//提交编班申请
string strOpNotes = string.Format("提交编班申请操作");
string strMsg = string.Empty;
if (!WKF_ExternalInterface.getInstance().WKF_BusDeclare(head.DOC_TYPE, head.SEQ_NO, user.User_Name, user.User_Role, strOpNotes, out strMsg))
{
//20171017 ZZ 新增：由于编班没有暂存功能，所以编班提交失败或者没有权限提交，需要删除生成的数据。
string strDelSql = string.Format("DELETE FROM UA_CLASS_GROUP WHERE SEQ_NO = '{0}' ", head.SEQ_NO);
ds.ExecuteTxtNonQuery(strDelSql);
return(string.Format("编班提交失败，原因：{0}", strMsg));
}
return(string.Empty);
}
catch (Exception ex)
{
//20171017 ZZ 新增：由于编班没有暂存功能，所以编班提交失败或者没有权限提交，需要删除生成的数据。
string strDelSql = string.Format("DELETE FROM UA_CLASS_GROUP WHERE SEQ_NO = '{0}' ", head.SEQ_NO);
ds.ExecuteTxtNonQuery(strDelSql);
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "编班提交失败，原因：" + ex.ToString());
return("提交失败！");
}
}
/// <summary>
/// 保存附件
/// </summary>
/// <param name="strFileName"></param>
/// <param name="strFileDirectory"></param>
/// <returns></returns>
protected bool SaveFile(string strFileName, string strFileDirectory)
{
try
{
bool res = false;
Insur_apply_check_file head = new Insur_apply_check_file();
if (string.IsNullOrEmpty(hidOid_File.Value))
{
head.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(head);
head.SEQ_NO = hidRelationSeqNo_File.Value;
head.FILE_TYPE = hidFile_FILE_TYPE.Value;
head.FILE_NAME = hidFile_FILE_NAME.Value;
head.FILE_SAVE_NAME = strFileName;
strFileDirectory = strFileDirectory.Replace(@"\", @"/");//将字符串中所有反斜杠\替换成正斜杠/
head.FILE_DIRECTORY = strFileDirectory;
var inserttrcn = ImplementFactory.GetInsertTransaction <Insur_apply_check_file>("Insur_apply_check_fileInsertTransaction");
inserttrcn.EntityList.Add(head);
res = inserttrcn.Commit();
}
else
{
head.OID = hidOid_File.Value;
ds.RetrieveObject(head);
head.FILE_TYPE = hidFile_FILE_TYPE.Value;
head.FILE_NAME = hidFile_FILE_NAME.Value;
head.FILE_SAVE_NAME = strFileName;
strFileDirectory = strFileDirectory.Replace(@"\", @"/");//将字符串中所有反斜杠\替换成正斜杠/
head.FILE_DIRECTORY = strFileDirectory;
var updatetrcn = ImplementFactory.GetUpdateTransaction <Insur_apply_check_file>("Insur_apply_check_fileUpdateTransaction", user.User_Name);
res = updatetrcn.Commit(head);
}
if (res)
{
//保存核对表头的参保人员类型
Insur_apply_check check = InsurHandleClass.getInstance().GetApplyCheckInfo(head.SEQ_NO);
if (check != null)
{
ds.RetrieveObject(check);
check.APPLY_TYPE = hidFile_FILE_TYPE.Value;
ds.UpdateObject(check);
}
}
return(res);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "公告附件上传失败：" + ex.ToString());
return(false);
}
}
/// <summary>
///保存方法
/// </summary>
/// <returns></returns>
private string SaveData()
{
bool result = false;
Shoolar_project_head head = new Shoolar_project_head();
if (string.IsNullOrEmpty(Post("hidOid")))//新增
{
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = GetSeq_no();
GetPageValue(head);
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_project_head>("Shoolar_project_headInsertTransaction");
inserttrcn.EntityList.Add(head);
result = inserttrcn.Commit();
}
else//修改
{
head.OID = Post("hidOid");
ds.RetrieveObject(head);
GetPageValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Shoolar_project_head>("Shoolar_project_headUpdateTransaction", user.User_Name);
result = updatetrcn.Commit(head);
if (result)
{
ProjectSettingHandleClass.getInstance().UpdateRelationFunction(head.SEQ_NO);
}
}
if (result)
{
if (head.PROJECT_CLASS.Equals("LIFE"))
{
if (string.IsNullOrEmpty(Post("hidOid")))//新增
{
InsertIntoLifeApplyData(head, Post("hidStudentType"));
}
else
{
UpdateLifeApplyData(head);
}
}
return(head.SEQ_NO);//保存成功 返回单据编号
}
else
{
return(string.Empty);
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
bool res = false;
Shoolar_apply_reward head = new Shoolar_apply_reward();
if (string.IsNullOrEmpty(Post("hidOid_Reward")))
{
head.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(head);
head.SEQ_NO = Post("hidSeqNo_Reward");
head.REWARD_NAME = Post("REWARD_NAME");
head.REWARD_DATE = Post("REWARD_DATE");
//head.REWARD_LEVEL = Post("REWARD_LEVEL");
head.AWARD_DEPARTMENT = Post("AWARD_DEPARTMENT");
head.REWARD_TYPE = Post("REWARD_TYPE");
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_reward>("Shoolar_apply_rewardInsertTransaction");
inserttrcn.EntityList.Add(head);
res = inserttrcn.Commit();
}
else
{
head.OID = Post("hidOid_Reward");
ds.RetrieveObject(head);
head.REWARD_NAME = Post("REWARD_NAME");
head.REWARD_DATE = Post("REWARD_DATE");
//head.REWARD_LEVEL = Post("REWARD_LEVEL");
head.AWARD_DEPARTMENT = Post("AWARD_DEPARTMENT");
head.REWARD_TYPE = Post("REWARD_TYPE");
var updatetrcn = ImplementFactory.GetUpdateTransaction <Shoolar_apply_reward>("Shoolar_apply_rewardUpdateTransaction", user.User_Name);
res = updatetrcn.Commit(head);
}
if (res)
{
return(head.OID);//成功返回主键
}
else
{
return(string.Empty);
}
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请，保存获奖情况数据失败：" + ex.ToString());
return(string.Empty);
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
bool res = false;
Shoolar_apply_family_list list = new Shoolar_apply_family_list();
if (string.IsNullOrEmpty(Post("hidOid_FamilyMember")))
{
list.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(list);
list.SEQ_NO = Post("hidSeqNo_FamilyMember");
list.MEMBER_NAME = Post("MEMBER_NAME");
list.MEMBER_AGE = cod.ChangeInt(Post("MEMBER_AGE"));
list.MEMBER_RELATION = Post("MEMBER_RELATION");
list.MEMBER_UNIT = Post("MEMBER_UNIT");
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_family_list>("Shoolar_apply_family_listInsertTransaction");
inserttrcn.EntityList.Add(list);
res = inserttrcn.Commit();
}
else
{
list.OID = Post("hidOid_FamilyMember");
ds.RetrieveObject(list);
list.MEMBER_NAME = Post("MEMBER_NAME");
list.MEMBER_AGE = cod.ChangeInt(Post("MEMBER_AGE"));
list.MEMBER_RELATION = Post("MEMBER_RELATION");
list.MEMBER_UNIT = Post("MEMBER_UNIT");
var updatetrcn = ImplementFactory.GetUpdateTransaction <Shoolar_apply_family_list>("Shoolar_apply_family_listUpdateTransaction", user.User_Name);
res = updatetrcn.Commit(list);
}
if (res)
{
return(list.OID);//成功返回主键
}
else
{
return(string.Empty);
}
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请，保存家庭成员数据失败：" + ex.ToString());
return(string.Empty);
}
}
/// <summary>
///保存方法
/// </summary>
/// <returns></returns>
private string SaveData()
{
bool result = false;
Peer_project_head head = new Peer_project_head();
if (string.IsNullOrEmpty(Post("hidOid")))//新增
{
head.OID = Guid.NewGuid().ToString();
head.SEQ_NO = GetSeq_no();
GetPageValue(head);
var inserttrcn = ImplementFactory.GetInsertTransaction <Peer_project_head>("Peer_project_headInsertTransaction");
inserttrcn.EntityList.Add(head);
result = inserttrcn.Commit();
}
else//修改
{
head.OID = Post("hidOid");
ds.RetrieveObject(head);
GetPageValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Peer_project_head>("Peer_project_headUpdateTransaction", user.User_Name);
result = updatetrcn.Commit(head);
if (result)
{
ProjectSettingHandleClass.getInstance().UpdateRelationFunction(head.SEQ_NO);
}
}
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("}");
return(json.ToString());
}
else
{
return(string.Empty);
}
}
private bool SaveData(string type)
{
object o = ds.ExecuteTxtScalar(string.Format("SELECT OID FROM BASIC_STU_INFO_MODI WHERE NUMBER = '{0}'", user.User_Id));
if (o != null && o.ToString().Length > 0)
{
modi.OID = o.ToString();
ds.RetrieveObject(modi);
GetValue(modi);
modi.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
modi.OP_CODE = user.User_Id;
modi.OP_NAME = user.User_Name;
modi.RET_CHANNEL = CValue.RET_CHANNEL_A0000;
var updatetrcn = ImplementFactory.GetUpdateTransaction <Basic_stu_info_modi>("Basic_stu_info_modiUpdateTransaction", user.User_Name);
if (updatetrcn.Commit(modi))
{
return(true);
}
}
else
{
modi.OID = Guid.NewGuid().ToString();
GetValue(modi);
modi.SEQ_NO = GetSeq_no();
modi.DOC_TYPE = this.Doc_type;
modi.NUMBER = user.User_Id;
modi.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
modi.OP_CODE = user.User_Id;
modi.OP_NAME = user.User_Name;
modi.RET_CHANNEL = CValue.RET_CHANNEL_A0000;
var inserttrcn = ImplementFactory.GetInsertTransaction <Basic_stu_info_modi>("Basic_stu_info_modiInsertTransaction");
inserttrcn.EntityList.Add(modi);
if (inserttrcn.Commit())
{
return(true);
}
}
return(false);
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
string oid = Post("hidOid_Notboth");
bool res = false;
Shoolar_project_notboth notboth = new Shoolar_project_notboth();
if (string.IsNullOrEmpty(oid))
{
oid = notboth.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(notboth);
notboth.SEQ_NO = Post("hidSeqNo_Notboth");
notboth.PROJECT_YEAR = Post("PROJECT_YEAR_NOTBOTH");
notboth.PROJECT_CLASS = Post("PROJECT_CLASS_NOTBOTH");
notboth.PROJECT_TYPE = Post("PROJECT_TYPE_NOTBOTH");
notboth.PROJECT_SEQ_NO = Post("PROJECT_SEQ_NO");
notboth.PROJECT_NAME = Post("hidProName_Notboth");
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_project_notboth>("Shoolar_project_notbothInsertTransaction");
inserttrcn.EntityList.Add(notboth);
res = inserttrcn.Commit();
}
else
{
notboth.OID = oid;
ds.RetrieveObject(notboth);
notboth.PROJECT_YEAR = Post("PROJECT_YEAR_NOTBOTH");
notboth.PROJECT_CLASS = Post("PROJECT_CLASS_NOTBOTH");
notboth.PROJECT_TYPE = Post("PROJECT_TYPE_NOTBOTH");
notboth.PROJECT_SEQ_NO = Post("PROJECT_SEQ_NO");
notboth.PROJECT_NAME = Post("hidProName_Notboth");
var updatetrcn = ImplementFactory.GetUpdateTransaction <Shoolar_project_notboth>("Shoolar_project_notbothUpdateTransaction", user.User_Name);
res = updatetrcn.Commit(notboth);
}
if (res)
{
return(oid);
}
else
{
return(string.Empty);
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
bool res = false;
Shoolar_apply_study_list list = new Shoolar_apply_study_list();
if (string.IsNullOrEmpty(Post("hidOid_StudyList")))
{
list.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(list);
list.SEQ_NO = Post("hidSeqNo_StudyList");
list.COURSE_NAME = Post("COURSE_NAME");
list.SCORE = Math.Round(cod.ChangeDecimal(Post("SCORE")), 1);
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_study_list>("Shoolar_apply_study_listInsertTransaction");
inserttrcn.EntityList.Add(list);
res = inserttrcn.Commit();
}
else
{
list.OID = Post("hidOid_StudyList");
ds.RetrieveObject(list);
list.COURSE_NAME = Post("COURSE_NAME");
list.SCORE = Math.Round(cod.ChangeDecimal(Post("SCORE")), 1);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Shoolar_apply_study_list>("Shoolar_apply_study_listUpdateTransaction", user.User_Name);
res = updatetrcn.Commit(list);
}
if (res)
{
return(list.OID);//成功返回主键
}
else
{
return(string.Empty);
}
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请，保存学习科目数据失败：" + ex.ToString());
return(string.Empty);
}
}
/// <summary>
/// 保存附件
/// </summary>
/// <param name="strFileName"></param>
/// <param name="strFileDirectory"></param>
/// <returns></returns>
protected bool SaveFile(string strFileName, string strFileDirectory)
{
try
{
bool res = false;
Shoolar_apply_file head = new Shoolar_apply_file();
if (string.IsNullOrEmpty(hidOid_File.Value))
{
head.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(head);
head.SEQ_NO = hidSeqNo_File.Value;
head.FILE_TYPE = hidFile_FILE_TYPE.Value;
head.FILE_NAME = hidFile_FILE_NAME.Value;
head.FILE_SAVE_NAME = strFileName;
strFileDirectory = strFileDirectory.Replace(@"\", @"/");//将字符串中所有反斜杠\替换成正斜杠/
head.FILE_DIRECTORY = strFileDirectory;
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_file>("Shoolar_apply_fileInsertTransaction");
inserttrcn.EntityList.Add(head);
res = inserttrcn.Commit();
}
else
{
head.OID = hidOid_File.Value;
ds.RetrieveObject(head);
head.FILE_TYPE = hidFile_FILE_TYPE.Value;
head.FILE_NAME = hidFile_FILE_NAME.Value;
head.FILE_SAVE_NAME = strFileName;
strFileDirectory = strFileDirectory.Replace(@"\", @"/");//将字符串中所有反斜杠\替换成正斜杠/
head.FILE_DIRECTORY = strFileDirectory;
var updatetrcn = ImplementFactory.GetUpdateTransaction <Shoolar_apply_file>("Shoolar_apply_fileUpdateTransaction", user.User_Name);
res = updatetrcn.Commit(head);
}
return(res);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助申请附件上传失败：" + ex.ToString());
return(false);
}
}
/// <summary>
/// 保存/提交事件
/// </summary>
/// <returns></returns>
private string Save()
{
try
{
bool bFlag = false;
Messge_info head = new Messge_info();
if (string.IsNullOrEmpty(Post("OID"))) //新增
{
head.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(head);
GetFormValue(head);
var inserttrcn = ImplementFactory.GetInsertTransaction <Messge_info>("Messge_infoInsertTransaction", user.User_Name);
inserttrcn.EntityList.Add(head);
bFlag = inserttrcn.Commit();
}
else //修改
{
head.OID = Post("OID");
ds.RetrieveObject(head);
GetFormValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Messge_info>("Messge_infoUpdateTransaction", user.User_Name);
bFlag = updatetrcn.Commit(head);
}
if (bFlag)
{
//插入接收人表
MessgeHandleClass.getInstance().InsertMessgeAccpter(head.OID, GetAccpter());
return(string.Empty);
}
return("信息发送失败！");
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "信息发送失败：" + ex.ToString());
return("信息发送失败！");
}
}
/// <summary>
///保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
bool result = false;
Question_info head = new Question_info();
if (string.IsNullOrEmpty(Post("hidOid")))//新增
{
head.OID = Guid.NewGuid().ToString();
GetPageValue(head);
var inserttrcn = ImplementFactory.GetInsertTransaction <Question_info>("Question_infoInsertTransaction");
inserttrcn.EntityList.Add(head);
result = inserttrcn.Commit();
}
else//修改
{
head.OID = Post("hidOid");
ds.RetrieveObject(head);
GetPageValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Question_info>("Question_infoUpdateTransaction", user.User_Name);
result = updatetrcn.Commit(head);
}
if (result)
{
return("提交成功！");
}
else
{
return(string.Empty);
}
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "提交问题反馈，出错：" + ex.ToString());
return(string.Empty);
}
}
/// <summary>
/// 保存方法
/// </summary>
/// <returns></returns>
private string Save()
{
try
{
bool result = false;
Score_rank_info head = new Score_rank_info();
if (string.IsNullOrEmpty(Post("hidOid")))//新增
{
//新增的时候，先通过学号+学年删除已有的数据再新增
string strDelSql = string.Format("DELETE FROM SCORE_RANK_INFO WHERE STU_NUMBER = '{0}' AND YEAR = '{1}' ", Post("STU_NUMBER"), Post("YEAR"));
ds.ExecuteTxtNonQuery(strDelSql);
//再新增
head.OID = Guid.NewGuid().ToString();
GetPageValue(head);
head.YEAR = Post("YEAR");
head.STU_NUMBER = Post("STU_NUMBER");
head.STU_NAME = Post("STU_NAME");
head.GRADE = Post("GRADE");
head.XY = Post("XY");
head.ZY = Post("ZY");
head.CLASS_CODE = Post("CLASS_CODE");
var inserttrcn = ImplementFactory.GetInsertTransaction <Score_rank_info>("Score_rank_infoInsertTransaction");
inserttrcn.EntityList.Add(head);
result = inserttrcn.Commit();
}
else//修改
{
head.OID = Post("hidOid");
ds.RetrieveObject(head);
GetPageValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Score_rank_info>("Score_rank_infoUpdateTransaction", user.User_Name);
result = updatetrcn.Commit(head);
}
if (!result)
{
return("成绩录入失败！");
}
#region 成绩录入后即可由系统直接计算排名，无须手动进行
//获得学生信息
Basic_stu_info stuInfo = StuHandleClass.getInstance().GetStuInfo_Obj(head.STU_NUMBER);
if (stuInfo != null)
{
//ZZ 20171023 新增：成绩录入后即可由系统直接计算排名，无须手动进行
var inserttrcn_scorequeue = ImplementFactory.GetInsertTransaction <Score_rank_queue>("Score_rank_queueInsertTransaction");
Score_rank_queue queue = new Score_rank_queue();
queue.OID = Guid.NewGuid().ToString();
queue.YEAR = head.YEAR;
queue.GRADE = head.GRADE;
queue.CLASSCODE = head.CLASS_CODE;
queue.CREATE_USER_ID = user.User_Id;
queue.CREATE_USER = user.User_Name;
queue.CREATE_TIME = GetDateLongFormater();
queue.CREATE_TYPE = "A";
queue.HANDLE_STATUS = "N";
queue.STU_TYPE = stuInfo.STUTYPE;//学生类型
inserttrcn_scorequeue.EntityList.Add(queue);
inserttrcn_scorequeue.Commit();
}
#endregion 成绩录入后即可由系统直接计算排名，无须手动进行
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "成绩录入失败，原因：" + ex.ToString());
return("成绩录入失败！");
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
bool bFlag = false;
//新增
Insur_apply_check head = new Insur_apply_check();
if (string.IsNullOrEmpty(Post("CHECK_OID")))
{
head.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(head);
head.SEQ_NO = Post("hidApplySeqNo");
GetFormValue(head);
//是否申请弃保 字段，如果没有值 就赋值 ，默认值 为否
if (string.IsNullOrWhiteSpace(Post("IS_REFUND")))
{
head.IS_REFUND = CValue.FLAG_N;
}
var inserttrcn = ImplementFactory.GetInsertTransaction <Insur_apply_check>("Insur_apply_checkInsertTransaction", user.User_Name);
inserttrcn.EntityList.Add(head);
if (inserttrcn.Commit())
{
bFlag = true;
}
}
else //修改
{
head.OID = Post("CHECK_OID");
ds.RetrieveObject(head);
GetFormValue(head);
//是否申请弃保 字段，如果没有值 就赋值 ，默认值 为否
if (string.IsNullOrWhiteSpace(Post("IS_REFUND")))
{
head.IS_REFUND = CValue.FLAG_N;
}
var updatetrcn = ImplementFactory.GetUpdateTransaction <Insur_apply_check>("Insur_apply_checkUpdateTransaction", user.User_Name);
if (updatetrcn.Commit(head))
{
bFlag = true;
}
}
if (bFlag)
{
#region 保存成功之后，修改的 手机号、身份证号、银行卡号 同步更新至学生个人信息中
//ZZ 20171213 修改：保存成功之后，修改的 手机号、身份证号、银行卡号 同步更新至学生个人信息中
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
Insur_project_apply apply = InsurHandleClass.getInstance().GetInsurProjectApplyInfo(param);
if (apply != null)
{
//手机号
if (!string.IsNullOrWhiteSpace(Post("STU_PHONE")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_Phone(apply.STU_NUMBER, Post("STU_PHONE"));
}
//身份证号
if (!string.IsNullOrWhiteSpace(Post("STU_IDNO")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_IDNo(apply.STU_NUMBER, Post("STU_IDNO"));
}
//银行卡号
if (!string.IsNullOrWhiteSpace(Post("STU_BANDKCODE")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_BankCode(apply.STU_NUMBER, Post("STU_BANDKCODE"));
}
}
#endregion 保存成功之后，修改的 手机号、身份证号、银行卡号 同步更新至学生个人信息中
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("}");
return(json.ToString());
}
else
{
return(string.Empty);
}
}
/// <summary>
/// 保存/提交事件
/// </summary>
/// <returns></returns>
private string Save()
{
try
{
#region 新增/修改公告
bool bFlag = false;
Notice_info head = new Notice_info();
if (string.IsNullOrEmpty(Post("hidNOTICE_OID"))) //新增
{
head.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(head);
GetFormValue(head);
var inserttrcn = ImplementFactory.GetInsertTransaction <Notice_info>("Notice_infoInsertTransaction", user.User_Name);
inserttrcn.EntityList.Add(head);
bFlag = inserttrcn.Commit();
}
else //修改
{
head.OID = Post("hidNOTICE_OID");
ds.RetrieveObject(head);
GetFormValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Notice_info>("Notice_infoUpdateTransaction", user.User_Name);
bFlag = updatetrcn.Commit(head);
}
#endregion 新增/修改公告
#region 发布成功之后操作
if (bFlag)
{
try
{
#region 重新更新公告内容
//重新更新公告内容
StringBuilder strTxt = new StringBuilder();
strTxt.AppendFormat("NOTICE_CONTENT = '{0}' ", Post("NOTICE_CONTENT"));//事迹正文
if (!ComHandleClass.getInstance().UpdateTextContent(head.OID, "OID", strTxt.ToString(), "NOTICE_INFO"))
{
return("保存公告内容失败！");
}
#endregion 重新更新公告内容
#region 奖助项目要更新公告ID
//奖助项目要更新公告ID
if (!string.IsNullOrEmpty(Request.QueryString["pro_oid"]))
{
string strUpProHead = string.Format("UPDATE SHOOLAR_PROJECT_HEAD SET NOTICE_ID = '{0}' WHERE OID = '{1}' ", head.OID, Request.QueryString["pro_oid"].ToString());
ds.ExecuteTxtNonQuery(strUpProHead);
}
#endregion 奖助项目要更新公告ID
#region 奖助核对信息要更新公告ID
//奖助核对信息要更新公告ID
if (!string.IsNullOrEmpty(Request.QueryString["pro_check_oid"]))
{
string strUpProHead = string.Format("UPDATE SHOOLAR_PROJECT_HEAD SET CHECK_NOTICE_ID = '{0}' WHERE OID = '{1}' ", head.OID, Request.QueryString["pro_check_oid"].ToString());
ds.ExecuteTxtNonQuery(strUpProHead);
}
#endregion 奖助核对信息要更新公告ID
#region 保险核对信息要更新公告ID
//保险核对信息要更新公告ID
if (!string.IsNullOrEmpty(Request.QueryString["insur_check_oid"]))
{
string strUpProHead = string.Format("UPDATE INSUR_PROJECT_HEAD SET CHECK_NOTICE_ID = '{0}' WHERE OID = '{1}' ", head.OID, Request.QueryString["insur_check_oid"].ToString());
ds.ExecuteTxtNonQuery(strUpProHead);
}
#endregion 保险核对信息要更新公告ID
#region 贷款核对信息要更新公告ID
//贷款核对信息要更新公告ID
if (!string.IsNullOrEmpty(Request.QueryString["loan_check_oid"]))
{
string strUpProHead = string.Format("UPDATE LOAN_PROJECT_HEAD SET CHECK_NOTICE_ID = '{0}' WHERE OID = '{1}' ", head.OID, Request.QueryString["loan_check_oid"].ToString());
ds.ExecuteTxtNonQuery(strUpProHead);
}
#endregion 贷款核对信息要更新公告ID
#region 困难生认定基本设置要更新公告ID（困难生申请）
//困难生认定基本设置要更新公告ID（困难生申请）
else if (!string.IsNullOrEmpty(Request.QueryString["apply_oid"]))
{
string strUpProHead = string.Format("UPDATE DST_PARAM_INFO SET APPLY_NOTICE_ID = '{0}' WHERE OID = '{1}' ", head.OID, Request.QueryString["apply_oid"].ToString());
ds.ExecuteTxtNonQuery(strUpProHead);
}
#endregion 困难生认定基本设置要更新公告ID（困难生申请）
#region 困难生认定基本设置要更新公告ID（家庭经济调查）
//困难生认定基本设置要更新公告ID（家庭经济调查）
else if (!string.IsNullOrEmpty(Request.QueryString["survey_oid"]))
{
string strUpProHead = string.Format("UPDATE DST_PARAM_INFO SET SURVEY_NOTICE_ID = '{0}' WHERE OID = '{1}' ", head.OID, Request.QueryString["survey_oid"].ToString());
ds.ExecuteTxtNonQuery(strUpProHead);
}
#endregion 困难生认定基本设置要更新公告ID（家庭经济调查）
#region 岗位申报基本设置要更新公告ID
else if (!string.IsNullOrEmpty(Request.QueryString["job_oid"]))
{
string strUpProHead = string.Format("UPDATE QZ_JOB_MANAGE_SET SET NOTICE_ID = '{0}' WHERE OID = '{1}' ", head.OID, Request.QueryString["job_oid"].ToString());
ds.ExecuteTxtNonQuery(strUpProHead);
}
#endregion 岗位申报基本设置要更新公告
#region 劳酬凭据基本设置要更新公告
else if (!string.IsNullOrEmpty(Request.QueryString["proof_oid"]))
{
string strUpProHead = string.Format("UPDATE QZ_JOB_PROOF_SET SET NOTICE_ID = '{0}' WHERE OID = '{1}' ", head.OID, Request.QueryString["proof_oid"].ToString());
ds.ExecuteTxtNonQuery(strUpProHead);
}
#endregion 劳酬凭据基本设置要更新公告
}
catch (Exception ex)
{
return("发布公告，出错：" + ex.ToString());
}
}
#endregion 发布成功之后操作
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "发布公告，出错：" + ex.ToString());
return("发布公告，出错：" + ex.ToString());
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
bool bFlag = false;
//新增
Shoolar_apply_check head = new Shoolar_apply_check();
if (string.IsNullOrEmpty(Post("CHECK_OID")))
{
head.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(head);
head.SEQ_NO = Post("hidApplySeqNo");
GetFormValue(head);
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_check>("Shoolar_apply_checkInsertTransaction", user.User_Name);
inserttrcn.EntityList.Add(head);
if (inserttrcn.Commit())
{
bFlag = true;
}
}
else //修改
{
head.OID = Post("CHECK_OID");
ds.RetrieveObject(head);
GetFormValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Shoolar_apply_check>("Shoolar_apply_checkUpdateTransaction", user.User_Name);
if (updatetrcn.Commit(head))
{
bFlag = true;
}
}
if (bFlag)
{
#region 保存成功之后，修改的 学生信息 同步更新至学生个人信息中
//ZZ 20171213 修改：保存成功之后，修改的 手机号 同步更新至学生个人信息中
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
Shoolar_apply_head apply = ProjectApplyHandleClass.getInstance().GetApplyHeadInfo(param);
if (apply != null)
{
//手机号
if (!string.IsNullOrWhiteSpace(Post("STU_PHONE")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_Phone(apply.STU_NUMBER, Post("STU_PHONE"));
}
//ZZ 20180319 修改：保存成功之后，修改的 学籍状态以及异动时间 同步更新至学生个人信息中
if (!string.IsNullOrWhiteSpace(Post("STU_REGISTER")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_Register(apply.STU_NUMBER, Post("STU_REGISTER"));
}
if (!string.IsNullOrWhiteSpace(Post("STU_DIFFDATE")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_DiffDate(apply.STU_NUMBER, Post("STU_DIFFDATE"));
}
if (!string.IsNullOrWhiteSpace(Post("STU_RICE_CARD")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_RiceCard(apply.STU_NUMBER, Post("STU_RICE_CARD"));
}
}
#endregion 保存成功之后，修改的 学生信息 同步更新至学生个人信息中
return(string.Empty);
}
else
{
return("保存核对信息失败！");
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
bool bFlag = false;
//新增
Loan_apply_check head = new Loan_apply_check();
if (string.IsNullOrEmpty(Post("CHECK_OID")))
{
head.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(head);
head.SEQ_NO = Post("hidApplySeqNo");
GetFormValue(head);
var inserttrcn = ImplementFactory.GetInsertTransaction <Loan_apply_check>("Loan_apply_checkInsertTransaction", user.User_Name);
inserttrcn.EntityList.Add(head);
if (inserttrcn.Commit())
{
bFlag = true;
}
}
else //修改
{
head.OID = Post("CHECK_OID");
ds.RetrieveObject(head);
GetFormValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Loan_apply_check>("Loan_apply_checkUpdateTransaction", user.User_Name);
if (updatetrcn.Commit(head))
{
bFlag = true;
}
}
if (bFlag)
{
#region 保存成功之后，修改的 手机号、银行卡号 同步更新至学生个人信息中
//ZZ 20171213 修改：保存成功之后，修改的 手机号、身份证号 同步更新至学生个人信息中
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
Loan_project_apply apply = LoanHandleClass.getInstance().GetLoanProjectApplyInfo(param);
if (apply != null)
{
//手机号
if (!string.IsNullOrWhiteSpace(Post("STU_PHONE")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_Phone(apply.STU_NUMBER, Post("STU_PHONE"));
}
//身份证号
if (!string.IsNullOrWhiteSpace(Post("STU_IDNO")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_IDNo(apply.STU_NUMBER, Post("STU_IDNO"));
}
}
#endregion 保存成功之后，修改的 手机号、银行卡号 同步更新至学生个人信息中
return(string.Empty);
}
else
{
return("保存核对信息失败！");
}
}
/// <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);
}
}