/// <summary> /// 模型数据改变 /// </summary> /// <param name="obj"></param> private void dataChanged(EquipmentTypeModel equipmentTypeModel) { getPageData(pageRepuestParams.PageIndex, pageRepuestParams.PageSize); var tmpModel = EquipmentTypeInfoList.FirstOrDefault(a => a.Id == equipmentTypeModel.Id); this.EquipmentTypeInfo = EquipmentTypeInfoList.FirstOrDefault(); }
public static List <EquipmentTypeModel> GetEquipmentAgreementList() { var connectionString = ConfigurationManager.AppSettings["DbConnection"]; var sqlString = "SELECT * FROM sys_Equipment_Type "; SqlParameter[] sqlParams = new SqlParameter[] { // new SqlParameter("@ClientIp", clientIp) }; List <EquipmentTypeModel> list = new List <EquipmentTypeModel>(); SqlDataReader reader = SqlHelper.ExecuteReader(connectionString, CommandType.Text, sqlString, sqlParams); while (reader.Read()) { EquipmentTypeModel e = new EquipmentTypeModel { TypeName = reader.GetString(0), ParentId = reader.GetString(1), EquipmentId = reader.GetString(2), ModelNumber = reader.GetString(3), Remark = reader.GetString(4), Id = reader.GetString(5), }; list.Add(e); } reader.Close(); return(list); }
public async Task <ResultModel <EquipmentTypeOutputModel> > InsertEquipmentType([FromBody] EquipmentTypeInputModel item) { var equipmentTypeItem = new EquipmentTypeModel() { Name = item.Name, Description = item.Description }; return(await _equipmentTypeStoreService.InsertAndSaveAsync <EquipmentTypeOutputModel>(equipmentTypeItem)); }
/// <summary> /// 执行导出命令 /// </summary> private async void OnExecuteExportCommand() { var window = (MetroWindow)Application.Current.MainWindow; var dialogResult = await window.ShowMessageAsync("数据导出" , "确定要从磁盘中导出企业信息数据吗?" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "是", NegativeButtonText = "否" }); if (dialogResult == MessageDialogResult.Affirmative) { string filePath = ""; System.Windows.Forms.SaveFileDialog openFileDialog = new System.Windows.Forms.SaveFileDialog(); openFileDialog.FileName = "设备类型信息" + DateTime.Now.ToString("yyyy-MM-dd_hh-mm-ss") + ".xls"; if (openFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)//注意,此处一定要手动引入System.Window.Forms空间,否则你如果使用默认的DialogResult会发现没有OK属性 { filePath = openFileDialog.FileName; } if (string.IsNullOrEmpty(filePath)) { await window.ShowMessageAsync("数据导出" , "数据导出失败,选择存储路径为空!" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); return; } if (EquipmentTypeInfoList.Any()) { try { EquipmentTypeModel model = new EquipmentTypeModel(); List <string> displayNameList = model.GetDisplayName(); DataTable dataTable = EquipmentTypeInfoList.ToDataTable <EquipmentTypeModel>(displayNameList); NPOIHelper.Export(dataTable, "企业信息", filePath); } catch (Exception ex) { await window.ShowMessageAsync("数据导出" , "数据导出失败!" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); } if (File.Exists(filePath)) { await window.ShowMessageAsync("数据导出" , "数据导出已完成!" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); } else { await window.ShowMessageAsync("数据导出" , "数据导出失败!" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); } } else { await window.ShowMessageAsync("数据导出" , "数据导出失败,无数据!" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); } } }
/// <summary> /// 执行导入命令 /// </summary> private async void OnExecuteImportCommand() { var window = (MetroWindow)System.Windows.Application.Current.MainWindow; var dialogResult = await window.ShowMessageAsync("数据导入" , "确定要导入企业信息数据到磁盘中吗?将会删除磁盘中原有数据" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "是", NegativeButtonText = "否" }); if (dialogResult == MessageDialogResult.Affirmative) { string filePath = ""; OpenFileDialog openFileDialog = new OpenFileDialog(); if (openFileDialog.ShowDialog() == DialogResult.OK)//注意,此处一定要手动引入System.Window.Forms空间,否则你如果使用默认的DialogResult会发现没有OK属性 { filePath = openFileDialog.FileName; } if (string.IsNullOrEmpty(filePath)) { UiMessage = "数据导入失败,选择存储路径为空!"; return; } if (EquipmentTypeInfoList.Any()) { try { EquipmentTypeModel model = new EquipmentTypeModel(); Dictionary <String, Type> filedNameDc = model.GetFiledNameAndType(); DataTable dt = NPOIHelper.Import(filePath); DataTable dtNew = new DataTable(); foreach (var kvp in filedNameDc) { dtNew.Columns.Add(kvp.Key, kvp.Value); } object[] values = new object[filedNameDc.Count]; foreach (DataRow row in dt.Rows) { for (int i = 0; i < dtNew.Columns.Count; i++) { values[i] = row[i]; } dtNew.Rows.Add(values); } List <EquipmentTypeModel> enterpriseModels = dtNew.DataTableToList <EquipmentTypeModel>(); getPageData(pageRepuestParams.PageIndex, pageRepuestParams.PageSize); var result = Utility.Http.HttpClientHelper.PostResponse <OperationResult>(GlobalData.ServerRootUri + "EquipmentTypeInfo/Remove", Utility.JsonHelper.ToJson(EquipmentTypeInfoList.Select(x => x.Id).ToList())); if (!Equals(result, null) && result.Successed) { var addResult = Utility.Http.HttpClientHelper.PostResponse <OperationResult>(GlobalData.ServerRootUri + "EquipmentTypeInfo/Add", Utility.JsonHelper.ToJson(enterpriseModels)); await window.ShowMessageAsync("数据导入" , "数据导入已完成!" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); getPageData(pageRepuestParams.PageIndex, pageRepuestParams.PageSize); EquipmentTypeInfo = null; } else { //操作失败,显示错误信息 UiMessage = "数据删除失败,请联系管理员!"; } } catch (Exception ex) { await window.ShowMessageAsync("数据导入" , "数据导入失败!" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); } //if (File.Exists(filePath)) //{ // await window.ShowMessageAsync("数据导入" // , "数据导入已完成!" // , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); //} //else //{ // await window.ShowMessageAsync("数据导入" // , "数据导入失败!" // , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); //} } else { await window.ShowMessageAsync("数据导入" , "数据导入失败,无数据!" , MessageDialogStyle.AffirmativeAndNegative, new MetroDialogSettings() { AffirmativeButtonText = "确定" }); } } }