示例#1
0
 private void inputOSToolStripMenuItem_Click(object sender, EventArgs e)
 {
     if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
     {
         DataTable excelTable = new DataTable();
         openFileDialog1.Multiselect = false;
         string filePath   = openFileDialog1.FileName;
         string fileType   = System.IO.Path.GetExtension(filePath);
         string SheetName1 = "手术医生编号";
         if (string.IsNullOrEmpty(fileType))
         {
             return;
         }
         excelTable = UserFunction.GetDataFromExcel(fileType, filePath, SheetName1);
         excelTable = UserFunction.removeEmptyRow(excelTable);
         string OsNo = ""; string OsName = ""; string NameSuoxie = "";
         foreach (DataRow drE in excelTable.Rows)
         {
             string   OS     = drE[0].ToString();
             string[] OSlist = OS.Split('_');
             OsNo       = OSlist[0];
             OsName     = OSlist[1];
             NameSuoxie = OSlist[2];
             dal.InsertShoushuYisheng(OsNo, OsName, NameSuoxie);
         }
         MessageBox.Show("导入完成");
     }
 }