public static void test()
{
var express = @"{
""$acttype"": ""CreateTable"",
""$table"": ""XXXS0301"",
""xm"": {
""$datatype"": ""nvarchar"",
""$precision"": ""20"",
""$scale"": """",
""$default"": """",
""$isnull"": true
},
""bh"":{
""$datatype"": ""nvarchar"",
""$precision"": ""20"",
""$scale"": """",
""$default"": """",
""$isnull"": false
},
""$pk"": [ ""bh"" ]
}
";
var s1 = DBExpress.Create <SqlServerExpress>(express).ToExpress();
var s = from t in new DaoLinqTable("e")
select new
{
t.name,
t.age
};
}
/// <summary>
/// 标准化DB执行操作
/// </summary>
/// <param name="p"></param>
/// <param name="express"></param>
/// <returns></returns>
public virtual UnitDataCollection Excute(UnitParameter p, DBExpress express)
{
UnitDataCollection rtn = new UnitDataCollection();
if (express != null)
{
p.SetValue("__json__", express);
if (p.Dao is ADBAccess)
{
if (express.CurrentAct == DBExpress.ActType.Query)
{
rtn = Query <JsonExpressUnit>(p, "");
}
else if (express.CurrentAct == DBExpress.ActType.QueryByPage)
{
rtn = QueryByPage <JsonExpressUnit>(p, "");
}
else
{
NonQuery <JsonExpressUnit>(p, "");
}
}
else if (p.Dao is MongoAccess26)
{
var result = ((MongoAccess26)p.Dao).Excute(express);
if (express.CurrentAct == DBExpress.ActType.Query)
{
rtn.MongoListData = (List <FrameDLRObject>)result;
}
}
}
return(rtn);
}
public override UnitDataCollection Excute(UnitParameter p, DBExpress express, bool islog = false)
{
if (express.CurrentAct == DBExpress.ActType.QueryByPage)
{
InitUPPage(p);
}
return(base.Excute(p, express));
}
/// <summary>
/// 通过json对象执行标准化DB操作
/// </summary>
/// <param name="p"></param>
/// <param name="json"></param>
/// <returns></returns>
public virtual UnitDataCollection Excute(UnitParameter p, FrameDLRObject json)
{
DBExpress express = null;
if (p.Dao is OracleAccess)
{
express = DBExpress.Create <OracleExpress>(json);
}
else if (p.Dao is SQLServerAccess ||
p.Dao is SQLServerAccess2000)
{
express = DBExpress.Create <SqlServerExpress>(json);
}
else if (p.Dao is MySQLAccess)
{
express = DBExpress.Create <MySQLExpress>(json);
}
else if (p.Dao is MongoAccess26)
{
express = DBExpress.Create <MongoExpress>(json);
}
return(Excute(p, express));
}
/// <summary>
/// 标准化DB执行操作
/// </summary>
/// <param name="p"></param>
/// <param name="express"></param>
/// <param name="islog">用于设定是否记录解析结果，以便进行debug操作</param>
/// <returns></returns>
public virtual UnitDataCollection Excute(UnitParameter p, DBExpress express, bool islog = false)
{
express.IsLog = islog;
return(DBUnitProxy.Excute(p, express));
}
