/// <summary>
/// 导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnImport_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tbFileSavePath.Text))
{
MessageBox.Show("请选择保存文件的路径");
return;
}
if (gvData.Rows.Count == 0)
{
MessageBox.Show("请先选择数据源文件");
}
else
{
toolStripProgressBar1.ProgressBar.Visible = true;
toolStripProgressBar1.ProgressBar.Minimum = 0;
toolStripProgressBar1.ProgressBar.Maximum = gvData.Rows.Count;
int i = 0;
int okCount = 0;
int errCount = 0;
foreach (DataGridViewRow dr in gvData.Rows)
{
ImportDataInfo dInfo = DataRowToDataInfo(dr);
if (dInfo != null)
{
try
{
ImportXlsData import = new ImportXlsData(dInfo);
import.dataRowImportOk += new DataRowImportComplete(import_dataRowImportOk);
import.CurrentRow = dr;
import.SavePath = tbFileSavePath.Text + "\\";
import.Import();
okCount++;
}
catch (Exception ex)
{
errCount++;
}
toolStripStatusLabel1.Text = string.Format("成功导入{0}个，失败{1}个", okCount, errCount);
}
i++;
toolStripProgressBar1.ProgressBar.Value = i;
}
toolStripProgressBar1.ProgressBar.Visible = false;
toolStripStatusLabel1.Text = toolStripStatusLabel1.Text.Insert(0, "完成导入，");
btnImport.Enabled = false;
}
}
private ImportDataInfo DataRowToDataInfo(DataGridViewRow dr)
{
ImportDataInfo info;
try
{
info = new ImportDataInfo();
if (dr.Cells[1] != null)
{
info.Title = dr.Cells[1].Value as string;
}
if (dr.Cells[2] != null)
{
info.FilePath = dr.Cells[2].Value as string;
}
if (dr.Cells[3] != null)
{
info.Description = dr.Cells[3].Value as string;
}
if (dr.Cells[4] != null)
{
info.Tags = dr.Cells[4].Value as string;
}
if (dr.Cells["Price"] != null)
{
decimal r = 0;
decimal.TryParse(dr.Cells["Price"].FormattedValue as string, out r);
info.Price = r;
}
if (dr.Cells["CateId"] != null)
{
int r = 0;
int.TryParse(dr.Cells["CateId"].FormattedValue as string, out r);
info.ClassId = r;
}
}
catch (Exception ex)
{
info = null;
dr.Cells["colStatus"].Value = "数据源转换错误";
}
return(info);
}
private ImportDataInfo DataRowToDataInfo(DataGridViewRow dr)
{
ImportDataInfo info;
try
{
info = new ImportDataInfo();
if (dr.Cells[1] != null)
{
info.Title = dr.Cells[1].Value as string;
}
if (dr.Cells[2] != null)
{
info.FilePath = dr.Cells[2].Value as string;
}
if (dr.Cells[3] != null)
{
info.Description = dr.Cells[3].Value as string;
}
if (dr.Cells[4] != null)
{
info.Tags = dr.Cells[4].Value as string;
}
if (dr.Cells["Price"] != null)
{
decimal r = 0;
decimal.TryParse(dr.Cells["Price"].FormattedValue as string, out r);
info.Price = r;
}
if (dr.Cells["CateId"] != null)
{
int r = 0;
int.TryParse(dr.Cells["CateId"].FormattedValue as string, out r);
info.ClassId = r;
}
}
catch(Exception ex)
{
info = null;
dr.Cells["colStatus"].Value = "数据源转换错误";
}
return info;
}
public ImportXlsData(ImportDataInfo doc)
{
this.docInfo = doc;
}
public ImportXlsData(ImportDataInfo doc)
{
this.docInfo = doc;
}