【b2c】商品自定义模型的研究就部分实现二

最新推荐文章于 2019-06-10 10:41:36 发布

码农下的天桥

最新推荐文章于 2019-06-10 10:41:36 发布

阅读量934

点赞数

分类专栏： web开发

本文链接：https://blog.csdn.net/cdnight/article/details/34959613

版权

web开发专栏收录该内容

142 篇文章 0 订阅

订阅专栏

再接上文。

现在要处理一下从这些json数据里面输入到数据库。

譬如:

一个用于输入的存储过程：

/*
返回的是json格式数据，{"status":true,"message":""}
需要的参数：
1、moduleid，当前模型的id。
2、json数据，是属性列表的json数据，格式参考如下：
[
{"id":0,"moduleid":0,"name":"颜色","attrName":"color","tips":"机身颜色","chooseType":1,"attrType":1,"isRequired":true,"usedInSearch":true,"enabled":true,"isMain":false,"orders":0,"single_isColor":true,"single_imgAllowed":true,"muti_maxSelected":0,"input_uiType":0,
"options":
[
{"id":0,"name":"白色","color":"#000000","orders":0,"enabled":true},
{"id":0,"name":"黑色","color":"#ffffff","orders":1,"enabled":true}
]
},

{"id":0,"moduleid":0,"name":"版本","attrName":"version","tips":"","chooseType":3,"attrType":1,"isRequired":true,"usedInSearch":false,"enabled":true,"isMain":false,"orders":0,"single_isColor":false,"single_imgAllowed":false,"muti_maxSelected":0,"input_uiType":1,
"options":[]
},

{"id":0,"moduleid":0,"name":"网络制式","attrName":"web","tips":"","chooseType":2,"attrType":2,"isRequired":true,"usedInSearch":false,"enabled":true,"isMain":false,"orders":0,"single_isColor":false,"single_imgAllowed":false,"muti_maxSelected":4,"input_uiType":0,
"options":[
{"id":0,"name":"GSM/WCDMA/LTE","color":"","orders":0,"enabled":true},
{"id":0,"name":"WCDMA/CDMA2000/TD-SCDMA","color":"","orders":0,"enabled":true},
{"id":0,"name":"GSM/WCDMA/CDMA/CDMA2000","color":"","orders":1,"enabled":true},
{"id":0,"name":"双模(GSM/CDMA)","color":"","orders":3,"enabled":true}
]
},

{"id":0,"moduleid":0,"name":"机身内存","attrName":"neicun","tips":"","chooseType":1,"attrType":1,"isRequired":true,"usedInSearch":false,"enabled":true,"isMain":false,"orders":3,"single_isColor":false,"single_imgAllowed":false,"muti_maxSelected":0,"input_uiType":0,
"options":
[
{"id":0,"name":"256MB","color":"","orders":0,"enabled":true},
{"id":0,"name":"512MB","color":"","orders":2,"enabled":true},
{"id":0,"name":"1G","color":"","orders":3,"enabled":true},
{"id":0,"name":"4g","color":"","orders":8,"enabled":true},
{"id":0,"name":"2g","color":"","orders":8,"enabled":true},
{"id":0,"name":"8g","color":"","orders":10,"enabled":true},
{"id":0,"name":"16G","color":"","orders":12,"enabled":true},
{"id":0,"name":"32G","color":"","orders":16,"enabled":true}
]
}]

*/

