using System;
using Kingdee.BOS;
using Kingdee.BOS.WebApi.ServicesStub;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Kingdee.BOS.Core;
using Kingdee.BOS.Orm.Entity;
using System.Data;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.BOS.App.Data;
using Kingdee.BOS.Core.DynamicForm;
using Kingdee.BOS.ServiceFacade.KDServiceFx;
namespace LCNR.Kingdee.CustomWebApiService
{
/// <summary>
/// 【WebApi】自定义WebApi接口
/// </summary>
public class TestApi : AbstractWebApiBusinessService
{
public TestApi(KDServiceContext context)
: base(context)
{
//
}
/// <summary>
/// 执行SQL并返回查询结果
/// </summary>
/// <param name="sql">SQL脚本</param>
/// <returns>返回DataSet</returns>
public object ExecuteDataSet(string sql)
{
if (this.KDContext.Session.AppContext == null)
{
// 会话超时
JObject res = new JObject();
res.Add("status", "0");
res.Add("msg", "你还没有登录");
return res.ToString();
}
else
{
JObject res = new JObject();
res.Add("status","1");
res.Add("msg","获取成功");
JArray arr = new JArray();
DynamicObjectCollection bills = DBUtils.ExecuteDynamicObject(this.KDContext.Session.AppContext, "/*dialect*/select * from T_BD_MATERIAL_L");
foreach(DynamicObject bill in bills)
{
var a = JsonConvert.SerializeObject(bill);
arr.Add(a);
}
res.Add("data", arr);
return res;
}
}
/// <summary>
/// 执行SQL并返回查询结果
/// </summary>
/// <param name="sql">SQL脚本</param>
/// <returns>返回字典集合</returns>
}
}