protected void btSave_Click(object sender, EventArgs e) { ProduceBOM info = new ProduceBOM(); ProduceDOMBLL bll = null; try { UIBindHelper.BindModelByControls(this.Page, info); bll = BLLFactory.CreateBLL <ProduceDOMBLL>(); info.Details = JsonConvertHelper.DeserializeObject <List <BOMDetail> >(this.hiBomDetailList.Value); if (this.hiID.Value == "") { bll.Insert(info); } else { info.CREATEUSER = this.HiCREATEUSER.Value; info.CREATETIME = DateTime.Parse(this.HiCREATETIME.Value); info.PID = this.hiID.Value; bll.Update(info); } ClientScript.RegisterStartupScript(this.GetType(), "myjs", "parent.refreshData();parent.closeAppWindow1();", true); } catch (Exception ex) { throw ex; } }
protected virtual async Task <List <TModel> > Query(string key = "") { string queryUri = $"{ConfigHelper.WebAPIAddress}/{this.ModelType.Name}/Query?key={key}"; LogHelper <TModel> .Debug($"查询地址:{queryUri}"); try { using (var response = await WebHelper.GetAsync(queryUri)) { LogHelper <TModel> .Debug($"接收到响应数据,状态代码:{response.StatusCode}"); if (response.IsSuccessStatusCode) { string content = await response.Content.ReadAsStringAsync(); var models = JsonConvertHelper.DeserializeObject <List <TModel> >(content); LogHelper <TModel> .Debug($"接收到 {models.Count} 条数据。"); return(models); } else { return(default);
protected void btSave_Click(object sender, EventArgs e) { SupplyInfo info = new SupplyInfo(); SupplyInfoBLL bll = null; try { UIBindHelper.BindModelByControls(this.Page, info); bll = BLLFactory.CreateBLL <SupplyInfoBLL>(); info.Details = JsonConvertHelper.DeserializeObject <List <SupplyMaterialInfo> >(this.hiMaterialList.Value); info.BATCHNUMBER = this.PLANID.SelectedItem.Text; if (this.hiID.Value == "") { bll.Insert(info); } else { info.CREATEUSER = this.HiCREATEUSER.Value; info.CREATETIME = DateTime.Parse(this.HiCREATETIME.Value); info.PID = this.hiID.Value; info.PLANID = this.hiPlanID.Value; info.PLName = this.PLNAME.Text; bll.Update(info); } ClientScript.RegisterStartupScript(this.GetType(), "myjs", "parent.refreshData();parent.closeAppWindow1();", true); } catch (Exception ex) { throw ex; } }
public void TestUpdateAppliedMigrationsExistingPrefix() { _rabbitMqHistory.Init(); SetupDefaultExchange(); PushDummyMigrationHistoryMessage(); var migrationHistoryRow = new MigrationHistoryRow { Prefix = "test" }; migrationHistoryRow.AppliedMigrations.Add(new MigrationHistoryRowDetails { Name = "001_TestMigration" }); migrationHistoryRow.AppliedMigrations.Add(new MigrationHistoryRowDetails { Name = "002_TestMigrationAddQueue" }); _rabbitMqHistory.UpdateAppliedMigrations(migrationHistoryRow); using (var connection = _connectionFactory.CreateConnection()) using (var channel = connection.CreateModel()) { var message = channel.BasicGet(Constants.HistoryQueue, true); Assert.IsNotNull(message); var migrationHistory = JsonConvertHelper.DeserializeObject <MigrationHistory>(message.Body); Assert.IsNotNull(migrationHistory); Assert.AreEqual(1, migrationHistory.AllMigrations.Count); var migration = migrationHistory.AllMigrations.First(); Assert.AreEqual("test", migration.Prefix); Assert.AreEqual(2, migration.AppliedMigrations.Count); CollectionAssert.AreEqual(migrationHistoryRow.AppliedMigrations.ToList(), migration.AppliedMigrations.ToList(), new AppliedMigrationsComparer()); } }
/// <summary> /// 确认 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btConfirm_Click(object sender, EventArgs e) { CheckStockBill info = new CheckStockBill(); CheckStockBLL bll = null; try { UIBindHelper.BindModelByControls(this.Page, info); bll = BLLFactory.CreateBLL <CheckStockBLL>(); info.Details = JsonConvertHelper.DeserializeObject <List <CheckStockDetail> >(this.hiCheckList.Value); info.CREATEUSER = this.HiCREATEUSER.Value; info.CREATETIME = DateTime.Parse(this.HiCREATETIME.Value); info.ID = this.hiID.Value; bll.ConfirmCheck(info); ClientScript.RegisterStartupScript(this.GetType(), "myjs", "parent.refreshData();parent.closeAppWindow1();", true); } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> Add([FromForm] string value) { if (string.IsNullOrWhiteSpace(value)) { this.logger.LogWarning($"{this.HttpContext.Connection.RemoteIpAddress} 请求新增空数据的 {typeof(TModel).Name} 对象"); return(this.StatusCode(StatusCodes.Status422UnprocessableEntity)); } try { var model = JsonConvertHelper.DeserializeObject <TModel>(value); if (model == null) { this.logger.LogWarning($"{this.HttpContext.Connection.RemoteIpAddress} 请求新增的数据转义为 {typeof(TModel).Name} 对象为空引用"); return(this.StatusCode(StatusCodes.Status422UnprocessableEntity)); } await this.context.Set <TModel>().AddAsync(model); await this.context.SaveChangesAsync(); this.logger.LogDebug($"{this.HttpContext.Connection.RemoteIpAddress} 请求新增 ID 为 {model.ID} 的 {typeof(TModel).Name} 对象"); return(this.StatusCode(StatusCodes.Status201Created, model.ID)); } catch (Exception ex) { this.logger.LogError(ex, $"{this.HttpContext.Connection.RemoteIpAddress} 请求新增 {typeof(TModel).Name} 对象遇到异常"); return(this.StatusCode(StatusCodes.Status417ExpectationFailed, ex.Message)); } }
/// <summary> /// 获取列表 /// </summary> /// <param name="tableName"></param> /// <returns></returns> public static List <TableModel> GetListTable() { string filepath = "table.json"; string json = JsonHelper.GetFile(filepath); List <TableModel> tableModels = JsonConvertHelper.DeserializeObject <List <TableModel> >(json) as List <TableModel>; return(tableModels); }
public async Task <User> Get() { HttpRequestItem httpRequestItem = new HttpRequestItem() { Url = Url, HttpMethod = HttpMethod.Get, AuthHeaderValue = new AuthenticationHeaderValue("Bearer", AccessToken) }; HttpResponseMessage httpResponseMessage = await _requestHandler.RequestAsync(httpRequestItem); string content = await httpResponseMessage.Content.ReadAsStringAsync(); User user = JsonConvertHelper.DeserializeObject <User>(content); return(user); }
public async Task <Expense> Get(int expenseId) { HttpRequestItem httpRequestItem = new HttpRequestItem() { Url = "https://api.toshl.com/expenses/" + expenseId, HttpMethod = HttpMethod.Get, AuthHeaderValue = new AuthenticationHeaderValue("Bearer", AccessToken) }; HttpResponseMessage httpResponseMessage = await _requestHandler.RequestAsync(httpRequestItem); string content = await httpResponseMessage.Content.ReadAsStringAsync(); Expense expense = JsonConvertHelper.DeserializeObject <Expense>(content); return(expense); }
private static MigrationHistory EnsureLatestMigrationHistoryVersion(string migrationHistoryJson) { var migrationHistory = JsonConvertHelper.DeserializeObject <GenericMigrationHistory>(migrationHistoryJson); switch (migrationHistory.Version) { case 1: // v1 uses the default JSON Serializer settings var migrationHistoryV1 = JsonConvert.DeserializeObject <Objects.v1.MigrationHistory>(migrationHistoryJson); return(MigrationHistoryUpgradeHelper.UpgradeToV2(migrationHistoryV1)); case 2: return(JsonConvertHelper.DeserializeObject <MigrationHistory>(migrationHistoryJson)); default: throw new RabbitMqMigrationException($"Invalid RabbitMq History version {migrationHistory.Version}"); } }
public async Task <User> Put(User user) { HttpRequestItem httpRequestItem = new HttpRequestItem() { Url = Url, HttpMethod = HttpMethod.Put, AuthHeaderValue = new AuthenticationHeaderValue("Bearer", AccessToken), HttpContent = new FormUrlEncodedContent(JsonConvertHelper.SerializeToDictionary(user)), IfUnmodifiedSinceHeader = new DateTime(2014, 08, 02) }; HttpResponseMessage httpResponseMessage = await _requestHandler.RequestAsync(httpRequestItem); string content = await httpResponseMessage.Content.ReadAsStringAsync(); User updatedUser = JsonConvertHelper.DeserializeObject <User>(content); return(updatedUser); }
protected void btSave_Click(object sender, EventArgs e) { OutStockBill info = new OutStockBill(); OutStockBLL bll = null; string result = null; try { UIBindHelper.BindModelByControls(this.Page, info); bll = BLLFactory.CreateBLL <OutStockBLL>(); info.Details = JsonConvertHelper.DeserializeObject <List <OutStockDetail> >(this.hiMatList.Value); if (this.hiID.Value == "") { result = bll.OutStorage(info); } else { info.CREATEUSER = this.HiCREATEUSER.Value; info.CREATETIME = DateTime.Parse(this.HiCREATETIME.Value); info.ID = this.hiID.Value; bll.Update(info); } if (string.IsNullOrEmpty(result) == true) { ClientScript.RegisterStartupScript(this.GetType(), "myjs", "parent.refreshData();parent.closeAppWindow1();", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "myjs", "MSI('提示','" + result + "');", true); } } catch (Exception ex) { throw ex; } }
private async Task <OAuthToken> RequestToken(Dictionary <string, string> requestContent) { HttpClientHandler handler = new HttpClientHandler(); HttpClient client = new HttpClient(handler); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue( "Basic", Convert.ToBase64String( Encoding.GetEncoding("ISO-8859-1").GetBytes( string.Format("{0}:{1}", ToshlClient.Id, ToshlClient.Secret)))); HttpRequestMessage httpRequest = new HttpRequestMessage() { RequestUri = new Uri("https://toshl.com/oauth2/token"), Method = HttpMethod.Post, Content = new FormUrlEncodedContent(requestContent) }; HttpResponseMessage httpResponseMessage = await client.SendAsync(httpRequest); string content = await httpResponseMessage.Content.ReadAsStringAsync(); Dictionary <string, dynamic> dict = JsonConvertHelper.DeserializeObject <Dictionary <string, dynamic> >(content); OAuthToken oAuthToken = new OAuthToken() { AccessToken = dict["access_token"], TokenType = dict["token_type"], ExpiresIn = dict["expires_in"], RefreshToken = dict["refresh_token"], Scope = dict["scope"] }; return(oAuthToken); }
/// <summary> /// 保存采集数据 /// </summary> /// <param name="value"></param> /// <returns></returns> public bool saveItemAndCalResultData(string dataStr, string resDataStr) { int count = 0; List <InspectItemData> itemList = JsonConvertHelper.DeserializeObject <List <InspectItemData> >(dataStr); List <InspectRealTimeItemData> realTimeItemList = JsonConvertHelper.DeserializeObject <List <InspectRealTimeItemData> >(dataStr); List <InspectResultData> culResultList = JsonConvertHelper.DeserializeObject <List <InspectResultData> >(resDataStr); //用于事务处理 using (IDataSession session = AppDataFactory.CreateMainSession()) { try { //插入基本信息 count = session.Insert <InspectItemData>(itemList); foreach (InspectRealTimeItemData irti in realTimeItemList) { List <DataParameter> dataParameter = new List <DataParameter>(); dataParameter.Add(new DataParameter { ParameterName = "DeviceSN", DataType = DbType.String, Value = irti.DeviceSN }); dataParameter.Add(new DataParameter { ParameterName = "ItemCode", DataType = DbType.String, Value = irti.ItemCode }); //更新实时记录表 int updCount = Convert.ToInt32(session.ExecuteSqlScalar("select count(0) from inspectrealtimedata where DeviceCode = @DeviceSN and ItemCode = @ItemCode ", dataParameter.ToArray())); //如果返回数据为0说明记录不存在则插入一条新的记录 if (updCount == 0) { session.Insert(irti); } else { //更新值 dataParameter.Add(new DataParameter { ParameterName = "InspectTime", DataType = DbType.DateTime, Value = irti.InspectTime }); dataParameter.Add(new DataParameter { ParameterName = "InspectData", DataType = DbType.String, Value = irti.InspectData }); dataParameter.Add(new DataParameter { ParameterName = "UpdateTime", DataType = DbType.DateTime, Value = irti.UpdateTime }); session.ExecuteSqlScalar("update inspectrealtimedata set InspectTime = @InspectTime, InspectData = @InspectData, UpdateTime = @UpdateTime where DeviceCode = @DeviceSN and ItemCode = @ItemCode ", dataParameter.ToArray()); } } //测试时使用否则插入同一张表中数据会主键冲突 foreach (InspectResultData ird in culResultList) { List <DataParameter> dataParameter = new List <DataParameter>(); dataParameter.Add(new DataParameter { ParameterName = "ID", DataType = DbType.String, Value = ird.ID }); int dataCount = Convert.ToInt32(session.ExecuteSqlScalar("select count(0) from inspectcalcresult where ID = @ID ", dataParameter.ToArray())); //如果返回数据为0说明记录不存在则插入一条新的记录 if (dataCount == 0) { count += session.Insert(ird); } else { count += session.Update(ird); } } } catch (Exception ex) { Console.WriteLine(ex.Message); //保存出错时回滚数据 session.RollbackTs(); return(false); } } return(true); }