// 積込完了時に生成されるファイル（納品で使います。）
private void CreateTsumiFiles()
{
// CRATE TUMIKOMI FILE
// MAIN FILE
List <MFile> mFiles = WebService.RequestTumikomi100(souko_cd, kitaku_cd, syuka_date, bin_no, course, tokuisaki_cd, todokesaki_cd);
MFileHelper mFileHelper = new MFileHelper();
mFileHelper.DeleteAll();
mFileHelper.InsertALL(mFiles);
//PsFile psFile = WebService.RequestTumikomi180(souko_cd, syuka_date);
/*
* PsFileHelper psFileHelper = new PsFileHelper();
* PsFile psFile = new PsFile();
* psFileHelper.DeleteAll();
* psFileHelper.Insert(psFile);
*/
// MAILBACK FILE
List <MbFile> mbFiles = WebService.RequestTumikomi140(souko_cd, kitaku_cd, syuka_date, bin_no, course);
MbFileHelper mbFileHelper = new MbFileHelper();
mbFileHelper.DeleteAll();
mbFileHelper.InsertAll(mbFiles);
// SOUKO FILE
SoFile soFile = WebService.RequestTumikomi160(souko_cd);
SoFileHelper soFileHelper = new SoFileHelper();
soFileHelper.DeleteAll();
soFileHelper.Insert(soFile);
// VENDOR FILE
string nohin_date = DateTime.Now.ToString("yyyyMMdd");
List <MateFile> mateFile = WebService.RequestTumikomi260();
MateFileHelper mateFileHelper = new MateFileHelper();
mateFileHelper.DeleteAll();
mateFileHelper.InsertAll(mateFile);
// TOKUISAKI FILE
List <TokuiFile> tokuiFile = WebService.RequestTumikomi270();
TokuiFileHelper tokuiFileHelper = new TokuiFileHelper();
tokuiFileHelper.DeleteAll();
tokuiFileHelper.InsertAll(tokuiFile);
Log.Debug(TAG, "CreateTsumiFiles end");
}
public bool Insert(SoFile soFile)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, dbFileName)))
{
connection.Insert(soFile);
return(true);
}
}
catch (SQLiteException ex)
{
Log.Info("SQLiteEx", ex.Message);
return(false);
}
}
// 積込完了時に生成されるファイル（納品で使います。）
private void CreateTsumiFiles()
{
string souko_cd = prefs.GetString("souko_cd", "");
string kitaku_cd = prefs.GetString("kitaku_cd", "");
string syuka_date = prefs.GetString("syuka_date", "");
string tokuisaki_cd = prefs.GetString("tokuisaki_cd", "");
string todokesaki_cd = prefs.GetString("todokesaki_cd", "");
string bin_no = prefs.GetString("bin_no", "");
string course = prefs.GetString("course", "");
// CRATE TUMIKOMI FILE
// MAIN FILE
List <MFile> mFiles = WebService.RequestTumikomi100(souko_cd, kitaku_cd, syuka_date, bin_no, course, tokuisaki_cd, todokesaki_cd);
new MFileHelper().InsertALL(mFiles);
// It would be useless..
//PsFile psFile = WebService.RequestTumikomi180();
PsFile psFile = new PsFile {
pass = ""
};
new PsFileHelper().Insert(psFile);
// MAILBACK FILE
List <MbFile> mbFiles = WebService.RequestTumikomi140(souko_cd, kitaku_cd, syuka_date, bin_no, course);
new MbFileHelper().InsertAll(mbFiles);
// SOUKO FILE
SoFile soFile = WebService.RequestTumikomi160(souko_cd);
new SoFileHelper().Insert(soFile);
// VENDOR FILE
List <MateFile> mateFile = WebService.RequestTumikomi260();
new MateFileHelper().InsertAll(mateFile);
// TOKUISAKI FILE
List <TokuiFile> tokuiFile = WebService.RequestTumikomi270();
new TokuiFileHelper().InsertAll(tokuiFile);
Log.Debug(TAG, "CreateTsumiFiles end");
Dictionary <string, string> param = new Dictionary <string, string>
{
{ "pTerminalID", prefs.GetString("terminal_id", "") },
{ "pProgramID", "TUM" },
{ "pSagyosyaCD", prefs.GetString("sagyousya_cd", "") },
{ "pSoukoCD", souko_cd },
{ "pSyukaDate", syuka_date },
{ "pBinNo", bin_no },
{ "pCourse", course },
{ "pTokuisakiCD", tokuisaki_cd },
{ "pTodokesakiCD", todokesaki_cd },
{ "pHHT_No", prefs.GetString("hht_no", "") }
};
//配車テーブルの該当コースの各数量を実績数で更新する
var updateResult = WebService.CallTumiKomiProc("210", param);
if (updateResult.poRet == "0" || updateResult.poRet == "99")
{
editor.PutBoolean("tenpo_zan_flg", updateResult.poRet == "99" ? true : false);
editor.Apply();
Activity.RunOnUiThread(() =>
{
// 正常登録
ShowDialog("報告", "積込検品が\n完了しました。", () => {
FragmentManager.PopBackStack(FragmentManager.GetBackStackEntryAt(0).Id, 0);
});
});
}
else
{
ShowDialog("エラー", "表示データがありません", () => {});
return;
}
}
