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;
}
