public void GenerateLibBuild(string path) { List <TableModel> tableNames = BLLFactory.Instance.idb.GetTableModelList(Utils.dbName, true); for (int i = 0; i < tableNames.Count; i++) { TableModel tm = tableNames[i]; string tablename = tm.TableName; string tableInfo = tm.TableNameRemark; DataTable dt = new DataTable(); dt.TableName = tableInfo; foreach (var item in tm.Columns) { if (!dt.Columns.Contains(item.ColumnRemark)) { dt.Columns.Add(item.ColumnRemark, typeof(string)); } } if (path.Length > 0) { string folder = path + @"\LCL\Excel\"; Utils.FolderCheck(folder); string filename = folder + tableInfo + "_Excel.xls"; MyExcelUtls.DataTable2Sheet(filename, dt); } } }
private void toolStripButton1_Click(object sender, EventArgs e) { if (this.dataGridView1.Rows.Count <= 0) { return; } SaveFileDialog sfd = new SaveFileDialog(); sfd.Filter = "EXCEL电子表格|*.xls"; sfd.InitialDirectory = "c:\\"; sfd.FileName = "库存药品损溢记录单" + DateTime.Now.Ticks.ToString(); if (sfd.ShowDialog() != System.Windows.Forms.DialogResult.OK) { return; } string fileName = sfd.FileName; DataTable dt = new DataTable("库存药品损溢记录单"); List <DataColumn> ldc = new List <DataColumn>(); foreach (DataGridViewColumn dc in this.dataGridView1.Columns) { if (dc.Index == 0) { continue; } ldc.Add(new DataColumn((dc.HeaderText), typeof(string))); } dt.Columns.AddRange(ldc.ToArray()); foreach (DataGridViewRow dgvr in this.dataGridView1.Rows) { DataRow dr = dt.NewRow(); for (int i = 1; i < dt.Columns.Count; i++) { dr[i - 1] = dgvr.Cells[i].Value == null ? string.Empty : dgvr.Cells[i].Value.ToString(); } dt.Rows.Add(dr); } if (MyExcelUtls.DataTable2Sheet(fileName, dt)) { MessageBox.Show("创建成功!"); } else { MessageBox.Show("创建失败,请联系管理员!"); } }
private bool outputToXLS(string filename) { try { DataTable dt = new DataTable("药品销毁表"); dt.Columns.Add("序号", typeof(int)); dt.Columns.Add("创建时间", typeof(DateTime)); dt.Columns.Add("创建人"); dt.Columns.Add("药品名称"); dt.Columns.Add("批号"); dt.Columns.Add("规格"); dt.Columns.Add("剂型"); dt.Columns.Add("生产厂家"); dt.Columns.Add("数量"); dt.Columns.Add("单价", typeof(decimal)); dt.Columns.Add("生产日期", typeof(DateTime)); dt.Columns.Add("有效期至", typeof(DateTime)); dt.Columns.Add("总价", typeof(decimal)); dt.Columns.Add("库区"); dt.Columns.Add("销毁方式"); dt.Columns.Add("销毁原因"); dt.Columns.Add("销毁地点"); dt.Columns.Add("销毁时间", typeof(DateTime)); dt.Columns.Add("运输车辆"); dt.Columns.Add("执行人"); dt.Columns.Add("运输人"); dt.Columns.Add("销毁后现象"); dt.Columns.Add("药监部门意见"); int i = 1; foreach (var r in result) { DataRow dr = dt.NewRow(); dr[0] = i; dr[1] = r.createTime; var p = Users.Where(u => u.CreateUserId == u.CreateUserId).FirstOrDefault(); dr[2] = p == null?"用户被人为删除!":p.Employee.Name; var b = this.PharmacyDatabaseService.GetDrugsBreakage(r.DrugsUnqualicationID, out msg); if (b == null) { MessageBox.Show("报损记录被认为删除!"); return(false); } dr[3] = b.drugName; dr[4] = b.batchNo; dr[5] = b.Specific; dr[6] = b.DosageType; dr[7] = b.FactoryName; dr[8] = b.quantity; dr[9] = b.PurchasePrice; dr[10] = b.produceDate; dr[11] = b.ExpireDate; dr[12] = r.price; dr[13] = r.wareHouseZone; dr[14] = r.DestroyMethod; dr[15] = r.DestroyReason; dr[16] = r.DestroyPlace; dr[17] = r.DestroyTime; dr[18] = r.DestroyCargo; dr[19] = r.DestroyMan; dr[20] = r.Destroyer; dr[21] = r.DestroyState; dr[22] = r.SupervisorOpinion; i++; this.toolStripProgressBar1.Value++; System.Threading.Thread.Sleep(100); dt.Rows.Add(dr); } MyExcelUtls.DataTable2Sheet(filename, dt); this.toolStripLabel7.Text = "导出完成"; this.toolStripProgressBar1.Value = 0; } catch (Exception ex) { return(false); } return(true); }