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