public string get_investigation(string cid) { string response = ""; try { investigation invest = db_context.investigation.Where(t => t.cid == cid).SingleOrDefault(); if (invest != null) { response = JsonConvert.SerializeObject(invest, json_setting); } else { response = "{}"; } } catch (Exception ex) { response = ex.Message; } return(response); }
public string save_case(string case_, string investigation) { string response = ""; int authority_level = int.Parse(Request.Cookies["authority_level"].Value); /*try * {*/ if (investigation != null) { var _investigation = JsonConvert.DeserializeObject <investigation>(investigation); var old_investigation = db_context.investigation.Where(t => t.cid == _investigation.cid).SingleOrDefault(); var is_new = false; if (old_investigation == null) { old_investigation = new investigation(); is_new = true; } old_investigation.cid = _investigation.cid; if (authority_level >= 2) //初录、理算 { old_investigation.investigation_cause = _investigation.investigation_cause; } if (authority_level >= 4) //审核 { old_investigation.investigation_area = _investigation.investigation_area; old_investigation.contact = _investigation.contact; old_investigation.contact_phone = _investigation.contact_phone; old_investigation.survey_points = _investigation.survey_points; } if (authority_level >= 5) //审批 { old_investigation.approval_result = _investigation.approval_result; old_investigation.approval_remark = _investigation.approval_remark; } if (is_new) { db_context.investigation.AddObject(old_investigation); } } cases _case = JsonConvert.DeserializeObject <cases>(case_); if (_case.id > 0) //修改 { cases old_case = db_context.cases.Where(t => t.id == _case.id).SingleOrDefault(); if (old_case != null) { old_case.current_state = _case.current_state; old_case.is_submit = _case.is_submit; if (authority_level >= 1) { old_case.is_reported = _case.is_reported; old_case.report_time = _case.report_time; old_case.application_id = _case.application_id; old_case.policy_id = _case.policy_id; old_case.report_type = _case.report_type; old_case.report_phone = _case.report_phone; old_case.insurant_name = _case.insurant_name; old_case.insurant_age = _case.insurant_age; old_case.insurant_sex = _case.insurant_sex; old_case.insurant_habitation = _case.insurant_habitation; old_case.insurant_idcard = _case.insurant_idcard; old_case.insurant_phone = _case.insurant_phone; old_case.accident_address = _case.accident_address; old_case.accident_time = _case.accident_time; old_case.policy_type = _case.policy_type; old_case.hospital_is_two_public = _case.hospital_is_two_public; old_case.hospital_name = _case.hospital_name; old_case.hospital_type = _case.hospital_type; old_case.case_type = _case.case_type; old_case.case_type_remark = _case.case_type_remark; if (old_case.report_user == null) { old_case.report_user = _case.report_user; } if (old_case.is_submit > 0 && old_case.report_submit_time == null) { old_case.report_submit_time = DateTime.Now; } } if (authority_level >= 2) { old_case.policy_holder = _case.policy_holder; old_case.accident_reason = _case.accident_reason; old_case.admissibility_type = _case.admissibility_type; old_case.compensation_type = _case.compensation_type; old_case.transfer_bank = _case.transfer_bank; old_case.transfer_name = _case.transfer_name; old_case.transfer_account = _case.transfer_account; old_case.is_data_holonomic = _case.is_data_holonomic; old_case.is_informed = _case.is_informed; old_case.data_remark = _case.data_remark; old_case.is_investigate = _case.is_investigate; old_case.expire_date = _case.expire_date; old_case.case_source = _case.case_source; if (old_case.record_user == null) { old_case.record_user = _case.record_user; } if (old_case.is_submit > 0 && old_case.record_submit_time == null) { old_case.record_submit_time = DateTime.Now; } } if (authority_level >= 3) { old_case.hospital_days = _case.hospital_days; old_case.subtract_type = _case.subtract_type; old_case.subtract_amount = _case.subtract_amount; old_case.compensation_amount = _case.compensation_amount; old_case.invoice_amount = _case.invoice_amount; old_case.deductible_amount = _case.deductible_amount; old_case.adjustment_remark = _case.adjustment_remark; old_case.is_diffcult = _case.is_diffcult; old_case.diffcult_reason = _case.diffcult_reason; old_case.subtract_type_remark = _case.subtract_type_remark; if (old_case.adjust_user == null) { old_case.adjust_user = _case.adjust_user; } if (old_case.is_submit > 0 && old_case.adjust_submit_time == null) { old_case.adjust_submit_time = DateTime.Now; } } if (authority_level >= 4) { old_case.is_need_communication = _case.is_need_communication; old_case.communication_content = _case.communication_content; old_case.communication_result = _case.communication_result; old_case.check_result = _case.check_result; old_case.check_subtract_type = _case.check_subtract_type; old_case.check_subtract_amount = _case.check_subtract_amount; old_case.check_subtract_content = _case.check_subtract_content; old_case.rejected_type = _case.rejected_type; old_case.rejected_nature = _case.rejected_nature; old_case.rejected_amount = _case.rejected_amount; old_case.rejected_reason = _case.rejected_reason; old_case.check_opinion = _case.check_opinion; if (old_case.check_user == null) { old_case.check_user = _case.check_user; } if (old_case.is_submit > 0 && old_case.check_submit_time == null) { old_case.check_submit_time = DateTime.Now; } } if (authority_level >= 5) { old_case.approval_result = _case.approval_result; if (old_case.approval_user == null) { old_case.approval_user = _case.approval_user; } if (old_case.is_submit > 0 && old_case.approval_submit_time == null) { old_case.approval_submit_time = DateTime.Now; } } db_context.SaveChanges(); response = _case.id.ToString(); } } else { if (authority_level == 1) { _case.report_submit_time = DateTime.Now; } db_context.cases.AddObject(_case); db_context.SaveChanges(); response = _case.id.ToString(); } /*} * catch (Exception ex) * { * response = ex.Message; * }*/ return(response); }