private void InitCommand() { CustCommand = new DelegateCommand((obj) => { //var ss1 = CRMService.GetQueryXoqlData<OpportunityAccountQueryXoqlModel>(@"select accountId.accountName AccountName,opportunityName OpportunityName from opportunity"); //if (ss1.code == 200) //{ // OpportunityAccountQueryXoqlModel[] rr = ss1.data.records; // SqlHelper.LoadArrayToDBModelTable(rr, "OpportunityAccountQueryXoqlTable"); //} //else //{ // MessageBox.Show($"{ss1.msg}"); //} var ss2 = CRMService.GetQueryXoqlData <SROpportunityQueryXoqlModel>(@" select customItem177__c ItemCode,opportunityName ItemName,ownerId XiangMuJingLi,dbcVarchar6 ShiChangZhiChi,customItem172__c YeWuZhiChi, customItem175__c JiShuZhiChi,customItem182__c PinZhiZhiChi,customItem173__c ChanPinJingLi,customItem180__c JiFuZhiChi,customItem181__c SeCaiZhiChi from opportunity "); if (ss2.code == 200) { SROpportunityQueryXoqlModel[] rr = ss2.data.records; SqlHelper.LoadArrayToDBModelTable(rr, "SROpportunityXoqlTable"); } else { MessageBox.Show($"{ss2.code} \r\n{ss2.msg}"); } //var ss = CRMService.GetQueryXoqlData(Token, "opportunity", " select dbcSelect1,opportunityName,customItem169__c,(select accountName from account where id=opportunity.customItem169__c) accountName from opportunity "); // var xx = CRMService.GetEntityDescription(); //Text1 = CRMService.GetEntityDescriptionString(); }); }
private void InitCommand() { CRMUserSyncCommand = new DelegateCommand((obj) => { var r = CRMService.GetQueryXoqlData <SRUserQueryXoqlModel>(@"select id Id,name Name,dimDepart DeptId from user ;"); if (r.code == 200) { SqlHelper.ExecuteNonQuerySR(" truncate table SRUserXoqlTable ;", null); SqlHelper.LoadIEnumerableToDBModelTableSR(r.data.records, "SRUserXoqlTable"); } }); CRMItemSyncCommand = new DelegateCommand((obj) => { List <SROpportunityQueryXoqlDbModel> lists = new List <SROpportunityQueryXoqlDbModel>(); var ss2 = CRMService.GetQueryXoqlData <SROpportunityQueryXoqlModel>(@" select customItem177__c ItemCode,opportunityName ItemName ,ownerId XiangMuJingLi,dbcVarchar6 ShiChangZhiChi,customItem172__c YeWuZhiChi, customItem175__c JiShuZhiChi,customItem182__c PinZhiZhiChi,customItem173__c ChanPinJingLi,customItem180__c JiFuZhiChi,customItem181__c SeCaiZhiChi,createdAt BeginDate from opportunity where dimDepart=1047572968276306 "); if (ss2.code == 200) { SROpportunityQueryXoqlModel[] rr = ss2.data.records; foreach (var item in rr) { SROpportunityQueryXoqlDbModel model = new SROpportunityQueryXoqlDbModel { Id = item.Id, BeginDate = TypeConvertHelper.ConvertTimeStampToDateTime(item.BeginDate), EndDate = TypeConvertHelper.ConvertTimeStampToDateTime(item.EndDate), ItemCode = item.ItemCode, ItemName = item.ItemName, HouDuanZhiChi = item.HouDuanZhiChi, JiFuZhiChi = item.JiFuZhiChi, PinZhiZhiChi = item.PinZhiZhiChi, SeCaiZhiChi = item.SeCaiZhiChi, ShiChangZhiChi = item.ShiChangZhiChi, XiangMuJingLi = item.XiangMuJingLi, YeWuZhiChi = item.YeWuZhiChi == null? "": string.Join(",", item.YeWuZhiChi), ChanPinJingLi = item.ChanPinJingLi == null? "" :string.Join(",", item.ChanPinJingLi), JiShuZhiChi = item.JiShuZhiChi == null ?"":string.Join(",", item.JiShuZhiChi), }; lists.Add(model); } SqlHelper.ExecuteNonQuerySR(" truncate table SROpportunityXoqlTable ;", null); SqlHelper.LoadIEnumerableToDBModelTableSR(lists, "SROpportunityXoqlTable"); } else { MessageBox.Show($"{ss2.code} \r\n{ss2.msg}"); } }); EmployeeCostImportCommand = new DelegateCommand((obj) => { //文件选择窗口 System.Windows.Forms.OpenFileDialog opd = new System.Windows.Forms.OpenFileDialog { Title = "选择文件", Filter = "EXCEL文件|*.xls*" //第一个参数是名称,随意取,第二个是模式匹配, 多个也是用“|”分割 }; if (opd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { int monthId = Convert.ToInt32(CommonService.ImportExcelToDatabaseTableWithoutSeq(opd.FileName, "SREmployeeCost", "SR")); SettleMonthSearchedItem.Id = monthId; SettleMonthSearchedItem.SearchText = monthId.ToString(); // 数据验证后加载验证模型列表到表格 //MessageBox.Show("导入成功"); } opd.Dispose(); }); ItemProfitSettleCommand = new DelegateCommand((obj) => { if (SettleMonthSearchedItem == null) { MessageBox.Show("请先导入人员支出Excel"); return; } //同步OA费用数据到松润数据库 DataTable dataTable = _itemProfitAccountingService.GetOaItemCostDataTable(SettleMonthSearchedItem.Id); _itemProfitAccountingService.ImportDataTableToDatabaseTableSR(dataTable, "SROaItemCost"); // 计算最终的结果 _itemProfitAccountingService.AccountItemProfit(SettleMonthSearchedItem.Id); ItemProfitAccountingQueryCommand.Execute(null); }); ItemProfitAccountingQueryCommand = new DelegateCommand((obj) => { ItemProfitAccountingLists.Clear(); _itemProfitAccountingService.GetItemProfitAccountingLists($" and ItemName like '%{ItemNameParameter}%' ").ForEach(x => ItemProfitAccountingLists.Add(x)); ListsSum = ItemProfitAccountingLists.Sum(x => x.Profit); ListsCount = ItemProfitAccountingLists.Count(); }); ItemProfitDeleteCommand = new DelegateCommand((obj) => { MessageBoxResult result = MessageBox.Show($"确认删除【{SettleMonthSearchedItem.Id}】已经结算的数据", "温馨提示", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { } }); ItemProfitMonthlyQueryCommand = new DelegateCommand((obj) => { if (SettleMonthSearchedItem == null) { return; } ItemProfitAccountingMonthlyLists.Clear(); _itemProfitAccountingService.GetItemProfitAccountingMonthlyLists($" and SettleMonth = {SettleMonthSearchedItem.Id} ").ForEach(x => ItemProfitAccountingMonthlyLists.Add(x)); }); SelectionChangedCommand = new DelegateCommand((obj) => { if (ItemProfitAccountingSelectedItem == null) { return; } ItemProfitAccountingMonthlyLists.Clear(); _itemProfitAccountingService.GetItemProfitAccountingMonthlyLists($" and ItemCode = {ItemProfitAccountingSelectedItem.ItemCode} ").ForEach(x => ItemProfitAccountingMonthlyLists.Add(x)); }); }