public bool Insert(SndNohinMail sndNohinMail) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, dbFileName))) { connection.Insert(sndNohinMail); return(true); } } catch (SQLiteException ex) { Log.Info("SQLiteEx", ex.Message); return(false); } }
private void InsertSndMailInfo(string mailback) { // レコード作成用 値取得 SndNohinMail sndNohinMail = new SndNohinMail { wPackage = "01", wTerminalID = "11101", //Handy: serialId wProgramID = prefs.GetString("program_id", "NOH"), //JOB: program_id wSagyosyaCD = prefs.GetString("sagyousya_cd", "99999"), wSoukoCD = prefs.GetString("souko_cd", ""), //JOB: noh_soukoCd wHaisoDate = prefs.GetString("haiso_date", ""), // noh_syukaDate wBinNo = prefs.GetString("bin_no", ""), //JOB: noh_binNo wCourse = prefs.GetString("course", ""), wDriverCD = prefs.GetString("driver_cd", ""), wTokuisakiCD = prefs.GetString("tokuisaki_cd", ""), wTodokesakiCD = prefs.GetString("todokesaki_cd", ""), wKanriNo = mailback, wVendorCd = prefs.GetString("vendor_cd", ""), wMateVendorCd = "", wSyukaDate = "0", wButsuryuNo = "", wKamotuNo = "", wMatehan = "", wMatehanSu = "", wHHT_no = "", wNohinKbn = "", wKaisyuKbn = "", wTenkanState = "00", wSakiTokuisakiCD = "", wSakiTodokesakiCD = "", wNohinDate = prefs.GetString("nohin_date", ""), wNohinTime = prefs.GetString("nohin_time", "") }; sndNohinMailHelper.Insert(sndNohinMail); }
private Dictionary <string, string> SetSendParam(object param) { Dictionary <string, string> result = new Dictionary <string, string>(); if (param.GetType() == typeof(SndNohinMail)) { SndNohinMail temp = ((SndNohinMail)param); result = new Dictionary <string, string> { { "pPackage", temp.wPackage }, { "pTerminalID", temp.wTerminalID }, { "pProgramID", temp.wProgramID }, { "pSagyosyaCD", temp.wSagyosyaCD }, { "pSoukoCD", temp.wSoukoCD }, { "pHaisoDate", temp.wHaisoDate }, { "pBinNo", temp.wBinNo }, { "pCourse", temp.wCourse }, { "pDriverCD", temp.wDriverCD }, { "pTokuisakiCD", temp.wTokuisakiCD }, { "pTodokesakiCD", temp.wTodokesakiCD }, { "pKanriNo", temp.wKanriNo }, { "pVendorCD", temp.wVendorCd }, { "pMatehanVendor", temp.wMateVendorCd }, { "pSyukaDate", temp.wSyukaDate }, { "pButsuryuNo", temp.wButsuryuNo }, { "pKamotsuNo", temp.wKamotuNo }, { "pMatehan", temp.wMatehan }, { "pMatehan_Su", temp.wMatehanSu }, { "pHHT_No", temp.wHHT_no } }; } else if (param.GetType() == typeof(SndNohinMailKaisyu)) { SndNohinMailKaisyu temp = ((SndNohinMailKaisyu)param); result = new Dictionary <string, string> { { "pPackage", temp.wPackage }, { "pTerminalID", temp.wTerminalID }, { "pProgramID", temp.wProgramID }, { "pSagyosyaCD", temp.wSagyosyaCD }, { "pSoukoCD", temp.wSoukoCD }, { "pHaisoDate", temp.wHaisoDate }, { "pBinNo", temp.wBinNo }, { "pCourse", temp.wCourse }, { "pDriverCD", temp.wDriverCD }, { "pTokuisakiCD", temp.wTokuisakiCD }, { "pTodokesakiCD", temp.wTodokesakiCD }, { "pKanriNo", temp.wKanriNo }, { "pVendorCD", temp.wVendorCd }, { "pMatehanVendor", temp.wMateVendorCd }, { "pSyukaDate", temp.wSyukaDate }, { "pButsuryuNo", temp.wButsuryuNo }, { "pKamotsuNo", temp.wKamotuNo }, { "pMatehan", temp.wMatehan }, { "pMatehan_Su", temp.wMatehanSu }, { "pHHT_No", temp.wHHT_no }, }; } else if (param.GetType() == typeof(SndNohinMate)) { SndNohinMate temp = ((SndNohinMate)param); result = new Dictionary <string, string> { { "pPackage", temp.wPackage }, { "pTerminalID", temp.wTerminalID }, { "pProgramID", temp.wProgramID }, { "pSagyosyaCD", temp.wSagyosyaCD }, { "pSoukoCD", temp.wSoukoCD }, { "pHaisoDate", temp.wHaisoDate }, { "pBinNo", temp.wBinNo }, { "pCourse", temp.wCourse }, { "pDriverCD", temp.wDriverCD }, { "pTokuisakiCD", temp.wTokuisakiCD }, { "pTodokesakiCD", temp.wTodokesakiCD }, { "pKanriNo", temp.wKanriNo }, { "pVendorCD", temp.wVendorCd }, { "pMatehanVendor", temp.wMateVendorCd }, { "pSyukaDate", temp.wSyukaDate }, { "pButsuryuNo", temp.wButsuryuNo }, { "pKamotsuNo", temp.wKamotuNo }, { "pMatehan", temp.wMatehan }, { "pMatehan_Su", temp.wMatehanSu }, { "pHHT_No", temp.wHHT_no }, }; } else if (param.GetType() == typeof(SndNohinWork)) { SndNohinWork temp = ((SndNohinWork)param); result = new Dictionary <string, string> { { "pPackage", temp.wPackage }, { "pTerminalID", temp.wTerminalID }, { "pProgramID", temp.wProgramID }, { "pSagyosyaCD", temp.wSagyosyaCD }, { "pSoukoCD", temp.wSoukoCD }, { "pHaisoDate", temp.wHaisoDate }, { "pBinNo", temp.wBinNo }, { "pCourse", temp.wCourse }, { "pDriverCD", temp.wDriverCD }, { "pTokuisakiCD", temp.wTokuisakiCD }, { "pTodokesakiCD", temp.wTodokesakiCD }, { "pKanriNo", temp.wKanriNo }, { "pVendorCD", temp.wVendorCd }, { "pMatehanVendor", temp.wMateVendorCd }, { "pSyukaDate", temp.wSyukaDate }, { "pButsuryuNo", temp.wButsuryuNo }, { "pKamotsuNo", temp.wKamotuNo }, { "pMatehan", temp.wMatehan }, { "pMatehan_Su", temp.wMatehanSu }, { "pHHT_No", temp.wHHT_no }, { "pNohinKbn", temp.wNohinKbn }, { "pTenkanState", temp.wTenkanState }, { "pKaisyuKbn", temp.wKaisyuKbn }, { "pSakiTokuisakiCD", temp.wSakiTokuisakiCD }, { "pSakiTodokesakiCD", temp.wSakiTodokesakiCD }, { "pNohinDate", temp.wNohinDate }, { "pNohinTime", temp.wNohinTime } }; } else if (param.GetType() == typeof(SndNohinSyohinKaisyu)) { SndNohinSyohinKaisyu temp = ((SndNohinSyohinKaisyu)param); result = new Dictionary <string, string> { { "pPackage", temp.wPackage }, { "pTerminalID", temp.wTerminalID }, { "pProgramID", temp.wProgramID }, { "pSagyosyaCD", temp.wSagyosyaCD }, { "pSoukoCD", temp.wSoukoCD }, { "pHaisoDate", temp.wHaisoDate }, { "pBinNo", temp.wBinNo }, { "pCourse", temp.wCourse }, { "pDriverCD", temp.wDriverCD }, { "pTokuisakiCD", temp.wTokuisakiCD }, { "pTodokesakiCD", temp.wTodokesakiCD }, { "pKanriNo", temp.wKanriNo }, { "pVendorCD", temp.wVendorCd }, { "pMatehanVendor", temp.wMateVendorCd }, { "pSyukaDate", temp.wSyukaDate }, { "pButsuryuNo", temp.wButsuryuNo }, { "pKamotsuNo", temp.wKamotuNo }, { "pMatehan", temp.wMatehan }, { "pMatehan_Su", temp.wMatehanSu }, { "pHHT_No", temp.wHHT_no }, }; } return(result); }