/// <summary>
/// 增加
/// </summary>
/// <param name="model">实体</param>
public void AddGroup(Sys_LeaderConfig model)
{
using (IDbConnection conn = OpenConnection())
{
const string sqlwhere = @"INSERT INTO Sys_LeaderConfig(GroupName,UserId,Memo,CreateTime,LastUpdateTime,IsDelete) VALUES (@GroupName,@UserId,@Memo,@CreateTime,@LastUpdateTime,@IsDelete)SELECT @@IDENTITY AS ID";
var param = new
{
model.GroupName,
model.UserId,
model.Memo,
model.CreateTime,
model.LastUpdateTime,
model.IsDelete
};
decimal id = conn.Query <decimal>(sqlwhere, param).FirstOrDefault();
model.Id = decimal.ToInt32(id);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">实体</param>
/// <returns>执行结果</returns>
public bool UpdateGroup(Sys_LeaderConfig model)
{
using (IDbConnection conn = OpenConnection())
{
const string sqlwhere = @"Update Sys_LeaderConfig SET GroupName = @GroupName,UserId = @UserId,Memo=@Memo,CreateTime = @CreateTime,LastUpdateTime=@LastUpdateTime,IsDelete = @IsDelete WHERE id=@id";
var param = new
{
model.GroupName,
model.UserId,
model.Memo,
model.CreateTime,
model.LastUpdateTime,
model.IsDelete,
model.Id
};
int result = conn.Execute(sqlwhere, param);
return(result > 0);
}
}
/// <summary>
/// 修改群组
/// </summary>
/// <returns></returns>
public bool UpdateByID(Sys_LeaderConfig sort)
{
return(groupDB.UpdateGroup(sort));
}
/// <summary>
/// 添加新的群组
/// </summary>
/// <param name="sort"></param>
/// <returns></returns>
public int Insert(Sys_LeaderConfig sort)
{
groupDB.AddGroup(sort);
return(sort.Id);
}
