private void load_data_to_grid() { decimal v_id_trung_tam = CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value); US_DM_PHONG_BAN v_us = new US_DM_PHONG_BAN(); DS_DM_PHONG_BAN v_ds = new DS_DM_PHONG_BAN(); v_us.FillDataset(v_ds, "where id=" + v_id_trung_tam); m_lbl_title.Text = "Trung tâm - ban: " + v_ds.DM_PHONG_BAN.Rows[0]["TEN_PHONG_BAN"].ToString(); // lấy mã trung tâm m_hdf_ma_trung_tam.Value = v_ds.DM_PHONG_BAN.Rows[0]["MA_PHONG_BAN"].ToString(); DS_GD_DON_DAT_HANG v_ds_gd_don_dat_hang = new DS_GD_DON_DAT_HANG(); US_GD_DON_DAT_HANG v_us_gd_don_dat_hang = new US_GD_DON_DAT_HANG(); //string temp = "01/08/2014"; int thisyear = DateTime.Now.Year; DateTime m_dat_dau_thang = new DateTime(thisyear, int.Parse(m_cbo_chon_thang.SelectedValue.ToString()), 1); DateTime m_dat_cuoi_thang = m_dat_dau_thang.AddMonths(1).AddDays(-1); v_us_gd_don_dat_hang.load_ddh_xin_td_duyet(v_ds_gd_don_dat_hang, v_id_trung_tam, m_dat_cuoi_thang); m_grv_don_hang_nhap.DataSource = v_ds_gd_don_dat_hang.GD_DON_DAT_HANG; m_grv_don_hang_nhap.DataBind(); //Lay tong tien dinh muc m_lbl_tong_tien_dm.Text = CIPConvert.ToStr(v_us_gd_don_dat_hang.get_tong_tien_dinh_muc_hang_thang(v_id_trung_tam, 173, m_dat_dau_thang, m_dat_cuoi_thang).ToString(), "#,###,##"); m_lbl_tong_tien_da_chi.Text = CIPConvert.ToStr(v_us_gd_don_dat_hang.get_tong_tien_da_chi_hang_thang(v_id_trung_tam, m_dat_cuoi_thang), "#,###"); //check duyệt //if(m_grv_don_hang_nhap.Rows.Count>1) //for (int i = 0; i < v_ds_gd_don_dat_hang.GD_DON_DAT_HANG.Rows.Count; i++) //{ // if (CIPConvert.ToDecimal(v_ds_gd_don_dat_hang.GD_DON_DAT_HANG.Rows[i]["PHAN_TRAM_VUOT"]) >= 120) // { // m_grv_don_hang_nhap. // } // else // { } //} }
private void load_data_to_grid() { decimal v_id_trung_tam = CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value); US_DM_PHONG_BAN v_us = new US_DM_PHONG_BAN(); DS_DM_PHONG_BAN v_ds = new DS_DM_PHONG_BAN(); v_us.FillDataset(v_ds, "where id=" + v_id_trung_tam); m_lbl_title.Text = "Trung tâm - ban: " + v_ds.DM_PHONG_BAN.Rows[0]["TEN_PHONG_BAN"].ToString(); // lấy mã trung tâm m_hdf_ma_trung_tam.Value = v_ds.DM_PHONG_BAN.Rows[0]["MA_PHONG_BAN"].ToString(); DS_GD_DON_DAT_HANG v_ds_gd_don_dat_hang = new DS_GD_DON_DAT_HANG(); US_GD_DON_DAT_HANG v_us_gd_don_dat_hang = new US_GD_DON_DAT_HANG(); //string temp = "01/08/2014 int thisyear = DateTime.Now.Year; DateTime m_dat_dau_thang = new DateTime(thisyear, int.Parse(m_cbo_chon_thang.SelectedValue.ToString()),1); DateTime m_dat_cuoi_thang = m_dat_dau_thang.AddMonths(1).AddDays(-1); v_us_gd_don_dat_hang.load_ddh_xin_cc_duyet(v_ds_gd_don_dat_hang, v_id_trung_tam, m_dat_cuoi_thang); m_grv_don_hang_nhap.DataSource = v_ds_gd_don_dat_hang.GD_DON_DAT_HANG; m_grv_don_hang_nhap.DataBind(); //Lay tong tien dinh muc //DateTime v_dau_thang = DateTime.Now.Date.AddDays(-DateTime.Now.Date.Day + 1); //DateTime v_cuoi_thang = DateTime.Now.Date.AddMonths(1).AddDays(-DateTime.Now.Date.Day); m_lbl_tong_tien_dm.Text = CIPConvert.ToStr(v_us_gd_don_dat_hang.get_tong_tien_dinh_muc_hang_thang(v_id_trung_tam, 173, m_dat_dau_thang, m_dat_cuoi_thang).ToString(), "#,###,##"); m_lbl_tong_tien_da_chi.Text = CIPConvert.ToStr(v_us_gd_don_dat_hang.get_tong_tien_da_chi_hang_thang(v_id_trung_tam, m_dat_cuoi_thang), "#,###"); }