Пример #1
0
        public void load_data_2_grid()
        {
            US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
            DataSet       v_ds = new DataSet();

            v_ds.Tables.Add(new DataTable());
            DateTime startDate = new DateTime();
            DateTime endDate   = new DateTime();

            if (deStartDate.EditValue == null)
            {
                startDate = new DateTime(2000, 1, 1);
            }
            else
            {
                startDate = (DateTime)deStartDate.EditValue;
            }
            if (deEndDate.EditValue == null)
            {
                endDate = DateTime.Now;
            }
            else
            {
                endDate = (DateTime)deEndDate.EditValue;
            }
            var states = (from CheckedListBoxItem item in chbbOrderState.Properties.Items
                          where item.CheckState == CheckState.Checked
                          select item.Value.ToString()).ToArray();
            string orderState = "";

            foreach (string state in states)
            {
                orderState += state + ",";
            }
            orderState += "0";
            v_us.FillAllOrder(v_ds, startDate, endDate, orderState);
            m_grc_ds_tat_ca_don_dat_hang.DataSource = v_ds.Tables[0];
        }