CommonDataMappingClass映射表

一、类名Class

类名:PublicFunctions.CommonDataMappingClass;针对框架或CRM的CommonDataMapping表

 

二、属性Properties

 

三、方法Methods

1、检查值是否存在

函数:public static bool CheckIsDuplicatedData(DBHelper.RawDBHelper.SqlDataFactory context, string Type, string Key, string Value)

context:数据库对象,如果是框架数据库,则针对的是框架的CommonDataMapping表

返回: true/false

 

2、检查值是否存在(重载)

函数:public static bool CheckIsDuplicatedData(DBHelper.RawDBHelper.SqlDataFactory context, string Type, string Key, string Value, string Status)

返回: true/false

 

3、保存到CommonDataMapping

函数:public static bool Set(DBHelper.RawDBHelper.SqlDataFactory context, string Type, string Key, List ValueList)

返回: true/false

 

4、保存到CommonDataMapping(重载)

函数:public static bool Set(DBHelper.RawDBHelper.SqlDataFactory context, string Type, string Key, List ValueList, string Status, string Note)

返回: true/false

 

5、获取关系字典

函数:public static Dictionary Get(DBHelper.RawDBHelper.SqlDataFactory context, string Type)

返回: Dictionary

 

6、获得value列表

函数:public static List Get(DBHelper.RawDBHelper.SqlDataFactory context, string Type, string Key)

返回: List

 

7、获得key列表

函数:public static List GetKey(DBHelper.RawDBHelper.SqlDataFactory context, string Type, string Value)

返回: List

 

8、获得key列表(重载)

函数:public static List GetKey(DBHelper.RawDBHelper.SqlDataFactory context, string Type, string Value, string Status)

返回: List

 

9、删除

函数:public static int Count(DBHelper.RawDBHelper.SqlDataFactory context, string Type = "", string Key = "", string Value = "", string Status = "")

返回: int

 

10、删除一个Key的所有值

函数:public static void Delete(DBHelper.RawDBHelper.SqlDataFactory context, string Type, string Key)

返回: 无