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