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; }
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; } }
private void dm_grid2us_object(US_DM_PHONG_BAN_PHAP_NHAN i_us , int i_grid_row) { DataRow v_dr; v_dr = (DataRow)m_grv_ty_trong.Rows[i_grid_row].UserData; m_obj_trans.GridRow2DataRow(i_grid_row, v_dr); i_us.DataRow2Me(v_dr); }
private void insert_grid_2_bd(decimal ip_phong_ban) { for (int i = 1; i < m_grv_ty_trong.Rows.Count; i++) { if (m_grv_ty_trong.Rows[i][(int)e_col_Number.TEN_PHAP_NHAN] == null) break; US_DM_PHONG_BAN_PHAP_NHAN v_us_pb_phap_nhan = new US_DM_PHONG_BAN_PHAP_NHAN(); v_us_pb_phap_nhan.UseTransOfUSObject(m_us_dm_phong_ban); v_us_pb_phap_nhan.dcID_PHAP_NHAN = CIPConvert.ToDecimal(m_grv_ty_trong.Rows[i][(int)e_col_Number.TEN_PHAP_NHAN]); v_us_pb_phap_nhan.dcID_PHONG_BAN = ip_phong_ban; v_us_pb_phap_nhan.dcTY_TRONG = CIPConvert.ToDecimal(m_grv_ty_trong.Rows[i][(int)e_col_Number.TY_TRONG]); v_us_pb_phap_nhan.Insert(); } }