123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160 |
- using System;
- using CLIP.eForm.Server.Data;
- using CLIP.eForm.Server.VO;
- using IBatisNet.DataMapper;
- using System.Collections.Generic;
- using System.Collections;
- using CLIP.eForm.Consent.Entity;
- namespace CLIP.eForm.Consent.Dac {
- public class SaveConsentDac : DacBase {
- public int InsertConsentMst(ISqlMapper mapper, Hashtable param) {
- return mapper.QueryForObject<Int32>("INSERT_CONSENT_MST", param);
- }
- public int ReWriteUpdateConsentMst(ISqlMapper mapper, Hashtable param) {
- return mapper.QueryForObject<Int32>("REWRITE_UPDATE_CONSENT_MST", param);
- }
- public void InsertConsentData(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("INSERT_CONSENT_DATA", param);
- }
- public void InsertConsentAudio(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("INSERT_CONSENT_AUDIO", param);
- }
- public void InsertConsentImage(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("INSERT_CONSENT_IMAGE", param);
- }
- public void InsertConsentImageSign(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("INSERT_CONSENT_IMAGE_SIGN", param);
- }
- public void UpdateConsentMst(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("UPDATE_CONSENT_MST", param);
- }
- public void UpdateConsentData(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("UPDATE_CONSENT_DATA", param);
- }
- public void UpdateConsentMstForReissue(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("UPDATE_CONSENT_MST_FOR_REISSUE", param);
- }
- public String UpdateConsentMstForDelete(ISqlMapper mapper, Hashtable param) {
- //return mapper.Update("UPDATE_CONSENT_MST_FOR_DELETE", param);
- return (String) mapper.Insert("UPDATE_CONSENT_MST_FOR_DELETE", param);
- }
- public int UpdateMrfhocrprntStatCd(ISqlMapper mapper, Hashtable param) {
- return mapper.Update("UPDATE_MRFHOCRPRNT_STATCD", param);
- }
- public void UpdateConsentMstStatus(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("UPDATE_CONSENT_MST_STATUS", param);
- }
- public void SetConsentDataChoice(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("INSERT_CONSENT_DATA_CHOICE", param);
- }
- public void SetMediHistory(ISqlMapper mapper, Hashtable param) {
- mapper.QueryForObject<Int32>("SET_MEDI_HISTORY", param);
- }
- /// <summary>
- /// OCR 히스토리 테이블 저장
- /// </summary>
- /// <param name="mapper"></param>
- /// <param name="param"></param>
- public void InsertPrintData(ISqlMapper mapper, Hashtable param) {
- mapper.Insert("setOcrPrntInfo", param);
- mapper.Insert("setOcrPrntHistInfo", param);
- }
- public void InsertPrintData(ISqlMapper mapper, Hashtable param, bool isNewConsentMasterCase) {
- //string histYN = mapper.QueryForObject<String>("getOcrPrntHistYN", param);
- //histYN = histYN ?? "Y";
- mapper.Insert("setOcrPrntInfo", param);
- if (isNewConsentMasterCase == false) {
- mapper.Update("updateOcrPrntHistInfo", param);
- }
- mapper.Insert("setOcrPrntHistInfo", param);
- //if (histYN.Equals("Y")) {
- //}
- }
- public void InsertPmcmspif(ISqlMapper mapper, Hashtable param) {
- mapper.Insert("insPmcmspif", param);
- }
- public void InsertPmihagmt(ISqlMapper mapper, Hashtable param) {
- mapper.Insert("insPmihagmt", param);
- }
- public void InsertPmcminfo(ISqlMapper mapper, Hashtable param) {
- mapper.Insert("insPmcminfo", param);
- }
- public IList<string> getOcrType6Forms(ISqlMapper mapper, Hashtable param) {
- return mapper.QueryForList<string>("getOcrType6Forms", param);
- //return null;
- }
- /// <summary>
- /// 개인정보동의서 인증저장시 PAM.PMCMPICM에 넣을 SEQ 번호를 가져온다
- /// </summary>
- /// <param name="mapper"></param>
- /// <param name="param"></param>
- /// <returns></returns>
- public int getPamSeqNo(ISqlMapper mapper, Hashtable param) {
- return mapper.QueryForObject<int>("getPamSeqNo", param);
- }
- public int updatePreSignData(ISqlMapper mapper, Hashtable param) {
- return mapper.QueryForObject<int>("updatePreSignData", param);
- }
- public int insPmcmpicm(ISqlMapper mapper, Hashtable param) {
- return (Int32)mapper.QueryForObject<int>("insPmcmpicm", param);
- }
- public int SaveAutoCompleteAll(ISqlMapper mapper, Hashtable param) {
- int result = 0;
- result = mapper.Update("SAVE_AUTO_MASTER_UPDATE", param);
- if (result > 0) {
- result = mapper.Update("SAVE_AUTO_MRFMOCRPRNT", param);
- }
-
- if (result > 0) {
- result = mapper.Update("SAVE_AUTO_MRFHOCRPRNT", param);
- }
-
- return result;
- }
- public int ImrCount(ISqlMapper mapper, Hashtable param) {
- return (Int32) mapper.QueryForObject<int>("ImrCount", param);
- }
- public ImrData ImrData(ISqlMapper mapper, Hashtable param) {
- return mapper.QueryForObject<ImrData>("ImrData", param);
- }
- public int ImrScanFileUpdate(ISqlMapper mapper, Hashtable param) {
- return mapper.Update("ImrUpdate", param);
- }
- public int ImrScanFileDelete(ISqlMapper mapper, Hashtable param) {
- return mapper.Delete("ImrDelete", param);
- }
- }
- }
|