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();
}
