示例#1
0
 private void btnOK_Click(object sender, EventArgs e)
 {
     using (EF.chtpzDBcontext db = new EF.chtpzDBcontext())
     {
         var query = db.FIRMs.Select(x => new { x.FIRM_ID, x.NAME, JUR_CITY_NAME = x.JUR_CITY.NAME, POST_CITY_NAME = x.POST_CITY.NAME });
         if (chkFirm.Checked)
         {
             query = query.Where(x => x.NAME.Contains(txtFirm.Text));
         }
         if (chkCity_Jur.Checked)
         {
             query = query.Where(x => x.JUR_CITY_NAME.Contains(txtCity_Jur.Text));
         }
         if (chkCity_Post.Checked)
         {
             query = query.Where(x => x.POST_CITY_NAME.Contains(txtCity_Post.Text));
         }
         dgvData1.DataSource = query.ToList();
     }
 }
示例#2
0
        private void frmTask1_Load(object sender, EventArgs e)
        {
            using (EF.chtpzDBcontext db = new EF.chtpzDBcontext())
            {
                var query = db.FIRMs.Select(x => new { x.FIRM_ID, x.NAME, JUR_CITY_NAME = x.JUR_CITY.NAME, POST_CITY_NAME = x.POST_CITY.NAME });
                dgvData1.DataSource = query.ToList();
            }

            #region dtvData1 shettings
            dgvData1.Columns["FIRM_ID"].Visible           = false;
            dgvData1.Columns["NAME"].HeaderText           = "Наименование фирмы";
            dgvData1.Columns["JUR_CITY_NAME"].HeaderText  = "Юр. город";
            dgvData1.Columns["POST_CITY_NAME"].HeaderText = "Почтовый город";
            #endregion

            #region Привязки к элементам управления
            txtFirm.DataBindings.Add(new Binding("Enabled", chkFirm, "Checked"));
            txtCity_Post.DataBindings.Add(new Binding("Enabled", chkCity_Post, "Checked"));
            txtCity_Jur.DataBindings.Add(new Binding("Enabled", chkCity_Jur, "Checked"));
            #endregion
        }
示例#3
0
        private void btnFilter2_Click(object sender, EventArgs e)
        {
            using (EF.chtpzDBcontext db = new EF.chtpzDBcontext())
            {
                var query = db.DOCUMENTs.Include(x => x.FIRM);
                if (chkNotFirm.Checked)
                {
                    int[] arrFirmId = new int[dgvData1.Rows.Count];
                    for (int i = 0; i < dgvData1.Rows.Count; i++)
                    {
                        arrFirmId[i] = (int)dgvData1.Rows[i].Cells["FIRM_ID"].Value;
                    }
                    query = query.Where(x => !arrFirmId.Contains(x.FIRM_ID));
                }

                var res = from c in query
                          group c by new { c.DOC_DATE.Month, c.DOC_DATE.Year } into g
                select g;

                //var a = db.DOCUMENTs.Local.GroupBy(x => x.DOC_DATE.ToString("MMMM", new CultureInfo("ru-RU")));
                List <myRowView> lstDataRow = new List <myRowView>();
                foreach (var item in res.OrderBy(x => x.Key.Year))
                {
                    myRowView curRow = lstDataRow.FirstOrDefault(x => x.Год == item.Key.Year);
                    if (curRow == null)
                    {
                        curRow = new myRowView();
                        lstDataRow.Add(curRow);
                    }

                    curRow.Год = item.Key.Year;
                    switch (item.Key.Month)
                    {
                    case 1:
                        curRow.Январь = item.Sum(x => x.SUM);
                        break;

                    case 2:
                        curRow.Февраль = item.Sum(x => x.SUM);
                        break;

                    case 3:
                        curRow.Март = item.Sum(x => x.SUM);
                        break;

                    case 4:
                        curRow.Апрель = item.Sum(x => x.SUM);
                        break;

                    case 5:
                        curRow.Май = item.Sum(x => x.SUM);
                        break;

                    case 6:
                        curRow.Июнь = item.Sum(x => x.SUM);
                        break;

                    case 7:
                        curRow.Июль = item.Sum(x => x.SUM);
                        break;

                    case 8:
                        curRow.Август = item.Sum(x => x.SUM);
                        break;

                    case 9:
                        curRow.Сентябрь = item.Sum(x => x.SUM);
                        break;

                    case 10:
                        curRow.Октябрь = item.Sum(x => x.SUM);
                        break;

                    case 11:
                        curRow.Ноябрь = item.Sum(x => x.SUM);
                        break;

                    case 12:
                        curRow.Декабрь = item.Sum(x => x.SUM);
                        break;
                    }
                }
                lstDataRow.OrderBy(x => x.Год);
                dgvData2.DataSource = lstDataRow;
            }
        }