static void Main(string[] args) { Logrila.Logging.NLogIntegration.NLogLogger.Use(); Logrila.Logging.ILog _log = Logger.Get <Program>(); _log.Warn("测试!"); var db = DBContextFactory.Instance.CreateContext("IRAPContext"); IRAPParameterEntity p = new IRAPParameterEntity() { PartitioningKey = 0, ParameterID = 1 , ParameterNameID = 1, ParameterValue = 12, ParameterValueStr = "test", TimeUpdated = DateTime.Now, UpdatedBy = "admin" }; //db.Set<IRAPParameterEntity>().Attach(p); db.Entry(p).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); // var list= db.Set<ETreeBizClass>().Where(c => c.LeafID == 2361480).ToList(); // IRAPTreeModelSet treemodelSet = new IRAPTreeModelSet(); // treemodelSet.CreateATree(206, "保养周期目录树", 1000, 5, true, 2, "", "", 1, "", "", true, false, false, false, 1); //throw new Exception("Error!"); // var list2 = from a in list group a by a.LeafID into g select new { g.Key,items=g }; //foreach (var r in list) //{ // Console.WriteLine("{0} {1}", r.TreeID,r.Leaf01); //} Console.WriteLine("saved."); Console.ReadKey(); }
/// <summary> /// 新增参数 /// </summary> /// <remarks>本方法需要在序列服务器中配置NextParameterID序列</remarks> /// <param name="communityID">社区标识</param> /// <param name="paramName">参数名称</param> /// <param name="paramValue">参数值(整型)</param> /// <param name="paramStrValue">参数值(字符串)</param> /// <param name="sysLogID">系统登录标识</param> /// <param name="paramID">输出参数,新增参数的参数标识</param> /// <returns>IRAP系统通用错误对象,如果其中的ErrCode:0-执行成功;非0执行失败</returns> public IRAPError Add( int communityID, string paramName, int paramValue, string paramStrValue, long sysLogID, out int paramID) { IRAPError rlt = new IRAPError(); paramID = 0; LoginEntity loginInfo = null; try { IRAPLog loginSet = new IRAPLog(); loginInfo = loginSet.GetLogin(communityID, sysLogID); if (loginInfo == null) { loginInfo = new LoginEntity() { UserCode = "Unknown", LanguageID = 30, }; } } catch (Exception error) { if (error.InnerException.InnerException != null) { rlt.ErrText = $"获取登录信息发生异常:" + $"{error.InnerException.InnerException.Message}"; } else { rlt.ErrText = $"获取登录信息发生异常:{error.Message}"; } rlt.ErrCode = 9999; return(rlt); } IIRAPNamespaceSet namespaceSet = IRAPNamespaceSetFactory.CreatInstance(Enums.NamespaceType.Sys); rlt = namespaceSet.Add( communityID, paramName, loginInfo.LanguageID, out int nameID); if (rlt.ErrCode != 0) { return(rlt); } rlt = RequestParameterID(out paramID); if (rlt.ErrCode != 0) { return(rlt); } IRAPParameterEntity entity = new IRAPParameterEntity() { ParameterID = (byte)paramID, ParameterNameID = nameID, PartitioningKey = communityID * 10000, ParameterValue = paramValue, ParameterValueStr = paramStrValue, UpdatedBy = loginInfo.UserCode, TimeUpdated = DateTime.Now, }; try { irapParams.Insert(entity); irapParams.SaveChanges(); rlt.ErrCode = 0; rlt.ErrText = "参数新增成功"; } catch (Exception error) { rlt.ErrCode = 9999; if (error.InnerException.InnerException != null) { rlt.ErrText = $"新增参数发生异常:" + $"{error.InnerException.InnerException.Message}"; } else { rlt.ErrText = $"新增参数发生异常:{error.Message}"; } } return(rlt); }