|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Converters;
|
using PdmSwPlugin.PDM;
|
using PdmSwPlugin.Test.Model;
|
using PdmSwPlugin.Util;
|
using PdmSwPlugin.Util.Entity;
|
using SolidWorks.Interop.sldworks;
|
using System;
|
using System.Collections.Generic;
|
using System.Runtime.InteropServices;
|
using System.Windows.Documents;
|
|
namespace PdmSwPlugin.Test.UIHandler
|
{
|
[ClassInterface(ClassInterfaceType.AutoDual)]
|
[ComVisible(true)]
|
public class TestWebModel
|
{
|
|
public SldWorks SwApp { get; set; }
|
public PdmControl pdm { get; set; }
|
|
public TestWebModel(SldWorks swApp, PdmControl pdm)
|
{
|
SwApp = swApp;
|
this.pdm = pdm;
|
}
|
|
public string test(string data, int a, double b)
|
{
|
var res = pdm.RefreshBomList(SwApp.IActiveDoc2);
|
return JsonUtil.Serialize(res);
|
}
|
|
public string search(string dataStr)
|
{
|
try
|
{
|
SearchParam param = JsonUtil.Deserialize<SearchParam>(dataStr);
|
|
string sql = "Select * FROM table WHERE 1=1";
|
|
if (param.startTime != null) sql += $" AND start_time >= {param.startTime}";
|
if (param.endTime != null) sql += $" AND start_time >= {param.endTime}";
|
|
foreach (SearchItem item in param.searchItems)
|
{
|
if (!string.IsNullOrEmpty(item.value)) sql += $" AND {item.name} {item.opt} {item.value}";
|
}
|
|
// doSomething
|
return ResultData.ok(new List<Dictionary<string, string>>() {
|
new Dictionary<string, string>(){
|
{ "sql",sql}
|
}
|
});
|
}
|
catch (Exception e)
|
{
|
return ResultData.error(e.Message);
|
}
|
}
|
|
public string GetSearchItem(string itemId)
|
{
|
try
|
{
|
int len = new Random().Next(10);
|
List<SearchItem> items = new List<SearchItem>(len);
|
for (int i = 0; i < len; i++)
|
{
|
items.Add(
|
new SearchItem()
|
{
|
name = itemId + i,
|
opt = "=",
|
value = ""
|
}
|
);
|
}
|
return ResultData.ok(items).ToString();
|
}
|
catch (Exception e)
|
{
|
return ResultData.error(e.Message).ToString();
|
}
|
}
|
}
|
}
|
|
public class SearchItem
|
{
|
public string id { get; set; }
|
public string name { get; set; }
|
public string opt { get; set; }
|
public string value { get; set; }
|
}
|
|
|
public class DateTimeFormatConverter : IsoDateTimeConverter
|
{
|
public DateTimeFormatConverter(string format)
|
{
|
DateTimeFormat = format;
|
}
|
}
|
|
public class SearchParam
|
{
|
[JsonConverter(typeof(DateTimeFormatConverter), "yyyy-MM-dd HH:ss:mm")]
|
public DateTime? startTime { get; set; }
|
[JsonConverter(typeof(DateTimeFormatConverter), "yyyy-MM-dd HH:ss:mm")]
|
public DateTime? endTime { get; set; }
|
public List<SearchItem> searchItems { get; set; }
|
}
|
|
|
[ComVisible(true)]
|
public class TestData
|
{
|
public string name { get; set; }
|
}
|
