110,539
社区成员
发帖
与我相关
我的任务
分享
public int SaveUsers(Users users)
{
using (IDbConnection conn = db.CreateConnection())
{
conn.Open();
IDbTransaction trans = conn.BeginTransaction();
string sql = string.Format("insert into [Users](username,Password,Tel,Address,level,alipay,reg_leave) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}');select @@identity", users.UserName, users.PassWord, users.Tel, users.Address, "1", users.Alipay, users.RegLeave);
return Convert.ToInt32(db.ExecuteScalar(CommandType.Text, sql));
}
}
select Scope_Identity