/// <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);
     }
 }
Esempio n. 2
0
        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);
        }