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);
}
