public async Task <IActionResult> Get(string id) { if (string.IsNullOrWhiteSpace(id)) { this.logger.LogWarning($"{this.HttpContext.Connection.RemoteIpAddress} 请求查询空 ID 的 {typeof(TModel).Name} 数据"); return(this.StatusCode(StatusCodes.Status406NotAcceptable)); } try { var model = await this.context.Set <TModel>().FindAsync(id); if (model == null) { this.logger.LogWarning($"{this.HttpContext.Connection.RemoteIpAddress} 请求查询 ID 不存在的 {typeof(TModel).Name} 数据"); return(this.StatusCode(StatusCodes.Status406NotAcceptable)); } else { this.logger.LogDebug($"{this.HttpContext.Connection.RemoteIpAddress} 请求查询 ID 为 {id} 的 {typeof(TModel).Name} 数据"); return(this.Content(JsonConvertHelper.SerializeObject(model))); } } catch (Exception ex) { this.logger.LogError(ex, $"{this.HttpContext.Connection.RemoteIpAddress} 请求查询 ID 为 {id} 的 {typeof(TModel).Name} 数据遇到异常"); return(this.StatusCode(StatusCodes.Status417ExpectationFailed, ex.Message)); } }
public string ReadStatus() { JArray Monthstatusjarr = JArray.Parse(this._MonthstatusStr); Dictionary <string, ListStatusByFac> MonthstatusObj = BuildMonthObj(Monthstatusjarr); return(JsonConvertHelper.SerializeObject(MonthstatusObj)); }
public async Task <OAuthToken> RefreshToken(string refreshToken) { Dictionary <string, string> contentDict = new Dictionary <string, string>() { { "grant_type", "refresh_token" }, { "refresh_token", refreshToken } }; string requestContent = JsonConvertHelper.SerializeObject(contentDict); OAuthToken oAuthToken = await RequestToken(contentDict); return(oAuthToken); }
public IActionResult Query(string key) { this.logger.LogDebug($"{this.HttpContext.Connection.RemoteIpAddress} 请求查询所有 {typeof(TModel).Name} 数据,关键字 = {key}"); var enumerable = this.context.Set <TModel>().AsEnumerable(); if (!string.IsNullOrWhiteSpace(key)) { enumerable = this.CreateQueryPerdicate(enumerable, key); } var models = enumerable.ToList(); return(this.Content(JsonConvertHelper.SerializeObject(models))); }
public override void Update(ModelType model) { try { if (model == null) { throw new ArgumentNullException("model"); } this.DbContext.SaveChanges(); } catch { EIMLog.Logger.Error("DataProvider Update Error:" + JsonConvertHelper.SerializeObject(model)); throw; } }
public async Task <OAuthToken> GetAccessToken(string callbackUrl) { //TODO hasn't handled error issue Uri uri = new Uri(callbackUrl); HttpValueCollection queryString = HttpUtility.ParseQueryString(uri.Query); string callbackCode = queryString["code"]; Dictionary <string, string> contentDict = new Dictionary <string, string>() { { "code", callbackCode }, { "grant_type", "authorization_code" } }; string requestContent = JsonConvertHelper.SerializeObject(contentDict); OAuthToken oAuthToken = await RequestToken(contentDict); return(oAuthToken); }
public static string AnalyseCheckInfo(string jsonobj) { List <CheckInfoListbyFac> Slist = new List <CheckInfoListbyFac>(); JArray SceInsList = JArray.Parse(jsonobj); foreach (JObject i in SceInsList) { CheckInfoDetail newinfo = new CheckInfoDetail(i["时间"].ToString(), i["车间"].ToString(), i["合格"].ToString(), i["详情"].ToString(), i["Id"].ToString()); int hasname = Slist.FindIndex(delegate(CheckInfoListbyFac sch) { return(sch.Name == newinfo.Fac); }); if (hasname == -1) //新的车间 { CheckInfoListbyFac newfac = new CheckInfoListbyFac(); newfac.InfoList.Add(newinfo); Slist.Add(newfac); } else { Slist[hasname].InfoList.Add(newinfo); } } return(JsonConvertHelper.SerializeObject(Slist)); }
public string CreateStatus() { string DBcommand; string source = ConfigurationManager.ConnectionStrings["EPInfoSys"].ConnectionString.ToString(); JArray Monthstatusjarr = JArray.Parse(this._MonthstatusStr); Dictionary <string, ListStatusByFac> MonthstatusObj = BuildMonthObj(Monthstatusjarr); string ListRulesStr = this.ReadRules(); JArray LRulesObj = JArray.Parse(ListRulesStr); foreach (JObject Ruleobj in LRulesObj) { //看Monthstatus有没有这个规则结果。如果有,那么更新则使用update语句,如果没有这个Id的规则结果,则使用insert语句 string ObjFactory = Ruleobj["车间"].ToString(); string ObjTime = this._Time; string KeyStr = ObjFactory + "|" + ObjTime; string Objid = Ruleobj["RuleId"].ToString(); int hasrule; if (MonthstatusObj.ContainsKey(KeyStr)) { hasrule = MonthstatusObj[KeyStr].Factory_List_Status.FindIndex(delegate(ListStatusbyRule sch) { return(sch.RuleId == Objid); }); } else { hasrule = -1; } //不管有没有这个规则,都需要先实例化由rule生成的规则结果类,以录入或覆盖原来的规则 ListStatusbyRule newLStatu = new ListStatusbyRule(Ruleobj["RuleId"].ToString(), ObjTime, ObjFactory, Ruleobj["项目"].ToString(), Ruleobj["规则"].ToString(), float.Parse(((JValue)Ruleobj["阀值"]).Value.ToString()), true); newLStatu.GetCValueFromDB(); newLStatu.ListValue = newLStatu.SetListValue(); int ifauto; int lvalue; if (newLStatu.IfAuto) { ifauto = 1; } else { ifauto = 0; } if (newLStatu.ListValue) { lvalue = 1; } else { lvalue = 0; } if (hasrule == -1) //没有这个规则 { if (MonthstatusObj.ContainsKey(KeyStr)) //有车间无规则,直接在车间里面加这个规则 { MonthstatusObj[KeyStr].Factory_List_Status.Add(newLStatu); } else //规则车间都没有 { ListStatusByFac newfac = new ListStatusByFac(ObjFactory, ObjTime); newfac.Factory_List_Status.Add(newLStatu); MonthstatusObj.Add(KeyStr, newfac); } DBcommand = @"INSERT INTO [EPInfoSystem].[dbo].[ListStatus] ([时间] ,[车间] ,[项目] ,[RuleId] ,[规则类] ,[阀值] ,[采集值] ,[自动] ,[挂牌]) VALUES ('" + this._Time + @"' ,'" + ObjFactory + @"' ,'" + newLStatu.Type + @"' ,'" + newLStatu.RuleId + @"' ,'" + newLStatu.RuleType + @"' ,'" + newLStatu.ThresHold + @"' ,'" + newLStatu.CollectionValue + @"' ," + ifauto + @" ," + lvalue + @" )" ; } else //有这个规则,修改Month类中的这个规则,然后使用update语句而不是insert { MonthstatusObj[KeyStr].Factory_List_Status[hasrule] = newLStatu; DBcommand = @" UPDATE [EPInfoSystem].[dbo].[ListStatus] SET [车间] = '" + ObjFactory + @"' ,[项目] = '" + newLStatu.Type + @"' ,[规则类] = '" + newLStatu.RuleType + @"' ,[阀值] = " + newLStatu.ThresHold + @" ,[采集值] =" + newLStatu.CollectionValue + @" ,[自动] = " + ifauto + @" ,[挂牌] = " + lvalue + @" WHERE [时间] ='" + this._Time + "'AND [RuleId]=" + newLStatu.RuleId; } DBOper dbcom = new DBOper(source, DBcommand); string _ret = dbcom.ReturnRows(); } return(JsonConvertHelper.SerializeObject(MonthstatusObj)); }