public bool Insert(SndNohinWork 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); } }
public override void OnBarcodeDataReceived(BarcodeDataReceivedEvent_ dataReceivedEvent) { IList <BarcodeDataReceivedEvent_.BarcodeData_> listBarcodeData = dataReceivedEvent.BarcodeData; foreach (BarcodeDataReceivedEvent_.BarcodeData_ barcodeData in listBarcodeData) { string kamotu_no = barcodeData.Data; bool isExist = false; MFile tsumikomi = null; foreach (MFile temp in tsumikomiDataList) { if (temp.kamotsu_no == kamotu_no) { isExist = true; tsumikomi = temp; break; } } new Thread(new ThreadStart(delegate { Activity.RunOnUiThread(() => { if (!isExist) { ShowDialog("エラー", "該当データがありません。", () => { }); return; } SndNohinWorkHelper sndNohinWorkHelper = new SndNohinWorkHelper(); if (sndNohinWorkHelper.SelectNohinWorkWithKamotu(kamotu_no).Count > 0) { ShowDialog("エラー", "登録済みです。", () => { }); return; } string tokuisaki_cd = prefs.GetString("tokuisaki_cd", ""); string todokesaki_cd = prefs.GetString("todokesaki_cd", ""); string matehanCd = tsumikomi.matehan; List <MFile> mfileList = mFilehelper.SelectByMatehanCd(tokuisaki_cd, todokesaki_cd, matehanCd); if (mfileList.Count > 0) { foreach (SndNohinWork temp in sndNohinWorkHelper.SelectAll()) { if (mfileList[0].matehan == temp.wMatehan) { ShowDialog("エラー", "登録済みです。", () => { }); return; } } } else { // err? } tvmatehanNm.Text = mfileList[0].category_nm; int idx = tvTsumidai.Text.IndexOf('/'); int tsumidai = (int.Parse(tvTsumidai.Text.Substring(0, idx)) + 1); // 総個数 idx = tvAll.Text.IndexOf('/'); ko_su = int.Parse(tvAll.Text.Substring(0, idx)) + mfileList.Count; if (ko_su <= tsumikomiDataList.Count) { // 画面の数字をカウントアップする tvTsumidai.Text = tsumidai + "/" + matehanCnt; tvAll.Text = ko_su + "/" + tsumikomiDataList.Count; switch (tsumikomi.bunrui) { case "01": tvCase.Text = (int.Parse(tvCase.Text) + mfileList.Count).ToString(); break; case "02": tvOricon.Text = (int.Parse(tvOricon.Text) + mfileList.Count).ToString(); break; case "03": tvSonota.Text = (int.Parse(tvSonota.Text) + mfileList.Count).ToString(); break; case "04": tvIdo.Text = (int.Parse(tvIdo.Text) + mfileList.Count).ToString(); break; case "05": tvMail.Text = (int.Parse(tvMail.Text) + mfileList.Count).ToString(); break; case "06": tvSonota.Text = (int.Parse(tvSonota.Text) + mfileList.Count).ToString(); break; case "07": tvFuteikei.Text = (int.Parse(tvFuteikei.Text) + mfileList.Count).ToString(); break; case "08": tvSonota.Text = (int.Parse(tvSonota.Text) + mfileList.Count).ToString(); break; case "09": tvHansoku.Text = (int.Parse(tvHansoku.Text) + mfileList.Count).ToString(); break; case "T": tvTc.Text = (int.Parse(tvTc.Text) + mfileList.Count).ToString(); break; default: tvSonota.Text = (int.Parse(tvSonota.Text) + mfileList.Count).ToString(); break; } if (ko_su == tsumikomiDataList.Count) { // レコード作成用 値取得 SndNohinWork sndNohinWork = new SndNohinWork { wPackage = "02", wTerminalID = "432660068", //Handy: serialId wProgramID = prefs.GetString("program_id", "NOH"), //JOB: program_id wSagyosyaCD = prefs.GetString("sagyosya", ""), wSoukoCD = mfileList[0].kenpin_souko, wHaisoDate = mfileList[0].syuka_date, // noh_syukaDate wBinNo = mfileList[0].bin_no, //JOB: noh_binNo wCourse = mfileList[0].course, //noh_course wDriverCD = mfileList[0].driver_cd, // noh_driverCd wTokuisakiCD = mfileList[0].tokuisaki_cd, // JOB: noh_tokuisakiCd wTodokesakiCD = mfileList[0].todokesaki_cd, // JOB: noh_todokesakiCd wKanriNo = "", // "" wVendorCd = mfileList[0].vendor_cd, //JOB: vendor_cd wMateVendorCd = "", // "" wSyukaDate = mfileList[0].syuka_date, //JOB: haiso_date wButsuryuNo = "", // "" wKamotuNo = kamotu_no, //JOB: kamotu_no wMatehan = mfileList[0].matehan, // JOB: noh_matehan wMatehanSu = matehanCnt.ToString(), // JOB: tumiko_su wHHT_no = "11101", wNohinKbn = "0", wKaisyuKbn = "", wTenkanState = "00", wSakiTokuisakiCD = "", wSakiTodokesakiCD = "", wNohinDate = prefs.GetString("nohin_date", ""), //FIX:setFixLength(8, JOB: nohin_date) wNohinTime = prefs.GetString("nohin_time", "") //FIX:setFixLength(4, JOB: nohin_time) }; SndNohinWorkHelper nohinWorkHelper = new SndNohinWorkHelper(); nohinWorkHelper.Insert(sndNohinWork); editor.PutBoolean("nohinWorkEndFlag", true); editor.Apply(); kaizoButton.Visibility = ViewStates.Gone; nohinWorkButton.Visibility = ViewStates.Visible; return; } } } ); } )).Start(); } }
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); }