private void load_data_to_lst_giao_kh(BKI_QLDTEntities ip_db) { decimal v_dc_id_quyet_dinh; if (m_lst_quyet_dinh.Count > 0) { v_dc_id_quyet_dinh = m_lst_quyet_dinh[0].ID; } else return; decimal v_id_dc_reported_user = Person.get_user_id(); US_GRID_GIAO_KH v_us = new US_GRID_GIAO_KH(); DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); v_us.get_grid_giao_kh_qbt(v_ds , v_dc_id_quyet_dinh , m_str_nguon , v_id_dc_reported_user , m_dc_id_don_vi); m_lst_giao_kh = v_ds.Tables[0] .AsEnumerable() .Select(x => new pr_F104_nhap_du_toan_ke_hoach_Result { ID = (x.IsNull("ID") ? -1 : CIPConvert.ToDecimal(x["ID"])), ID_CHA = (x.IsNull("ID_CHA") ? -1 : CIPConvert.ToDecimal(x["ID_CHA"])), ID_DON_VI = (x.IsNull("ID_DON_VI") ? -1 : CIPConvert.ToDecimal(x["ID_DON_VI"])), ID_REPORTED_USER = (x.IsNull("ID_REPORTED_USER") ? -1 : CIPConvert.ToDecimal(x["ID_REPORTED_USER"])), NOI_DUNG = x["NOI_DUNG"].ToString(), NS = (x.IsNull("NS") ? 0 : CIPConvert.ToDecimal(x["NS"])), NTCT = (x.IsNull("NTCT") ? 0 : CIPConvert.ToDecimal(x["NTCT"])), QUY = (x.IsNull("QUY") ? 0 : CIPConvert.ToDecimal(x["QUY"])), REPORT_LEVEL = x["REPORT_LEVEL"].ToString(), So_KM = (x.IsNull("So_KM") ? 0 : CIPConvert.ToDecimal(x["So_KM"])), STT = x["STT"].ToString(), TONG = (x.IsNull("TONG") ? 0 : CIPConvert.ToDecimal(x["TONG"])), }) .ToList(); }
private void load_data_to_grid() { try { //Kiem tra neu khong phai la don vi nhap thi chi cho xem if (m_ddl_don_vi.SelectedValue != Person.get_id_don_vi().ToString()) { m_grv.Columns[0].Visible = false; m_cmd_insert.Visible = false; m_cmd_update.Visible = false; m_cmd_cancel.Visible = false; } else { m_grv.Columns[0].Visible = true; if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.SUA) { m_cmd_update.Visible = true; m_cmd_cancel.Visible = true; } else if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.THEM) { m_cmd_insert.Visible = true; m_cmd_cancel.Visible = true; } } //decimal v_id_dc_loai = 1; decimal v_id_dc_reported_user; // Chú thích: id_dc_loai = 1 - Loại dự án // id_dc_loai = 2 - CLKM //Kiểm tra xem thuộc loại nào: //if (m_rdb_theo_quoc_lo.Checked == true) //{ // v_id_dc_loai = 1; //} //if (m_rdb_theo_chuong_loai_khoan_muc.Checked == true) //{ // v_id_dc_loai = 2; //} //Lấy id_reported_user v_id_dc_reported_user = Person.get_user_id(); //1. Get dataset DS_GRID_GIAO_KH v_ds = new DS_GRID_GIAO_KH(); //2. Lay du lieu US_GRID_GIAO_KH v_us = new US_GRID_GIAO_KH(); decimal v_dc_id_quyet_dinh = -1; if (m_hdf_id_quyet_dinh.Value.Trim().Equals("")) { v_dc_id_quyet_dinh = -1; } else v_dc_id_quyet_dinh = CIPConvert.ToDecimal(m_hdf_id_quyet_dinh.Value); if (v_dc_id_quyet_dinh != -1) { US_DM_QUYET_DINH v_us_qd = new US_DM_QUYET_DINH(v_dc_id_quyet_dinh); m_lbl_grid_ngay.Text = CIPConvert.ToStr(v_us_qd.datNGAY_THANG, "dd/MM/yyyy"); m_lbl_grid_so_quyet_dinh.Text = v_us_qd.strSO_QUYET_DINH; m_lbl_grid_ve_viec.Text = v_us_qd.strNOI_DUNG; } //kiem tra xem dang nhap Nguon nao string v_str_is_nguon_ns = "N"; if (Request.QueryString["ip_nguon_ns"] == "Y") { v_str_is_nguon_ns = "Y"; } if (v_dc_id_quyet_dinh < 0) return; v_us.get_grid_giao_kh_qbt(v_ds , v_dc_id_quyet_dinh , v_str_is_nguon_ns , v_id_dc_reported_user , CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)); m_grv.DataSource = v_ds.Tables[0]; m_grv.DataBind(); if (!m_hdf_id_giao_kh.Value.Equals("")) { m_grv.SelectedIndex = -1; for (int i = 0; i < m_grv.Rows.Count; i++) if (CIPConvert.ToDecimal(m_grv.DataKeys[i].Value) == CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value)) m_grv.SelectedIndex = i; } //get tong tien decimal v_dc_tong_tien = 0; for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++) { if (v_ds.Tables[0].Rows[i][GRID_GIAO_KH.ID].ToString() != "-1") { v_dc_tong_tien += get_so_tien(v_ds.Tables[0].Rows[i][GRID_GIAO_KH.NTCT].ToString()) + get_so_tien(v_ds.Tables[0].Rows[i][GRID_GIAO_KH.NS].ToString()) + get_so_tien(v_ds.Tables[0].Rows[i][GRID_GIAO_KH.QUY].ToString()); } } m_lbl_grid_tong_tien.Text = CIPConvert.ToStr(v_dc_tong_tien, "#,###,##"); } catch (Exception v_e) { m_lbl_mess_grid.Text = v_e.ToString(); } }