public void display(decimal ip_dc_id_van_ban)
{
m_dc_id_gd_van_ban = ip_dc_id_van_ban;
US_V_GD_VAN_THU_ALL v_us = new US_V_GD_VAN_THU_ALL(ip_dc_id_van_ban);
US_CM_DM_TU_DIEN v_us_loai_van_ban = new US_CM_DM_TU_DIEN(v_us.dcID_LOAI_CONG_VAN);
m_lbl_loai_van_ban.Text = v_us_loai_van_ban.strTEN;
m_lbl_so_va_ky_hieu.Text = v_us.strSO_CV_DEN + " " + v_us.strSO_VA_KY_HIEU;
m_lbl_ten_loai_va_trich_yeu_noi_dung.Text = v_us.strTEN_LOAI_VA_TRICH_YEU_ND;
//Hien thi thong tin danh sach da ban hanh cua van ban nay
US_GD_BAN_HANH_VAN_BAN v_us_ban_hanh = new US_GD_BAN_HANH_VAN_BAN();
DS_GD_BAN_HANH_VAN_BAN v_ds_ban_hanh = new DS_GD_BAN_HANH_VAN_BAN();
v_us_ban_hanh.FillDataset(v_ds_ban_hanh, "where " + GD_BAN_HANH_VAN_BAN.ID_VAN_BAN + " = " + ip_dc_id_van_ban);
string v_str_danh_sach_email_da_ban_hanh = "";
string v_str_danh_sach_email_da_xac_nhan = "";
decimal v_dc_so_email_ban_hanh = 0;
decimal v_dc_so_email_da_nhan_mail = 0;
for (int i = 0; i < v_ds_ban_hanh.GD_BAN_HANH_VAN_BAN.Count; i++)
{
v_str_danh_sach_email_da_ban_hanh += v_ds_ban_hanh.Tables[0].Rows[i][GD_BAN_HANH_VAN_BAN.GHI_CHU];//GHi chu luu du lieu email
v_dc_so_email_ban_hanh++;
if (!v_ds_ban_hanh.Tables[0].Rows[i][GD_BAN_HANH_VAN_BAN.NGAY_NHAN].ToString().Equals(""))
{
v_str_danh_sach_email_da_xac_nhan += v_ds_ban_hanh.Tables[0].Rows[i][GD_BAN_HANH_VAN_BAN.GHI_CHU];
v_dc_so_email_da_nhan_mail++;
}
}
v_str_danh_sach_email_da_ban_hanh = v_dc_so_email_ban_hanh + " email";
v_str_danh_sach_email_da_xac_nhan = v_dc_so_email_da_nhan_mail + " email";
m_lbl_danh_sach_mail_da_ban_hanh.Text = v_str_danh_sach_email_da_ban_hanh;
m_lbl_danh_sach_mail_da_xac_nhan.Text = v_str_danh_sach_email_da_xac_nhan;
this.ShowDialog();
}
private void us_object2grid(US_V_GD_VAN_THU_ALL 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 grid2us_object(US_V_GD_VAN_THU_ALL 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_gd_van_thu_all()
{
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_GD_VAN_THU_ALL v_us = new US_V_GD_VAN_THU_ALL();
US_GD_VAN_THU v_us_gd_van_thu = new US_GD_VAN_THU();
grid2us_object(v_us, m_fg.Row);
try
{
v_us_gd_van_thu = new US_GD_VAN_THU(v_us.dcID);
v_us_gd_van_thu.BeginTransaction();
v_us_gd_van_thu.Delete();
v_us_gd_van_thu.CommitTransaction();
m_fg.Rows.Remove(m_fg.Row);
}
catch (Exception v_e)
{
v_us_gd_van_thu.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
}
}
private void load_data_2_grid()
{
if (m_cbo_trang_thai.SelectedValue == null) return;
m_ds = new DS_V_GD_VAN_THU_ALL();
decimal v_dc_id_loai_cong_van = -1;
if (m_rdb_van_ban_di_ben_ngoai.Checked) v_dc_id_loai_cong_van = ID_LOAI_VAN_THU.CONG_VAN_DI_BEN_NGOAI;
else if (m_rdb_van_ban_den.Checked) v_dc_id_loai_cong_van = ID_LOAI_VAN_THU.CONG_VAN_DEN;
else if (m_rdb_van_ban_di_noi_bo.Checked) v_dc_id_loai_cong_van = ID_LOAI_VAN_THU.CONG_VAN_DI_NOI_BO;
string v_str_from_date = (m_txt_tu_ngay.Text.Replace("/", "").Trim() == string.Empty) ? "01/01/1900" : m_txt_tu_ngay.Text;
string v_str_to_date = (m_txt_den_ngay.Text.Replace("/", "").Trim() == string.Empty) ? "30/12/2999" : m_txt_den_ngay.Text;
m_us.Search(m_ds, CIPConvert.ToDecimal(m_cbo_phap_nhan.SelectedValue), v_dc_id_loai_cong_van, CIPConvert.ToDatetime(v_str_from_date, "dd/MM/yyyy"), CIPConvert.ToDatetime(v_str_to_date, "dd/MM/yyyy"), m_txt_tu_khoa.Text.Trim(),CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue));
//if (m_rdb_van_ban_di_noi_bo.Checked == true) v_dc_id_loai_cong_van = ID_LOAI_VAN_THU.CONG_VAN_DI;
//else if (m_rdb_van_ban_den.Checked == true) v_dc_id_loai_cong_van = ID_LOAI_VAN_THU.CONG_VAN_DEN;
//DateTime v_dat_tu_ngay = DateTime.Now;
//DateTime v_dat_den_ngay = DateTime.Now;
//if (m_txt_tu_ngay.getValue() == null) v_dat_tu_ngay = new DateTime(1800, 1, 1);
//else v_dat_tu_ngay = CIPConvert.ToDatetime(m_txt_tu_ngay.Text, "dd/MM/yyyy");
//if (m_txt_den_ngay.getValue() != null) v_dat_den_ngay = CIPConvert.ToDatetime(m_txt_den_ngay.Text, "dd/MM/yyyy");
//m_us.Search(m_ds, CIPConvert.ToDecimal(m_cbo_phap_nhan.SelectedValue)
// , v_dc_id_loai_cong_van
// , v_dat_tu_ngay
// , v_dat_den_ngay
// , m_txt_tu_khoa.Text.Trim()
// , CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue));
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
CGridUtils.MakeSoTT(0, m_fg);
m_fg.Redraw = true;
format_grid();
if (m_fg.Row < 0) return;
for (int i = m_fg.Row; i < m_fg.Rows.Count; i++)
{
US_V_GD_VAN_THU_ALL v_us = new US_V_GD_VAN_THU_ALL();
grid2us_object(v_us, i);
if (m_fg.Rows[i][(int)e_col_Number.FILE_SCAN] != null)
m_fg.Rows[i][(int)e_col_Number.FILE_SCAN] = m_fg.Rows[i][(int)e_col_Number.FILE_SCAN].ToString().Replace("210.245.89.37/FileUpload_Vanthu/", "");
if (v_us.strDANH_SACH_EMAIL_BAN_HANH == "") m_fg.Rows[i][(int)e_col_Number.SO_MAIL_DA_BAN_HANH] = "0";
else
m_fg.Rows[i][(int)e_col_Number.SO_MAIL_DA_BAN_HANH] = v_us.strDANH_SACH_EMAIL_BAN_HANH.Split(';').Length;
if (v_us.strDANH_SACH_EMAIL_XAC_NHAN == "") m_fg.Rows[i][(int)e_col_Number.SO_MAIL_DA_XAC_NHAN] = "0";
else
m_fg.Rows[i][(int)e_col_Number.SO_MAIL_DA_XAC_NHAN] = v_us.strDANH_SACH_EMAIL_XAC_NHAN.Split(';').Length;
}
}
void m_cmd_xem_file_Click(object sender, EventArgs e)
{
try
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return;
grid2us_object(m_us, m_fg.Row);
if (m_us.dcID_VAN_BAN == 0) return;
US_V_GD_VAN_THU_ALL v_us = new US_V_GD_VAN_THU_ALL(m_us.dcID_VAN_BAN);
HelpUtils.openPDFFile(v_us.strLINK_SCAN);
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void view_file_pdf()
{
if (m_dc_id_gd_van_ban == 0) return;
US_V_GD_VAN_THU_ALL v_us = new US_V_GD_VAN_THU_ALL(m_dc_id_gd_van_ban);
HelpUtils.openPDFFile(v_us.strLINK_SCAN);
}
