public object Post([FromBody] DDStepDefineEntity ProcessInfo) { var db = SqlSugarFactory.GetInstance(); var processDefineGuid = Guid.NewGuid().ToString(); ProcessInfo.StepModuleList.ForEach(item => { item.StepDefinitionGuid = Guid.NewGuid().ToString(); item.ProcessDefinitionGuid = processDefineGuid; }); ProcessInfo.StepRelationModuleList.ForEach(item => { item.RelationDefinitionGuid = Guid.NewGuid().ToString(); item.ProcessDefinitionGuid = processDefineGuid; }); db.Ado.BeginTran(); try { var count1 = db.Insertable(ProcessInfo.StepModuleList).ExecuteCommand(); var count2 = db.Insertable(ProcessInfo.StepRelationModuleList).ExecuteCommand(); db.Ado.CommitTran(); } catch (Exception ex) { db.Ado.RollbackTran(); return(new ResponseError(ex.StackTrace, ResultCode.ApiManagerNetworkError)); } //SqlSugarFactory.GetInstance().Insertable(entity).ExecuteReturnEntity() //var y=JsonConvert.DeserializeObject<DDStepDefineEntity>(x); return(new ResponseSucess()); }
public object Post([FromBody] DdFormModuleEntity entity) { if (string.IsNullOrWhiteSpace(entity.Layout)) { return(new ResponseError("提交表单模板数据不能为空。", ResultCode.NoRelation)); } if (entity.Id == null || Guid.Empty.Equals(entity.Id)) { entity.Id = Guid.NewGuid(); } var executedEntity = SqlSugarFactory.GetInstance().Insertable(entity).ExecuteReturnEntity(); return(new ResponseSucess(executedEntity)); }
public async static Task DownloadData() { NLog.LogManager.GetCurrentClassLogger().Info("Download covid19 Data begin"); var db = SqlSugarFactory.CreateSqlSugarClient(); var url = await getPath(); if (string.IsNullOrEmpty(url)) { return; } var sql = "truncate table dbo.covid19"; await db.Ado.ExecuteCommandAsync(sql); using (var httpClient = new HttpClient()) { httpClient.Timeout = TimeSpan.FromMinutes(60); var response = await httpClient.GetAsync(url); var items = await response.Content.ReadAsAsync <dynamic>(); foreach (var item in items) { var country = (string)item["Country/Region"]; var province = (string)item["Province/State"]; var dt = DateTime.Parse((string)item.Date); var latitude = (decimal)item["Lat"]; var longitude = (decimal)item["Long"]; var confirmed = (int)((string)item.Confirmed is null ? 0 : item.Confirmed); var deaths = (int)((string)item.Deaths is null ? 0 : item.Deaths); var recovered = (int)((string)item.Recovered is null ? 0 : item.Recovered); await db.Ado.UseStoredProcedure().ExecuteCommandAsync("[dbo].[SP_InsertCovids19]", new { date = dt, country = country, province = province, latitude = latitude, longitude = longitude, confirmed = confirmed, deaths = deaths, recovered = recovered, }); } // Now parse with JSON.Net } NLog.LogManager.GetCurrentClassLogger().Info("Download covid19 Data completed"); }
public object Get(string formGuid) { var cache = new MemoryCacheService(); var formEntiy = (DdFormModuleEntity)cache.Get(formGuid); if (formEntiy == null) { //构建一个虚拟的业务对象结构 var bizObj = new DDBizObjectEntity(); bizObj.Name = "成本管理_合同变更审批"; bizObj.FieldList = new List <DDBizObjectItem>() { new DDBizObjectItem() { Name = "用户名称", DataType = "text", }, new DDBizObjectItem() { Name = "备注", DataType = "text", }, new DDBizObjectItem() { Name = "性别", DataType = "text", }, new DDBizObjectItem() { Name = "婚姻状态", DataType = "text", }, new DDBizObjectItem() { Name = "性格描述", DataType = "text", }, new DDBizObjectItem() { Name = "年龄", DataType = "number", }, new DDBizObjectItem() { Name = "出生日期", DataType = "datetime", }, new DDBizObjectItem() { Name = "github地址", DataType = "text", }, new DDBizObjectItem() { Name = "审批意见", DataType = "text", }, new DDBizObjectItem() { Name = "说明文字", DataType = "text", }, new DDBizObjectItem() { Name = "期望薪资", DataType = "number", }, new DDBizObjectItem() { Name = "年龄", DataType = "number", }, new DDBizObjectItem() { Name = "工作经历", DataType = "table", Rows = new List <DDBizObjectItem>() { new DDBizObjectItem() { Name = "编号", DataType = "table_text" }, new DDBizObjectItem() { Name = "公司名称", DataType = "table_text" }, new DDBizObjectItem() { Name = "入职时间", DataType = "table_datetime" }, new DDBizObjectItem() { Name = "工作时间", DataType = "table_number" } } } }; formEntiy = SqlSugarFactory.GetInstance().Queryable <DdFormModuleEntity>().With(SqlSugar.SqlWith.NoLock).InSingle(formGuid); if (formEntiy == null) { return(new ResponseError("没找到对应的表单模板数据。", ResultCode.NoProcessAuth)); } else { formEntiy.BizObject = bizObj; MemoryCacheService.Set(formGuid, formEntiy); return(new ResponseSucess(formEntiy)); } } else { return(new ResponseSucess(formEntiy)); } }