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