private void change_state_all(decimal ip_id_trang_thai_cu, decimal ip_id_trang_thai_moi, C1.Win.C1FlexGrid.C1FlexGrid i_fg_left, C1.Win.C1FlexGrid.C1FlexGrid i_fg_right, string ip_str_message) { if (!CGridUtils.IsThere_Any_NonFixed_Row(i_fg_left)) return; for (int i = 1; i < i_fg_left.Rows.Count; i++) { if (!CGridUtils.IsThere_Any_NonFixed_Row(i_fg_left)) return; if (!CGridUtils.isValid_NonFixed_RowIndex(i_fg_left, i_fg_left.Row)) return; m_obj_trans = get_trans_object(i_fg_left); m_us = new US_V_DM_BILL(); grid_2us_object(m_us, i,i_fg_left); //chuyen tu trang thai 1-Da nhan noi bo -> 2-Da chuyen cho CPN change_state_of_bill(m_us.dcID, ip_id_trang_thai_moi); } load_data_2_grid(ip_id_trang_thai_cu, i_fg_left); load_data_2_grid(ip_id_trang_thai_moi, i_fg_right); BaseMessages.MsgBox_Infor(ip_str_message); }
private void save_data() { //set_color_ma_bill_da_ton_tai(); //Các bước: //B1. Kiểm tra dữ liệu trên grid, nếu sai thì không làm gì hết if(!check_validate_grid_is_ok()) return; //B2. Nếu đúng rồi thì lưu thôi // Insert vào dm bill, cột số tiền để null DS_V_DM_BILL v_ds_v_dm_bill = new DS_V_DM_BILL(); US_V_DM_BILL v_us_v_dm_bill = new US_V_DM_BILL(); Int64 v_dem_bill = 0; for(int v_i_cur_row = m_fg.Rows.Fixed; v_i_cur_row < m_fg.Rows.Count - 1; v_i_cur_row++) { //Check xem tồn tại số bill trong CSDL chưa? Nếu có rồi tô màu đỏ if(is_exist_bill_in_db(CIPConvert.ToStr(m_fg.Rows[v_i_cur_row][(int)e_col_Number.SO_BILL]))) { BaseMessages.MsgBox_Error("Đã tồn tại số bill " + CIPConvert.ToStr(m_fg.Rows[v_i_cur_row][(int)e_col_Number.SO_BILL]) + "này trong phần mềm!"); set_color_ma_bill_da_ton_tai(v_i_cur_row); return; } //Đổ dữ liệu từ lưới lên us grid_row_2_us_v_dm_bill(v_i_cur_row, v_us_v_dm_bill); //Insert v_us_v_dm_bill.Insert(); //Xóa hàng nếu insert thành công cho dễ nhìn if(m_fg.Rows.Count > 3) { m_fg.Rows.Remove(v_i_cur_row); v_i_cur_row = v_i_cur_row - 1; } else { m_fg.Rows[v_i_cur_row].Clear(C1.Win.C1FlexGrid.ClearFlags.All); } v_dem_bill++; } BaseMessages.MsgBox_Infor("Đã nhập thành công " + v_dem_bill + " Bill!"); }
private void grid_row_2_us_v_dm_bill(int ip_grid_row, US_V_DM_BILL iop_us_v_dm_bill) { iop_us_v_dm_bill.datNGAY_GUI = CIPConvert.ToDatetime(m_dat_ngay_gui.Text.Trim(), "dd/MM/yyyy"); iop_us_v_dm_bill.strSO_BILL = CIPConvert.ToStr(m_fg[ip_grid_row, (int)e_col_Number.SO_BILL]); iop_us_v_dm_bill.dcID_PHONG_BAN = CIPConvert.ToDecimal(m_fg[ip_grid_row, (int)e_col_Number.MA_PHONG_BAN]); iop_us_v_dm_bill.strNGUOI_GUI = CIPConvert.ToStr(m_fg[ip_grid_row, (int)e_col_Number.NGUOI_GUI]); iop_us_v_dm_bill.strNGUOI_NHAN = CIPConvert.ToStr(m_fg[ip_grid_row, (int)e_col_Number.NGUOI_NHAN]); iop_us_v_dm_bill.strNOI_NHAN = CIPConvert.ToStr(m_fg[ip_grid_row, (int)e_col_Number.NOI_NHAN]); if(m_fg[ip_grid_row, (int)e_col_Number.NOI_DUNG] != null) iop_us_v_dm_bill.strNOI_DUNG = CIPConvert.ToStr(m_fg[ip_grid_row, (int)e_col_Number.NOI_DUNG]); else iop_us_v_dm_bill.SetNOI_DUNGNull(); if(m_fg[ip_grid_row, (int)e_col_Number.GHI_CHU] != null) iop_us_v_dm_bill.strGHI_CHU = CIPConvert.ToStr(m_fg[ip_grid_row, (int)e_col_Number.GHI_CHU]); else iop_us_v_dm_bill.SetGHI_CHUNull(); iop_us_v_dm_bill.dcID_TRANG_THAI = CONST_ID_TRANG_THAI_THU.ID_DA_NHAN_NOI_BO; if(CIPConvert.ToStr(m_fg[ip_grid_row, (int)e_col_Number.LOAI_THU]) == "Trong nước") iop_us_v_dm_bill.strTRONG_NUOC = "x"; else iop_us_v_dm_bill.strNUOC_NGOAI = "x"; iop_us_v_dm_bill.SetSO_TIENNull(); iop_us_v_dm_bill.SetTRANG_THAI_THUNull(); iop_us_v_dm_bill.SetTEN_PHONG_BANNull(); iop_us_v_dm_bill.SetTEN_PHONG_BANNull(); }
private void load_data_grv_detail(decimal ip_id_trang_thai) { decimal v_id_trung_tam = CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value); US_V_DM_BILL v_us_v_dm_bill = new US_V_DM_BILL(); DS_V_DM_BILL v_ds_v_dm_bill = new DS_V_DM_BILL(); v_ds_v_dm_bill.Clear(); if (ip_id_trang_thai == CONST_ID_TRANG_THAI_THU.ID_DA_NHAN_NOI_BO || ip_id_trang_thai == CONST_ID_TRANG_THAI_THU.ID_DA_CHUYEN_CPN) { v_us_v_dm_bill.FillDataset(v_ds_v_dm_bill, v_id_trung_tam, CIPConvert.ToDatetime(m_txt_tu_ngay.Text), CIPConvert.ToDatetime(m_txt_den_ngay.Text), ip_id_trang_thai, "", m_txt_nguoi_gui_tk.Text.Trim()); } if (ip_id_trang_thai == CONST_ID_TRANG_THAI_THU.ID_BI_TRA_LAI_MAT_PHI) { v_us_v_dm_bill.Fill_DS_BAO_CAO_TONG_HOP_BILL_BI_TRA_LAI_MAT_PHI_WEB_DETAIL(v_ds_v_dm_bill, v_id_trung_tam, CIPConvert.ToDatetime(m_txt_tu_ngay.Text), CIPConvert.ToDatetime(m_txt_den_ngay.Text), m_txt_nguoi_gui_tk.Text.Trim()); } if (ip_id_trang_thai == CONST_ID_TRANG_THAI_THU.ID_BI_TRA_LAI_KHONG_MAT_PHI) { v_us_v_dm_bill.Fill_DS_BAO_CAO_TONG_HOP_BILL_BI_TRA_LAI_KHONG_MAT_PHI_WEB_DETAIL(v_ds_v_dm_bill, v_id_trung_tam, CIPConvert.ToDatetime(m_txt_tu_ngay.Text), CIPConvert.ToDatetime(m_txt_den_ngay.Text), m_txt_nguoi_gui_tk.Text.Trim()); } m_grv_detail.DataSource = v_ds_v_dm_bill.V_DM_BILL; string v_str_thong_tin = "Danh sách Có " + v_ds_v_dm_bill.V_DM_BILL.Rows.Count + " Bill"; m_lbl_grv_detail.Text = v_str_thong_tin; m_grv_detail.DataBind(); if (!m_hdf_id_bill.Value.Equals("")) { m_grv_detail.SelectedIndex = -1; for (int i = 0; i < m_grv_detail.Rows.Count; i++) if (CIPConvert.ToDecimal(m_grv_detail.DataKeys[i].Value) == CIPConvert.ToDecimal(m_hdf_id_bill.Value)) m_grv_detail.SelectedIndex = i; } if (v_ds_v_dm_bill.V_DM_BILL.Count == 0) thong_bao("Không tìm thấy Bill!", true); }
private void us_object2grid(US_V_DM_BILL i_us , int i_grid_row,C1.Win.C1FlexGrid.C1FlexGrid i_fg) { DataRow v_dr = (DataRow)i_fg.Rows[i_grid_row].UserData; i_us.Me2DataRow(v_dr); m_obj_trans = get_trans_object(i_fg); m_obj_trans.DataRow2GridRow(v_dr, i_grid_row); }
m_txt_so_bill.ForeColor = Color.Black; } private void set_search_so_bill_format_before() { if (m_txt_so_bill.Text == "") {
private void grid_2us_object(US_V_DM_BILL i_us , int i_grid_row,C1.Win.C1FlexGrid.C1FlexGrid i_fg) { DataRow v_dr; v_dr = (DataRow)i_fg.Rows[i_grid_row].UserData; m_obj_trans = get_trans_object(i_fg); m_obj_trans.GridRow2DataRow(i_grid_row, v_dr); i_us.DataRow2Me(v_dr); }
this.KeyPreview = true; } private ITransferDataRow get_trans_object(C1.Win.C1FlexGrid.C1FlexGrid i_fg) { Hashtable v_htb = new Hashtable(); v_htb.Add(V_DM_BILL.NUOC_NGOAI, e_col_Number.NUOC_NGOAI); v_htb.Add(V_DM_BILL.TEN_PHONG_BAN, e_col_Number.TEN_PHONG_BAN);
{ if( disposing ) { if(components != null) { components.Dispose(); } } base.Dispose( disposing ); } private void delete_v_dm_bill() { if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_trang_thai)) return; if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_trang_thai, m_grv_trang_thai.Row)) return; if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return; US_V_DM_BILL v_us = new US_V_DM_BILL(); grid2us_object(v_us, m_grv_trang_thai.Row); try { v_us.BeginTransaction();
private void load_data_to_grid() { decimal v_id_trung_tam = CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value); decimal v_dc_id_trang_thai = CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue); string v_str_tu_khoa = m_txt_tim_kiem.Text.Trim(); US_V_DM_BILL v_us_v_dm_bill = new US_V_DM_BILL(); DS_V_DM_BILL v_ds_v_dm_bill = new DS_V_DM_BILL(); v_ds_v_dm_bill.Clear(); v_us_v_dm_bill.FillDataset(v_ds_v_dm_bill, v_id_trung_tam, CIPConvert.ToDatetime(m_txt_tu_ngay.Text), CIPConvert.ToDatetime(m_txt_den_ngay.Text), v_dc_id_trang_thai, v_str_tu_khoa); m_grv_v_dm_bill.DataSource = v_ds_v_dm_bill.V_DM_BILL; string v_str_thong_tin = " (Có " + v_ds_v_dm_bill.V_DM_BILL.Rows.Count + " bản ghi)"; m_lbl_thong_tim_grv_dm_bill.Text = v_str_thong_tin; m_grv_v_dm_bill.DataBind(); if (!m_hdf_id_bill.Value.Equals("")) { m_grv_v_dm_bill.SelectedIndex = -1; for (int i = 0; i < m_grv_v_dm_bill.Rows.Count; i++) if (CIPConvert.ToDecimal(m_grv_v_dm_bill.DataKeys[i].Value) == CIPConvert.ToDecimal(m_hdf_id_bill.Value)) m_grv_v_dm_bill.SelectedIndex = i; } if (v_ds_v_dm_bill.V_DM_BILL.Count == 0) thong_bao("Không tìm thấy Bill!",true); }
public void display_for_update(US_V_DM_BILL ip_us_v) { m_e_form_mode = DataEntryFormMode.UpdateDataState; us_obj_2_form(ip_us_v); this.ShowDialog(); }
private void us_obj_2_form(US_V_DM_BILL ip_us) { m_us.dcID = ip_us.dcID; m_txt_so_bill.Text = ip_us.strSO_BILL ; m_txt_noi_dung.Text = ip_us.strNOI_DUNG; m_txt_nguoi_nhan.Text = ip_us.strNGUOI_NHAN ; m_txt_nguoi_gui.Text = ip_us.strNGUOI_GUI ; m_txt_ghi_chu.Text = ip_us.strGHI_CHU ; m_txt_noi_nhan.Text = ip_us.strNOI_NHAN ; if (ip_us.strNUOC_NGOAI=="x")m_chk_nuoc_ngoai.Checked=true ; if (ip_us.strTRONG_NUOC == "x") m_chk_trong_nuoc.Checked = true; m_cbo_trang_thai.SelectedValue = ip_us.dcID_TRANG_THAI; m_cbo_trung_tam.SelectedValue = ip_us.dcID_PHONG_BAN; m_txt_so_tien.Text = ip_us.dcSO_TIEN.ToString(); m_dtp_ngay_gui.Text = ip_us.datNGAY_GUI.Date.ToString(); }