/// <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 SaveData()
{
try
{
if (string.IsNullOrEmpty(Post("OID")))
{
return("主键不能为空！");
}
Insur_project_head model = new Insur_project_head();
model.OID = Post("OID");
ds.RetrieveObject(model);
#region 发送信息核对信息
string strMsgOid = string.Empty;
if (model.CHECK_MSG_ID.Length == 0)
{
strMsgOid = SendMsg(model.SEQ_NO);
}
else
{
//删除相关信息数据
string strDelMsgSql = string.Format("DELETE FROM MESSGE_INFO WHERE OID = '{0}' ", model.CHECK_MSG_ID);
string strDelMsg_ListSql = string.Format("DELETE FROM MESSGE_ACCPTER WHERE MSG_OID = '{0}' ", model.CHECK_MSG_ID);
ds.ExecuteTxtNonQuery(strDelMsgSql);
ds.ExecuteTxtNonQuery(strDelMsg_ListSql);
//重新发送信息
strMsgOid = SendMsg(model.SEQ_NO);
}
#endregion 发送信息核对信息
#region 保存信息核对
if (strMsgOid.Length > 0)
{
//清除核对信息
model.CHECK_START = Post("CHECK_START");
model.CHECK_END = Post("CHECK_END");
model.CHECK_IS_SEND = CValue.FLAG_Y;
model.CHECK_MSG_ID = strMsgOid;
model.CHECK_OP_CODE = user.User_Id;
model.CHECK_OP_NAME = user.User_Name;
model.CHECK_OP_TIME = GetDateLongFormater();
ds.UpdateObject(model);
}
#endregion 保存信息核对
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保存保险项目数据，出错：" + ex.ToString());
return("保存失败！");
}
}
/// <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 ChkCheckData()
{
if (string.IsNullOrEmpty(Get("id")))
{
return("保险项目主键不能为空！");
}
Insur_project_head head = new Insur_project_head();
head.OID = Get("id");
ds.RetrieveObject(head);
if (head == null)
{
return("保险项目信息不能为空！");
}
if (string.IsNullOrEmpty(head.CHECK_START))
{
return("保险项目核对信息未设置，不能发布公告！");
}
return(string.Empty);
}
/// <summary>
/// 通过传入的主键编码删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
try
{
if (string.IsNullOrEmpty(Get("id")))
{
return("主键为空,不允许删除操作");
}
Insur_project_head model = new Insur_project_head();
model.OID = Get("id");
ds.RetrieveObject(model);
//删除发布的核对信息
Messge_info msg = new Messge_info();
msg.OID = model.CHECK_MSG_ID;
ds.RetrieveObject(msg);
var transaction = ImplementFactory.GetDeleteTransaction <Messge_info>("Messge_infoDeleteTransaction");
transaction.EntityList.Add(msg);
if (transaction.Commit())
{
//清除核对信息
model.CHECK_START = "";
model.CHECK_END = "";
model.CHECK_IS_SEND = "";
model.CHECK_MSG_ID = "";
model.CHECK_OP_CODE = "";
model.CHECK_OP_NAME = "";
model.CHECK_OP_TIME = "";
ds.UpdateObject(model);
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "删除保险项目数据，出错：" + ex.ToString());
return("删除失败！");
}
}
