private void btn_modify_Click(object sender, RoutedEventArgs e)
{
txb_modify.Text = txb_modify.Text.Replace(" ", "");
if (!(txb_modify.Text == "") && !(selectDataStar == null) && !(selectDataStar.Name == txb_modify.Text))
{
selectDataEnd = selectDataStar;
if (txb_modify.Text[txb_modify.Text.Length - 1].ToString() == "组")
{
txb_modify.Text = txb_modify.Text.Replace(" ", "").TrimEnd('组');
}
string strSQL = " update [member] set [name] = '" + txb_modify.Text + "' where [ID] = " + selectDataEnd.ID + " ";
DatabaseOperate.databaseOperate(strSQL);
this.cmb_whichgroup.ItemsSource = App.GroupComboBoxData;
this.my_treeview.ItemsSource = App.outputTreeView;
}
if (!(selectIndexEnd == -1))
{
cmb_whichgroup.SelectedIndex = selectIndexEnd;
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
my_time.Elapsed += new System.Timers.ElapsedEventHandler(Timer_TimesUp);
my_time.AutoReset = false;
my_prompt.Visibility = Visibility.Collapsed;
DatabaseOperate.bindTreeViewData();
DatabaseOperate.UpdateConfig();
string datapath = App.pathDesktop + @"\考勤记录";
if (!(Directory.Exists(datapath)))
{
Directory.CreateDirectory(datapath);
}
string starTime = DateTime.Now.ToString(DateTime.Now.ToString("dddd", new System.Globalization.CultureInfo("zh-cn")) + " " + DateTime.Now.ToString("yyyy.MM.dd"));
ShowListViewData timeListViewItem = new ShowListViewData("启动时间：", DateTime.Now.ToString("HH:mm:ss"), starTime);
App.ListViewData.Add(timeListViewItem);
ShowListViewData splitLines = new ShowListViewData("——————————", "——————————", "——————————————————————————");
App.ListViewData.Add(splitLines);
page_Register_Loaded();
}
private void btn_addmember_Click(object sender, RoutedEventArgs e)
{
txb_addmember.Text = txb_addmember.Text.Replace(" ", "");
if (txb_addmember.Text == "" || cmb_whichgroup.SelectedItem == null)
{
return;
}
selectIndexEnd = selectIndexStar;
string strSQL = "insert into [member](parentID,name) values('" + whichGroup.Id + "', '" + txb_addmember.Text + "')";
DatabaseOperate.databaseOperate(strSQL);
btn_addmember.Content = "添加成功 !";
my_time.Start();
this.cmb_whichgroup.ItemsSource = App.GroupComboBoxData;
this.my_treeview.ItemsSource = App.outputTreeView;
if (!(selectIndexEnd == -1))
{
cmb_whichgroup.SelectedIndex = selectIndexEnd;
}
}
private void btn_addgroup_Click(object sender, RoutedEventArgs e)
{
txb_addgroup.Text = txb_addgroup.Text.Replace(" ", "");
if (txb_addgroup.Text == "")
{
return;
}
if (txb_addgroup.Text[txb_addgroup.Text.Length - 1].ToString() == "组")
{
txb_addgroup.Text = txb_addgroup.Text.Replace(" ", "").TrimEnd('组');
}
string strSQL = "insert into [member](parentID,name) values('-1', '" + txb_addgroup.Text + "')";
DatabaseOperate.databaseOperate(strSQL);
this.cmb_whichgroup.ItemsSource = App.GroupComboBoxData;
this.my_treeview.ItemsSource = App.outputTreeView;
if (!(selectIndexEnd == -1))
{
cmb_whichgroup.SelectedIndex = selectIndexEnd;
}
}
private void btn_confirmModifyPassword_Click(object sender, RoutedEventArgs e)
{
if (txbl_newPassword.Password == "" || txbl_confirmPassword.Password == "")
{
return;
}
if (!(txbl_newPassword.Password == txbl_confirmPassword.Password))
{
txbl_newPassword.Password = "";
txbl_confirmPassword.Password = "";
btn_confirmModifyPassword.Content = "输入不一致 ！";
my_time.Start();
}
else
{
string strSQL = " update [configuration] set [password] = '" + txbl_confirmPassword.Password + "'";
DatabaseOperate.databaseOperate(strSQL);
DatabaseOperate.UpdateConfig();
btn_confirmModifyPassword.Content = "修改成功 ！";
my_time.Start();
}
}
private void cmb_group_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cmb_group.SelectedItem == null)
{
return;
}
var ComboBox = (ComboBox)sender;
var item = (ShowComboBoxData)ComboBox.SelectedItem;
DatabaseOperate.bingMemberComboBoxData(item.Id);
cmb_name.ItemsSource = App.MemberComboBoxData;
}
private void btn_delete_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (!(selectDataStar == null))
{
selectDataEnd = selectDataStar;
if (selectDataEnd.ParentID == -1)
{
string _strSQL = " delete from [member] where [parentID] = " + selectDataEnd.ID + " ";
DatabaseOperate.databaseOperate(_strSQL);
}
string strSQL = " delete from [member] where [ID] = " + selectDataEnd.ID + " ";
DatabaseOperate.databaseOperate(strSQL);
this.cmb_whichgroup.ItemsSource = App.GroupComboBoxData;
this.my_treeview.ItemsSource = App.outputTreeView;
}
if (!(selectIndexEnd == -1))
{
cmb_whichgroup.SelectedIndex = selectIndexEnd;
}
}
private void btn_confirmModifyWorkTime_Click(object sender, RoutedEventArgs e)
{
if (txb_amWorkTimeA.Text == "" ||
txb_amWorkTimeB.Text == "" ||
txb_amWorkTimeC.Text == "" ||
txb_amWorkTimeD.Text == "" ||
txb_pmWorkTimeA.Text == "" ||
txb_pmWorkTimeB.Text == "" ||
txb_pmWorkTimeC.Text == "" ||
txb_pmWorkTimeD.Text == "" ||
txb_evenWorkTimeA.Text == "" ||
txb_evenWorkTimeB.Text == "" ||
txb_evenWorkTimeC.Text == "" ||
txb_evenWorkTimeD.Text == "")
{
btn_confirmModifyWorkTime.Content = "输入不能为空 ！";
my_time.Start();
return;
}
else
{
string[] WorkTime = new string[9];
string[] WorkTimeTable = new string[] { "amWorkTime", "amWorkTimeStart", "amWorkTimeEnd", "pmWorkTime", "pmWorkTimeStart", "pmWorkTimeEnd", "evenWorkTime", "evenWorkTimeStart", "evenWorkTimeEnd" };
if (Convert.ToInt16(txb_amWorkTimeB.Text) >= 30)
{
if ((Convert.ToInt16(txb_amWorkTimeB.Text) - 30) < 10)
{
WorkTime[0] = txb_amWorkTimeA.Text + ":" + "0" + (Convert.ToInt16(txb_amWorkTimeB.Text) - 30).ToString();
}
else
{
WorkTime[0] = txb_amWorkTimeA.Text + ":" + (Convert.ToInt16(txb_amWorkTimeB.Text) - 30).ToString();
}
}
else
{
WorkTime[0] = (Convert.ToUInt32(txb_amWorkTimeA.Text) - 1).ToString() + ":" + (Convert.ToInt16(txb_amWorkTimeB.Text) + 30).ToString();
}
WorkTime[1] = txb_amWorkTimeA.Text + ":" + txb_amWorkTimeB.Text;
WorkTime[2] = txb_amWorkTimeC.Text + ":" + txb_amWorkTimeD.Text;
if (Convert.ToInt16(txb_pmWorkTimeB.Text) >= 30)
{
if ((Convert.ToInt16(txb_pmWorkTimeB.Text) - 30) < 10)
{
WorkTime[3] = txb_pmWorkTimeA.Text + ":" + "0" + (Convert.ToInt16(txb_pmWorkTimeB.Text) - 30).ToString();
}
else
{
WorkTime[3] = txb_pmWorkTimeA.Text + ":" + (Convert.ToInt16(txb_pmWorkTimeB.Text) - 30).ToString();
}
}
else
{
WorkTime[3] = (Convert.ToUInt32(txb_pmWorkTimeA.Text) - 1).ToString() + ":" + (Convert.ToInt16(txb_pmWorkTimeB.Text) + 30).ToString();
}
WorkTime[4] = txb_pmWorkTimeA.Text + ":" + txb_pmWorkTimeB.Text;
WorkTime[5] = txb_pmWorkTimeC.Text + ":" + txb_pmWorkTimeD.Text;
if (Convert.ToInt16(txb_evenWorkTimeB.Text) >= 30)
{
if (Convert.ToInt16(txb_evenWorkTimeB.Text) < 40)
{
WorkTime[6] = txb_evenWorkTimeA.Text + ":" + "0" + (Convert.ToInt16(txb_evenWorkTimeB.Text) - 30).ToString();
}
else
{
WorkTime[6] = txb_evenWorkTimeA.Text + ":" + (Convert.ToInt16(txb_evenWorkTimeB.Text) - 30).ToString();
}
}
else
{
WorkTime[6] = (Convert.ToUInt32(txb_evenWorkTimeA.Text) - 1).ToString() + ":" + (Convert.ToInt16(txb_evenWorkTimeB.Text) + 30).ToString();
}
WorkTime[7] = txb_evenWorkTimeA.Text + ":" + txb_evenWorkTimeB.Text;
WorkTime[8] = txb_evenWorkTimeC.Text + ":" + txb_evenWorkTimeD.Text;
for (int i = 0; i < 9; i++)
{
string strSQL = " update [configuration] set [" + WorkTimeTable[i] + "] = '" + WorkTime[i] + "'";
DatabaseOperate.databaseOperate(strSQL);
}
DatabaseOperate.UpdateConfig();
btn_confirmModifyWorkTime.Content = "修改成功 ！";
my_time.Start();
}
}
