Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
 /// <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);
     }
 }
Exemplo n.º 3
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.Team)
            {
                MessageBoxEx.Show("团签类型不能导出此报表!");
                return;
            }

            var list = _bllVisaInfo.GetModelList(" visa_id = '" + visaModel.Visa_id + "' ");

            ExcelGenerator.GetIndividualVisaExcel(list, visaModel.Remark, visaModel.GroupNo);
        }