private void toolStripButton1_Click(object sender, EventArgs e)
{
using (DataGridView dgv = new DataGridView())
{
var c = this.PharmacyDatabaseService.GetRolewithModule().OrderBy(r => r.RoleName);
var d = from i in c
group i by i.RoleName into g
let auths = g.Select(r => r.ModuleName)
let authkeys = g.Select(r => r.ModuleAuthKey)
select new Business.Models.RoleWithModuleModel
{
ModuleAuthKey = String.Join(",", authkeys),
ModuleName = String.Join(",", auths),
RoleName = g.FirstOrDefault().RoleName,
RoleCode = g.FirstOrDefault().RoleCode,
RoleDescription = g.FirstOrDefault().RoleDescription
};
this.Controls.Add(dgv);
dgv.Name = "RoleWithModule";
dgv.DataSource = d.ToList();
MyExcelUtls.DataGridview2Sheet(dgv, "岗位权限分配表");
}
}
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)
{
using (DataGridView dgv = new DataGridView())
{
this.Controls.Add(dgv);
var c = this.PharmacyDatabaseService.GetRolewithUser().OrderBy(r => r.EmployeeName);
var d = from i in c
group i by i.EmployeeName into g
let roles = g.Select(r => r.RoleName)
let rolecode = g.Select(r => r.RoleCode)
select new Business.Models.RoleWithUserModel
{
RoleName = String.Join(",", roles),
EmployeeName = g.FirstOrDefault().EmployeeName,
Password = g.FirstOrDefault().Password,
RoleCode = String.Join(",", rolecode),
RoleDescription = string.Empty,
UserAcount = g.FirstOrDefault().UserAcount
};
dgv.DataSource = d.OrderBy(r => r.EmployeeName).ToList();
dgv.AutoGenerateColumns = false;
MyExcelUtls.DataGridview2Sheet(dgv, "员工岗位分配表");
}
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
if (this.dataGridView1.Rows.Count <= 0)
{
return;
}
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "采购入库单");
}
private void toolStripButton5_Click(object sender, EventArgs e)
{
if (this.dataGridView1.Rows.Count <= 0)
{
return;
}
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "销售管理、税票费情况(" + DateTime.Now.ToLongDateString() + ")");
}
private void btnExcelImport_Click(object sender, EventArgs e)
{
string path = "员工名册20160823.xls";
DataSet ds = MyExcelUtls.GetExcelToDataSet(path, false);
dataGridView1.DataSource = ds.Tables["上海总部$"];
excelTable = ds.Tables["上海总部$"];
btnToDB.Enabled = true;
}
private void toolStripButton1_Click_1(object sender, EventArgs e)
{
if (this.dataGridView1.Rows.Count <= 0)
{
return;
}
string s = this._order == null ? "" : this._order.DocumentNumber;
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "采购订单" + s);
}
private void button2_Click(object sender, EventArgs e)
{
this.dataGridView1.EndEdit();
if (this.dataGridView1.Rows.Count <= 0)
{
MessageBox.Show("盘存数据为空！无导出数据！");
return;
}
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, this.comboBox1.Text + "库存");
//Search();
}
private void btnny_Click(object sender, EventArgs e)
{
string path = "20160425学员名单宁阳.xls";
DataSet ds = MyExcelUtls.GetExcelToDataSet(path, false);
dataGridView1.DataSource = ds.Tables[0];
excelTable = ds.Tables[0];
//btnToDB.Enabled = true;
}
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 void btnjmsadd_Click(object sender, EventArgs e)
{
//if(openFileDialog1.ShowDialog()== DialogResult.OK)
{
//string path = "加盟信息记录表_陈志刚.xls";
//string path = "加盟信息记录表_马鑫.xls";
//string path = "加盟信息记录表_王彬.xls";
//string path = "加盟信息记录表_吴华强.xls";
string path = "加盟信息记录表_周悦琪.xls";
DataSet ds = MyExcelUtls.GetExcelToDataSet(path, false);
dataGridView1.DataSource = ds.Tables["Sheet1$"];
excelTable = ds.Tables["Sheet1$"];
btnImportJms.Enabled = true;
btnImportJmsGenzong.Enabled = true;
}
}
//右键菜单事件
private void GetDrugInfo(int Method)
{
if (this.dgvMain.SelectedRows.Count <= 0)
{
return;
}
var c = this.dgvMain.SelectedRows[0].DataBoundItem as Business.Models.DrugInfoModel;
DrugInfo di = this.PharmacyDatabaseService.GetDrugInfo(out msg, c.id);
if (di == null)
{
return;
}
if (Method == 0)
{
UI.UserControls.ucGoodsInfo ucControl = new UserControls.ucGoodsInfo(di);
Form f = new Form();
f.WindowState = FormWindowState.Normal;
f.StartPosition = FormStartPosition.CenterScreen;
f.Text = di.ProductGeneralName;
f.AutoSize = true;
f.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
Panel p = new Panel();
p.AutoSize = true;
p.Controls.Add(ucControl);
f.Controls.Add(p);
SetControls.SetControlReadonly(f, true);
f.ShowDialog();
}
if (Method == 1)
{
Forms.Approval.FormApprovalFlowCenter form = new Forms.Approval.FormApprovalFlowCenter(di, di.FlowID, false);
form.ShowDialog();
}
if (Method == 2)
{
MyExcelUtls.DataGridview2Sheet(this.dgvMain, "已锁定品种信息查询结果");
}
}
public Form_OutInventoryCheck()
{
InitializeComponent();
#region 表格初始化和右键
this.dataGridView1.RowPostPaint += (s, e) => DataGridViewOperator.SetRowNumber(this.dataGridView1, e);
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
this.dataGridView1.ReadOnly = true;
BaseRightMenu brm = new BaseRightMenu(this.dataGridView1);
#endregion
#region 控件事件
this.toolStripButton1.Click += (s, e) => GetData();
this.button1.Click += (s, e) => GetData();
this.toolStripButton2.Click += (s, e) =>
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "出库复核查询结果");
};
this.button2.Click += (s, e) =>
{
this.q = new DrugOutInventoryCheckQueryModel
{
DTF = DateTime.Now.Date,
DTT = DateTime.Now.Date
};
this.drugOutInventoryCheckQueryModelBindingSource.Clear();
this.drugOutInventoryCheckQueryModelBindingSource.Add(this.q);
};
#endregion
#region 绑定
this.drugOutInventoryCheckQueryModelBindingSource.Add(this.q);
#endregion
}
//右键菜单事件
private void GetDrugInfo(int Method)
{
if (this.dataGridView1.SelectedRows.Count <= 0)
{
return;
}
var c = this.dataGridView1.SelectedRows[0].DataBoundItem as Business.Models.DrugInfoModel;
DrugInfo di = this.PharmacyDatabaseService.GetDrugInfo(out msg, c.id);
if (di == null)
{
return;
}
if (Method == 0)
{
UI.UserControls.ucGoodsInfo ucControl = new UserControls.ucGoodsInfo(di);
Form f = new Form();
f.WindowState = FormWindowState.Normal;
f.StartPosition = FormStartPosition.CenterScreen;
f.Text = di.ProductGeneralName;
f.AutoSize = true;
f.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
Panel p = new Panel();
p.AutoSize = true;
p.Controls.Add(ucControl);
f.Controls.Add(p);
SetControls.SetControlReadonly(f, true);
f.ShowDialog();
}
if (Method == 1)
{
FormApprovalFlowCenter form = new FormApprovalFlowCenter(di, di.FlowID, false);
form.ShowDialog();
}
if (Method == 2)
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "品种信息查询结果");
}
if (Method == 3)
{
var u = this.dataGridView1.SelectedRows[0].DataBoundItem as Business.Models.DrugInfoModel;
byte[] b = this.PharmacyDatabaseService.GetUpdateFiles("ApprovalFiles\\9047DBCF-CD15-4904-8786-006A76DD4799").FirstOrDefault().bytes;
using (System.IO.FileStream fs = new System.IO.FileStream("File", System.IO.FileMode.OpenOrCreate))
{
fs.Write(b, 0, b.Length);
fs.Close();
CreateWinWord cww = new CreateWinWord();
cww.d = u;
if (cww.CreateWord(fs.Name, u.ProductGeneralName, 2))
{
MessageBox.Show(u.ProductGeneralName + "：审批信息表导出成功！");
this.PharmacyDatabaseService.WriteLog(BugsBox.Pharmacy.AppClient.Common.AppClientContext.currentUser.Id, "导出首营信息审批表成功！品种名称：" + di.ProductGeneralName);
}
else
{
this.PharmacyDatabaseService.WriteLog(BugsBox.Pharmacy.AppClient.Common.AppClientContext.currentUser.Id, "导出首营信息审批表失败！品种名称：" + di.ProductGeneralName);
}
fs.Dispose();
}
}
if (Method == 4)
{
var u = this.dataGridView1.SelectedRows[0].DataBoundItem as Business.Models.DrugInfoModel;
Form_DrugQualityTrace frm = new Form_DrugQualityTrace(u.id, u.ProductGeneralName);
frm.ShowDialog();
frm.Dispose();
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dgvOutInventory, "销售出库拣货复核查询结果");
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "药品养护单");
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dgvDrugDetailList, "报损申请单" + DateTime.Now.Ticks);
}
private void toolStripbtnOutput_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "库存缺货单");
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "配送入库退货单查询结果");
}
private void toolStripButton1_Click_1(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dgvDrugDetailList, "不合格药品申请");
}
private void button1_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "销售统计（" + dtFrom.Value.ToLongDateString() + "至：" + dtTo.Value.ToLongDateString() + "）");
}
private void button1_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "采购记录汇总");
}
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);
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView2, "直调销售单据" + DateTime.Now.Ticks.ToString());
}
private void button2_Click(object sender, EventArgs e)
{
string msg = string.Empty;
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "可用库存表");
}
public FormInstrumentsQuery()
{
InitializeComponent();
#region 右键支持
BaseForm.BasicInfoRightMenu cms = new BaseForm.BasicInfoRightMenu(this.dataGridView1);
cms.InserMenu("查看医疗器械信息", delegate()
{
this.InstrumentDetailOpen(FormStatusEnum.Read);
});
cms.InserMenu("修改医疗器械信息", delegate()
{
this.InstrumentDetailOpen(FormStatusEnum.Edit);
});
cms.InserMenu("导出当前查询结果列表", delegate()
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "医疗器械信息查询结果列表");
});
cms.InserMenu("导出当前器械审批表", delegate()
{
var u = this.dataGridView1.CurrentRow.DataBoundItem as Business.Models.InstrumentsModel;
byte[] b = this.PharmacyDatabaseService.GetUpdateFiles("ApprovalFiles\\医疗器械.doc").FirstOrDefault().bytes;
using (System.IO.FileStream fs = new System.IO.FileStream("File", System.IO.FileMode.OpenOrCreate))
{
fs.Write(b, 0, b.Length);
fs.Close();
CreateWinWord cww = new CreateWinWord();
cww.Inst = u;
if (cww.CreateWord(fs.Name, u.ProductGeneralName, 0))
{
MessageBox.Show(u.ProductGeneralName + "：审批信息表导出成功！");
this.PharmacyDatabaseService.WriteLog(BugsBox.Pharmacy.AppClient.Common.AppClientContext.currentUser.Id, "导出首营医疗器械信息审批表成功！品种名称：" + u.ProductGeneralName);
}
else
{
this.PharmacyDatabaseService.WriteLog(BugsBox.Pharmacy.AppClient.Common.AppClientContext.currentUser.Id, "导出首营医疗器械信息审批表失败！品种名称：" + u.ProductGeneralName);
}
fs.Dispose();
}
});
#endregion
#region datagridview1事件
this.dataGridView1.AutoGenerateColumns = true;
this.dataGridView1.ReadOnly = true;
this.dataGridView1.RowPostPaint += (sender, ex) => DataGridViewOperator.SetRowNumber((DataGridView)sender, ex);
this.dataGridView1.CellMouseDoubleClick += (sender, e) =>
{
if (e.ColumnIndex < 0 || e.RowIndex < 0)
{
return;
}
if (e.Button == System.Windows.Forms.MouseButtons.Left)
{
this.InstrumentDetailOpen(FormStatusEnum.Read);
}
};
#endregion
#region 文本框键盘事件
this.textBox1.KeyDown += (sender, e) =>
{
if (e.KeyCode == Keys.Return || e.KeyCode == Keys.Enter)
{
this.InstrumentsQuery();
}
};
#endregion
#region 分页控件事件
this.pagerControl1.DataPaging += pagerControl1_DataPaging;
#endregion
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dgvMain, "已锁定客户查询结果");
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dgvMain, "药品销售记录查询单");
}
public FormOrderReturnDetailIndex()
{
InitializeComponent();
BugsBox.Pharmacy.UI.Common.BaseRightMenu brm = new BugsBox.Pharmacy.UI.Common.BaseRightMenu(this.dataGridView1);
brm.InsertMenuItem("导出查询结果", delegate()
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "销售品种退货记录");
});
brm.InsertMenuItem("查看销退详情", delegate()
{
if (this.dataGridView1.CurrentRow == null)
{
return;
}
var m = this.dataGridView1.CurrentRow.DataBoundItem as Business.Models.SalesOrderReturnDetailModel;
var orderReturn = PharmacyDatabaseService.GetSalesOrderReturn(out msg, m.SalesOrderReturnId);
using (FormSalesOrderReturn frm = new FormSalesOrderReturn(orderReturn))
{
frm.ShowDialog();
}
});
brm.InsertMenuItem("查看销售单", delegate()
{
if (this.dataGridView1.CurrentRow == null)
{
return;
}
var m = this.dataGridView1.CurrentRow.DataBoundItem as Business.Models.SalesOrderReturnDetailModel;
SalesOrder so = this.PharmacyDatabaseService.GetSalesOrder(out msg, m.SalesOrderId);
using (FormSalesOrderEdit frm = new FormSalesOrderEdit(so, true))
{
frm.ShowDialog();
}
});
Business.Models.SalesOrderReturnDetailQueryModel q = null;
//初始化查询条件
Action InitQuery = () =>
{
this.dateTimePicker1.Value = DateTime.Now.Date.AddDays(-3);
this.dateTimePicker2.Value = DateTime.Now.Date;
q = new Business.Models.SalesOrderReturnDetailQueryModel
{
DTF = this.dateTimePicker1.Value,
DTT = this.dateTimePicker2.Value.AddDays(1)
};
this.salesOrderReturnDetailQueryModelBindingSource.Clear();
this.salesOrderReturnDetailQueryModelBindingSource.Add(q);
};
InitQuery();
#region 初始化表格控件
this.dataGridView1.AllowUserToAddRows = false;
this.dataGridView1.ReadOnly = true;
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
this.dataGridView1.RowPostPaint += (s, e) => DataGridViewOperator.SetRowNumber(this.dataGridView1, e);
this.dataGridView1.AllowUserToOrderColumns = true;
#endregion
#region 钮事件
this.toolStripButton1.Click += (s, e) =>
{
this.Validate();
q.DTT = this.dateTimePicker2.Value.AddDays(1);
q.DTF = this.dateTimePicker1.Value;
var re = this.PharmacyDatabaseService.GetSalesOrderReturnDetailModels(q, out msg).ToList();
re.Add(new Business.Models.SalesOrderReturnDetailModel
{
ProductGeneralName = "合计",
ReturnAmount = re.Sum(r => r.ReturnAmount),
Price = re.Sum(r => decimal.Round(r.ReturnAmount * r.UnitPrice, 4))
});
this.dataGridView1.DataSource = re;
this.dataGridView1.Columns["DrugInfoId"].Visible = false;
this.dataGridView1.Columns["CreateTime"].Visible = false;
this.dataGridView1.Columns["ReturnEmName"].Visible = false;
this.dataGridView1.Columns["Id"].Visible = false;
this.dataGridView1.Columns["SalesOrderId"].Visible = false;
this.dataGridView1.Columns["SalesOrderReturnId"].Visible = false;
Business.Models.SalesOrderReturnDetailModel m = new Business.Models.SalesOrderReturnDetailModel();
PropertyInfo[] pis = m.GetType().GetProperties();
foreach (PropertyInfo pi in pis)
{
int a = (pi.GetCustomAttributes(typeof(DataMemberAttribute), false)[0] as DataMemberAttribute).Order;
if (a < 0)
{
continue;
}
this.dataGridView1.Columns[pi.Name].DisplayIndex = a;
}
};
this.toolStripButton2.Click += (s, e) =>
{
InitQuery();
};
this.toolStripButton3.Click += (s, e) =>
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "销售品种退货记录");
};
#endregion
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
MyExcelUtls.DataGridview2Sheet(this.dataGridView1, "采购、销售管理、税票统计结果");
}
