Пример #1
0
 public static DataTable QryTable(DataRow r, string type)
 {
     return(ExecuteTable(DataUtil.BuildSelectSQL(r), type));
 }
Пример #2
0
 public static DataRow QryRow(DataRow r, string type)
 {
     return(ExecuteRow(DataUtil.BuildSelectSQL(r), type));
 }
Пример #3
0
 /// <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));
 }
Пример #4
0
 public static void Delete(DataTable t, string type)
 {
     ExecuteTrans(DataUtil.BuildDeleteSQL(t), type);
 }
Пример #5
0
 public static int Delete(DataRow r, string type)
 {
     return(ExecuteNone(DataUtil.BuildDeleteSQL(r), type));
 }
Пример #6
0
 public static void Insert(DataTable t, string type)
 {
     ExecuteTrans(DataUtil.BuildInsertSQL(t), type);
 }
Пример #7
0
 public static int Insert(DataRow r, string type)
 {
     return(ExecuteNone(DataUtil.BuildInsertSQL(r), type));
 }