private void del_bt_Click(object sender, EventArgs e)
{
DataRow DR = gridView1.GetDataRow(gridView1.FocusedRowHandle);
Maticsoft.BLL.parts use = new Maticsoft.BLL.parts();
use.Delete(Convert.ToInt32(DR["id"]));
//MessageBox.Show(a["id"].ToString());
MessageBox.Show("删除成功");
Maticsoft.BLL.parts usec = new Maticsoft.BLL.parts();
DataSet ds = usec.GetAllList();
main_gc.DataSource = ds.Tables[0];
}
private void import_bt_Click(object sender, EventArgs e)
{
//string filepath = "";
//OpenFileDialog opf = new OpenFileDialog();
//if (opf.ShowDialog() == DialogResult.OK)
//{
// filepath = opf.FileName;
//}
DataSet ds = new DataSet();
System.Data.DataTable dt = null;
OpenFileDialog sflg = new OpenFileDialog();
sflg.Filter = "Excel(*.xls)|*.xls|Excel(*.xlsx)|*.xlsx";
if (sflg.ShowDialog() == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
FileStream fs = new FileStream(sflg.FileName, FileMode.Open, FileAccess.Read);
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(fs);
int sheetCount = book.NumberOfSheets;
for (int sheetIndex = 0; sheetIndex < sheetCount; sheetIndex++)
{
string st_name = book.GetSheetName(sheetIndex);
NPOI.SS.UserModel.ISheet sheet = book.GetSheetAt(sheetIndex);
if (sheet == null)
{
continue;
}
NPOI.SS.UserModel.IRow row = sheet.GetRow(0);
if (row == null)
{
continue;
}
int firstCellNum = row.FirstCellNum;
int lastCellNum = row.LastCellNum;
if (firstCellNum == lastCellNum)
{
continue;
}
dt = new System.Data.DataTable(sheet.SheetName);
dt.Columns.Add("PN", typeof(string));
//MessageBox.Show(dt.Columns["bushe_xianshu"].DataType.ToString());
//dt.Columns.Add("", typeof(int));
dt.Columns.Add("name", typeof(string));
dt.Columns.Add("jobnum", typeof(string));
dt.Columns.Add("ARef", typeof(string));
dt.Columns.Add("size", typeof(string));
dt.Columns.Add("sm", typeof(string));
dt.Columns.Add("Barcode", typeof(string));
lastCellNum = 7;
for (int i = firstCellNum; i < lastCellNum; i++)
{
dt.Columns.Add(row.GetCell(i).StringCellValue, typeof(string));
}
for (int i = 1; i <= sheet.LastRowNum; i++)
{
DataRow newRow = dt.Rows.Add();
for (int j = firstCellNum; j < lastCellNum; j++)
{
newRow[j] = sheet.GetRow(i).GetCell(j).StringCellValue;
}
}
NPOI.SS.UserModel.IRow row0 = sheet.GetRow(0);
ds.Tables.Add(dt);
main_gc.DataSource = ds.Tables[0];
}
for (int i = 0; i < gridView1.RowCount; i++)
{
string LJH = gridView1.GetRowCellValue(i, "PN").ToString();
string mc = gridView1.GetRowCellValue(i, "name").ToString();
string gdh = gridView1.GetRowCellValue(i, "jobnum").ToString();
string BH = gridView1.GetRowCellValue(i, "ARef").ToString();
string cc = gridView1.GetRowCellValue(i, "size").ToString();
string dsm = gridView1.GetRowCellValue(i, "sm").ToString();
string tm = gridView1.GetRowCellValue(i, "Barcode").ToString();
Maticsoft.BLL.parts use = new Maticsoft.BLL.parts();
Maticsoft.Model.parts us = new parts()
{
PN = LJH,
//name = mc,
//jobnum = gdh,
//ARef = BH,
//size = cc,
//sm = dsm,
Barcode = tm,
};
use.Add(us);
}
DevExpress.XtraEditors.XtraMessageBox.Show("导入成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//MessageBox.Show("已成功导入");
Maticsoft.BLL.parts pr = new Maticsoft.BLL.parts();
DataSet ds2 = pr.GetAllList();
main_gc.DataSource = ds2.Tables[0];
}