private void btnSaveProductFile_Click(object sender, EventArgs e)
{
try
{
int i = 0;
ProductFileManager man = new ProductFileManager();
foreach (DataRow row in dtProductFile.Rows)
{
switch (row.RowState)
{
case DataRowState.Added:
i += man.AddProductFile(row);
break;
case DataRowState.Modified:
i += man.UpdateProductFile(row);
break;
case DataRowState.Deleted:
i += man.DeleteProductFile(row);
break;
}
}
dtProductFile.AcceptChanges();
MessageBox.Show(string.Format("保存成功，更新【{0}】条数据！", i), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("保存失败！" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void LoadSourcePorductFile()
{
try
{
string product_code = string.Empty;
if (this.dgvProduct.CurrentRow != null)
{
product_code = this.dgvProduct.CurrentRow.Cells["PRODUCT_CODE"].Value.ToString();
}
ProductFileManager man = new ProductFileManager();
dtProductFile = man.GetProductFileList(product_code);
this.dgvProductFile.DataSource = dtProductFile;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// 加载升级文件清单
/// </summary>
private void LoadProductFile()
{
if (dtVersionFile != null)
{
dtVersionFile.Clear();
}
else
{
VersionFileManager versionMan = new VersionFileManager();
dtVersionFile = versionMan.GetList("1=2");
DataColumn col = new DataColumn("bCheck", typeof(bool));
dtVersionFile.Columns.Add(col);
this.dgvVERSIONFILE.DataSource = dtVersionFile;
}
string folder = txt_ProductFolder.Text.Trim();
if (folder.Trim().Length == 0)
{
return;
}
ProductFileManager pfMan = new ProductFileManager();
DataTable dtPF = pfMan.GetProductFileList(this.cmdProduct.SelectedValue.ToString());
foreach (DataRow row in dtPF.Rows)
{
//[OBJ_NO],[PRODUCT_CODE],[FILE_VERSION],[FILE_VERSION2],[FILE_NAME],[FILE_PATH],[FILE_DATA],[OBJ_DATE],[REMARK]
string fileName = folder + @"\" + row["PRODUCT_FILENAME"].ToString();
if (File.Exists(fileName))
{
DataRow newRow = dtVersionFile.NewRow();
newRow["bCheck"] = 1;
newRow["OBJ_NO"] = Guid.NewGuid().ToString();
newRow["PRODUCT_CODE"] = this.cmdProduct.SelectedValue.ToString();
string product_Filename = row["PRODUCT_FILENAME"].ToString();
string[] names = product_Filename.Split('\\');
newRow["FILE_NAME"] = names[names.Length - 1];
newRow["FILE_PATH"] = @"\" + product_Filename;
newRow["FILE_DATA"] = getFileByte(fileName);
dtVersionFile.Rows.Add(newRow);
}
}
}