首页 > 代码库 > PDA开发数据由DB下载至PDA本地
PDA开发数据由DB下载至PDA本地
public string DownFile = "\\下载.txt";//下载路径 public string LoadFile = "\\上传.txt";//上传路径 public List<string> _readtxt = new List<string>(); public MainForm() { InitializeComponent(); tbDelivery.Focus(); } private void btnDownLoad_Click(object sender, EventArgs e) { try { if (tbDelivery.Text.Trim().Length == 0) { MES.PDA.Core.Service.MessageServices.ShowWarm("请先扫描供货号!"); tbDelivery.Focus(); return; } else { if (!CheckDelivery()) { return; } if (System.IO.File.Exists(DownFile)) { StreamReader objReader = new StreamReader(DownFile); string sLine = ""; sLine = objReader.ReadLine(); if (sLine != string.Empty) { string[] ss = sLine.Split(‘,‘); if (ss.Length > 0) { if (ss[0] != tbDelivery.Text.Trim()) { MES.PDA.Core.Service.MessageServices.ShowWarm("本机已下载供货号:" + ss[0] + ",请扫描该供货号并上传后。再下载其它供货号!"); objReader.Close(); return; } else { MES.PDA.Core.Service.MessageServices.ShowWarm("该供货号已下载,请进行扫描并上传!
"); objReader.Close(); return; } } } objReader.Close(); } else { FileStream fs = System.IO.File.Create(DownFile); StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("UTF-8")); string sql = Sql.getDelivery(tbDelivery.Text.Trim()); Daisy.Common.McsClient.McsDataReader reader = (Daisy.Common.McsClient.McsDataReader)MES.PDA.Core.Service.DatabaseAccessService.execute(sql, MES.PDA.Core.Service.ReturnType.RESULTSET); if (reader.rowNumber == 0) { MES.PDA.Core.Service.MessageServices.ShowWarm("获取供货号信息失败!"); sw.Close(); return; } else { string sLine = string.Empty; while (reader.Read()) { //MES.PDA.Core.Service.MessageServices.ShowWarm(reader.getString(2)); sLine = reader.getString(0) + "," + reader.getString(1) + "," + reader.getString(2) + "," + reader.getString(3) + "," + reader.getString(4) + "," + reader.getString(5); //sw.WriteLine(sLine); sw.WriteLine(sLine); } sw.Flush(); sw.Close(); } var sqlload = "{?=call apps.cux_pda_load_scan_utl.init_data_download(‘" + tbDelivery.Text.Trim() + "‘)}"; //MES.PDA.Core.Service.MessageServices.ShowWarm(sql); //return; string ret = (string)MES.PDA.Core.Service.DatabaseAccessService.execute(sqlload, ReturnType.STRING); if (!ret.StartsWith("0@")) { MES.PDA.Core.Service.MessageServices.ShowWarm(ret); return; } else { MES.PDA.Core.Service.MessageServices.ShowWarm("下载成功!
"); btnScan.Focus(); } } } } catch (Exception ex) { MES.PDA.Core.Service.MessageServices.ShowWarm(ex.ToString()); } }
PDA开发数据由DB下载至PDA本地