/// <summary> /// 数据操作 /// </summary> /// <param name="Mess">区别编辑还是新增还是删除</param> private void OpreationDB(string Mess) { BaseDataClass.EquipmentInfoList Equiplist = new EquipmentInfoList(); Equiplist.EquipmentID = this.tbx_ID.Text.Trim(); Equiplist.EquipmentName = this.tbx_Name.Text.Trim(); Equiplist.EquipmentModel = this.tbx_EquipNum.Text.Trim(); Equiplist.EquipmentType = this.tbx_EquipType.Text.Trim(); Equiplist.PersonIncharge = this.tbx_PersonIncharge.Text.Trim(); Equiplist.ReturnDate = this.TimePicker_ReturnDate.Value.ToString("yyyy-MM-dd"); Equiplist.AllottedDate = this.TimePicker_Intime.Value.ToString("yyyy-MM-dd"); Equiplist.Description = this.tbx_descrip.Text; Equiplist.Unit = this.tbx_Unit.Text; Equiplist.EquipmentState = this.tbx_EquipmentState.Text; deviceInfo PersonInfo = new deviceInfo(); string Error = ""; bool Result = false; if (Mess == "添加") { if (tbx_ID.Text.Trim() != "") { //deviceInfo device = new deviceInfo(); //string sql = "select * from EquipmentInfoList where EquipmentID =" + tbx_ID.Text.Trim(); //DataSet result= device.gettablebycondition(sql); deviceInfo device = new deviceInfo(); log_tabel log = new log_tabel(); log.addrow("EquipmentID", tbx_ID.Text.Trim(), log_tabel.operatetype.equal, log_tabel.mark.normal); int i = device.GetRecordCount(logs.EquipmentInfoList, log); if (i > 0) { MessageBox.Show("设备编号重复 请重新录入!"); } else { Result = PersonInfo.AddBaseList(Equiplist, ref Error); } } } if (Mess == "编辑") { Result = PersonInfo.UpdateBaselist(Equiplist, ref Error); } if (Mess == "删除") { Result = PersonInfo.DeleteOneRecord(BaseDataClassNames.EquipmentInfoList, Equiplist.EquipmentID, ref Error); } if (Result == true) { MessageBox.Show("设备信息" + Mess + "成功"); ClearText(this.Content); } else { MessageBox.Show("设备信息" + Mess + "失败,请稍后再试!"); ClearText(this.Content); } }
/// <summary> /// 是否可以执行打印命令 /// </summary> /// <returns></returns> private bool OnCanExecutePrintCommand() { if (Equals(EquipmentInfoList, null) || !EquipmentInfoList.Any()) { return(false); } else { return(true); } }
/// <summary> /// 取得分页数据 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> private void getPageData(int pageIndex, int pageSize) { #if DEBUG System.Diagnostics.Stopwatch stopwatch = new System.Diagnostics.Stopwatch(); stopwatch.Start(); #endif pageRepuestParams.SortField = "LastUpdatedTime"; pageRepuestParams.SortOrder = "desc"; pageRepuestParams.PageIndex = pageIndex; pageRepuestParams.PageSize = pageSize; Utility.Http.HttpClientHelper.SetAccessTokenToHttpClient(GlobalData.AccessTocken); var result = Utility.Http.HttpClientHelper.PostResponse <OperationResult <PageResult <EquipmentInfoModel> > >(GlobalData.ServerRootUri + "EquipmentInfo/PageData", Utility.JsonHelper.ToJson(pageRepuestParams)); #if DEBUG stopwatch.Stop(); Utility.LogHelper.Info("获取地标信息用时(毫秒):" + stopwatch.ElapsedMilliseconds); Utility.LogHelper.Info("地标信息内容:" + Utility.JsonHelper.ToJson(result)); #endif if (!Equals(result, null) && result.Successed) { Application.Current.Resources["UiMessage"] = result?.Message; LogHelper.Info(Application.Current.Resources["UiMessage"].ToString()); if (result.Data.Data.Any()) { //TotalCounts = result.Data.Total; //Messenger.Default.Send(LoginUser, MessengerToken.LoginSuccess); EquipmentInfoList = new ObservableCollection <EquipmentInfoModel>(result.Data.Data); //TotalCounts = result.Data.Total; } else { EquipmentInfoList?.Clear(); //TotalCounts = 0; Application.Current.Resources["UiMessage"] = "未找到数据"; } } else { //操作失败,显示错误信息 EquipmentInfoList = new ObservableCollection <EquipmentInfoModel>(); Application.Current.Resources["UiMessage"] = result?.Message ?? "查询地标信息失败,请联系管理员!"; } }
/// <summary> /// 取得分页数据 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> private void getPageData(int pageIndex, int pageSize) { #if DEBUG System.Diagnostics.Stopwatch stopwatch = new System.Diagnostics.Stopwatch(); stopwatch.Start(); #endif pageRepuestParams.SortField = GlobalData.SortField; pageRepuestParams.SortOrder = GlobalData.SortOrder; pageRepuestParams.PageIndex = pageIndex; pageRepuestParams.PageSize = pageSize; var result = Utility.Http.HttpClientHelper.PostResponse <OperationResult <PageResult <EquipmentInfoModel> > >(GlobalData.ServerRootUri + "EquipmentInfo/PageData", Utility.JsonHelper.ToJson(pageRepuestParams)); #if DEBUG stopwatch.Stop(); Utility.LogHelper.Info("获取设备信息用时(毫秒):" + stopwatch.ElapsedMilliseconds); Utility.LogHelper.Info("设备信息内容:" + Utility.JsonHelper.ToJson(result)); #endif if (!Equals(result, null) && result.Successed) { UiMessage = result?.Message; LogHelper.Info(UiMessage); if (result.Data.Data.Any()) { EquipmentInfoList = new ObservableCollection <EquipmentInfoModel>(result.Data.Data); TotalCounts = result.Data.Total; } else { EquipmentInfoList?.Clear(); TotalCounts = 0; UiMessage = "未找到数据"; } } else { //操作失败,显示错误信息 EquipmentInfoList = new ObservableCollection <EquipmentInfoModel>(); UiMessage = result?.Message ?? "查询设备信息失败,请联系管理员!"; } }
/// <summary> /// 获取设备分页数据 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> private void getEquipmentPageData(int pageIndex, int pageSize) { #if DEBUG System.Diagnostics.Stopwatch stopwatch = new System.Diagnostics.Stopwatch(); stopwatch.Start(); #endif pageRepuestParams = new PageRepuestParams(); pageRepuestParams.SortField = GlobalData.SortField; pageRepuestParams.SortOrder = GlobalData.SortOrder; pageRepuestParams.PageIndex = pageIndex; pageRepuestParams.PageSize = pageSize; var result = Utility.Http.HttpClientHelper.PostResponse <OperationResult <PageResult <EquipmentModel> > >(GlobalData.ServerRootUri + "EquipmentInfo/PageData", Utility.JsonHelper.ToJson(pageRepuestParams)); #if DEBUG stopwatch.Stop(); Utility.LogHelper.Info("获取设备列表用时(毫秒):" + stopwatch.ElapsedMilliseconds); Utility.LogHelper.Info("设备列表内容:" + Utility.JsonHelper.ToJson(result)); #endif if (!Equals(result, null) && result.Successed) { Application.Current.Resources["UiMessage"] = result?.Message; LogHelper.Info(Application.Current.Resources["UiMessage"].ToString()); if (result.Data.Data.Any()) { EquipmentInfoList = new ObservableCollection <EquipmentModel>(result.Data.Data); EquipmentModel equ = new EquipmentModel(); EquipmentInfoList.Insert(0, equ); } else { EquipmentInfoList?.Clear(); Application.Current.Resources["UiMessage"] = "未找到数据"; } } else { //操作失败,显示错误信息 EquipmentInfoList = new ObservableCollection <EquipmentModel>(); Application.Current.Resources["UiMessage"] = result?.Message ?? "查询设备列表失败,请联系管理员!"; } }
private void ReadTextAssets() { // 所有装备信息 var text = Resources.Load <TextAsset>("TextAssets/Equipment"); EquipmentInfoList equipmentInfoList = JsonUtility.FromJson <EquipmentInfoList>(text.text); foreach (var equipmentInfo in equipmentInfoList.equipmentList) { allEquipment.Add(equipmentInfo.enName); equipmentInfoMap.Add(equipmentInfo.enName, equipmentInfo); } allEquipment.ForEach(i => equipmentList.Add(i)); // 所有技能信息 text = Resources.Load <TextAsset>("TextAssets/Skill"); SkillList skillList = JsonUtility.FromJson <SkillList>(text.text); foreach (var skill in skillList.skillList) { this.skillList.Add(skill.enName); skillInfoMap.Add(skill.enName, skill); } }
/// <summary> /// 模型数据改变 /// </summary> /// <param name="obj"></param> private void dataChanged(EquipmentInfoModel equipmentModel) { getPageData(pageRepuestParams.PageIndex, pageRepuestParams.PageSize); this.EquipmentInfo = EquipmentInfoList.FirstOrDefault(); }
public override void OnParamterChanged(object parameter) { this.EquMaintenancePlanInfo = parameter as EquMaintenancePlanInfoModel; this.EntDepartmentInfo = EntDepartmentInfoList.Where(x => x.Id == Guid.Parse(EquMaintenancePlanInfo.CheckDepartmentID)).FirstOrDefault(); this.EquipmentModel = EquipmentInfoList.Where(x => x.Id == Guid.Parse(EquMaintenancePlanInfo.EquipmentInfo_Id)).FirstOrDefault(); }
public override void OnParamterChanged(object parameter) { this.EquRepairsInfo = parameter as EquRepairsInfoModel; this.EquipmentModel = EquipmentInfoList.Where(x => x.Id == Guid.Parse(EquRepairsInfo.EquipmentInfo_Id)).FirstOrDefault(); this.EquSparePartsInfo = EquSparePartsInfoList.Where(x => x.Id == Guid.Parse(EquRepairsInfo.SparePartsInfo_Id)).FirstOrDefault(); }