public object GetBranch(BRANCHEntity Data) { string sql = $@"SELECT A.ID,A.NAME FROM BRANCH A WHERE 1=1"; if (!Data.ID.IsEmpty()) { sql += (" and A.ID= " + Data.ID); } sql += " and STATUS = 1"; DataTable dt = DbHelper.ExecuteTable(sql); return(new { dt = dt }); }
public string Save(BRANCHEntity DefineSave) { var v = GetVerify(DefineSave); if (DefineSave.ID.IsEmpty()) { DefineSave.ID = service.CommonService.NewINC("BRANCH"); } v.IsUnique(a => a.ID); v.Require(a => a.NAME); v.IsUnique(a => a.NAME); v.Require(a => a.ORGID); v.IsUnique(a => a.ORGID); v.Require(a => a.AREA_BUILD); v.Require(a => a.STATUS); v.Verify(); service.XtglService.Org_Update(DefineSave.ORGID, DefineSave.ID.ToInt()); return(CommonSave(DefineSave)); }
public UIResult GetBranch(BRANCHEntity Data) { return(new UIResult(service.DataService.GetBranch(Data))); }
public void Delete(BRANCHEntity DefineDelete) { var v = GetVerify(DefineDelete); CommenDelete(DefineDelete); }