/// <summary>
/// 表实体转换为Json字符
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public static string ToJsonString(this IModel.BaseTable table)
{
StringBuilder sb = new StringBuilder();
Type type = table.GetType();
{
PropertyInfo[] pis = type.GetProperties();
int i = 0;
foreach (PropertyInfo pi in pis)
{
object obj = pi.GetValue(table, null);
string v = obj == null ? string.Empty : obj.ToString().Replace("'", "\\'");
if (i == 0)
{
sb.Append(string.Format("'{0}':'{1}'", pi.Name, v));
}
else
{
sb.Append(string.Format(",'{0}':'{1}'", pi.Name, v));
}
i++;
}
}
return("{" + sb + "}");
}
public int Update(DataContext ctx, BaseTable baseTable)
{
Common.DataAccess da = new Common.DataAccess();
if (ctx != null)
da.ctx = ctx;
da.TableEntity = baseTable;
return da.Update();
}
public DataTable Select(DataContext ctx, BaseTable baseTable)
{
Common.DataAccess da = new Common.DataAccess();
if (ctx != null)
da.ctx = ctx;
da.TableEntity = baseTable;
return da.Select();
}
public int Update(Common.DataContext ctx, IModel.BaseTable baseTable)
{
int rel = 0;
rel = dal.Update(ctx, baseTable);
return(rel);
}
public DataTable Select(Common.DataContext ctx, IModel.BaseTable baseTable)
{
return(dal.Select(ctx, baseTable));
}