public UIResult GetFloor(FLOOREntity Data)
{
var res = service.DpglService.GetFloor(Data);
return(new UIResult(
new
{
floorelement = res.Item1
}
));
}
public string Save(FLOOREntity DefineSave)
{
var v = GetVerify(DefineSave);
if (DefineSave.ID.IsEmpty())
{
DefineSave.ID = service.CommonService.NewINC("FLOOR");
}
v.IsUnique(a => a.ID);
v.Require(a => a.CODE);
v.Require(a => a.NAME);
v.Require(a => a.BRANCHID);
v.Require(a => a.REGIONID);
v.Require(a => a.ORGID);
v.Require(a => a.AREA_BUILD);
v.Require(a => a.STATUS);
v.Verify();
return(CommonSave(DefineSave));
}
public object GetFloor(FLOOREntity Data)
{
string sql = $@"SELECT A.ID,A.CODE,A.NAME FROM FLOOR A WHERE 1=1";
if (!Data.BRANCHID.IsEmpty())
{
sql += (" and A.BRANCHID= " + Data.BRANCHID);
}
if (!Data.REGIONID.IsEmpty())
{
sql += (" and A.REGIONID= " + Data.REGIONID);
}
sql += " and STATUS = 1 ORDER BY A.CODE";
DataTable dt = DbHelper.ExecuteTable(sql);
return(new
{
dt = dt
});
}
/// <summary>
/// 可返回一行楼层记录或符合条件的所有记录
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public Tuple <dynamic, DataTable> GetFloor(FLOOREntity Data)
{
string sql = $@"select A.*,B.ORGIDCASCADER from FLOOR A,ORG B where A.ORGID=B.ORGID(+) ";
if (!Data.ID.IsEmpty())
{
sql += (" AND A.ID= " + Data.ID);
}
if (!Data.CODE.IsEmpty())
{
sql += (" AND A.CODE= " + Data.CODE);
}
if (!Data.NAME.IsEmpty())
{
sql += (" AND A.NAME like %" + Data.NAME + "%");
}
DataTable floor = DbHelper.ExecuteTable(sql);
return(new Tuple <dynamic, DataTable>(floor.ToOneLine(), floor));
}
public UIResult GetFloor(FLOOREntity Data)
{
return(new UIResult(service.DataService.GetFloor(Data)));
}
public void Delete(FLOOREntity DefineDelete)
{
var v = GetVerify(DefineDelete);
CommenDelete(DefineDelete);
}