public string Save(SHOPEntity DefineSave)
{
var v = GetVerify(DefineSave);
if (DefineSave.SHOPID.IsEmpty())
{
DefineSave.SHOPID = service.CommonService.NewINC("SHOP");
DefineSave.STATUS = ((int)单元状态.正常).ToString();
DefineSave.RENT_STATUS = ((int)租用状态.空置).ToString();
}
else
{
var shop = new SHOPEntity();
shop = service.XtglService.SelectShop(DefineSave.SHOPID);
if (shop.RENT_STATUS == ((int)租用状态.出租).ToString())
{
if (shop.AREA_RENTABLE != DefineSave.AREA_RENTABLE)
{
throw new LogicException($"出租状态不能修改租赁面积!");
}
if (shop.AREA_USABLE != DefineSave.AREA_USABLE)
{
throw new LogicException($"出租状态不能修改使用面积!");
}
if (shop.AREA_BUILD != DefineSave.AREA_BUILD)
{
throw new LogicException($"出租状态不能修改建筑面积!");
}
}
}
v.IsUnique(a => a.SHOPID);
v.IsUnique(a => a.CODE);
v.Require(a => a.NAME);
v.Require(a => a.BRANCHID);
v.Require(a => a.REGIONID);
v.Require(a => a.FLOORID);
v.Require(a => a.ORGID);
v.Require(a => a.CATEGORYID);
v.Require(a => a.TYPE);
v.Require(a => a.AREA_RENTABLE);
v.Require(a => a.STATUS);
v.Require(a => a.RENT_STATUS);
v.Verify();
return(CommonSave(DefineSave));
}
public object GetOneShop(SHOPEntity Data)
{
string sql = " SELECT A.* FROM SHOP A " +
" WHERE 1=1 ";
if (!Data.SHOPID.IsEmpty())
{
sql += (" and A.SHOPID= " + Data.SHOPID);
}
DataTable dt = DbHelper.ExecuteTable(sql);
return(new
{
dt = dt.ToOneLine()
});
}
public string Check(SHOPEntity DefineSave)
{
DefineSave.STATUS = "2";
var v = GetVerify(DefineSave);
v.IsUnique(a => a.SHOPID);
v.IsUnique(a => a.CODE);
v.Require(a => a.NAME);
v.Require(a => a.BRANCHID);
v.Require(a => a.REGIONID);
v.Require(a => a.FLOORID);
v.Require(a => a.ORGID);
v.Require(a => a.CATEGORYID);
v.Require(a => a.TYPE);
v.Require(a => a.AREA_RENTABLE);
v.Require(a => a.STATUS);
v.Require(a => a.RENT_STATUS);
v.Verify();
return(CommonSave(DefineSave));
}
public string Save(SHOPEntity DefineSave)
{
var v = GetVerify(DefineSave);
if (DefineSave.SHOPID.IsEmpty())
{
DefineSave.SHOPID = service.CommonService.NewINC("SHOP");
}
v.IsUnique(a => a.SHOPID);
v.IsUnique(a => a.CODE);
v.Require(a => a.NAME);
v.Require(a => a.BRANCHID);
v.Require(a => a.FLOORID);
v.Require(a => a.ORGID);
v.Require(a => a.CATEGORYID);
v.Require(a => a.TYPE);
v.Require(a => a.AREA_BUILD);
v.Require(a => a.STATUS);
v.Require(a => a.RENT_STATUS);
v.Verify();
return(CommonSave(DefineSave));
}
public object GetShop(SHOPEntity Data)
{
string sql = " SELECT A.SHOPID,A.CODE,B.CATEGORYID,B.CATEGORYCODE,B.CATEGORYNAME,A.AREA_BUILD,A.AREA_RENTABLE FROM " +
" SHOP A,CATEGORY B " +
" WHERE A.CATEGORYID = B.CATEGORYID ";
if (!Data.CODE.IsEmpty())
{
sql += " AND A.CODE='" + Data.CODE + "'";
}
if (!Data.BRANCHID.IsEmpty())
{
sql += " AND A.BRANCHID=" + Data.BRANCHID + "";
}
DataTable dt = DbHelper.ExecuteTable(sql);
return(new
{
dt = dt.ToOneLine()
});
}
/// <summary>
/// 可返回一行店铺记录或符合条件的所有记录
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public Tuple <dynamic, DataTable> GetShop(SHOPEntity Data)
{
string sql = $@"SELECT A.*,B.CATEGORYCODE,B.CATEGORYNAME,B.CATEGORYIDCASCADER,A.AREA_BUILD AREA,C.ORGIDCASCADER " +
" FROM SHOP A,CATEGORY B,ORG C WHERE A.CATEGORYID = B.CATEGORYID(+) "
+ " and A.ORGID=C.ORGID(+)";
if (!Data.SHOPID.IsEmpty())
{
sql += (" AND A.SHOPID= " + Data.SHOPID);
}
if (!Data.CODE.IsEmpty())
{
sql += (" AND A.CODE= " + Data.CODE);
}
if (!Data.NAME.IsEmpty())
{
sql += (" AND A.NAME like %" + Data.NAME + "%");
}
DataTable shop = DbHelper.ExecuteTable(sql);
return(new Tuple <dynamic, DataTable>(shop.ToOneLine(), shop));
}
public void Delete(SHOPEntity DefineDelete)
{
var v = GetVerify(DefineDelete);
CommenDelete(DefineDelete);
}
public UIResult GetShop(SHOPEntity Data)
{
return(new UIResult(service.DpglService.GetOneShop(Data)));
}
