/// <summary>
/// 添加差旅休假信息
/// </summary>
/// <param name="travelOnVacation"></param>
/// <returns></returns>
public int AddTravelOnVacation(TravelOnVacation travelOnVacation)
{
using (MySqlConnection conn = DapperHelper.GetConnString())
{
string sql = @"insert into TravelOnVacation(StaffId,Name,ApplicationType,ApplicationReason,StartTime,EndTime,ComputingTime,ApplicationDate,State) values(@StaffId,@Name,@ApplicationType,@ApplicationReason,@StartTime,@EndTime,@ComputingTime,@ApplicationDate,@State)";
var result = conn.Execute(sql, travelOnVacation);
return(result);
}
}
public PageNumber GetTravelOnVacations(int StaffId, int?pageIndex)
{
//0删除、1提交、2草稿
//Breach List
List <TravelOnVacation> travelOnVacationsList = new List <TravelOnVacation>();
//查询本月签到情况
var list = ItravelOnVacationServices.GetTravelOnVacations(StaffId);
////申请类型条件查询
//if (!string.IsNullOrWhiteSpace(applicationType))
//{
// list = list.Where(m => m.ApplicationType.Contains(applicationType)).ToList();
//}
////申请状态条件查询
//if (state != null)
//{
// list = list.Where(m => m.State.Equals(state)).ToList();
//}
////申请日期条件查询
//if (!string.IsNullOrWhiteSpace(applicationDate))
//{
// list = list.Where(m => m.ApplicationDate.Contains(applicationDate)).ToList();
//}
for (int i = 0; i < list.Count; i++)
{
var reverseStrState = ""; //状态文字(反)
var strState = ""; //状态文字
//0删除、1提交、2草稿
if (list[i].State == 1)
{
strState = "提交中 "; reverseStrState = "撤回 ";
}
if (list[i].State == 2)
{
strState = "草稿 "; reverseStrState = "删除 ";
}
//实例化差旅休假Model
TravelOnVacation travelOnVacations = new TravelOnVacation
{
Id = list[i].Id, //主键（自增）
StaffId = list[i].StaffId, //员工ID
Name = list[i].Name, //姓名
ApplicationType = list[i].ApplicationType, //申请类型
ApplicationReason = list[i].ApplicationReason, //申请事由
StartTime = list[i].StartTime, //开始时间
EndTime = list[i].EndTime, //结束时间
ComputingTime = list[i].ComputingTime, //计算时长
ApplicationDate = list[i].ApplicationDate, //申请日期
State = list[i].State, //状态
StrState = strState, //状态文字
ReverseStrState = reverseStrState //状态文字(反)
};
//Add Model In List
travelOnVacationsList.Add(travelOnVacations);
}
PageNumber pageNumber = new PageNumber();
pageNumber.DataCount = travelOnVacationsList.Count;
pageNumber.CurrentPage = Convert.ToInt32(pageIndex);
pageNumber.TotlePage = (travelOnVacationsList.Count / PAGESIZE) + (travelOnVacationsList.Count % PAGESIZE == 0 ? 0 : 1);
pageNumber.Data = travelOnVacationsList.Skip((Convert.ToInt32(pageIndex) - 1) * PAGESIZE).Take(PAGESIZE);
return(pageNumber);
}
public int AddTravelOnVacation(TravelOnVacation travelOnVacation)
{
var result = ItravelOnVacationServices.AddTravelOnVacation(travelOnVacation);
return(result);
}