/// <summary> /// 生成报表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCreateReport_Click(object sender, EventArgs e) { if (cbCountry.Text == "日本") { ExcelGenerator.GetTeamVisaExcelOfJapan(_dgvList, txtGroupNo.Text); } else if (cbCountry.Text == "泰国") { ExcelGenerator.GetTeamVisaExcelOfThailand(_dgvList, 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.Individual) { MessageBoxEx.Show("个签类型不能导出此报表!"); return; } var list = _bllVisaInfo.GetModelList(" visa_id = '" + visaModel.Visa_id + "' "); ExcelGenerator.GetTeamVisaExcelOfJapan(list, visaModel.GroupNo); }