private void us_object2grid(US_V_TONG_TIEN_BILL_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);
}
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 grid2us_object(US_V_TONG_TIEN_BILL_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_bill_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_TIEN_BILL_THEO_PHONG_BAN v_us = new US_V_TONG_TIEN_BILL_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 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();
}
