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