public bool Insert(TenpoArrive tenpoArrive)
{
try
{
using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, dbFileName)))
{
connection.Insert(tenpoArrive);
return(true);
}
}
catch (SQLiteException ex)
{
Log.Info("SQLiteEx", ex.Message);
return(false);
}
}
private void Confirm()
{
bool hasError = false;
((MainActivity)this.Activity).ShowProgress("納品情報を確認しています。");
new Thread(new ThreadStart(delegate {
Activity.RunOnUiThread(() =>
{
// Main file
MFileHelper mFlieHelper = new MFileHelper();
List <MFile> tsumikomiList = mFlieHelper.SelectTsumikomiList(etTokuisaki.Text, etTodokesaki.Text);
if (tsumikomiList.Count == 0)
{
hasError = true;
ShowDialog("エラー", "得意先コードが見つかりません。", () => { etTodokesaki.RequestFocus(); });
return;
}
// 店舗到着情報を登録する。
TenpoArrive tenpoArrive = new TenpoArrive
{
pBinNo = tsumikomiList[0].bin_no,
pCourse = tsumikomiList[0].course,
pSoukoCD = tsumikomiList[0].kenpin_souko,
pKitakuCD = tsumikomiList[0].kitaku_cd,
pNohinDate = DateTime.Now.ToString("yyyyMMdd"),
pNohinTime = DateTime.Now.ToString("HHmm"),
pProgramID = "NOH",
pSyukaDate = tsumikomiList[0].syuka_date,
pTerminalID = prefs.GetString("terminal_id", ""),
pTodokesakiCD = tsumikomiList[0].todokesaki_cd,
pTokuisakiCD = tsumikomiList[0].tokuisaki_cd
};
//var fileName = Android.OS.Environment.ExternalStorageDirectory + Java.IO.File.Separator + "TenpoNohinInfo.csv";
var fileName = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal) + Java.IO.File.Separator + "TenpoNohinInfo.csv";
using (var fs = new StreamWriter(fileName, true))
{
fs.WriteLine(
DateTime.Now.ToString("HHmm")
+ ',' + tsumikomiList[0].kenpin_souko
+ ',' + tsumikomiList[0].kitaku_cd
+ ',' + tsumikomiList[0].syuka_date
+ ',' + tsumikomiList[0].syuka_date
+ ',' + tsumikomiList[0].bin_no
+ ',' + tsumikomiList[0].course
+ ',' + tsumikomiList[0].tokuisaki_cd
+ ',' + tsumikomiList[0].todokesaki_cd
+ ',' + prefs.GetString("terminal_id", "")
+ ',' + "htt");
fs.Close();
string PureFileName = new FileInfo(fileName).Name;
Uri serverUri = new Uri(String.Format("ftp://192.168.0.19/" + PureFileName));
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(serverUri);
request.Method = WebRequestMethods.Ftp.UploadFile;
request.UseBinary = true;
request.UsePassive = false;//true;
request.KeepAlive = false;
request.Timeout = System.Threading.Timeout.Infinite;
request.AuthenticationLevel = System.Net.Security.AuthenticationLevel.None;
//request.Credentials = new NetworkCredential("test", "test");
byte[] data = File.ReadAllBytes(fileName);
Stream stream = request.GetRequestStream();
stream.Write(data, 0, data.Length);
stream.Close();
/*
* FileStream stream = new FileStream(fileName, FileMode.Open, FileAccess.Read);
*
* StreamReader sourceStream = new StreamReader(stream);
* byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
* sourceStream.Close();
* request.ContentLength = data.Length;
*/
//
FtpWebResponse response = (FtpWebResponse)request.GetResponse();
//
response.Close();
response.Dispose();
}
TenpoArriveHelper tenpoArriveHelper = new TenpoArriveHelper();
tenpoArriveHelper.Insert(tenpoArrive);
editor.PutString("souko_cd", tsumikomiList[0].kenpin_souko);
editor.PutString("kitaku_cd", tsumikomiList[0].kitaku_cd);
editor.PutString("haiso_date", tsumikomiList[0].syuka_date);
editor.PutString("bin_no", tsumikomiList[0].bin_no);
editor.PutString("course", tsumikomiList[0].course);
editor.PutString("driver_cd", tsumikomiList[0].driver_cd);
editor.PutString("tokuisaki_cd", tsumikomiList[0].tokuisaki_cd);
editor.PutString("tokuisaki_nm", tsumikomiList[0].tokuisaki_rk);
editor.PutString("todokesaki_cd", tsumikomiList[0].todokesaki_cd);
editor.PutString("vendor_cd", tsumikomiList[0].vendor_cd);
editor.PutString("vendor_nm", tsumikomiList[0].vendor_nm);
editor.PutString("mate_vendor_cd", tsumikomiList[0].default_vendor);
editor.PutString("mate_vendor_nm", tsumikomiList[0].default_vendor_nm);
editor.PutString("mailbag_flg", "1");
editor.PutString("nohin_date", DateTime.Now.ToString("yyyyMMdd"));
editor.PutString("nohin_time", DateTime.Now.ToString("HHmm"));
editor.PutString("bunrui", tsumikomiList[0].bunrui);
editor.PutString("matehan_cd", tsumikomiList[0].matehan);
editor.PutString("jyuryo", etReceipt.Text);
editor.PutBoolean("mailBagFlag", false);
editor.Apply();
}
);
Activity.RunOnUiThread(() => {
((MainActivity)this.Activity).DismissDialog();
if (!hasError)
{
StartFragment(FragmentManager, typeof(NohinMenuFragment));
}
});
}
)).Start();
}
