/// <summary> /// 自动生成数据 /// </summary> /// <returns></returns> private string AutoData() { try { string insur_seq_no = Post("insur_seq_no"); if (string.IsNullOrWhiteSpace(insur_seq_no)) { return("自动生成保险申请数据失败:参数不能为空!"); } Dictionary <string, string> param_pro_head = new Dictionary <string, string>(); param_pro_head.Add("SEQ_NO", insur_seq_no); Insur_project_head project = InsurHandleClass.getInstance().GetInsurProjectHeadInfo(param_pro_head); if (project == null) { return("自动生成保险申请数据失败:项目信息为空!"); } //当为“医保”的时候,判断是否设置了 保险期限、金额 if (project.INSUR_TYPE.Equals("A")) { if (project.INSUR_LIMITDATE.Length == 0 || project.INSUR_MONEY.ToString().Length == 0) { return("自动生成保险申请数据失败:项目信息中承保期限、金额设置不能为空!"); } } Dictionary <string, string> param = new Dictionary <string, string>(); List <Basic_stu_info> stuList = StuHandleClass.getInstance().GetStuInfoArray(param); if (stuList == null) { return("自动生成保险申请数据失败!"); } foreach (Basic_stu_info stu in stuList) { if (stu == null) { continue; } //删除相同学号的数据 string strSelectSql = string.Format("SELECT SEQ_NO FROM INSUR_PROJECT_APPLY WHERE INSUR_SEQ_NO = '{0}' AND STU_NUMBER = '{1}' ", insur_seq_no, stu.NUMBER); DataTable dt = ds.ExecuteTxtDataTable(strSelectSql); if (dt != null && dt.Rows.Count != 0) { string strDeleteSql_Head = string.Format("DELETE FROM INSUR_PROJECT_APPLY WHERE SEQ_NO = '{0}' ", dt.Rows[0]["SEQ_NO"].ToString()); string strDeleteSql_Check = string.Format("DELETE FROM INSUR_APPLY_CHECK WHERE SEQ_NO = '{0}' ", dt.Rows[0]["SEQ_NO"].ToString()); ds.ExecuteTxtNonQuery(strDeleteSql_Head); ds.ExecuteTxtNonQuery(strDeleteSql_Check); } //插入申请数据 Insur_project_apply head = InsertIntoApplyHead(project, stu); //插入预先核对信息 InsertIntoCheckInfo(head.SEQ_NO, head.INSUR_LIMITDATE, head.INSUR_MONEY); } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "自动生成保险申请数据,出错:" + ex.ToString()); return("自动生成保险申请数据失败!"); } }
/// <summary> /// 发送信息核对信息 /// </summary> /// <returns></returns> private string SendMsg(string strProjectSeqNo) { Dictionary <string, string> dic = InsurHandleClass.getInstance().GetCheckInfoMsgAccpterList(strProjectSeqNo); string strMsgOid = string.Empty; MessgeHandleClass.getInstance().SendMessge("I", Post("MSG_CONTENT"), user.User_Id, user.User_Name, dic, out strMsgOid); return(strMsgOid); }
/// <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() { try { Insur_project_head head = new Insur_project_head(); if (string.IsNullOrEmpty(Post("OID"))) { head.OID = Guid.NewGuid().ToString(); head.SEQ_NO = GetSeq_no(); ds.RetrieveObject(head); head.INSUR_NAME = Post("INSUR_NAME").Trim(); head.INSUR_INFO = Post("INSUR_INFO"); head.INSUR_YEAR = Post("INSUR_YEAR"); head.INSUR_TYPE = Post("INSUR_TYPE"); head.INSUR_LIMITDATE = Post("INSUR_LIMITDATE"); head.INSUR_MONEY = Math.Round(Convert.ToDecimal(Post("INSUR_MONEY")), 2); head.OP_CODE = user.User_Id; head.OP_NAME = user.User_Name; head.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ds.UpdateObject(head); } else { head.OID = Post("OID"); ds.RetrieveObject(head); head.INSUR_NAME = Post("INSUR_NAME").Trim(); head.INSUR_INFO = Post("INSUR_INFO"); head.INSUR_YEAR = Post("INSUR_YEAR"); head.INSUR_TYPE = Post("INSUR_TYPE"); head.INSUR_LIMITDATE = Post("INSUR_LIMITDATE"); head.INSUR_MONEY = Math.Round(Convert.ToDecimal(Post("INSUR_MONEY")), 2); head.OP_CODE = user.User_Id; head.OP_NAME = user.User_Name; head.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ds.UpdateObject(head); InsurHandleClass.getInstance().UpdateRelationFunction(head.SEQ_NO); } return(head.OID); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保险项目保存,出错:" + ex.ToString()); return(string.Empty); } }
/// <summary> /// 判断是否可以核对 /// </summary> /// <returns></returns> private string IsCanCheck() { try { if (string.IsNullOrEmpty(Get("id"))) { return("保险申请主键不能为空!"); } string strMsg = string.Empty; if (!InsurHandleClass.getInstance().IsCanCheck(Get("id"), user.User_Role, out strMsg)) { return(strMsg); } return(string.Empty); } catch (Exception ex) { LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "校验是否可以进行信息核对,出错:" + ex.ToString()); return("校验是否可以进行信息核对失败!"); } }
/// <summary> /// 批量确认核对信息 /// </summary> /// <returns></returns> private string MultiCheck() { try { DataTable dtMultiCheck = GetMultiCheckData(); if (dtMultiCheck == null) { return("批量核对失败:批量核对数据读取失败!"); } int nSuccessNum = 0; int nFailNum = 0; foreach (DataRow row in dtMultiCheck.Rows) { #region 筛选可以核对信息的数据 //筛选可以核对信息的数据 if (row == null) { continue; } string strMsg = string.Empty; if (!InsurHandleClass.getInstance().IsCanCheck(row["OID"].ToString(), user.User_Role, out strMsg)) { nFailNum++; continue; } #endregion 筛选可以核对信息的数据 #region 更新核对信息 Insur_project_apply head = new Insur_project_apply(); head.OID = row["OID"].ToString(); ds.RetrieveObject(head); if (head == null) { continue; } Insur_apply_check check = InsurHandleClass.getInstance().GetApplyCheckInfo(head.SEQ_NO); check.OID = check.OID; ds.RetrieveObject(check); #region 由于医保新增了 参保人员字段,未填写以及 判断附件是否存在 //ZZ 20171214 新增校验:由于医保新增了 参保人员字段,未填写以及 判断附件是否存在 if (head.INSUR_TYPE.Equals("A"))//医保 { //判断 参保人员类别 字段是否填写 if (check.APPLY_TYPE.Length == 0)//医保时,参保人员类别 字段必填 { continue; } //判断 参保人员类别 != 普通在校生 时,校验是否上传了附件 if (!check.APPLY_TYPE.Equals("A")) { string strSQL = string.Format("SELECT COUNT(*) FROM INSUR_APPLY_CHECK_FILE WHERE SEQ_NO = '{0}' ", check.SEQ_NO); int nCount = cod.ChangeInt(ds.ExecuteTxtScalar(strSQL).ToString()); if (nCount <= 0) { continue; } } } #endregion 由于医保新增了 参保人员字段,未填写以及 判断附件是否存在 switch (user.User_Role) { case "F": //辅导员 check.CHECK_STEP = "2"; //辅导员已核对 check.F_CHECK_CODE = user.User_Id; check.F_CHECK_NAME = user.User_Name; check.F_CHECK_TIME = GetDateLongFormater(); break; case "Y": //学院 check.CHECK_STEP = "3"; //学院已核对 check.Y_CHECK_CODE = user.User_Id; check.Y_CHECK_NAME = user.User_Name; check.Y_CHECK_TIME = GetDateLongFormater(); break; } ds.UpdateObject(check); nSuccessNum++; #endregion 更新核对信息 #region 步学生信息中的手机号,修改成核对后的数据 if (check.CHECK_STEP.Equals("3")) { #region 承保期限 if (check.NEW_INSUR_LIMITDATE.ToString().Length > 0) { head.INSUR_LIMITDATE = check.NEW_INSUR_LIMITDATE; } #endregion 承保期限 #region 金额 //金额大于0 if (check.NEW_INSUR_MONEY.ToString().Length > 0 && cod.ChangeInt(check.NEW_INSUR_MONEY.ToString()) > 0) { head.INSUR_MONEY = check.NEW_INSUR_MONEY; } #endregion 金额 ds.UpdateObject(head); } #endregion 步学生信息中的手机号,修改成核对后的数据 } return(string.Format("批量核对成功:生效{0}条记录,不生效{1}条记录。", nSuccessNum, nFailNum)); } 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); } }