public RegForm() { InitializeComponent(); ComboBox_Reg_Login.AutoCompleteMode = AutoCompleteMode.SuggestAppend; ComboBox_Reg_Login.AutoCompleteSource = AutoCompleteSource.ListItems; Class_SQL.OpenConnection(); this.ComboBox_Reg_Login.Focus(); Class_SQL.LoadComboBox(this.ComboBox_Reg_Login, "select user_name as 'ID', description as 'NAME' from bi.dbo.ABS_USER_PROFILE where active= 'Y' and DOSTUP_ABS = N'Y' order by description asc"); }
private void Form_Library_Add_Load(object sender, EventArgs e) { this.Text = TextForm + FormType; txt_name.Text = Names; txt_uroven2.Text = Uroven2; txt_uroven3.Text = Uroven3; cb_active.Checked = Act; Class_SQL.LoadComboBox(cbm_en, "select KEY_ID as ID ,NAME from bi.dbo.ABS_EN where ACTIVE ='Y' order by NAME"); if (TypeNme == "lib_en") { txt_uroven2.Visible = false; lab_uroven2.Visible = false; cbm_en.Visible = false; lab_en.Visible = false; } else if (TypeNme == "dop_uslugi") { txt_uroven3.Visible = true; lab_uroven3.Visible = true; } else if (TypeNme == "dop_meterial") { txt_uroven3.Visible = false; lab_uroven3.Visible = false; } else if (TypeNme == "dop_operation") { txt_uroven3.Visible = false; lab_uroven3.Visible = false; } if (Type == "NEW") { cbm_en.SelectedIndex = -1; } else { if (TypeNme != "lib_en") { //cbm_en.SelectedValue = EN; } } }
private void Form_Service_Add_Load(object sender, EventArgs e) { Ordernumber = "00000000" + Convert.ToString(Class_SQL.SelectNextNumber()); Ordernumber = "SER-" + RightString(Ordernumber, 9); ComboBox_Add_Service_Order_Type.Items.Clear(); ComboBox_Add_Service_Order_Type.Items.Add("Сервисная заявка"); ComboBox_Add_Service_Order_Type.SelectedItem = "Сервисная заявка"; ComboBox_Add_Service_Order_Type.Enabled = false; TextBox_Add_Service_Number.Text = Ordernumber; DateTimePicker_Add_Service_Date.Value = DateTime.Now; DateTimePicker_Add_Service_Time.Text = "00:00:00"; Class_SQL.LoadComboBox(ComboBox_Add_Service_Company, "select COMPANY as 'ID', DESCRIPTION as 'NAME' from bi.dbo.ABS_COMPANY where ACTIVE='Y' and COMPANY in (" + Class_SQL.StringActivCompany(FirstForm.UserName) + ")"); ComboBox_Add_Service_Company.SelectedIndex = -1; Class_SQL.LoadComboBox(ComboBox_Add_Service_Warehouse, "select WAREHOUSE as 'ID', DESCRIPTION as 'NAME' from bi.dbo.ABS_WAREHOUSE where ACTIVE='Y' and WAREHOUSE in (" + Class_SQL.StringActivWarehouse(FirstForm.UserName) + ")"); ComboBox_Add_Service_Warehouse.SelectedIndex = -1; }