/// <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)", "", ""));
}
