public US_V_GD_VAN_THU_ALL(decimal i_dbID) { pm_objDS = new DS_V_GD_VAN_THU_ALL(); pm_strTableName = c_TableName; IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName); v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang); SqlCommand v_cmdSQL; v_cmdSQL = v_objMkCmd.getSelectCmd(); this.FillDatasetByCommand(pm_objDS, v_cmdSQL); pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]); }
private void load_data_2_grid() { m_ds = new DS_V_GD_VAN_THU_ALL(); decimal v_dc_id_loai_cong_van = -1; //if (m_rdb_van_ban_di_khong_luu.Checked == true) v_dc_id_loai_cong_van = ID_LOAI_VAN_THU.CONG_VAN_DI_KHONG_LUU; //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; 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_ben_ngoai.Checked) v_dc_id_loai_cong_van = ID_LOAI_VAN_THU.CONG_VAN_DI_BEN_NGOAI; 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()); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); //Neu khong co du lieu thi return if (m_fg.Rows.Count < 0) return; for (int i = m_fg.Rows.Fixed; i < m_fg.Rows.Count; 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/", ""); } m_fg.Redraw = true; format_grid(); }
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; } }
public void Search(DS_V_GD_VAN_THU_ALL op_ds, decimal ip_dc_id_phap_nhan , decimal ip_dc_id_loai_cong_van, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay , string ip_str_tu_khoa , decimal ip_dc_id_trang_thai) { CStoredProc v_sp = new CStoredProc("pr_v_gd_van_thu_all_search_with_trang_thai"); v_sp.addDecimalInputParam("@ip_dc_id_trang_thai", ip_dc_id_trang_thai); v_sp.addDecimalInputParam("@ip_dc_id_phap_nhan", ip_dc_id_phap_nhan); v_sp.addDecimalInputParam("@ip_dc_id_loai_cong_van", ip_dc_id_loai_cong_van); v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay); v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay); v_sp.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa); v_sp.fillDataSetByCommand(this, op_ds); }
public US_V_GD_VAN_THU_ALL() { pm_objDS = new DS_V_GD_VAN_THU_ALL(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }