用友U9二开附件自定义下载1获取附件列表

jieeeeeeeeeeee

已于 2024-04-07 15:29:26 修改

阅读量812

点赞数

分类专栏： U9 文章标签： c#

于 2021-12-31 15:43:19 首次发布

本文链接：https://blog.csdn.net/jieeeeeeeeeeee/article/details/122257615

版权

U9 专栏收录该内容

9 篇文章 3 订阅

订阅专栏

ItemMaster item = ItemMaster.Finder.Find($"Org.id ={Context.LoginOrg.ID} and Code='{param.ItemCode}'");

if (item != null)
{
long itemid = item.ID;
UFIDA.U9.Base.Attachment.Attachment.EntityList attEntity = UFIDA.U9.Base.Attachment.Attachment.Finder.FindAll($"id ={itemid} and EntityFullName='UFIDA.U9.CBO.SCM.Item.ItemMaster'");

DataSet ds = new DataSet();
DataTable newTable = new DataTable();
newTable.Columns.Add("Idx", typeof(int));
newTable.Columns.Add("AttachType", typeof(string));
newTable.Columns.Add("URI", typeof(string));
newTable.Columns.Add("Title", typeof(string));
newTable.Columns.Add("Size", typeof(string));
newTable.Columns.Add("Description", typeof(string));
if (attEntity != null)
{
foreach (Attachment attachment in attEntity)
{
DataRow dr = newTable.NewRow();
dr["Idx"] = attachment.Idx;//序号
dr["AttachType"] = attachment.AttachType?.Name;//附件类型
dr["URI"] = attachment.URI;//附件
dr["Title"] = attachment.Title;//标题
dr["Size"] = attachment.Size;//大小
dr["Description"] = attachment.Description;//描述
newTable.Rows.Add(dr);
}

ds.Tables.Add(newTable);

string json = JsonConvert.SerializeObject(ds, Formatting.None, jsonSetting);

result.state = "success";
result.msg = "查询成功";
result.data = json;
return JsonConvert.SerializeObject(result, Formatting.None, jsonSetting);

}
else
{
result.state = "fail";
result.msg = "未查到该料品附件信息";
result.data = "";
return JsonConvert.SerializeObject(result, Formatting.None, jsonSetting);
}

}
else
{
result.state = "fail";
result.msg = "未查到该料品";
result.data = "";
return JsonConvert.SerializeObject(result, Formatting.None, jsonSetting);
}