public bool Insert(SndNohinMailKaisyu nohinWork)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, dbFileName)))
{
connection.Insert(nohinWork);
return(true);
}
}
catch (SQLiteException ex)
{
Log.Info("SQLiteEx", ex.Message);
return(false);
}
}
private void appendFile(string mailbag)
{
// レコード作成用 値取得
SndNohinMailKaisyu sndNohinMailKaisyu = new SndNohinMailKaisyu
{
wPackage = "00",
wTerminalID = "11101",
wProgramID = prefs.GetString("program_id", "NOH"),
wSagyosyaCD = prefs.GetString("sagyousya_cd", "99999"),
wSoukoCD = prefs.GetString("souko_cd", "108"),
wHaisoDate = prefs.GetString("haiso_date", ""),
wBinNo = prefs.GetString("bin_no", ""),
wCourse = prefs.GetString("course", ""),
wDriverCD = prefs.GetString("driver_cd", ""),
wTokuisakiCD = prefs.GetString("tokuisaki_cd", ""),
wTodokesakiCD = prefs.GetString("todokesaki_cd", ""),
wKanriNo = mailbag,
wVendorCd = prefs.GetString("vendor_cd", ""),
wMateVendorCd = "",
wSyukaDate = "0",
wButsuryuNo = "",
wKamotuNo = "",
wMatehan = "",
wMatehanSu = "0",
wHHT_no = "11101",
wNohinKbn = "1", // 商品回収
wKaisyuKbn = "0",
wTenkanState = "00",
wSakiTokuisakiCD = "",
wSakiTodokesakiCD = "",
wNohinDate = prefs.GetString("nohin_date", ""),
wNohinTime = prefs.GetString("nohin_time", "")
};
//DEF_MAIL_KAI
sndNohinMailKaisyuHelper.Insert(sndNohinMailKaisyu);
}
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);
}
