Files
2025-12-11 14:13:27 +08:00

1849 lines
49 KiB
C#

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
namespace ConsoleApp9
{
public class Root
{
public int code { get; set; }
public string message { get; set; }
public Data data { get; set; }
}
public class Data
{
public Table table { get; set; }
}
public class Table
{
public string table_id { get; set; }
public string name { get; set; }
public string alias { get; set; }
public string space_id { get; set; }
public string created_on { get; set; }
public List<dynamic> fields { get; set; }
}
internal class Program
{
static void Main(string[] args)
{
Root USA=JsonConvert.DeserializeObject<Root>("""
{
"code": 0,
"message": "success",
"data": {
"table": {
"table_id": "2100000061683453",
"name": "项目报备",
"alias": "",
"space_id": "4000000007643308",
"created_on": "2025-01-11 14:38:16",
"fields": [
{
"field_id": "2200000565424395",
"name": "审批状态",
"alias": "",
"field_type": "category",
"data_type": "category",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 0,
"options": [
{
"id": "1",
"name": "审批中"
},
{
"id": "2",
"name": "已通过"
},
{
"id": "3",
"name": "已驳回"
}
]
}
},
{
"field_id": "2200000500097483",
"name": "报备编号",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {},
"required": true,
"description": "系统自动生成",
"config": {}
},
{
"field_id": "2200000500097487",
"name": "项目名称",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {},
"required": true,
"description": "连锁店的名称规范是,酒店名+地点,类似携程的名称。比如:维也纳(叶挺大道店)",
"config": {}
},
{
"field_id": "2200000500102423",
"name": "客房数量",
"alias": "",
"field_type": "numeric",
"data_type": "numeric",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"precision": 0,
"unit_prefix": "",
"unit_surfix": "间",
"is_percent": 0
}
},
{
"field_id": "2200000500097481",
"name": "所属客户",
"alias": "",
"field_type": "relation",
"data_type": "relation",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"table_id": "2100000061658663",
"space_id": "4000000007643308"
}
},
{
"field_id": "2200000500102431",
"name": "项目范围",
"alias": "",
"field_type": "category",
"data_type": "category",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 0,
"options": [
{
"id": "1",
"name": "中国"
},
{
"id": "2",
"name": "国外"
}
]
}
},
{
"field_id": "2200000505101124",
"name": "外国国家",
"alias": "",
"field_type": "relation",
"data_type": "relation",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"table_id": "2100000062377115",
"space_id": "4000000007643308"
}
},
{
"field_id": "2200000565423164",
"name": "是否跨区报备",
"alias": "",
"field_type": "category",
"data_type": "category",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 0,
"options": [
{
"id": "1",
"name": "是"
},
{
"id": "2",
"name": "否"
}
]
}
},
{
"field_id": "2200000565423166",
"name": "跨区属地对应业务",
"alias": "",
"field_type": "user",
"data_type": "user",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0
}
},
{
"field_id": "2200000500587628",
"name": "项目省份",
"alias": "",
"field_type": "relation",
"data_type": "relation",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"table_id": "2100000061749582",
"space_id": "4000000007643308"
}
},
{
"field_id": "2200000500587629",
"name": "项目地级市",
"alias": "",
"field_type": "relation",
"data_type": "relation",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"table_id": "2100000061749583",
"space_id": "4000000007643308"
}
},
{
"field_id": "2200000547108158",
"name": "是否连锁",
"alias": "",
"field_type": "category",
"data_type": "category",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 0,
"options": [
{
"id": "1",
"name": "是"
},
{
"id": "2",
"name": "否"
},
{
"id": "3",
"name": "选项3"
}
]
}
},
{
"field_id": "2200000547108157",
"name": "连锁酒店采买公司",
"alias": "",
"field_type": "relation",
"data_type": "relation",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"is_multi": 0,
"table_id": "2100000061658663",
"space_id": "4000000007643308"
}
},
{
"field_id": "2200000500587630",
"name": "项目详细地址",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {},
"required": false,
"description": "",
"config": {}
},
{
"field_id": "2200000500097484",
"name": "项目报备日期",
"alias": "",
"field_type": "date",
"data_type": "date",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"precision": "date"
}
},
{
"field_id": "2200000507063096",
"name": "产品方案",
"alias": "",
"field_type": "category",
"data_type": "category",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 0,
"options": [
{
"id": "1",
"name": "客控"
},
{
"id": "2",
"name": "网络"
},
{
"id": "3",
"name": "电视"
},
{
"id": "4",
"name": "客控+网络"
},
{
"id": "5",
"name": "客控+电视"
},
{
"id": "6",
"name": "网络+电视"
},
{
"id": "7",
"name": "客控+网络+电视"
},
{
"id": "8",
"name": "锁"
}
]
}
},
{
"field_id": "2200000500097485",
"name": "商机里程碑",
"alias": "",
"field_type": "category",
"data_type": "category",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 1,
"options": [
{
"id": "1",
"name": "发现需求"
},
{
"id": "2",
"name": "确认需求"
},
{
"id": "3",
"name": "商务谈判"
},
{
"id": "4",
"name": "样板间成交"
},
{
"id": "7",
"name": "大货成交"
},
{
"id": "9",
"name": "仅做样板大货未成"
},
{
"id": "6",
"name": "输单"
},
{
"id": "8",
"name": "取消"
}
]
}
},
{
"field_id": "2200000500097486",
"name": "输单原因",
"alias": "",
"field_type": "category",
"data_type": "category",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 0,
"options": [
{
"id": "1",
"name": "客户需求消失"
},
{
"id": "2",
"name": "价格不满足期望"
},
{
"id": "3",
"name": "产品不匹配需求"
}
]
}
},
{
"field_id": "2200000500097489",
"name": "预计成交日期",
"alias": "",
"field_type": "date",
"data_type": "date",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"precision": "date"
}
},
{
"field_id": "2200000500097490",
"name": "预计成交金额",
"alias": "",
"field_type": "money",
"data_type": "numeric",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"precision": 2,
"unit_prefix": "",
"unit_surfix": "元",
"is_percent": 0
}
},
{
"field_id": "2200000500905542",
"name": "负责人",
"alias": "",
"field_type": "user",
"data_type": "user",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"is_multi": 0
}
},
{
"field_id": "2200000500905543",
"name": "协同人",
"alias": "",
"field_type": "user",
"data_type": "user",
"from_relation_field": {},
"required": false,
"description": "填入关联区域销售负责人",
"config": {
"is_multi": 1
}
},
{
"field_id": "2200000500097488",
"name": "下次跟进时间",
"alias": "",
"field_type": "date",
"data_type": "date",
"from_relation_field": {},
"required": true,
"description": "",
"config": {
"precision": "date"
}
},
{
"field_id": "2200000500097493",
"name": "附件",
"alias": "",
"field_type": "file",
"data_type": "file",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"is_multi": 1,
"is_watermark": 0
}
},
{
"field_id": "2200000500097494",
"name": "备注",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {},
"required": false,
"description": "",
"config": {}
},
{
"field_id": "2200000500097495",
"name": "增值税税率",
"alias": "",
"field_type": "numeric",
"data_type": "numeric",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"precision": 0,
"unit_prefix": "",
"unit_surfix": "%",
"is_percent": 1
}
},
{
"field_id": "2200000547115309",
"name": "报价次数",
"alias": "",
"field_type": "calculation",
"data_type": "numeric",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"precision": 0,
"unit_prefix": "",
"unit_surfix": "",
"is_percent": 0
}
},
{
"field_id": "2200000500097496",
"name": "优惠金额",
"alias": "",
"field_type": "money",
"data_type": "numeric",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"precision": 2,
"unit_prefix": "",
"unit_surfix": "元",
"is_percent": 0
}
},
{
"field_id": "2200000500097497",
"name": "优惠原因",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {},
"required": false,
"description": "",
"config": {}
},
{
"field_id": "2200000566651880",
"name": "画图次数",
"alias": "",
"field_type": "calculation",
"data_type": "numeric",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"precision": 0,
"unit_prefix": "",
"unit_surfix": "",
"is_percent": 0
}
},
{
"field_id": "2200000500097504",
"name": "跟进是否超时",
"alias": "",
"field_type": "category",
"data_type": "category",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 0,
"options": [
{
"id": "1",
"name": "已及时跟进"
},
{
"id": "2",
"name": "超时未跟进"
}
]
}
},
{
"field_id": "2200000500097505",
"name": "所属部门",
"alias": "",
"field_type": "relation",
"data_type": "relation",
"from_relation_field": {},
"required": false,
"description": "创建时如果未填写,则默认归属于商机创建人所在的部门",
"config": {
"is_multi": 0,
"table_id": "2100000061658732",
"space_id": "4000000007643308"
}
},
{
"field_id": "2200000500097507",
"name": "成交概率",
"alias": "",
"field_type": "numeric",
"data_type": "numeric",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"precision": 0,
"unit_prefix": "",
"unit_surfix": "%",
"is_percent": 1
}
},
{
"field_id": "2200000565427082",
"name": "流程发起人",
"alias": "process_executor_id",
"field_type": "user",
"data_type": "user",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"is_multi": 0
}
},
{
"field_id": "2200000565427083",
"name": "流程状态",
"alias": "process_status",
"field_type": "category",
"data_type": "category",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 1,
"options": [
{
"id": "1",
"name": "执行中"
},
{
"id": "2",
"name": "已完成(同意)"
},
{
"id": "3",
"name": "已完成(不同意)"
},
{
"id": "4",
"name": "已撤销"
},
{
"id": "5",
"name": "已关闭"
},
{
"id": "6",
"name": "异常中"
}
]
}
},
{
"field_id": "2200000565427084",
"name": "流程进展",
"alias": "process_current_log",
"field_type": "input",
"data_type": "text",
"from_relation_field": {},
"required": false,
"description": "",
"config": {}
},
{
"field_id": "2200000565427085",
"name": "流程启动时间",
"alias": "process_created_on",
"field_type": "date",
"data_type": "date",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"precision": "datetime"
}
},
{
"field_id": "2200000565427086",
"name": "流程结束时间",
"alias": "process_completed_on",
"field_type": "date",
"data_type": "date",
"from_relation_field": {},
"required": false,
"description": "",
"config": {
"precision": "datetime"
}
},
{
"field_id": "1103011117000000",
"name": "联系人",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {
"field_id": 2200000500097481
},
"required": true,
"description": "",
"config": {}
},
{
"field_id": "1103011118000000",
"name": "联系方式",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {
"field_id": 2200000500097481
},
"required": true,
"description": "",
"config": {}
},
{
"field_id": "1103011110000000",
"name": "客户类别",
"alias": "",
"field_type": "category",
"data_type": "category",
"from_relation_field": {
"field_id": 2200000500097481
},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"is_tile": 0,
"options": [
{
"id": "1",
"name": "宝来威分公司"
},
{
"id": "2",
"name": "签约服务商"
},
{
"id": "4",
"name": "签约渠道商"
},
{
"id": "5",
"name": "特许经销商"
},
{
"id": "6",
"name": "连锁品牌方"
},
{
"id": "7",
"name": "集成工程商"
},
{
"id": "8",
"name": "酒店甲方"
},
{
"id": "9",
"name": "总包公司"
},
{
"id": "10",
"name": "设计公司"
},
{
"id": "11",
"name": "运营商体系"
},
{
"id": "12",
"name": "同行异业"
},
{
"id": "13",
"name": "战略合作伙伴"
},
{
"id": "14",
"name": "V9-易从代理商"
}
]
}
},
{
"field_id": "1103011173000000",
"name": "关联国内部门",
"alias": "",
"field_type": "relation",
"data_type": "relation",
"from_relation_field": {
"field_id": 2200000500097481
},
"required": true,
"description": "",
"config": {
"is_multi": 0,
"table_id": "2100000061658732",
"space_id": "4000000007643308"
}
},
{
"field_id": "1103011173001101",
"name": "部门",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {
"field_id": 2200000500097481
},
"required": false,
"description": "",
"config": {}
},
{
"field_id": "1103011116000000",
"name": "负责人",
"alias": "",
"field_type": "user",
"data_type": "user",
"from_relation_field": {
"field_id": 2200000500097481
},
"required": false,
"description": "",
"config": {
"is_multi": 0
}
},
{
"field_id": "1103011136000000",
"name": "协同人(助理+关联区域业务)",
"alias": "",
"field_type": "user",
"data_type": "user",
"from_relation_field": {
"field_id": 2200000500097481
},
"required": false,
"description": "请填入业务助理和关联区域负责人和上级主管",
"config": {
"is_multi": 1
}
},
{
"field_id": "1167001102000000",
"name": "省",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {
"field_id": 2200000500587628
},
"required": false,
"description": "",
"config": {}
},
{
"field_id": "1168001102000000",
"name": "市",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {
"field_id": 2200000500587629
},
"required": false,
"description": "",
"config": {}
},
{
"field_id": "1124011101000000",
"name": "部门",
"alias": "",
"field_type": "input",
"data_type": "text",
"from_relation_field": {
"field_id": 2200000500097505
},
"required": false,
"description": "",
"config": {}
}
]
}
},
"meta": {
"trace_id": "ecd5c742aa1a9c216a5ee4325882f2a4"
}
}
""");
Console.WriteLine(USA.data);
Console.ReadLine();
Console.WriteLine("Hello, World!");
}
}
}