create or replace function module_updateAttrList(
moduleid int,
attrList_json_str text
)
returns varchar
as
$$
declare _attrList json;
declare _result json;
declare status boolean;
declare msg varchar(200);
declare _tmpNameId int;
declare jsonitem json;
declare jsonLv1 json;
declare jsonLv2 json;
declare record1 record;
declare tmpOptionJsonArr json;
declare recordLv2 record;
declare _tmpModuleId int;
begin 
_tmpModuleId:=moduleid;
if not exists (select id from xx_module where id=moduleid ) then
status:=false;
msg:='当前模型不存在！';
return cast((select row_to_json(t) from (select status as "status",msg as "message") t) as varchar);
end if;
_attrList:=cast(attrList_json_str as json);
/*
[
{"id":0,"moduleid":0,"name":"颜色","attrName":"color","tips":"机身颜色","chooseType":1,"attrType":1,"isRequired":true,"usedInSearch":true,"enabled":true,"isMain":false,"orders":0,"single_isColor":true,"single_imgAllowed":true,"muti_maxSelected":0,"input_uiType":0,
"options":
[
{"id":0,"name":"白色","color":"#000000","orders":0,"enabled":true},
{"id":0,"name":"黑色","color":"#ffffff","orders":1,"enabled":true}
]
},

{"id":0,"moduleid":0,"name":"版本","attrName":"version","tips":"","chooseType":3,"attrType":1,"isRequired":true,"usedInSearch":false,"enabled":true,"isMain":false,"orders":0,"single_isColor":false,"single_imgAllowed":false,"muti_maxSelected":0,"input_uiType":1,
"options":[]
},

{"id":0,"moduleid":0,"name":"网络制式","attrName":"web","tips":"","chooseType":2,"attrType":2,"isRequired":true,"usedInSearch":false,"enabled":true,"isMain":false,"orders":0,"single_isColor":false,"single_imgAllowed":false,"muti_maxSelected":4,"input_uiType":0,
"options":[
{"id":0,"name":"GSM/WCDMA/LTE","color":"","orders":0,"enabled":true},
{"id":0,"name":"WCDMA/CDMA2000/TD-SCDMA","color":"","orders":0,"enabled":true},
{"id":0,"name":"GSM/WCDMA/CDMA/CDMA2000","color":"","orders":1,"enabled":true},
{"id":0,"name":"双模(GSM/CDMA)","color":"","orders":3,"enabled":true}
]
},

{"id":0,"moduleid":0,"name":"机身内存","attrName":"neicun","tips":"","chooseType":1,"attrType":1,"isRequired":true,"usedInSearch":false,"enabled":true,"isMain":false,"orders":3,"single_isColor":false,"single_imgAllowed":false,"muti_maxSelected":0,"input_uiType":0,
"options":
[
{"id":0,"name":"256MB","color":"","orders":0,"enabled":true},
{"id":0,"name":"512MB","color":"","orders":2,"enabled":true},
{"id":0,"name":"1G","color":"","orders":3,"enabled":true},
{"id":0,"name":"4g","color":"","orders":8,"enabled":true},
{"id":0,"name":"2g","color":"","orders":8,"enabled":true},
{"id":0,"name":"8g","color":"","orders":10,"enabled":true},
{"id":0,"name":"16G","color":"","orders":12,"enabled":true},
{"id":0,"name":"32G","color":"","orders":16,"enabled":true}
]
}]
*/
--raise info '当前数组的长度：%',_attrList;
if json_array_length(_attrList)<1 then 
status:=false;
msg:='没有任何需要更新的属性信息。';
return cast((select row_to_json(t) from (select status as "status",msg as "message") t) as varchar);
end if;



for record1 in (select json_array_elements(_attrList)) loop
jsonItem:=cast(record1.json_array_elements as json);
--raise 'jsonItem is:%',jsonItem;
if cast(jsonItem->>'id'  as int)<1 then
--为零，则需要添加。
insert into xx_attr_name (
"moduleid",
"name",
"attrName",
"tips",
"chooseType",
"attrType",
"isRequired",
"usedInSearch",
"isMain",
"orders",
"single_isColor",
"single_imgAllowed",
"muti_maxSelected",
"input_uiType",
"enabled") values(
_tmpModuleId,
jsonItem->>'name',
jsonItem->>'attrName',
jsonItem->>'tips',
(jsonItem->>'chooseType')::int,
(jsonItem->>'attrType')::int,
(jsonItem->>'isRequired')::boolean,
(jsonItem->>'usedInSearch')::boolean,
(jsonItem->>'isMain')::boolean,
(jsonItem->>'orders')::int,
(jsonItem->>'single_isColor')::boolean,
(jsonItem->>'single_imgAllowed')::boolean,
(jsonItem->>'muti_maxSelected')::int,
(case (jsonItem->>'input_uiType')::int when 0 then 1 else (jsonItem->>'input_uiType')::int end),
(jsonItem->>'enabled')::boolean
);
--获取插入成功的id值。
if found then
_tmpNameId:=currval(pg_get_serial_sequence('xx_attr_name', 'id'));
if _tmpNameId>0 then
   --再次遍历相关option。
   for recordLv2 in (select json_array_elements(jsonItem->'options')) loop
   jsonLv2:=cast(recordLv2.json_array_elements as json);
   --{"id":0,"name":"256MB","color":"","orders":0,"enabled":true},
   insert into xx_attr_val (
    name,
    color,
    orders,
    enabled,
    nameid
   ) values(
    (jsonLv2->>'name'),
    (jsonLv2->>'color'),
    (jsonLv2->>'orders')::int,
    (jsonLv2->>'enabled')::boolean,
    _tmpNameId
   );
   end loop;
