public static GridModel GetField(int fieldId) { GridModel model = new GridModel(); using (var sqlb = DbHelper.CreateSql()) { sqlb.SelectSql = @"SELECT f.*, t.ControlTypeName FROM DevFieldInfo f LEFT JOIN dbo.DevControlType t ON f.ControlTypeId=t.ControlTypeId "; sqlb.AddFilter("f.FieldId = @FieldId", "@FieldId", fieldId); model.Data = sqlb.QueryDataTable() ; model.AutoSetFields(); } return model; }