//public void BalanceLeaves(LvApplication lvappl) //{ // _empQuota.Clear(); // using (var context = new TAS2013Entities()) // { // _empQuota = context.LvQuotas.Where(aa => aa.EmpID == lvappl.EmpID).ToList(); // float _NoOfDays = lvappl.NoOfDays; // if (_empQuota.Count > 0) // { // switch (lvappl.LvType) // { // case "A": // _empQuota.FirstOrDefault().A = (float)(_empQuota.FirstOrDefault().A - _NoOfDays); // break; // case "B": // _empQuota.FirstOrDefault().B = (float)(_empQuota.FirstOrDefault().B - _NoOfDays); // break; // case "C": // _empQuota.FirstOrDefault().C = (float)(_empQuota.FirstOrDefault().C - _NoOfDays); // break; // case "D": // _empQuota.FirstOrDefault().D = (float)(_empQuota.FirstOrDefault().D - _NoOfDays); // break; // case "E": // _empQuota.FirstOrDefault().E = (float)(_empQuota.FirstOrDefault().E - _NoOfDays); // break; // case "F": // _empQuota.FirstOrDefault().F = (float)(_empQuota.FirstOrDefault().F - _NoOfDays); // break; // case "G": // _empQuota.FirstOrDefault().G = (float)(_empQuota.FirstOrDefault().G - _NoOfDays); // break; // case "H": // _empQuota.FirstOrDefault().H = (float)(_empQuota.FirstOrDefault().H - _NoOfDays); // break; // case "I": // _empQuota.FirstOrDefault().I = (float)(_empQuota.FirstOrDefault().I - _NoOfDays); // break; // case "J": // _empQuota.FirstOrDefault().J = (float)(_empQuota.FirstOrDefault().J - _NoOfDays); // break; // case "K": // _empQuota.FirstOrDefault().K = (float)(_empQuota.FirstOrDefault().K - _NoOfDays); // break; // case "L": // _empQuota.FirstOrDefault().L = (float)(_empQuota.FirstOrDefault().L - _NoOfDays); // break; // default: // break; // } // context.SaveChanges(); // } // } //} #endregion #region -- Add Half Leave-- public void AddHalfLeaveToLeaveData(LvApplication lvappl, LvType lvType) { DateTime datetime = new DateTime(); datetime = lvappl.FromDate; string _EmpDate = lvappl.EmpID + datetime.Date.ToString("yyMMdd"); LvData _LVData = new LvData(); _LVData.EmpID = lvappl.EmpID; _LVData.EmpDate = _EmpDate; _LVData.Remarks = lvappl.LvReason; _LVData.HalfLeave = true; _LVData.LvID = lvappl.LvID; _LVData.AttDate = datetime.Date; _LVData.LvCode = lvappl.LeaveTypeID; _LVData.FirstHalf = lvappl.FirstHalf; try { using (var db = new TAS2013Entities()) { db.LvDatas.Add(_LVData); db.SaveChanges(); } } catch (Exception ex) { } // Balance Leaves from Emp Table BalanceLeaves(lvappl, lvType); }
//public bool CheckHalfLeaveBalance(LvApplication lvapplication) //{ // _empQuota.Clear(); // int _EmpID; // float RemainingLeaves; // _EmpID = lvapplication.EmpID; // using (var context = new TAS2013Entities()) // { // _empQuota = context.LvQuotas.Where(aa => aa.EmpID == _EmpID).ToList(); // if (_empQuota.Count > 0) // { // switch (lvapplication.LvType) // { // case "A": // RemainingLeaves = (float)_empQuota.FirstOrDefault().A; // break; // case "B": // RemainingLeaves = (float)_empQuota.FirstOrDefault().B; // break; // case "C": // RemainingLeaves = (float)_empQuota.FirstOrDefault().C; // break; // case "D": // RemainingLeaves = (float)_empQuota.FirstOrDefault().D; // break; // case "E": // RemainingLeaves = (float)_empQuota.FirstOrDefault().E; // break; // case "F": // RemainingLeaves = (float)_empQuota.FirstOrDefault().F; // break; // case "G": // RemainingLeaves = (float)_empQuota.FirstOrDefault().G; // break; // case "H": // RemainingLeaves = (float)_empQuota.FirstOrDefault().H; // break; // case "I": // RemainingLeaves = (float)_empQuota.FirstOrDefault().I; // break; // case "J": // RemainingLeaves = (float)_empQuota.FirstOrDefault().J; // break; // case "K": // RemainingLeaves = (float)_empQuota.FirstOrDefault().K; // break; // default: // RemainingLeaves = 1; // break; // } // if ((RemainingLeaves - (float)lvapplication.NoOfDays) >= 0) // { // return true; // } // else // return false; // } // else // return false; // } //} #endregion #region -- Delete Leaves -- public void DeleteFromLVData(LvApplication lvappl) { int _EmpID = lvappl.EmpID; DateTime Date = lvappl.FromDate; while (Date <= lvappl.ToDate) { using (var context = new TAS2013Entities()) { string EmpDate = _EmpID.ToString() + Date.ToString("yyMMdd"); if (context.LvDatas.Where(aa => aa.EmpDate == EmpDate).Count() > 0) { var _id = context.LvDatas.Where(aa => aa.EmpID == _EmpID && aa.AttDate == Date.Date).FirstOrDefault().EmpDate; if (_id != null) { LvData lvvdata = context.LvDatas.Find(_id); //lvvdata.Active = false; context.LvDatas.Remove(lvvdata); context.SaveChanges(); } } } Date = Date.AddDays(1); } }
public bool AddLeaveToLeaveData(LvApplication lvappl) { DateTime datetime = new DateTime(); datetime = lvappl.FromDate; for (int i = 0; i < lvappl.NoOfDays; i++) { string _EmpDate = lvappl.EmpID + datetime.Date.ToString("yyMMdd"); LvData _LVData = new LvData(); _LVData.EmpID = lvappl.EmpID; _LVData.EmpDate = _EmpDate; _LVData.Remarks = lvappl.LvReason; _LVData.LvID = lvappl.LvID; _LVData.AttDate = datetime.Date; _LVData.LvCode = lvappl.LvType; _LVData.CompanyID = lvappl.CompanyID; try { using (var context = new TAS2013Entities()) { context.LvDatas.Add(_LVData); context.SaveChanges(); } } catch (Exception ex) { } datetime = datetime.AddDays(1); // Balance Leaves from Emp Table } BalanceLeaves(lvappl); return(true); }
private void butPageUpdate_Click(object sender, EventArgs e) { //if (txtPages.Text.Trim().Length <= 0) // return; if (Archstat.Trim().Length > 0) { int p = Convert.ToInt32(Archstat); if (p >= (int)T_ConFigure.ArchStat.排序完) { MessageBox.Show("已经排序完成无法进行更改页码!"); LvData.Focus(); return; } } try { int pages; bool bl = int.TryParse(txtPages.Text.Trim(), out pages); if (bl) { Common.UpdatePages(txtPages.Text.Trim(), Archid); ArchRegPages = pages; } LineFocus?.Invoke(sender, new EventArgs()); } catch { MessageBox.Show("更新页码失败!"); } }
public bool DeleteHLFromLVData(LvApplication lvappl) { bool chceck = false; int _EmpID = lvappl.EmpID; DateTime Date = lvappl.FromDate; while (Date <= lvappl.ToDate) { using (var context = new TAS2013Entities()) { if (context.LvDatas.Where(aa => aa.EmpID == _EmpID && aa.AttDate == Date.Date).Count() > 0) { var _id = context.LvDatas.Where(aa => aa.EmpID == _EmpID && aa.AttDate == Date.Date).FirstOrDefault().EmpDate; if (_id != null) { LvData lvvdata = context.LvDatas.Find(_id); //lvvdata.Active = false; context.LvDatas.Remove(lvvdata); context.SaveChanges(); chceck = true; } } } Date = Date.AddDays(1); } return(chceck); }
private void polygon_Click(object sender, RoutedEventArgs e) { LvData lv = Listview.SelectedItem as LvData; if (lv != null) { Console.WriteLine(lv.version.ToString()); Listview.Items.RemoveAt(1); } else { MessageBox.Show("0"); } }
private void butOk_Click(object sender, EventArgs e) { Application.DoEvents(); Query(); Witeini(); if (PagesEnd) { txtPages.Enabled = false; } LvData.Focus(); if (LvData.Items.Count > 0) { LvData.Items[0].Selected = true; // LvData_Click(null, null); } }