private void btnUpdateRequiedVersion_Click(object sender, EventArgs e)
{
try
{
if (m_VEHeader.Count <= 0)
{
return;
}
var header = m_VEHeader[0];
if (!header.IsVersionNull() && header.Version.Trim() == Application.ProductVersion.Trim())
{
MessageBox.Show("版本号相同不需更換!");
return;
}
string ver = Application.ProductVersion.Trim();
#if UseSQLServer
string fullDest = Path.GetFullPath(Application.ExecutablePath).ToLower();
byte[] zipped = null;
byte[] md5 = null;
if (MyFunction.CompressFileToBuf(fullDest, out zipped, out md5))
{
var programAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ProgramTableAdapter();
var cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM [dbo].[Program] WHERE 1=1");
cmd.Connection = programAdapter.Connection;
programAdapter.Connection.Open();
cmd.ExecuteNonQuery();
var table = new VoucherExpense.DamaiDataSet.ProgramDataTable();
var programRow = table.NewProgramRow();
programRow.ID = Guid.NewGuid();
programRow.ProgramVersion = ver;
programRow.UpdatedTime = DateTime.Now;
programRow.ZippedImage = zipped;
programRow.MD5 = md5;
table.AddProgramRow(programRow);
labelRequiredVersion.Text = ver + " 正在上傳";
Application.DoEvents();
programAdapter.Update(table);
programAdapter.Connection.Dispose();
}
#endif
header.Version = ver;
VEHeaderAdapter.Update(m_VEHeader);
labelRequiredVersion.Text = "要求版本 " + header.Version;
}
catch (Exception ex)
{
MessageBox.Show("錯誤:" + ex.Message);
}
}