else
raise '这是continue啊。';
continue;
end if;
else
continue;
end if;
--添加操作处理完毕。
else
--假如有id的话，那么尝试更新该模型下面的所有属性。
   --有没有相关name，有就更新，否则继续。
   if exists(select id from xx_attr_name where id=(jsonItem->>'id')::int and xx_attr_name."moduleid"=_tmpModuleId) then
     update xx_attr_name set
       "name"=jsonItem->>'name',
       "attrName"=(jsonItem->>'attrName'),
       "tips"=jsonItem->>'tips',
       "chooseType"=(jsonItem->>'chooseType')::int,
       "attrType"=(jsonItem->>'attrType')::int,
       "isRequired"=(jsonItem->>'isRequired')::boolean,
       "usedInSearch"=(jsonItem->>'usedInSearch')::boolean,
       "isMain"=(jsonItem->>'isMain')::boolean,
       "orders"=(jsonItem->>'orders')::int,
       "single_isColor"=(jsonItem->>'single_isColor')::boolean,
       "single_imgAllowed"=(jsonItem->>'single_imgAllowed')::boolean,
       "muti_maxSelected"=(jsonItem->>'muti_maxSelected')::int,
       "input_uiType"=(case (jsonItem->>'input_uiType')::int when 0 then 1 else (jsonItem->>'input_uiType')::int end),
       "enabled"=(jsonItem->>'enabled')::boolean
       where id=(jsonItem->>'id')::int;
       --看看有没有option，检查是更新还是插入。
       for recordLv2 in (select json_array_elements(jsonItem->'options')) loop
       jsonLv2:=cast(recordLv2.json_array_elements as json);
       if (jsonLv2->>'id')::int >0 then
        --有id，就更新。
        update xx_attr_val set
                           name=(jsonLv2->>'name'),
                           color=jsonLv2->>'color',
                           orders=(jsonLv2->>'orders')::int,
                           enabled=(jsonLv2->>'enabled')::boolean,
                           nameid=(jsonItem->>'id')::int
                           where id=(jsonLv2->>'id')::int;        
       else
       --没id，就插入。
        insert into xx_attr_val (
                           name,
                           color,
                           orders,
                           enabled,
                           nameid
                           ) values(
                           jsonLv2->>'name',
                           jsonLv2->>'color',
                           (jsonLv2->>'orders')::int,
                           (jsonLv2->>'enabled')::boolean,
                           (jsonItem->>'id')::int
                           );
       end if;
       end loop;
   else
    --没有相关名info，继续。
    continue;
   end if;

--更新操作处理完毕。
end if;
end loop;
status:=true;
msg:='成功保存相关资料。';
return cast((select row_to_json(t) from (select status as "status",msg as "message") t) as varchar);
end
$$ language plpgsql volatile;

总算可以调试到正常添加模型及各种属性了。请注意，下面这些参数及属性都是从淘宝及太平洋那里参考而来的。根据实际需要可以变换。

请看看下面：

编辑主屏尺寸属性

编辑颜色属性。

