PDA端的数据库一般采用的是sqlce数据库,这样与PC端的sql2000中的数据同步就变成了一个问题,如在PDA端处理,PDA端的内存,CPU等都是一个制约因素,其次他们的一个连接稳定及其间的数据传输也是一个难点.本例中通过在PC端的转化后再复制到PDA上面,这样,上面所有的问题都得到了一个有效的控制.
一,创建项目,添加引用
![](https://p-blog.csdn.net/images/p_blog_csdn_net/zh2305/1.jpg)
二 设计界面,编写代码
![](https://p-blog.csdn.net/images/p_blog_csdn_net/zh2305/2.jpg)
程序代码
using
System;
using
System.Collections.Generic;
using
System.ComponentModel;
using
System.Data;
using
System.Drawing;
using
System.Text;
using
System.Windows.Forms;
using
System.Data.SqlServerCe;
using
OpenNETCF.Desktop.Communication;
using
System.IO;
using
System.Collections;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
namespace
FyfjmFileChange
![](https://i-blog.csdnimg.cn/blog_migrate/a41954a27d6ad96fa2c2cf816e677448.gif)
...
{
public partial class MainForm : Form
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
string _strCurrentDirectory = System.IO.Directory.GetCurrentDirectory();
RAPI m_rapi = new RAPI();
private ArrayList _arrData = new ArrayList();
private string[] Temp;
private int sign;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
public MainForm()
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
InitializeComponent();
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void btOpenFile_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
if (openFileDialog.ShowDialog() == DialogResult.OK)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
tbSourceLoadFile.Text = openFileDialog.FileName;
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void btSaveFile_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
if (saveFileDialog.ShowDialog() == DialogResult.OK)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
tbLoadPurposeFile.Text = saveFileDialog.FileName;
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void btUp1Load_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
sign = 1;
lbDownLoadState.Text = "Status:Ready Up……";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
Cursor.Current = Cursors.WaitCursor;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DataAcess.DisConnection();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
if (tbLoadPurposeFile.Text.Trim().Length > 0 && tbPdaSourceFile.Text.Trim().Length > 0)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
lbDownLoadState.Text = "Status:Copying the File……";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
m_rapi.Connect(false, -1);
m_rapi.CopyFileFromDevice(_strCurrentDirectory + @"DataBaseFyfjm.sdf", tbPdaSourceFile.Text.Trim() + @"DataBaseFyfjm.sdf", true);
m_rapi.Disconnect();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Changing the File……";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
if (FileFormCeDataBase(tbLoadPurposeFile.Text.Trim()))
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("File Update successful", "System Message");
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Successful……";
}
else
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("DataFile Change Failed", "System Message");
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Failed……";
}
}
catch (RAPIException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
System.Windows.Forms.MessageBox.Show(ex.Message, "System Message");
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Failed……";
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
Cursor.Current = Cursors.Default;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void btDownLoadStop_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
Close();
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void btDownLoad_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
Cursor.Current = Cursors.WaitCursor;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
if (tbSourceLoadFile.Text.Trim().Length > 0 && tbPdaPurposeFile.Text.Trim().Length > 0)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
if (MessageBox.Show("Are you Sure to clear the SKU data", "System Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
SqlCeConnection _objConn = DataAcess.CreateConnection(_strCurrentDirectory + @"DataBaseFyfjm.sdf");
string _strSQL = "delete from Enquiry";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
SqlCeCommand _objComm = _objConn.CreateCommand();
_objComm.CommandText = _strSQL;
_objComm.CommandType = CommandType.Text;
_objComm.ExecuteNonQuery();
}
catch (SqlCeException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("Delete data Failed" + ex.Message, "System Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
return;
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
if (File.Exists(tbSourceLoadFile.Text.Trim()) && FileToCeDataBase(tbSourceLoadFile.Text.Trim()))
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
DataAcess.Dispose(); //在复制之前要关闭数据库
// while (DataAcess._objConn.State == ConnectionState.Closed)
// {
m_rapi.Connect(false, -1);
m_rapi.CopyFileToDevice(_strCurrentDirectory + @"DataBaseFyfjm.sdf", tbPdaPurposeFile.Text.Trim() + @"DataBaseFyfjm.sdf", true);
m_rapi.Disconnect();
MessageBox.Show("Down File to device successful", "System Message");
// }
}
catch (RAPIException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
System.Windows.Forms.MessageBox.Show(ex.Message, "System Message");
}
//}
}
else
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("The SourceFile not exist", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
Cursor.Current = Cursors.Default;
DownLoadProgressBar.Value = 0;
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void UpStop_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
Close();
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private bool SaveTxt(string strFilePath)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
bool _bResult = false;
DataSet _objDs = new DataSet();
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
SqlCeConnection _objConn = DataAcess.CreateConnection(_strCurrentDirectory + @"DataBaseFyfjm.sdf");
SqlCeCommand _objComm = _objConn.CreateCommand();
_objComm.CommandText = "SELECT SKU FROM Take where Take_sign = '0'";
_objComm.CommandType = CommandType.Text;
SqlCeDataAdapter _objDa = new SqlCeDataAdapter(_objComm);
SqlCeCommandBuilder _objCb = new SqlCeCommandBuilder(_objDa);
_objDa.Fill(_objDs);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
UpLoadProgressBar.Maximum = _objDs.Tables[0].Rows.Count;
UpLoadProgressBar.Step = 0;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
System.IO.StreamWriter _objWriter = new StreamWriter(strFilePath, false, System.Text.Encoding.UTF8);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
int i = 0;
foreach (DataRow _objDr in _objDs.Tables[0].Rows)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
string _sLine = _objDr[0] + "," + "1";
_objWriter.WriteLine(_sLine);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
i++;
UpLoadProgressBar.Value = i;
}
_objWriter.Close();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DataAcess.Close();
_objConn.Close();
_objConn.Dispose();
_objConn = null;
_objComm.Dispose();
_bResult = true;
}
catch (SqlCeException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show(ex.Message, "系统提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
}
catch (Exception ex1)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show(ex1.Message, "系统提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
return _bResult;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private bool FileFormCeDataBase(string strFilePath)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
bool _bResult = false;
string[] _strTemp = strFilePath.Split('.');
string _strFileStype = _strTemp[_strTemp.Length - 1];
switch (_strFileStype.ToUpper())
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
/**//*case "XLS":
_bResult = SaveXLS(strFilePath);
break;
case "CSV":
_bResult = SaveCSV(strFilePath);
break;*/
case "TXT":
switch (sign)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
case 1:
_bResult = SaveTxt(strFilePath);
break;
case 2:
_bResult = SumSaveTxt(strFilePath);
break;
case 3:
_bResult = AllSaveTxt(strFilePath);
break;
default:
break;
}
break;
default:
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("File Format Error", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
break;
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
UpLoadProgressBar.Value = 0;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
return _bResult;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private bool FileToCeDataBase(string strFilePath)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
bool _bResult = false;
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
_arrData = new ArrayList();
System.IO.StreamReader objectReader = new System.IO.StreamReader(strFilePath, System.Text.Encoding.UTF8);
string sLine = "";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
while (sLine != null)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
sLine = objectReader.ReadLine();
if (sLine != null)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
_arrData.Add(sLine);
}
}
objectReader.Close();
}
catch (Exception ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show(ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
SqlCeConnection _objConn = DataAcess.CreateConnection(_strCurrentDirectory + @"DataBaseFyfjm.sdf");
SqlCeCommand _objComm = _objConn.CreateCommand();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DownLoadProgressBar.Maximum = _arrData.Count;
DownLoadProgressBar.Step = 1;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
for (int j = 0; j < _arrData.Count; j++)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
Temp = _arrData[j].ToString().Trim().Split(',');
_objComm.CommandText = string.Format("insert into Enquiry(Code,Color,Size,Price,SKU) values('{0}','{1}','{2}','{3}','{4}')", Temp[0].Trim(), Temp[1].Trim(), Temp[2].Trim(), Temp[3].Trim(), Temp[4].Trim());
_objComm.ExecuteNonQuery();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DownLoadProgressBar.Value++;
}
_arrData.Clear();
_bResult = true;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
_objConn.Close();
_objConn.Dispose();
_objConn = null;
_objComm.Dispose();
return _bResult;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void btUp2Load_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
sign = 2;
lbDownLoadState.Text = "Status:Ready Up……";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
Cursor.Current = Cursors.WaitCursor;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DataAcess.DisConnection();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
if (tbLoadPurposeFile.Text.Trim().Length > 0 && tbPdaSourceFile.Text.Trim().Length > 0)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
lbDownLoadState.Text = "Status:Copying the File……";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
m_rapi.Connect(false, -1);
m_rapi.CopyFileFromDevice(_strCurrentDirectory + @"DataBaseFyfjm.sdf", tbPdaSourceFile.Text.Trim() + @"DataBaseFyfjm.sdf", true);
m_rapi.Disconnect();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Changing the File……";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
if (FileFormCeDataBase(tbLoadPurposeFile.Text.Trim()))
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("File Update successful", "System Message");
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Successful……";
}
else
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("DataFile Change Failed", "System Message");
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Failed……";
}
}
catch (RAPIException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
System.Windows.Forms.MessageBox.Show(ex.Message, "System Message");
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Failed……";
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
Cursor.Current = Cursors.Default;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private bool SumSaveTxt(string strFilePath)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
bool _bResult = false;
DataSet _objDs = new DataSet();
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
SqlCeConnection _objConn = DataAcess.CreateConnection(_strCurrentDirectory + @"DataBaseFyfjm.sdf");
SqlCeCommand _objComm = _objConn.CreateCommand();
_objComm.CommandText = "select SKU,Count(*)as Qty from Take where Take_sign = '0' Group By SKU";
_objComm.CommandType = CommandType.Text;
SqlCeDataAdapter _objDa = new SqlCeDataAdapter(_objComm);
SqlCeCommandBuilder _objCb = new SqlCeCommandBuilder(_objDa);
_objDa.Fill(_objDs);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
UpLoadProgressBar.Maximum = _objDs.Tables[0].Rows.Count;
UpLoadProgressBar.Step = 0;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
System.IO.StreamWriter _objWriter = new StreamWriter(strFilePath, false, System.Text.Encoding.UTF8);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
int i = 0;
foreach (DataRow _objDr in _objDs.Tables[0].Rows)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
string _sLine = _objDr[0] + "," + _objDr[1];
_objWriter.WriteLine(_sLine);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
i++;
UpLoadProgressBar.Value = i;
}
_objWriter.Close();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DataAcess.Close();
_objConn.Close();
_objConn.Dispose();
_objConn = null;
_objComm.Dispose();
_bResult = true;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
}
catch (SqlCeException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show(ex.Message, "系统提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
}
catch (Exception ex1)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show(ex1.Message, "系统提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
return _bResult;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void btTake_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
Cursor.Current = Cursors.WaitCursor;
if (MessageBox.Show("Are you Sure to clear the Stock Take data", "System Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
SqlCeConnection _objConn = DataAcess.CreateConnection(_strCurrentDirectory + @"DataBaseFyfjm.sdf");
string _strSQL1 = "delete from Take";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
SqlCeCommand _objComm = _objConn.CreateCommand();
_objComm.CommandText = _strSQL1;
_objComm.CommandType = CommandType.Text;
_objComm.ExecuteNonQuery();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DataAcess.Dispose(); //在复制之前要关闭数据库
m_rapi.Connect(false, -1);
m_rapi.CopyFileToDevice(_strCurrentDirectory + @"DataBaseFyfjm.sdf", tbPdaPurposeFile.Text.Trim() + @"DataBaseFyfjm.sdf", true);
m_rapi.Disconnect();
MessageBox.Show("Delete Successful!", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
catch (SqlCeException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("Delete data Failed" + ex.Message, "System Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
return;
}
}
Cursor.Current = Cursors.Default;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void btAllclear_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
if (MessageBox.Show("Are you Sure to clear all the data", "System Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
SqlCeConnection _objConn = DataAcess.CreateConnection(_strCurrentDirectory + @"DataBaseFyfjm.sdf");
string _strSQL = "delete from Take";
string _strSQL1 = "delete from Enquiry";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
SqlCeCommand _objComm = _objConn.CreateCommand();
_objComm.CommandText = _strSQL;
_objComm.CommandType = CommandType.Text;
_objComm.ExecuteNonQuery();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
_objComm.CommandText = _strSQL1;
_objComm.CommandType = CommandType.Text;
_objComm.ExecuteNonQuery();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DataAcess.Dispose(); //在复制之前要关闭数据库
m_rapi.Connect(false, -1);
m_rapi.CopyFileToDevice(_strCurrentDirectory + @"DataBaseFyfjm.sdf", tbPdaPurposeFile.Text.Trim() + @"DataBaseFyfjm.sdf", true);
m_rapi.Disconnect();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
MessageBox.Show("Delete Successful!", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
catch (SqlCeException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("Delete data Failed" + ex.Message, "System Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
return;
}
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private void btUp3Load_Click(object sender, EventArgs e)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
sign = 3;
lbDownLoadState.Text = "Status:Ready Up……";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
Cursor.Current = Cursors.WaitCursor;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DataAcess.DisConnection();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
if (tbLoadPurposeFile.Text.Trim().Length > 0 && tbPdaSourceFile.Text.Trim().Length > 0)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
lbDownLoadState.Text = "Status:Copying the File……";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
m_rapi.Connect(false, -1);
m_rapi.CopyFileFromDevice(_strCurrentDirectory + @"DataBaseFyfjm.sdf", tbPdaSourceFile.Text.Trim() + @"DataBaseFyfjm.sdf", true);
m_rapi.Disconnect();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Changing the File……";
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
if (FileFormCeDataBase(tbLoadPurposeFile.Text.Trim()))
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("File Update successful", "System Message");
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Successful……";
}
else
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show("DataFile Change Failed", "System Message");
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Failed……";
}
}
catch (RAPIException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
System.Windows.Forms.MessageBox.Show(ex.Message, "System Message");
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
lbDownLoadState.Text = "Status:Failed……";
}
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
Cursor.Current = Cursors.Default;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
private bool AllSaveTxt(string strFilePath)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
bool _bResult = false;
DataSet _objDs = new DataSet();
try
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
SqlCeConnection _objConn = DataAcess.CreateConnection(_strCurrentDirectory + @"DataBaseFyfjm.sdf");
SqlCeCommand _objComm = _objConn.CreateCommand();
_objComm.CommandText = "select SKU,Zone,Take_sign from Take";
_objComm.CommandType = CommandType.Text;
SqlCeDataAdapter _objDa = new SqlCeDataAdapter(_objComm);
SqlCeCommandBuilder _objCb = new SqlCeCommandBuilder(_objDa);
_objDa.Fill(_objDs);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
UpLoadProgressBar.Maximum = _objDs.Tables[0].Rows.Count;
UpLoadProgressBar.Step = 0;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
System.IO.StreamWriter _objWriter = new StreamWriter(strFilePath, false, System.Text.Encoding.UTF8);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
int i = 0;
foreach (DataRow _objDr in _objDs.Tables[0].Rows)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
string _sLine = _objDr[1] + "," + _objDr[0] + "," + "1" + "," + _objDr[2];
_objWriter.WriteLine(_sLine);
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
i++;
UpLoadProgressBar.Value = i;
}
_objWriter.Close();
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
DataAcess.Close();
_objConn.Close();
_objConn.Dispose();
_objConn = null;
_objComm.Dispose();
_bResult = true;
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
}
catch (SqlCeException ex)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show(ex.Message, "系统提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
}
catch (Exception ex1)
![](https://i-blog.csdnimg.cn/blog_migrate/37c8bf68cdc3cc81759c34160776bc53.gif)
...{
MessageBox.Show(ex1.Message, "系统提示:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
return _bResult;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6a9c071a08f1dae2d3e1c512000eef41.gif)
}
}
该程序是从文本取数据导入,如果是sql数据库,则采用数据库操作方法将数据取出,后面操作方法大体类似
James
http://www.cardprinterworld.com