private void 个签意见书ToolStripMenuItem_Click(object sender, EventArgs e) { HashSet <Visa> set = new HashSet <Visa>(); Model.Visa visaModel = null; int idx = 0; //visaModel的下标 for (int i = 0; i < rowMergeView1.SelectedRows.Count; i++) { for (int j = 0; j < _listVisa.Count; j++) { if (_listVisaInfo[j].Contains(_listDgv[rowMergeView1.SelectedRows[i].Index])) { if (!set.Contains(_listVisa[j])) { set.Add(_listVisa[j]); visaModel = _listVisa[j]; idx = j; } } } } if (set.Count > 1) { MessageBoxEx.Show("请选择同一个团号的签证进行导出!"); return; } if (visaModel == null) { return; } ExcelGenerator.GetIndividualVisaExcel(_listVisaInfo[idx], visaModel.Remark, visaModel.GroupNo); }
/// <summary> /// 生成报表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCreateReport_Click(object sender, EventArgs e) { if (dgvGroupInfo.Rows[0].Cells["Remark"].Value != null) { ExcelGenerator.GetIndividualVisaExcel(_dgvList, dgvGroupInfo.Rows[0].Cells["Remark"].Value.ToString(), txtGroupNo.Text); } else { ExcelGenerator.GetIndividualVisaExcel(_dgvList, string.Empty, txtGroupNo.Text); } }
private void 个签意见书ToolStripMenuItem_Click(object sender, EventArgs e) { if (this.dataGridView1.SelectedRows.Count > 1) { MessageBoxEx.Show(Resources.SelectShowMoreThanOne); return; } Model.Visa visaModel = _bllVisa.GetModel((Guid)dataGridView1.SelectedRows[0].Cells["Visa_id"].Value); if (visaModel == null) { MessageBoxEx.Show(Resources.FindModelFailedPleaseCheckInfoCorrect); return; } if (visaModel.Types == Common.Enums.Types.Team) { MessageBoxEx.Show("团签类型不能导出此报表!"); return; } var list = _bllVisaInfo.GetModelList(" visa_id = '" + visaModel.Visa_id + "' "); ExcelGenerator.GetIndividualVisaExcel(list, visaModel.Remark, visaModel.GroupNo); }