public int UpdateAll(adminsTable entity, string updateFields = null) { if (updateFields == null) { updateFields = "[username]=@username,[pwd]=@pwd,[sex]=@sex"; } else { updateFields = StringHelper.SqlUpdateFields(updateFields); } string sql = "UPDATE [admins] SET " + updateFields; return(SqlDapperHelper.Execute(sql, entity)); }
public int UpdateFieldsByWhere(adminsTable entity, string whereFields, string updateFields = null) { if (updateFields == null) { updateFields = "[username]=@username,[pwd]=@pwd,[sex]=@sex"; } else { updateFields = StringHelper.SqlUpdateFields(updateFields); } string where = "WHERE " + StringHelper.SqlWhereFields(whereFields); string sql = string.Format("UPDATE [admins] SET {0} " + where, updateFields); return(SqlDapperHelper.Execute(sql, entity)); }
public int InsertIdentity(adminsTable entity) { string sql = "SET IDENTITY_INSERT [admins] ON;INSERT INTO [admins] ([id],[username],[pwd],[sex]) VALUES (@id,@username,@pwd,@sex);SET IDENTITY_INSERT [admins] OFF"; return(SqlDapperHelper.Execute(sql, entity)); }
public int Insert(adminsTable entity) { string sql = "INSERT INTO [admins] ([username],[pwd],[sex]) VALUES (@username,@pwd,@sex);SELECT @@IDENTITY"; return(SqlDapperHelper.ExecuteScalar <int>(sql, entity)); }