/// <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);
}
}
