/// <summary> /// [base] /// </summary> public static DbDataReader SelReturnReader(string tbname, string where, SqlParameter[] sp = null) { SqlModel model = new SqlModel(); model.size = 1; model.cmd = SqlCmd.Select; model.tbName = tbname; model.where = where; model.AddSpToList(sp); return(DB.ExecuteReader(model)); }
/// <summary> /// 用于一些无模型的数据写入(ZL_GroupModel) /// </summary> public static int Insert(string tbname, string fields, string values, SqlParameter[] sp = null) { SqlModel model = new SqlModel() { cmd = SqlCmd.Insert, tbName = tbname }; model.fields = fields; model.values = values; model.AddSpToList(sp); return(DB.InsertID(model)); }
public static int Insert(M_Base data, SqlBase db) { SqlModel model = new SqlModel() { cmd = SqlCmd.Insert, tbName = data.TbName, pk = data.PK }; model.AddSpToList(data.GetParameters()); model.fields = DB.GetFields(data); model.values = DB.GetParams(data); PreSPList(model); return(db.InsertID(model)); }
public static bool UpdateByID(M_Base data, int id) { SqlModel model = new SqlModel() { cmd = SqlCmd.Update, tbName = data.TbName, pk = data.PK }; model.AddSpToList(data.GetParameters()); model.sql = "UPDATE " + data.TbName + " SET " + DB.GetFieldAndParam(data) + " WHERE " + data.PK + "=" + id; PreSPList(model); DB.ExecuteNonQuery(model); return(true); }