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(); m_hdf_ten_trung_tam.Value = m_lbl_title.Text; m_hdf_ma_trung_tam.Value = v_ds.DM_PHONG_BAN[0]["MA_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); DateTime v_ngay_dat_hang = CIPConvert.ToDatetime(m_hdf_ngay_gui.Value); DateTime m_dat_dau_thang = new DateTime(v_ngay_dat_hang.Year,v_ngay_dat_hang.Month,1); DateTime m_dat_cuoi_thang = m_dat_dau_thang.AddMonths(1).AddDays(-1); if (CIPConvert.ToDecimal(m_hdf_form_mode.Value) == CONST_ID_TRANG_THAI_DON_HANG.XIN_TD_DUYET) 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); if (CIPConvert.ToDecimal(m_hdf_form_mode.Value) == CONST_ID_TRANG_THAI_DON_HANG.XIN_CC_DUYET) 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); //lay ti le vuot m_hdf_ti_le_vuot.Value = v_ds_gd_don_dat_hang.GD_DON_DAT_HANG.Rows[0]["PHAN_TRAM_VUOT"].ToString(); m_grv_don_hang_nhap.DataSource = v_ds_gd_don_dat_hang.GD_DON_DAT_HANG; m_grv_don_hang_nhap.DataBind(); if (v_ds_gd_don_dat_hang.GD_DON_DAT_HANG.Count > 0) { load_thong_tin_chi_tiet(); load_data_to_grid_don_hang_de(); } //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), "#,###") + " (VNĐ)"; //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"]) >= 20) // { // 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), "#,###"); }
private bool check_cc_duyet_don_hang() { 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(); DateTime m_dat_cuoi_thang = DateTime.Now.AddMonths(1).AddDays(-1); v_us_gd_don_dat_hang.load_ddh_xin_cc_duyet(v_ds_gd_don_dat_hang, CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value), m_dat_cuoi_thang); if (v_ds_gd_don_dat_hang.GD_DON_DAT_HANG.Rows.Count > 0) return true; else return false; }