public US_V_TONG_TIEN_BILL_THEO_PHONG_BAN(decimal i_dbID)
{
pm_objDS = new DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
public US_V_TONG_TIEN_BILL_THEO_PHONG_BAN()
{
pm_objDS = new DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDatasetSearch(DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN ip_v_ds, DateTime ip_v_dt_tu_ngay, DateTime ip_v_dt_den_ngay, decimal ip_v_id_trang_thai, string ip_v_id_tu_khoa, decimal ip_v_id_phap_nhan)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_TONG_HOP_BILL_THEO_PHONG_BAN_PN");
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_v_dt_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_v_dt_den_ngay);
v_stored_proc.addDecimalInputParam("@ID_TRANG_THAI", ip_v_id_trang_thai);
v_stored_proc.addDecimalInputParam("@ID_PHAP_NHAN", ip_v_id_phap_nhan);
v_stored_proc.addNVarcharInputParam("@TU_KHOA", ip_v_id_tu_khoa);
v_stored_proc.fillDataSetByCommand(this, ip_v_ds);
}
public void FillDataset_chi_phi_theo_phong_ban(DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN ip_v_ds_tong_hop, decimal ip_v_id_phap_nhan, decimal ip_v_id_trang_thai, DateTime ip_v_dt_tu_ngay, DateTime ip_v_dt_den_ngay)
{
CStoredProc v_stored_proc = new CStoredProc("V_CHI_TIET_CHI_PHI_THEO_PHONG_BAN_VA_PHAP_NHAN");
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_v_dt_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_v_dt_den_ngay);
v_stored_proc.addDecimalInputParam("@ID_TRANG_THAI", ip_v_id_trang_thai);
v_stored_proc.addDecimalInputParam("@ID_PHAP_NHAN", ip_v_id_phap_nhan);
v_stored_proc.fillDataSetByCommand(this, ip_v_ds_tong_hop);
}
public void FillDatasetSearch(DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN ip_v_ds, DateTime ip_v_dt_tu_ngay, DateTime ip_v_dt_den_ngay, decimal ip_v_id_trang_thai)
{
CStoredProc v_stored_proc = new CStoredProc("pr_CHI_PHI_THEO_PHAP_NHAN");
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_v_dt_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_v_dt_den_ngay);
v_stored_proc.addDecimalInputParam("@ID_TRANG_THAI", ip_v_id_trang_thai);
v_stored_proc.fillDataSetByCommand(this, ip_v_ds);
}
private void tim_kiem()
{
string v_id_tu_khoa = m_txt_tim_kiem.Text;
decimal v_id_trang_thai = CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue);
decimal v_id_phap_nhan = CIPConvert.ToDecimal(m_cbo_phap_nhan.SelectedValue);
m_dat_chon_thang = CIPConvert.ToDatetime("01/"+m_dt_chon_thang.Text);
DateTime v_dt_tu_ngay = m_dat_chon_thang;
DateTime v_dt_den_ngay = m_dat_chon_thang.AddMonths(1).AddDays(-m_dat_chon_thang.Day);
US_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_us = new US_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_ds = new DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
v_us.FillDatasetSearch(v_ds, v_dt_tu_ngay, v_dt_den_ngay, v_id_trang_thai, v_id_tu_khoa, v_id_phap_nhan);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(v_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
for (int i = m_fg.Rows.Fixed; i < m_fg.Rows.Count; i++)
{
string v_ma_phong = m_fg.Rows[i][2/*col ma phong*/].ToString().ToUpper();
if (v_ma_phong.Contains("TAW"))
{
m_fg.Rows[i][8/*col uu tien*/] = "2";
}
else if (v_ma_phong.Contains("TDT"))
{
m_fg.Rows[i][8/*col uu tien*/] = "1";
}
else if (v_ma_phong.Contains("TNE"))
{
m_fg.Rows[i][8/*col uu tien*/] = "1";
}
else if (v_ma_phong.Contains("TTN"))
{
m_fg.Rows[i][8/*col uu tien*/] = "1";
}
else if (v_ma_phong.Contains("THR"))
{
m_fg.Rows[i][8/*col uu tien*/] = "3";
}
else if (v_ma_phong.Contains("TMH"))
{
m_fg.Rows[i][8/*col uu tien*/] = "1";
}
else if (v_ma_phong.Contains("TOS"))
{
m_fg.Rows[i][8/*col uu tien*/] = "1";
}
else if (v_ma_phong.Contains("TIS"))
{
m_fg.Rows[i][8/*col uu tien*/] = "3";
}
else if (v_ma_phong.Contains("TRD"))
{
m_fg.Rows[i][8/*col uu tien*/] = "3";
}
else if (v_ma_phong.Contains("TAD"))
{
m_fg.Rows[i][8/*col uu tien*/] = "3";
}
else if (v_ma_phong.Contains("TFP"))
{
m_fg.Rows[i][8/*col uu tien*/] = "3";
}
else if (v_ma_phong.Contains("TLI"))
{
m_fg.Rows[i][8/*col uu tien*/] = "3";
}
else if (v_ma_phong.Contains("TAL"))
{
m_fg.Rows[i][8/*col uu tien*/] = "3";
}
else if (v_ma_phong.Contains("TTV"))
{
m_fg.Rows[i][8/*col uu tien*/] = "4";
}
else if (v_ma_phong.Contains("TSA"))
{
m_fg.Rows[i][8/*col uu tien*/] = "4";
}
else if (v_ma_phong.Contains("TSG"))
{
m_fg.Rows[i][8/*col uu tien*/] = "4";
}
else if (v_ma_phong.Contains("TBI"))
{
m_fg.Rows[i][8/*col uu tien*/] = "2";
}
else if (v_ma_phong.Contains("TSM"))
{
m_fg.Rows[i][8/*col uu tien*/] = "4";
}
else if (v_ma_phong.Contains("TIC"))
{
m_fg.Rows[i][8/*col uu tien*/] = "2";
}
else if (v_ma_phong.Contains("TAE"))
{
m_fg.Rows[i][8/*col uu tien*/] = "4";
}
else if (v_ma_phong.Contains("TPE"))
{
m_fg.Rows[i][8/*col uu tien*/] = "5";
}
else if (v_ma_phong.Contains("TEG"))
{
m_fg.Rows[i][8/*col uu tien*/] = "3";
}
else if (v_ma_phong.Contains("MOL"))
{
m_fg.Rows[i][8/*col uu tien*/] = "2";
}
else
{
m_fg.Rows[i][8/*col uu tien*/] = "5";
}
}
//m_fg.Sort(new SortFlags(), 8);
//m_fg.ShowSortAt(new SortFlags(), 8);
m_fg.Redraw = true;
}
private void load_data_2_grid()
{
m_ds = new DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
m_us.FillDataset(m_ds);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
CGridUtils.MakeSoTT(0, m_fg);
m_fg.Redraw = true;
}
private void tim_kiem()
{
string v_id_tu_khoa = m_txt_tim_kiem.Text;
decimal v_id_trang_thai = CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue);
DateTime v_dt_tu_ngay = m_dt_tu_ngay;
DateTime v_dt_den_ngay = m_dt_den_ngay;
US_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_us = new US_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_ds = new DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
v_us.FillDatasetSearch(v_ds, v_dt_tu_ngay, v_dt_den_ngay, v_id_trang_thai, v_id_tu_khoa);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(v_ds, m_fg, m_obj_trans);
CGridUtils.MakeSoTT(0, m_fg);
m_fg.Redraw = true;
}
public void Display_for_chi_tiet(decimal v_id_phap_nhan, decimal v_id_trang_thai, DateTime v_dt_tu_ngay, DateTime v_dt_den_ngay, decimal v_tong_bill, decimal v_tong_chi_phi)
{
m_obj_trans = get_trans_object(m_fg);
format_controls();
m_dt_tu_ngay = v_dt_tu_ngay;
m_dt_den_ngay = v_dt_den_ngay;
m_id_trang_thai = v_id_trang_thai;
load_txt_cbo_trang_thai();
BCTKUS.US_CM_DM_TU_DIEN v_us_td = new BCTKUS.US_CM_DM_TU_DIEN();
BCTKDS.DS_CM_DM_TU_DIEN v_ds_td = new BCTKDS.DS_CM_DM_TU_DIEN();
US_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_us_tong_hop = new US_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_ds_tong_hop = new DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
v_us_td.FillDataset(v_ds_td, "where ID =" + v_id_phap_nhan);
m_lbl_phap_nhan.Text ="PN: " + v_ds_td.Tables[0].Rows[0][4].ToString().ToUpper();
m_lbl_tu_ngay.Text = v_dt_tu_ngay.Date.ToShortDateString();
m_lbl_den_ngay.Text = v_dt_den_ngay.Date.ToShortDateString();
m_lbl_tong_bill.Text = CIPConvert.ToStr(v_tong_bill, "#,###");
m_lbl_tong_chi_phi.Text = CIPConvert.ToStr(v_tong_chi_phi, "#,###") + " (VNĐ)";
v_us_tong_hop.FillDataset_chi_phi_theo_phong_ban(v_ds_tong_hop, v_id_phap_nhan, v_id_trang_thai, v_dt_tu_ngay, v_dt_den_ngay);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(v_ds_tong_hop, m_fg, m_obj_trans);
CGridUtils.MakeSoTT(0, m_fg);
m_fg.Redraw = true;
this.ShowDialog();
}
