private void OnDataChange(object subscriptionhandle, object requesthandle, ItemValueResult[] values)
{
foreach (ItemValueResult value in values)
{
if (value.ClientHandle == null)
{
continue;
}
if (handle[0].Equals(value.ClientHandle))
{
this.Dispatcher.BeginInvoke((Action) delegate()
{
tbValue.Text = SafeConverter.SafeToStr(value.Value);
});
}
if (handle[1].Equals(value.ClientHandle))
{
this.Dispatcher.BeginInvoke((Action) delegate()
{
tbValue2.Text = SafeConverter.SafeToStr(value.Value);
});
}
}
}
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
string enuminfo = SafeConverter.SafeToStr(parameter);
if (string.IsNullOrEmpty(enuminfo))
{
return(value);
}
string sValue = SafeConverter.SafeToStr(value);
string sText = sValue;
string[] enuminfos = enuminfo.Split(';', '；');
foreach (var str in enuminfos)
{
string[] s = str.Split(':', '：');
if (s.Count() < 2)
{
continue;
}
if (sValue == s[0])
{
sText = s[1];
}
}
return(sText);
}
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
int result = 0;
int.TryParse(SafeConverter.SafeToStr(value), out result);
return(result + 1);
}
private async void button4_Click(object sender, RoutedEventArgs e)
{
//DelById
bool m_SysUser = (await testEfCodeFirstF.Delete(tbIn.Text));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysUser);
}
/// <summary>
/// 使用EF框架获取数据，返回DataTable
/// </summary>
/// <param name="type"></param>
/// <param name="strSql"></param>
/// <param name="parameterNames"></param>
/// <param name="parameterValues"></param>
/// <returns></returns>
public DataTable GetDataTableWithEF(Type type, string strSql, string[] parameterNames, string[] parameterValues)
{
var table = new DataTable("DataTableWithEF");
DbRawSqlQuery datas =
dbContext.Database.SqlQuery(type, strSql, DBFactory.ChangeToDbParams(parameterNames, parameterValues));
foreach (var data in datas)
{
var row = table.NewRow();
foreach (var info in type.GetProperties())
{
if (table.Rows.Count <= 0)
{
table.Columns.Add(info.Name);
}
var value = info.GetValue(data, null) ?? DBNull.Value;
row[info.Name] = SafeConverter.SafeToStr(value);
}
table.Rows.Add(row);
}
return(table);
}
private async void button2_Click(object sender, RoutedEventArgs e)
{
//GetByParam
List <SysMenuItem> m_SysMenuItem = (await sysMenuItemF.GetByParam(tbIn.Text));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysMenuItem);
}
public string GetJsonDataWithPage(string strSql, int pageIndex, int pageSize)
{
DataTable dt = GetDataTable(strSql, null, null);
DataTable newdt = dt.Copy(); //copy dt的框架
if (pageIndex > 0)
{
newdt.Clear();
int rowbegin = (pageIndex - 1) * pageSize;
int rowend = pageIndex * pageSize;
if (rowbegin < dt.Rows.Count)
{
if (rowend > dt.Rows.Count)
{
rowend = dt.Rows.Count;
}
for (int i = rowbegin; i <= rowend - 1; i++)
{
DataRow newdr = newdt.NewRow();
DataRow dr = dt.Rows[i];
foreach (DataColumn column in dt.Columns)
{
newdr[column.ColumnName] = dr[column.ColumnName];
}
newdt.Rows.Add(newdr);
}
}
}
return(SafeConverter.JsonSerializeObject(newdt));
}
private async void btnGetPage_Click(object sender, RoutedEventArgs e)
{
//GetPage
List <SysMenuItem> m_SysMenuItem = (await sysMenuItemF.GetPageData(10, 1, true, "CREATION_DATE", tbIn.Text));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysMenuItem);
}
private async void btnCount_Click(object sender, RoutedEventArgs e)
{
//GetCount
int i = (await sysMenuItemF.GetCount(tbIn.Text));
tbResult.Text = SafeConverter.JsonSerializeObject(i);
}
public string PostInventorySyn()
{
NetLog.Write("MES库存同步SAP（初始化）" + " ");
var oldBatchs = GetFDIInventorySynBacths("");
List <FDIInventorySynBacth> Batchs = new List <FDIInventorySynBacth>();
var oldMains = GetFDIInventorySyns("");
List <FDIInventorySyn> Mains = new List <FDIInventorySyn>();
foreach (var m in oldMains)
{
FDIInventorySyn main = new FDIInventorySyn();
main.CopyDataItem(m);
main.Batchs = new List <FDIInventorySynBacth>();
foreach (var d in oldBatchs.Where(c => c.ItemCode == m.ItemCode))
{
FDIInventorySynBacth detial = new FDIInventorySynBacth();
detial.CopyDataItem(d);
main.Batchs.Add(detial);
}
Mains.Add(main);
}
string jsonText = SafeConverter.JsonSerializeObject(Mains);
return(jsonText);
}
public string GetMaterialInfo(string jsMaterialInfo)
{
NetLog.Write("GetRawMaterialInfo" + " " + jsMaterialInfo);
List <FDIGetMaterialInfo> mains = new List <FDIGetMaterialInfo>();
try
{
mains = SafeConverter.JsonDeserializeObject <List <FDIGetMaterialInfo> >(jsMaterialInfo);
foreach (var main in mains)
{
var check = GetFDIGetMaterialInfos($"ItemCode = '{main.ItemCode}'");
foreach (var c in check)
{
DelFDIGetMaterialInfo(c.PKNO);
}
main.PKNO = CBaseData.NewGuid();
AddFDIGetMaterialInfo(main);
}
}
catch (Exception ex)
{
NetLog.Error("GetRawMaterialInfo error", ex);
return("error: " + ex.Message);
}
return("OK");
}
public void ConvertTest()
{
var value = SafeConverter.Convert(0, typeof(bool));
Assert.AreEqual(value.GetType(), typeof(bool));
Assert.AreEqual(value.ToString(), "False");
Assert.AreEqual(SafeConverter.Convert <bool>(0), false);
Assert.AreEqual(SafeConverter.Convert <bool>("0"), false);
Assert.AreEqual(SafeConverter.Convert <bool>("1"), true);
Assert.AreEqual(SafeConverter.Convert <int>("1"), 1);
var separator = CultureInfo.CurrentCulture.NumberFormat.CurrencyDecimalSeparator;
var stringDecimal = "1,89".Replace(".", separator).Replace(",", separator);
Assert.AreEqual(SafeConverter.Convert <double>(stringDecimal), 1.89d);
value = SafeConverter.Convert(0, typeof(string));
Assert.AreEqual(value.GetType(), typeof(string));
Assert.AreEqual(SafeConverter.Convert <int?>("1"), 1);
Assert.AreEqual(SafeConverter.Convert <int?>(null), null);
Assert.AreEqual(SafeConverter.Convert <int?>(""), null);
Assert.AreEqual(SafeConverter.Convert(null, typeof(int?)), null);
Assert.AreEqual(SafeConverter.Convert <int>(BindingFlags.Static), 8);
Assert.AreEqual(SafeConverter.Convert <BindingFlags>(8), BindingFlags.Static);
Assert.AreEqual(SafeConverter.Convert <BindingFlags>("8"), BindingFlags.Static);
}
public void BindGridView()
{
string searchStr = "SELECT PKNO, COMPANY_CODE, BELONGFUNCTION, FUNCTIONPKNO, GROUPNO, ATTACHNAME, " +
" ATTACHMANAGEMODE, ATTACHFORMATE, ATTACHSTORETYPE, ATTACHINTROD, ATTACHSTOREFILE, ISEQ, " +
" CREATED_BY, CREATION_DATE, UPDATED_BY, LAST_UPDATE_DATE, UPDATED_INTROD，ISTATE，REMARK " +
" FROM SYS_ATTACHINFO " +
" WHERE PKNO IS NOT NULL ";
if (!string.IsNullOrEmpty(BelongFunction))
{
searchStr = $" AND BELONGFUNCTION = {BelongFunction}";
}
if (!string.IsNullOrEmpty(FunctionPKNO))
{
searchStr += $" AND FUNCTIONPKNO = {FunctionPKNO}";
}
if (!string.IsNullOrEmpty(GroupNo))
{
searchStr += $" AND GROUPNO = {GroupNo}";
}
searchStr += " ORDER BY FUNCTIONPKNO, GROUPNO, ISEQ";
DataSet ds = wsSQL.UseService(s => s.GetDataSet(searchStr, null, null));
sysAttachInfos = SafeConverter.DataSetToModel <SysAttachInfo>(ds);
gridView.ItemsSource = sysAttachInfos;
}
/// <summary>
/// 使用EF框架获取第一行第一列数据
/// </summary>
/// <param name="strSql"></param>
/// <param name="parameterNames"></param>
/// <param name="parameterValues"></param>
/// <returns></returns>
public List <string> GetFirstRowWithEF(Type type, string strSql, string[] parameterNames, string[] parameterValues)
{
List <string> result = new List <string>();
if (type == null)
{
return(result);
}
DbRawSqlQuery datas = dbContext.Database.SqlQuery(type, strSql, DBFactory.ChangeToDbParams(parameterNames, parameterValues));
foreach (var data in datas)
{
foreach (var info in type.GetProperties())
{
var value = info.GetValue(data, null) ?? DBNull.Value;
result.Add(SafeConverter.SafeToStr(value));
}
return(result);
}
return(result);
}
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
if (value == null)
{
return("");
}
string[] operates = SafeConverter.SafeToStr(parameter).Split(' '); //字段 + 字段
if (operates.Count() < 3)
{
return("");
}
string field1 = operates[0];
string operate = operates[1];
string field2 = operates[2];
string value1 = "";
string value2 = "";
PropertyInfo propertyInfo1 = value.GetType().GetProperty(field1);
if (propertyInfo1 != null)
{
value1 = SafeConverter.SafeToStr(propertyInfo1.GetValue(value, null));
}
PropertyInfo propertyInfo2 = value.GetType().GetProperty(field2);
if (propertyInfo2 != null)
{
value2 = SafeConverter.SafeToStr(propertyInfo2.GetValue(value, null));
}
string operate2 = "";
string value3 = "";
if (operates.Count() == 5)
{
operate2 = operates[1];
string field3 = operates[2];
PropertyInfo propertyInfo3 = value.GetType().GetProperty(field3);
if (propertyInfo3 != null)
{
value3 = SafeConverter.SafeToStr(propertyInfo3.GetValue(value, null));
}
}
DataTable dt = new DataTable("ColumnOperateConverter");
try
{
return(dt.Compute(value1 + operate + value2 + operate2 + value3, ""));//将运算字符串转换成表达式运算
}
catch (Exception)
{
return("");
}
}
private void BarEditItem8_OnEditValueChanged(object sender, RoutedEventArgs e)
{
//显示
string value = (sender as BarEditItem).EditValue.ToString();
if (cvMain != null)
{
cvMain.ShowGrid = SafeConverter.SafeToBool(value);
}
}
private void OutBound_OnSelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (SafeConverter.SafeToStr(cmbOutBound.SelectedValue) == "1") //机床
{
cmbOutPos.ItemsSource = ws.UseService(s => s.GetAmAssetMasterNs("USE_FLAG = 1"));
}
else
{
cmbOutPos.ItemsSource = null;
}
}
public static void CopyDeepDataItem <S, T>(this T target, S source, Expression <Func <T, object> > expressKey = null)
{
foreach (var sourceProperty in source.GetType().GetProperties())
{
PropertyInfo item = target.GetType().GetProperty(sourceProperty.Name);
if (item != null && item.DeclaringType.Equals(target.GetType()))
{
item.SetValue(target, SafeConverter.SafeToObject(item.PropertyType, sourceProperty.GetValue(source, null)), null);
}
}
}
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
if (value == null)
{
return("");
}
string formate = SafeConverter.SafeToStr(parameter);
string sValue = SafeConverter.SafeToStr(value, formate);
return(sValue);
}
public bool Add([FromBody] string obj)
{
try
{
T t = SafeConverter.JsonDeserializeObject <T>(obj);
return(Bll.Add(t));
}
catch
{
return(false);
}
}
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
string[] parameters = SafeConverter.SafeToStr(parameter).Split(';', '；'); //外键表名称;关联外键表字段;外键表显示字段名
string sValue = SafeConverter.SafeToStr(value);
if ((parameters.Count() < 3) || (string.IsNullOrEmpty(sValue)))
{
return(sValue);
}
string sText = LoadingStr;
if (!bBackgroundGetValue) //尚未开启后台获取数据
{
bBackgroundGetValue = true;
ThreadPool.QueueUserWorkItem(s =>
{
while (!CBaseData.AppClosing)
{
DateTime synchroTime = DateTime.Now.AddSeconds(GetValueSpan);
try
{
List <CacheData> cacheDatas =
CacheDatas.Where(c => c.LastSynchroTime <= synchroTime)
.OrderByDescending(c => c.LastSynchroTime).ToList(); //按照上次更新的时间逆序排序
foreach (var cacheData in cacheDatas)
{
cacheData.RefreshDataFromDB(); //刷新数据
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
Thread.Sleep(10);
}
});//开启后台提取数据
}
sText = GetValueByTableField(parameters, sValue);
if ((sText == sValue) && (Guid.TryParse(sText, out _)))
{
sText = "";
}
return(sText);
}
private void BarEditItem7_OnEditValueChanged(object sender, RoutedEventArgs e)
{
string value = SafeConverter.SafeToStr((sender as BarEditItem).EditValue);
if (string.IsNullOrEmpty(value))
{
return;
}
foreach (DragThumb thumb in cvMain.SelectDragThumbs)
{
thumb.MonitorItem = SafeConverter.SafeToBool(value);
}
}
private void BarEditItem_OnEditValueChanged(object sender, RoutedEventArgs e)
{
string value = SafeConverter.SafeToStr((sender as BarEditItem).EditValue);
if (string.IsNullOrEmpty(value))
{
return;
}
if (cvMain.CurSelectedDragThumb != null)
{
cvMain.CurSelectedDragThumb.CtrlName = value;
}
}
public float GetFloat(int i)
{
var value = GetValue(i);
if (value != null)
{
float num;
if (float.TryParse(value.ToString(), NumberStyles.Any, CultureInfo.InvariantCulture.NumberFormat, out num))
{
return(num);
}
}
return(SafeConverter.Convert <float>(value));
}
private void BarEditItem3_OnEditValueChanged(object sender, RoutedEventArgs e)
{
string value = SafeConverter.SafeToStr((sender as BarEditItem).EditValue);
if (string.IsNullOrEmpty(value))
{
return;
}
foreach (DragThumb thumb in cvMain.SelectDragThumbs)
{
thumb.Position = new Point(thumb.Position.X, double.Parse(value));
}
}
public double GetDouble(int i)
{
var value = GetValue(i);
if (value != null)
{
double num;
if (double.TryParse(value.ToString(), NumberStyles.Any, CultureInfo.InvariantCulture.NumberFormat, out num))
{
return(num);
}
}
return(SafeConverter.Convert <double>(value));
}
public static void CopyDataItem <S, T>(this T target, S source, List <string> skipNames)
{
foreach (var sourceProperty in source.GetType().GetProperties())
{
if (skipNames.Contains(sourceProperty.Name))
{
continue;
}
PropertyInfo item = target.GetType().GetProperty(sourceProperty.Name);
if (sourceProperty.DeclaringType.Equals(source.GetType()) && item != null)
{
item.SetValue(target, SafeConverter.SafeToObject(item.PropertyType, sourceProperty.GetValue(source, null)), null);
}
}
}
private async void button3_Click(object sender, RoutedEventArgs e)
{
//Add
TestEFCodeFirst test = new TestEFCodeFirst()
{
PKNO = tbIn.Text,
USER_NAME = "Test1",
PASSWORD = "******",
};
string value = SafeConverter.JsonSerializeObject(test);
TestEFCodeFirst test2 = SafeConverter.JsonDeserializeObject <TestEFCodeFirst>(value);
bool m_SysUser = (await testEfCodeFirstF.Add(test));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysUser);
}
/// <summary>
/// 将文件转换为byte数组
/// </summary>
/// <param name="path">文件地址</param>
/// <returns>转换后的byte数组</returns>
public static byte[] FileToBytes(string path)
{
if (!System.IO.File.Exists(path))
{
return(new byte[0]);
}
FileInfo fi = new FileInfo(path);
byte[] buff = new byte[fi.Length];
FileStream fs = fi.OpenRead();
fs.Read(buff, 0, SafeConverter.SafeToInt(fs.Length));
fs.Close();
return(buff);
}
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
if (value == null)
{
return(Visibility.Collapsed);
}
string checkValue = SafeConverter.SafeToStr(parameter);
if (string.IsNullOrEmpty(checkValue)) //没有参数
{
return(SafeConverter.SafeToBool(value) ? Visibility.Visible : Visibility.Collapsed);
}
else
{
string sValue = SafeConverter.SafeToStr(value);
List <string> checks = checkValue.Split(';').ToList();
return((checks.Contains(sValue)) ? Visibility.Visible : Visibility.Collapsed);
}
}
