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