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)); }