private void cap_nhat_gridview() { C1.Win.C1FlexGrid.CellStyle v_cell_style_err = this.m_fg.Styles.Add("RowColorErr"); v_cell_style_err.BackColor = Color.Red; US_V_GD_DON_DAT_HANG_DETAIL v_us_v_don_dat_hang_de = new US_V_GD_DON_DAT_HANG_DETAIL(); DS_V_GD_DON_DAT_HANG_DETAIL v_ds_v_don_dat_hang_de = new DS_V_GD_DON_DAT_HANG_DETAIL(); int v_i_row_fg = 0; int v_i_m_ds = 0; for (v_i_row_fg = 1, v_i_m_ds=0 ; v_i_row_fg < m_fg.Rows.Count; v_i_row_fg++, v_i_m_ds++) { m_lbl_loading.Visible = true; progressBar1.Visible = true; progressBar1.Minimum = 0; progressBar1.Maximum = m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Count; progressBar1.Value = v_i_row_fg; v_us_v_don_dat_hang_de.So_sanh_hoa_don_theo_ma_NCC(v_ds_v_don_dat_hang_de, m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_m_ds][(int)e_col_Number.MA_PHIEU].ToString(), m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_m_ds][(int)e_col_Number.TEN_VPP].ToString()); if (v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows.Count > 0) { decimal test = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.SO_LUONG]); decimal don_gia = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.GIA_BAN]); decimal doanh_thu = CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.DOANH_THU]); if (CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.SO_LUONG]) == CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["SO_LUONG"]) && CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.GIA_BAN]) == CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["DON_GIA_CHUA_VAT"]) && CIPConvert.ToDecimal(m_fg.Rows[v_i_row_fg][(int)e_col_Number.DOANH_THU]) == (CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["DON_GIA_CHUA_VAT"]) * CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["SO_LUONG"]))) { m_fg.RemoveItem(v_i_row_fg); v_i_row_fg--; } } v_ds_v_don_dat_hang_de.Clear(); } m_lbl_loading.Visible = false; progressBar1.Visible = false; m_lbl_thong_bao_cap_nhat.Visible = true; }
private void load_don_dat_hang_de(string ip_v_ma_phieu) { US_V_GD_DON_DAT_HANG_DETAIL v_us = new US_V_GD_DON_DAT_HANG_DETAIL(); DS_V_GD_DON_DAT_HANG_DETAIL v_ds = new DS_V_GD_DON_DAT_HANG_DETAIL(); v_us.FillDataset(v_ds, "Where MA_DON_HANG =" + "'"+ip_v_ma_phieu+"' order by NGAY_DAT_HANG DESC"); m_fg_don_dat_hang_de.Redraw = false; CGridUtils.Dataset2C1Grid(v_ds, m_fg_don_dat_hang_de, m_obj_trans_de); m_fg_don_dat_hang_de.Redraw = true; }
} private void update_v_gd_don_dat_hang_detail() { if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_don_hang_de)) return; if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_don_hang_de, m_grv_don_hang_de.Row)) return; grid2us_object(m_us, m_grv_don_hang_de.Row);
Hashtable v_htb = new Hashtable(); v_htb.Add(V_GD_DON_DAT_HANG_DETAIL.TRANG_THAI_HANG, e_col_Number.TRANG_THAI_HANG); v_htb.Add(V_GD_DON_DAT_HANG_DETAIL.DON_GIA_CHUA_VAT, e_col_Number.DON_GIA_CHUA_VAT); v_htb.Add(V_GD_DON_DAT_HANG_DETAIL.TEN_VPP, e_col_Number.TEN_VPP); v_htb.Add(V_GD_DON_DAT_HANG_DETAIL.DON_GIA_GOM_VAT, e_col_Number.DON_GIA_GOM_VAT); v_htb.Add(V_GD_DON_DAT_HANG_DETAIL.SO_LUONG, e_col_Number.SO_LUONG); v_htb.Add(V_GD_DON_DAT_HANG_DETAIL.MA_VPP, e_col_Number.MA_VPP); v_htb.Add(V_GD_DON_DAT_HANG_DETAIL.DON_VI_TINH, e_col_Number.DON_VI_TINH);
components.Dispose(); } } base.Dispose( disposing ); } private void delete_v_gd_don_dat_hang_detail() { if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_don_hang_de)) return; if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_don_hang_de, m_grv_don_hang_de.Row)) return; if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return; US_V_GD_DON_DAT_HANG_DETAIL v_us = new US_V_GD_DON_DAT_HANG_DETAIL(); grid2us_object(v_us, m_grv_don_hang_de.Row); try { v_us.BeginTransaction(); v_us.Delete(); v_us.CommitTransaction(); m_grv_don_hang_de.Rows.Remove(m_grv_don_hang_de.Row); } catch (Exception v_e) {
private void load_data_2_grid_detail(decimal ip_dc_id_don_hang) { US_V_GD_DON_DAT_HANG_DETAIL v_us = new US_V_GD_DON_DAT_HANG_DETAIL(); DS_V_GD_DON_DAT_HANG_DETAIL v_ds = new DS_V_GD_DON_DAT_HANG_DETAIL(); v_us.FillDataset(v_ds, "where id_don_dat_hang=" + ip_dc_id_don_hang); m_grv_detail.DataSource = v_ds.V_GD_DON_DAT_HANG_DETAIL; m_grv_detail.DataBind(); string v_str_thong_tin = "Danh sách Có " + v_ds.V_GD_DON_DAT_HANG_DETAIL.Rows.Count + " mặt hàng"; m_lbl_grv_detail.Text = v_str_thong_tin; view_detail_grv(true); }
private void so_sanh_chi_phi_voi_don_hang() { US_V_GD_DON_DAT_HANG_DETAIL v_us_v_don_dat_hang_de = new US_V_GD_DON_DAT_HANG_DETAIL(); DS_V_GD_DON_DAT_HANG_DETAIL v_ds_v_don_dat_hang_de = new DS_V_GD_DON_DAT_HANG_DETAIL(); int v_i_row_fg = 0; int v_i_ds = 0; //set Style cell C1.Win.C1FlexGrid.CellStyle v_cell_style_err = this.m_fg.Styles.Add("RowColorErr"); v_cell_style_err.BackColor = Color.Red; C1.Win.C1FlexGrid.CellStyle v_cell_style_err2 = this.m_fg.Styles.Add("RowColorErr2"); v_cell_style_err2.BackColor = Color.Yellow; v_cell_style_err2.ForeColor = Color.DarkRed; C1.Win.C1FlexGrid.CellStyle v_cell_style_ok = this.m_fg.Styles.Add("RowColorOk"); v_cell_style_ok.BackColor = Color.White; C1.Win.C1FlexGrid.CellStyle v_cell_style_chu_ok = this.m_fg.Styles.Add("RowColor"); v_cell_style_chu_ok.BackColor = Color.Black; C1.Win.C1FlexGrid.CellStyle v_cell_style_notOK_in_data = this.m_fg.Styles.Add("RowColorNotOk"); v_cell_style_notOK_in_data.BackColor = Color.Green; //so sánh từng hóa đơn với MA_PHIEU trong cơ sở dữ liệu for (v_i_row_fg = 1, v_i_ds = 0; v_i_ds < m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Count; v_i_row_fg++, v_i_ds++) { m_lbl_loading.Visible = true; progressBar1.Visible = true; progressBar1.Minimum = 0; progressBar1.Maximum = m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Count; progressBar1.Value = v_i_row_fg; v_us_v_don_dat_hang_de.So_sanh_hoa_don_theo_ma_NCC(v_ds_v_don_dat_hang_de, m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.MA_PHIEU].ToString(), m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.TEN_VPP].ToString()); if (v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows.Count > 0) { if (CIPConvert.ToDecimal(m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.SO_LUONG]) != CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["SO_LUONG"])) { m_fg.SetCellStyle(v_i_row_fg, (int)e_col_Number.SO_LUONG, v_cell_style_err2); } if (CIPConvert.ToDecimal(m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.GIA_BAN]) != CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["DON_GIA_CHUA_VAT"])) { m_fg.SetCellStyle(v_i_row_fg, (int)e_col_Number.GIA_BAN, v_cell_style_err2); } if (CIPConvert.ToDecimal(m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_ds][(int)e_col_Number.DOANH_THU]) != (CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["DON_GIA_CHUA_VAT"]) * CIPConvert.ToDecimal(v_ds_v_don_dat_hang_de.V_GD_DON_DAT_HANG_DETAIL.Rows[0]["SO_LUONG"]))) { m_fg.SetCellStyle(v_i_row_fg, (int)e_col_Number.DOANH_THU, v_cell_style_err2); } } else { m_fg.SetCellStyle(v_i_row_fg, (int)e_col_Number.TEN_VPP, v_cell_style_err); //m_fg.Rows[v_i_row_fg].StyleDisplay.ForeColor = Color.White; } v_ds_v_don_dat_hang_de.Clear(); } m_lbl_loading.Visible = false; progressBar1.Visible = false; }
private void display_pop_up_detail(string v_ma_don_hang) { m_lbl_ten_detail.Text = "Mã phiếu: " + v_ma_don_hang.ToString(); US_V_GD_DON_DAT_HANG_DETAIL v_us = new US_V_GD_DON_DAT_HANG_DETAIL(); DS_V_GD_DON_DAT_HANG_DETAIL v_ds = new DS_V_GD_DON_DAT_HANG_DETAIL(); v_us.FillDataset(v_ds, v_ma_don_hang, CIPConvert.ToDatetime(m_txt_tu_ngay.Text), CIPConvert.ToDatetime(m_txt_den_ngay.Text)); m_grv_detail.DataSource = v_ds.V_GD_DON_DAT_HANG_DETAIL; string v_str_thong_tin = "Danh sách Có " + v_ds.V_GD_DON_DAT_HANG_DETAIL.Rows.Count + " vật tư"; m_lbl_grv_detail.Text = v_str_thong_tin; m_grv_detail.DataBind(); }