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