private WRPicture AssamblyPic(IDataReader reader)
{
WRPicture wrPic = new WRPicture();
wrPic.ID = reader["id"].ToString();
string content = reader["content"].ToString();
if (!string.IsNullOrEmpty(content))
{
wrPic.Content = content.Replace("\n", "");
}
return(wrPic);
}
internal void AddWorkReportPictures(List <WRPicture> pics, string wrid)
{
if (pics == null || pics.Count < 1)
{
return;
}
for (int i = 0; i < pics.Count; i++)
{
WRPicture pic = pics[i];
if (string.IsNullOrWhiteSpace(pic.ID) || pic.ID.Length != 36)
{
pic.ID = Guid.NewGuid().ToString();
}
//新增一条数据
var insertStr = $@"INSERT INTO wrpictures(id, wrid, content, tenantid) VALUES ('{pic.ID}', '{wrid}', decode('{pic.Content}','base64'), '{Utils.GetTenantId()}')";
db.ExecSqlStatement(insertStr);
}
}