而每次保存这些属性列表，它的格式应该是：

   var ModuleData={
        id:0,
        name:"",
        logo:"",
        memo:"",
        orders:0,
        enabled:true,
        attrList:[{"attrName":"color","attrType":1,"chooseType":1,"enabled":true,"id":8,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"颜色","options":[{"enabled":true,"id":1,"moduleid":1,"name":"白色","nameid":8,"orders":0},{"enabled":true,"id":2,"moduleid":1,"name":"黑色","nameid":8,"orders":0},{"enabled":true,"id":167,"moduleid":1,"name":"银灰色","nameid":8,"orders":1},{"enabled":true,"id":168,"moduleid":1,"name":"咖啡色","nameid":8,"orders":2},{"enabled":true,"id":169,"moduleid":1,"name":"红色","nameid":8,"orders":3},{"enabled":true,"id":170,"moduleid":1,"name":"金色","nameid":8,"orders":4},{"enabled":true,"id":171,"moduleid":1,"name":"蓝色","nameid":8,"orders":5},{"enabled":true,"id":172,"moduleid":1,"name":"橙色","nameid":8,"orders":6}],"orders":0,"single_imgAllowed":true,"single_isColor":true,"tips":"","usedInSearch":true},{"attrName":"memory","attrType":1,"chooseType":1,"enabled":true,"id":10,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"机身内存","options":[{"enabled":true,"id":3,"moduleid":1,"name":"256MB","nameid":10,"orders":0},{"enabled":true,"id":4,"moduleid":1,"name":"512MB","nameid":10,"orders":1},{"enabled":true,"id":5,"moduleid":1,"name":"1G","nameid":10,"orders":2},{"enabled":true,"id":6,"moduleid":1,"name":"2G","nameid":10,"orders":2},{"enabled":true,"id":7,"moduleid":1,"name":"4G","nameid":10,"orders":4},{"enabled":true,"id":8,"moduleid":1,"name":"8G","nameid":10,"orders":8}],"orders":2,"single_imgAllowed":true,"single_isColor":true,"tips":"","usedInSearch":true},{"attrName":"mobile_version","attrType":2,"chooseType":3,"enabled":true,"id":9,"input_uiType":1,"isMain":false,"isRequired":false,"moduleid":1,"muti_maxSelected":0,"name":"手机版本","options":[],"orders":2,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":false},{"attrName":"chichi","attrType":2,"chooseType":1,"enabled":true,"id":13,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"主屏尺寸","options":[{"enabled":true,"id":18,"moduleid":1,"name":"0.96英寸","nameid":13,"orders":0},{"enabled":true,"id":19,"moduleid":1,"name":"1.3英寸","nameid":13,"orders":1},{"enabled":true,"id":20,"moduleid":1,"name":"1.36英寸","nameid":13,"orders":2},{"enabled":true,"id":21,"moduleid":1,"name":"1.4英寸","nameid":13,"orders":4},{"enabled":true,"id":23,"moduleid":1,"name":"1.6英寸","nameid":13,"orders":5},{"enabled":true,"id":22,"moduleid":1,"name":"1.44英寸","nameid":13,"orders":5},{"enabled":true,"id":24,"moduleid":1,"name":"1.65英寸","nameid":13,"orders":6},{"enabled":true,"id":25,"moduleid":1,"name":"1.7英寸","nameid":13,"orders":7},{"enabled":true,"id":26,"moduleid":1,"name":"1.77英寸","nameid":13,"orders":8},{"enabled":true,"id":27,"moduleid":1,"name":"1.8英寸","nameid":13,"orders":9},{"enabled":true,"id":28,"moduleid":1,"name":"1.9英寸","nameid":13,"orders":10},{"enabled":true,"id":29,"moduleid":1,"name":"2.0英寸","nameid":13,"orders":11},{"enabled":true,"id":30,"moduleid":1,"name":"2.1英寸","nameid":13,"orders":12},{"enabled":true,"id":31,"moduleid":1,"name":"2.2英寸","nameid":13,"orders":13},{"enabled":true,"id":32,"moduleid":1,"name":"2.3英寸","nameid":13,"orders":14},{"enabled":true,"id":33,"moduleid":1,"name":"2.44英寸","nameid":13,"orders":15},{"enabled":true,"id":34,"moduleid":1,"name":"2.5英寸","nameid":13,"orders":16},{"enabled":true,"id":35,"moduleid":1,"name":"2.6英寸","nameid":13,"orders":17},{"enabled":true,"id":36,"moduleid":1,"name":"2.8英寸","nameid":13,"orders":18},{"enabled":true,"id":37,"moduleid":1,"name":"2.9英寸","nameid":13,"orders":19},{"enabled":true,"id":38,"moduleid":1,"name":"3.0英寸","nameid":13,"orders":20},{"enabled":true,"id":39,"moduleid":1,"name":"3.1英寸","nameid":13,"orders":21},{"enabled":true,"id":40,"moduleid":1,"name":"3.2英寸","nameid":13,"orders":22},{"enabled":true,"id":41,"moduleid":1,"name":"3.3英寸","nameid":13,"orders":23},{"enabled":true,"id":42,"moduleid":1,"name":"3.4英寸","nameid":13,"orders":24},{"enabled":true,"id":43,"moduleid":1,"name":"3.5英寸","nameid":13,"orders":25},{"enabled":true,"id":44,"moduleid":1,"name":"3.6英寸","nameid":13,"orders":26},{"enabled":true,"id":45,"moduleid":1,"name":"3.7英寸","nameid":13,"orders":27},{"enabled":true,"id":46,"moduleid":1,"name":"3.75英寸","nameid":13,"orders":28},{"enabled":true,"id":47,"moduleid":1,"name":"3.8英寸","nameid":13,"orders":29},{"enabled":true,"id":48,"moduleid":1,"name":"3.95英寸","nameid":13,"orders":30},{"enabled":true,"id":49,"moduleid":1,"name":"3.97英寸","nameid":13,"orders":31},{"enabled":true,"id":50,"moduleid":1,"name":"4.0英寸","nameid":13,"orders":32},{"enabled":true,"id":51,"moduleid":1,"name":"4.02英寸","nameid":13,"orders":33},{"enabled":true,"id":52,"moduleid":1,"name":"4.05英寸","nameid":13,"orders":34},{"enabled":true,"id":53,"moduleid":1,"name":"4.2英寸","nameid":13,"orders":35},{"enabled":true,"id":54,"moduleid":1,"name":"4.3英寸","nameid":13,"orders":36},{"enabled":true,"id":55,"moduleid":1,"name":"4.4英寸","nameid":13,"orders":37},{"enabled":true,"id":56,"moduleid":1,"name":"4.45英寸","nameid":13,"orders":38},{"enabled":true,"id":57,"moduleid":1,"name":"4.5英寸","nameid":13,"orders":39},{"enabled":true,"id":58,"moduleid":1,"name":"4.6英寸","nameid":13,"orders":40},{"enabled":true,"id":59,"moduleid":1,"name":"4.63英寸","nameid":13,"orders":41},{"enabled":true,"id":60,"moduleid":1,"name":"4.65英寸","nameid":13,"orders":42},{"enabled":true,"id":61,"moduleid":1,"name":"4.7英寸","nameid":13,"orders":43},{"enabled":true,"id":62,"moduleid":1,"name":"4.8英寸","nameid":13,"orders":44},{"enabled":true,"id":63,"moduleid":1,"name":"4.95英寸","nameid":13,"orders":45},{"enabled":true,"id":64,"moduleid":1,"name":"4.97英寸","nameid":13,"orders":46},{"enabled":true,"id":65,"moduleid":1,"name":"5.0英寸","nameid":13,"orders":47},{"enabled":true,"id":66,"moduleid":1,"name":"5.1英寸","nameid":13,"orders":48},{"enabled":true,"id":67,"moduleid":1,"name":"5.2英寸","nameid":13,"orders":49},{"enabled":true,"id":68,"moduleid":1,"name":"5.3英寸","nameid":13,"orders":50},{"enabled":true,"id":69,"moduleid":1,"name":"5.5英寸","nameid":13,"orders":51},{"enabled":true,"id":70,"moduleid":1,"name":"5.7英寸","nameid":13,"orders":52},{"enabled":true,"id":71,"moduleid":1,"name":"5.88英寸","nameid":13,"orders":53},{"enabled":true,"id":72,"moduleid":1,"name":"6.0英寸","nameid":13,"orders":54},{"enabled":true,"id":73,"moduleid":1,"name":"6.1英寸","nameid":13,"orders":55},{"enabled":true,"id":74,"moduleid":1,"name":"6.3英寸","nameid":13,"orders":56},{"enabled":true,"id":75,"moduleid":1,"name":"6.44英寸","nameid":13,"orders":57},{"enabled":true,"id":76,"moduleid":1,"name":"7.0英寸","nameid":13,"orders":58},{"enabled":true,"id":77,"moduleid":1,"name":"7.7英寸","nameid":13,"orders":59}],"orders":3,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":true},{"attrName":"core_amount","attrType":2,"chooseType":1,"enabled":true,"id":11,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"核心数","options":[{"enabled":true,"id":9,"moduleid":1,"name":"单核","nameid":11,"orders":0},{"enabled":true,"id":10,"moduleid":1,"name":"双核","nameid":11,"orders":0},{"enabled":true,"id":11,"moduleid":1,"name":"四核","nameid":11,"orders":0},{"enabled":true,"id":12,"moduleid":1,"name":"八核","nameid":11,"orders":0}],"orders":5,"single_imgAllowed":true,"single_isColor":true,"tips":"","usedInSearch":true},{"attrName":"kuangshi","attrType":2,"chooseType":1,"enabled":true,"id":12,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"手机款式","options":[{"enabled":true,"id":13,"moduleid":1,"name":"直板","nameid":12,"orders":0},{"enabled":true,"id":14,"moduleid":1,"name":"翻盖","nameid":12,"orders":1},{"enabled":true,"id":15,"moduleid":1,"name":"滑盖","nameid":12,"orders":2},{"enabled":true,"id":16,"moduleid":1,"name":"侧滑盖","nameid":12,"orders":4},{"enabled":true,"id":17,"moduleid":1,"name":"旋转","nameid":12,"orders":6}],"orders":6,"single_imgAllowed":true,"single_isColor":true,"tips":"","usedInSearch":true},{"attrName":"fenbianlv","attrType":2,"chooseType":1,"enabled":true,"id":14,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"分辨率","options":[{"enabled":true,"id":78,"moduleid":1,"name":"1920x1080","nameid":14,"orders":0},{"enabled":true,"id":79,"moduleid":1,"name":"1280x720","nameid":14,"orders":1},{"enabled":true,"id":80,"moduleid":1,"name":"800x480","nameid":14,"orders":2},{"enabled":true,"id":81,"moduleid":1,"name":"960x540","nameid":14,"orders":3},{"enabled":true,"id":82,"moduleid":1,"name":"320x240","nameid":14,"orders":4},{"enabled":true,"id":83,"moduleid":1,"name":"640x1136","nameid":14,"orders":5},{"enabled":true,"id":84,"moduleid":1,"name":"960x640","nameid":14,"orders":6},{"enabled":true,"id":85,"moduleid":1,"name":"854x480","nameid":14,"orders":7},{"enabled":true,"id":86,"moduleid":1,"name":"480x320","nameid":14,"orders":8},{"enabled":true,"id":87,"moduleid":1,"name":"1280x800","nameid":14,"orders":9},{"enabled":true,"id":88,"moduleid":1,"name":"1280x800","nameid":14,"orders":10},{"enabled":true,"id":89,"moduleid":1,"name":"1280x768","nameid":14,"orders":11},{"enabled":true,"id":90,"moduleid":1,"name":"160x128","nameid":14,"orders":12},{"enabled":true,"id":91,"moduleid":1,"name":"1800x1080","nameid":14,"orders":13},{"enabled":true,"id":92,"moduleid":1,"name":"1024x768","nameid":14,"orders":14},{"enabled":true,"id":93,"moduleid":1,"name":"720x1280","nameid":14,"orders":15},{"enabled":true,"id":94,"moduleid":1,"name":"1080x720","nameid":14,"orders":16},{"enabled":true,"id":95,"moduleid":1,"name":"480x800","nameid":14,"orders":17},{"enabled":true,"id":96,"moduleid":1,"name":"220x176","nameid":14,"orders":18},{"enabled":true,"id":97,"moduleid":1,"name":"400x240","nameid":14,"orders":19},{"enabled":true,"id":98,"moduleid":1,"name":"128x128","nameid":14,"orders":20},{"enabled":true,"id":99,"moduleid":1,"name":"640x360","nameid":14,"orders":21},{"enabled":true,"id":100,"moduleid":1,"name":"240x320","nameid":14,"orders":22},{"enabled":true,"id":101,"moduleid":1,"name":"640x480","nameid":14,"orders":23},{"enabled":true,"id":102,"moduleid":1,"name":"480x360","nameid":14,"orders":24},{"enabled":true,"id":103,"moduleid":1,"name":"128x160","nameid":14,"orders":25},{"enabled":true,"id":104,"moduleid":1,"name":"540x960","nameid":14,"orders":26},{"enabled":true,"id":105,"moduleid":1,"name":"480x854","nameid":14,"orders":27},{"enabled":true,"id":106,"moduleid":1,"name":"320x480","nameid":14,"orders":28},{"enabled":true,"id":107,"moduleid":1,"name":"176x220","nameid":14,"orders":29},{"enabled":true,"id":108,"moduleid":1,"name":"128x64","nameid":14,"orders":30},{"enabled":true,"id":109,"moduleid":1,"name":"96x64","nameid":14,"orders":31},{"enabled":true,"id":110,"moduleid":1,"name":"220x178","nameid":14,"orders":32},{"enabled":true,"id":111,"moduleid":1,"name":"450x320","nameid":14,"orders":33},{"enabled":true,"id":112,"moduleid":1,"name":"128x80","nameid":14,"orders":34},{"enabled":true,"id":113,"moduleid":1,"name":"864x480","nameid":14,"orders":35},{"enabled":true,"id":114,"moduleid":1,"name":"170x220","nameid":14,"orders":36},{"enabled":true,"id":115,"moduleid":1,"name":"176x144","nameid":14,"orders":37},{"enabled":true,"id":116,"moduleid":1,"name":"2560x1440","nameid":14,"orders":38},{"enabled":true,"id":117,"moduleid":1,"name":"240x400","nameid":14,"orders":39}],"orders":7,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":true},{"attrName":"ossystem","attrType":2,"chooseType":1,"enabled":true,"id":15,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"操作系统","options":[{"enabled":true,"id":118,"moduleid":1,"name":"Android/安卓","nameid":15,"orders":0},{"enabled":true,"id":119,"moduleid":1,"name":"iOS","nameid":15,"orders":1},{"enabled":true,"id":120,"moduleid":1,"name":"WP7/芒果","nameid":15,"orders":2},{"enabled":true,"id":121,"moduleid":1,"name":"阿里云OS","nameid":15,"orders":3},{"enabled":true,"id":122,"moduleid":1,"name":"Symbian/塞班","nameid":15,"orders":4},{"enabled":true,"id":123,"moduleid":1,"name":"黑莓","nameid":15,"orders":5},{"enabled":true,"id":124,"moduleid":1,"name":"windows Mobile","nameid":15,"orders":6},{"enabled":true,"id":125,"moduleid":1,"name":"Linux","nameid":15,"orders":7},{"enabled":true,"id":128,"moduleid":1,"name":"OMS","nameid":15,"orders":10},{"enabled":true,"id":126,"moduleid":1,"name":"PALM","nameid":15,"orders":8},{"enabled":true,"id":127,"moduleid":1,"name":"meego","nameid":15,"orders":9},{"enabled":true,"id":129,"moduleid":1,"name":"mmp","nameid":15,"orders":11},{"enabled":true,"id":130,"moduleid":1,"name":"rex","nameid":15,"orders":12},{"enabled":true,"id":131,"moduleid":1,"name":"Nucleus","nameid":15,"orders":13},{"enabled":true,"id":132,"moduleid":1,"name":"INFINEON","nameid":15,"orders":14},{"enabled":true,"id":133,"moduleid":1,"name":"Larena 3.0","nameid":15,"orders":15},{"enabled":true,"id":134,"moduleid":1,"name":"FlLyme","nameid":15,"orders":16},{"enabled":true,"id":135,"moduleid":1,"name":"无操作系统","nameid":15,"orders":17}],"orders":8,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":true},{"attrName":"webtype","attrType":2,"chooseType":2,"enabled":true,"id":16,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":-1,"name":"网络类型","options":[{"enabled":true,"id":136,"moduleid":1,"name":"天翼-电信","nameid":16,"orders":0},{"enabled":true,"id":137,"moduleid":1,"name":"G3-移动","nameid":16,"orders":1},{"enabled":true,"id":138,"moduleid":1,"name":"沃-联通","nameid":16,"orders":2},{"enabled":true,"id":139,"moduleid":1,"name":"双模(GSM/CDMA2000)","nameid":16,"orders":3},{"enabled":true,"id":140,"moduleid":1,"name":"GSM","nameid":16,"orders":4},{"enabled":true,"id":141,"moduleid":1,"name":"TD-LTE（4G）/TD-SCDMA/GSM","nameid":16,"orders":5},{"enabled":true,"id":142,"moduleid":1,"name":"GSM/WCDMA/LTE","nameid":16,"orders":6},{"enabled":true,"id":143,"moduleid":1,"name":"双模(GSM/CDMA)","nameid":16,"orders":7},{"enabled":true,"id":144,"moduleid":1,"name":"GSM/WCDMA/CDMA/CDMA2000","nameid":16,"orders":8},{"enabled":true,"id":145,"moduleid":1,"name":"CDMA","nameid":16,"orders":9},{"enabled":true,"id":146,"moduleid":1,"name":"GSM/TD-SCDMA/WCDMA","nameid":16,"orders":10},{"enabled":true,"id":147,"moduleid":1,"name":"EVDO+GSM","nameid":16,"orders":11},{"enabled":true,"id":148,"moduleid":1,"name":"TD-SCDMA/CDMA/GSM","nameid":16,"orders":12},{"enabled":true,"id":149,"moduleid":1,"name":"小灵通","nameid":16,"orders":13},{"enabled":true,"id":150,"moduleid":1,"name":"WCDMA/CDMA2000/TD-SCDMA","nameid":16,"orders":14}],"orders":9,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":true},{"attrName":"chumopingleixign","attrType":2,"chooseType":1,"enabled":true,"id":17,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"触摸屏类型","options":[{"enabled":true,"id":151,"moduleid":1,"name":"电容式","nameid":17,"orders":0},{"enabled":true,"id":152,"moduleid":1,"name":"电阻式","nameid":17,"orders":1}],"orders":10,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":false},{"attrName":"jianpan","attrType":2,"chooseType":1,"enabled":true,"id":18,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"键盘类型","options":[{"enabled":true,"id":154,"moduleid":1,"name":"T9标准键盘","nameid":18,"orders":1},{"enabled":true,"id":155,"moduleid":1,"name":"虚拟触摸键盘","nameid":18,"orders":2},{"enabled":true,"id":153,"moduleid":1,"name":"QWERTY全键盘","nameid":18,"orders":0}],"orders":11,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":false},{"attrName":"","attrType":2,"chooseType":1,"enabled":true,"id":19,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"摄像头类型","options":[{"enabled":true,"id":156,"moduleid":1,"name":"无摄像头","nameid":19,"orders":0},{"enabled":true,"id":157,"moduleid":1,"name":"双摄像头(前后)","nameid":19,"orders":1},{"enabled":true,"id":158,"moduleid":1,"name":"单摄像头(后)","nameid":19,"orders":2},{"enabled":true,"id":159,"moduleid":1,"name":"单摄像头(前)","nameid":19,"orders":3}],"orders":12,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":true},{"attrName":"","attrType":2,"chooseType":1,"enabled":true,"id":20,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"后置摄像头","options":[{"enabled":true,"id":162,"moduleid":1,"name":"300万像素级","nameid":20,"orders":2},{"enabled":true,"id":163,"moduleid":1,"name":"500万像素级","nameid":20,"orders":3},{"enabled":true,"id":164,"moduleid":1,"name":"800万像素级","nameid":20,"orders":4},{"enabled":true,"id":165,"moduleid":1,"name":"1300万像素级","nameid":20,"orders":5},{"enabled":true,"id":166,"moduleid":1,"name":"1600万像素及以上","nameid":20,"orders":6},{"enabled":true,"id":160,"moduleid":1,"name":"无","nameid":20,"orders":0},{"enabled":true,"id":161,"moduleid":1,"name":"200万及以下","nameid":20,"orders":1}],"orders":13,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":true},{"attrName":"","attrType":2,"chooseType":1,"enabled":true,"id":21,"input_uiType":1,"isMain":false,"isRequired":true,"moduleid":1,"muti_maxSelected":0,"name":"手机价格区间","options":[{"enabled":true,"id":173,"moduleid":1,"name":"499元或以下","nameid":21,"orders":0},{"enabled":true,"id":174,"moduleid":1,"name":"500-999元","nameid":21,"orders":1},{"enabled":true,"id":175,"moduleid":1,"name":"1000-1999元","nameid":21,"orders":2},{"enabled":true,"id":176,"moduleid":1,"name":"2000-2999元","nameid":21,"orders":3},{"enabled":true,"id":177,"moduleid":1,"name":"3000-3999元","nameid":21,"orders":4},{"enabled":true,"id":178,"moduleid":1,"name":"4000-4999元","nameid":21,"orders":5}],"orders":14,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":true},{"attrName":"","attrType":2,"chooseType":3,"enabled":true,"id":22,"input_uiType":2,"isMain":false,"isRequired":false,"moduleid":1,"muti_maxSelected":0,"name":"上市时间","options":[],"orders":15,"single_imgAllowed":false,"single_isColor":false,"tips":"","usedInSearch":false}]// 属性列表  ,里面的属性请参考下面AttrDataSample
    };
    //--数据区域。该模型的所有数据。
    var AttrDataSample={
        id:0,//数据库的id
        moduleid:0,//数据库对应的模型id。
        name:"",//属性名称，中文名称。
        attrName:"",//属性的英文名称，用于方便提交表单时候进行相关操作。请注意，同一个模型里面不能有相同的属性名称。
        tips:"",//属性填写提示。
        chooseType:1,//选择类型，1：单选，2：多选，3：手写输入
        attrType:1,//属性类型，1、sku属性，2、普通展示属性。
        isRequired:true,//是否必须填写或选择。
        usedInSearch:true,//是否在搜索里面使用。
        enabled:true,//该属性是否启用。
        isMain:false,//是否主要的sku属性。
        orders:0,//该属性的排位。
        /*single 单选系列参数*/
        single_isColor:false,
        single_imgAllowed:false,
        /*单选参数结束*/
        /*多选系列参数*/
        muti_maxSelected:0,
        /*多选参数结束*/
        /*手动输入系列参数*/
        input_uiType:0,
        /*手动输入参数结束*/
        /*共用，选择类型的option*/
        options:[] //里面的item为：{id:0,name:"",orders:"",color:"",enabled:false}
    };

后台直接接受json数据然后进行处理。