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))); }