新增文章

文章标题分类内容

// 引用SDK组件Kingdee.BOS.WebApi.Client.dll；SDK下载地址：https://openapi.open.kingdee.com/ApiSdkCenter
var client = new K3CloudApi();
// 初始化登录认证，appID、appSec可在"第三方系统登录授权"中获取
client.InitClient("6529ff74328a55", "appID", "appSec", "userName", 2052, "100", "http://192.168.188.81/k3cloud/");
client.GetSysReportData("aGsf_240319","{"FieldKeys":"","SchemeId":"","StartRow":0,"Limit":2000,"IsVerifyBaseDataField":"true","FilterString":[],"Model":{"FDate1":"1900-01-01","FDate2":"1900-01-01"}}");

------------------------------------------------------------------------------------------------------------------------------------------
            var aUrl = this.Context.ClientInfo.EntryPageUrl.ToString(); aUrl = aUrl.Substring(0, aUrl.IndexOf("k3cloud") + 8);
            var aDBid = this.Context.DBId.ToString();
            var aUser = "";
            var aPass = "";

#region|  取得 用户密码 aUser,aPass ★   -
            aSql = string.Format(@"/*dialect*/
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   select FName FUser ,FWebApi  from T_SEC_user  where  FWebApi != '' order by FName
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      ", aUserId); DynamicObjectCollection aTable2 = DBServiceHelper.ExecuteDynamicObject(this.Context, aSql);

if (aTable2.Count > 0)
            {
               aUser = aTable2[0]["FUser"].ToString();
               aPass = aTable2[0]["FWebApi"].ToString();
            }
            else
            {
               this.View.ShowErrMessage("请打开【查询用户】 指定使用 WebApi 用户 ！"); return;
            }
            #endregion

K3CloudApiClient k3Client = new K3CloudApiClient(aUrl);
            k3Client.ValidateLogin(aDBid, aUser, aPass, 2052);

------------------------------------------------------------------------------------------------------------------------------------------
      #region|  aGetSysReport  查询报表数据     |
      private void aGetSysReport(K3CloudApiClient k3Client)
      {
         #region|  查询报表   -
         string aJson1 = @"
            {
              ""FieldKeys"": ""FMaterialName,FLot_Text,FDate,FMachineName,FShiftGroupName"",
              ""SchemeId"": """",
              ""StartRow"": 0,
              ""Limit"": 10,
              ""IsVerifyBaseDataField"": ""true"",
              ""FilterString"": [
    
              ],
              ""Model"": {
                ""FDate1"": ""2024-03-01"",
                ""FDate2"": ""2024-03-31""
              }
            }";

string aResult1 = k3Client.GetSysReportData("aGsf_240319", aJson1); JObject aResultJObject1 = JObject.Parse(aResult1);
         #endregion

#region|  读取结果  -
         var aTable1 = aResultJObject1["Result"]["Rows"];

foreach (var aRow1 in aTable1)  // 逐行赋值 
         {
            string aFMaterialName = aRow1[0].Value<string>();
            string aFLot_Text = aRow1[1].Value<string>();
            string aFDate = aRow1[2].Value<string>();
            string aFMachineName = aRow1[3].Value<string>();
            string aFShiftGroupName = aRow1[4].Value<string>();
         }
         #endregion

}
      #endregion

------------------------------------------------------------------------------------------------------------------------------------------
   aFMaterialName	"TPA4533-P白色造粒料"	string
   aFLot_Text	"C24ZL050619"	string
   aFDate	"2024-03-19"	string
   aFMachineName	"造粒05线"	string
   aFShiftGroupName	"白班"	string

------------------------------------------------------------------------------------------------------------------------------------------
aResultJObject1	{{
  "Result": {
    "IsSuccess": true,
    "RowCount": 95,
    "Rows": [
      [
        "TPA4533-P白色造粒料",
        "C24ZL050619",
        "2024-03-19",
        "造粒05线",
        "白班"
      ],
      [
        "TPA4533-P白色造粒料",
        "C24ZL050619",
        "2024-03-19",
        "造粒05线",
        "夜班"
      ]
    ]
  }
}}

------------------------------------------------------------------------------------------------------------------------------------------
一、请求参数说明：
1.formid：业务对象表单Id，字符串类型（必录）
2.data：JSON格式数据（详情参考JSON格式数据）（必录）
     2.1.FieldKeys：需查询的字段key集合，字符串类型，格式："key1,key2,..."（必录）注（简单账表可能存在动态字段，指定待查字段时，须确保当前查询条件的结果集中包含待查字段）
     2.2.SchemeId：过滤方案内码，字符串类型
     2.3.StartRow：开始行索引，整型（非必录）
     2.4.Limit：最大行数，整型，不能超过10000（非必录）
     2.5.IsVerifyBaseDataField：是否验证所有的基础资料有效性，布尔类，默认true（非必录）
     2.6.FilterString：过滤条件，数组类型，如：[{"Left":"(","FieldName":"Field1","Compare":"67","Value":"111","Right":")","Logic":"0"},{"Left":"(","FieldName":"Field2","Compare":"67","Value":"222","Right":")","Logic":"0"}]
     2.7.Model：表单数据包，JSON类型（必录）

二、返回结果：
{"Result": {"IsSuccess": true,"RowCount": 0,"Rows": [ ] }}

三、代码示例：
// 引用SDK组件Kingdee.BOS.WebApi.Client.dll；SDK下载地址：https://openapi.open.kingdee.com/ApiSdkCenter
var client = new K3CloudApi();
// 初始化登录认证，appID、appSec可在"第三方系统登录授权"中获取
client.InitClient("6529ff74328a55", "appID", "appSec", "userName", 2052, "100", "http://192.168.188.81/k3cloud/");
client.GetSysReportData("aGsf_240319","{"FieldKeys":"","SchemeId":"","StartRow":0,"Limit":2000,"IsVerifyBaseDataField":"true","FilterString":[],"Model":{"FDate1":"1900-01-01","FDate2":"1900-01-01"}}");

四、JSON格式数据：
{
    "FieldKeys": "",
    "SchemeId": "",
    "StartRow": 0,
    "Limit": 2000,
    "IsVerifyBaseDataField": "true",
    "FilterString": [],
    "Model": {
        "FDate1": "1900-01-01",
        "FDate2": "1900-01-01"
    }
}

五、字段说明：
	 起始日期：FDate1  (必填项)
	 截止日期：FDate2  (必填项)

参数FieldKeys显示列：
	 造粒料名称：FMaterialName 
	 鑫瑞订单ID：FLot_Text 
	 生产日期：FDate 
	 产线：FMachineName 
	 班次：FShiftGroupName 
	 总投料量：FQtyInput 
	 生产总量：FQtyProduce 
	 合格品数量：FQtyPass 
	 不合格品数量：FQtyUnPass 
	 合格品累计：FQtyPassSum 
	 不合格品累计：FQtyUnPassSum 
	 不合格数量上限预警%：FQtyUnPassRate 
	 批次待完成数量：FQtyRemain 
	 行数：FRow

备注：错误代码MsgCode说明
           0：默认
           1：上下文丢失
           2：没有权限
           3：操作标识为空
           4：异常
           5：单据标识为空
           6：数据库操作失败
           7：许可错误
           8：参数错误
           9：指定字段/值不存在
           10：未找到对应数据
           11：验证失败
           12：不可操作
           13：网控冲突
           14：调用限制
           15：禁止管理员登录