public static void load_data_to_ddl_ten_du_an( DateTime ip_dat_tu_ngay , DateTime ip_dat_den_ngay , decimal ip_dc_id_don_Vi , decimal ip_dc_id_du_an_cong_trinh , decimal ip_dc_id_loai_nhiem_vu , DropDownList op_ddl) { US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(); DS_DM_CONG_TRINH_DU_AN_GOI_THAU v_ds = new DS_DM_CONG_TRINH_DU_AN_GOI_THAU(); CStoredProc v_sp = new IP.Core.IPUserService.CStoredProc("pr_get_ds_du_an_from_giao_von"); v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay); v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay); v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_Vi); v_sp.addDecimalInputParam("@ip_dc_id_loai_nhiem_vu", ip_dc_id_loai_nhiem_vu); v_sp.addDecimalInputParam("@ip_dc_id_du_an_cong_trinh", ip_dc_id_du_an_cong_trinh); v_sp.fillDataSetByCommand(v_us, v_ds); op_ddl.DataTextField = DM_CONG_TRINH_DU_AN_GOI_THAU.TEN; op_ddl.DataValueField = DM_CONG_TRINH_DU_AN_GOI_THAU.ID; op_ddl.DataSource = v_ds.DM_CONG_TRINH_DU_AN_GOI_THAU; op_ddl.DataBind(); }
public static void load_data_to_cbo_du_an_cong_trinh_from_giao_von2(decimal ip_dc_id_loai_du_an, decimal ip_dc_id_cha , DropDownList op_ddl_quyet_dinh) { DS_DM_CONG_TRINH_DU_AN_GOI_THAU v_ds = new DS_DM_CONG_TRINH_DU_AN_GOI_THAU(); US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(); decimal v_dc_id_don_vi = Person.get_id_don_vi(); string v_str_data_default = "---Chọn dự án---"; v_ds.EnforceConstraints = false; if (ip_dc_id_loai_du_an != -1) { v_str_data_default = "---Chọn dự án---"; v_us.FillDataset(v_ds, " WHERE ID_LOAI = " + ip_dc_id_loai_du_an + " AND ID_CHA = " + ip_dc_id_cha + " order by " + DM_CONG_TRINH_DU_AN_GOI_THAU.TEN); } //else { // v_str_data_default = "---Chọn dự án---"; // v_us.FillDataset(v_ds, " WHERE ID_CHA = " + ip_dc_id_cha); //} op_ddl_quyet_dinh.DataTextField = DM_CONG_TRINH_DU_AN_GOI_THAU.TEN; op_ddl_quyet_dinh.DataValueField = DM_CONG_TRINH_DU_AN_GOI_THAU.ID; op_ddl_quyet_dinh.DataSource = v_ds.DM_CONG_TRINH_DU_AN_GOI_THAU; op_ddl_quyet_dinh.DataBind(); op_ddl_quyet_dinh.Items.Insert(0, new ListItem(v_str_data_default, "-1")); }
public static void load_data_to_cbo_du_an_theo_cong_trinh_va_loai_nhiem_vu(decimal ip_id_cong_trinh, decimal ip_id_loai_nhiem_vu, DropDownList ddl, decimal ip_dc_id_don_vi) { DS_DM_CONG_TRINH_DU_AN_GOI_THAU v_ds = new DS_DM_CONG_TRINH_DU_AN_GOI_THAU(); US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(); string v_str_data_default = "---Chọn dự án---"; v_ds.EnforceConstraints = false; v_ds.Clear(); v_us.loadDanhMucDuanTheoCongTrinhVaLoaiNhiemVu(v_ds, ip_dc_id_don_vi, ip_id_cong_trinh, ip_id_loai_nhiem_vu); ddl.DataTextField = DM_CONG_TRINH_DU_AN_GOI_THAU.TEN; ddl.DataValueField = DM_CONG_TRINH_DU_AN_GOI_THAU.ID; ddl.DataSource = v_ds.DM_CONG_TRINH_DU_AN_GOI_THAU; ddl.DataBind(); ddl.Items.Insert(0, new ListItem(v_str_data_default, "-1")); }
public static void load_data_to_cbo_du_an_cong_trinh_from_giao_von(LOAI_DU_AN ip_dc_id_loai_du_an , DropDownList op_ddl_quyet_dinh) { DS_DM_CONG_TRINH_DU_AN_GOI_THAU v_ds = new DS_DM_CONG_TRINH_DU_AN_GOI_THAU(); US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(); decimal v_dc_id_don_vi = Person.get_id_don_vi(); string v_str_data_default = ""; v_ds.EnforceConstraints = false; op_ddl_quyet_dinh.DataTextField = DM_CONG_TRINH_DU_AN_GOI_THAU.TEN; op_ddl_quyet_dinh.DataValueField = DM_CONG_TRINH_DU_AN_GOI_THAU.ID; op_ddl_quyet_dinh.DataSource = v_ds.DM_CONG_TRINH_DU_AN_GOI_THAU; op_ddl_quyet_dinh.DataBind(); op_ddl_quyet_dinh.Items.Insert(0, new ListItem(v_str_data_default, "-1")); }
public static void load_data_to_cbo_cong_trinh_du_an( decimal ip_dc_id_don_vi , decimal ip_id_cong_trinh , decimal ip_dc_id_loai_nhiem_vu , eTAT_CA ip_e_tat_ca , DropDownList ip_obj_cbo_cong_trinh_du_an_goi_thau) { US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_dm_cong_trinh_du_an_goi_thau = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(); DS_DM_CONG_TRINH_DU_AN_GOI_THAU v_ds_dm_cong_trinh_du_an_goi_thau = new DS_DM_CONG_TRINH_DU_AN_GOI_THAU(); string v_str_user_name = HttpContext.Current.Session[SESSION.UserName].ToString(); v_us_dm_cong_trinh_du_an_goi_thau.loadDanhMucDuanTheoCongTrinhVaLoaiNhiemVu( v_ds_dm_cong_trinh_du_an_goi_thau , ip_dc_id_don_vi , ip_id_cong_trinh , ip_dc_id_loai_nhiem_vu); DataView v_dv_quyet_dinh = v_ds_dm_cong_trinh_du_an_goi_thau.DM_CONG_TRINH_DU_AN_GOI_THAU.DefaultView; v_dv_quyet_dinh.Sort = DM_CONG_TRINH_DU_AN_GOI_THAU.TEN + " ASC"; ip_obj_cbo_cong_trinh_du_an_goi_thau.DataSource = v_dv_quyet_dinh.ToTable(); ip_obj_cbo_cong_trinh_du_an_goi_thau.DataTextField = DM_CONG_TRINH_DU_AN_GOI_THAU.TEN; ip_obj_cbo_cong_trinh_du_an_goi_thau.DataValueField = DM_CONG_TRINH_DU_AN_GOI_THAU.ID; ip_obj_cbo_cong_trinh_du_an_goi_thau.DataBind(); if (ip_e_tat_ca == eTAT_CA.YES) { ip_obj_cbo_cong_trinh_du_an_goi_thau.Items.Insert(0, new ListItem(CONST_GIAO_DICH.STR_VALUE_TAT_CA, CONST_GIAO_DICH.ID_TAT_CA.ToString())); } }
private decimal insert_du_an(decimal ip_dc_id_cong_trinh) { decimal v_dc_id_du_an = -1; //Kiem tra xem nguoi dung dang Chon du an hay dang nhap du an if (m_ddl_du_an.Visible == true) { //kiem tra xem du an da chon co cha la cong trinh khong //neu khong phai, ta phai them 1 du an moi US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_du_an = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(CIPConvert.ToDecimal(m_ddl_du_an.SelectedValue)); if (v_us_du_an.dcID_CHA != ip_dc_id_cong_trinh) { v_us_du_an.dcID_CHA = ip_dc_id_cong_trinh; v_us_du_an.Insert(); return v_us_du_an.dcID; } else return CIPConvert.ToDecimal(m_ddl_du_an.SelectedValue); } else //neu nguoi dung dang Nhap 1 du an moi thi ta phai insert 1 du an moi { try { //1. kiểm tra xem đã có dự án trong bảng DM_CONG_TRINH_DU_AN_GOI_THAU chưa US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(); DS_DM_CONG_TRINH_DU_AN_GOI_THAU v_ds = new DS_DM_CONG_TRINH_DU_AN_GOI_THAU(); v_us.FillDataset(v_ds, "where " + DM_CONG_TRINH_DU_AN_GOI_THAU.TEN + "= N'" + m_txt_du_an.Text.Trim() + "'" + "and " + DM_CONG_TRINH_DU_AN_GOI_THAU.ID_LOAI + "=" + ID_LOAI_CONG_TRINH_DU_AN_GOI_THAU.DU_AN + "and " + DM_CONG_TRINH_DU_AN_GOI_THAU.ID_CHA + "=" + ip_dc_id_cong_trinh); //1.1 Nếu có rồi thì không thêm nữa if (v_ds.DM_CONG_TRINH_DU_AN_GOI_THAU.Count > 0) { v_us = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][DM_CONG_TRINH_DU_AN_GOI_THAU.ID])); } else { //1.2 Nếu chưa có thì thêm mới v_us.dcID_DON_VI = Person.get_id_don_vi(); v_us.strTEN = m_txt_du_an.Text.Trim(); v_us.dcID_LOAI = ID_LOAI_CONG_TRINH_DU_AN_GOI_THAU.DU_AN; v_us.dcID_CHA = ip_dc_id_cong_trinh; v_us.Insert(); } v_dc_id_du_an = v_us.dcID; return v_dc_id_du_an; } catch (Exception) { return v_dc_id_du_an; } } }
private decimal insert_cong_trinh() { decimal v_dc_id_cong_trinh = -1; //kiem tra xem nguoi dung dang Chon Cong trinh hay dang nhap //Neu dang chon -> lay ra id cong trinh if (m_ddl_cong_trinh.Visible == true) { return CIPConvert.ToDecimal(m_ddl_cong_trinh.SelectedValue); } else { //Neu dang nhap ->insert 1 cong trinh moi try { //0. khi chi nhap ten quoc lo vd: 1A thì lưu lại thành 'Quốc lộ 1A' if (m_txt_quoc_lo.Text.Trim().Length < 5) { m_txt_quoc_lo.Text = "Quốc lộ " + m_txt_quoc_lo.Text.Trim(); } //1. kiểm tra xem đã có tên quốc lộ trong bản DM_CONG_TRINH_DU_AN_GOI_THAU chưa US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(); DS_DM_CONG_TRINH_DU_AN_GOI_THAU v_ds = new DS_DM_CONG_TRINH_DU_AN_GOI_THAU(); v_us.FillDataset(v_ds, "where " + DM_CONG_TRINH_DU_AN_GOI_THAU.TEN + "= N'" + m_txt_quoc_lo.Text + "'" + "and " + DM_CONG_TRINH_DU_AN_GOI_THAU.ID_LOAI + "=" + ID_LOAI_CONG_TRINH_DU_AN_GOI_THAU.CONG_TRINH); //1.1 Nếu có rồi thì không thêm nữa if (v_ds.DM_CONG_TRINH_DU_AN_GOI_THAU.Count > 0) { v_us = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][DM_CONG_TRINH_DU_AN_GOI_THAU.ID])); } else { //1.2 Nếu chưa có thì thêm mới v_us.dcID_DON_VI = Person.get_id_don_vi(); v_us.strTEN = m_txt_quoc_lo.Text.Trim(); v_us.SetID_CHANull(); v_us.dcID_LOAI = ID_LOAI_CONG_TRINH_DU_AN_GOI_THAU.CONG_TRINH; v_us.Insert(); } v_dc_id_cong_trinh = v_us.dcID; return v_dc_id_cong_trinh; } catch (Exception) { return v_dc_id_cong_trinh; } } }
private void us_object_to_form() { m_us = new US_GD_CHI_TIET_GIAO_KH(CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value)); if (!m_us.IsTU_CHU_YNNull()) { if (m_us.strTU_CHU_YN == "Y") { m_rdb_chi_thuong_xuyen.Checked = true; m_rdb_chi_khong_thuong_xuyen.Checked = false; } else { m_rdb_chi_thuong_xuyen.Checked = false; m_rdb_chi_khong_thuong_xuyen.Checked = true; } } m_txt_so_km.Text = m_us.strGHI_CHU_2; if (Request.QueryString["ip_nguon_ns"] == "N") { m_txt_so_tien.Text = CIPConvert.ToStr(m_us.dcSO_TIEN_QUY_BT); } else { m_txt_so_tien.Text = CIPConvert.ToStr(m_us.dcSO_TIEN_NS); } m_txt_so_tien_nam_truoc_chuyen_sang.Text = CIPConvert.ToStr(m_us.dcSO_TIEN_NAM_TRUOC_CHUYEN_SANG); m_txt_ghi_chu.Text = m_us.strGHI_CHU; //m_txt_ten_quoc_lo.Text = v_us_du_an_cong_trinh.strTEN_DU_AN_CONG_TRINH.Replace("Quốc lộ ",""); if (!m_us.IsID_CONG_TRINHNull()) { m_rdb_theo_quoc_lo.Checked = true; m_rdb_theo_chuong_loai_khoan_muc.Checked = false; m_rdb_theo_quoc_lo_CheckedChanged(null, null); US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_du_an = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(m_us.dcID_DU_AN); US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_cong_trinh = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(v_us_du_an.dcID_CHA); //set cong trinh m_ddl_cong_trinh.SelectedValue = v_us_du_an.dcID_CHA.ToString(); m_ddl_cong_trinh_SelectedIndexChanged(null, null); m_txt_quoc_lo.Text = v_us_cong_trinh.strTEN; m_ddl_cong_trinh.Visible = true; m_txt_quoc_lo.Visible = false; m_cmd_chon_quoc_lo.Visible = false; m_cmd_them_quoc_lo.Visible = true; //set du an m_txt_du_an.Text = v_us_du_an.strTEN; m_txt_du_an.Visible = false; m_ddl_du_an.Visible = true; m_cmd_chon_du_an.Visible = false; m_cmd_them_du_an.Visible = true; m_ddl_du_an.SelectedValue = v_us_du_an.dcID.ToString(); m_rdb_theo_chuong_loai_khoan_muc.Checked = false; m_rdb_theo_quoc_lo.Checked = true; } else { m_rdb_theo_quoc_lo.Checked = false; m_rdb_theo_chuong_loai_khoan_muc.Checked = true; m_rdb_theo_chuong_loai_khoan_muc_CheckedChanged(null, null); m_ddl_chuong.SelectedValue = m_us.dcID_CHUONG.ToString(); US_DM_CHUONG_LOAI_KHOAN_MUC v_us_khoan = new US_DM_CHUONG_LOAI_KHOAN_MUC(m_us.dcID_KHOAN); m_ddl_loai.SelectedValue = v_us_khoan.dcID_CHA.ToString(); m_ddl_loai_SelectedIndexChanged(null, null); m_ddl_khoan.SelectedValue = m_us.dcID_KHOAN.ToString(); m_ddl_muc.SelectedValue = m_us.dcID_MUC.ToString(); m_ddl_muc_SelectedIndexChanged(null, null); if (!m_us.IsID_TIEU_MUCNull()) { m_ddl_tieu_muc.SelectedValue = m_us.dcID_TIEU_MUC.ToString(); } m_rdb_theo_chuong_loai_khoan_muc.Checked = true; m_rdb_theo_quoc_lo.Checked = false; } m_ddl_loai_nhiem_vu.Focus(); m_ddl_loai_nhiem_vu.SelectedValue = m_us.dcID_LOAI_NHIEM_VU.ToString(); load_panel_loai_chi(); m_txt_noi_dung_du_toan.Text = m_us.strGHI_CHU_1; //set quyet dinh US_DM_QUYET_DINH v_us_quyet_dinh = new US_DM_QUYET_DINH(m_us.dcID_QUYET_DINH); m_txt_so_qd.Text = v_us_quyet_dinh.strSO_QUYET_DINH; m_txt_noi_dung.Text = v_us_quyet_dinh.strNOI_DUNG; //m_txt_ngay_thang.Text = CIPConvert.ToStr(v_us_quyet_dinh.datNGAY_THANG, "dd/MM/yyyy"); m_lbl_ngay_thang.Text = CIPConvert.ToStr(v_us_quyet_dinh.datNGAY_THANG, "dd/MM/yyyy"); m_hdf_id_quyet_dinh.Value = v_us_quyet_dinh.dcID.ToString(); disable_edit_quyet_dinh(); }