/// <summary> /// BaseApi(DBHelper dbh, string rS, string cS, string reS, string dtS): 有五个参数的构造函数 /// </summary> /// <param name="dbh">DBHelper对象</param> /// <param name="rS">行分隔符</param> /// <param name="cS">列分隔符</param> /// <param name="reS">结果集分隔符</param> /// <param name="dtS">数据类型, 可以使json, array, html 三种格式 默认是html</param> private void initClass(MySqlDBHelper dbh, string rS, string cS, string reS, string dtS) { if (Native.isNullEmpty(rS)) { rS = "\u0002"; } if (Native.isNullEmpty(cS)) { cS = "\u0001"; } if (Native.isNullEmpty(reS)) { reS = "\u0003"; } if (Native.isNullEmpty(dtS)) { dtS = "html"; } setDBHelper(dbh); setRSplit(rS); setCSplit(cS); setReSplit(reS); setDataType(dtS); MConvert.setKeySplit(','); }
/// <summary> /// BaseApi(DBHelper dbh, string rS, string cS, string reS, string dtS): 有五个参数的构造函数 /// </summary> /// <param name="dbh">DBHelper对象</param> /// <param name="rS">行分隔符</param> /// <param name="cS">列分隔符</param> /// <param name="reS">结果集分隔符</param> /// <param name="dtS">数据类型, 可以使json, array, html 三种格式 默认是html</param> private void initClass(DBHelper dbh, string rS, string cS, string reS, string dtS) { if (Native.isNullEmpty(rS)) { rS = "\u0002"; } if (Native.isNullEmpty(cS)) { cS = "\u0001"; } if (Native.isNullEmpty(reS)) { reS = "\u0003"; } if (Native.isNullEmpty(dtS)) { dtS = "html"; } setDBHelper(dbh); setRSplit(rS); setCSplit(cS); setReSplit(reS); setDataType(dtS); MConvert.setKeySplit(','); DBUtil.setBaseApi(this); COL_FIELDS = new string[, ] { { "index", "col.colorder as idx" }, { "name", "col.name as name" }, { "ifMark", "(case when COLUMNPROPERTY(col.id, col.name, 'IsIdentity')=1 then '√'else '' end) as ifMask" }, { "ifPrimaryKey", @"(case when (SELECT count(*) FROM sysobjects WHERE (name in (SELECT name FROM sysindexes WHERE (id = col.id) AND (indid in (SELECT indid FROM sysindexkeys WHERE (id = col.id) AND (colid in (SELECT colid FROM syscolumns WHERE (id = col.id) AND (name = col.name))))))) AND (xtype = 'PK'))>0 then '√' else '' end) as ifPrimaryKey" }, { "defaultValue", "comments.text as defValue" }, { "type", "types.name as type" }, { "byte", "col.length as byte" }, { "length", "COLUMNPROPERTY(col.id, col.name, 'PRECISION') as length" }, { "decimalSize", "isnull(COLUMNPROPERTY(col.id,col.name,'Scale'),0) as decimalSize" }, { "ifNull", "(case when col.isnullable=1 then '√'else '' end) as ifNull" }, { "comment", "properties.value as comment" } }; }