public static int maxid(string tablename)
{
using (conn con = new conn())
{
int i = con.exeiscalar("select max(id) from " + tablename);
return i;
}
}
public static int getivalue(string tablename, string getziduan, string tiaojian)
{
using (conn con = new conn())
{
int i = con.exeiscalar("select " + getziduan + " from " + tablename + " where " + tiaojian);
return i;
}
}
public static int getcount(string tablename)
{
using (conn con = new conn())
{
int i = con.exeiscalar("select count(classid) from " + tablename);
return i;
}
}
public static int getcount(string tablename,string colName, string tiaojian)
{
using (conn con = new conn())
{
int i = con.exeiscalar("select count(" + colName + ") from " + tablename + " where " + tiaojian);
return i;
}
}
//执行sql语句
public static int exeisql(string sql)
{
int i = 0;
using (conn con = new conn())
{
i = con.exeiscalar(sql);
return i;
}
}