private void EmployeesBtn_Click(object sender, EventArgs e)
{
Key = 1;
tableLayoutPanel3.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel1.Hide();
SaveBtn.Hide();
JobTitlesbtn.Enabled = true;
DepartmentsBtn.Enabled = true;
OfficesBtn.Enabled = true;
SqldataGridView.Show();
CreateBtn.Show();
CreateBtn.Enabled = true;
UpdateBtn.Show();
UpdateBtn.Enabled = false;
DeleteBtn.Show();
DeleteBtn.Enabled = false;
TurnOnEditBth.Show();
MainPicture.Hide();
string sql = "select p.id_pracownika as ID, p.imie as Imie, p.nazwisko as Nazwisko, s.nazwa as Stanowisko, d.nazwa_dzialu as 'Nazwa działu', si.nazwa_siedziby as Siedziba, si.adres as Adres" +
" from PRACOWNICY p join DZIALY d on p.id_dzialu=d.id_dzialu join STANOWISKA s on p.id_stanowiska=s.id_stanowiska join SIEDZIBY si on d.id_siedziby=si.id_siedziby;";
LoadDataToSqldataGridView("Pracownicy", sql);
EmployeesBtn.Enabled = false;
}
private void SaveBtn_Click(object sender, EventArgs e)
{
try
{
var phoneRegEx = new Regex("^(\\+380|0)([0-9]{9})$");
if (!phoneRegEx.IsMatch(PhoneTB.Text))
{
MessageBox.Show("Невіроно введений номер телефону, номер поивнен бути у форматі +380*********");
return;
}
else
{
_person.Phone = PhoneTB.Text;
}
try
{
MailAddress m = new MailAddress(EmailTB.Text);
_person.Email = EmailTB.Text;
}
catch (FormatException)
{
MessageBox.Show("Перевірте коректність введеного Email");
return;
}
_person.Name = NameTB.Text;
_person.Surname = SurnameTB.Text;
_person.Address = AddressTB.Text;
try
{
_person.Birthday = DateTime.Parse(BirthdayTB.Text);
}
catch (Exception)
{
MessageBox.Show("Перевірте правильність введеня дати");
return;
}
dbContext.Entry(_person).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
catch (Exception) {
MessageBox.Show("Сталася помилка при збереженні");
} finally
{
NameTB.ReadOnly = true;
SurnameTB.ReadOnly = true;
AddressTB.ReadOnly = true;
BirthdayTB.ReadOnly = true;
PhoneTB.ReadOnly = true;
EmailTB.ReadOnly = true;
SaveBtn.Hide();
EditBtn.Show();
MessageBox.Show("Дані успішно збережені");
}
}
public Form1()
{
InitializeComponent();
SqldataGridView.Hide();
tableLayoutPanel1.Hide();
CreateBtn.Hide();
UpdateBtn.Hide();
UpdateBtn.Enabled = false;
DeleteBtn.Hide();
DeleteBtn.Enabled = false;
TurnOnEditBth.Hide();
TurnOffEditBth.Hide();
SaveBtn.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel3.Hide();
SqldataGridView.ReadOnly = false;
}
private void DepartmentsBtn_Click(object sender, EventArgs e)
{
Key = 4;
tableLayoutPanel3.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel1.Hide();
SaveBtn.Hide();
EmployeesBtn.Enabled = true;
JobTitlesbtn.Enabled = true;
OfficesBtn.Enabled = true;
SqldataGridView.Show();
CreateBtn.Show();
UpdateBtn.Show();
DeleteBtn.Show();
CreateBtn.Enabled = true;
UpdateBtn.Enabled = false;
DeleteBtn.Enabled = false;
TurnOnEditBth.Show();
MainPicture.Hide();
string sql = "select d.nazwa_dzialu, s.nazwa_siedziby, s.adres from DZIALY d join SIEDZIBY s on d.id_siedziby=s.id_siedziby ";
LoadDataToSqldataGridView("Dzialy", sql);
DepartmentsBtn.Enabled = false;
}
private void OfficesBtn_Click(object sender, EventArgs e)
{
Key = 3;
tableLayoutPanel3.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel1.Hide();
SaveBtn.Hide();
EmployeesBtn.Enabled = true;
JobTitlesbtn.Enabled = true;
DepartmentsBtn.Enabled = true;
SqldataGridView.Show();
CreateBtn.Show();
UpdateBtn.Show();
DeleteBtn.Show();
CreateBtn.Enabled = true;
UpdateBtn.Enabled = false;
DeleteBtn.Enabled = false;
TurnOnEditBth.Show();
MainPicture.Hide();
string sql = "select id_siedziby as ID ,nazwa_siedziby as Oddział, adres as Adres from SIEDZIBY ";
LoadDataToSqldataGridView("Siedziby", sql);
OfficesBtn.Enabled = false;
}
private void JobTitlesbtn_Click(object sender, EventArgs e)
{
Key = 2;
tableLayoutPanel3.Hide();
tableLayoutPanel2.Hide();
tableLayoutPanel1.Hide();
SaveBtn.Hide();
EmployeesBtn.Enabled = true;
OfficesBtn.Enabled = true;
DepartmentsBtn.Enabled = true;
SqldataGridView.Show();
CreateBtn.Show();
UpdateBtn.Show();
DeleteBtn.Show();
CreateBtn.Enabled = true;
UpdateBtn.Enabled = false;
DeleteBtn.Enabled = false;
TurnOnEditBth.Show();
MainPicture.Hide();
string sql = "select id_stanowiska, nazwa as Stanowisko from STANOWISKA ";
LoadDataToSqldataGridView("Stanowiska", sql);
JobTitlesbtn.Enabled = false;
}
public void ShowCmdWindow(string cmd, int LscId, string LscName, string LscIP, int LscPort, string LscUID, string LscPwd, int BeatInterval, int BeatDelay, string DBServer, int DBPort, string DBName, string DBUID, string DBPwd, string HisDBServer, int HisDBPort, string HisDBName, string HisDBUID, string HisDBPwd, bool Enabled)
{
switch (cmd)
{
case "Edit":
LSCWindow.Icon = Icon.ChartOrganisation;
LSCWindow.Title = "编辑信息";
LSCIDField.Disabled = true;
LSCStatusBar.ClearStatus();
SaveBtn.Hide();
EditBtn.Show();
LSCIDField.Number = LscId;
LSCNameField.Text = LscName;
LSCIPField.Text = LscIP;
LSCPortField.Number = LscPort;
LSCUIDField.Text = LscUID;
LSCPwdField.Text = LscPwd;
BeatIntervalField.Number = BeatInterval;
BeatDelayField.Number = BeatDelay;
DBIPField.Text = DBServer;
DBPortField.Number = DBPort;
DBNameField.Text = DBName;
DBUIDField.Text = DBUID;
DBPwdField.Text = DBPwd;
HisDBIPField.Text = HisDBServer;
HisDBPortField.Number = HisDBPort;
HisDBNameField.Text = HisDBName;
HisDBUIDField.Text = HisDBUID;
HisDBPwdField.Text = HisDBPwd;
EnabledCheckbox.Checked = Enabled;
LSCWindow.Show();
break;
case "Del":
X.Msg.Confirm("确认对话框", "本操作将删除与Lsc有关的所有数据！您确定要删除吗？", new MessageBoxButtonsConfig {
Yes = new MessageBoxButtonConfig {
Handler = String.Format(@"
X.LSCManager.DelLsc({0},{{
success: function(result) {{
LSCPagingToolbar.doRefresh();
}},
eventMask: {{
showMask: true,
target: 'customtarget',
msg: '正在删除中...',
customTarget: LSCPanel.body.up('div')
}}}});", LscId),
Text = "确定"
},
No = new MessageBoxButtonConfig {
Text = "取消"
}
}).Show();
break;
case "Add":
LSCWindow.Icon = Icon.ChartOrganisationAdd;
LSCWindow.Title = "新增信息";
EnabledCheckbox.Checked = false;
LSCIDField.Disabled = false;
LSCStatusBar.ClearStatus();
SaveBtn.Show();
EditBtn.Hide();
LSCIDField.Clear();
LSCNameField.Clear();
LSCIPField.Clear();
LSCPortField.Number = LscPort;
LSCUIDField.Clear();
LSCPwdField.Clear();
BeatIntervalField.Number = BeatInterval;
BeatDelayField.Number = BeatDelay;
DBIPField.Clear();
DBPortField.Number = DBPort;
DBNameField.Clear();
DBUIDField.Clear();
DBPwdField.Clear();
HisDBIPField.Clear();
HisDBPortField.Number = HisDBPort;
HisDBNameField.Clear();
HisDBUIDField.Clear();
HisDBPwdField.Clear();
EnabledCheckbox.Checked = Enabled;
LSCWindow.Show();
break;
case "Sync":
SyncWindow.Icon = Icon.DatabaseRefresh;
SyncWindow.Title = String.Format("数据同步[{0}]", LscName);
STRadio.Checked = true;
SyncWindowHF.Text = LscId.ToString();
SyncWindow.Show();
break;
default:
break;
}
}