public static DataTable QryTable(DataRow r, string type)
{
return(ExecuteTable(DataUtil.BuildSelectSQL(r), type));
}
public static DataRow QryRow(DataRow r, string type)
{
return(ExecuteRow(DataUtil.BuildSelectSQL(r), type));
}
/// <summary>
/// 获取某列等值条件的数据集的第一行数据
/// </summary>
public static DataRow GetRowByField(string tbName, string fieldName, object v, string type)
{
return(ExecuteRow(string.Format("select * from {0} where {1}={2}", tbName, fieldName, DataUtil.SqlItem(v)), type));
}
public static void Delete(DataTable t, string type)
{
ExecuteTrans(DataUtil.BuildDeleteSQL(t), type);
}
public static int Delete(DataRow r, string type)
{
return(ExecuteNone(DataUtil.BuildDeleteSQL(r), type));
}
public static void Insert(DataTable t, string type)
{
ExecuteTrans(DataUtil.BuildInsertSQL(t), type);
}
public static int Insert(DataRow r, string type)
{
return(ExecuteNone(DataUtil.BuildInsertSQL(r), type));
}