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