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);
}
