private bool check_100_phan_tram_phap_nhan(decimal ip_id_phong_ban, decimal ip_id_phap_nhan) { DS_DM_PHONG_BAN_PHAP_NHAN v_ds = new DS_DM_PHONG_BAN_PHAP_NHAN(); US_DM_PHONG_BAN_PHAP_NHAN v_us = new US_DM_PHONG_BAN_PHAP_NHAN(); v_us.FillDataset(v_ds, "where ID_PHONG_BAN = " + ip_id_phong_ban); switch(m_e) { case DataEntryFormMode.InsertDataState: decimal tong_phan_tram_insert = CIPConvert.ToDecimal(m_txt_ty_trong.Text); foreach(DataRow v_dr in v_ds.DM_PHONG_BAN_PHAP_NHAN.Rows) { tong_phan_tram_insert = tong_phan_tram_insert + CIPConvert.ToDecimal(v_dr["TY_TRONG"].ToString()); } if(tong_phan_tram_insert > 100) { return false; } break; case DataEntryFormMode.UpdateDataState: decimal tong_phan_tram_update = 0; foreach(DataRow v_dr in v_ds.DM_PHONG_BAN_PHAP_NHAN.Rows) { if(CIPConvert.ToDecimal(v_dr["ID_PHAP_NHAN"].ToString()) == ip_id_phap_nhan) v_dr["TY_TRONG"] = m_txt_ty_trong.Text; tong_phan_tram_update = tong_phan_tram_update + CIPConvert.ToDecimal(v_dr["TY_TRONG"].ToString()); } if(tong_phan_tram_update > 100) { return false; } break; } return true; }
public US_DM_PHONG_BAN_PHAP_NHAN(decimal i_dbID) { pm_objDS = new DS_DM_PHONG_BAN_PHAP_NHAN(); 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 bool insert_data() { try { string v_str_file_name = m_txt_file_upload.Text.Split('\\')[m_txt_file_upload.Text.Split('\\').Length - 1]; string v_str_save_file = ConfigurationSettings.AppSettings["DOMAIN"] + "/" + "FileUpload_Vanthu" + "/" + v_str_file_name.Replace(ConfigurationSettings.AppSettings["DOMAIN"] + "/" + "FileUpload_Vanthu" + "/",""); if (!m_txt_file_upload.Text.Trim().Equals("") && !m_txt_file_upload.Text.Contains(ConfigurationSettings.AppSettings["DOMAIN"])) { if (!HelpUtils.ftpTransfer(m_txt_file_upload.Text.Replace(v_str_file_name, ""), v_str_file_name)) return false; } US_GD_VAN_THU v_us_gd_van_thu = new US_GD_VAN_THU(); if (m_dc_id_van_thu != 0) v_us_gd_van_thu = new US_GD_VAN_THU(m_dc_id_van_thu); if (m_tcd_ngay_tren_cv.getValue() == null) v_us_gd_van_thu.SetNGAY_THANG_TREN_CONG_VANNull(); else v_us_gd_van_thu.datNGAY_THANG_TREN_CONG_VAN = CIPConvert.ToDatetime(m_tcd_ngay_tren_cv.Text, "dd/MM/yyyy"); if (m_tcd_ngay_nhap.getValue() == null) v_us_gd_van_thu.SetNGAY_LAPNull(); else v_us_gd_van_thu.datNGAY_LAP = CIPConvert.ToDatetime(m_tcd_ngay_nhap.Text, "dd/MM/yyyy"); v_us_gd_van_thu.strSO_VA_KY_HIEU = m_txt_so_va_ky_hieu.Text.Trim(); v_us_gd_van_thu.strTEN_LOAI_VA_TRICH_YEU_ND = m_txt_ten_loai.Text.Trim(); US_DM_PHONG_BAN_PHAP_NHAN v_us_dm_phong_ban = new US_DM_PHONG_BAN_PHAP_NHAN(); DS_DM_PHONG_BAN_PHAP_NHAN v_ds_dm_phong_ban = new DS_DM_PHONG_BAN_PHAP_NHAN(); if (m_cbx_ban_luu.SelectedValue != null) { v_us_dm_phong_ban.FillDataset(v_ds_dm_phong_ban, " where id_phong_ban = " + m_cbx_ban_luu.SelectedValue); v_us_gd_van_thu.dcID_NGUOI_NHAN_BAN_LUU = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue); v_us_gd_van_thu.dcID_NOI_NGUOI_NHAN = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue); } else { v_us_gd_van_thu.SetID_NGUOI_NHAN_BAN_LUUNull(); v_us_gd_van_thu.SetID_NOI_NGUOI_NHANNull(); } if (v_ds_dm_phong_ban.Tables[0].Rows.Count > 0) v_us_gd_van_thu.dcID_PHAP_NHAN = CIPConvert.ToDecimal(v_ds_dm_phong_ban.Tables[0].Rows[0][DM_PHONG_BAN_PHAP_NHAN.ID_PHAP_NHAN]); else v_us_gd_van_thu.SetID_PHAP_NHANNull(); v_us_gd_van_thu.strGHI_CHU = m_txt_ghi_chu.Text.Trim(); v_us_gd_van_thu.dcID_TRANG_THAI = CIPConvert.ToDecimal(m_cbx_trang_thai.SelectedValue); v_us_gd_van_thu.strNGUOI_LAP = m_txt_nguoi_nhap.Text.Trim(); if (!m_txt_file_upload.Text.Trim().Equals(string.Empty)) v_us_gd_van_thu.strLINK_SCAN = v_str_save_file; else v_us_gd_van_thu.strLINK_SCAN = string.Empty; v_us_gd_van_thu.strSO_CV_DEN = m_txt_so_cv_den.Text.Trim(); v_us_gd_van_thu.strNOI_GUI = m_txt_noi_gui.Text.Trim(); v_us_gd_van_thu.dcID_LOAI_CONG_VAN = ID_LOAI_VAN_THU.CONG_VAN_DEN; v_us_gd_van_thu.strNOI_NHAN = m_cbx_ban_luu.Text.Trim(); if (v_us_dm_phong_ban.dcID == -1) { v_us_gd_van_thu.Insert(); US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN(); v_us.FillDataset(v_ds, "where ma_tu_dien='CV_DEN'"); if (v_ds.CM_DM_TU_DIEN.Count > 0) { v_us.DataRow2Me(v_ds.Tables[0].Rows[0]); string v_str_so = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN_NGAN].ToString(); string v_str_nam = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN].ToString(); v_str_so = CIPConvert.ToStr(CIPConvert.ToDecimal(v_str_so) + 1, "0#"); m_txt_so_cv_den.Text = v_str_so + "/" + v_str_nam; v_us.strTEN = v_str_nam; v_us.strTEN_NGAN = v_str_so; v_us.Update(); } } else { v_us_dm_phong_ban.Update(); } return true; } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); return false; } }
public US_DM_PHONG_BAN_PHAP_NHAN() { pm_objDS = new DS_DM_PHONG_BAN_PHAP_NHAN(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
public void timTyTrongTrungTam(DS_DM_PHONG_BAN_PHAP_NHAN op_ds, decimal ip_id_phap_nhan, decimal ip_id_trung_tam) { CStoredProc v_proc = new CStoredProc("pr_tim_ty_trong_phap_nhan"); v_proc.addNVarcharInputParam("@ID_TRUNG_TAM", ip_id_trung_tam); v_proc.addNVarcharInputParam("@ID_PHAP_NHAN", ip_id_phap_nhan); v_proc.fillDataSetByCommand(this, op_ds); }