public void Display_for_chi_tiet(decimal v_id) { format_controls(); US_V_TONG_HOP_CPN_THEO_PHONG_BAN v_us = new US_V_TONG_HOP_CPN_THEO_PHONG_BAN(); DS_V_TONG_HOP_CPN_THEO_PHONG_BAN v_ds = new DS_V_TONG_HOP_CPN_THEO_PHONG_BAN(); v_us.FillDataset(v_ds,"where id ="+ v_id); DataRow v_dr = v_ds.Tables[0].Rows[0]; DateTime v_dat_ngay_gui = (DateTime)(v_dr["NGAY_GUI"]); m_lbl_phong.Text = v_dr["TEN_PHONG_BAN"].ToString(); m_lbl_so_bill.Text = v_dr["SO_BILL"].ToString(); m_lbl_ngay_gui.Text = v_dat_ngay_gui.ToShortDateString(); m_lbl_nguoi_gui.Text = v_dr["NGUOI_GUI"].ToString(); m_lbl_nguoi_nhan.Text = v_dr["NGUOI_NHAN"].ToString(); m_lbl_noi_nhan.Text = v_dr["NOI_NHAN"].ToString(); m_lbl_trang_thai.Text = v_dr["TRANG_THAI"].ToString(); m_lbl_noi_dung.Text = v_dr["NOI_DUNG"].ToString(); if (v_dr["SO_TIEN"].ToString() == "" || v_dr["SO_TIEN"] == null) { m_lbl_so_tien.Text = " 0 (vnđ)"; } else m_lbl_so_tien.Text = CIPConvert.ToStr(v_dr["SO_TIEN"], "#,##0") + " (vnđ)"; if(v_dr["TRONG_NUOC"].ToString() == "x") { m_lbl_khu_vuc.Text = "Trong nước"; } if (v_dr["NUOC_NGOAI"].ToString() == "x") { m_lbl_khu_vuc.Text = "Ngoài nước"; } if (v_dr["GHI_CHU"] == null || v_dr["GHI_CHU"].ToString() == "") { m_lbl_ghi_chu.Text = "................"; } else m_lbl_ghi_chu.Text = v_dr["GHI_CHU"].ToString(); this.ShowDialog(); }
private void grid2us_object(US_V_TONG_HOP_CPN_THEO_PHONG_BAN i_us , int i_grid_row) { DataRow v_dr; v_dr = (DataRow)m_fg.Rows[i_grid_row].UserData; m_obj_trans.GridRow2DataRow(i_grid_row, v_dr); i_us.DataRow2Me(v_dr); }
private void delete_v_tong_hop_cpn_theo_phong_ban() { if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return; if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return; if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return; US_V_TONG_HOP_CPN_THEO_PHONG_BAN v_us = new US_V_TONG_HOP_CPN_THEO_PHONG_BAN(); grid2us_object(v_us, m_fg.Row); try { v_us.BeginTransaction(); v_us.Delete(); v_us.CommitTransaction(); m_fg.Rows.Remove(m_fg.Row); } catch (Exception v_e) { v_us.Rollback(); CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret()); v_objErrHandler.showErrorMessage(); } }
private void us_object2grid(US_V_TONG_HOP_CPN_THEO_PHONG_BAN i_us , int i_grid_row) { DataRow v_dr = (DataRow)m_fg.Rows[i_grid_row].UserData; i_us.Me2DataRow(v_dr); m_obj_trans.DataRow2GridRow(v_dr, i_grid_row); }
public void Display_for_chi_tiet(decimal ip_v_id_phong_ban, decimal ip_v_id_trang_thai, DateTime ip_v_dt_tu_ngay, DateTime ip_v_dt_den_ngay, decimal ip_v_tong_bill, decimal ip_v_tong_tien) { m_obj_trans = get_trans_object(m_fg); format_controls(); US_DM_PHONG_BAN v_us_dm_pb = new US_DM_PHONG_BAN(); DS_DM_PHONG_BAN v_ds_dm_pb = new DS_DM_PHONG_BAN(); US_V_TONG_HOP_CPN_THEO_PHONG_BAN v_us_tong_hop_CPN = new US_V_TONG_HOP_CPN_THEO_PHONG_BAN(); DS_V_TONG_HOP_CPN_THEO_PHONG_BAN v_ds_tong_hop_CPN = new DS_V_TONG_HOP_CPN_THEO_PHONG_BAN(); v_us_dm_pb.FillDataset(v_ds_dm_pb, "where ID =" + ip_v_id_phong_ban); m_lbl_ten_phong_ban.Text = "CHI TIẾT CÁC BILL CỦA " + v_ds_dm_pb.Tables[0].Rows[0][2].ToString().ToUpper(); m_lbl_tu_ngay.Text = ip_v_dt_tu_ngay.Date.ToShortDateString(); m_lbl_den_ngay.Text = ip_v_dt_den_ngay.Date.ToShortDateString(); m_lbl_tong_bill.Text = CIPConvert.ToStr(ip_v_tong_bill, "#,###"); m_lbl_tong_tien.Text = CIPConvert.ToStr(ip_v_tong_tien, "#,###") + " (VNĐ)"; v_us_tong_hop_CPN.FillDataset_chi_tiet_Bill(v_ds_tong_hop_CPN, ip_v_id_phong_ban, ip_v_id_trang_thai, ip_v_dt_tu_ngay, ip_v_dt_den_ngay); m_fg.Redraw = true; CGridUtils.Dataset2C1Grid(v_ds_tong_hop_CPN, m_fg, m_obj_trans); CGridUtils.MakeSoTT(0, m_fg); decimal v_dc_tong_doanh_thu = 0; //m_v_us.get_tong_doanh_thu(v_dc_tong_doanh_thu); for (int i = 1; i <= v_ds_tong_hop_CPN.V_TONG_HOP_CPN_THEO_PHONG_BAN.Count; i++) { if (m_fg[i, (int)e_col_Number.SO_TIEN] == null) { } else v_dc_tong_doanh_thu += CIPConvert.ToDecimal((m_fg[i, (int)e_col_Number.SO_TIEN])); } if (v_dc_tong_doanh_thu == 0) m_lbl_chua_tinh_vat.Text = "0 VNĐ"; else m_lbl_chua_tinh_vat.Text = CIPConvert.ToStr(v_dc_tong_doanh_thu, "#,###.##") + " VNĐ"; m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Count // chỗ này dùng hàm count tức là để đếm, có thể dùng các hàm khác thay thế , 0 , (int)e_col_Number.NGAY_GUI // chỗ này là tên trường mà mình nhóm , (int)e_col_Number.TRANG_THAI // chỗ này là tên trường mà mình Count , "{0}" ); m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Sum , 0 , (int)e_col_Number.NGAY_GUI , (int)e_col_Number.SO_TIEN , "{0}" ); m_fg.Redraw = true; m_fg.Tree.Show(1); this.ShowDialog(); }