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