/// <summary>
/// 修改问卷分类
/// </summary>
/// <param name="model">问卷分类</param>
public bool EditPaperSort(Survey_ExampaperCategory model)
{
using (var conn = OpenConnection())
{
const string sqlwhere =
@"update Survey_ExampaperCategory set CategoryName=@CategoryName where CategoryId=@CategoryId";
var param = new
{
model.CategoryName,
model.CategoryId
};
var result = conn.Execute(sqlwhere, param);
return(result > 0);
}
}
/// <summary>
/// 增加问卷分类
/// </summary>
/// <param name="model">问卷分类实体</param>
public bool AddPaperSort(Survey_ExampaperCategory model)
{
using (var conn = OpenConnection())
{
const string sqlwhere =
@"insert into Survey_ExampaperCategory (CategoryName,ParentId,IsDelete) values (@CategoryName,@ParentId,@IsDelete) SELECT @@Identity as Id";
var param = new
{
model.CategoryName,
model.ParentId,
model.IsDelete
};
var id = conn.Query <decimal>(sqlwhere, param).FirstOrDefault();
model.CategoryId = decimal.ToInt32(id);
return(model.CategoryId > 0);
}
}
/// <summary>
/// 修改问卷分类
/// </summary>
/// <param name="model">问卷分类</param>
public bool EditPaperSort(Survey_ExampaperCategory model)
{
return(Sdb.EditPaperSort(model));
}
