public AjaxRspJson crateObject_alter(crateObject_alter crateObject_Alter) { #region Input Format /* * {"ObjectName":{"Obj_Code":"TTECHNICS","zn_CN":"涂饰标准工艺单","en_US":"TTECHNICS","Is_Enable":"是"},"ObjRelation":[{"is_del":false,"obj_code":"TTECHNICS","obj_table":"DATA_TTECHNICS","zn_CN":"涂饰标准工艺单主表","en_US":"DATA_TTECHNICS","is_main":"是"},{"is_del":false,"obj_code":"TTECHNICS","obj_table":"DATA_TTECHNICS_ITEM0","zn_CN":"涂饰标准工艺单子表","en_US":"DATA_TTECHNICS_ITEM0","is_main":"否"}],"objproperty":[{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"TTECHNICS_CODE","Obj_Pro_Type":1,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":1,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"标准工艺单编码","en_Us":"TTECHNICS_CODE","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS_ITEM0","Obj_Pro_Code":"GB_CODE","Obj_Pro_Type":5,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":1,"Obj_Pro_Default":null,"Obj_Pro_Object":"OPSTAGE","Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"工步编码","en_Us":"gb_code","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"IRATE","Obj_Pro_Type":3,"Obj_Pro_Length":18,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":6,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":1,"Obj_Pro_Usingcheck":1,"Zn_Cn":"损耗量","en_Us":"irate","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"ADDON","Obj_Pro_Type":3,"Obj_Pro_Length":4,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":2,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":1,"Obj_Pro_Usingcheck":1,"Zn_Cn":"用量 g/sf","en_Us":"ADDON","Is_Del":false},{"ID":0,"Is_System":1,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"CREATE_USER","Obj_Pro_Type":1,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":1,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"创建人","en_Us":"CREATE_USER","Is_Del":false},{"ID":0,"Is_System":1,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"MODIFY_USER","Obj_Pro_Type":1,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":1,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"修改人","en_Us":"MODIFY_USER","Is_Del":false},{"ID":0,"Is_System":1,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"CREATE_TIME","Obj_Pro_Type":4,"Obj_Pro_Length":0,"Obj_Pro_Visible":0,"Obj_Pro_Enable":1,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"创建日期","en_Us":"CREATE_TIME","Is_Del":false},{"ID":0,"Is_System":1,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"MODIFY_TIME","Obj_Pro_Type":4,"Obj_Pro_Length":0,"Obj_Pro_Visible":0,"Obj_Pro_Enable":1,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"修改日期","en_Us":"MODIFY_TIME","Is_Del":false},{"ID":0,"Is_System":1,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"VERIFY_TIME","Obj_Pro_Type":4,"Obj_Pro_Length":0,"Obj_Pro_Visible":0,"Obj_Pro_Enable":1,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"确定时间","en_Us":"VERIFY_TIME","Is_Del":false},{"ID":0,"Is_System":1,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"VERIFY_USER","Obj_Pro_Type":1,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":1,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"确定人","en_Us":"VERIFY_USER","Is_Del":false},{"ID":0,"Is_System":1,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"STATUS","Obj_Pro_Type":1,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":1,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"系统状态","en_Us":"STATUS","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"CUSTID","Obj_Pro_Type":1,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":1,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"编码","en_Us":"CUSTID","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"DDATE","Obj_Pro_Type":4,"Obj_Pro_Length":0,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"日期","en_Us":"DDATE","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"TTECHNICS_TEXT","Obj_Pro_Type":1,"Obj_Pro_Length":255,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"版本说明","en_Us":"TTECHNICS_TEXT","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"ITIME","Obj_Pro_Type":2,"Obj_Pro_Length":2,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":1,"Obj_Pro_Usingcheck":1,"Zn_Cn":"次数","en_Us":"ITIME","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS_ITEM0","Obj_Pro_Code":"GB_INDEX","Obj_Pro_Type":1,"Obj_Pro_Length":10,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"工步行号","en_Us":"gb_index","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"VERSION","Obj_Pro_Type":2,"Obj_Pro_Length":18,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":1,"Obj_Pro_Usingcheck":1,"Zn_Cn":"版本","en_Us":"VERSION","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS_ITEM0","Obj_Pro_Code":"MEMO","Obj_Pro_Type":1,"Obj_Pro_Length":255,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"备注","en_Us":"memo","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS_ITEM0","Obj_Pro_Code":"OP","Obj_Pro_Type":5,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":"OP","Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"工艺操作","en_Us":"op","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS_ITEM0","Obj_Pro_Code":"INV_CODE","Obj_Pro_Type":5,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":"U8_INVENTORY","Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"化料编码","en_Us":"inv_code","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"RATESUM","Obj_Pro_Type":3,"Obj_Pro_Length":18,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":6,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":1,"Obj_Pro_Usingcheck":1,"Zn_Cn":"配比合计","en_Us":"ratesum","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS_ITEM0","Obj_Pro_Code":"RATE","Obj_Pro_Type":3,"Obj_Pro_Length":18,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":6,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":1,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":1,"Obj_Pro_Usingcheck":1,"Zn_Cn":"配比","en_Us":"rate","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"COLOR","Obj_Pro_Type":5,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":"COLOR","Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"颜色","en_Us":"color","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"STYLE","Obj_Pro_Type":5,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":"STYLE","Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"风格","en_Us":"style","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"GX_CODE","Obj_Pro_Type":5,"Obj_Pro_Length":10,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":1,"Obj_Pro_Default":null,"Obj_Pro_Object":"SFC_OPERATION","Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"工序编码","en_Us":"GX_CODE","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"BABLE","Obj_Pro_Type":6,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":"JEC","Obj_Pro_Check":1,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"状态","en_Us":"BABLE","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"DISENABLETIME","Obj_Pro_Type":4,"Obj_Pro_Length":0,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":0,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":0,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"状态时间","en_Us":"DISENABLETIME","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"TTECHNICS_NAME","Obj_Pro_Type":1,"Obj_Pro_Length":255,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":1,"Obj_Pro_Default":null,"Obj_Pro_Object":null,"Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"标准工艺单名称","en_Us":"TTECHNICS_NAME","Is_Del":false},{"ID":0,"Is_System":0,"Obj_Code":"TTECHNICS","Obj_Table":"DATA_TTECHNICS","Obj_Pro_Code":"MIX_INV_CODE","Obj_Pro_Type":5,"Obj_Pro_Length":60,"Obj_Pro_Visible":0,"Obj_Pro_Enable":0,"Obj_Pro_Null":1,"Obj_Pro_Default":null,"Obj_Pro_Object":"U8_INVENTORY","Obj_Pro_Digit":0,"Obj_Pro_Using":0,"Obj_Pro_Enum":null,"Obj_Pro_Check":0,"Obj_Pro_Order":0,"Obj_Pro_Show":1,"Obj_Pro_Positive":0,"Obj_Pro_Usingcheck":1,"Zn_Cn":"混合料编码","en_Us":"MIX_INV_CODE","Is_Del":false}],"allobj":[{"Obj_Code":"ROUTINGTYPE","Value":"工艺类别"},{"Obj_Code":"PRODCLLIN","Value":"产品分类生产路线"},{"Obj_Code":"PRODCLLIN_ITEM0","Value":"产品分类生产路线子表"},{"Obj_Code":"PRODUCTCLINE","Value":"产品生产路线"},{"Obj_Code":"TECHPROUTING","Value":"工艺路线"},{"Obj_Code":"SERIAL","Value":"流水"},{"Obj_Code":"BURDENING","Value":"配料单"},{"Obj_Code":"CURRENTSTOCK","Value":"存货现存量"},{"Obj_Code":"TECHNICS","Value":"标准工艺单1"},{"Obj_Code":"TECHNICS_ITEM0","Value":"标准工艺单1子表"},{"Obj_Code":"PALLET","Value":"托盘"},{"Obj_Code":"PALLET_ITEM0","Value":"托盘子表"},{"Obj_Code":"BURDENING_ITEM0","Value":"配料单子表"},{"Obj_Code":"CALENDAR","Value":"工作日历"},{"Obj_Code":"NT_CTRL","Value":"路线工序控制"},{"Obj_Code":"NT_CTRL_ITEM0","Value":"路线工艺控制子表"},{"Obj_Code":"GROUP_STD","Value":"组批规格对照"},{"Obj_Code":"NR_CTRL","Value":"流转单工序控制"},{"Obj_Code":"NR_CTRL_ITEM0","Value":"工序控制子表"},{"Obj_Code":"sys_obj.ObjectPropertyControl","Value":"属性列表"},{"Obj_Code":"sys_obj.ObjectPropertyOperationControl","Value":"属性操作"},{"Obj_Code":"sys_obj.ObjectListAlertPrint","Value":"打印模板"},{"Obj_Code":"sys_obj.ObjectLayoutControl","Value":"单据布局"},{"Obj_Code":"BOX","Value":"箱"},{"Obj_Code":"OUTSTOCK_ITEM0","Value":"出库单子表"},{"Obj_Code":"COMMANDVOUCH","Value":"生产指令单"},{"Obj_Code":"REQUISITION","Value":"调拨单"},{"Obj_Code":"BOX_BARCODE_ITEM0","Value":"箱码档案子表"},{"Obj_Code":"WH_INV_RE","Value":"仓库存货对照"},{"Obj_Code":"OUTSTOCK","Value":"出库单"},{"Obj_Code":"WS_WH_RE","Value":"工位线边仓对照"},{"Obj_Code":"PRODUCTCLINE_ITEM0","Value":"产品生产线子表"},{"Obj_Code":"WSOPERATION","Value":"标准工序工位对照"},{"Obj_Code":"REQUISITION_ITEM0","Value":"调拨单表体"},{"Obj_Code":"REASONCLASS","Value":"原因分类"},{"Obj_Code":"TEAM","Value":"班组"},{"Obj_Code":"STATIONEQUIPMENT","Value":"工位设备对照"},{"Obj_Code":"REASON","Value":"原因档案"},{"Obj_Code":"FACTORY","Value":"工厂"},{"Obj_Code":"POSITIONALT","Value":"货位调整单"},{"Obj_Code":"EQUIPMENTCLASS","Value":"设备分类"},{"Obj_Code":"EQUIPMENT","Value":"设备"},{"Obj_Code":"ENUMMETHON","Value":"枚举对象"},{"Obj_Code":"CALENDAR_ITEM1","Value":"工作日班次明细表"},{"Obj_Code":"WAREHOUSELISTS","Value":"仓库"},{"Obj_Code":"POSITIONALT_ITEM0","Value":"货位调整表体"},{"Obj_Code":"BARCODECLASS","Value":"条码分类"},{"Obj_Code":"PRODUCTIONLINE","Value":"生产线"},{"Obj_Code":"sys_obj.ObjectListAlertControlLeft","Value":"左侧筛选设置"},{"Obj_Code":"sys_obj.ObjectListAlertControlQuery","Value":"快速查询设置"},{"Obj_Code":"BCRECORD","Value":"班次"},{"Obj_Code":"CUSCLAFILE","Value":"客户分类"},{"Obj_Code":"INVENTORY","Value":"存货"},{"Obj_Code":"WORKSTATION","Value":"工位"},{"Obj_Code":"PDEPARTMENT","Value":"部门"},{"Obj_Code":"BOM_BOM","Value":"物料清单"},{"Obj_Code":"BOM_BOM_ITEM0","Value":"物料清单子表"},{"Obj_Code":"sys_obj.ObjectListAlertControlVouchLeft","Value":"单据左侧筛选"},{"Obj_Code":"LOG","Value":"日志"},{"Obj_Code":"INVENTORYCLASS","Value":"存货分类"},{"Obj_Code":"SUPPLIERFILE","Value":"供应商分类"},{"Obj_Code":"SUPCLASSIFI","Value":"供应商"},{"Obj_Code":"PR_ORDER_ITEM0","Value":"生产订单子表"},{"Obj_Code":"WORKSHOP","Value":"车间"},{"Obj_Code":"WAREHOUSEFILES","Value":"货位"},{"Obj_Code":"TECHPROUTING_ITEM0","Value":"工艺路线子表1"},{"Obj_Code":"PR_ORDER","Value":"生产订单"},{"Obj_Code":"COMPUTATIONGROUP","Value":"计量单位组"},{"Obj_Code":"COMPUTATIONUNIT","Value":"计量单位"},{"Obj_Code":"GROUP_STD_ITEM0","Value":"DATA_GROUP_STD_ITEM0"},{"Obj_Code":"BUSINESS","Value":"业务类型"},{"Obj_Code":"sys_obj.SetMenuAuth","Value":"菜单权限设置"},{"Obj_Code":"sys_obj.SetOperationAuth","Value":"对象权限设置"},{"Obj_Code":"SFC_OPERATION_ITEM0","Value":"标准工序表体"},{"Obj_Code":"BOX_BARCODE","Value":"箱码档案"},{"Obj_Code":"sys_obj.ObjectList","Value":"对象列表"},{"Obj_Code":"sys_obj.SetMenuControl","Value":"菜单设置"},{"Obj_Code":"sys_obj.ObjectOperationControl","Value":"对象操作"},{"Obj_Code":"sys_obj.ObjectListAlertControl","Value":"列表布局"},{"Obj_Code":"TEST","Value":"测试专用"},{"Obj_Code":"CHECKVOUCH","Value":"盘点单"},{"Obj_Code":"CHECKVOUCH_ITEM0","Value":"盘点单子表"},{"Obj_Code":"AGVCLASS","Value":"AGV分类"},{"Obj_Code":"RULEASSIGN","Value":"存货规则分配"},{"Obj_Code":"INVBARCODE","Value":"存货条码档案"},{"Obj_Code":"AGV","Value":"AGV维护"},{"Obj_Code":"INSTOCK","Value":"入库单"},{"Obj_Code":"INSTOCK_ITEM0","Value":"入库单子表"},{"Obj_Code":"LABEL_DESIGN","Value":"标签"},{"Obj_Code":"RULESETTING","Value":"规则设置"},{"Obj_Code":"RULESETTING_ITEM0","Value":"规则设置子表"},{"Obj_Code":"CSTOCKS","Value":"货位现存量"},{"Obj_Code":"BOOLEAN","Value":"布尔型"},{"Obj_Code":"CALENDAR_ITEM0","Value":"班次日历子表"},{"Obj_Code":"COMMANDVOUCH_ITEM0","Value":"生产指令单子表"},{"Obj_Code":"TT_VO_MERGE","Value":"涂饰工艺单合并"},{"Obj_Code":"TT_VO_MERGE_ITEM0","Value":"涂饰工艺单合并子表"},{"Obj_Code":"CUSTOMERFILE","Value":"客户"},{"Obj_Code":"DECHILV","Value":"得尺率"},{"Obj_Code":"DOR","Value":"DOR报告"},{"Obj_Code":"ORDERSTATUS","Value":"订单状态报告"},{"Obj_Code":"MATCALCULATE","Value":"化料需求测算"},{"Obj_Code":"MATE_COST","Value":"化料成本对比报告"},{"Obj_Code":"UA_USER","Value":"人员"},{"Obj_Code":"ROLE","Value":"角色"},{"Obj_Code":"ROLE_USER","Value":"角色人员分配"},{"Obj_Code":"TTECHNICS_VO","Value":"涂饰工艺单"},{"Obj_Code":"TTECHNICS_VO_ITEM0","Value":"涂饰工艺单子表"},{"Obj_Code":"OPSTAGE","Value":"工步"},{"Obj_Code":"DETAILWEIGHT","Value":"托盘明细"},{"Obj_Code":"NWORKLIST","Value":"不量革报工"},{"Obj_Code":"REP_PLAN","Value":"报表发送计划"},{"Obj_Code":"U8_DEPT","Value":"(U8)部门档案"},{"Obj_Code":"REP_STYLE","Value":"报表类型"},{"Obj_Code":"MIX_DETAIL","Value":"混合料消耗明细报表"},{"Obj_Code":"FG_PIREPORT","Value":"坯革生产报告"},{"Obj_Code":"PICKUP","Value":"蓝皮挑选单"},{"Obj_Code":"NTECHNICS_VO","Value":"转鼓工艺单"},{"Obj_Code":"NTECHNICS_VO_ITEM0","Value":"转鼓工艺单子表"},{"Obj_Code":"EX_SYSTEM","Value":"外部系统"},{"Obj_Code":"MATEPROSPECT","Value":"化料库存展望"},{"Obj_Code":"MATEPROSPECT_ITEM0","Value":"化料展望子表"},{"Obj_Code":"REP_EXEC","Value":"计划执行情况"},{"Obj_Code":"GROUP_REPORT","Value":"组批明细报表"},{"Obj_Code":"FGBLUEREPORT","Value":"蓝皮分级报告"},{"Obj_Code":"U8_MO","Value":"生产订单(U8)"},{"Obj_Code":"GROUP_VOUCH_ITEM0","Value":"组批单子表"},{"Obj_Code":"GROUP_VOUCH","Value":"组批单"},{"Obj_Code":"TS_CHECK","Value":"涂饰工艺单确认"},{"Obj_Code":"TS_CHECK_ITEM0","Value":"涂饰工艺单确认子表"},{"Obj_Code":"U8_INV_POWER","Value":"联产品分配率"},{"Obj_Code":"U8_INV_POWER_ITEM0","Value":"联产品分配率子表"},{"Obj_Code":"WORKLIST","Value":"报工单"},{"Obj_Code":"WORKLIST_ITEM0","Value":"报工单子表"},{"Obj_Code":"INDIRECTCOST","Value":"标准其他间接费用"},{"Obj_Code":"FG_OFFER","Value":"蓝皮标准成本测算"},{"Obj_Code":"FG_OFFER_ITEM1","Value":"蓝皮报价单子表2"},{"Obj_Code":"FG_OFFER_ITEM0","Value":"蓝皮报价单子表1"},{"Obj_Code":"FG_OFFER_PI","Value":"坯革标准成本测算"},{"Obj_Code":"MO_INV_REFER","Value":"生产存货等级对照"},{"Obj_Code":"MO_INV_REFER_ITEM0","Value":"生产存货等级对照字表"},{"Obj_Code":"OP","Value":"工艺操作档案"},{"Obj_Code":"NTECHNICS","Value":"转鼓标准工艺单"},{"Obj_Code":"NTECHNICS_ITEM0","Value":"转鼓标准工艺单子表"},{"Obj_Code":"PRO_ROUTE","Value":"产品工艺路线"},{"Obj_Code":"PRO_ROUTE_ITEM1","Value":"产品工艺路线子表1"},{"Obj_Code":"PRO_ROUTE_ITEM0","Value":"产品工艺路线子表0"},{"Obj_Code":"TTECHNICS","Value":"涂饰标准工艺单"},{"Obj_Code":"TTECHNICS_ITEM0","Value":"涂饰标准工艺单子表"},{"Obj_Code":"NT_VO_MERGE","Value":"转鼓工艺单合并"},{"Obj_Code":"NT_VO_MERGE_ITEM0","Value":"转鼓工艺单合并子表"},{"Obj_Code":"FG_OFFER_PI_ITEM1","Value":"坯革报价单子表2"},{"Obj_Code":"FG_OFFER_PI_ITEM0","Value":"坯革报价单子表1"},{"Obj_Code":"STYLE","Value":"风格"},{"Obj_Code":"TRANSVOUCH","Value":"工序流转单1"},{"Obj_Code":"TREATINGWAYS","Value":"处理方式"},{"Obj_Code":"COMPANY","Value":"公司信息"},{"Obj_Code":"BAD_REPORT","Value":"不合格品报告"},{"Obj_Code":"ENDWORKLIST","Value":"产成品入库推单报告"},{"Obj_Code":"PDA_REPORT","Value":"PDA皮料出库报告"},{"Obj_Code":"SP_MATERIAL","Value":"化料推单报告"},{"Obj_Code":"FG_OFFER_CP","Value":"成品标准成本测算"},{"Obj_Code":"TRANSVOUCH_ITEM0","Value":"工序流转单子表1"},{"Obj_Code":"U8_MOTYPE","Value":"(U8)生产订单类别"},{"Obj_Code":"FG_OFFER_CP_ITEM1","Value":"成品报价单子表2"},{"Obj_Code":"FG_OFFER_CP_ITEM0","Value":"成品报价单子表1"},{"Obj_Code":"TRANS_VOUCH","Value":"工序流转单"},{"Obj_Code":"TRANS_VOUCH_ITEM1","Value":"工序流转单子表2"},{"Obj_Code":"TRANS_VOUCH_ITEM0","Value":"工序流转单子表"},{"Obj_Code":"MIX_REPORT","Value":"混合料汇总报告"},{"Obj_Code":"U8_RD_STYLE","Value":"(U8)收发类别"},{"Obj_Code":"BADRECORD","Value":"不合格品记录单"},{"Obj_Code":"NTS_CTRL","Value":"工序控制档案"},{"Obj_Code":"U8_INVENTORY","Value":"(U8)存货档案"},{"Obj_Code":"COLOR","Value":"颜色"},{"Obj_Code":"U8_SO","Value":"(U8)销售订单"},{"Obj_Code":"LAN_SPLIT","Value":"外购蓝皮分托单"},{"Obj_Code":"LAN_SPLIT_ITEM0","Value":"外购蓝皮分托单子表"},{"Obj_Code":"SFC_OPERATION","Value":"标准工序"},{"Obj_Code":"TECHNICS_VOU","Value":"工艺单1"},{"Obj_Code":"TECHNICS_VOU_ITEM0","Value":"工艺单1子表"},{"Obj_Code":"INVPROSPECT","Value":"皮料库存展望"},{"Obj_Code":"INVPROSPECT_ITEM0","Value":"皮料库存展望子表"},{"Obj_Code":"REP_ROLE","Value":"报表-角色对照"},{"Obj_Code":"WHOUSE","Value":"(U8)仓库档案"},{"Obj_Code":"DIRECTFREE","Value":"标准其他直接费用"},{"Obj_Code":"FUPRODUCTION","Value":"副产品档案"},{"Obj_Code":"FUPRODUCTION_ITEM0","Value":"副产品档案子表"},{"Obj_Code":"PRO_PLAN","Value":"计划产量"},{"Obj_Code":"PRO_PLAN_ITEM0","Value":"计划产量子表"}],"allobjtab":[{"Obj_Table":"DATA_TTECHNICS"},{"Obj_Table":"DATA_TTECHNICS_ITEM0"}]} */ #endregion try { if (ModelState.IsValid) { Dictionary <string, string> Result = _objectCreate.crateObject_alter(crateObject_Alter); return(new AjaxRspJson { RspCode = RspStatus.Successed, ObjectData = Result, RspMsg = "" }); } else { return(new AjaxRspJson { RspCode = RspStatus.Failed, ObjectData = null, RspMsg = "无法将值反序列化为对象" }); } } catch (Exception e) { return(new AjaxRspJson { RspCode = RspStatus.Failed, ObjectData = null, RspMsg = e.Message }); } }
public Dictionary <string, string> crateObject_alter(crateObject_alter createObject_Alter) { try { string Result = ObjectCreateDataAccess.crateObject_alter(createObject_Alter); Dictionary <string, string> keyValuePairs = new Dictionary <string, string>(); keyValuePairs.Add("REEES", Result); return(keyValuePairs); } catch (Exception e) { throw e; } }
public static string crateObject_ADD(crateObject_alter crateObject_Alter) { try { using (IDbConnection dbConnection = (new AppDataBase()).connection) { dbConnection.Open(); IDbTransaction transaction = dbConnection.BeginTransaction(); try { #region 对象名称 Obj_Name obj_Name = crateObject_Alter.ObjectName; if (obj_Name != null) { string obj_code = obj_Name.Obj_Code; string zn_CN1 = obj_Name.zn_CN; string en_US1 = obj_Name.en_US; string is_enable = obj_Name.Is_Enable; //Update_FLC_Lang(dbConnection, obj_code, zn_CN1, en_US1, transaction); string sql = "delete FLC_OBJECT where obj_code = :obj_code"; var parm1 = new DynamicParameters(); parm1.Add(":obj_code", obj_code); // AppDataBase.ExecuteScalar(sql, dbConnection, parm1, transaction); sql = "select count(*) from FLC_OBJECT where obj_code = :obj_code"; string str = AppDataBase.ExecuteScalar(sql, dbConnection, parm1, transaction).ToString(); int id1 = MethodGetSerial.getSerialNumInt("FLC_OBJECT", transaction, dbConnection); string inobject = "insert into FLC_OBJECT(id,obj_code,is_enable) values (:id,:obj_code,:is_enable)"; var parm2 = new DynamicParameters(); parm2.Add(":id", id1); parm2.Add(":obj_code", obj_code); parm2.Add(":is_enable", is_enable); AppDataBase.Execute(inobject, parm2, transaction); } //取得流水号 #endregion #region 对象表新增 List <ObjRelation> objRelations = crateObject_Alter.ObjRelation; foreach (ObjRelation dr in objRelations) { string obj_code = dr.obj_code; string obj_table = dr.obj_table; string zn_CN2 = dr.zn_CN; string en_US2 = dr.en_US; int is_main = dr.is_main; //只做中英文修改 还有删除操作(flc_objects flc_obj_property flc_lang 中删除,删除表) string sign = obj_code + "." + obj_table; // Update_FLC_Lang(sign, zn_CN2, en_US2,transaction); #region 在FLC_OBJECTS新增对应数据 //在FLC_OBJECTS删除对应数据 string sql = "delete FLC_OBJECTS where obj_code = :obj_code and obj_table=:obj_table"; var parm3 = new DynamicParameters(); parm3.Add(":obj_code", obj_code); parm3.Add(":obj_table", obj_table); AppDataBase.ExecuteScalar(sql, dbConnection, parm3, transaction); //在FLC_OBJECTS新增对应数据 sql = "insert into FLC_OBJECTS(obj_code,obj_table,is_main,id) values (:obj_code,:obj_table,:is_main,:id)"; //取得流水号 int id2 = MethodGetSerial.getSerialNumInt("FLC_OBJECTS", transaction); var parm4 = new DynamicParameters(); parm4.Add(":obj_code", obj_code); parm4.Add(":obj_table", obj_table); parm4.Add(":is_main", is_main); parm4.Add(":id", id2); AppDataBase.Execute(sql, parm4, transaction); #endregion #region 构建对象表 //查找此表是否存在语句 string setable = "select count(*) coun from user_tables where table_name=:obj_table"; var parm5 = new DynamicParameters(); parm5.Add(":obj_table", obj_table); //创建表语句 //主表 string creobjtab = "create table {0} (id number null)"; creobjtab = string.Format(creobjtab, obj_table); //子表 string creobjtabs = "create table {0} (id number null,mid number null)"; creobjtabs = string.Format(creobjtabs, obj_table); //查找此表是否存在 存在删除再创建。 int count = Convert.ToInt32(AppDataBase.ExecuteScalar(setable, dbConnection, parm5, transaction)); if (count > 0) { sql = "drop table " + obj_table; AppDataBase.Execute(sql, null, transaction); } if (is_main == 1) { AppDataBase.Execute(creobjtab, null, transaction); } else { AppDataBase.Execute(creobjtabs, null, transaction); } #endregion } #endregion #region 对象属性 List <Flc_Object_Property> objproperty = crateObject_Alter.Objproperty; foreach (Flc_Object_Property dr in objproperty) { #region 属性 string obj_code = dr.Obj_Code.ToUpper(); string obj_table = dr.Obj_Table.ToUpper(); string obj_pro_code = dr.Obj_Pro_Code.ToUpper(); int obj_pro_type = Convert.ToInt32(dr.Obj_Pro_Type); string obj_pro_length; if (dr.Obj_Pro_Length.ToString() == null) { obj_pro_length = " "; } else { obj_pro_length = dr.Obj_Pro_Length.ToString(); } int obj_pro_visible = dr.Obj_Pro_Visible; int obj_pro_enable = dr.Obj_Pro_Enable; int obj_pro_null = dr.Obj_Pro_Null; if (dr.Obj_Pro_Default == null) { dr.Obj_Pro_Default = " "; } string obj_pro_default = dr.Obj_Pro_Default; if (dr.Obj_Pro_Object == null) { dr.Obj_Pro_Object = " "; } string obj_pro_object = dr.Obj_Pro_Object; string obj_pro_digit; if (dr.Obj_Pro_Digit == null) { obj_pro_digit = " "; } else { obj_pro_digit = dr.Obj_Pro_Digit.ToString(); } int obj_pro_using = dr.Obj_Pro_Using; string zn_CN3 = dr.Zn_Cn; string en_US3 = dr.en_Us; #endregion string codes = obj_code + "." + obj_table + "." + obj_pro_code; //Update_FLC_Lang(codes, zn_CN3, en_US3,transaction); #region 在FLC_OBJECT_PROPERTY插入数据 string sql = "delete FLC_OBJECT_PROPERTY where obj_code=:obj_code and obj_pro_code=:obj_pro_code"; var parm6 = new DynamicParameters(); parm6.Add(":obj_code", obj_code); parm6.Add(":obj_pro_code", obj_pro_code); AppDataBase.ExecuteScalar(sql, dbConnection, parm6, transaction); string infopro = @"insert into FLC_OBJECT_PROPERTY values(:obj_code,:obj_table,:obj_pro_code,:obj_pro_type,:obj_pro_length, :obj_pro_visible,:obj_pro_enable,:obj_pro_null,:obj_pro_default,:obj_pro_object,:obj_pro_digit,:obj_pro_using)"; var parm7 = new DynamicParameters(); parm7.Add(":obj_code", obj_code); parm7.Add(":obj_table", obj_table); parm7.Add(":obj_pro_code", obj_pro_code); parm7.Add(":obj_pro_type", obj_pro_type); parm7.Add(":obj_pro_length", obj_pro_length); parm7.Add(":obj_pro_visible", obj_pro_visible); parm7.Add(":obj_pro_enable", obj_pro_enable); parm7.Add(":obj_pro_null", obj_pro_null); parm7.Add(":obj_pro_default", obj_pro_default); parm7.Add(":obj_pro_object", obj_pro_object); parm7.Add(":obj_pro_digit", obj_pro_digit); parm7.Add(":obj_pro_using", obj_pro_using); AppDataBase.Execute(infopro, parm7, transaction); #endregion #region 在表中插入数据 //拼类型 string typess = string.Empty; switch (obj_pro_type) { case 1: typess = "nvarchar2(" + obj_pro_length + ")"; break; case 2: typess = "nvarchar2(" + obj_pro_length + ")"; break; case 3: typess = "number(" + obj_pro_length + ")"; break; case 4: typess = "Date"; break; case 5: typess = "nvarchar2(60)"; break; default: typess = "nvarchar2(255)"; break; } //在对象表中添加该属性 string add = "alter table " + obj_table + " add " + obj_pro_code + " {0}"; add = string.Format(add, typess); AppDataBase.Execute(add, null, transaction); #endregion } #endregion transaction.Commit(); } catch (Exception e) { transaction.Rollback(); // dbConnection.Close(); //transaction.Dispose(); throw e; } } } catch (Exception e) { throw e; } return("ok"); }
public static string crateObject_alter(crateObject_alter crateObject_Alter) { try { using (IDbConnection dbConnection = AppDataBase.DbConection) { // dbConnection=new dbConnection.Open(); IDbTransaction transaction = dbConnection.BeginTransaction(); try { #region 对象名称 Obj_Name obj_Name = crateObject_Alter.ObjectName; if (obj_Name != null) { string obj_code = obj_Name.Obj_Code; string zn_CN = obj_Name.zn_CN; string en_US = obj_Name.en_US; if (obj_Name.Is_Enable == "是") { obj_Name.Is_Enable = "1"; } else { obj_Name.Is_Enable = "0"; } int is_enable = Convert.ToInt32(obj_Name.Is_Enable); string upobject = "update FLC_OBJECT set is_enable=:is_enable where obj_code = :obj_code"; var parm3 = new DynamicParameters(); parm3.Add(":is_enable", is_enable); parm3.Add(":obj_code", obj_code); AppDataBase.Execute(upobject, parm3, transaction); //Update_FLC_Lang(obj_code, zn_CN, en_US, transaction); } #endregion #region 对象表修改 List <ObjRelation> objRelations = crateObject_Alter.ObjRelation; foreach (ObjRelation dr in objRelations) { int is_del = dr.is_del; string obj_code = dr.obj_code; string obj_table = dr.obj_table; string zn_CN2 = dr.zn_CN; string en_US2 = dr.en_US; int is_main = dr.is_main; //只做中英文修改 还有删除操作(flc_objects flc_obj_property flc_lang 中删除,删除表) string signs = obj_code + "." + obj_table; #region 除操作 if (is_del == 1) { //主表不删除 if (is_main == 0) { //flc_objects删除 string del_objects = "delete from FLC_OBJECTS where obj_code=:obj_code and obj_table=:obj_table"; //flc_obj_property删除 string delvalue_FlcObjPro = "delete from FLC_OBJECT_PROPERTY where obj_code=:obj_code and obj_table=:obj_table"; var parm1 = new DynamicParameters(); parm1.Add(":obj_code", obj_code); parm1.Add(":obj_table", obj_table); //flc_lang删除 string delvalue_FlcLang = "delete from FLC_LANG where key='" + signs + "'"; string sele_tb = "select count(*) from user_tables where table_name='" + obj_table + "'"; string drop_table = "drop table " + obj_table; AppDataBase.Execute(del_objects, parm1, transaction); AppDataBase.Execute(delvalue_FlcObjPro, parm1, transaction); AppDataBase.Execute(delvalue_FlcLang, transaction); //判断表是否存在 int i = Convert.ToInt32(AppDataBase.ExecuteScalar(sele_tb, null, transaction)); if (i > 0) { AppDataBase.Execute(drop_table, null, transaction); } else { throw new Exception("此表不存在 "); } } } #endregion #region 修改操作或新增 else { // Update_FLC_Lang(signs, zn_CN2, en_US2, transaction); string seobjects = "Select count(*) from FLC_OBJECTS where obj_code = :obj_code and obj_table=:obj_table"; var parm10 = new DynamicParameters(); parm10.Add(":obj_code", obj_code); parm10.Add(":obj_table", obj_table); string inobjects = "insert into FLC_OBJECTS(obj_code,obj_table,is_main,id) values (:obj_code,:obj_table,:is_main,:id)"; //不存在就插入 int count = Convert.ToInt32(AppDataBase.ExecuteScalar(seobjects, dbConnection, parm10, transaction)); if (count < 1) { int id = MethodGetSerial.getSerialNumInt("FLC_OBJECTS", transaction); var parm11 = new DynamicParameters(); parm11.Add(":obj_code", obj_code); parm11.Add(":obj_table", obj_table); parm11.Add(":is_main", is_main); parm11.Add(":id", id); AppDataBase.Execute(inobjects, parm11); //新增之后构建表 string creobjtab = "create table {0} (id number null,mid number null)"; creobjtab = string.Format(creobjtab, obj_table, transaction); string setable = "select count(*) coun from user_tables where table_name=:obj_table"; var parm12 = new DynamicParameters(); parm12.Add(":obj_table", obj_table); int i = Convert.ToInt32(AppDataBase.ExecuteScalar(setable, dbConnection, parm12, transaction)); if (count < 1) { AppDataBase.Execute(creobjtab, null, transaction); } } } #endregion } #endregion #region 对象表属性修改 List <Flc_Object_Property> objproperty = crateObject_Alter.Objproperty; foreach (Flc_Object_Property dr in objproperty) { #region 属性 string is_del = dr.Is_Del.ToString(); string obj_code = dr.Obj_Code.ToUpper(); string obj_table = dr.Obj_Table.ToUpper(); string obj_pro_code = dr.Obj_Pro_Code.ToUpper(); int obj_pro_type = Convert.ToInt32(dr.Obj_Pro_Type); string obj_pro_length; if (dr.Obj_Pro_Length.ToString() == null) { obj_pro_length = " "; } else { obj_pro_length = dr.Obj_Pro_Length.ToString(); } int obj_pro_visible = dr.Obj_Pro_Visible; int obj_pro_enable = dr.Obj_Pro_Enable; int obj_pro_null = dr.Obj_Pro_Null; if (dr.Obj_Pro_Default == null) { dr.Obj_Pro_Default = " "; } string obj_pro_default = dr.Obj_Pro_Default; if (dr.Obj_Pro_Object == null) { dr.Obj_Pro_Object = " "; } string obj_pro_object = dr.Obj_Pro_Object; string obj_pro_digit; if (dr.Obj_Pro_Digit == null) { obj_pro_digit = " "; } else { obj_pro_digit = dr.Obj_Pro_Digit.ToString(); } int obj_pro_using = dr.Obj_Pro_Using; string zn_CN = dr.Zn_Cn; string en_US = dr.en_Us; string codes = obj_code + "." + obj_table + "." + obj_pro_code; #endregion #region 除操作 if (is_del == "1" || is_del == "true") { string sefopro = "Select count(*) from FLC_OBJECT_PROPERTY where obj_code=:obj_code and obj_pro_code=:obj_pro_code"; var parm3 = new DynamicParameters(); parm3.Add(":obj_code", obj_code); parm3.Add(":obj_pro_code", obj_pro_code); int count = Convert.ToInt32(AppDataBase.ExecuteScalar(sefopro, dbConnection, parm3, transaction)); if (count < 1) { continue; } else { //1.属性表中删除,2.语言表删除 3.对象表中删除 string delvalue_FlcObjPro = "delete from FLC_OBJECT_PROPERTY where obj_code=:obj_code and obj_pro_code=:obj_pro_code"; AppDataBase.Execute(delvalue_FlcObjPro, parm3, transaction); string delvalue_FlcLang = "delete from FLC_LANG where key='{0}'"; AppDataBase.Execute(string.Format(delvalue_FlcLang, codes), null, transaction); string delcolumn = "Alter table {0} drop column {1}"; AppDataBase.Execute(string.Format(delcolumn, obj_table, obj_pro_code), null, transaction); } } #endregion #region 新增或更新操作 else { #region 操作语言表 //Update_FLC_Lang(codes, zn_CN, en_US, transaction); codes = string.Empty; #endregion string sefopro = "Select count(*) from FLC_OBJECT_PROPERTY where obj_code=:obj_code and obj_pro_code=:obj_pro_code"; string infopro = @"insert into FLC_OBJECT_PROPERTY values(:obj_code,:obj_table,:obj_pro_code,:obj_pro_type,:obj_pro_length, :obj_pro_visible,:obj_pro_enable,:obj_pro_null,:obj_pro_default,:obj_pro_object,:obj_pro_digit,:obj_pro_using)"; string upfopro = @"update FLC_OBJECT_PROPERTY set obj_code=:obj_code,obj_table=:obj_table,obj_pro_code=:obj_pro_code,obj_pro_type=:obj_pro_type,obj_pro_length=:obj_pro_length, obj_pro_visible=:obj_pro_visible,obj_pro_enable=:obj_pro_enable,obj_pro_null=:obj_pro_null,obj_pro_default=:obj_pro_default,obj_pro_object=:obj_pro_object, obj_pro_digit=:obj_pro_digit,obj_pro_using=:obj_pro_using where obj_code=:obj_code and obj_pro_code=:obj_pro_code"; var parm3 = new DynamicParameters(); parm3.Add(":obj_code", obj_code); parm3.Add(":obj_pro_code", obj_pro_code); var parm4 = new DynamicParameters(); parm4.Add(":obj_code", obj_code); parm4.Add(":obj_table", obj_table); parm4.Add(":obj_pro_code", obj_pro_code); parm4.Add(":obj_pro_type", obj_pro_type); parm4.Add(":obj_pro_length", obj_pro_length); parm4.Add(":obj_pro_visible", obj_pro_visible); parm4.Add(":obj_pro_enable", obj_pro_enable); parm4.Add(":obj_pro_null", obj_pro_null); parm4.Add(":obj_pro_default", obj_pro_default); parm4.Add(":obj_pro_object", obj_pro_object); parm4.Add(":obj_pro_digit", obj_pro_digit); parm4.Add(":obj_pro_using", obj_pro_using); string typess = string.Empty; switch (obj_pro_type) { case 1: typess = "nvarchar2(" + obj_pro_length + ")"; break; case 2: typess = "nvarchar2(" + obj_pro_length + ")"; break; case 3: typess = "number(" + obj_pro_length + ")"; break; case 4: typess = "Date"; break; case 5: typess = "nvarchar2(60)"; break; //case 6: //typess = "nvarchar2(255)"; //break; default: typess = "nvarchar2(255)"; break; } int count = Convert.ToInt32(AppDataBase.ExecuteScalar(sefopro, dbConnection, parm3, transaction)); if (count < 1) { AppDataBase.Execute(infopro, parm4, transaction); //判断表是否存在 不存在报错 string setable = "select count(*) coun from user_tables where table_name='" + obj_table + "'"; int i = Convert.ToInt32(AppDataBase.ExecuteScalar(setable, null, transaction)); if (i > 0) { //在对象表中添加该属性 string add = "alter table " + obj_table + " add " + obj_pro_code + " " + typess; AppDataBase.Execute(add, null, transaction); } } else { //更新之后对应语言表也要更新(已完成) 同时对象表也要更新修改 //此处修改对象表有1种 修改字段类型 string gettype = "select obj_pro_type from flc_object_property where obj_code=:obj_code and obj_pro_code=:obj_pro_code"; string getlength = "select obj_pro_length from flc_object_property where obj_code=:obj_code and obj_pro_code=:obj_pro_code"; var parm5 = new DynamicParameters(); parm5.Add(":obj_code", obj_code); parm5.Add(":obj_pro_code", obj_pro_code); int type = Convert.ToInt32(AppDataBase.ExecuteScalar(gettype, dbConnection, parm5, transaction)); string length = AppDataBase.ExecuteScalar(getlength, dbConnection, parm5, transaction).ToString(); if (length == "") { length = "0"; } //更新属性表中值 AppDataBase.Execute(upfopro, parm4, transaction); if (obj_pro_length == "") { obj_pro_length = "0"; } if (type == obj_pro_type && Convert.ToInt32(length) >= Convert.ToInt32(obj_pro_length)) { continue; } else { //此处异常会有很多 try { string alter = "alter table {0} modify {1} {2}"; alter = string.Format(alter, obj_table, obj_pro_code, typess); AppDataBase.Execute(alter, null, transaction); } catch (Exception e) { throw new Exception(e.ToString()); } } } } } #endregion #endregion } catch (Exception e) { transaction.Rollback(); throw e; } transaction.Commit(); } } catch (Exception e) { throw e; } return("ok"); }