private void Page_Loaded(object sender, RoutedEventArgs e)
{
_PageViewModel.InitPropValue();
TBPlanCaption.Focus();
DataContext = _PageViewModel;
AppFuns.SetStateBarText("录入或编辑一个工作计划。");
}
/// <summary>
/// 查询计划
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void btn_Refrash_ClickAsync(object sender, RoutedEventArgs e)
{
//设置查询条件类
_CurPageViewModel.SearchCondition.PageIndex = 1;
await _CurPageViewModel.GetPlansAsync();
AppFuns.SetStateBarText($"共查询到 :{_CurPageViewModel.SearchCondition.RecordCount}条记录,每页{_CurPageViewModel.SearchCondition.PageSize}条，共{_CurPageViewModel.SearchCondition.PageCount}页！");
}
private async void btn_Refrash_ClickAsync(object sender, RoutedEventArgs e)
{
_CurPageViewModel.SearchCondition.PageIndex = 1;
await _CurPageViewModel.GetFilesAsync();
Col_UCFileInfo.Width = new GridLength(0);
AppFuns.SetStateBarText($"共查询到 :{_CurPageViewModel.SearchCondition.RecordCount}条记录,每页{_CurPageViewModel.SearchCondition.PageSize}条，共{_CurPageViewModel.SearchCondition.PageCount}页！");
}
/// <summary>
/// 更新文件信息（文件名及文件描述）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void btn_SaveChange(object sender, RoutedEventArgs e)
{
ExcuteResult JsonResult = await DataPlanFileRepository.UpdateFileInfo(_CurUCViewModel.CurFile);
if (JsonResult.State == 0)
{
AppFuns.SetStateBarText(JsonResult.Msg);
}
AppFuns.ShowMessage(JsonResult.Msg, "消息");
}
/// <summary>
/// 查询备忘录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void btn_Search_ClickAsync(object sender, System.Windows.RoutedEventArgs e)
{
Col_NoteInfo.Width = new System.Windows.GridLength(0, System.Windows.GridUnitType.Pixel);
_CurPageViewModel.SearchCondition.PageIndex = 1;
await _CurPageViewModel.GetNotesAsync();
DataContext = _CurPageViewModel;
AppFuns.SetStateBarText($"共查询到 :{_CurPageViewModel.SearchCondition.RecordCount}条记录,每页{_CurPageViewModel.SearchCondition.PageSize}条，共{_CurPageViewModel.SearchCondition.PageCount}页！");
}
/// <summary>
/// 查询记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void BtnSearchClickAsync(object sender, RoutedEventArgs e)
{
await _PageViewModel.SearchRecords();
if (_PageViewModel.CurMember != null)
{
await UcMemberHolidayFile.InitFileDatasAsync(_PageViewModel.CurMember.Id, "休假信息", true);
_PageViewModel.CanOperation = true;
AppFuns.SetStateBarText($"正在录入[{_PageViewModel.CurMember.Name}]的休假信息。");
}
}
/// <summary>
/// 删除该文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void btn_DeleteFileAsync(object sender, RoutedEventArgs e)
{
if (AppFuns.ShowMessage($"确定要删除[{_CurUCViewModel.CurFile.Name}]文件吗？", Caption: "确认", showYesNo: true))
{
ExcuteResult JsonResult = await DataPlanFileRepository.DeleteFileInfo(_CurUCViewModel.CurFile);
if (JsonResult.State == 0)
{
_DelFileCallBackFun?.Invoke(_CurUCViewModel.CurFile);
AppFuns.SetStateBarText(JsonResult.Msg);
}
else
{
AppFuns.ShowMessage(JsonResult.Msg, "消息");
}
}
}
/// <summary>
/// 查询指定条件的记录
/// </summary>
/// <returns></returns>
private async System.Threading.Tasks.Task SearchMember()
{
List <Lib.MemberInfoEntity> MemberList = await DataMemberRepository.ReadMembers(_PageViewModel.mSearch);
if (MemberList == null)
{
AppFuns.SetStateBarText("查询过程出现错误，请重试!");
return;
}
if (MemberList.Count < 1)
{
_PageViewModel.EntityList.Clear();
}
else
{
MemberList.Sort((x, y) => x.OrderIndex - y.OrderIndex);
_PageViewModel.EntityList.Clear();
MemberList.ForEach(e => { _PageViewModel.EntityList.Add(e); });
}
AppFuns.SetStateBarText($"共查询到记录：{_PageViewModel.EntityList.Count}条");
}
/// <summary>
/// 查询待发放信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void BtnSearchClickAsync(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(_MemberSearch.Id))
{
return;
}
List <Lib.MemberInfoEntity> Members = await DataMemberRepository.ReadMembers(_MemberSearch);
if (Members == null || Members.Count < 1)
{
AppFuns.ShowMessage("未找到此用户信息！");
return;
}
AppFuns.SetStateBarText($"查看或打印[{Members[0].Name}]信息表。");
_FixedDocVM = new FixedDocViewModel(Members[0]);
await _FixedDocVM.InitPropsAsync();
//设定打印标题
_FixedDocVM.PrintCaption = $"事 业 编 制 人 员 基 本 情 况 表";
if (_FixedDocVM.CurMember.MemberType.Equals("劳动合同制"))
{
_FixedDocVM.PrintCaption = $"劳 动 用 工 人 员 基 本 情 况 表";
}
if (_FixedDocVM.CurMember.MemberType.Equals("劳务派遣制"))
{
_FixedDocVM.PrintCaption = $"劳 务 用 工 人 员 基 本 情 况 表";
}
//设定打印日期
_FixedDocVM.PrintDate = DateTime.Now;
//导入格式模板
string SheetTemplet = "PrintMemberSheetFixedDot.xaml";
_FixedDoc = (FixedDocument)Application.LoadComponent(new Uri($"/Office.Work.Platform;component/Member/{SheetTemplet}", UriKind.RelativeOrAbsolute));
_FixedDoc.AddPages();
_FixedDoc.DataContext = _FixedDocVM;
docViewer.Document = _FixedDoc;
this.BtnExport.IsEnabled = true;
}
/// <summary>
/// 查询数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void btn_Refrash_ClickAsync(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(_PageViewModel.FieldValue))
{
AppFuns.SetStateBarText("必须输入查询内容!");
return;
}
//是否在结果中查询
if (!_PageViewModel.SearchInResult)
{
_PageViewModel.mSearch = new MemberSearch();
}
//设置查询条件
PropertyInfo[] SourceAttris = _PageViewModel.mSearch.GetType().GetProperties();
var tempObj = SourceAttris.Where(x => x.Name.Equals(_PageViewModel.FieldEnName, StringComparison.Ordinal)).FirstOrDefault();
if (tempObj != null)
{
tempObj.SetValue(_PageViewModel.mSearch, _PageViewModel.FieldValue);
}
await SearchMember();
}
private void Page_Unloaded(object sender, RoutedEventArgs e)
{
AppFuns.SetStateBarText("就绪。");
}
private void Page_Loaded(object sender, System.Windows.RoutedEventArgs e)
{
AppFuns.SetStateBarText("统计员工休假信息。");
this.DataContext = _PageViewModel;
}
public void Page_Loaded(object sender, System.Windows.RoutedEventArgs e)
{
AppFuns.SetStateBarText("查询平台备忘内容。");
Col_NoteInfo.Width = new System.Windows.GridLength(0, System.Windows.GridUnitType.Pixel);
btn_Search_ClickAsync(null, null);
}
/// <summary>
/// 查询待发放信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void Btn_Search_ClickAsync(object sender, RoutedEventArgs e)
{
//获取所有可发放的待遇项目
IEnumerable <MemberPayItem> CollectPayItem = await DataMemberPayItemRepository.GetRecords(new MemberPayItemSearch()
{
PayUnitName = AppSet.LoginUser.UnitName, UserId = AppSet.LoginUser.Id
}).ConfigureAwait(false);
_CurViewModel.PayItems = CollectPayItem?.ToList();
//1.查询所有可发放的待遇项目信息
_CurViewModel.SearchCondition.PayYear = _CurViewModel.PayYearMonth.Year;
_CurViewModel.SearchCondition.PayMonth = _CurViewModel.PayYearMonth.Month;
_CurViewModel.SalaryJArray.Clear();
IEnumerable <MemberSalarySearchResult> SalaryList = await DataMemberSalaryRepository.GetRecords(_CurViewModel.SearchCondition).ConfigureAwait(false);
if (SalaryList != null && SalaryList.Count() > 0)
{
foreach (MemberSalarySearchResult item in SalaryList)
{
float YingFaDaiYu = 0f;
float GeRenJiaoNa = 0f;
float DanWeiJiaoNa = 0f;
JObject TempJobj = new JObject();
PropertyInfo[] Props = item.GetType().GetProperties();
for (int i = 0; i < Props.Length; i++)
{
if (_CurViewModel.NoPrintItemNames.Contains(Props[i].Name))
{
continue;
}
var CurValue = Props[i].GetValue(item);
if (CurValue != null)
{
if (Props[i].Name == "SalaryItems")
{
_CurViewModel.SalaryItems = CurValue as List <SalaryItem>;
//在 _CurViewModel.SalaryItems 中添加相应的汇总项
switch (item.TableType)
{
case "月度工资表":
int k = 0;
for (k = 0; k < _CurViewModel.SalaryItems.Count; k++)
{
MemberPayItem CurPayItem = _CurViewModel.PayItems.Where(x => x.Name.Equals(_CurViewModel.SalaryItems[k].Name)).FirstOrDefault();
if (CurPayItem != null && CurPayItem.PayType.Equals("个人交纳"))
{
break;
}
}
_CurViewModel.SalaryItems.Insert(k, new SalaryItem()
{
Name = "应发合计", Amount = 0
});
_CurViewModel.SalaryItems.Add(new SalaryItem()
{
Name = "实发合计", Amount = 0
});
break;
case "月度补贴表":
_CurViewModel.SalaryItems.Add(new SalaryItem()
{
Name = "补贴合计", Amount = 0
});
break;
case "其他待遇表":
_CurViewModel.SalaryItems.Add(new SalaryItem()
{
Name = "发放合计", Amount = 0
});
break;
}
for (int ik = 0; ik < _CurViewModel.SalaryItems.Count; ik++)
{
TempJobj[_CurViewModel.SalaryItems[ik].Name] = _CurViewModel.SalaryItems[ik].Amount;
MemberPayItem CurPayItem = _CurViewModel.PayItems.Where(x => x.Name.Equals(_CurViewModel.SalaryItems[ik].Name)).FirstOrDefault();
if (CurPayItem != null)
{
if (CurPayItem.PayType.Equals("应发待遇"))
{
YingFaDaiYu += _CurViewModel.SalaryItems[ik].Amount;
}
else if (CurPayItem.PayType.Equals("个人交纳"))
{
GeRenJiaoNa += _CurViewModel.SalaryItems[ik].Amount;
}
else if (CurPayItem.PayType.Equals("单位交纳"))
{
DanWeiJiaoNa += _CurViewModel.SalaryItems[ik].Amount;
}
}
}
}
else
{
if (Props[i].Name.Equals("UpDateTime"))
{
DateTime upDate = DateTime.MinValue;
DateTime.TryParse(CurValue.ToString(), out upDate);
if (upDate == DateTime.MinValue)
{
upDate = DateTime.Now;
}
TempJobj[_CurViewModel.NamesEnCn[Props[i].Name]] = upDate.ToString("yyyy-MM-dd");
}
else
{
TempJobj[_CurViewModel.NamesEnCn[Props[i].Name]] = CurValue.ToString();
}
}
}
else
{
TempJobj[_CurViewModel.NamesEnCn[Props[i].Name]] = "";
continue;
}
}
switch (item.TableType)
{
case "月度工资表":
TempJobj["应发合计"] = YingFaDaiYu.ToString("0.00");
TempJobj["实发合计"] = (YingFaDaiYu - GeRenJiaoNa).ToString("0.00");
break;
case "月度补贴表":
TempJobj["补贴合计"] = YingFaDaiYu.ToString("0.00");
break;
case "其他待遇表":
TempJobj["发放合计"] = YingFaDaiYu.ToString("0.00");
break;
}
_CurViewModel.SalaryJArray.Add(TempJobj);
}
}
else
{
_CurViewModel.SalaryJArray.Clear();
AppFuns.ShowMessage("未发现指定的待遇发放记录！");
return;
}
App.Current.Dispatcher.Invoke(() =>
{
AppFuns.SetStateBarText($"共查询到：{_CurViewModel.SalaryJArray.Count} 条数据。");
string Caption = $"{AppSet.LoginUser.UnitShortName}{_CurViewModel.SearchCondition.MemberType}人员{_CurViewModel.SearchCondition.TableType}";
string DateStr = $"发放月份：（{_CurViewModel.SearchCondition.PayYear}年{_CurViewModel.SearchCondition.PayMonth}月）";
if (!_CurViewModel.SearchCondition.TableType.Contains("月"))
{
DateStr = $"发放时间：{_CurViewModel.PayYearMonth.Year}年{_CurViewModel.PayYearMonth.Month}月{_CurViewModel.PayYearMonth.Day}日";
}
CreateFlowDoc("PrintMemberPaySheetDot.xaml", Caption, DateStr, _CurViewModel.SalaryJArray, P_DocWidth: 1122, P_DocHeight: 793);
});
}
private void Page_Unloaded(object sender, RoutedEventArgs e)
{
_FixedDoc = null;
_FixedDocVM = null;
AppFuns.SetStateBarText("就绪");
}