/// <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();
}
