public UIResult GetRegion(REGIONEntity Data)
{
var res = service.DpglService.GetRegion(Data);
return(new UIResult(
new
{
regionelement = res.Item1
}
));
}
public object GetRegion(REGIONEntity Data)
{
string sql = $@"SELECT A.REGIONID,A.CODE,A.NAME FROM REGION A WHERE 1=1";
if (!Data.BRANCHID.IsEmpty())
{
sql += (" and A.BRANCHID= " + Data.BRANCHID);
}
sql += " AND A.STATUS = 1 ORDER BY A.CODE";
DataTable dt = DbHelper.ExecuteTable(sql);
return(new
{
dt = dt
});
}
public string Save(REGIONEntity DefineSave)
{
var v = GetVerify(DefineSave);
if (DefineSave.REGIONID.IsEmpty())
{
DefineSave.REGIONID = service.CommonService.NewINC("REGION");
}
v.IsUnique(a => a.REGIONID);
v.IsUnique(a => a.CODE);
v.Require(a => a.NAME);
v.Require(a => a.BRANCHID);
v.Require(a => a.ORGID);
v.Require(a => a.AREA_BUILD);
v.Require(a => a.STATUS);
v.Verify();
return(CommonSave(DefineSave));
}
public Tuple <dynamic, DataTable> GetRegion(REGIONEntity Data)
{
string sql = "select A.*,B.ORGIDCASCADER from REGION A,ORG B where A.ORGID=B.ORGID(+)";
if (!Data.BRANCHID.IsEmpty())
{
sql += (" AND A.BRANCHID = " + Data.BRANCHID);
}
if (!Data.REGIONID.IsEmpty())
{
sql += (" AND A.REGIONID= " + Data.REGIONID);
}
if (!Data.CODE.IsEmpty())
{
sql += (" AND A.CODE= " + Data.CODE);
}
if (!Data.NAME.IsEmpty())
{
sql += (" AND A.NAME like %" + Data.NAME + "%");
}
DataTable region = DbHelper.ExecuteTable(sql);
return(new Tuple <dynamic, DataTable>(region.ToOneLine(), region));
}
public void Delete(REGIONEntity DefineDelete)
{
var v = GetVerify(DefineDelete);
CommenDelete(DefineDelete);
}
public UIResult GetRegion(REGIONEntity Data)
{
return(new UIResult(service.DataService.GetRegion(Data)));
}
