/// <summary>
/// 区域列表
/// </summary>
/// <returns></returns>
public IEnumerable <AreaEntity> GetList()
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_Area where 1=1 and Layer<>4 and EnabledMark<>0");
sql.Append(" order by CreateDate desc");
var list = Base_Area.Query(sql);
return(EntityConvertTools.CopyToList <Base_Area, AreaEntity>(list.ToList()));
}
/// <summary>
/// 区域列表
/// </summary>
/// <param name="parentId">节点Id</param>
/// <param name="keyword">关键字查询</param>
/// <returns></returns>
public IEnumerable <AreaEntity> GetList(string parentId, string keyword)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_Area where 1=1");
if (!string.IsNullOrEmpty(parentId))
{
sql.Append(" and ParentId=@0", parentId);
}
if (!string.IsNullOrEmpty(keyword))
{
sql.Append(" and (charindex(@0,AreaCode)>0 or (charindex(@0,AreaName)>0", keyword);
}
var list = Base_Area.Query(sql);
return(EntityConvertTools.CopyToList <Base_Area, AreaEntity>(list.ToList()));
}
/// <summary>
/// 保存区域表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="{">区域实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, AreaEntity areaEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
areaEntity.Modify(keyValue);
Base_Area area = Base_Area.SingleOrDefault("where AreaId=@0", keyValue);
area = EntityConvertTools.CopyToModel <AreaEntity, Base_Area>(areaEntity, area);
area.AreaId = keyValue;
area.Update();
}
else
{
areaEntity.Create();
Base_Area area = EntityConvertTools.CopyToModel <AreaEntity, Base_Area>(areaEntity, null);
area.Insert();
}
}
public void DBFirst方式()
{
Base_Area _Base_Area = new Base_Area();
_Base_Area.Code = "006";
HuNiEntitiesDb.Base_Area.Add(_Base_Area);
HuNiEntitiesDb.SaveChanges();
var tempArea = from u in HuNiEntitiesDb.Base_Area select u;
foreach (var item in tempArea)
{
Console.WriteLine(item);
}
//测试更新
var area1 = tempArea.FirstOrDefault <Base_Area>();
area1.Code = "122";
HuNiEntitiesDb.SaveChanges();
}
/// <summary>
/// 删除区域
/// </summary>
/// <param name="keyValue">主键</param>
public void RemoveForm(string keyValue)
{
Base_Area.Delete("where AreaId=@0", keyValue);
}
/// <summary>
/// 区域实体
/// </summary>
/// <param name="keyValue">主键值</param>
/// <returns></returns>
public AreaEntity GetEntity(string keyValue)
{
var area = Base_Area.SingleOrDefault("where AreaId=@0", keyValue);
return(EntityConvertTools.CopyToModel <Base_Area, AreaEntity>(area, null));
}
