private void load_data_2_cbo() { DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN(); US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN(); v_us_cm_dm_tu_dien.FillDataset(v_ds_cm_dm_tu_dien, "where id_loai_tu_dien = "+ CONST_ID_CM_DM_LOAI_TD.ID_LOAI_DINH_MUC); m_cbo_loai_dinh_muc.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN; m_cbo_loai_dinh_muc.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN; m_cbo_loai_dinh_muc.ValueMember = CM_DM_TU_DIEN.ID; }
private void get_so_ky_hieu() { var v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN(); var v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_dm_tu_dien.FillDataset(v_ds_cm_dm_tu_dien, "where MA_TU_DIEN = '" + _loaiCongVan + "' and TEN = '" + getYear() + "'"); var v_int_cv_count = 1; if (v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.Rows.Count > 0) { var v_dr = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.Rows[0]; int.TryParse(v_dr[CM_DM_TU_DIEN.TEN_NGAN].ToString(), out v_int_cv_count); } else if(!string.IsNullOrEmpty(_loaiCongVan)) { //v_us_cm_dm_tu_dien.strMA_TU_DIEN = _loaiCongVan; //v_us_cm_dm_tu_dien.dcID_LOAI_TU_DIEN = 26; //v_us_cm_dm_tu_dien.strTEN_NGAN = "01"; //v_us_cm_dm_tu_dien.strTEN = this.Text; //v_us_cm_dm_tu_dien.Insert(); } this.Text = string.Format("{0:00}", v_int_cv_count) + "/" + getYear(); }
private void load_cbo_trang_thai() { m_trang_thai = false; BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN(); BCTKDS.DS_CM_DM_TU_DIEN v_ds = new BCTKDS.DS_CM_DM_TU_DIEN(); v_us.FillDataset(v_ds, "where id_loai_tu_dien = " + 12); m_cbo_trang_thai.DataSource = v_ds.CM_DM_TU_DIEN; m_cbo_trang_thai.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN; DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow(); v_dr[CM_DM_TU_DIEN.ID] = -1; v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 12; v_dr[CM_DM_TU_DIEN.TEN] = "Tất cả"; v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "Tất cả"; v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "TRANG_THAI_THU"; v_dr[CM_DM_TU_DIEN.GHI_CHU] = " "; v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_trang_thai.SelectedIndex = 0; m_trang_thai = 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 load_thong_tin_so_va_ky_hieu_van_ban() { 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) { 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(); m_txt_so_cv_den.Text = v_str_so + "/" + v_str_nam; } }
private void load_data_trang_thai() { try { US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_dm_tu_dien.FillDataset(v_ds_cm_dm_tu_dien, "where ma_tu_dien in ('CHO_SO_VAO_SO_DONG_DAU','DA_LUU','DA_CHUYEN_DEN_NGUOI_NHAN','NGUOI_NHAN_DA_NHAN_DUOC') order by ten_ngan"); m_cbx_trang_thai.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN; m_cbx_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbx_trang_thai.ValueMember = CM_DM_TU_DIEN.ID; } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } }
private void load_cbo_loai_de_xuat() { BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN(); BCTKDS.DS_CM_DM_TU_DIEN v_ds = new BCTKDS.DS_CM_DM_TU_DIEN(); v_us.FillDataset(v_ds, "where id_loai_tu_dien =" + 17); m_cbo_loai_de_xuat.DataSource = v_ds.CM_DM_TU_DIEN; m_cbo_loai_de_xuat.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_loai_de_xuat.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN; DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow(); v_dr[CM_DM_TU_DIEN.ID] = -1; v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 17; v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = ""; v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "----------------------------Tất cả-----------------------------"; v_dr[CM_DM_TU_DIEN.TEN] = ""; v_dr[CM_DM_TU_DIEN.GHI_CHU] = ""; v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_trung_tam.SelectedIndex = 0; }
private void load_cbo_loai_de_xuat() { 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 id_loai_tu_dien ="+17); m_cbo_loai_de_xuat.DataSource = v_ds.CM_DM_TU_DIEN; m_cbo_loai_de_xuat.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_loai_de_xuat.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN; }
private void load_data_2_cbo() { US_CM_DM_TU_DIEN v_us_td = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_td = new DS_CM_DM_TU_DIEN(); v_us_td.FillDataset(v_ds_td," where id_loai_tu_dien= 16 "); m_cbo_loai_co_so.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_loai_co_so.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_loai_co_so.DataSource = v_ds_td.CM_DM_TU_DIEN; }
private void load_data_to_cbo_trang_thai() { BCTKUS.US_CM_DM_TU_DIEN v_us_trang_thai_van_thu = new BCTKUS.US_CM_DM_TU_DIEN(); BCTKDS.DS_CM_DM_TU_DIEN v_ds_trang_thai_van_thu = new BCTKDS.DS_CM_DM_TU_DIEN(); v_us_trang_thai_van_thu.FillDataset(v_ds_trang_thai_van_thu, "where id_loai_tu_dien=22"); //id loai tu dien trang thai van thu DataRow v_dr = v_ds_trang_thai_van_thu.CM_DM_TU_DIEN.NewRow(); v_dr[CM_DM_TU_DIEN.ID] = -1; v_dr[CM_DM_TU_DIEN.GHI_CHU] = ""; v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 22; v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "TatCa"; v_dr[CM_DM_TU_DIEN.TEN] = "0 - Tất cả"; v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "0 - Tất cả"; v_ds_trang_thai_van_thu.Tables[0].Rows.InsertAt(v_dr, 0); v_ds_trang_thai_van_thu.AcceptChanges(); m_cbo_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN; m_cbo_trang_thai.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_trang_thai.DataSource = v_ds_trang_thai_van_thu.CM_DM_TU_DIEN; }
private void load_cbo_loai_dinh_muc() { BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN(); BCTKDS.DS_CM_DM_TU_DIEN v_ds = new BCTKDS.DS_CM_DM_TU_DIEN(); v_us.FillDataset(v_ds, "where id_loai_tu_dien =" + 17); m_cbo_loai_dm.DataSource = v_ds.CM_DM_TU_DIEN; m_cbo_loai_dm.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_loai_dm.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN; //DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow(); //v_dr[CM_DM_TU_DIEN.ID] = -1; //v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 17; //v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = " "; //v_dr[CM_DM_TU_DIEN.TEN] = "Tất cả"; //v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "Tất cả"; //v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); //m_cbo_loai_dm.SelectedIndex = 0; flag_loai_dm = true; }
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(884, 562); this.Controls.Add(this.m_pnl_top); this.Controls.Add(this.m_grv_trang_thai); this.Controls.Add(this.m_pnl_out_place_dm); this.Name = "f511_TRA_CUU_TRANG_THAI_CPN"; this.Text = "F511-Tra cứu trạng thái CPN"; this.Load += new System.EventHandler(this.f511_TRA_CUU_TRANG_THAI_CPN_Load); this.m_pnl_out_place_dm.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.m_grv_trang_thai)).EndInit(); this.m_pnl_top.ResumeLayout(false); this.m_pnl_top.PerformLayout(); this.ResumeLayout(false); } private void insert_v_dm_bill() { // f511_TRA_CUU_TRANG_THAI_CPN_DE v_fDE = new f511_TRA_CUU_TRANG_THAI_CPN_DE(); // v_fDE.display();
private void load_cbo_trang_thai() { BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN(); v_us.FillDataset(v_ds, "where ID_LOAI_TU_DIEN=" + 12); m_cbo_trang_thai.DataSource = v_ds.CM_DM_TU_DIEN; m_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.ID; m_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN; DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow(); v_dr[CM_DM_TU_DIEN.ID] = -1; v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 12; v_dr[CM_DM_TU_DIEN.TEN] = "-----Tất cả-----"; v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "-----Tất cả-----"; v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "TRANG_THAI_THU"; v_dr[CM_DM_TU_DIEN.GHI_CHU] = " "; v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_trang_thai.SelectedIndex = 0; m_cbo_trang_thai.DataBind(); }
private void load_txt_cbo_trang_thai() { BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN(); BCTKDS.DS_CM_DM_TU_DIEN v_ds = new BCTKDS.DS_CM_DM_TU_DIEN(); if (m_id_trang_thai != -1) { v_us.FillDataset(v_ds, "where id = " + m_id_trang_thai); m_cbo_trang_thai.Text = v_ds.Tables[0].Rows[0][4].ToString(); } else { m_cbo_trang_thai.Text = "Tất cả"; } }
public void Display_for_chi_tiet(decimal v_id_phap_nhan, decimal v_id_trang_thai, DateTime v_dt_tu_ngay, DateTime v_dt_den_ngay, decimal v_tong_bill, decimal v_tong_chi_phi) { m_obj_trans = get_trans_object(m_fg); format_controls(); m_dt_tu_ngay = v_dt_tu_ngay; m_dt_den_ngay = v_dt_den_ngay; m_id_trang_thai = v_id_trang_thai; load_txt_cbo_trang_thai(); BCTKUS.US_CM_DM_TU_DIEN v_us_td = new BCTKUS.US_CM_DM_TU_DIEN(); BCTKDS.DS_CM_DM_TU_DIEN v_ds_td = new BCTKDS.DS_CM_DM_TU_DIEN(); US_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_us_tong_hop = new US_V_TONG_TIEN_BILL_THEO_PHONG_BAN(); DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_ds_tong_hop = new DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN(); v_us_td.FillDataset(v_ds_td, "where ID =" + v_id_phap_nhan); m_lbl_phap_nhan.Text ="PN: " + v_ds_td.Tables[0].Rows[0][4].ToString().ToUpper(); m_lbl_tu_ngay.Text = v_dt_tu_ngay.Date.ToShortDateString(); m_lbl_den_ngay.Text = v_dt_den_ngay.Date.ToShortDateString(); m_lbl_tong_bill.Text = CIPConvert.ToStr(v_tong_bill, "#,###"); m_lbl_tong_chi_phi.Text = CIPConvert.ToStr(v_tong_chi_phi, "#,###") + " (VNĐ)"; v_us_tong_hop.FillDataset_chi_phi_theo_phong_ban(v_ds_tong_hop, v_id_phap_nhan, v_id_trang_thai, v_dt_tu_ngay, v_dt_den_ngay); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(v_ds_tong_hop, m_fg, m_obj_trans); CGridUtils.MakeSoTT(0, m_fg); m_fg.Redraw = true; this.ShowDialog(); }
private void load_data_2_cbo_trang_thai() { 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 id_loai_tu_dien = 12"); m_cbo_trang_thai.DataSource = v_ds.CM_DM_TU_DIEN; m_cbo_trang_thai.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN; }