/// <summary> /// user_name -> userName /// userName -> userName /// </summary> /// <param name="c"></param> /// <returns></returns> internal static string GetFieldName(DDLColumn c) { DDLConfig ddlconfig = c.DDLTable.DDLConfig; if (ddlconfig.UnifyName) return c.Name; string columnName = c.NameSql; string[] parts = columnName.Split(ddlconfig.DBColSeparator[0]); string result = ""; for (int i = 0; i < parts.Length; i++) { string partStr = parts[i]; if (string.IsNullOrEmpty(partStr)) { continue; } if (i == 0) { result += partStr; } else { result += (partStr.Substring(0, 1).ToUpper() + (partStr.Length == 1 ? "" : partStr.Substring(1))); } } return result; }
private void D() { DDLTable newtable; DDLColumn column; ddlConfig.Tables.Add(newtable = new DDLTable("wintop_cbs", "cbs_cbs_city", "查博士城市")); newtable.Columns.Add(new DDLColumn("id", "id", "bigint", "是", "")); newtable.Columns.Add(new DDLColumn("城市名称", "city", "String")); newtable.Columns.Add(new DDLColumn("城市编号", "cityId", "int")); newtable.Columns.Add(new DDLColumn("顺序号", "cbs_id", "int")); newtable.Columns.Add(new DDLColumn("省份名称", "province", "String")); ddlConfig.Tables.Add(newtable = new DDLTable("wintop_cbs", "cbs_insurance_report", "查博士交通费版")); newtable.Columns.Add(new DDLColumn("id", "id", "bigint", "是", "")); newtable.Columns.Add(new DDLColumn("姓名", "name", "String")); newtable.Columns.Add(new DDLColumn("手机号", "phone", "String")); newtable.Columns.Add(new DDLColumn("城市 ID(通过接口获取)", "cityid", "String")); newtable.Columns.Add(new DDLColumn("检测地址", "address", "String")); newtable.Columns.Add(new DDLColumn("回调地址", "callbackurl", "String")); newtable.Columns.Add(new DDLColumn("产品SKU", "skuno", "String")); newtable.Columns.Add(new DDLColumn("车辆 vin 码", "vin", "String")); newtable.Columns.Add(new DDLColumn("车牌号", "carno", "String")); newtable.Columns.Add(new DDLColumn("期望检测时间(“2019-08-17”)", "expecttime", "String")); newtable.Columns.Add(new DDLColumn("经度", "longitude", "String")); newtable.Columns.Add(new DDLColumn("纬度", "latitude", "String")); newtable.Columns.Add(new DDLColumn("交通费金额", "travelcost", "金额")); newtable.Columns.Add(new DDLColumn("第三方订单号", "thirdpartorderid", "String")); newtable.Columns.Add(column = new DDLColumn("orderId", "orderId", "varchar(100)", "", "")); column.UniqueKeySign = "Y"; column.UniqueForDB = false; newtable.Columns.Add(new DDLColumn("购买调用Id", "buy_invoke_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("wap端报告url", "wap_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("PC端报告url", "pc_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("报告url", "insurance_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("抖音报告url", "tiktok_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("json报告", "jsorn_report", "text", "", "")); newtable.Columns.Add(new DDLColumn("json报告_invoke_id", "jsorn_report_invoke_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("创建人", "cre_person", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("创建人姓名", "cre_person_name", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("创建日期", "cre_time", "datetime", "", "")); newtable.Columns.Add(new DDLColumn("修改日期", "modify_time", "datetime", "", "")); newtable.Columns.Add(new DDLColumn("店铺", "service_network_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("店铺姓名", "service_network_name", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态", "query_status", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态code", "query_status_code", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态message", "query_status_msg", "varchar(200)", "", "")); ddlConfig.Tables.Add(newtable = new DDLTable("wintop_cbs", "cbs_skuno", "查博士skuNO")); newtable.Columns.Add(new DDLColumn("id", "id", "bigint", "是", "")); newtable.Columns.Add(new DDLColumn("code", "code", "String", 20)); newtable.Columns.Add(new DDLColumn("skuno", "skuno", "string", 200)); newtable.Columns.Add(new DDLColumn("说明", "name", "string")); newtable.Columns.Add(new DDLColumn("启用标志,1:启用 0:禁用", "enable_flag", "int", 3)); }
internal static FieldBase Create(DDLColumn c) { FieldBase fieldBase = new FieldBase(); fieldBase.Name = CodeUtil.GetFieldName(c); fieldBase.Desc = c.Desc; fieldBase.Remark = c.Remark; fieldBase.DDLColumn = c; fieldBase.FieldType = DDLUtil.AnalysisFieldType(c); fieldBase.JDBCType = DBUtil.AnalysisJDBCType(fieldBase.FieldType); fieldBase.IsKeyField = c.IsKeyColumn(); fieldBase.IsPrimaryKeyColumn = c.IsPrimaryKeyColumn(); fieldBase.IsUniqueKeyColumn = c.IsUniqueKeyColumn(); fieldBase.IsParentKey = c.IsParentKey; return(fieldBase); }
public void Init() { ddlConfig = new DDLConfig(); ddlConfig.MyDBType = DDLConfig.DBType.MySql; DDLTable newtable; DDLColumn column; ddlConfig.Tables.Add(newtable = new DDLTable("base_info", "wx_user", "微信用户")); newtable.Columns.Add(new DDLColumn("id", "id", "varchar(64)", "Y", "")); newtable.Columns.Add(column = new DDLColumn("unionid", "unionid", "varchar(255)", "", "")); column.UniqueKeySign = "Y"; newtable.Columns.Add(new DDLColumn("用户昵称", "nickName", "varchar(255)", "", "")); newtable.Columns.Add(new DDLColumn("用户头像图片的 URL", "avatarUrl", "varchar(500)", "", "")); }
public void B() { DDLTable newtable; DDLColumn column; ddlConfig.Tables.Add(newtable = new DDLTable("wintop_cbs", "cbs_invoke_log", "调用日志")); newtable.Columns.Add(new DDLColumn("id", "id", "bigint", "是", "")); newtable.Columns.Add(new DDLColumn("url", "url", "varchar(1000)", "", "")); newtable.Columns.Add(new DDLColumn("方向:in、out", "direction", "varchar(10)", "", "")); newtable.Columns.Add(new DDLColumn("日志类型", "data_type", "varchar(50)", "", "")); newtable.Columns.Add(new DDLColumn("data1", "data1", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("data2", "data2", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("请求信息", "request_data", "text", "", "")); newtable.Columns.Add(new DDLColumn("响应信息", "response_data", "text", "", "")); newtable.Columns.Add(new DDLColumn("错误信息", "err_msg", "text", "", "")); newtable.Columns.Add(new DDLColumn("请求时间", "request_time", "datetime", "", "")); newtable.Columns.Add(new DDLColumn("响应时间", "response_time", "datetime", "", "")); ddlConfig.Tables.Add(newtable = new DDLTable("wintop_cbs", "cbs_base_report", "基础版报告")); newtable.Columns.Add(new DDLColumn("id", "id", "bigint", "是", "")); newtable.Columns.Add(new DDLColumn("车辆识别码", "vin", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("车牌号", "licenseplate", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("中介ID", "middleagentid", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("发动机号", "enginno", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("行驶证照片链接", "drivingpic", "varchar(100)", "", "")); newtable.Columns.Add(column = new DDLColumn("orderId", "orderId", "varchar(100)", "", "")); column.UniqueKeySign = "Y"; newtable.Columns.Add(new DDLColumn("购买调用Id", "buy_invoke_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("wap端报告url", "wap_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("PC端报告url", "pc_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("PC端New报告url", "pc_new_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("json报告", "jsorn_report", "text", "", "")); newtable.Columns.Add(new DDLColumn("json报告_invoke_id", "jsorn_report_invoke_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("创建人", "cre_person", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("创建人姓名", "cre_person_name", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("创建日期", "cre_time", "datetime", "", "")); newtable.Columns.Add(new DDLColumn("修改日期", "modify_time", "datetime", "", "")); newtable.Columns.Add(new DDLColumn("店铺", "service_network_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("店铺姓名", "service_network_name", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态", "query_status", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态code", "query_status_code", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态message", "query_status_msg", "varchar(200)", "", "")); ddlConfig.Tables.Add(newtable = new DDLTable("wintop_cbs", "cbs_new_report", "综合版报告")); newtable.Columns.Add(new DDLColumn("id", "id", "bigint", "是", "")); newtable.Columns.Add(new DDLColumn("车辆识别码", "vin", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("车牌号", "licenseplate", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("发动机号", "Enginno", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("行驶证照片链接", "drivingpic", "varchar(100)", "", "")); newtable.Columns.Add(column = new DDLColumn("orderId", "orderId", "varchar(100)", "", "")); column.UniqueKeySign = "Y"; newtable.Columns.Add(new DDLColumn("购买调用Id", "buy_invoke_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("wap端报告url", "wap_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("PC端报告url", "pc_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("PC端New报告url", "pc_new_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("json报告", "jsorn_report", "text", "", "")); newtable.Columns.Add(new DDLColumn("json报告_invoke_id", "jsorn_report_invoke_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("创建人", "cre_person", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("创建人姓名", "cre_person_name", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("创建日期", "cre_time", "datetime", "", "")); newtable.Columns.Add(new DDLColumn("修改日期", "modify_time", "datetime", "", "")); newtable.Columns.Add(new DDLColumn("店铺", "service_network_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("店铺姓名", "service_network_name", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态", "query_status", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态code", "query_status_code", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态message", "query_status_msg", "varchar(200)", "", "")); ddlConfig.Tables.Add(newtable = new DDLTable("wintop_cbs", "cbs_collision_report", "碰撞版报告")); newtable.Columns.Add(new DDLColumn("id", "id", "bigint", "是", "")); newtable.Columns.Add(new DDLColumn("车辆识别码", "vin", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("车牌号", "licenseplate", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("发动机号", "Enginno", "varchar(100)", "", "")); newtable.Columns.Add(new DDLColumn("行驶证照片链接", "drivingpic", "varchar(100)", "", "")); newtable.Columns.Add(column = new DDLColumn("orderId", "orderId", "varchar(100)", "", "")); column.UniqueKeySign = "Y"; newtable.Columns.Add(new DDLColumn("购买调用Id", "buy_invoke_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("wap端报告url", "wap_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("PC端报告url", "pc_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("PC端New报告url", "pc_new_report_url", "varchar(500)", "", "")); newtable.Columns.Add(new DDLColumn("json报告", "jsorn_report", "text", "", "")); newtable.Columns.Add(new DDLColumn("json报告_invoke_id", "jsorn_report_invoke_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("创建人", "cre_person", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("创建人姓名", "cre_person_name", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("创建日期", "cre_time", "datetime", "", "")); newtable.Columns.Add(new DDLColumn("修改日期", "modify_time", "datetime", "", "")); newtable.Columns.Add(new DDLColumn("店铺", "service_network_id", "bigint", "", "")); newtable.Columns.Add(new DDLColumn("店铺姓名", "service_network_name", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态", "query_status", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态code", "query_status_code", "varchar(20)", "", "")); newtable.Columns.Add(new DDLColumn("查询状态message", "query_status_msg", "varchar(200)", "", "")); }